ACPMHSTDTL

UPDATED BY
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.
BRIP.1
PML-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
BRIP.1
PML-CNSL-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
BRIP.1
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.
BRIP.1
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
BRIP.1
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
BRIP.1
PML-TRAN-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BRIP.1
PML-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
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
BRIP.1
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.
BRIP.1
PML-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group.
BRIP.1
PML-RESOURCE-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
PML-BILL-RATE
Element: Bill Rate
Signed 13.4
The billing rate that is set up for a resource for a specific activity.
BRIP.1
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.
BRIP.1
PML-UNITS-AMOUNT
Element: Intl Amt
Signed 18.2
BRIP.1
PML-UNIT-MEASURE
Element: Unit Measure
Alpha 12
BRIP.1
PML-MILESTONE
Element: Milestone
Alpha 3
BRIP.1
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
BRIP.1
PML-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
BRIP.1
PML-INVC-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
PML-TAX-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
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.
BRIP.1
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.
BRIP.1
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.
BRIP.1
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.
BRIP.1
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.
BRIP.1
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.
BRIP.1
PML-MX-VALUE-1
Element: Mx Value
Alpha 32
The attribute value.
BRIP.1
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.
BRIP.1
PML-MX-VALUE-3
Element: Mx Value
Alpha 32
The attribute value.
BRIP.1
PML-EXCEED-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
PML-EXCEED-UNIT
Element: Intl Amt
Signed 18.2
BRIP.1
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.
BRIP.1
PML-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
BRIP.1
PML-RETENTION-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
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
BRIP.1
PML-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
BRIP.1
PML-REVENUE-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
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
BRIP.1
PML-LINE-NBR-MAP
Element: Line Nbr Map
Numeric 6
BRIP.1
PML-ADJUST-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
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
BRIP.1
PML-TAXABLE-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
PML-SERVICE-LOC
Element: Service Loc
Numeric 4
A user defined code identifying a customer's service location.
BRIP.1
PML-BACKED-OUT-FL
Element: Backed Out Fl
Alpha 1

Y = Yes
N = No
BRIP.1
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.
BRIP.1
PML-RETAIN-CODE
Element: Retain Code
Alpha 3
BRIP.1
PML-RETAIN-ID
Element: Retain Id
Numeric 6
BRIP.1
PML-RETAINER-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
PML-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
BRIP.1
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
BRIP.1
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
BRIP.1
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.
BRIP.1
PML-XREF-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
BRIP.1
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.
BRIP.1
PML-MAINT-SCHEDULE
Element: Maint Schedule
Alpha 15
BRIP.1
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.
BRIP.1
PML-SUITE
Element: Prod Suite
Alpha 6
BRIP.1
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
BRIP.1


ACPMHSTDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMLSET1 OBJ-ID
LINE-NBR
BR123 BR157
BR252 BR52.1
BRIP.1
PMLSET2 GLT-OBJ-ID
ATN-OBJ-ID
OBJ-ID
LINE-NBR
KeyChange


ACPMHSTDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Not Required
PMH-CONTRACT->CNT-CONTRACT (CNTSET1)
Acpmhstcsl ACPMHSTCSL Required
PML-OBJ-ID->PMC-OBJ-ID
PML-LINE-NBR->PMC-LINE-NBR
Acpmhsthdr ACPMHSTHDR Required
PML-OBJ-ID->PMH-OBJ-ID
Acreasoncd ACREASONCD Not Required
PML-REASON-CODE->CDE-REASON-CODE
Actrans ACTRANS Not Required
PML-ATN-OBJ-ID->ATN-OBJ-ID
Gltrans GLTRANS Not Required
PML-GLT-OBJ-ID->GLT-OBJ-ID


ACPMHSTDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acpmhsttax ACPMHSTTAX
PML-OBJ-ID->PHT-OBJ-ID
PML-LINE-NBR->PHT-PML-LINE-NBR
  PHT-SEQ-NBR


File created: Thu Jun 09 11:10:58 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.