|
|
ACPMHSTCSL FILE
The ACPMHSTCSL file contains product invoice information as it appears on the
invoice that is sent to the customer. This file is updated primarily by
Product Invoicing (BR151). This file has relations with ACPMHSTHDR and
ACPMHSTDTL.
UPDATED BY
BRPI.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMC-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.
PMC-LINE-NBR Numeric 6 BRPI.1
Element: Line Number This field contains the line number.
PMC-DESCRIPTION Alpha 30 (Lower Case) BRPI.1
Element: Description This field displays the description.
PMC-BILL-RATE Signed 13.4
Element: Bill Rate
PMC-UNITS-AMOUNT Signed 15.2
Element: Units Amount This is the units amount included in
the file.
PMC-INVC-AMT Signed 15.2 BRPI.1
Element: Adj Amt
PMC-CUM-AMT Signed 15.2
Element: Adj Amt
PMC-CUM-UNIT Signed 15.2
Element: Cum Unit
PMC-CONTRACT Alpha 10 BRPI.1
Element: Contract
PMC-LINE-TYPE Alpha 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
PMC-LINE-LVL Numeric 1
Element: Line Lvl 1 = Detail
2 = Footer
3 = Total
4 = Gross Total
5 = Sub Total
6 = Final Total
7 = Invoice Tax Total
8 = Invoice Total
PMC-FEE-CD Alpha 5
Element: Fee Cd
PMC-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.
PMC-ACCT-CAT-CLASS Alpha 5 BRPI.1
Element: Acct Cat Class
PMC-MATRIX-CAT Alpha 12
Element: Attribute 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.
PMC-MX-VALUE Alpha 32
Element: Attribute Value
PMC-RESOURCE-TYPE Alpha 1
Element: Resource Type P = AC Person
E = Employee
Q = Equipment
V = Vendor
A = Asset
PMC-RESOURCE-CODE Alpha 10
Element: Resource Code
PMC-RESOURCE-COMP Numeric 4
Element: Company
PMC-FIELD1-DESC Alpha 30 (Lower Case)
Element: Description
PMC-FIELD2-DESC Alpha 30 (Lower Case)
Element: Description
PMC-CTR-CAT-GRP Alpha 5
Element: Ctr Cat Grp
PMC-FIELD3-DESC Alpha 30 (Lower Case)
Element: Description
PMC-FIELD4-DESC Alpha 30 (Lower Case)
Element: Description
PMC-FIELD5-DESC Alpha 30 (Lower Case)
Element: Description
PMC-TAX-CODE Alpha 10 Occurs 8 Times
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PMC-TAX-RATE Percent 7.5 (Percent) Occurs 8 Times
Element: Tax Rate The tax rate defined for the tax code.
PMC-TAX-AMT Signed 15.2 Occurs 8 Times
Element: Adj Amt
PMC-TAXABLE Signed 15.2
Element: Adj Amt
PMC-SUITE Alpha 6
Element: Prod Suite
ACPMHSTCSL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMCSET1 OBJ-ID BRPI.1
LINE-NBR
ACPMHSTCSL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acpmhsthdr ACPMHSTHDR Required
PMC-OBJ-ID -> PMH-OBJ-ID
ACPMHSTCSL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acpmhstdtl ACPMHSTDTL
PMC-OBJ-ID -> PML-OBJ-ID
PML-LINE-NBR
|
