OEINVHDR

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.
UPDATED BY
WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIH-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
WH20.7
OIH-BATCH-NBR
Element: Batch Nbr
Numeric 6
This identifies the batch the entered invoices, debit memos, and credit memos are a part of.
WH20.7
OIH-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
0 = Unreleased
1 = Released
OIH-BATCH-DATE
Element: Batch Date
Numeric 8 (yyyymmdd)
This is the date the batch was created.
WH20.7
OIH-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description of the batch.
WH20.7
OIH-BATCH-COUNT
Element: Detail Count
Signed 5.0
Control total number of records in the batch.
WH20.7
OIH-DETAIL-COUNT
Element: Detail Count
Signed 5.0
The total number of records that have been entered in the batch.
WH20.7
OIH-BTCH-QUANTITY
Element: Quantity
Signed 13.4
Control total amount in the invoice batch.
WH20.7
OIH-DTL-QUANTITY
Element: Quantity
Signed 13.4
The total amount actually entered into the batch.
WH20.7
OIH-INVC-SOURCE
Element: Invc Source
Alpha 1
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
WH20.7


OEINVHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIHSET1 COMPANY
BATCH-NBR
WH20.7


OEINVHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company OECOMPANY Required
OIH-COMPANY->OEC-COMPANY


OEINVHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:09:36 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.