VAPS CLOSED DIST Table
View exposing legacy VAPS closed-trip distribution detail including trip identifiers, batch and sequence information, charged account and object codes, distribution status, amount, and journal voucher processing dates and status.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BATCH_NO |
Batch number associated with the closed-trip distribution record. |
NUMBER |
4 |
DATE_ENTERED |
Date the closed-trip distribution record was entered. |
DATE |
|
DIST_ACCT |
Charged account code for the closed-trip distribution. |
VARCHAR2 |
6 |
DIST_AMT |
Distribution amount associated with the closed-trip distribution. |
NUMBER |
10,2 |
DIST_OBJ |
Charged object code for the closed-trip distribution. |
VARCHAR2 |
5 |
DIST_STATUS |
Distribution status code associated with the closed-trip distribution. |
VARCHAR2 |
1 |
JV_DATE |
Journal voucher processing date associated with the closed-trip distribution. |
DATE |
|
JV_STATUS |
Journal voucher status associated with the closed-trip distribution. |
VARCHAR2 |
1 |
SEQ_NO |
Sequence number associated with the closed-trip distribution record. |
NUMBER |
5 |
SEQ_SUFFIX |
Sequence suffix associated with the closed-trip distribution record. |
NUMBER |
2 |
TIME_ENTERED |
Time the closed-trip distribution record was entered. |
VARCHAR2 |
6 |
TRANS_TYPE |
Transaction type code associated with the closed-trip distribution record. |
NUMBER |
2 |
TRIP_NO |
Legacy VAPS trip identifier. |
VARCHAR2 |
8 |