VAPS FTRVD007 Table
View exposing closed-trip distribution detail from the legacy VAPS travel system including trip identifiers, batch and sequence information, charged account and object codes, distribution status, amount, and journal voucher processing fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
D007_BATCH_NO |
Batch number associated with the closed-trip distribution record. |
NUMBER |
4 |
D007_SEQ_NO |
Sequence number associated with the closed-trip distribution record. |
NUMBER |
5 |
D007_SEQ_SUFFIX |
Sequence suffix associated with the closed-trip distribution record. |
NUMBER |
2 |
D007_TRANS_TYPE |
Transaction type code associated with the closed-trip distribution record. |
NUMBER |
2 |
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 |
TIME_ENTERED |
Time the closed-trip distribution record was entered. |
VARCHAR2 |
6 |
TRIP_NO |
Legacy VAPS trip identifier. |
VARCHAR2 |
8 |
USER_ID |
User identifier associated with the closed-trip distribution record. |
VARCHAR2 |
10 |