VAPS VOUCHER DETAIL Table
View exposing legacy VAPS voucher detail records including voucher identifiers, amounts, vendor references, and related payment processing attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
D030_AGENCY |
Agency associated with voucher processing. |
VARCHAR2 |
20 |
D030_AMOUNT |
Amount of the voucher transaction. |
NUMBER |
10,2 |
D030_BATCH_NO |
Batch number grouping voucher records. |
NUMBER |
4 |
D030_CHANGE_DATE |
Date the voucher was last updated. |
DATE |
|
D030_CODE |
Code associated with the voucher record. |
VARCHAR2 |
2 |
D030_DATE_ENTERED |
Date the voucher was entered. |
DATE |
|
D030_DAYS |
Number of days associated with voucher processing. |
VARCHAR2 |
2 |
D030_ENTERED_BY |
User who entered the voucher. |
VARCHAR2 |
8 |
D030_FAST_CHECK |
Indicator identifying whether the voucher was processed as a fast check (Y/N). |
VARCHAR2 |
1 |
D030_ID |
Identifier associated with the voucher record. |
VARCHAR2 |
9 |
D030_NAME |
Name associated with the voucher record. |
VARCHAR2 |
28 |
D030_SEQ_NO |
Sequence number identifying the voucher record. |
NUMBER |
5 |
D030_TRANS_TYPE |
Code identifying the voucher transaction type. |
NUMBER |
2 |
D030_TRIP_NO |
Trip identifier associated with the voucher. |
VARCHAR2 |
8 |
D030_USER_ID |
User associated with the voucher record. |
VARCHAR2 |
12 |
D030_VENDOR_CODE |
Vendor identifier associated with the voucher. |
VARCHAR2 |
6 |
D030_VERIFY |
Indicator identifying whether the voucher was verified (Y/N). |
VARCHAR2 |
1 |