CC_VISA_TAO09(SQL Table) |
Index Back |
---|---|
Visa - (9) Lodging InformationVisa 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 |