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.5
UPDATED BY
BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 BL940
OE114 OE129 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIH-COMPANY Numeric 4 BL120 BL130
Company The company number represents an BL20.1 BL20.3
established company and is entered on BL21.2 BL21.5
all function codes. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIH-BATCH-NBR Numeric 6 BL120 BL130
Batch Number This identifies the batch the entered BL20.1 BL20.3
invoices, debit memos, and credit memos BL21.2 BL21.5
are a part of. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIH-STATUS Numeric 1
Status This field contains the status of the
transaction.
0 = Unreleased
1 = Released
OIH-BATCH-DATE Numeric 8 (yyyymmdd) BL120 BL130
Batch Date This is the date the batch was created. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIH-DESCRIPTION Alpha 30 (Lower Case) BL120 BL130
Description The description of the batch. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIH-BATCH-COUNT Signed 5.0 BL120 BL130
Batch Count Control total number of records in the BL20.1 BL20.3
batch. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIH-DETAIL-COUNT Signed 5.0 BL120 BL130
Detail Count The total number of records that have BL20.1 BL20.3
been entered in the batch. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIH-BTCH-QUANTITY Signed 13.4 BL120 BL130
Btch-Quantity Control total amount in the invoice BL20.1 BL20.3
batch. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIH-DTL-QUANTITY Signed 13.4 BL120 BL130
Dtl Quantity The total amount actually entered into BL20.1 BL20.3
the batch. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIH-INVC-SOURCE Alpha 1 BL120 BL130
Invc Source Identifies where the invoices within BL20.1 BL20.3
the batch came from. For example, were BL21.2 BL21.5
they interfaced, manually entered, or BL29.1 BL29.2
created by the system. BL520 BL820
I = Interfaced BL92.1 BL940
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
OE830 OE950
OEINVHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIHSET1 COMPANY BL120 BL130
BATCH-NBR BL20.1 BL20.3
BL21.2 BL21.5
BL220 BL29.1
BL29.2 BL520
BL80.5 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
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
|