VAPS INVDIST Table
View exposing legacy VAPS invoice distribution detail including distribution sequence, charged and committed account and object codes, amounts, invoice number, purchase order digits, status, and transaction audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DIST_AMOUNT |
Distribution amount associated with the invoice distribution record. |
NUMBER |
11,2 |
DIST_CHARGED_ACCOUNT |
Charged account code for the invoice distribution. |
VARCHAR2 |
5 |
DIST_CHARGED_OBJ |
Charged object code for the invoice distribution. |
VARCHAR2 |
3 |
DIST_CHECKNUM |
Check number associated with the invoice distribution record. |
VARCHAR2 |
6 |
DIST_COMMITTED_ACCOUNT |
Committed account code for the invoice distribution. |
VARCHAR2 |
5 |
DIST_COMMITTED_OBJ |
Committed object code for the invoice distribution. |
VARCHAR2 |
3 |
DIST_FRT_AMOUNT |
Freight amount associated with the invoice distribution record. |
NUMBER |
11,2 |
DIST_INV_NUM |
Invoice number associated with the invoice distribution record. |
VARCHAR2 |
20 |
DIST_NUM |
Distribution number associated with the invoice distribution record. |
VARCHAR2 |
3 |
DIST_PO_DIGITS |
Purchase order digits associated with the invoice distribution record. |
VARCHAR2 |
7 |
DIST_SEQ |
Distribution sequence identifier for the invoice distribution record. |
VARCHAR2 |
7 |
DIST_STATUS |
Status code associated with the invoice distribution record. |
VARCHAR2 |
1 |
DIST_TIME_WRITTEN |
Timestamp indicating when the invoice distribution record was written. |
VARCHAR2 |
23 |
DIST_TRANS_TYPE |
Transaction type code associated with the invoice distribution record. |
VARCHAR2 |
3 |