ACPMHSTDTL – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
PML
Primary key
OBJ-ID, LINE-NBR
Fields
66
Updated by
1 program
Referenced by
4 programs

ACPMHSTDTL is a Lawson AC Billing Revenue table (prefix PML); no description in the lawson data dictionary. It is indexed by OBJ-ID, LINE-NBR (PMLSET1); alternate indexes: PMLSET2. It is related 1:1 to ACCNTRACT, ACPMHSTCSL, ACPMHSTHDR, ACREASONCD, ACTRANS and GLTRANS and 1:M to ACPMHSTTAX. It is updated by BRIP.1 and referenced by BR123, BR157, BR252 and BR52.1. The table has 66 fields, 2 indexes and 7 documented relations.

About ACPMHSTDTL

No description in the Lawson data dictionary.

Fields (66)

Column = COBOL field name without the PML- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PML-OBJ-ID PK
OBJ_ID		Numeric 12This 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
PML-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.BRIP.1
PML-CNSL-LINE-NBR
CNSL_LINE_NBR		Numeric 6This field contains the line number.BRIP.1
PML-PT-ACTIVITY
PT_ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.BRIP.1
PML-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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 thruBRIP.1
PML-BILLING-METHOD
BILLING_METHOD		Numeric 1—
  • 1 Time and Material
  • 2 Cost Plus
  • 3 Units of Production
  • 4 Milestone
  • 5 Pass Thru
  • 9 User Defined
BRIP.1
PML-TRAN-DATE
TRAN_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BRIP.1
PML-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.BRIP.1
PML-RESOURCE-TYPE
RESOURCE_TYPE		Alpha 1The 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
BRIP.1
PML-RESOURCE-COMP
RESOURCE_COMP		Numeric 4Identifies 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
PML-RESOURCE-CODE
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group.BRIP.1
PML-RESOURCE-DESC
RESOURCE_DESC		Alpha 30 (Lower Case)This field displays the description.BRIP.1
PML-BILL-RATE
BILL_RATE		Signed 13.4The billing rate that is set up for a resource for a specific activity.BRIP.1
PML-MARK-UP-PCT
MARK_UP_PCT		Signed 5.2This 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.BRIP.1
PML-UNITS-AMOUNT
UNITS_AMOUNT		Signed 18.2—BRIP.1
PML-UNIT-MEASURE
UNIT_MEASURE		Alpha 12—BRIP.1
PML-MILESTONE
MILESTONE		Alpha 3—BRIP.1
PML-PERC-COMPLETE
PERC_COMPLETE		Signed 7.3——
PML-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1Code indicating the taxing status. E - Exempt, T - Taxable.
  • E Exempt
  • T Taxable
BRIP.1
PML-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.BRIP.1
PML-INVC-AMT
INVC_AMT		Signed 18.2—BRIP.1
PML-TAX-AMT
TAX_AMT		Signed 18.2—BRIP.1
PML-POST-COMPANY
POST_COMPANY		Numeric 4Identifies 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
PML-ACCT-UNIT
ACCT_UNIT		Alpha 15The 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.BRIP.1
PML-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BRIP.1
PML-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BRIP.1
PML-ATN-OBJ-ID
ATN_OBJ_ID		Numeric 12This 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
PML-MATRIX-CAT-1
MATRIX_CAT_1		Alpha 12Attribute 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
PML-MX-VALUE-1
MX_VALUE_1		Alpha 32The attribute value.BRIP.1
PML-MATRIX-CAT-2
MATRIX_CAT_2		Alpha 12Attribute 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
MX_VALUE_2		Alpha 32The attribute value.—
PML-MATRIX-CAT-3
MATRIX_CAT_3		Alpha 12Attribute 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
PML-MX-VALUE-3
MX_VALUE_3		Alpha 32The attribute value.BRIP.1
PML-EXCEED-AMT
EXCEED_AMT		Signed 18.2—BRIP.1
PML-EXCEED-UNIT
EXCEED_UNIT		Signed 18.2—BRIP.1
PML-BILL-ACTIVITY
BILL_ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.BRIP.1
PML-CONTRACT
CONTRACT		Alpha 15Activity Management contract.BRIP.1
PML-RETENTION-AMT
RETENTION_AMT		Signed 18.2—BRIP.1
PML-LEVEL
LEVEL		Numeric 1—
  • 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
BRIP.1
PML-REASON-CODE
REASON_CODE		Alpha 4This field contains the reason code, which indicates the cause for credit memos.BRIP.1
PML-REVENUE-AMT
REVENUE_AMT		Signed 18.2—BRIP.1
PML-ADJ-LEVEL
ADJ_LEVEL		Alpha 1—
  • I Invoice Level
  • D Invoice Detail Level
  • T Transaction Detail Level
  • P Posting Activity Level
  • A Posting Activity Acct Cat Lvl
BRIP.1
PML-LINE-NBR-MAP
LINE_NBR_MAP		Numeric 6—BRIP.1
PML-ADJUST-AMT
ADJUST_AMT		Signed 18.2—BRIP.1
PML-LINE-TYPE
LINE_TYPE		Alpha 1This 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
PML-TAXABLE-AMT
TAXABLE_AMT		Signed 18.2—BRIP.1
PML-SERVICE-LOC
SERVICE_LOC		Numeric 4A user defined code identifying a customer's service location.BRIP.1
PML-BACKED-OUT-FL
BACKED_OUT_FL		Alpha 1—
  • Y Yes
  • N No
BRIP.1
PML-FEE-CD
FEE_CD		Alpha 5The fee code name will be a user defined identifier of the code that will be used to calculate fee.BRIP.1
PML-RETAIN-CODE
RETAIN_CODE		Alpha 3—BRIP.1
PML-RETAIN-ID
RETAIN_ID		Numeric 6—BRIP.1
PML-RETAINER-AMT
RETAINER_AMT		Signed 18.2—BRIP.1
PML-SUM-ACCT-CAT
SUM_ACCT_CAT		Alpha 5The name of the summary account category.BRIP.1
PML-ADJUST-TYPE
ADJUST_TYPE		Alpha 1—
  • A Write Up or Down
  • B Hold
  • C Bill in Advance
  • D Transfer
—
PML-ORIG-INVC-AMT
ORIG_INVC_AMT		Signed 18.2—BRIP.1
PML-TRANSFER-AMT
TRANSFER_AMT		Signed 18.2——
PML-TRANSFER-UNITS
TRANSFER_UNITS		Signed 18.2——
PML-CTR-CAT-GRP
CTR_CAT_GRP		Alpha 5—BRIP.1
PML-XREF-HIH-OBJID
XREF_HIH_OBJID		Numeric 12This 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
PML-XREF-LINE-NBR
XREF_LINE_NBR		Numeric 6This field contains the line number.BRIP.1
PML-GLT-OBJ-ID
GLT_OBJ_ID		Numeric 12This 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
PML-MAINT-SCHEDULE
MAINT_SCHEDULE		Alpha 15—BRIP.1
PML-MSC-OBJ-ID
MSC_OBJ_ID		Numeric 12This 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
PML-SUITE
SUITE		Alpha 6—BRIP.1
PML-TAX-ACCT-CAT
TAX_ACCT_CAT		Alpha 5Account 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
DELIV_METHOD		Alpha 1—
  • S Shipped
  • H Hosted at
  • E Electronic
  • L Loaded
  • 1 Method 1
  • 2 Method 2
  • 3 Method 3
BRIP.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PMLSET1OBJ-ID, LINE-NBRPrimaryBR123, BR157, BR252, BR52.1, BRIP.1
PMLSET2GLT-OBJ-ID, ATN-OBJ-ID, OBJ-ID, LINE-NBRKeyChange—

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTNot RequiredPMH-CONTRACT → CNT-CONTRACT (CNTSET1)
AcpmhstcslACPMHSTCSLRequiredPML-OBJ-ID → PMC-OBJ-ID, PML-LINE-NBR → PMC-LINE-NBR
AcpmhsthdrACPMHSTHDRRequiredPML-OBJ-ID → PMH-OBJ-ID
AcreasoncdACREASONCDNot RequiredPML-REASON-CODE → CDE-REASON-CODE
ActransACTRANSNot RequiredPML-ATN-OBJ-ID → ATN-OBJ-ID
GltransGLTRANSNot RequiredPML-GLT-OBJ-ID → GLT-OBJ-ID

One to many (1) — child tables

RelationTableRulesConditionField map
AcpmhsttaxACPMHSTTAXPML-OBJ-ID → PHT-OBJ-ID, PML-LINE-NBR → PHT-PML-LINE-NBR, → PHT-SEQ-NBR

Programs

Updated by (1)

Referenced by (4)