Lawson Insight Technical Documentation |
|
OEINVHDR
OEINVHDR FILE
Invoice Header
This file stores the Invoice Header records. Information identified on this
record includes the batch number, date, batch count, the number of invoices
within the batch, and so on.
REFERENCED BY
BL220 BL80.6
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
OE114 OE129 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE530 OE830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIH-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIH-BATCH-NBR Numeric 6 BL120 BL122
Element: Batch Number This identifies the batch the entered BL130 BL20.1
invoices, debit memos, and credit memos BL20.3 BL21.2
are a part of. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIH-STATUS Numeric 1
Element: Status This field displays the status of the
transaction.
0 = Unreleased
1 = Released
OIH-BATCH-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Batch Date This is the date the batch was created. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIH-DESCRIPTION Alpha 30 (Lower Case) BL120 BL122
Element: Description The description of the batch. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIH-BATCH-COUNT Signed 5.0 BL120 BL122
Element: Detail Count Control total number of records in the BL130 BL20.1
batch. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIH-DETAIL-COUNT Signed 5.0 BL120 BL122
Element: Detail Count The total number of records that have BL130 BL20.1
been entered in the batch. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIH-BTCH-QUANTITY Signed 13.4 BL120 BL122
Element: Quantity Control total amount in the invoice BL130 BL20.1
batch. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIH-DTL-QUANTITY Signed 13.4 BL120 BL122
Element: Quantity The total amount actually entered into BL130 BL20.1
the batch. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIH-INVC-SOURCE Alpha 1 BL120 BL122
Element: Invc Source Identifies where the invoices within BL130 BL20.1
the batch came from. For example, were BL20.3 BL21.2
they interfaced, manually entered, or BL21.5 BL29.1
created by the system. BL29.2 BL520
I = Interfaced BL820 BL92.1
M = Manual OE114 OE129
S = Shipment OE30.1 OE30.2
R = Return OE30.3 OE30.4
C = Recurring Invoice OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OEINVHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIHSET1 COMPANY BL120 BL122
BATCH-NBR BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL220
BL29.1 BL29.2
BL520 BL80.6
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OEINVHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company OECOMPANY Required
OIH-COMPANY -> OEC-COMPANY
OEINVHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oeinvoice OEINVOICE Delete Cascades
OIH-COMPANY -> OEI-COMPANY
OIH-BATCH-NBR -> OEI-BATCH-NBR
OEI-INVC-PREFIX
OEI-INVC-NUMBER
|