 |
Lawson Insight Technical Documentation |
|
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 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 BR20.7
IVH-POSTING-DATE Numeric 8 (yyyymmdd) BR02.3 BR120
Posting Date The date assigned to the journal entry BR20.7
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 BR20.7
IVH-CONTACT-CODE Alpha 5 BR02.3 BR120
Contact Code BR20.7
IVH-CUST-PO-NBR Alpha 22 BR02.3 BR120
Customer P.O. Number BR20.7
IVH-LAST-LINE-NBR Numeric 6 BR120 BR20.1
Last Line Number This field contains the number of the BR20.2 BR20.3
last line item added to the document. It BR20.4 BR20.5
is used to determine what the next line
number is when you add another
item.
IVH-UNITS-AMOUNT Signed 15.2 BR120 BR20.1
Units Amount 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
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 BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
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-CUST-NAME Derived
Cust Name
IVH-LOCK-BOX Alpha 2
Lock Box
IVH-BILL-WBS-CODE Alpha 3 BR02.3 BR120
Bill Wbs Code
IVH-EXCEED-AMT Signed 15.2 BR120 BR20.1
Exceed Amt BR20.2 BR20.3
BR20.4 BR20.5
IVH-EXCEED-UNIT Signed 15.2 BR120 BR20.1
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 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
|