|
|
ACPMHSTDTL FILE
The ACPMHSTDTL file stores detail data about a product invoice. This file is
updated primarily by Product Invoicing (BR151). The ACPMHSTDTL file has
relations with the ACCNTRACT, ACPMHSTHDR, ACPMHSTTAX, ACPMHSTCSL, ACREASONCD,
ACTRANS, and GLTRANS files.
REFERENCED BY
BR123 BR157 BR252 BR52.1
UPDATED BY
BRPI.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PML-OBJ-ID Numeric 12 BRPI.1
Object This is the object identifier. It is
Identification 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 Numeric 6 BRPI.1
Element: Line Number This field contains the line number.
PML-CNSL-LINE-NBR Numeric 6 BRPI.1
Element: Line Number
PML-PT-ACTIVITY Alpha 15 BRPI.1
Element: Activity
PML-ACCT-CATEGORY Alpha 5 BRPI.1
Element: Account CategoAccount 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.
PML-BILLING-METHOD Numeric 1 BRPI.1
Element: Billing Method1 = Time and Material
2 = Cost Plus
3 = Units of Production
4 = Milestone
5 = Pass Thru
9 = User Defined
PML-TRAN-DATE Numeric 8 (yyyymmdd) BRPI.1
Element: Date
PML-DESCRIPTION Alpha 30 (Lower Case) BRPI.1
Element: Description This field displays the description.
PML-RESOURCE-TYPE Alpha 1
Element: Resource Type P = AC Person
Q = Equipment
V = Vendor
E = Employee
A = Asset
PML-RESOURCE-COMP Numeric 4
Element: Company
PML-RESOURCE-CODE Alpha 10
Element: Resource Code
PML-RESOURCE-DESC Alpha 30 (Lower Case)
Element: Description
PML-BILL-RATE Signed 13.4
Element: Bill Rate
PML-MARK-UP-PCT Signed 5.2 BRPI.1
Element: Markup percentage
PML-UNITS-AMOUNT Signed 15.2
Element: Units Amount This is the units amount included in
the file.
PML-UNIT-MEASURE Alpha 12
Element: Unit Measure
PML-MILESTONE Alpha 3 BRPI.1
Element: Milestone
PML-PERC-COMPLETE Signed 7.3
Element: Percent Complete
PML-TAX-EXEMPT-CD Alpha 1 BRPI.1
Element: Tax Exempt CodE = Exempt
T = Taxable
PML-TAX-CODE Alpha 10 BRPI.1
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PML-INVC-AMT Signed 15.2 BRPI.1
Element: Adj Amt
PML-TAX-AMT Signed 15.2 BRPI.1
Element: Adj Amt
PML-POST-COMPANY Numeric 4 BRPI.1
Element: Company
PML-ACCT-UNIT Alpha 15 BRPI.1
Element: Accounting UniThe 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 Numeric 6 BRPI.1
Element: Account 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 Numeric 4 BRPI.1
Element: Subaccount 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 Numeric 12 BRPI.1
Object
Identification
PML-MATRIX-CAT-1 Alpha 12
Element: Attribute
PML-MX-VALUE-1 Alpha 32
Element: Attribute Value
PML-MATRIX-CAT-2 Alpha 12
Element: Attribute
PML-MX-VALUE-2 Alpha 32
Element: Attribute Value
PML-MATRIX-CAT-3 Alpha 12 BRPI.1
Element: Attribute
PML-MX-VALUE-3 Alpha 32 BRPI.1
Element: Attribute Value
PML-EXCEED-AMT Signed 15.2
Element: Adj Amt
PML-EXCEED-UNIT Signed 15.2
Element: Exceed Unit
PML-BILL-ACTIVITY Alpha 15 BRPI.1
Element: Activity
PML-CONTRACT Alpha 10 BRPI.1
Element: Contract
PML-RETENTION-AMT Signed 15.2
Element: Adj Amt
PML-LEVEL Numeric 1 BRPI.1
Element: Level 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 Alpha 4 BRPI.1
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
PML-REVENUE-AMT Signed 15.2
Element: Adj Amt
PML-ADJ-LEVEL Alpha 1
Element: Adj Level 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 Numeric 6
Element: Line Nbr Map
PML-ADJUST-AMT Signed 15.2
Element: Adj Amt
PML-LINE-TYPE Alpha 1 BRPI.1
Element: Line Type 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 Signed 15.2 BRPI.1
Element: Adj Amt
PML-SERVICE-LOC Numeric 4
Element: Service Loc
PML-BACKED-OUT-FL Alpha 1
Element: Backed Out Fl Y = Yes
N = No
PML-FEE-CD Alpha 5
Element: Fee Cd
PML-RETAIN-CODE Alpha 3
Element: Retain Code
PML-RETAIN-ID Numeric 6
Element: Retain Id
PML-RETAINER-AMT Signed 15.2
Element: Adj Amt
PML-ACCT-CAT-CLASS Alpha 5 BRPI.1
Element: Acct Cat Class
PML-ADJUST-TYPE Alpha 1
Element: Adjust Type A = Write Up or Down
B = Hold
C = Bill in Advance
D = Transfer
PML-ORIG-INVC-AMT Signed 15.2
Element: Adj Amt
PML-TRANSFER-AMT Signed 15.2
Element: Adj Amt
PML-TRANSFER-UNITS Signed 15.2
Element: Adj Amt
PML-CTR-CAT-GRP Alpha 5
Element: Ctr Cat Grp
PML-XREF-HIH-OBJID Numeric 12
Object
Identification
PML-XREF-LINE-NBR Numeric 6
Element: Line Number
PML-GLT-OBJ-ID Numeric 12 BRPI.1
Object
Identification
PML-MAINT-SCHEDULE Alpha 15 BRPI.1
Element: Maint Schedule
PML-MSC-OBJ-ID Numeric 12 BRPI.1
Object
Identification
PML-SUITE Alpha 6 BRPI.1
Element: Prod Suite
PML-TAX-ACCT-CAT Alpha 5
Element: Account Category
PML-DELIV-METHOD Alpha 1 BRPI.1
Element: Deliv Method S = Shipped
H = Hosted at
E = Electronic
L = Loaded
1 = Method 1
2 = Method 2
3 = Method 3
ACPMHSTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMLSET1 OBJ-ID BR123 BR157
LINE-NBR BR252 BR52.1
BRPI.1
PMLSET2 GLT-OBJ-ID KeyChange
ATN-OBJ-ID
OBJ-ID
LINE-NBR
ACPMHSTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acpmhsttax ACPMHSTTAX
PML-OBJ-ID -> PHT-OBJ-ID
PML-LINE-NBR -> PHT-PML-LINE-NBR
PHT-SEQ-NBR
|
