BR123 | BR157 | BR252 | BR52.1 | BRIP.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
PML-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||
PML-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||
PML-CNSL-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||
PML-PT-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. |
|
||
PML-ACCT-CATEGORY Element: Acct Category | Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru |
|
||
PML-BILLING-METHOD Element: Billing Method | Numeric 1 1 = Time and Material 2 = Cost Plus 3 = Units of Production 4 = Milestone 5 = Pass Thru 9 = User Defined |
|
||
PML-TRAN-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||
PML-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
PML-RESOURCE-TYPE Element: Resource Type | Alpha 1 The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset P = AC Person Q = Equipment V = Vendor E = Employee A = Asset |
|
||
PML-RESOURCE-COMP Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
||
PML-RESOURCE-CODE Element: Resource Code | Alpha 10 The code identifying the resource assigned to the activity or activity group. |
|
||
PML-RESOURCE-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
PML-BILL-RATE Element: Bill Rate | Signed 13.4 The billing rate that is set up for a resource for a specific activity. |
|
||
PML-MARK-UP-PCT Element: Mark Up Pct | Signed 5.2 This field indicates the percentage of markup for billing. If an account category is billable, a markup percentage can be established. A rate scheudled is for labor transactions only. Markup percentages will increase teh cost amount by the percentage entered. |
|
||
PML-UNITS-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||
PML-UNIT-MEASURE Element: Unit Measure | Alpha 12 |
|
||
PML-MILESTONE Element: Milestone | Alpha 3 |
|
||
PML-PERC-COMPLETE Element: Perc Complete | Signed 7.3 |
|
||
PML-TAX-EXEMPT-CD Element: Tax Exempt Cd | Alpha 1 Code indicating the taxing status. E - Exempt, T - Taxable. E = Exempt T = Taxable |
|
||
PML-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||
PML-INVC-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-POST-COMPANY Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
||
PML-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
||
PML-ACCOUNT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||
PML-SUB-ACCT Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||
PML-ATN-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||
PML-MATRIX-CAT-1 Element: Matrix Cat | Alpha 12 Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis. |
|
||
PML-MX-VALUE-1 Element: Mx Value | Alpha 32 The attribute value. |
|
||
PML-MATRIX-CAT-2 Element: Matrix Cat | Alpha 12 Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis. |
|
||
PML-MX-VALUE-2 Element: Mx Value | Alpha 32 The attribute value. |
|
||
PML-MATRIX-CAT-3 Element: Matrix Cat | Alpha 12 Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis. |
|
||
PML-MX-VALUE-3 Element: Mx Value | Alpha 32 The attribute value. |
|
||
PML-EXCEED-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-EXCEED-UNIT Element: Intl Amt | Signed 18.2 |
|
||
PML-BILL-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. |
|
||
PML-CONTRACT Element: Contract | Alpha 15 Activity Management contract. |
|
||
PML-RETENTION-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-LEVEL Element: Level | Numeric 1 1 = ACBILLX 2 = Resource ACBILLX 3 = ACBILL 4 = Resource ACBILL 5 = Contract ACBILLX 6 = Resource Contract ACBILLX 7 = Contract ACBILL 8 = Resource Contract ACBILL 9 = ACCNTRACT |
|
||
PML-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code, which indicates the cause for credit memos. |
|
||
PML-REVENUE-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-ADJ-LEVEL Element: Adj Level | Alpha 1 I = Invoice Level D = Invoice Detail Level T = Transaction Detail Level P = Posting Activity Level A = Posting Activity Acct Cat Lvl |
|
||
PML-LINE-NBR-MAP Element: Line Nbr Map | Numeric 6 |
|
||
PML-ADJUST-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-LINE-TYPE Element: Line Type | Alpha 1 This field contains the type of inventory on this line. A = Transaction B = Milestone C = Tax F = Fee G = Retention on Fee H = Overage on Fee I = Billed Retention on Fee J = Billed Overage on Fee K = Overage L = Billed Overage M = Retention N = Billed Retention O = Retainer P = Billed Retainer |
|
||
PML-TAXABLE-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-SERVICE-LOC Element: Service Loc | Numeric 4 A user defined code identifying a customer's service location. |
|
||
PML-BACKED-OUT-FL Element: Backed Out Fl | Alpha 1 Y = Yes N = No |
|
||
PML-FEE-CD Element: Fee Cd | Alpha 5 The fee code name will be a user defined identifier of the code that will be used to calculate fee. |
|
||
PML-RETAIN-CODE Element: Retain Code | Alpha 3 |
|
||
PML-RETAIN-ID Element: Retain Id | Numeric 6 |
|
||
PML-RETAINER-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-SUM-ACCT-CAT Element: Sum Acct Cat | Alpha 5 The name of the summary account category. |
|
||
PML-ADJUST-TYPE Element: Adjust Type | Alpha 1 A = Write Up or Down B = Hold C = Bill in Advance D = Transfer |
|
||
PML-ORIG-INVC-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-TRANSFER-AMT Element: Intl Amt | Signed 18.2 |
|
||
PML-TRANSFER-UNITS Element: Intl Amt | Signed 18.2 |
|
||
PML-CTR-CAT-GRP Element: Ctr Cat Grp | Alpha 5 |
|
||
PML-XREF-HIH-OBJID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||
PML-XREF-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||
PML-GLT-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||
PML-MAINT-SCHEDULE Element: Maint Schedule | Alpha 15 |
|
||
PML-MSC-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||
PML-SUITE Element: Prod Suite | Alpha 6 |
|
||
PML-TAX-ACCT-CAT Element: Acct Category | Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru |
|
||
PML-DELIV-METHOD Element: Deliv Method | Alpha 1 S = Shipped H = Hosted at E = Electronic L = Loaded 1 = Method 1 2 = Method 2 3 = Method 3 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PMLSET1 |
OBJ-ID LINE-NBR |
|
| ||||||||||||
PMLSET2 |
GLT-OBJ-ID ATN-OBJ-ID OBJ-ID LINE-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Accntract | ACCNTRACT |
Not Required
| ||||||
Acpmhstcsl | ACPMHSTCSL |
Required
| ||||||
Acpmhsthdr | ACPMHSTHDR |
Required
| ||||||
Acreasoncd | ACREASONCD |
Not Required
| ||||||
Actrans | ACTRANS |
Not Required
| ||||||
Gltrans | GLTRANS |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Acpmhsttax | ACPMHSTTAX |
|
All trademarks and registered trademarks are the property of their
respective owners.