|
|
ACHISTHDR FILE
REFERENCED BY
BR02.1 BR21.1 BR400 BR420 BR900
UPDATED BY
AC300 AC310 BR122 BR131 BR521 BR901
BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HIH-COMPANY Numeric 4 BR521 BRIP.1
Element: Company Identifies the Accounts Receivable
company whcih is maintained in AR!0.
HIH-CUSTOMER Alpha 9 (Right Justified) BR521 BRIP.1
Element: Customer NumbeThe number that represents a customer
which is maintained in BR11.
HIH-INVOICE Alpha 22 BR521 BRIP.1
Element: Invoice NumberUsed to identify the invoice. This
number includes the invoice prefix and
the invoice number.
HIH-INVOICE-PREFIX Alpha 2 BR521 BRIP.1
Element: Invoice PrefixThe Invoice prefix or the Credit Memo
prefix value that is maintained in the
Customer (BR11).
HIH-INVOICE-NBR Numeric 8 BR521 BRIP.1
Element: Invoice Nbr The next sequential Accounts Receivable
invoice number.
HIH-INVOICE-ID Numeric 6 BR521 BRIP.1
Element: Invoice Id ?????
HIH-PROCESS-LEVEL Alpha 5 BR521 BRIP.1
Element: Process Level The process level is the reporting
hierarchy below the invoice Accounts
Receivable company.
HIH-DUE-DATE Numeric 8 (yyyymmdd) BR521 BRIP.1
Element: Date The Invoice Terms Code derived date
maintained in the Accounts Receivable
Customer (AR10).
HIH-BILL-TO Numeric 4 BR521 BRIP.1
Element: Ship-to Code The mailing address for the invoice.
Bill to addresses are maintained in the
Accounts Receivable Bill To (AR09.4).
HIH-CONTRACT Alpha 10 BR521 BRIP.1
Element: Bid Name The invoice contract maintained in
Contract (BR10).
HIH-CONTACT-CODE Alpha 5 BR521 BRIP.1
Element: Contact Code The contact maintained in the invoice
Customer (BR11).
HIH-AR-DETAIL Alpha 1
Element: Ar Detail The AR Interface Option maintained on
the invoice Customer (BR11).
The values are:
S = Summary
D = Detail
HIH-INVOICE-TYPE Alpha 1 BR521 BRIP.1
Element: Invoice Type This field indicates whether the invoice
is a retainer, regular or a cancelled
invoice type.
The values are:
R = Retainer
I = Invoice
B = Invoice Cancel
HIH-INVOICE-DATE Numeric 8 (yyyymmdd) BR521 BRIP.1
Element: Date The date of the invoice which can be
specified on the Invoice Calculation
programs.
HIH-POSTING-DATE Numeric 8 (yyyymmdd) BR521 BRIP.1
Element: Date
HIH-REFERENCE Alpha 10 (Lower Case) BR521 BRIP.1
Element: Requester The reference number associated with
the transaction.
HIH-UNITS-AMOUNT Signed 15.2 BR521 BRIP.1
Element: Adj Amt The total units amount for the invoice.
HIH-CONTRACT-CURR Alpha 5 BR521 BRIP.1
Element: Contract Curr
HIH-CONTRACT-ND Numeric 1 BR521 BRIP.1
Element: Contract Nd
HIH-INVC-AMT-TOT Signed 15.2 BR521 BRIP.1
Element: Invc Amt Tot
HIH-TAX-AMT-TOT Signed 15.2 BR521 BRIP.1
Element: Tax Amt Tot
HIH-RETAIN-AMT Signed 15.2 BR521 BRIP.1
Element: Retain Amt
HIH-CUST-PO-NBR Alpha 22 BR521 BRIP.1
Element: Customer P.O. Number
HIH-INVC-OPTIONS Alpha 1 BR521 BRIP.1
Element: Invc Options
HIH-INVC-FORMAT Alpha 1 BR521 BRIP.1
Element: Invc Format
HIH-RETAIN-DESC Alpha 30 BR521 BRIP.1
Element: Retain Desc
HIH-CUM-AMT Signed 15.2 BR521 BRIP.1
Element: Cum Amt
HIH-CUM-UNIT Signed 15.2 BR521 BRIP.1
Element: Cum Unit
HIH-CUM-TAX-AMT Signed 15.2 BR521 BRIP.1
Element: Cum Tax Amt
HIH-CUM-RETAIN-AMT Signed 15.2 BR521 BRIP.1
Element: Cum Retain Amt
HIH-CUM-FLAG Alpha 1 BR521 BRIP.1
Element: Cum Flag
HIH-INVC-SUMM-OPT Alpha 1 BR521 BRIP.1
Element: Invc Summ Opt
HIH-EXCEED-AMT Signed 15.2 BR521 BRIP.1
Element: Exceed Amt
HIH-EXCEED-UNIT Signed 15.2 BR521 BRIP.1
Element: Exceed Unit
HIH-CUM-EXCEED-AMT Signed 15.2 BR521 BRIP.1
Element: Cum Exceed Amt
HIH-CUM-EXCEED-UNT Signed 15.2 BR521 BRIP.1
Element: Cum Exceed Unt
HIH-RETAINAGE-AMT Signed 15.2 BR521 BRIP.1
Element: Retainage Amt
HIH-CUM-RETAINAGE Signed 15.2 BR521 BRIP.1
Element: Cum Retainage
HIH-INVC-OPTION-2 Alpha 1 BR521 BRIP.1
Element: Invc Option 2
HIH-AC-CUSTOMER-ID Alpha 5 BR521 BRIP.1
Element: Ac Customer Id
HIH-WBS-INVC-NBR Numeric 8 BR521 BRIP.1
Element: Wbs Invc Nbr
HIH-CUST-NAME Derived
Element: Cust Name
HIH-LOCK-BOX Alpha 2
Element: Lock Box
HIH-XREF-NBR Alpha 22 BR122 BR521
Element: Xref Nbr BR901 BRIP.1
HIH-BILL-WBS-CODE Alpha 3 BR521 BRIP.1
Element: Bill Wbs Code
HIH-EXCEED-OPTION Alpha 1
Element: Exceed Option I = Include
E = Exclude
HIH-REALIZATION-FL Alpha 1 BR122 BR131
Element: Realization FlY = Yes BR521 BR901
N = No BRIP.1
HIH-WBS-XREF-NBR Alpha 22 BR521 BRIP.1
Element: Wbs Xref Nbr
ACHISTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIHSET1 CONTRACT AC300 AC310
COMPANY BR02.1 BR122
CUSTOMER BR131 BR21.1
AC-CUSTOMER-ID BR400 BR420
INVOICE-PREFIX BR521 BR900
INVOICE-NBR BR901 BRIP.1
HIHSET2 CONTRACT KeyChange BR900 BR901
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
HDT-SEQ-NBR-2
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
|
