ACPMHSTCSL – No description in the Lawson data dictionary

System: AC Billing Revenue (BR)
Prefix: PMC
Primary key: OBJ-ID, LINE-NBR
Fields: 30
Updated by: 1 program
Referenced by: 0 programs

ACPMHSTCSL is a Lawson AC Billing Revenue table (prefix PMC); no description in the lawson data dictionary. It is indexed by OBJ-ID, LINE-NBR (PMCSET1). It is related 1:1 to ACPMHSTHDR and 1:M to ACPMHSTDTL. It is updated by BRIP.1. The table has 30 fields, 1 index and 2 documented relations.

About ACPMHSTCSL

No description in the Lawson data dictionary.

Fields (30)

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

Field / column	Type	Description & values	Updated by
`PMC-OBJ-ID` PK 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` PK LINE_NBR	Numeric 6	This field contains the line number.	BRIP.1
`PMC-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`PMC-BILL-RATE` BILL_RATE	Signed 13.4	The billing rate that is set up for a resource for a specific activity.	BRIP.1
`PMC-UNITS-AMOUNT` UNITS_AMOUNT	Signed 18.2	—	BRIP.1
`PMC-INVC-AMT` INVC_AMT	Signed 18.2	—	BRIP.1
`PMC-CUM-AMT` CUM_AMT	Signed 18.2	—	BRIP.1
`PMC-CUM-UNIT` CUM_UNIT	Signed 18.2	—	BRIP.1
`PMC-CONTRACT` CONTRACT	Alpha 15	Activity Management contract.	BRIP.1
`PMC-LINE-TYPE` 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` 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` 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` 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` SUM_ACCT_CAT	Alpha 5	The name of the summary account category.	BRIP.1
`PMC-MATRIX-CAT` 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` MX_VALUE	Alpha 32	The attribute value.	BRIP.1
`PMC-RESOURCE-TYPE` 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` RESOURCE_CODE	Alpha 10	The code identifying the resource assigned to the activity or activity group.	BRIP.1
`PMC-RESOURCE-COMP` RESOURCE_COMP	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` FIELD1_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`PMC-FIELD2-DESC` FIELD2_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`PMC-CTR-CAT-GRP` CTR_CAT_GRP	Alpha 5	—	BRIP.1
`PMC-FIELD3-DESC` FIELD3_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`PMC-FIELD4-DESC` FIELD4_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`PMC-FIELD5-DESC` FIELD5_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`PMC-TAX-CODE` TAX_CODE	Alpha 10 Occurs 8 Times ×8	This field contains a code representing specific tax information. This must be valid Tax Code.	BRIP.1
`PMC-TAX-RATE` TAX_RATE	Percent 7.5 (Percent) Occurs 8 Times ×8	The tax rate defined for the tax code.	BRIP.1
`PMC-TAX-AMT` TAX_AMT	Signed 18.2 Occurs 8 Times ×8	—	BRIP.1
`PMC-TAXABLE` TAXABLE	Signed 18.2	—	—
`PMC-SUITE` SUITE	Alpha 6	—	—

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`PMCSET1`	`OBJ-ID`, `LINE-NBR`	Primary		BRIP.1

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Acpmhsthdr	ACPMHSTHDR	Required		`PMC-OBJ-ID` → `PMH-OBJ-ID`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Acpmhstdtl	ACPMHSTDTL			`PMC-OBJ-ID` → `PML-OBJ-ID`, → `PML-LINE-NBR`

Programs

Updated by (1)

BRIP.1 Invoice Print Program