|
|
ACPMHSTCSL FILE
UPDATED BY
BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMC-OBJ-ID Numeric 12 BRIP.1
Element: Obj Id 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.
PMC-LINE-NBR Numeric 6 BRIP.1
Element: Line Nbr This field contains the line number.
PMC-DESCRIPTION Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
PMC-BILL-RATE Signed 13.4 BRIP.1
Element: Bill Rate The billing rate that is set up for a
resource for a specific activity.
PMC-UNITS-AMOUNT Signed 18.2 BRIP.1
Element: Intl Amt
PMC-INVC-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PMC-CUM-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PMC-CUM-UNIT Signed 18.2 BRIP.1
Element: Intl Amt
PMC-CONTRACT Alpha 15 BRIP.1
Element: Contract Activity Management contract.
PMC-LINE-TYPE Alpha 1 BRIP.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 BRIP.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 BRIP.1
Element: Fee Cd The fee code name will be a user defined
identifier of the code that will be used
to calculate fee.
PMC-ACCT-CATEGORY Alpha 5 BRIP.1
Element: Acct Category 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
PMC-SUM-ACCT-CAT Alpha 5 BRIP.1
Element: Sum Acct Cat The name of the summary account
category.
PMC-MATRIX-CAT Alpha 12 BRIP.1
Element: Matrix Cat 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 BRIP.1
Element: Mx Value The attribute value.
PMC-RESOURCE-TYPE Alpha 1 BRIP.1
Element: Resource Type The type of resource. Valid values
include:
P - AC Person
Q - Equipment
E - Employee
V - Vendor
A - Asset
P = AC Person
E = Employee
Q = Equipment
V = Vendor
A = Asset
PMC-RESOURCE-CODE Alpha 10 BRIP.1
Element: Resource Code The code identifying the resource
assigned to the activity or activity
group.
PMC-RESOURCE-COMP Numeric 4 BRIP.1
Element: Company 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.
PMC-FIELD1-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
PMC-FIELD2-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
PMC-CTR-CAT-GRP Alpha 5 BRIP.1
Element: Ctr Cat Grp
PMC-FIELD3-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
PMC-FIELD4-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
PMC-FIELD5-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
PMC-TAX-CODE Alpha 10 Occurs 8 Times BRIP.1
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 BRIP.1
Element: Tax Rate The tax rate defined for the tax code.
PMC-TAX-AMT Signed 18.2 Occurs 8 Times BRIP.1
Element: Intl Amt
PMC-TAXABLE Signed 18.2
Element: Intl Amt
PMC-SUITE Alpha 6
Element: Prod Suite
ACPMHSTCSL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMCSET1 OBJ-ID BRIP.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
|
