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