| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
VS_ACCT_NBR |
Character(19) |
VARCHAR2(19) NOT NULL |
Account Number
|
| 3 |
VS_POSTING_DT |
Date(10) |
DATE |
Posting Date
|
| 4 |
VS_CCTRANS_NBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Transaction Number
|
| 5 |
VS_CCSEQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Visa Sequence Number
|
| 6 |
VS_ITEM_SEQ_NBR |
Number(5,0) |
INTEGER NOT NULL |
Item Sequence Number
|
| 7 |
VS_CHARGE_DT |
Date(10) |
DATE |
Visa Date of Charge
|
| 8 |
VS_DAILY_ROOM_RT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Daily Room Rate
|
| 9 |
VS_DISC_RATE |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Discount Rate
|
| 10 |
VS_FOODBEV_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Food/Beverage Amount
|
| 11 |
VS_FOLIO_CASHADV |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Folio Cash Advance
|
| 12 |
VS_VALETPARK_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Valet Parking Amount
|
| 13 |
VS_MINIBAR_CHARGE |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Mini Bar Charge
|
| 14 |
VS_LAUNDRY_CHG |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Laundry Charge
|
| 15 |
VS_PHONE_CHG |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Phone Charge
|
| 16 |
VS_GIFTSHOP_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Gift Shop Amount
|
| 17 |
VS_MOVIE_CHG |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Movie Charge
|
| 18 |
VS_BUS_CENTER_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Business Center Amount
|
| 19 |
VS_HEALTHCLUB_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Health Club Amount
|
| 20 |
VS_ROOM_TAX |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Room Tax
|
| 21 |
VS_ROOM_TAX2 |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Room Tax 2
|
| 22 |
VS_ROOM_TAX3 |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Room Tax 3
|
| 23 |
VS_ROOM_TAX4 |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Room Tax 4
|
| 24 |
VS_OTHERCHG |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Other Charge
|
| 25 |
VS_OTHERCHARGECODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Other Charge Code
|
| 26 |
VS_OTHERCHARGEDESC |
Character(20) |
VARCHAR2(20) NOT NULL |
Description of Other Charge
|
| 27 |
VS_MESSAGE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Message Identifier
|
| 28 |
VS_PURCH_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Visa/Infospan Purchase ID
|
| 29 |
VS_FIRST_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Visa Cardholder First Name
|
| 30 |
VS_LAST_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Visa Cardholder Last Name
|
| 31 |
VS_MERCH_SRV_DESCR |
Character(40) |
VARCHAR2(40) NOT NULL |
Visa Merchant Service Descr
|
| 32 |
VS_COMMODITY_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Visa Commodity Code
|
| 33 |
VS_ITEM_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Visa Item Amount
|
| 34 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
|
| 35 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|