| # |
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_NO_SHOW_IND |
Number(1,0) |
SMALLINT NOT NULL |
Visa No Show Indicator
|
| 7 |
VS_CHECKIN_DT |
Date(10) |
DATE |
Visa Check In Date
|
| 8 |
VS_DAILY_ROOM_RT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Daily Room Rate
|
| 9 |
VS_OTHERCHG |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Other Charge
|
| 10 |
VS_TAX_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Tax Amount
|
| 11 |
VS_FOODBEV_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Food/Beverage Amount
|
| 12 |
VS_PREPAID_EXP |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Prepaid Expense
|
| 13 |
VS_FOLIO_CASHADV |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Folio Cash Advance
|
| 14 |
VS_VALETPARK_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Valet Parking Amount
|
| 15 |
VS_MINIBAR_CHARGE |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Mini Bar Charge
|
| 16 |
VS_LAUNDRY_CHG |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Laundry Charge
|
| 17 |
VS_PHONE_CHG |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Phone Charge
|
| 18 |
VS_GIFTSHOP_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Gift Shop Amount
|
| 19 |
VS_MOVIE_CHG |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Movie Charge
|
| 20 |
VS_BUS_CENTER_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Business Center Amount
|
| 21 |
VS_HEALTHCLUB_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Health Club Amount
|
| 22 |
VS_EXTRA_CHARGE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Extra Charge Code
|
| 23 |
VS_ROOM_TAX |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Room Tax
|
| 24 |
VS_LODGING_NIGHTS |
Number(3,0) |
SMALLINT NOT NULL |
Visa Lodging Nights
|
| 25 |
VS_TOTAL_NONROOM |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Total Non Room
|
| 26 |
VS_MESSAGE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Message Identifier
|
| 27 |
VS_PURCH_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Visa/Infospan Purchase ID
|
| 28 |
VS_SOURCE_AMOUNT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Visa Source Amount
|
| 29 |
VS_TRANS_DT |
Date(10) |
DATE |
Visa Transaction Date
|
| 30 |
VS_MRCHNT_CAT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Visa Merchant Category Code
|
| 31 |
VS_SUPPLIER_NAME |
Character(26) |
VARCHAR2(26) NOT NULL |
Visa Supplier Name
|
| 32 |
VS_SPPLY_POSTL_CD |
Character(14) |
VARCHAR2(14) NOT NULL |
Visa Supplier Postal Code
|
| 33 |
VS_FIRST_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Visa Cardholder First Name
|
| 34 |
VS_LAST_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Visa Cardholder Last Name
|
| 35 |
CRDMEM_ACCT_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Cardmember Number
|
| 36 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|