|
|
ACPMHSTDTL FILE
REFERENCED BY
BR123 BR157 BR252 BR52.1
UPDATED BY
BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PML-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.
PML-LINE-NBR Numeric 6 BRIP.1
Element: Line Nbr This field contains the line number.
PML-CNSL-LINE-NBR Numeric 6 BRIP.1
Element: Line Nbr This field contains the line number.
PML-PT-ACTIVITY Alpha 15 BRIP.1
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PML-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
PML-BILLING-METHOD Numeric 1 BRIP.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) BRIP.1
Element: Date This field displays the system date
when this was created.
PML-DESCRIPTION Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
PML-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
Q = Equipment
V = Vendor
E = Employee
A = Asset
PML-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.
PML-RESOURCE-CODE Alpha 10 BRIP.1
Element: Resource Code The code identifying the resource
assigned to the activity or activity
group.
PML-RESOURCE-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
PML-BILL-RATE Signed 13.4 BRIP.1
Element: Bill Rate The billing rate that is set up for a
resource for a specific activity.
PML-MARK-UP-PCT Signed 5.2 BRIP.1
Element: Mark Up Pct 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.
PML-UNITS-AMOUNT Signed 18.2 BRIP.1
Element: Intl Amt
PML-UNIT-MEASURE Alpha 12 BRIP.1
Element: Unit Measure
PML-MILESTONE Alpha 3 BRIP.1
Element: Milestone
PML-PERC-COMPLETE Signed 7.3
Element: Perc Complete
PML-TAX-EXEMPT-CD Alpha 1 BRIP.1
Element: Tax Exempt Cd Code indicating the taxing status. E -
Exempt, T - Taxable.
E = Exempt
T = Taxable
PML-TAX-CODE Alpha 10 BRIP.1
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PML-INVC-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PML-TAX-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PML-POST-COMPANY 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.
PML-ACCT-UNIT Alpha 15 BRIP.1
Element: Acct Unit 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.
PML-ACCOUNT Numeric 6 BRIP.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 BRIP.1
Element: Sub Acct 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 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.
PML-MATRIX-CAT-1 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.
PML-MX-VALUE-1 Alpha 32 BRIP.1
Element: Mx Value The attribute value.
PML-MATRIX-CAT-2 Alpha 12
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.
PML-MX-VALUE-2 Alpha 32
Element: Mx Value The attribute value.
PML-MATRIX-CAT-3 Alpha 12
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.
PML-MX-VALUE-3 Alpha 32
Element: Mx Value The attribute value.
PML-EXCEED-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PML-EXCEED-UNIT Signed 18.2 BRIP.1
Element: Intl Amt
PML-BILL-ACTIVITY Alpha 15 BRIP.1
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PML-CONTRACT Alpha 15 BRIP.1
Element: Contract Activity Management contract.
PML-RETENTION-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PML-LEVEL Numeric 1 BRIP.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 BRIP.1
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
PML-REVENUE-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PML-ADJ-LEVEL Alpha 1 BRIP.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 BRIP.1
Element: Line Nbr Map
PML-ADJUST-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PML-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
PML-TAXABLE-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PML-SERVICE-LOC Numeric 4 BRIP.1
Element: Service Loc A user defined code identifying a
customer's service location.
PML-BACKED-OUT-FL Alpha 1 BRIP.1
Element: Backed Out Fl Y = Yes
N = No
PML-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.
PML-RETAIN-CODE Alpha 3 BRIP.1
Element: Retain Code
PML-RETAIN-ID Numeric 6 BRIP.1
Element: Retain Id
PML-RETAINER-AMT Signed 18.2 BRIP.1
Element: Intl Amt
PML-SUM-ACCT-CAT Alpha 5 BRIP.1
Element: Sum Acct Cat The name of the summary account
category.
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 18.2 BRIP.1
Element: Intl Amt
PML-TRANSFER-AMT Signed 18.2
Element: Intl Amt
PML-TRANSFER-UNITS Signed 18.2
Element: Intl Amt
PML-CTR-CAT-GRP Alpha 5 BRIP.1
Element: Ctr Cat Grp
PML-XREF-HIH-OBJID 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.
PML-XREF-LINE-NBR Numeric 6 BRIP.1
Element: Line Nbr This field contains the line number.
PML-GLT-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.
PML-MAINT-SCHEDULE Alpha 15 BRIP.1
Element: Maint Schedule
PML-MSC-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.
PML-SUITE Alpha 6
Element: Prod Suite
PML-TAX-ACCT-CAT Alpha 5
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
PML-DELIV-METHOD Alpha 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
BRIP.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
|
