VAPS PAID TRANS Table
View exposing paid transaction detail from the legacy VAPS travel and payment system including trip, batch, sequence, payee, vendor, invoice, amount, verification and fast-check indicators, address fields, and entry, defer, and paid dates.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
D100_ADDR1 |
Primary address line associated with the payee. |
VARCHAR2 |
25 |
D100_ADDR2 |
Secondary address line associated with the payee. |
VARCHAR2 |
25 |
D100_ADDR3 |
Tertiary address line associated with the payee. |
VARCHAR2 |
21 |
D100_ADDR4 |
Quaternary address line associated with the payee. |
VARCHAR2 |
21 |
D100_AGENCY |
Agency or vendor description associated with the paid transaction. |
VARCHAR2 |
20 |
D100_AMOUNT |
Amount associated with the paid transaction. |
NUMBER |
10,2 |
D100_BATCH_NO |
Batch number associated with the paid transaction. |
NUMBER |
4 |
D100_DATE_ENTERED |
Date the paid transaction record was entered. |
DATE |
|
D100_DEFER_DATE |
Defer date associated with the paid transaction. |
DATE |
|
D100_FAST_CHECK |
Indicator identifying whether the paid transaction was processed as a fast check (Y/N). |
VARCHAR2 |
1 |
D100_ID |
Person or traveler identifier associated with the paid transaction. |
VARCHAR2 |
9 |
D100_INVOICE |
Invoice number associated with the paid transaction. |
VARCHAR2 |
20 |
D100_PAID_DATE |
Date the transaction was paid. |
DATE |
|
D100_PAYEE_NAME |
Name of the payee associated with the paid transaction. |
VARCHAR2 |
26 |
D100_SEQ_NO |
Sequence number associated with the paid transaction. |
NUMBER |
5 |
D100_TRANS_TYPE |
Transaction type code associated with the paid transaction. |
NUMBER |
2 |
D100_TRIP_NO |
Legacy VAPS trip identifier associated with the paid transaction. |
VARCHAR2 |
8 |
D100_USER_ID |
User identifier associated with the paid transaction record. |
VARCHAR2 |
12 |
D100_VENDOR_CODE |
Vendor code associated with the paid transaction. |
VARCHAR2 |
6 |
D100_VERIFY |
Indicator identifying whether the paid transaction was verified (Y/N). |
VARCHAR2 |
1 |