Invoice Header
The Billing and Revenue Invoice Header file contains the control information associated with an invoice. The file is keyed by Obj-ID.
REFERENCED BY
BR120 | BR123 | BR140 | BR151 | BR152 | BR156 |
BR16.1 | BR220 | BR521 | BR580 | AC300 | BR09.1 |
BR02.1 | BR02.3 | BR121 | BR122 | BR131 | BR145 |
BR20.1 | BR20.2 | BR20.3 | BR20.4 | BR20.5 | BR20.7 |
BR21.1 | BR245 | BR300 | BR400 | BR420 | BR45.1 |
BR46.1 | BR46.2 | BR46.4 | BR49.1 | BRIP.1 | 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 |
|
||||||||||||||||||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HIHSET1 |
OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||
HIHSET2 |
CONTRACT COMPANY CUSTOMER AC-CUSTOMER-ID INVOICE OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||
HIHSET3 |
CONTRACT OBJ-ID |
|
|||||||||||||||||||||||||||||||||||||
HIHSET4 |
COMPANY CUSTOMER CONTRACT INVOICE-PREFIX INVOICE-NBR OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||
HIHSET5 |
INVOICE-PREFIX INVOICE-NBR COMPANY CUSTOMER OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||
HIHSET6 |
INVOICE-TYPE CONTRACT RETAIN-ID INVOICE-PREFIX INVOICE-NBR OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||
HIHSET7 |
COMPANY CUSTOMER INVOICE-PREFIX INVOICE-NBR OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||
HIHSET8 |
CONTRACT GRANT OBJ-ID |
|
|||||||||||||||||||||||||||||||||||||
HIHSET9 |
GRANT CONTRACT OBJ-ID |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Accntract | ACCNTRACT |
Not Required
| |||||||||
Arcomp | ARCOMP |
Not Required
| |||||||||
Arcontacts | ARCONTACTS |
Not Required
| |||||||||
Arcustomer | ARCUSTOMER |
Not Required
| |||||||||
Aroihdr C | AROIHDR |
Not Required
| |||||||||
Aroihdr D | AROIHDR |
Not Required
| |||||||||
Aroihdr I | AROIHDR |
Not Required
| |||||||||
Aroihdr M | AROIHDR |
Not Required
| |||||||||
Arproclevl | ARPROCLEVL |
Not Required
| |||||||||
Billto | BILLTO |
Not Required
| |||||||||
Custdesc | CUSTDESC |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Achistcnsl | ACHISTCNSL |
| ||||||||||||
Achistdtl | ACHISTDTL |
| ||||||||||||
Achistgm | ACHISTGM |
| ||||||||||||
Achisttax | ACHISTTAX |
| ||||||||||||
Acinvaudit | ACINVAUDIT |
| ||||||||||||
Acinvord | ACINVORD |
| ||||||||||||
Acproadj | ACPROADJ |
|
All trademarks and registered trademarks are the property of their
respective owners.