ACHISTHDR – Invoice Header

System: AC Billing Revenue (BR)
Prefix: HIH
Primary key: OBJ-ID
Fields: 59
Updated by: 18 programs
Referenced by: 18 programs

ACHISTHDR is the Invoice Header table in Lawson AC Billing Revenue (prefix HIH). It is indexed by OBJ-ID (HIHSET1); alternate indexes: HIHSET2, HIHSET3, HIHSET4, HIHSET5, HIHSET6, HIHSET7, HIHSET8 and HIHSET9. It is related 1:1 to ACCNTRACT, ARCOMP, ARCONTACTS, ARCUSTOMER, AROIHDR, ARPROCLEVL, BILLTO and CUSTDESC and 1:M to ACHISTCNSL, ACHISTDTL, ACHISTGM, ACHISTTAX, ACINVAUDIT, ACINVORD and ACPROADJ. It is updated by BR122, BR131, BR145, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 and 10 more and referenced by AC300, BR02.1, BR02.3, BR09.1, BR120, BR121, BR123, BR140 and 10 more. The table has 59 fields, 9 indexes and 18 documented relations.

About ACHISTHDR

The Billing and Revenue Invoice Header file contains the control information associated with an invoice. The file is keyed by Obj-ID.

Fields (59)

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

Field / column	Type	Description & values	Updated by
`HIH-OBJ-ID` PK OBJ_ID	Numeric 12	The object identifier. It is a unique number used to relate the invoice Header to the invoice detail lines (ACHISTDTL).	BRIP.1
`HIH-COMPANY` COMPANY	Numeric 4	Identifies the Accounts Receivable company which is maintained in AR10.	BRIP.1
`HIH-CUSTOMER` CUSTOMER	Alpha 9 (Right Justified)	Identifies the AR customer associated with the invoice.	BRIP.1
`HIH-INVOICE` INVOICE	Alpha 22	Used to identify the invoice. Represents the invoice prefix and the invoice number and will be the invoice in AR.	BRIP.1
`HIH-INVOICE-PREFIX` INVOICE_PREFIX	Alpha 2	The Invoice Prefix or the Credit Memo Prefix value that is maintained in the AC Customer (BR11). This must be unique by system code and company.	BRIP.1
`HIH-INVOICE-NBR` INVOICE_NBR	Numeric 8	The next sequential Accounts Receivable invoice number.	BRIP.1
`HIH-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	The Accounts Receivable process level, which is the reporting hierarchy below the AR Company. Defined in AC Customer (BR11).	BRIP.1
`HIH-DUE-DATE` DUE_DATE	Numeric 8 (yyyymmdd)	The invoice due date, derived from the "Invoice Terms Code" in Accounts Receivable Customer (AR10).	BR20.7, BRIP.1
`HIH-BILL-TO` BILL_TO	Numeric 4	This is the "Bill To" code that represents the customers billing address. The address will be defaulted from the AR Customer address if this Bill-To code field is not filled in. The Bill To addresses are maintained in the AR Bill To (AR09.4).	BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +10 more
`HIH-CONTRACT` CONTRACT	Alpha 15	The contract maintained on Contract (BR10). This field is blank if the invoice combines multiple contracts or the invoice is created using the Single Invoice Calculation (BR19).	BRIP.1
`HIH-CONTACT-CODE` CONTACT_CODE	Alpha 5	The contact code represents the contact information, this is attached to he AC Customer in (BR11).	BR20.7, BRIP.1
`HIH-AR-DETAIL` AR_DETAIL	Alpha 1	The AR Interface Option maintained on the AC Customer (BR11). The valid values are: `S` Summary `D` Detail `A` Activity `S` Summary `D` Detail `A` Activity/Acct Cat	BRIP.1
`HIH-INVOICE-TYPE` INVOICE_TYPE	Alpha 1	Indicates whether the invoice is a retainer, regular or cancelled invoice. The values are: `R` Retainer `I` Invoice `B` Invoice Cancel `R` Retainer `I` Invoice `B` Invoice Cancel `C` Auto generated retainer credit `F` Non Grant Fund	BRIP.1
`HIH-INVOICE-DATE` INVOICE_DATE	Numeric 8 (yyyymmdd)	The date of the invoice, which is defined on the BR19 or BR120 programs. If not entered in these programs then the Through Date will default. If the Through date is left blank the system date will default.	BR20.7, BRIP.1
`HIH-POSTING-DATE` POSTING_DATE	Numeric 8 (yyyymmdd)	The date assigned to the journal entry for posting. This date will be defaulted from the Through Date on the BR19 or BR120 forms, or if the Through Date is left blank the system date will default.	BR20.7, BRIP.1
`HIH-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	This is filled with the program token that created the record. They can only be BR02, BR19, BR21, BR45, BR120, BR121 and BR140.	BRIP.1
`HIH-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	The contract currency code established in Contract (BR10).	BRIP.1
`HIH-CURR-ND` CURR_ND	Numeric 1	The number of decimals defined for the currency of the object.	BRIP.1
`HIH-INVOICE-AMT` INVOICE_AMT	Signed 18.2	The total invoice amount.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIH-UNITS-AMOUNT` UNITS_AMOUNT	Signed 15.2	The total units for the invoice.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIH-CUST-PO-NBR` CUST_PO_NBR	Alpha 22	The purchase order number maintained in the Contract (BR10).	BR20.7, BRIP.1
`HIH-INVC-OPTIONS` INVC_OPTIONS	Alpha 1	The first Summarize by option maintained on the AC Customer (BR11). The valid values are: `A` Account Category `B` Summary Acct Cat `C` Attribute `D` Resource `A` Account Category `B` Contract Category Group `C` Attribute `D` Resource `E` Summary Account Category `F` Cost Classification	BRIP.1
`HIH-INVC-FORMAT` INVC_FORMAT	Alpha 1	The Invoice Format option maintained on the AC Customer (BR11). The valid values are: `S` Standard `C` Customized `F` Fax with Standard `E` EDI with Standard `S` Standard `C` Customized `F` Fax `E` EDI `V` Custom Vat	BRIP.1
`HIH-RETAIN-ID` RETAIN_ID	Numeric 6	The Retainer Sequence maintained on the Retainer Parameters (BR02).	BRIP.1
`HIH-RETAIN-DESC` RETAIN_DESC	Alpha 30	The retainer description maintained on the Retainer Parameters (BR02).	BRIP.1
`HIH-CUM-FLAG` CUM_FLAG	Alpha 1	The Cumlative Totals flag maintained on the AC Customer (BR11). This tells us whether or not the cumulative totals are to be displayed on the invoice. The valid values are: `Y` Yes `N` No	BRIP.1
`HIH-INVC-SUMM-OPT` INVC_SUMM_OPT	Alpha 1	The Invoice Print Option maintained on the AC Customer (BR11). The valid values are: `D` Detail `S` Summary `D` Detail `S` Summary	BRIP.1
`HIH-INVC-OPTION-2` INVC_OPTION_2	Alpha 1	The second Summarize by option maintained on the AC Customer (BR11). The valid values are: `A` Account Category `B` Summary Acct Cat `C` Attribute `D` Resource `A` Account Category `B` Contract Category Group `C` Attribute `D` Resource `E` Summary Account Category	BRIP.1
`HIH-AC-CUSTOMER-ID` AC_CUSTOMER_ID	Alpha 5	The "Customer Invoice Option" established on the AC Customer(BR11), and attached to the Contract on the Contract parameters (BR10). This option stores the AC Customer information for processing an invoice. Only one option can be attached to each contract on the BR10. When creating a combined contract invoice in the Single Calculation (BR19) with different options, the user must specify one option for the invoice.	BRIP.1
`HIH-WBS-INVC-NBR` WBS_INVC_NBR	Numeric 8	The sequential invoice number for the invoice group (BILLl-WBS-CODE) maintained on the Activity (AC10). Used by Gov't Contractors to keep invoices sequentially numbered when billing different posting activities separately within a contract.	BRIP.1
`HIH-CUST-NAME` CUST_NAME	Derived	The name of the customer established on the AR customer group address (AR09).	—
`HIH-LOCK-BOX` LOCK_BOX	Alpha 2	The lock box code for the invoice company maintained in AR Customer Defaults (AR08).	BRIP.1
`HIH-XREF-NBR` XREF_NBR	Alpha 22	The original invoice number for a cancelled or deleted invoice or credit memo. Used to map the original invoice to the invoice created for a cancel or delete.	BRIP.1
`HIH-BILL-WBS-CODE` BILL_WBS_CODE	Alpha 3	The Invoice Group identified on the Activity (AC10) for the posting level activity. This is for creating separate invoices by activity group. Related to the WBS-INVC-NBR field.	BRIP.1
`HIH-EXCEED-OPTION` EXCEED_OPTION	Alpha 1	The "Ceiling Overage" option indicated on the AC Customer (BR11). The valid values are: `I` Include `E` Exclude `I` Include `E` Exclude	BRIP.1
`HIH-REALIZATION-FL` REALIZATION_FL	Alpha 1	Flag used to determine if the Revenue Realization (BR131) program has been run for these invoices. The valid values are: `Y` Yes `N` No `Y` Yes `N` No	BR122, BR131, BRIP.1
`HIH-WBS-XREF-NBR` WBS_XREF_NBR	Alpha 22	The historical combined contract reference number.	—
`HIH-STATUS` STATUS	Numeric 1	The status of the invoice. The valid values are: `0` Unreleased `1` Released `2` Pending Approval `3` Processed `4` Cancelled `5` Invoice Delete `0` Unreleased `1` Released `2` Pending Approval `3` Processed `4` Cancelled `5` Invoice Delete	BR122, BR145, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR45.1 +2 more
`HIH-LAST-LINE-NBR` LAST_LINE_NBR	Numeric 6	The number of the last line item added to the document. It is used to determine what the next line number is when you add another item.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIH-USER-NAME` USER_NAME	Alpha 10 (Lower Case)	The system user name that identifies who creatd the invoice.	BRIP.1
`HIH-BILL-TO-GRP` BILL_TO_GRP	Numeric 4	This is the "Bill to Group" maintained on the AC Customer (BR11). It represents the Bill to Group that is attached to the customer. It will print multiple invoices with different bill to addresses. It will only be used when using the "Custom Invoice" option.	BRIP.1
`HIH-CNT-WBS-CODE` CNT_WBS_CODE	Alpha 3	The Invoice Group associated with the Contract Activity. This is used to combine invoices across contracts. The invoice group must be set up with the Combine Contracts flag set to Y=Yes on the Invoice Groups (BR06).	BRIP.1
`HIH-FEE-EXCEED-OPT` FEE_EXCEED_OPT	Alpha 1	The "Fee Ceiling Overage" option maintained on the AC Customer (BR11). The valid values are: `I` Include `E` Exclude `I` Include `E` Exclude	BRIP.1
`HIH-PRE-ADJUST-AMT` PRE_ADJUST_AMT	Signed 18.2	The cumulative amount of all adjustment transactions within the invoice.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
`HIH-PRE-HOLD-AMT` PRE_HOLD_AMT	Signed 18.2	The cumulative amount of all held transactions within the invoice.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5
`HIH-PRE-BILL-HIST` PRE_BILL_HIST	Signed 18.2	The billable amount including transactions, milestones, overage, retention and retainers prior to adjustments.	BRIP.1
`HIH-FINAL-INVC-FL` FINAL_INVC_FL	Alpha 1	Flag indicating whether the invoice has been processed final. The valid values are: `Y` Yes `N` No `Y` Yes `N` No	BRIP.1
`HIH-PRE-BIA` PRE_BIA	Signed 18.2	The cumulative amount of all bill in advance transactions added to the invoice.	BR46.1
`HIH-PRE-XFER` PRE_XFER	Signed 18.2	The cumulative amount of all the transfer transactions added to or subtracted from the invoice.	BR46.2, BR46.4
`HIH-TAX-PRINT` TAX_PRINT	Alpha 1	Determines how to summarize the tax codes/amounts on the invoice. This is maintained on the AC Customer (BR11). The valid values are: `M` Multiple sum by code/level `S` Single tax line `M` Multiple sum by code/level `S` Single tax line	BRIP.1
`HIH-HIST-FLAG` HIST_FLAG	Alpha 1	—	—
`HIH-JURIS-CODE` JURIS_CODE	Alpha 3	—	BRIP.1
`HIH-TAX-FLAG` TAX_FLAG	Alpha 1	—	TX101
`HIH-INVC-OPTION-3` INVC_OPTION_3	Alpha 1	— `A` Account Category `B` Contract Category Group `C` Attribute `D` Resource `E` Summary Account Category	BRIP.1
`HIH-INVC-OPTION-4` INVC_OPTION_4	Alpha 1	— `A` Account Category `B` Contract Category Group `C` Attribute `D` Resource `E` Summary Account Category	BRIP.1
`HIH-INVC-OPTION-5` INVC_OPTION_5	Alpha 1	— `A` Account Category `B` Contract Category Group `C` Attribute `D` Resource `E` Summary Account Category	BRIP.1
`HIH-TAX-CALC-FLAG` TAX_CALC_FLAG	Alpha 1	This flag determines whether tax will be calculated at a detail level or summary level. If calculated at a detail level, tax amounts will be calculated separately for each invoice line. If calculated at a summary level, taxable amount for a tax code for the whole invoice will be determined, and tax will be calculated on that summarized taxable amount. `1` Detail `2` Summary	BRIP.1
`HIH-PRO-ADJ-FL` PRO_ADJ_FL	Alpha 1	" " `Y` Yes `N` No	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +2 more
`HIH-GRANT` GRANT	Alpha 30	—	—

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
`HIHSET1`	`OBJ-ID`	Primary	AC300, BR02.3, BR09.1, BR120, BR121, BR122, BR123, BR131 +22 more (list truncated in source)
`HIHSET2`	`CONTRACT`, `COMPANY`, `CUSTOMER`, `AC-CUSTOMER-ID`, `INVOICE`, `OBJ-ID`	KeyChange	BR02.1, BR121, BR131, BR145, BR245, BR300, BR400, BR420
`HIHSET3`	`CONTRACT`, `OBJ-ID`	KeyChange	—
`HIHSET4`	`COMPANY`, `CUSTOMER`, `CONTRACT`, `INVOICE-PREFIX`, `INVOICE-NBR`, `OBJ-ID`	KeyChange	BR420
`HIHSET5`	`INVOICE-PREFIX`, `INVOICE-NBR`, `COMPANY`, `CUSTOMER`, `OBJ-ID`	KeyChange	BR02.3, BR21.1, BR420
`HIHSET6`	`INVOICE-TYPE`, `CONTRACT`, `RETAIN-ID`, `INVOICE-PREFIX`, `INVOICE-NBR`, `OBJ-ID`	KeyChange	BR02.1
`HIHSET7`	`COMPANY`, `CUSTOMER`, `INVOICE-PREFIX`, `INVOICE-NBR`, `OBJ-ID`	KeyChange	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR20.7, BR45.1, BR46.1 +4 more
`HIHSET8`	`CONTRACT`, `GRANT`, `OBJ-ID`		—
`HIHSET9`	`GRANT`, `CONTRACT`, `OBJ-ID`		—

Relations

One to one (11) — lookups and parents

Relation	Table	Rules	Field map
Accntract	ACCNTRACT	Not Required	`HIH-CONTRACT` → `CNT-CONTRACT (CNTSET1)`
Arcomp	ARCOMP	Not Required	`HIH-COMPANY` → `ACO-COMPANY`
Arcontacts	ARCONTACTS	Not Required	`HIH-COMPANY` → `CON-COMPANY`, `HIH-CUSTOMER` → `CON-CUSTOMER`, `HIH-CONTACT-CODE` → `CON-RESP-CODE`
Arcustomer	ARCUSTOMER	Not Required	`HIH-COMPANY` → `ACM-COMPANY`, `HIH-CUSTOMER` → `ACM-CUSTOMER`
Aroihdr C	AROIHDR	Not Required	`HIH-COMPANY` → `ARH-COMPANY`, `"C"` → `ARH-TRANS-TYPE`, `HIH-INVOICE` → `ARH-INVOICE`
Aroihdr D	AROIHDR	Not Required	`HIH-COMPANY` → `ARH-COMPANY`, `"D"` → `ARH-TRANS-TYPE`, `HIH-INVOICE` → `ARH-INVOICE`
Aroihdr I	AROIHDR	Not Required	`HIH-COMPANY` → `ARH-COMPANY`, `"I"` → `ARH-TRANS-TYPE`, `HIH-INVOICE` → `ARH-INVOICE`
Aroihdr M	AROIHDR	Not Required	`HIH-COMPANY` → `ARH-COMPANY`, `"M"` → `ARH-TRANS-TYPE`, `HIH-INVOICE` → `ARH-INVOICE`
Arproclevl	ARPROCLEVL	Not Required	`HIH-COMPANY` → `APV-COMPANY`, `HIH-PROCESS-LEVEL` → `APV-PROCESS-LEVEL`
Billto	BILLTO	Not Required	`ACO-CUST-GROUP` → `ABS-CUST-GROUP`, `HIH-CUSTOMER` → `ABS-CUSTOMER`, `HIH-BILL-TO` → `ABS-BILL-TO`
Custdesc	CUSTDESC	Not Required	`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `HIH-CUSTOMER` → `CUD-CUSTOMER`

One to many (7) — child tables

Relation	Table	Field map
Achistcnsl	ACHISTCNSL	`HIH-OBJ-ID` → `IHC-OBJ-ID`, → `IHC-LINE-NBR`
Achistdtl	ACHISTDTL	`HIH-OBJ-ID` → `HDT-OBJ-ID`, → `HDT-PT-ACTIVITY`, → `HDT-ACCT-CATEGORY`, → `HDT-LINE-NBR`
Achistgm	ACHISTGM	`HIH-OBJ-ID` → `IHG-HIH-OBJ-ID`, → `IHG-CONTRACT-ACTVY`, → `IHG-RECORD-TYPE`, → `IHG-ACTIVITY`
Achisttax	ACHISTTAX	`HIH-OBJ-ID` → `HIT-OBJ-ID`, → `HIT-HDT-LINE-NBR`, → `HIT-SEQ-NBR`
Acinvaudit	ACINVAUDIT	`HIH-OBJ-ID` → `IVA-OBJ-ID`, → `IVA-LINE-NBR`, → `IVA-TRANS-DATE`, → `IVA-SEQUENCE-NBR`
Acinvord	ACINVORD	`HIH-OBJ-ID` → `AIO-HIH-OBJ-ID`, → `AIO-CONTRACT`
Acproadj	ACPROADJ	`HIH-OBJ-ID` → `BRJ-HIH-OBJ-ID`, → `BRJ-LINE-NBR-MAP`, → `BRJ-ADJ-LEVEL`, → `BRJ-REASON-CODE`

Programs

Updated by (18)

BR122 Online batch invoice process
BR131 Revenue Realization
BR145 Invoice Control Maintenance
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
BR20.7 Invoice Header
BR300 Invoice Purge
BR420 Billing Invoice Report
BR45.1 Invoice Control
BR46.1 Bill in Advance
BR46.2 Transfer Invoice Transaction
BR46.4 Split Transfer
BR49.1 Invoice Adjustment Maintenance
BRIP.1 Invoice Print Program
TX101 Journal File Create

Referenced by (18)

AC300 Activity Group Purge
BR02.1 Retainer Parameters
BR02.3 Retainer Invoice Entry
BR09.1 Jurisdiction Codes
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR123 Product Invoice Cancel
BR140 Billing and Revenue Backout
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR156 Maintenance Quote
BR16.1 Service Location
BR21.1 Invoice Cancellation
BR220 Invoice Audit Listing
BR245 Invoice Control Listing
BR400 Invoice History
BR521 Billing Import
BR580 Applied Balance Rebuild