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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#HIH-OBJ-ID PK
OBJ_ID		Numeric 12The object identifier. It is a unique number used to relate the invoice Header to the invoice detail lines (ACHISTDTL).BRIP.1
#HIH-COMPANY SET2 SET4 SET5 SET7
COMPANY		Numeric 4Identifies the Accounts Receivable company which is maintained in AR10.BRIP.1
#HIH-CUSTOMER SET2 SET4 SET5 SET7
CUSTOMER		Alpha 9 (Right Justified)Identifies the AR customer associated with the invoice.BRIP.1
#HIH-INVOICE SET2
INVOICE		Alpha 22Used to identify the invoice. Represents the invoice prefix and the invoice number and will be the invoice in AR.BRIP.1
#HIH-INVOICE-PREFIX SET4 SET5 SET6 SET7
INVOICE_PREFIX		Alpha 2The 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 SET4 SET5 SET6 SET7
INVOICE_NBR		Numeric 8The next sequential Accounts Receivable invoice number.BRIP.1
#HIH-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5The 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 4This 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 SET2 SET3 SET4 SET6 SET8 SET9
CONTRACT		Alpha 15The 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 5The 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 1The 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 SET6
INVOICE_TYPE		Alpha 1Indicates 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 5The contract currency code established in Contract (BR10).BRIP.1
#HIH-CURR-ND
CURR_ND		Numeric 1The number of decimals defined for the currency of the object.BRIP.1
#HIH-INVOICE-AMT
INVOICE_AMT		Signed 18.2The 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.2The 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 22The purchase order number maintained in the Contract (BR10).BR20.7, BRIP.1
#HIH-INVC-OPTIONS
INVC_OPTIONS		Alpha 1The 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 1The 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 SET6
RETAIN_ID		Numeric 6The Retainer Sequence maintained on the Retainer Parameters (BR02).BRIP.1
#HIH-RETAIN-DESC
RETAIN_DESC		Alpha 30The retainer description maintained on the Retainer Parameters (BR02).BRIP.1
#HIH-CUM-FLAG
CUM_FLAG		Alpha 1The 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 1The 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 1The 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 SET2
AC_CUSTOMER_ID		Alpha 5The "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 8The 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		DerivedThe name of the customer established on the AR customer group address (AR09).—
#HIH-LOCK-BOX
LOCK_BOX		Alpha 2The lock box code for the invoice company maintained in AR Customer Defaults (AR08).BRIP.1
#HIH-XREF-NBR
XREF_NBR		Alpha 22The 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 3The 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 1The "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 1Flag 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 22The historical combined contract reference number.—
#HIH-STATUS
STATUS		Numeric 1The 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 6The 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 4This 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 3The 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 1The "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.2The 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.2The 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.2The billable amount including transactions, milestones, overage, retention and retainers prior to adjustments.BRIP.1
#HIH-FINAL-INVC-FL
FINAL_INVC_FL		Alpha 1Flag 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.2The cumulative amount of all bill in advance transactions added to the invoice.BR46.1
#HIH-PRE-XFER
PRE_XFER		Signed 18.2The cumulative amount of all the transfer transactions added to or subtracted from the invoice.BR46.2, BR46.4
#HIH-TAX-PRINT
TAX_PRINT		Alpha 1Determines 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 1This 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 SET8 SET9
GRANT		Alpha 30——

Indexes (9)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HIHSET1
  1. OBJ-ID
PrimaryAC300, BR02.3, BR09.1, BR120, BR121, BR122, BR123, BR131 +22 more (list truncated in source)
HIHSET2
  1. CONTRACT
  2. COMPANY
  3. CUSTOMER
  4. AC-CUSTOMER-ID
  5. INVOICE
  6. OBJ-ID
KeyChangeBR02.1, BR121, BR131, BR145, BR245, BR300, BR400, BR420
HIHSET3
  1. CONTRACT
  2. OBJ-ID
KeyChange—
HIHSET4
  1. COMPANY
  2. CUSTOMER
  3. CONTRACT
  4. INVOICE-PREFIX
  5. INVOICE-NBR
  6. OBJ-ID
KeyChangeBR420
HIHSET5
  1. INVOICE-PREFIX
  2. INVOICE-NBR
  3. COMPANY
  4. CUSTOMER
  5. OBJ-ID
KeyChangeBR02.3, BR21.1, BR420
HIHSET6
  1. INVOICE-TYPE
  2. CONTRACT
  3. RETAIN-ID
  4. INVOICE-PREFIX
  5. INVOICE-NBR
  6. OBJ-ID
KeyChangeBR02.1
HIHSET7
  1. COMPANY
  2. CUSTOMER
  3. INVOICE-PREFIX
  4. INVOICE-NBR
  5. OBJ-ID
KeyChangeBR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR20.7, BR45.1, BR46.1 +4 more
HIHSET8
  1. CONTRACT
  2. GRANT
  3. OBJ-ID
—
HIHSET9
  1. GRANT
  2. CONTRACT
  3. OBJ-ID
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACCNTRACTARCOMPARCONTACTSARCUSTOMERAROIHDRARPROCLEVLBILLTOCUSTDESCACHISTCNSLACHISTDTLACHISTGMACHISTTAXACINVAUDITACINVORDACPROADJACHISTHDR

One to one (11) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTNot Required
HIH-CONTRACT→CNT-CONTRACT (CNTSET1)
ArcompARCOMPNot Required
HIH-COMPANY→ACO-COMPANY
ArcontactsARCONTACTSNot Required
HIH-COMPANY→CON-COMPANY
HIH-CUSTOMER→CON-CUSTOMER
HIH-CONTACT-CODE→CON-RESP-CODE
ArcustomerARCUSTOMERNot Required
HIH-COMPANY→ACM-COMPANY
HIH-CUSTOMER→ACM-CUSTOMER
Aroihdr CAROIHDRNot Required
HIH-COMPANY→ARH-COMPANY
"C"→ARH-TRANS-TYPE
HIH-INVOICE→ARH-INVOICE
Aroihdr DAROIHDRNot Required
HIH-COMPANY→ARH-COMPANY
"D"→ARH-TRANS-TYPE
HIH-INVOICE→ARH-INVOICE
Aroihdr IAROIHDRNot Required
HIH-COMPANY→ARH-COMPANY
"I"→ARH-TRANS-TYPE
HIH-INVOICE→ARH-INVOICE
Aroihdr MAROIHDRNot Required
HIH-COMPANY→ARH-COMPANY
"M"→ARH-TRANS-TYPE
HIH-INVOICE→ARH-INVOICE
ArproclevlARPROCLEVLNot Required
HIH-COMPANY→APV-COMPANY
HIH-PROCESS-LEVEL→APV-PROCESS-LEVEL
BilltoBILLTONot Required
ACO-CUST-GROUP→ABS-CUST-GROUP
HIH-CUSTOMER→ABS-CUSTOMER
HIH-BILL-TO→ABS-BILL-TO
CustdescCUSTDESCNot Required
ACO-CUST-GROUP→CUD-CUST-GROUP
HIH-CUSTOMER→CUD-CUSTOMER

One to many (7) — child tables

RelationTableRulesConditionField map
AchistcnslACHISTCNSL
HIH-OBJ-ID→IHC-OBJ-ID
—→IHC-LINE-NBR
AchistdtlACHISTDTL
HIH-OBJ-ID→HDT-OBJ-ID
—→HDT-PT-ACTIVITY
—→HDT-ACCT-CATEGORY
—→HDT-LINE-NBR
AchistgmACHISTGM
HIH-OBJ-ID→IHG-HIH-OBJ-ID
—→IHG-CONTRACT-ACTVY
—→IHG-RECORD-TYPE
—→IHG-ACTIVITY
AchisttaxACHISTTAX
HIH-OBJ-ID→HIT-OBJ-ID
—→HIT-HDT-LINE-NBR
—→HIT-SEQ-NBR
AcinvauditACINVAUDIT
HIH-OBJ-ID→IVA-OBJ-ID
—→IVA-LINE-NBR
—→IVA-TRANS-DATE
—→IVA-SEQUENCE-NBR
AcinvordACINVORD
HIH-OBJ-ID→AIO-HIH-OBJ-ID
—→AIO-CONTRACT
AcproadjACPROADJ
HIH-OBJ-ID→BRJ-HIH-OBJ-ID
—→BRJ-LINE-NBR-MAP
—→BRJ-ADJ-LEVEL
—→BRJ-REASON-CODE

Programs

Updated by (18)

Referenced by (18)