|
|
ACHISTHDR FILE
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
AC300 AC310 BR02.3 BR02.1 BR09.1 BR120
BR121 BR123 BR140 BR151 BR152 BR156
BR16.1 BR21.1 BR220 BR420 BR521 BR580
BR245 BR400
UPDATED BY
BR122 BR131 BR145 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.7 BR45.1 BR46.1 BR46.2
BR46.4 BRIP.1 TX101 BR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HIH-OBJ-ID Numeric 12 BRIP.1
Element: Obj Id The object identifier. It is a unique
number used to relate the invoice Header
to the invoice detail lines
(ACHISTDTL).
HIH-COMPANY Numeric 4 BRIP.1
Element: Company Identifies the Accounts Receivable
company which is maintained in AR10.
HIH-CUSTOMER Alpha 9 (Right Justified) BRIP.1
Element: Customer Identifies the AR customer associated
with the invoice.
HIH-INVOICE Alpha 22 BRIP.1
Element: Invoice Used to identify the invoice. Represents
the invoice prefix and the invoice
number and will be the invoice in AR.
HIH-INVOICE-PREFIX Alpha 2 BRIP.1
Element: Invoice PrefixThe 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 Numeric 8 BRIP.1
Element: Invoice Nbr The next sequential Accounts Receivable
invoice number.
HIH-PROCESS-LEVEL Alpha 5 BRIP.1
Element: Process Level The Accounts Receivable process level,
which is the reporting hierarchy below
the AR Company. Defined in AC Customer
(BR11).
HIH-DUE-DATE Numeric 8 (yyyymmdd) BRIP.1
Element: Due Date The invoice due date, derived from the
"Invoice Terms Code" in Accounts
Receivable Customer (AR10).
HIH-BILL-TO Numeric 4 BR02.3 BR120
Element: Bill To This is the "Bill To" code that BR121 BR122
represents the customers billing BR123 BR140
address. The address will be defaulted BR151 BR152
from the AR Customer address if this BR156 BR20.1
Bill-To code field is not filled in. The BR20.2 BR20.3
Bill To addresses are maintained in the BR20.4 BR20.5
AR Bill To (AR09.4). BR20.7 BR420
BR521 BRIP.1
HIH-CONTRACT Alpha 15 BRIP.1
Element: Contract 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 Alpha 5 BR20.7 BRIP.1
Element: Contact Code The contact code represents the contact
information, this is attached to he AC
Customer in (BR11).
HIH-AR-DETAIL Alpha 1 BRIP.1
Element: Ar Detail 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 Alpha 1 BRIP.1
Element: Invoice Type 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
HIH-INVOICE-DATE Numeric 8 (yyyymmdd) BR20.7 BRIP.1
Element: Invoice Date 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 Numeric 8 (yyyymmdd) BR20.7 BRIP.1
Element: Posting Date 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 Alpha 10 (Lower Case) BRIP.1
Element: Reference 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 Alpha 5 BRIP.1
Element: Currency Code The contract currency code established
in Contract (BR10).
HIH-CURR-ND Numeric 1 BRIP.1
Element: Acct Nd The number of decimals defined for the
currency of the object.
HIH-INVOICE-AMT Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The total invoice amount. BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HIH-UNITS-AMOUNT Signed 15.2 BR20.1 BR20.2
Element: Units Amount The total units for the invoice. BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HIH-CUST-PO-NBR Alpha 22 BR20.7 BRIP.1
Element: Cust Po Nbr The purchase order number maintained in
the Contract (BR10).
HIH-INVC-OPTIONS Alpha 1 BRIP.1
Element: Invc Options 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 = Accountt Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
HIH-INVC-FORMAT Alpha 1 BRIP.1
Element: Invc Format 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 Numeric 6 BRIP.1
Element: Retain Id The Retainer Sequence maintained on the
Retainer Parameters (BR02).
HIH-RETAIN-DESC Alpha 30 BRIP.1
Element: Retain Desc The retainer description maintained on
the Retainer Parameters (BR02).
HIH-CUM-FLAG Alpha 1 BRIP.1
Element: Cum Flag 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 Alpha 1 BRIP.1
Element: Invc Summ Opt 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 Alpha 1 BRIP.1
Element: Invc Option 2 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 Alpha 5 BRIP.1
Element: Ac Customer IdThe "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 Numeric 8 BRIP.1
Element: Wbs Invc Nbr 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 Derived
Element: Cust Name The name of the customer established on
the AR customer group address (AR09).
HIH-LOCK-BOX Alpha 2 BRIP.1
Element: Lock Box The lock box code for the invoice
company maintained in AR Customer
Defaults (AR08).
HIH-XREF-NBR Alpha 22 BRIP.1
Element: Xref Nbr 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 Alpha 3 BRIP.1
Element: Bill Wbs Code 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 Alpha 1 BRIP.1
Element: Exceed Option 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 Alpha 1 BR122 BR131
Element: Realization FlFlag used to determine if the Revenue BRIP.1
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 Alpha 22
Element: Wbs Xref Nbr The historical combined contract
reference number.
HIH-STATUS Numeric 1 BR122 BR145
Element: Status The status of the invoice. BR20.1 BR20.2
The valid values are: BR20.3 BR20.4
0=Unreleased BR20.5 BR45.1
1=Released BRIP.1
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 Numeric 6 BR20.1 BR20.2
Element: Line Nbr The number of the last line item added BR20.3 BR20.4
to the document. It is used to BR20.5 BR46.1
determine what the next line number is BR46.2 BR46.4
when you add another item. BRIP.1
HIH-USER-NAME Alpha 10 (Lower Case) BRIP.1
Element: User The system user name that identifies
who creatd the invoice.
HIH-BILL-TO-GRP Numeric 4 BRIP.1
Element: Bill To Grp 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 Alpha 3 BRIP.1
Element: Cnt Wbs Code 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 Alpha 1 BRIP.1
Element: Fee Exceed OptThe "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 Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The cumulative amount of all adjustment BR20.3 BR20.4
transactions within the invoice. BR20.5 BRIP.1
HIH-PRE-HOLD-AMT Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The cumulative amount of all held BR20.3 BR20.4
transactions within the invoice. BR20.5 BRIP.1
HIH-PRE-BILL-HIST Signed 18.2 BRIP.1
Element: Intl Amt The billable amount including
transactions, milestones, overage,
retention and retainers prior to
adjustments.
HIH-FINAL-INVC-FL Alpha 1 BRIP.1
Element: Final Invc Fl Flag indicating whether the invoice has
been processed final.
The valid values are:
Y=Yes
N=No
Y = Yes
N = No
HIH-PRE-BIA Signed 18.2 BR46.1
Element: Intl Amt The cumulative amount of all bill in
advance transactions added to the
invoice.
HIH-PRE-XFER Signed 18.2 BR46.2 BR46.4
Element: Intl Amt The cumulative amount of all the
transfer transactions added to or
subtracted from the invoice.
HIH-TAX-PRINT Alpha 1 BRIP.1
Element: Tax Print 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 Alpha 1
Element: Hist Flag
HIH-JURIS-CODE Alpha 3 BRIP.1
Element: Juris Code
HIH-TAX-FLAG Alpha 1 TX101
Element: Tax Flag
HIH-INVC-OPTION-3 Alpha 1 BRIP.1
Element: Invc Options A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
HIH-INVC-OPTION-4 Alpha 1 BRIP.1
Element: Invc Options A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
HIH-INVC-OPTION-5 Alpha 1 BRIP.1
Element: Invc Options A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
HIH-TAX-CALC-FLAG Alpha 1 BRIP.1
Element: Tax Calc Flag 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 Alpha 1
Element: Realization FlY = Yes
N = No
" "
ACHISTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIHSET1 OBJ-ID AC300 AC310
BR02.3 BR09.1
BR120 BR121
BR122 BR123
BR131 BR140
BR145 BR151
BR152 BR156
BR16.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR20.6 BR20.7
BR21.1 BR220
BR300 BR420
BR45.1 BR46.1
BR46.2 BR46.4
...
HIHSET2 CONTRACT KeyChange BR121 BR131
COMPANY BR145 BR245
CUSTOMER BR300 BR400
AC-CUSTOMER-ID BR420
INVOICE
OBJ-ID
HIHSET3 CONTRACT KeyChange
OBJ-ID
HIHSET4 COMPANY KeyChange BR420
CUSTOMER
CONTRACT
INVOICE-PREFIX
INVOICE-NBR
OBJ-ID
HIHSET5 INVOICE-PREFIXKeyChange BR02.3 BR21.1
INVOICE-NBR BR420
COMPANY
CUSTOMER
OBJ-ID
HIHSET6 INVOICE-TYPE KeyChange BR02.1
CONTRACT
RETAIN-ID
INVOICE-PREFIX
INVOICE-NBR
OBJ-ID
HIHSET7 COMPANY KeyChange BR20.1 BR20.2
CUSTOMER BR20.3 BR20.4
INVOICE-PREFIX BR20.5 BR20.7
INVOICE-NBR BR300 BR45.1
OBJ-ID BR46.1 BR46.2
BR46.4 TX101
ACHISTHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Not Required
HIH-CONTRACT -> CNT-CONTRACT
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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
