VAPS TRANS DIST Table
View exposing legacy VAPS transaction distribution detail including distribution attributes, charged accounts, and related processing fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BATCH_NO |
Batch number grouping related transaction records. |
NUMBER |
4 |
DATE_ENTERED |
Date the transaction distribution was entered. |
DATE |
|
DIST_ACCT |
Account number charged in the distribution. |
VARCHAR2 |
6 |
DIST_AMT |
Amount applied to the distribution. |
NUMBER |
10,2 |
DIST_OBJ |
Object code associated with the distribution. |
VARCHAR2 |
5 |
DIST_STATUS |
Status of the distribution record. |
VARCHAR2 |
1 |
JV_DATE |
Journal voucher processing date. |
DATE |
|
JV_STATUS |
Status of journal voucher processing. |
VARCHAR2 |
1 |
SEQ_NO |
Sequence number identifying the transaction within a batch. |
NUMBER |
5 |
SEQ_SUFFIX |
Suffix extending the sequence number for sub-record identification. |
NUMBER |
2 |
TIME_ENTERED |
Time the transaction distribution was entered. |
VARCHAR2 |
6 |
TRANS_TYPE |
Code identifying the transaction type. |
NUMBER |
2 |
TRIP_NO |
Trip identifier associated with the transaction distribution. |
VARCHAR2 |
8 |