OEB_AP_CREDIT_CARD_TRXNS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRX_ID BIGINT 8
2 VALIDATE_CODE CHARACTER VARYING(25) 25
3 CARD_PROGRAM_ID BIGINT 8
4 EXPENSED_AMOUNT NUMERIC(18,6) 19
5 REFERENCE_NUMBER CHARACTER VARYING(240) 240
6 TRANSACTION_TYPE CHARACTER VARYING(80) 80
7 TRANSACTION_DATE TIMESTAMP 8
8 TRANSACTION_AMOUNT NUMERIC(18,6) 19
9 DEBIT_FLAG CHARACTER VARYING(1) 1
10 BILLED_DATE TIMESTAMP 8
11 BILLED_AMOUNT NUMERIC(18,6) 19
12 BILLED_DECIMAL BIGINT 8
13 BILLED_CURRENCY_CODE CHARACTER VARYING(15) 15
14 POSTED_DATE TIMESTAMP 8
15 POSTED_AMOUNT NUMERIC(18,6) 19
16 POSTED_DECIMAL BIGINT 8
17 POSTED_CURRENCY_CODE CHARACTER VARYING(15) 15
18 CURRENCY_CONVERSION_EXPONENT BIGINT 8
19 CURRENCY_CONVERSION_RATE NUMERIC(18,6) 19
20 MIS_INDUSTRY_CODE CHARACTER VARYING(80) 80
21 SIC_CODE BIGINT 8
22 MERCHANT_TAX_ID CHARACTER VARYING(80) 80
23 MERCHANT_REFERENCE CHARACTER VARYING(80) 80
24 MERCHANT_NAME1 CHARACTER VARYING(240) 240
25 MERCHANT_NAME2 CHARACTER VARYING(80) 80
26 MERCHANT_ADDRESS1 CHARACTER VARYING(80) 80
27 MERCHANT_ADDRESS2 CHARACTER VARYING(80) 80
28 MERCHANT_ADDRESS3 CHARACTER VARYING(80) 80
29 MERCHANT_ADDRESS4 CHARACTER VARYING(80) 80
30 MERCHANT_CITY CHARACTER VARYING(80) 80
31 MERCHANT_PROVINCE_STATE CHARACTER VARYING(80) 80
32 MERCHANT_POSTAL_CODE CHARACTER VARYING(80) 80
33 MERCHANT_COUNTRY CHARACTER VARYING(80) 80
34 TOTAL_TAX NUMERIC(18,6) 19
35 LOCAL_TAX NUMERIC(18,6) 19
36 NATIONAL_TAX NUMERIC(18,6) 19
37 OTHER_TAX NUMERIC(18,6) 19
38 ORG_ID BIGINT 8
39 LAST_UPDATE_DATE TIMESTAMP 8
40 LAST_UPDATED_BY BIGINT 8
41 LAST_UPDATE_LOGIN BIGINT 8
42 CREATION_DATE TIMESTAMP 8
43 CREATED_BY BIGINT 8
44 FOLIO_TYPE CHARACTER VARYING(80) 80
45 ATM_CASH_ADVANCE NUMERIC(18,6) 19
46 ATM_TRANSACTION_DATE TIMESTAMP 8
47 ATM_FEE_AMOUNT NUMERIC(18,6) 19
48 ATM_TYPE CHARACTER VARYING(80) 80
49 ATM_ID CHARACTER VARYING(80) 80
50 ATM_NETWORK_ID CHARACTER VARYING(80) 80
51 RESTAURANT_FOOD_AMOUNT NUMERIC(18,6) 19
52 RESTAURANT_BEVERAGE_AMOUNT NUMERIC(18,6) 19
53 RESTAURANT_TIP_AMOUNT NUMERIC(18,6) 19
54 CAR_RENTAL_DATE TIMESTAMP 8
55 CAR_RETURN_DATE TIMESTAMP 8
56 CAR_RENTAL_LOCATION CHARACTER VARYING(80) 80
57 CAR_RENTAL_STATE CHARACTER VARYING(80) 80
58 CAR_RETURN_LOCATION CHARACTER VARYING(80) 80
59 CAR_RETURN_STATE CHARACTER VARYING(80) 80
60 CAR_RENTER_NAME CHARACTER VARYING(240) 240
61 CAR_RENTAL_DAYS CHARACTER VARYING(80) 80
62 CAR_RENTAL_AGREEMENT_NUMBER CHARACTER VARYING(80) 80
63 CAR_CLASS CHARACTER VARYING(80) 80
64 CAR_TOTAL_MILEAGE NUMERIC(18,6) 19
65 CAR_GAS_AMOUNT NUMERIC(18,6) 19
66 CAR_INSURANCE_AMOUNT NUMERIC(18,6) 19
67 CAR_MILEAGE_AMOUNT NUMERIC(18,6) 19
68 CAR_DAILY_RATE NUMERIC(18,6) 19
69 HOTEL_ARRIVAL_DATE TIMESTAMP 8
70 HOTEL_DEPART_DATE TIMESTAMP 8
71 HOTEL_CHARGE_DESC CHARACTER VARYING(80) 80
72 HOTEL_GUEST_NAME CHARACTER VARYING(80) 80
73 HOTEL_STAY_DURATION NUMERIC(18,6) 19
74 HOTEL_ROOM_RATE NUMERIC(18,6) 19
75 HOTEL_NO_SHOW_FLAG CHARACTER VARYING(1) 1
76 HOTEL_ROOM_AMOUNT NUMERIC(18,6) 19
77 HOTEL_TELEPHONE_AMOUNT NUMERIC(18,6) 19
78 HOTEL_ROOM_TAX NUMERIC(18,6) 19
79 HOTEL_BAR_AMOUNT NUMERIC(18,6) 19
80 HOTEL_MOVIE_AMOUNT NUMERIC(18,6) 19
81 HOTEL_GIFT_SHOP_AMOUNT NUMERIC(18,6) 19
82 HOTEL_LAUNDRY_AMOUNT NUMERIC(18,6) 19
83 HOTEL_HEALTH_AMOUNT NUMERIC(18,6) 19
84 HOTEL_RESTAURANT_AMOUNT NUMERIC(18,6) 19
85 HOTEL_BUSINESS_AMOUNT NUMERIC(18,6) 19
86 HOTEL_PARKING_AMOUNT NUMERIC(18,6) 19
87 HOTEL_ROOM_SERVICE_AMOUNT NUMERIC(18,6) 19
88 HOTEL_TIP_AMOUNT NUMERIC(18,6) 19
89 HOTEL_MISC_AMOUNT NUMERIC(18,6) 19
90 HOTEL_CITY CHARACTER VARYING(80) 80
91 HOTEL_STATE CHARACTER VARYING(80) 80
92 HOTEL_FOLIO_NUMBER CHARACTER VARYING(80) 80
93 HOTEL_ROOM_TYPE CHARACTER VARYING(240) 240
94 AIR_DEPARTURE_DATE TIMESTAMP 8
95 AIR_DEPARTURE_CITY CHARACTER VARYING(80) 80
96 AIR_ROUTING CHARACTER VARYING(80) 80
97 AIR_ARRIVAL_CITY CHARACTER VARYING(80) 80
98 AIR_STOPOVER_FLAG CHARACTER VARYING(1) 1
99 AIR_BASE_FARE_AMOUNT NUMERIC(18,6) 19
100 AIR_FARE_BASIS_CODE CHARACTER VARYING(80) 80
101 AIR_SERVICE_CLASS CHARACTER VARYING(80) 80
102 AIR_CARRIER_ABBREVIATION CHARACTER VARYING(80) 80
103 AIR_CARRIER_CODE CHARACTER VARYING(80) 80
104 AIR_TICKET_ISSUER CHARACTER VARYING(240) 240
105 AIR_ISSUER_CITY CHARACTER VARYING(80) 80
106 AIR_PASSENGER_NAME CHARACTER VARYING(80) 80
107 AIR_REFUND_TICKET_NUMBER CHARACTER VARYING(80) 80
108 AIR_EXCHANGED_TICKET_NUMBER CHARACTER VARYING(80) 80
109 AIR_AGENCY_NUMBER CHARACTER VARYING(80) 80
110 AIR_TICKET_NUMBER CHARACTER VARYING(80) 80
111 FINANCIAL_CATEGORY CHARACTER VARYING(80) 80
112 PAYMENT_FLAG CHARACTER VARYING(1) 1
113 RECORD_TYPE CHARACTER VARYING(80) 80
114 MERCHANT_ACTIVITY CHARACTER VARYING(80) 80
115 CATEGORY CHARACTER VARYING(30) 30
116 REPORT_HEADER_ID BIGINT 8
117 EXPENSE_STATUS CHARACTER VARYING(15) 15
118 COMPANY_PREPAID_INVOICE_ID BIGINT 8
119 INACTIVE_EMP_WF_ITEM_KEY CHARACTER VARYING(50) 50
120 LOCATION_ID BIGINT 8
121 REQUEST_ID BIGINT 8
122 MERCHANT_COUNTRY_CODE CHARACTER VARYING(30) 30
123 DISPUTE_DATE TIMESTAMP 8
124 PAYMENT_DUE_FROM_CODE CHARACTER VARYING(30) 30
125 TRX_AVAILABLE_DATE TIMESTAMP 8
126 CARD_ACCEPTOR_ID BIGINT 8
127 TRXN_DETAIL_FLAG CHARACTER VARYING(1) 1
128 DESCRIPTION CHARACTER VARYING(240) 240
129 CARD_ID BIGINT 8
130 COMPANY_NUMBER CHARACTER VARYING(15) 15
131 MARKET_CODE CHARACTER VARYING(3) 3
132 VALIDATE_REQUEST_ID CHARACTER VARYING(50) 50
133 CUSTOMER_CODE CHARACTER VARYING(100) 100
134 PURCHASE_IDENTIFICATION CHARACTER VARYING(100) 100
135 FUEL_TYPE CHARACTER VARYING(15) 15
136 FUEL_UOM_CODE CHARACTER VARYING(1) 1
137 FUEL_QUANTITY NUMERIC(18,6) 19
138 FUEL_UNIT_PRICE NUMERIC(18,6) 19
139 FUEL_SALE_AMOUNT NUMERIC(18,6) 19
140 NON_FUEL_SALE_AMOUNT NUMERIC(18,6) 19
141 FLEET_IDENTITY_CODE CHARACTER VARYING(100) 100
142 AIR_AGENCY_NAME CHARACTER VARYING(240) 240
143 AIR_TOTAL_LEGS CHARACTER VARYING(15) 15
144 CUSTOMER_DATA1 CHARACTER VARYING(30) 30
145 CUSTOMER_DATA2 CHARACTER VARYING(30) 30
146 CUSTOMER_DATA3 CHARACTER VARYING(30) 30
147 CUSTOMER_DATA4 CHARACTER VARYING(30) 30
148 CUSTOMER_DATA5 CHARACTER VARYING(30) 30
149 CUSTOMER_DATA6 CHARACTER VARYING(30) 30
150 CUSTOMER_DATA7 CHARACTER VARYING(30) 30
151 CUSTOMER_DATA8 CHARACTER VARYING(30) 30
152 CUSTOMER_DATA9 CHARACTER VARYING(30) 30
153 CUSTOMER_DATA10 CHARACTER VARYING(30) 30
154 DCC_FLAG CHARACTER VARYING(1) 1
155 ODOMETER_READING CHARACTER VARYING(40) 40
156 VEHICLE_NUMBER CHARACTER VARYING(40) 40
157 FUEL_BRAND CHARACTER VARYING(80) 80
158 DEVICE_DOWNLOAD_FLAG CHARACTER VARYING(10) 10
159 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
160 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
161 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
162 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
163 MERCHANT_NAME1_1 CHARACTER VARYING(240) 240
164 CAR_RENTER_NAME_1 CHARACTER VARYING(240) 240
165 AIR_TICKET_ISSUER_1 CHARACTER VARYING(240) 240
166 CARD_NUMBER CHARACTER VARYING(80) 80