ACHISTDTL – Invoice Detail

System: AC Billing Revenue (BR)
Prefix: HDT
Primary key: OBJ-ID, LINE-NBR
Fields: 68
Updated by: 25 programs
Referenced by: 9 programs

ACHISTDTL is the Invoice Detail table in Lawson AC Billing Revenue (prefix HDT). It is indexed by OBJ-ID, LINE-NBR (HDTSET1); alternate indexes: HDTSET2, HDTSET3, HDTSET4, HDTSET5, HDTSET6, HDTSET7, HDTSET8 and HDTSET9. It is related 1:1 to ACCNTRACT, ACHISTCNSL, ACHISTHDR, ACHSTDTBOD, ACREASONCD, ACTRANS and GLTRANS and 1:M to ACHISTTAX and ACINVAUDIT. It is updated by BR02.3, BR120, BR121, BR122, BR123, BR131, BR140, BR151 and 17 more and referenced by AC10.1, AC300, BR145, BR16.1, BR245, BR400, BR45.1, BRBD.2 and 1 more. The table has 68 fields, 9 indexes and 9 documented relations.

About ACHISTDTL

The Billing and Revenue Invoice detail file contains the records associated with an invoice header. The file is keyed by the OBJ-ID associated with the invoice header.

Fields (68)

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

Field / column	Type	Description & values	Updated by
`HDT-OBJ-ID` PK OBJ_ID	Numeric 12	The object identifier is a number used to relate the invoice detail records to the invoice header. The object type is INVID in the OBJID file.	BR46.1, BR46.2, BR46.4, BRIP.1
`HDT-LINE-NBR` PK LINE_NBR	Numeric 6	The line number associated with the invoice detail record. It, in combination with the OBJ-ID field, keeps the ACHISTDTL record unique.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-CNSL-LINE-NBR` CNSL_LINE_NBR	Numeric 6	The number that maps the ACHISTCNSL file line number to this record.	BRIP.1
`HDT-PT-ACTIVITY` PT_ACTIVITY	Alpha 15	The posting activity associated with the original activity transaction being billed on this invoice.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The account category associated with the original activity transaction being billed on this invoice.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-BILLING-METHOD` BILLING_METHOD	Numeric 1	The billing method maintained for the activity associated with the invoice transaction in the Activity Billing (BR00) or Billing Detail (BR00.2) `1` Time and Materials `2` Cost Plus `3` Units of Production `4` Milestone `5` Pass Thru `9` User defined `1` Time and Materials `2` Cost Plus `3` Units of Production `4` Milestone `5` Pass Thru `9` User defined	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-TRAN-DATE` TRAN_DATE	Numeric 8 (yyyymmdd)	The transaction date associated with the original activity transaction being billed on this invoice.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description associated with the original activity transaction being billed on this invoice.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-RESOURCE-TYPE` RESOURCE_TYPE	Alpha 1	The type of resource associated with the original activity transaction. The valid values are: `P` AC Person `Q` Equipment `E` Employee `V` Vendor `Q` Equipment `P` Person	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-RESOURCE-COMP` RESOURCE_COMP	Numeric 4	The resource company or from company on the original activity transaction.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-RESOURCE-CODE` RESOURCE_CODE	Alpha 10	The resource code associated with the original activity transacton being billed on this invoice.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-RESOURCE-DESC` RESOURCE_DESC	Alpha 30 (Lower Case)	The description of the resource code maintained in Resource (AC03).	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-BILL-RATE` BILL_RATE	Signed 13.4	The billing rate that is associated with the original activity transaction being billed on this invoice. Only populated when the billing method is Time and Materials.	BR46.1, BR46.2, BR46.4, BRIP.1
`HDT-MARK-UP-PCT` MARK_UP_PCT	Signed 5.2	The percentage of markup for billing associated with the account category on the original activity transaction. The markup percent is maintained in Account Category Detail (AC08.3) and/or Billing Detail (BR00.2). Markup percentages will increase the cost amount by the percentage entered.	BR46.2, BR46.4, BRIP.1
`HDT-UNITS-AMOUNT` UNITS_AMOUNT	Signed 15.2	The billable units amount associated with the original activity transaction.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-UNIT-MEASURE` UNIT_MEASURE	Alpha 12	The unit of measure associated with the original activity transaction.	BR46.1, BR46.2, BR46.4, BRIP.1
`HDT-MILESTONE` MILESTONE	Alpha 3	The milestone code maintained in Milestone (BR05). Only populated when the billing method is Milestone.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-PERC-COMPLETE` PERC_COMPLETE	Signed 7.3	The percentage of completion associated with the percent complete milestone maintained in Percent Complete Milestones (BR05).	—
`HDT-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	The code indicating the taxing status. The valid values are: `E` Exempt `T` Taxable `E` Exempt `T` Taxable	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-TAX-CODE` TAX_CODE	Alpha 10	The code representing specific tax information. Must be a valid Tax Code.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-INVC-AMT` INVC_AMT	Signed 18.2	The invoice amount. Any billing adjustments made to the invoice line will be included in this line.	BR120, BR121, BR122, BR123, BR140, BR151, BR152, BR156 +11 more
`HDT-TAX-AMT` TAX_AMT	Signed 18.2	The tax amount calculated for the invoice line.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-POST-COMPANY` POST_COMPANY	Numeric 4	The company used for posting transactions to the General Ledger.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-ACCT-UNIT` ACCT_UNIT	Alpha 15	The accounting unit used in the transaction that is posted to General Ledger. This field along with the account and subaccount make up the location (account) where the amount and other account information is stored.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-ACCOUNT` ACCOUNT	Numeric 6	The Account used in the transaction that is posted to General Ledger. This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-SUB-ACCT` SUB_ACCT	Numeric 4	The subaccount used in the transaction that is posted ot General Ledger. This field along with the accounting unit and account make up the location (account) where ammounts and other account information is stored. subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	The system-defined object id representing the original activity transaction.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-MATRIX-CAT-1` MATRIX_CAT_1	Alpha 12	The Billing Category name associated with the original activity transaction for this invoice.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-MX-VALUE-1` MX_VALUE_1	Alpha 32	The Billing Category value associated with the original activity transaction.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-MATRIX-CAT-2` MATRIX_CAT_2	Alpha 12	The Billing Category name associated with the original activity transaction for this invoice.	—
`HDT-MX-VALUE-2` MX_VALUE_2	Alpha 32	The Billing Category value associated with the original activity transaction for this invoice.	—
`HDT-MATRIX-CAT-3` MATRIX_CAT_3	Alpha 12	The Billing Category name associated with the original activity transaction for this invoice.	—
`HDT-MX-VALUE-3` MX_VALUE_3	Alpha 32	The Billing Category value associated with the original activity transaction for this invoice.	—
`HDT-EXCEED-AMT` EXCEED_AMT	Signed 18.2	The amount of the detail invoice amoun that exceeds a ceiling. The ceilings are maintained in Contract Detail (BR102) Activity Billing (BR00.1) or Billing Detail (BR00.2) or Ceiling Levels (BR00.3).	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-EXCEED-UNIT` EXCEED_UNIT	Signed 15.2	The unit amount related to the exceed amount that is over the ceiling.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-BILL-ACTIVITY` BILL_ACTIVITY	Alpha 15	The billing activity assoicated with the posting activity on the original activity transaction.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-CONTRACT` CONTRACT	Alpha 15	The contract associated with the posting activity on the original activity transaction. The contract activity associated with the posting activity on the original transaction has a one to one relationship with the contract.	BR46.1, BR46.2, BR46.4, BRIP.1
`HDT-RETENTION-AMT` RETENTION_AMT	Signed 18.2	The retention amount based on the Retention Percent maintained in Bill Retention (BR01.2)	BR46.2, BR46.4, BRIP.1
`HDT-LEVEL` LEVEL	Numeric 1	Stores the level at which the exceeded amount or unit is recaptured. The billing level maintained on the Bill Parameter (BR00). The valid values are: `1` Billx `2` Resource Billx `3` Bill `4` Resource Bill `5` Contract Billx `6` Resource Contract Billx `7` Contract Bill `8` Resource Contract Bill `9` Contract `1` Billx `2` Resource Billx `3` Bill `4` Resource Bill `5` Contract Billx `6` Resource Contract Billx `7` Contract Bill `8` Resource Contract Bill `9` Contract	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-REASON-CODE` REASON_CODE	Alpha 4	The reason code indicating the cause of an invoice adjustment.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-REVENUE-AMT` REVENUE_AMT	Signed 18.2	The revenue amount assoicated with the original activity transaction. Field will only be populated when using transaction based revenue methods (i.e. Full Accrual or Cost Plus Full Accrual).	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-ADJ-LEVEL` ADJ_LEVEL	Alpha 1	Indicates the invoice edit(BR20) level of the adjustment. The valid values are: `I` Invoice `D` Invoice Detail `T` Transaction Detail `P` Posting Activity `A` Posting Activity Acct Cat `I` Invoice Level `D` Invoice Detail Level `T` Transaction Detail Level `P` Posting Activity Level `A` Posting Activity Acct Cat	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-LINE-NBR-MAP` LINE_NBR_MAP	Numeric 6	Indicates the detail line number that is associated with the adjustment line.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-ADJUST-AMT` ADJUST_AMT	Signed 18.2	The Adjustment amount is the prorated revenue amount	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-LINE-TYPE` LINE_TYPE	Alpha 1	This field contains the line type. The valid 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 `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	BR46.1, BR46.2, BR46.4, BRIP.1
`HDT-TAXABLE-AMT` TAXABLE_AMT	Signed 18.2	The taxable amount.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-SERVICE-LOC` SERVICE_LOC	Numeric 4	The service location used for the tax calculation.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-BACKED-OUT-FL` BACKED_OUT_FL	Alpha 1	— `Y` Yes `N` No	BR140, BR46.1, BR46.2, BR46.4, BRIP.1
`HDT-FEE-CD` FEE_CD	Alpha 5	The Fee Code maintained in Assignment for Billing (BR15.2) associated with the contract.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-RETAIN-CODE` RETAIN_CODE	Alpha 3	The Retainer Code maintained in Retainer Detail (BR02.2). Only populated when applying specific type retainers.	BR46.2, BR46.4, BRIP.1
`HDT-RETAIN-ID` RETAIN_ID	Numeric 6	The retainer sequence maintained in the Retainer Parameters (BR02).	BRIP.1
`HDT-RETAINER-AMT` RETAINER_AMT	Signed 18.2	The invoice amount associated with a retainer invoice type.	BR46.2, BR46.4, BRIP.1
`HDT-SUM-ACCT-CAT` SUM_ACCT_CAT	Alpha 5	The name of the summary account category that is assoicated with the detail account category.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-ADJUST-TYPE` ADJUST_TYPE	Alpha 1	The category of adjustment related to this invoice detail line. The values are: `A` Write up or Down `B` Hold `C` Bill in Advance `D` Transfer `A` Write Up or Down `B` Hold `C` Bill in Advance `D` Transfer	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HDT-ORIG-INVC-AMT` ORIG_INVC_AMT	Signed 18.2	The original invoice amount from the original activity transactions billable amount. Will not be populated on the write up or write down adjustment lines. Used to display the original billable amount on the detail lines in the Invoice Edit (BR20).	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
`HDT-TRANSFER-AMT` TRANSFER_AMT	Signed 18.2	The transfer amount or billable amount being transferred in Transfer Invoice Transaction (BR40.6). Stored in Contract Currency. Only populated when Adjust-Type equals D.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
`HDT-TRANSFER-UNITS` TRANSFER_UNITS	Signed 18.2	The transfer units or billable units being transferred in Transfer Invoice Transaction (BR40.6). Only populated when Adjust-Type equals D.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
`HDT-CTR-CAT-GRP` CTR_CAT_GRP	Alpha 5	—	BR46.1, BR46.2, BR46.4, BRIP.1
`HDT-XREF-HIH-OBJID` XREF_HIH_OBJID	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
`HDT-XREF-LINE-NBR` XREF_LINE_NBR	Numeric 6	This field contains the line number.	BRIP.1
`HDT-GLT-OBJ-ID` GLT_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
`HDT-BILL-ADJ-AMT` BILL_ADJ_AMT	Signed 18.2	—	BR02.3, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2 +2 more
`HDT-UNIT-ADJ-AMT` UNIT_ADJ_AMT	Signed 15.2	—	BR02.3, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BRIP.1
`HDT-GRANT` GRANT	Alpha 30	—	—
`HDT-COST-CLASS` COST_CLASS	Alpha 15	—	—
`HDT-ELIGIBLE` ELIGIBLE	Alpha 1	— `Y` Yes `N` No	—
`HDT-MATCH-FUND` MATCH_FUND	Alpha 30	—	—
`HDT-ATN-BILL-AMT` ATN_BILL_AMT	Signed 18.2	—	—

Indexes (9)

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

Index	Keys	Flags	Used in
`HDTSET1`	`OBJ-ID`, `LINE-NBR`	Primary	BR02.3, BR120, BR121, BR122, BR123, BR140, BR145, BR151 +21 more
`HDTSET2`	`CONTRACT`, `OBJ-ID`, `LINE-NBR`	KeyChange	AC10.1, AC300, BR02.3, BR120, BR121, BR122, BR123, BR131 +12 more
`HDTSET3`	`ATN-OBJ-ID`, `CONTRACT`, `OBJ-ID`, `LINE-NBR`	KeyChange	—
`HDTSET4`	`OBJ-ID`, `TRAN-DATE*`, `LINE-NBR`	KeyChange	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
`HDTSET5`	`OBJ-ID`, `CNSL-LINE-NBR`, `LINE-NBR`	KeyChange	BRIP.1
`HDTSET6`	`OBJ-ID`, `CONTRACT`, `LINE-NBR`	KeyChange	BR120, BR121, BR122, BR123, BR140, BR151, BR152, BR156 +11 more
`HDTSET7`	`OBJ-ID`, `PT-ACTIVITY`, `ACCT-CATEGORY`, `LINE-NBR`	KeyChange	BR121, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2 +1 more
`HDTSET8`	`GLT-OBJ-ID`, `OBJ-ID`, `LINE-NBR`	KeyChange	—
`HDTSET9`	`OBJ-ID`, `LINE-NBR*`, `LINE-TYPE`	KeyChange	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Field map
Accntract	ACCNTRACT	Required	`HDT-CONTRACT` → `CNT-CONTRACT`
Achistcnsl	ACHISTCNSL	Required	`HDT-OBJ-ID` → `IHC-OBJ-ID`, `HDT-CNSL-LINE-NBR` → `IHC-LINE-NBR`
Achisthdr	ACHISTHDR	Required	`HDT-OBJ-ID` → `HIH-OBJ-ID`
Achstdtbod	ACHSTDTBOD	Not Required, Delete Cascades	`HDT-OBJ-ID` → `YAL-OBJ-ID`, `HDT-LINE-NBR` → `YAL-LINE-NBR`
Acreasoncd	ACREASONCD	Required	`HDT-REASON-CODE` → `CDE-REASON-CODE`
Actrans	ACTRANS	Required	`HDT-ATN-OBJ-ID` → `ATN-OBJ-ID`
Gltrans	GLTRANS	Not Required	`HDT-GLT-OBJ-ID` → `GLT-OBJ-ID`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Achisttax	ACHISTTAX			`HDT-OBJ-ID` → `HIT-OBJ-ID`, `HDT-LINE-NBR` → `HIT-HDT-LINE-NBR`, → `HIT-SEQ-NBR`
Acinvaudit	ACINVAUDIT			`HDT-OBJ-ID` → `IVA-OBJ-ID`, `HDT-LINE-NBR` → `IVA-LINE-NBR`, → `IVA-TRANS-DATE`, → `IVA-SEQUENCE-NBR`

Programs

Updated by (25)

BR02.3 Retainer Invoice Entry
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR122 Online batch invoice process
BR123 Product Invoice Cancel
BR131 Revenue Realization
BR140 Billing and Revenue Backout
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR156 Maintenance Quote
BR20.1 Invoice Edit Contract
BR20.2 Invoice Edit Line
BR20.3 Invoice Edit Activity
BR20.4 Invoice Edit Activity and Account Category
BR20.5 Invoice Edit Transaction
BR21.1 Invoice Cancellation
BR300 Invoice Purge
BR420 Billing Invoice Report
BR46.1 Bill in Advance
BR46.2 Transfer Invoice Transaction
BR46.4 Split Transfer
BR49.1 Invoice Adjustment Maintenance
BR521 Billing Import
BR580 Applied Balance Rebuild
BRIP.1 Invoice Print Program

Referenced by (9)

AC10.1 Activity
AC300 Activity Group Purge
BR145 Invoice Control Maintenance
BR16.1 Service Location
BR245 Invoice Control Listing
BR400 Invoice History
BR45.1 Invoice Control
BRBD.2 BR BOD Inquiry
TX101 Journal File Create