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. |
|
||
OIH-BATCH-NBR Element: Batch Nbr | Numeric 6 This identifies the batch the entered invoices, debit memos, and credit memos are a part of. |
|
||
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. |
|
||
OIH-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The description of the batch. |
|
||
OIH-BATCH-COUNT Element: Detail Count | Signed 5.0 Control total number of records in the batch. |
|
||
OIH-DETAIL-COUNT Element: Detail Count | Signed 5.0 The total number of records that have been entered in the batch. |
|
||
OIH-BTCH-QUANTITY Element: Quantity | Signed 13.4 Control total amount in the invoice batch. |
|
||
OIH-DTL-QUANTITY Element: Quantity | Signed 13.4 The total amount actually entered into the batch. |
|
||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
OIHSET1 |
COMPANY BATCH-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Company | OECOMPANY |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Oeinvoice | OEINVOICE |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.