ACPMHSTCSL

UPDATED BY
BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMC-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
PMC-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
BRIP.1
PMC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
PMC-BILL-RATE
Element: Bill Rate
Signed 13.4
The billing rate that is set up for a resource for a specific activity.
BRIP.1
PMC-UNITS-AMOUNT
Element: Intl Amt
Signed 18.2
BRIP.1
PMC-INVC-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
PMC-CUM-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
PMC-CUM-UNIT
Element: Intl Amt
Signed 18.2
BRIP.1
PMC-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
BRIP.1
PMC-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
PMC-LINE-LVL
Element: Line Lvl
Numeric 1

1 = Detail
2 = Footer
3 = Total
4 = Gross Total
5 = Sub Total
6 = Final Total
7 = Invoice Tax Total
8 = Invoice Total
BRIP.1
PMC-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
PMC-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
PMC-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
BRIP.1
PMC-MATRIX-CAT
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
PMC-MX-VALUE
Element: Mx Value
Alpha 32
The attribute value.
BRIP.1
PMC-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
E = Employee
Q = Equipment
V = Vendor
A = Asset
BRIP.1
PMC-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group.
BRIP.1
PMC-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
PMC-FIELD1-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
PMC-FIELD2-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
PMC-CTR-CAT-GRP
Element: Ctr Cat Grp
Alpha 5
BRIP.1
PMC-FIELD3-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
PMC-FIELD4-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
PMC-FIELD5-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
PMC-TAX-CODE
Element: Tax Code
Alpha 10 Occurs 8 Times
This field contains a code representing specific tax information. This must be valid Tax Code.
BRIP.1
PMC-TAX-RATE
Element: Tax Rate
Percent 7.5 (Percent) Occurs 8 Times
The tax rate defined for the tax code.
BRIP.1
PMC-TAX-AMT
Element: Intl Amt
Signed 18.2 Occurs 8 Times
BRIP.1
PMC-TAXABLE
Element: Intl Amt
Signed 18.2
PMC-SUITE
Element: Prod Suite
Alpha 6


ACPMHSTCSL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMCSET1 OBJ-ID
LINE-NBR
BRIP.1


ACPMHSTCSL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acpmhsthdr ACPMHSTHDR Required
PMC-OBJ-ID->PMH-OBJ-ID


ACPMHSTCSL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acpmhstdtl ACPMHSTDTL
PMC-OBJ-ID->PML-OBJ-ID
  PML-LINE-NBR


File created: Thu Jun 09 02:11:08 2016

Home
Contact Us



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