FCT_EMP_UNRECONCILED_AMEX

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EMPLOYEE_NUMBER CHARACTER VARYING(35) 35
2 TRX_ID BIGINT 8
3 VALIDATE_CODE CHARACTER VARYING(25) 25
4 CARD_PROGRAM_ID BIGINT 8
5 EXPENSED_AMOUNT NUMERIC(18,6) 19
6 REFERENCE_NUMBER CHARACTER VARYING(240) 240
7 TRANSACTION_TYPE CHARACTER VARYING(80) 80
8 TRANSACTION_DATE TIMESTAMP 8
9 TRANSACTION_AMOUNT NUMERIC(18,6) 19
10 DEBIT_FLAG CHARACTER VARYING(1) 1
11 BILLED_DATE TIMESTAMP 8
12 BILLED_AMOUNT NUMERIC(18,6) 19
13 BILLED_DECIMAL BIGINT 8
14 BILLED_CURRENCY_CODE CHARACTER VARYING(15) 15
15 POSTED_DATE TIMESTAMP 8
16 POSTED_AMOUNT NUMERIC(18,6) 19
17 POSTED_DECIMAL BIGINT 8
18 POSTED_CURRENCY_CODE CHARACTER VARYING(15) 15
19 CURRENCY_CONVERSION_EXPONENT BIGINT 8
20 CURRENCY_CONVERSION_RATE NUMERIC(18,6) 19
21 MIS_INDUSTRY_CODE CHARACTER VARYING(80) 80
22 SIC_CODE BIGINT 8
23 MERCHANT_TAX_ID CHARACTER VARYING(80) 80
24 MERCHANT_REFERENCE CHARACTER VARYING(80) 80
25 MERCHANT_NAME1 CHARACTER VARYING(240) 240
26 MERCHANT_NAME2 CHARACTER VARYING(80) 80
27 MERCHANT_ADDRESS1 CHARACTER VARYING(80) 80
28 MERCHANT_ADDRESS2 CHARACTER VARYING(80) 80
29 MERCHANT_ADDRESS3 CHARACTER VARYING(80) 80
30 MERCHANT_ADDRESS4 CHARACTER VARYING(80) 80
31 MERCHANT_CITY CHARACTER VARYING(80) 80
32 MERCHANT_PROVINCE_STATE CHARACTER VARYING(80) 80
33 MERCHANT_POSTAL_CODE CHARACTER VARYING(80) 80
34 MERCHANT_COUNTRY CHARACTER VARYING(80) 80
35 TOTAL_TAX NUMERIC(18,6) 19
36 LOCAL_TAX NUMERIC(18,6) 19
37 NATIONAL_TAX NUMERIC(18,6) 19
38 OTHER_TAX NUMERIC(18,6) 19
39 ORG_ID BIGINT 8
40 LAST_UPDATE_DATE TIMESTAMP 8
41 LAST_UPDATED_BY BIGINT 8
42 LAST_UPDATE_LOGIN BIGINT 8
43 CREATION_DATE TIMESTAMP 8
44 CREATED_BY BIGINT 8
45 FOLIO_TYPE CHARACTER VARYING(80) 80
46 ATM_CASH_ADVANCE NUMERIC(18,6) 19
47 ATM_TRANSACTION_DATE TIMESTAMP 8
48 ATM_FEE_AMOUNT NUMERIC(18,6) 19
49 ATM_TYPE CHARACTER VARYING(80) 80
50 ATM_ID CHARACTER VARYING(80) 80
51 ATM_NETWORK_ID CHARACTER VARYING(80) 80
52 RESTAURANT_FOOD_AMOUNT NUMERIC(18,6) 19
53 RESTAURANT_BEVERAGE_AMOUNT NUMERIC(18,6) 19
54 RESTAURANT_TIP_AMOUNT NUMERIC(18,6) 19
55 CAR_RENTAL_DATE TIMESTAMP 8
56 CAR_RETURN_DATE TIMESTAMP 8
57 CAR_RENTAL_LOCATION CHARACTER VARYING(80) 80
58 CAR_RENTAL_STATE CHARACTER VARYING(80) 80
59 CAR_RETURN_LOCATION CHARACTER VARYING(80) 80
60 CAR_RETURN_STATE CHARACTER VARYING(80) 80
61 CAR_RENTER_NAME CHARACTER VARYING(240) 240
62 CAR_RENTAL_DAYS CHARACTER VARYING(80) 80
63 CAR_RENTAL_AGREEMENT_NUMBER CHARACTER VARYING(80) 80
64 CAR_CLASS CHARACTER VARYING(80) 80
65 CAR_TOTAL_MILEAGE NUMERIC(18,6) 19
66 CAR_GAS_AMOUNT NUMERIC(18,6) 19
67 CAR_INSURANCE_AMOUNT NUMERIC(18,6) 19
68 CAR_MILEAGE_AMOUNT NUMERIC(18,6) 19
69 CAR_DAILY_RATE NUMERIC(18,6) 19
70 HOTEL_ARRIVAL_DATE TIMESTAMP 8
71 HOTEL_DEPART_DATE TIMESTAMP 8
72 HOTEL_CHARGE_DESC CHARACTER VARYING(80) 80
73 HOTEL_GUEST_NAME CHARACTER VARYING(80) 80
74 HOTEL_STAY_DURATION NUMERIC(18,6) 19
75 HOTEL_ROOM_RATE NUMERIC(18,6) 19
76 HOTEL_NO_SHOW_FLAG CHARACTER VARYING(1) 1
77 HOTEL_ROOM_AMOUNT NUMERIC(18,6) 19
78 HOTEL_TELEPHONE_AMOUNT NUMERIC(18,6) 19
79 HOTEL_ROOM_TAX NUMERIC(18,6) 19
80 HOTEL_BAR_AMOUNT NUMERIC(18,6) 19
81 HOTEL_MOVIE_AMOUNT NUMERIC(18,6) 19
82 HOTEL_GIFT_SHOP_AMOUNT NUMERIC(18,6) 19
83 HOTEL_LAUNDRY_AMOUNT NUMERIC(18,6) 19
84 HOTEL_HEALTH_AMOUNT NUMERIC(18,6) 19
85 HOTEL_RESTAURANT_AMOUNT NUMERIC(18,6) 19
86 HOTEL_BUSINESS_AMOUNT NUMERIC(18,6) 19
87 HOTEL_PARKING_AMOUNT NUMERIC(18,6) 19
88 HOTEL_ROOM_SERVICE_AMOUNT NUMERIC(18,6) 19
89 HOTEL_TIP_AMOUNT NUMERIC(18,6) 19
90 HOTEL_MISC_AMOUNT NUMERIC(18,6) 19
91 HOTEL_CITY CHARACTER VARYING(80) 80
92 HOTEL_STATE CHARACTER VARYING(80) 80
93 HOTEL_FOLIO_NUMBER CHARACTER VARYING(80) 80
94 HOTEL_ROOM_TYPE CHARACTER VARYING(240) 240
95 AIR_DEPARTURE_DATE TIMESTAMP 8
96 AIR_DEPARTURE_CITY CHARACTER VARYING(80) 80
97 AIR_ROUTING CHARACTER VARYING(80) 80
98 AIR_ARRIVAL_CITY CHARACTER VARYING(80) 80
99 AIR_STOPOVER_FLAG CHARACTER VARYING(1) 1
100 AIR_BASE_FARE_AMOUNT NUMERIC(18,6) 19
101 AIR_FARE_BASIS_CODE CHARACTER VARYING(80) 80
102 AIR_SERVICE_CLASS CHARACTER VARYING(80) 80
103 AIR_CARRIER_ABBREVIATION CHARACTER VARYING(80) 80
104 AIR_CARRIER_CODE CHARACTER VARYING(80) 80
105 AIR_TICKET_ISSUER CHARACTER VARYING(240) 240
106 AIR_ISSUER_CITY CHARACTER VARYING(80) 80
107 AIR_PASSENGER_NAME CHARACTER VARYING(80) 80
108 AIR_REFUND_TICKET_NUMBER CHARACTER VARYING(80) 80
109 AIR_EXCHANGED_TICKET_NUMBER CHARACTER VARYING(80) 80
110 AIR_AGENCY_NUMBER CHARACTER VARYING(80) 80
111 AIR_TICKET_NUMBER CHARACTER VARYING(80) 80
112 FINANCIAL_CATEGORY CHARACTER VARYING(80) 80
113 PAYMENT_FLAG CHARACTER VARYING(1) 1
114 RECORD_TYPE CHARACTER VARYING(80) 80
115 MERCHANT_ACTIVITY CHARACTER VARYING(80) 80
116 CATEGORY CHARACTER VARYING(30) 30
117 REPORT_HEADER_ID BIGINT 8
118 EXPENSE_STATUS CHARACTER VARYING(15) 15
119 COMPANY_PREPAID_INVOICE_ID BIGINT 8
120 INACTIVE_EMP_WF_ITEM_KEY CHARACTER VARYING(50) 50
121 LOCATION_ID BIGINT 8
122 REQUEST_ID BIGINT 8
123 MERCHANT_COUNTRY_CODE CHARACTER VARYING(30) 30
124 DISPUTE_DATE TIMESTAMP 8
125 PAYMENT_DUE_FROM_CODE CHARACTER VARYING(30) 30
126 TRX_AVAILABLE_DATE TIMESTAMP 8
127 CARD_ACCEPTOR_ID BIGINT 8
128 TRXN_DETAIL_FLAG CHARACTER VARYING(1) 1
129 DESCRIPTION CHARACTER VARYING(240) 240
130 CARD_ID BIGINT 8
131 COMPANY_NUMBER CHARACTER VARYING(15) 15
132 MARKET_CODE CHARACTER VARYING(3) 3
133 VALIDATE_REQUEST_ID CHARACTER VARYING(50) 50
134 CUSTOMER_CODE CHARACTER VARYING(100) 100
135 PURCHASE_IDENTIFICATION CHARACTER VARYING(100) 100
136 FUEL_TYPE CHARACTER VARYING(15) 15
137 FUEL_UOM_CODE CHARACTER VARYING(1) 1
138 FUEL_QUANTITY NUMERIC(18,6) 19
139 FUEL_UNIT_PRICE NUMERIC(18,6) 19
140 FUEL_SALE_AMOUNT NUMERIC(18,6) 19
141 NON_FUEL_SALE_AMOUNT NUMERIC(18,6) 19
142 FLEET_IDENTITY_CODE CHARACTER VARYING(100) 100
143 AIR_AGENCY_NAME CHARACTER VARYING(240) 240
144 AIR_TOTAL_LEGS CHARACTER VARYING(15) 15
145 CUSTOMER_DATA1 CHARACTER VARYING(30) 30
146 CUSTOMER_DATA2 CHARACTER VARYING(30) 30
147 CUSTOMER_DATA3 CHARACTER VARYING(30) 30
148 CUSTOMER_DATA4 CHARACTER VARYING(30) 30
149 CUSTOMER_DATA5 CHARACTER VARYING(30) 30
150 CUSTOMER_DATA6 CHARACTER VARYING(30) 30
151 CUSTOMER_DATA7 CHARACTER VARYING(30) 30
152 CUSTOMER_DATA8 CHARACTER VARYING(30) 30
153 CUSTOMER_DATA9 CHARACTER VARYING(30) 30
154 CUSTOMER_DATA10 CHARACTER VARYING(30) 30
155 DCC_FLAG CHARACTER VARYING(1) 1
156 ODOMETER_READING CHARACTER VARYING(40) 40
157 VEHICLE_NUMBER CHARACTER VARYING(40) 40
158 FUEL_BRAND CHARACTER VARYING(80) 80
159 DEVICE_DOWNLOAD_FLAG CHARACTER VARYING(10) 10
160 EMPLOYEE_ID BIGINT 8
161 CARDMEMBER_NAME CHARACTER VARYING(80) 80
162 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
163 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
164 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
165 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
166 DAYS_OUTSTANDING BIGINT 8
167 AMOUNT_UNRECONCILED NUMERIC(19,6) 19
168 DAYS_OUTSTANDING_STRING CHARACTER VARYING(10) 10
169 UNREC_ROW_ID BIGINT 8
170 EMPLOYEE_NAME CHARACTER VARYING(201) 201
171 HIRE_DATE TIMESTAMP 8
172 TERMINATIONDATE TIMESTAMP 8
173 IS_TERMINATED_CURRENT_FISCAL_YEAR CHARACTER VARYING(1) 1
174 IS_TERMINATED_LAST_12_MONTHS CHARACTER VARYING(1) 1
175 TENURE_COMPLETED_YRS NUMERIC(10,1) 19
176 TERMINATED_FLAG CHARACTER VARYING(10) 10
177 EMPLOYEE_HRS_PER_WEEK NUMERIC(6,2) 19
178 PAYROLL_STATUS_CODE CHARACTER VARYING(50) 50
179 PAYROLL_STATUS_NAME CHARACTER VARYING(128) 128
180 POSITIONID INTEGER 4
181 POSITION_NUMBER CHARACTER VARYING(100) 100
182 POSITION_TITLE CHARACTER VARYING(256) 256
183 POSITION_FTE NUMERIC(18,2) 19
184 POSITION_LEVEL_OF_WORK INTEGER 4
185 LEADER_PROFILE_ID INTEGER 4
186 LEADER_PROFILE_DESCRIPTION CHARACTER VARYING(128) 128
187 JOB_FAMILY_ID INTEGER 4
188 JOB_FAMILY_DESCRIPTION CHARACTER VARYING(30) 30
189 JOB_SUBFAMILY_ID INTEGER 4
190 JOB_SUBFAMILY_DESCRIPTION CHARACTER VARYING(40) 40
191 WORK_ADDRESS CHARACTER VARYING(767) 767
192 WORK_CITY CHARACTER VARYING(50) 50
193 WORK_STATECODE CHARACTER VARYING(5) 5
194 WORK_POSTCODE CHARACTER VARYING(12) 12
195 IPCNO CHARACTER VARYING(50) 50
196 POSITION_START_DATE TIMESTAMP 8
197 CURRENT_POSITION_END_DATE TIMESTAMP 8
198 CONTRACT_END_DATE TIMESTAMP 8
199 FULLPART_CODE CHARACTER VARYING(50) 50
200 FULLPART_DESCRIPTION CHARACTER VARYING(128) 128
201 ORGANISATIONAL_UNIT_ID BIGINT 8
202 ORGANISATIONAL_UNIT_LEVEL_NAME CHARACTER VARYING(100) 100
203 BUSINESS_UNIT_CODE CHARACTER VARYING(100) 100
204 BUSINESS_UNIT_NAME CHARACTER VARYING(100) 100
205 BUSINESS_UNIT_CODE_CASCADE CHARACTER VARYING(100) 100
206 BUSINESS_UNIT_LABEL_CASCADE CHARACTER VARYING(100) 100
207 DIVISION_CODE CHARACTER VARYING(100) 100
208 DIVISION_NAME CHARACTER VARYING(100) 100
209 DIVISION_CODE_CASCADE CHARACTER VARYING(100) 100
210 DIVISION_LABEL_CASCADE CHARACTER VARYING(100) 100
211 DEPARTMENT_CODE CHARACTER VARYING(100) 100
212 DEPARTMENT_NAME CHARACTER VARYING(100) 100
213 DEPARTMENT_CODE_CASCADE CHARACTER VARYING(100) 100
214 DEPARTMENT_LABEL_CASCADE CHARACTER VARYING(100) 100
215 SECTION_CODE CHARACTER VARYING(100) 100
216 SECTION_NAME CHARACTER VARYING(100) 100
217 SECTION_CODE_CASCADE CHARACTER VARYING(100) 100
218 SECTION_LABEL_CASCADE CHARACTER VARYING(100) 100
219 TEAM_CODE CHARACTER VARYING(100) 100
220 TEAM_NAME CHARACTER VARYING(100) 100
221 TEAM_CODE_CASCADE CHARACTER VARYING(100) 100
222 TEAM_LABEL_CASCADE CHARACTER VARYING(100) 100
223 DEPARTMENT_COST_CENTRE CHARACTER VARYING(100) 100
224 LEADER_FIRST_NAME CHARACTER VARYING(100) 100
225 LEADER_PREFERRED_NAME CHARACTER VARYING(100) 100
226 LEADER_SURNAME CHARACTER VARYING(100) 100
227 LEADER_REPORTING_NAME CHARACTER VARYING(255) 255
228 LEADER_POSITION_NUMBER CHARACTER VARYING(100) 100
229 LEADER_POSITION_TITLE CHARACTER VARYING(256) 256
230 LEADER_LEADER_PROFILE CHARACTER VARYING(128) 128
231 IS_LEADER CHARACTER VARYING(1) 1
232 HR_EFFECTIVE_DATE TIMESTAMP 8
233 BUSINESS_UNIT_LABEL_PATH CHARACTER VARYING(250) 250
234 DIVISION_LABEL_PATH CHARACTER VARYING(250) 250
235 DEPARTMENT_LABEL_PATH CHARACTER VARYING(250) 250
236 SECTION_LABEL_PATH CHARACTER VARYING(250) 250
237 TEAM_LABEL_PATH CHARACTER VARYING(250) 250
238 EXTENDED_UNPAID_ABSENCE_FLAG INTEGER 4
239 EXTERNAL_COMPANY CHARACTER VARYING(255) 255
240 HEADCOUNT_MTH INTEGER 4
241 TOTAL_FTE_MTH NUMERIC(38,10) 19
242 EMP_DUPE_ROW_NUM BIGINT 8
243 LOB_FTE_MTH_TOTAL NUMERIC(38,10) 19
244 DIV_FTE_MTH_TOTAL NUMERIC(38,10) 19
245 DEPT_FTE_MTH_TOTAL NUMERIC(38,10) 19