ACHISTCNSL – Billing Consolidation

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

ACHISTCNSL is the Billing Consolidation table in Lawson AC Billing Revenue (prefix IHC). It is indexed by OBJ-ID, LINE-NBR (IHCSET1); alternate indexes: IHCSET2. It is related 1:1 to ACHISTHDR and 1:M to ACHISTDTL and ACINVAUDIT. It is updated by BR300 and BRIP.1. The table has 30 fields, 2 indexes and 3 documented relations.

About ACHISTCNSL

No description in the Lawson data dictionary.

Fields (30)

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

Field / column	Type	Description & values	Updated by
`IHC-OBJ-ID` PK OBJ_ID	Numeric 12	The object identifier is a number used to relate the invoice consolidated records to the invoice header/detail records. The object Type is INVID in the OBJID file.	BRIP.1
`IHC-LINE-NBR` PK LINE_NBR	Numeric 6	The unique number of the invoice consolidated record.	BRIP.1
`IHC-DESCRIPTION` DESCRIPTION	Alpha 60 (Lower Case)	The description that displays in the print file for the invoice, based on what the summarize options are set for in the AC Customer(BR11).	BRIP.1
`IHC-BILL-RATE` BILL_RATE	Signed 13.4	The billing rate set up for a resource for a specific activity.	BRIP.1
`IHC-UNITS-AMOUNT` UNITS_AMOUNT	Signed 15.2	This is the units amount included in the file.	BRIP.1
`IHC-INVC-AMT` INVC_AMT	Signed 18.2	—	BRIP.1
`IHC-CUM-AMT` CUM_AMT	Signed 18.2	—	BRIP.1
`IHC-CUM-UNIT` CUM_UNIT	Signed 15.2	This field stores the cumulative units used to calculate fee. It is all costs available for billing or revenue based on the account categories set up as drivers on fee code set up.	BRIP.1
`IHC-CONTRACT` CONTRACT	Alpha 15	Activity Management contract.	BRIP.1
`IHC-LINE-TYPE` LINE_TYPE	Alpha 1	This field contains the type of inventory on this line. The values are: `A` Transaction `B` Milestone `C` Tax `F` Fee `G` Retention on Fee `H` Overage of 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
`IHC-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
`IHC-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
`IHC-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The account category associated with the invoice detail records.	BRIP.1
`IHC-SUM-ACCT-CAT` SUM_ACCT_CAT	Alpha 5	The name of the summary account category.	BRIP.1
`IHC-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
`IHC-MX-VALUE` MX_VALUE	Alpha 32	The attribute value.	BRIP.1
`IHC-RESOURCE-TYPE` RESOURCE_TYPE	Alpha 1	The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor	BRIP.1
`IHC-RESOURCE-CODE` RESOURCE_CODE	Alpha 10	The code identifying the resource assigned to the activity or activity group associated with the invoice transactions.	BRIP.1
`IHC-RESOURCE-COMP` RESOURCE_COMP	Numeric 4	Resource Company. Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is the from company blank with the from company for type P or Q resources.	BRIP.1
`IHC-FIELD1-DESC` FIELD1_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`IHC-FIELD2-DESC` FIELD2_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`IHC-CTR-CAT-GRP` CTR_CAT_GRP	Alpha 5	—	BRIP.1
`IHC-FIELD3-DESC` FIELD3_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`IHC-FIELD4-DESC` FIELD4_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`IHC-FIELD5-DESC` FIELD5_DESC	Alpha 30 (Lower Case)	This field displays the description.	BRIP.1
`IHC-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
`IHC-TAX-RATE` TAX_RATE	Percent 7.5 (Percent) Occurs 8 Times ×8	The tax rate defined for the tax code.	BRIP.1
`IHC-TAX-AMT` TAX_AMT	Signed 18.2 Occurs 8 Times ×8	—	BRIP.1
`IHC-TAXABLE` TAXABLE	Signed 18.2	—	BRIP.1
`IHC-GRANT` GRANT	Alpha 30	—	—

Indexes (2)

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
`IHCSET1`	`OBJ-ID`, `LINE-NBR`	Primary		BR300, BRIP.1
`IHCSET2`	`CONTRACT`, `OBJ-ID`, `LINE-NBR`	KeyChange		—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Achisthdr	ACHISTHDR	Required		`IHC-OBJ-ID` → `HIH-OBJ-ID (HIHSET1)`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Achistdtl	ACHISTDTL			`IHC-OBJ-ID` → `HDT-OBJ-ID`, `IHC-LINE-NBR` → `HDT-CNSL-LINE-NBR`, → `HDT-LINE-NBR`
Acinvaudit	ACINVAUDIT			`IHC-OBJ-ID` → `IVA-OBJ-ID`, → `IVA-LINE-NBR`, → `IVA-TRANS-DATE`, → `IVA-SEQUENCE-NBR`

Programs

Updated by (2)

BR300 Invoice Purge
BRIP.1 Invoice Print Program