ACINVHDR FILE
REFERENCED BY
BR121 BR420
UPDATED BY
AC300 AC310 BR02.3 BR120 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IVH-COMPANY Numeric 4 BR02.3 BR120
Company The company number represents an
established company and is entered on
all function codes.
IVH-CUSTOMER Alpha 9 (Right Justified) BR02.3 BR120
Customer Number This field contains the number that
represents a customer.
IVH-INVOICE-PREFIX Alpha 2 BR02.3 BR120
Invoice Prefix
IVH-INVOICE-NBR Numeric 8 BR02.3 BR120
Invoice Nbr
IVH-PROCESS-LEVEL Alpha 5 BR02.3 BR120
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
IVH-RETAIN-ID Numeric 6 BR02.3
Retain Id
IVH-INVOICE-ID Numeric 6 BR02.3 BR120
Invoice Id
IVH-CONTRACT Alpha 10 BR02.3 BR120
Contract
IVH-INVOICE-DATE Numeric 8 (yyyymmdd) BR02.3 BR120
Invoice Date
IVH-POSTING-DATE Numeric 8 (yyyymmdd) BR02.3 BR120
Posting Date The date assigned to the journal entry
for posting.
IVH-REFERENCE Alpha 10 (Lower Case) BR02.3 BR120
Reference The reference number associated with
the transaction.
IVH-BILL-TO Numeric 4 BR02.3 BR120
Bill To
IVH-CONTACT-CODE Alpha 5 BR02.3 BR120
Contact Code
IVH-CUST-PO-NBR Alpha 22 BR02.3 BR120
Customer P.O. Number
IVH-LAST-LINE-NBR Numeric 6
Last Line Number This field contains 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.
IVH-UNITS-AMOUNT Signed 15.2 BR120
Units Amount This is the units amount included in
the file.
IVH-CONTRACT-CURR Alpha 5 BR02.3 BR120
Contract Curr
IVH-CONTRACT-ND Numeric 1 BR02.3 BR120
Contract Nd
IVH-INVC-AMT-TOT Signed 15.2 BR02.3 BR120
Invc Amt Tot
IVH-TAX-AMT-TOT Signed 15.2 BR120
Tax Amt Tot
IVH-STATUS Numeric 1 BR02.3 BR120
Status This field displays the status of the
transaction.
0 = Unreleased
1 = Released
2 = Retainer
9 = Delete
IVH-AC-CUSTOMER-ID Alpha 5 BR02.3 BR120
Ac Customer Id
IVH-CUMULATIVE-FL Alpha 1 BR02.3 BR120
Cumulative Fl
IVH-WBS-INVC-NBR Numeric 8
Wbs Invc Nbr
IVH-CUST-NAME Derived
Cust Name
IVH-LOCK-BOX Alpha 2
Lock Box
IVH-BILL-WBS-CODE Alpha 3 BR02.3 BR120
Bill Wbs Code
ACINVHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IVHSET1 CONTRACT AC300 AC310
COMPANY BR02.3 BR121
CUSTOMER BR420 BRIP.1
AC-CUSTOMER-ID
INVOICE-PREFIX
INVOICE-NBR
IVHSET2 CONTRACT
COMPANY
CUSTOMER
AC-CUSTOMER-ID
WBS-INVC-NBR
INVOICE-PREFIX
INVOICE-NBR
IVHSET3 CONTRACT BR02.1 BR02.3
COMPANY
CUSTOMER
AC-CUSTOMER-ID
RETAIN-ID
INVOICE-PREFIX
INVOICE-NBR
IVHSET4 COMPANY
CUSTOMER
CONTRACT
INVOICE-PREFIX
INVOICE-NBR
AC-CUSTOMER-ID
ACINVHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
IVH-CONTRACT -> CNT-CONTRACT (CNTSET1)
Arcomp ARCOMP Not Required
IVH-COMPANY -> ACO-COMPANY
Arcontacts ARCONTACTS Not Required
IVH-COMPANY -> CON-COMPANY
IVH-CUSTOMER -> CON-CUSTOMER
IVH-CONTACT-CODE -> CON-RESP-CODE
Arcustomer ARCUSTOMER Not Required
IVH-COMPANY -> ACM-COMPANY
IVH-CUSTOMER -> ACM-CUSTOMER
Arproclevl ARPROCLEVL Not Required
IVH-COMPANY -> APV-COMPANY
IVH-PROCESS-LEVEL -> APV-PROCESS-LEVEL
Billto BILLTO Not Required
ACO-CUST-GROUP -> ABS-CUST-GROUP
IVH-CUSTOMER -> ABS-CUSTOMER
IVH-BILL-TO -> ABS-BILL-TO
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
IVH-CUSTOMER -> CUD-CUSTOMER
ACINVHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acinvaudit ACINVAUDIT
IVH-CONTRACT -> IVA-CONTRACT
IVH-COMPANY -> IVA-COMPANY
IVH-CUSTOMER -> IVA-CUSTOMER
IVH-AC-CUSTOMER-ID -> IVA-AC-CUSTOMER-ID
IVH-INVOICE-PREFIX -> IVA-INVOICE-PREFIX
IVH-INVOICE-NBR -> IVA-INVOICE-NBR
IVA-LINE-NBR
IVA-TRANS-DATE
IVA-SEQUENCE-NBR
Acinvdtl ACINVDTL
IVH-CONTRACT -> IVD-CONTRACT
IVH-COMPANY -> IVD-COMPANY
IVH-CUSTOMER -> IVD-CUSTOMER
IVH-AC-CUSTOMER-ID -> IVD-AC-CUSTOMER-ID
IVH-INVOICE-ID -> IVD-INVOICE-ID
IVD-LINE-NBR
|
