Lawson Insight Technical Documentation |
|
ACINVHDR
ACINVHDR FILE
REFERENCED BY
BR121 BR420 BRAH.1
UPDATED BY
AC300 AC310 BR02.3 BR120 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR20.7 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IVH-COMPANY Numeric 4 BR02.3 BR120
Element: Company The company number represents an
established company and is entered on
all function codes.
IVH-CUSTOMER Alpha 9 (Right Justified) BR02.3 BR120
Element: Customer NumbeThis field contains the number that
represents a customer.
IVH-INVOICE-PREFIX Alpha 2 BR02.3 BR120
Element: Invoice Prefix
IVH-INVOICE-NBR Numeric 8 BR02.3 BR120
Element: Invoice Nbr
IVH-PROCESS-LEVEL Alpha 5 BR02.3 BR120
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
IVH-RETAIN-ID Numeric 6 BR02.3
Element: Retain Id
IVH-INVOICE-ID Numeric 6 BR02.3 BR120
Element: Invoice Id
IVH-CONTRACT Alpha 10 BR02.3 BR120
Element: Bid Name
IVH-INVOICE-DATE Numeric 8 (yyyymmdd) BR02.3 BR120
Element: Date BR20.7
IVH-POSTING-DATE Numeric 8 (yyyymmdd) BR02.3 BR120
Element: Date BR20.7
IVH-REFERENCE Alpha 10 (Lower Case) BR02.3 BR120
Element: Requester The reference number associated with
the transaction.
IVH-BILL-TO Numeric 4 BR02.3 BR120
Element: Ship-to Code BR20.7
IVH-CONTACT-CODE Alpha 5 BR02.3 BR120
Element: Contact Code BR20.7
IVH-CUST-PO-NBR Alpha 22 BR02.3 BR120
Element: Customer P.O. Number BR20.7
IVH-LAST-LINE-NBR Numeric 6 BR120 BR20.1
Element: Line Number BR20.2 BR20.3
BR20.4 BR20.5
IVH-UNITS-AMOUNT Signed 15.2 BR120 BR20.1
Element: Adj Amt This is the units amount included in BR20.2 BR20.3
the file. BR20.4 BR20.5
IVH-CONTRACT-CURR Alpha 5 BR02.3 BR120
Element: Contract Curr
IVH-CONTRACT-ND Numeric 1 BR02.3 BR120
Element: Contract Nd
IVH-INVC-AMT-TOT Signed 15.2 BR02.3 BR120
Element: Invc Amt Tot BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
IVH-STATUS Numeric 1 BR02.3 BR120
Element: 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
Element: Ac Customer Id
IVH-CUMULATIVE-FL Alpha 1 BR02.3 BR120
Element: Cumulative Fl
IVH-CUST-NAME Derived
Element: Cust Name
IVH-LOCK-BOX Alpha 2
Element: Lock Box
IVH-BILL-WBS-CODE Alpha 3 BR02.3 BR120
Element: Bill Wbs Code
IVH-EXCEED-AMT Signed 15.2 BR120 BR20.1
Element: Exceed Amt BR20.2 BR20.3
BR20.4 BR20.5
IVH-EXCEED-UNIT Signed 15.2 BR120 BR20.1
Element: Exceed Unit BR20.2 BR20.3
BR20.4 BR20.5
ACINVHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IVHSET1 CONTRACT AC300 AC310
COMPANY BR02.3 BR121
CUSTOMER BR20.1 BR20.2
AC-CUSTOMER-ID BR20.3 BR20.4
INVOICE-PREFIX BR20.5 BR20.7
INVOICE-NBR BR420 BR521
BRIP.1
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
IVHSET5 INVOICE-PREFIX BR20.2 BR20.3
INVOICE-NBR BR20.4 BR20.5
COMPANY BR20.7 BRAH.1
CUSTOMER
AC-CUSTOMER-ID
CONTRACT
ACINVHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
IVH-CONTRACT -> CNT-CONTRACT
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
|