ACHISTHDR

Invoice Header

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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HIH-OBJ-ID
Element: Obj Id
Numeric 12
The object identifier. It is a unique number used to relate the invoice Header to the invoice detail lines (ACHISTDTL).
HIH-COMPANY
Element: Company
Numeric 4
Identifies the Accounts Receivable company which is maintained in AR10.
HIH-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Identifies the AR customer associated with the invoice.
HIH-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice. Represents the invoice prefix and the invoice number and will be the invoice in AR.
HIH-INVOICE-PREFIX
Element: 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.
HIH-INVOICE-NBR
Element: Invoice Nbr
Numeric 8
The next sequential Accounts Receivable invoice number.
HIH-PROCESS-LEVEL
Element: Process Level
Alpha 5
The Accounts Receivable process level, which is the reporting hierarchy below the AR Company. Defined in AC Customer (BR11).
HIH-DUE-DATE
Element: Due Date
Numeric 8 (yyyymmdd)
The invoice due date, derived from the "Invoice Terms Code" in Accounts Receivable Customer (AR10).
HIH-BILL-TO
Element: 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).
HIH-CONTRACT
Element: 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).
HIH-CONTACT-CODE
Element: Contact Code
Alpha 5
The contact code represents the contact information, this is attached to he AC Customer in (BR11).
HIH-AR-DETAIL
Element: 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
HIH-INVOICE-TYPE
Element: 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
HIH-INVOICE-DATE
Element: 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.
HIH-POSTING-DATE
Element: 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.
HIH-REFERENCE
Element: 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.
HIH-CURRENCY-CODE
Element: Currency Code
Alpha 5
The contract currency code established in Contract (BR10).
HIH-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals defined for the currency of the object.
HIH-INVOICE-AMT
Element: Intl Amt
Signed 18.2
The total invoice amount.
HIH-UNITS-AMOUNT
Element: Units Amount
Signed 15.2
The total units for the invoice.
HIH-CUST-PO-NBR
Element: Cust Po Nbr
Alpha 22
The purchase order number maintained in the Contract (BR10).
HIH-INVC-OPTIONS
Element: 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
HIH-INVC-FORMAT
Element: 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
HIH-RETAIN-ID
Element: Retain Id
Numeric 6
The Retainer Sequence maintained on the Retainer Parameters (BR02).
HIH-RETAIN-DESC
Element: Retain Desc
Alpha 30
The retainer description maintained on the Retainer Parameters (BR02).
HIH-CUM-FLAG
Element: 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
HIH-INVC-SUMM-OPT
Element: 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
HIH-INVC-OPTION-2
Element: 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
HIH-AC-CUSTOMER-ID
Element: 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.
HIH-WBS-INVC-NBR
Element: 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.
HIH-CUST-NAME
Element: Cust Name
Derived
The name of the customer established on the AR customer group address (AR09).
HIH-LOCK-BOX
Element: Lock Box
Alpha 2
The lock box code for the invoice company maintained in AR Customer Defaults (AR08).
HIH-XREF-NBR
Element: 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.
HIH-BILL-WBS-CODE
Element: 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.
HIH-EXCEED-OPTION
Element: 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
HIH-REALIZATION-FL
Element: 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
HIH-WBS-XREF-NBR
Element: Wbs Xref Nbr
Alpha 22
The historical combined contract reference number.
HIH-STATUS
Element: 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
HIH-LAST-LINE-NBR
Element: 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.
HIH-USER-NAME
Element: User
Alpha 10 (Lower Case)
The system user name that identifies who creatd the invoice.
HIH-BILL-TO-GRP
Element: 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.
HIH-CNT-WBS-CODE
Element: 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).
HIH-FEE-EXCEED-OPT
Element: 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
HIH-PRE-ADJUST-AMT
Element: Intl Amt
Signed 18.2
The cumulative amount of all adjustment transactions within the invoice.
HIH-PRE-HOLD-AMT
Element: Intl Amt
Signed 18.2
The cumulative amount of all held transactions within the invoice.
HIH-PRE-BILL-HIST
Element: Intl Amt
Signed 18.2
The billable amount including transactions, milestones, overage, retention and retainers prior to adjustments.
HIH-FINAL-INVC-FL
Element: 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
HIH-PRE-BIA
Element: Intl Amt
Signed 18.2
The cumulative amount of all bill in advance transactions added to the invoice.
HIH-PRE-XFER
Element: Intl Amt
Signed 18.2
The cumulative amount of all the transfer transactions added to or subtracted from the invoice.
HIH-TAX-PRINT
Element: 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
HIH-HIST-FLAG
Element: Hist Flag
Alpha 1
HIH-JURIS-CODE
Element: Juris Code
Alpha 3
HIH-TAX-FLAG
Element: Tax Flag
Alpha 1
TX101
HIH-INVC-OPTION-3
Element: Invc Options
Alpha 1

A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
HIH-INVC-OPTION-4
Element: Invc Options
Alpha 1

A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
HIH-INVC-OPTION-5
Element: Invc Options
Alpha 1

A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
HIH-TAX-CALC-FLAG
Element: 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
HIH-PRO-ADJ-FL
Element: Realization Fl
Alpha 1

Y = Yes
N = No
" "
HIH-GRANT
Element: Grant
Alpha 30


ACHISTHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIHSET1 OBJ-ID
TX101
HIHSET2 CONTRACT
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE
OBJ-ID
KeyChange
HIHSET3 CONTRACT
OBJ-ID
KeyChange
HIHSET4 COMPANY
CUSTOMER
CONTRACT
INVOICE-PREFIX
INVOICE-NBR
OBJ-ID
KeyChange
HIHSET5 INVOICE-PREFIX
INVOICE-NBR
COMPANY
CUSTOMER
OBJ-ID
KeyChange
HIHSET6 INVOICE-TYPE
CONTRACT
RETAIN-ID
INVOICE-PREFIX
INVOICE-NBR
OBJ-ID
KeyChange
HIHSET7 COMPANY
CUSTOMER
INVOICE-PREFIX
INVOICE-NBR
OBJ-ID
KeyChange
TX101
HIHSET8 CONTRACT
GRANT
OBJ-ID
HIHSET9 GRANT
CONTRACT
OBJ-ID


ACHISTHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


ACHISTHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Achistdtl ACHISTDTL
HIH-OBJ-ID->HDT-OBJ-ID
  HDT-PT-ACTIVITY
  HDT-ACCT-CATEGORY
  HDT-LINE-NBR
Achisttax ACHISTTAX
HIH-OBJ-ID->HIT-OBJ-ID
  HIT-HDT-LINE-NBR
  HIT-SEQ-NBR


File created: Wed Jun 08 20:48:20 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.