ACHISTHDR FILE
REFERENCED BY
BR02.1 BR400 BR420
UPDATED BY
AC300 AC310 BR131 BR21.1 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HIH-COMPANY Numeric 4 BRIP.1
Company The company number represents an
established company and is entered on
all function codes.
HIH-CUSTOMER Alpha 9 (Right Justified) BRIP.1
Customer Number This field contains the number that
represents a customer.
HIH-INVOICE Alpha 22 BRIP.1
Invoice Number Used to identify the invoice.
HIH-INVOICE-PREFIX Alpha 2 BRIP.1
Invoice Prefix
HIH-INVOICE-NBR Numeric 8 BRIP.1
Invoice Nbr
HIH-INVOICE-ID Numeric 6 BRIP.1
Invoice Id
HIH-PROCESS-LEVEL Alpha 5 BRIP.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
HIH-DUE-DATE Numeric 8 (yyyymmdd) BRIP.1
Due Date The transaction due date.
HIH-BILL-TO Numeric 4 BRIP.1
Bill To
HIH-CONTRACT Alpha 10 BRIP.1
Contract
HIH-CONTACT-CODE Alpha 5 BRIP.1
Contact Code
HIH-AR-DETAIL Alpha 1
Ar Detail
HIH-INVOICE-TYPE Alpha 1 BRIP.1
Invoice Type
HIH-INVOICE-DATE Numeric 8 (yyyymmdd) BRIP.1
Invoice Date
HIH-POSTING-DATE Numeric 8 (yyyymmdd) BRIP.1
Posting Date The date assigned to the journal entry
for posting.
HIH-REFERENCE Alpha 10 (Lower Case) BRIP.1
Reference The reference number associated with
the transaction.
HIH-UNITS-AMOUNT Signed 15.2 BRIP.1
Units Amount This is the units amount included in
the file.
HIH-CONTRACT-CURR Alpha 5 BRIP.1
Contract Curr
HIH-CONTRACT-ND Numeric 1 BRIP.1
Contract Nd
HIH-INVC-AMT-TOT Signed 15.2 BRIP.1
Invc Amt Tot
HIH-TAX-AMT-TOT Signed 15.2 BRIP.1
Tax Amt Tot
HIH-RETAIN-AMT Signed 15.2 BRIP.1
Retain Amt
HIH-CUST-PO-NBR Alpha 22 BRIP.1
Customer P.O. Number
HIH-INVC-OPTIONS Alpha 1 BRIP.1
Invc Options
HIH-INVC-FORMAT Alpha 1 BRIP.1
Invc Format
HIH-RETAIN-DESC Alpha 30 BRIP.1
Retain Desc
HIH-CUM-AMT Signed 15.2 BRIP.1
Cum Amt
HIH-CUM-UNIT Signed 15.2 BRIP.1
Cum Unit
HIH-CUM-TAX-AMT Signed 15.2 BRIP.1
Cum Tax Amt
HIH-CUM-RETAIN-AMT Signed 15.2 BRIP.1
Cum Retain Amt
HIH-CUM-FLAG Alpha 1 BRIP.1
Cum Flag
HIH-INVC-SUMM-OPT Alpha 1 BRIP.1
Invc Summ Opt
HIH-EXCEED-AMT Signed 15.2 BRIP.1
Exceed Amt
HIH-EXCEED-UNIT Signed 15.2 BRIP.1
Exceed Unit
HIH-CUM-EXCEED-AMT Signed 15.2 BRIP.1
Cum Exceed Amt
HIH-CUM-EXCEED-UNT Signed 15.2 BRIP.1
Cum Exceed Unt
HIH-RETAINAGE-AMT Signed 15.2 BRIP.1
Retainage Amt
HIH-CUM-RETAINAGE Signed 15.2 BRIP.1
Cum Retainage
HIH-INVC-OPTION-2 Alpha 1 BRIP.1
Invc Option 2
HIH-AC-CUSTOMER-ID Alpha 5 BRIP.1
Ac Customer Id
HIH-WBS-INVC-NBR Numeric 8 BRIP.1
Wbs Invc Nbr
HIH-CUST-NAME Derived
Cust Name
HIH-LOCK-BOX Alpha 2
Lock Box
HIH-XREF-NBR Alpha 22 BR21.1 BRIP.1
Xref Nbr
HIH-BILL-WBS-CODE Alpha 3 BRIP.1
Bill Wbs Code
HIH-EXCEED-OPTION Alpha 1
Exceed Option I = Include
E = Exclude
HIH-REALIZATION-FL Alpha 1 BR131 BR21.1
Realization Fl Y = Yes BRIP.1
N = No
HIH-WBS-XREF-NBR Alpha 22 BRIP.1
Wbs Xref Nbr
ACHISTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIHSET1 CONTRACT AC300 AC310
COMPANY BR02.1 BR131
CUSTOMER BR21.1 BR400
AC-CUSTOMER-ID BR420 BRIP.1
INVOICE-PREFIX
INVOICE-NBR
HIHSET2 CONTRACT KeyChange
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE
HIHSET3 CONTRACT
COMPANY
CUSTOMER
AC-CUSTOMER-ID
WBS-INVC-NBR
INVOICE-PREFIX
INVOICE-NBR
HIHSET4 COMPANY
CUSTOMER
CONTRACT
INVOICE-PREFIX
INVOICE-NBR
AC-CUSTOMER-ID
HIHSET5 INVOICE-PREFIX
INVOICE-NBR
COMPANY
CUSTOMER
AC-CUSTOMER-ID
CONTRACT
ACHISTHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acfeehist ACFEEHIST
HIH-COMPANY -> FHI-COMPANY
HIH-CUSTOMER -> FHI-CUSTOMER
HIH-INVOICE -> FHI-INVOICE
FHI-ACCT-CATEGORY
Achistcnsl ACHISTCNSL
HIH-CONTRACT -> IHC-CONTRACT
HIH-COMPANY -> IHC-COMPANY
HIH-CUSTOMER -> IHC-CUSTOMER
HIH-AC-CUSTOMER-ID -> IHC-AC-CUSTOMER-ID
HIH-INVOICE-PREFIX -> IHC-INVOICE-PREFIX
HIH-INVOICE-NBR -> IHC-INVOICE-NBR
IHC-LINE-NBR
Achistdtl ACHISTDTL
HIH-CONTRACT -> HDT-CONTRACT
HIH-COMPANY -> HDT-COMPANY
HIH-CUSTOMER -> HDT-CUSTOMER
HIH-AC-CUSTOMER-ID -> HDT-AC-CUSTOMER-ID
HIH-INVOICE-PREFIX -> HDT-INVOICE-PREFIX
HIH-INVOICE-NBR -> HDT-INVOICE-NBR
HDT-LINE-NBR
HDT-SEQ-NBR
Acinvaudit ACINVAUDIT
HIH-CONTRACT -> IVA-CONTRACT
HIH-COMPANY -> IVA-COMPANY
HIH-CUSTOMER -> IVA-CUSTOMER
HIH-AC-CUSTOMER-ID -> IVA-AC-CUSTOMER-ID
HIH-INVOICE-PREFIX -> IVA-INVOICE-PREFIX
HIH-INVOICE-NBR -> IVA-INVOICE-NBR
IVA-LINE-NBR
IVA-TRANS-DATE
IVA-SEQUENCE-NBR
|
