VAPS INVOICE Table
View exposing legacy VAPS invoice header detail including invoice number, purchase order linkage, vendor pay-to and committed vendor identifiers, dates, gross, net, freight, discount and remittance attributes, payment status, tax fields, attachment and destination indicators, and transaction audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
INV_APPROVAL |
Indicator identifying whether the invoice requires approval or has been approved (Y/N). |
VARCHAR2 |
1 |
INV_ATTACHMENT |
Indicator identifying whether the invoice has an attachment (Y/N). |
VARCHAR2 |
1 |
INV_BATCH |
Batch identifier associated with the invoice. |
VARCHAR2 |
7 |
INV_BATCH_SEQ |
Batch sequence associated with the invoice. |
VARCHAR2 |
4 |
INV_CANCELLED |
Indicator identifying whether the invoice was cancelled (Y/N). |
VARCHAR2 |
1 |
INV_CHECKNUMBER |
Check number associated with the invoice payment. |
VARCHAR2 |
6 |
INV_DATE |
Invoice date. |
DATE |
|
INV_DATE_PAID |
Date the invoice was paid. |
VARCHAR2 |
6 |
INV_DATE_SENT_TO_PAY |
Date the invoice was sent for payment processing. |
DATE |
|
INV_DATE_TO_PAY |
Date by which the invoice is due for payment. |
DATE |
|
INV_DESTINATION |
Destination code associated with the invoice. |
VARCHAR2 |
1 |
INV_DISCOUNT |
Discount terms associated with the invoice. |
VARCHAR2 |
4 |
INV_DISCOUNT_DAYS |
Number of days associated with the invoice discount terms. |
VARCHAR2 |
2 |
INV_ENTERED_BY |
User identifier of the person who entered the invoice. |
VARCHAR2 |
4 |
INV_ENTERED_DATE |
Date the invoice was entered. |
DATE |
|
INV_FASTCHECK |
Indicator identifying whether the invoice was processed as a fast check (Y/N). |
VARCHAR2 |
1 |
INV_FOREIGN_ADDRESS |
Indicator identifying whether the invoice involves a foreign address (Y/N). |
VARCHAR2 |
1 |
INV_FREIGHT_INVOICE |
Indicator identifying whether the invoice is a freight invoice (Y/N). |
VARCHAR2 |
1 |
INV_FRT_AMOUNT |
Freight amount associated with the invoice. |
NUMBER |
11,2 |
INV_GROSS_AMOUNT |
Gross amount of the invoice. |
NUMBER |
11,2 |
INV_LINE_ITEM |
Invoice line item indicator or code. |
VARCHAR2 |
1 |
INV_MAT_REC_DATE |
Material receipt date associated with the invoice. |
DATE |
|
INV_NET_AMOUNT |
Net amount of the invoice. |
NUMBER |
11,2 |
INV_NUMBER |
Invoice number. |
VARCHAR2 |
20 |
INV_OLDRECORD |
Indicator identifying whether the invoice record is an older or superseded record (Y/N). |
VARCHAR2 |
1 |
INV_PODIGITS |
Purchase order digits associated with the invoice. |
VARCHAR2 |
9 |
INV_POPREFIX |
Purchase order prefix associated with the invoice. |
VARCHAR2 |
3 |
INV_REMITTANCE |
Remittance code associated with the invoice. |
VARCHAR2 |
2 |
INV_ROOM_NUMBER |
Room number associated with invoice routing or delivery. |
VARCHAR2 |
10 |
INV_SEND_TO_NAME |
Name of the person or office to which the invoice was sent. |
VARCHAR2 |
20 |
INV_SEPERATE_CHECK |
Indicator identifying whether the invoice requires a separate check (Y/N). |
VARCHAR2 |
1 |
INV_SEQNUMBER |
Sequence identifier for the invoice record. |
VARCHAR2 |
7 |
INV_STATUS |
Status code associated with the invoice. |
VARCHAR2 |
1 |
INV_STATUS_DATE |
Date the current invoice status became effective. |
DATE |
|
INV_TAXCODE |
Tax code associated with the invoice. |
VARCHAR2 |
1 |
INV_TAXID |
Tax identifier associated with the invoice. |
VARCHAR2 |
9 |
INV_TERMINAL |
Terminal identifier associated with invoice entry or processing. |
VARCHAR2 |
4 |
INV_TO_DEPARTMENT |
Indicator identifying whether the invoice was routed to a department (Y/N). |
VARCHAR2 |
1 |
INV_TRANSACTION_TIME |
Transaction timestamp associated with the invoice record. |
VARCHAR2 |
23 |
INV_TRANSACTION_TYPE |
Transaction type code associated with the invoice record. |
VARCHAR2 |
1 |
INV_VENDOR_COMMITTED |
Committed vendor identifier associated with the invoice. |
VARCHAR2 |
6 |
INV_VENDOR_PAYTO |
Vendor pay-to identifier associated with the invoice. |
VARCHAR2 |
6 |
INV_VERIFIED |
Indicator identifying whether the invoice was verified (Y/N). |
VARCHAR2 |
1 |
INV_WHERE_SENT |
Code identifying where the invoice was sent for processing. |
VARCHAR2 |
5 |