CC_VISA_TAO09

(SQL Table)
Index Back

Visa - (9) Lodging Information

Visa Commercial - (9) Lodging Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 VS_LOADTRANSCODE Character(1) VARCHAR2(1) NOT NULL Load Transaction Code
1=Add transaction
2=Delete transaction
3=Update matching transaction
4=Update if existed or add
3 VS_ACCT_NBR Character(19) VARCHAR2(19) NOT NULL Account Number
4 POST_DT Date(10) DATE The Date a transaction was Posted.
5 VS_CCTRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
6 VS_CCSEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Visa Sequence Number
7 VS_NO_SHOW Character(1) VARCHAR2(1) NOT NULL No Show Indicator
0=No
1=Yes
8 CC_CHECK_IN_DATE Date(10) DATE Lodge Check-In Date
9 CC_DAILY_ROOM_RATE Signed Number(18,2) DECIMAL(16,2) NOT NULL Two decimal places are implied (ex 1234 = 12.34).
10 CC_OTHERCHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Other Charges
11 CC_TOTAL_TAX_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Total Tax Amount
12 CC_FOODDRINKCHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Food/Beverage Charges
13 CC_PREPAID_EXPENSE Signed Number(18,2) DECIMAL(16,2) NOT NULL Two decimal places are implied (ex 1234 = 12.34).
14 CC_FOLIOCASHADV Signed Number(18,2) DECIMAL(16,2) NOT NULL Folio Cash Advances
15 CC_VALETPARKCHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Valet Parking Charges
16 CC_MINIBARCHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Mini Bar Charges
17 CC_LAUNDRYCHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Laundry Charges
18 CC_PHONECHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Telephone Charges
19 CC_GIFTSHOPCHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Gift Shop Purchases
20 CC_MOVIECHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Movie Charges
21 CC_BUSCENTERCHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Business Center Charges
22 CC_HLTHCLUBCHARGE Signed Number(18,2) DECIMAL(16,2) NOT NULL Health Club Charges
23 CC_LODGE_EXTR_CHRG Character(4) VARCHAR2(4) NOT NULL Extra Charge Code
0=None
2=Restaurant
3=Gift Shop
4=Mini-bar
5=Telephone
6=Other
7=Laundry
24 CC_TOTAL_ROOM_TAX Signed Number(18,2) DECIMAL(16,2) NOT NULL Two decimal places are implied (ex 1234 = 12.34).
25 VS_LODGING_NIGHTS Number(3,0) SMALLINT NOT NULL Visa Lodging Nights
26 CC_TOTAL_NON_ROOM Signed Number(18,2) DECIMAL(16,2) NOT NULL Two decimal places are implied (ex 1234 = 12.34).
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 CC_SOURCE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Two decimal places are implied (ex 1234 = 12.34).
30 TRANS_DT Date(10) DATE Transaction Date
31 VS_MERCHANT_CAT_CD Character(4) VARCHAR2(4) NOT NULL Merchant Category Code
32 VS_SUPPLIER_NAME Character(26) VARCHAR2(26) NOT NULL Visa Supplier Name
33 VS_SUPPLIER_POSTAL Character(14) VARCHAR2(14) NOT NULL Supplier Postal Code
34 VS_PROCESSOR_KEY Character(52) VARCHAR2(52) NOT NULL Processor Addendum Key
35 VS_OPTIONAL_01 Character(26) VARCHAR2(26) NOT NULL Optional Field 1
36 VS_OPTIONAL_02 Character(26) VARCHAR2(26) NOT NULL Optional Field 2
37 VS_OPTIONAL_03 Character(26) VARCHAR2(26) NOT NULL Optional Field 3
38 VS_OPTIONAL_04 Character(26) VARCHAR2(26) NOT NULL Optional Field 4
39 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number