FCT_EMP_EXPENSE_AMEX_AGING_T_TAL

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AIR_CARRIER_CODE CHARACTER VARYING(80) 80
2 AIR_DEPARTURE_CITY CHARACTER VARYING(80) 80
3 AIR_DEPARTURE_DATE TIMESTAMP 8
4 AIR_ISSUER_CITY CHARACTER VARYING(80) 80
5 AIR_PASSENGER_NAME CHARACTER VARYING(80) 80
6 AIR_ROUTING CHARACTER VARYING(80) 80
7 AIR_SERVICE_CLASS CHARACTER VARYING(80) 80
8 AIR_TICKET_ISSUER CHARACTER VARYING(240) 240
9 AIR_TICKET_NUMBER CHARACTER VARYING(80) 80
10 AP_VALIDATION_ERROR CHARACTER VARYING(240) 240
11 APPROVED_DATE TIMESTAMP 8
12 ATM_CASH_ADVANCE NUMERIC(18,6) 19
13 ATM_FEE_AMOUNT NUMERIC(18,6) 19
14 ATM_ID CHARACTER VARYING(80) 80
15 ATM_NETWORK_ID CHARACTER VARYING(80) 80
16 ATM_TRANSACTION_DATE TIMESTAMP 8
17 ATM_TYPE CHARACTER VARYING(80) 80
18 ATTENDEES CHARACTER VARYING(240) 240
19 ATTRIBUTE_CATEGORY CHARACTER VARYING(80) 80
20 AVERAGE_COST_PER_ATTENDEE NUMERIC(37,25) 19
21 BILLED_AMOUNT NUMERIC(18,6) 19
22 BILLED_CURRENCY_CODE CHARACTER VARYING(15) 15
23 BILLED_DATE TIMESTAMP 8
24 BILLED_DECIMAL BIGINT 8
25 CAR_DAILY_RATE NUMERIC(18,6) 19
26 CAR_MILEAGE_AMOUNT NUMERIC(18,6) 19
27 CAR_RENTAL_AGREEMENT_NUMBER CHARACTER VARYING(80) 80
28 CAR_RENTAL_DATE TIMESTAMP 8
29 CAR_RENTAL_DAYS CHARACTER VARYING(80) 80
30 CAR_RENTAL_LOCATION CHARACTER VARYING(80) 80
31 CAR_RENTAL_STATE CHARACTER VARYING(80) 80
32 CAR_RENTER_NAME CHARACTER VARYING(240) 240
33 CAR_RETURN_DATE TIMESTAMP 8
34 CAR_RETURN_LOCATION CHARACTER VARYING(80) 80
35 CAR_RETURN_STATE CHARACTER VARYING(80) 80
36 CARD_ID BIGINT 8
37 CARD_PROGRAM_ID BIGINT 8
38 CATEGORY CHARACTER VARYING(30) 30
39 CATEGORY_CODE CHARACTER VARYING(30) 30
40 CC_COMPANY_PREPAID_INVOICE_ID BIGINT 8
41 CREATED_BY BIGINT 8
42 CREATION_DATE TIMESTAMP 8
43 CREDIT_CARD_TRX_ID BIGINT 8
44 CREDIT_CARD_TRXN_CREATION_DATE TIMESTAMP 8
45 CREDIT_CARD_TRXN_LAST_UPDATE_DATE TIMESTAMP 8
46 CREDIT_CARD_TRXN_LAST_UPDATE_LOGIN BIGINT 8
47 CREDIT_CARD_TRXN_LAST_UPDATED_BY BIGINT 8
48 CURRENCY_CODE CHARACTER VARYING(15) 15
49 CURRENCY_CONVERSION_EXPONENT BIGINT 8
50 CURRENCY_CONVERSION_RATE NUMERIC(18,6) 19
51 DAILY_AMOUNT NUMERIC(18,6) 19
52 DAYS_BILLED_DATE_TO_APPROVED_DATE BIGINT 8
53 DAYS_BILLED_DATE_TO_SUBMITTED_DATE BIGINT 8
54 DAYS_SUBMITTED_DATE_TO_APPROVED_DATE BIGINT 8
55 DEBIT_FLAG CHARACTER VARYING(1) 1
56 DESCRIPTION CHARACTER VARYING(240) 240
57 DEVICE_DOWNLOAD_FLAG CHARACTER VARYING(10) 10
58 DISPUTE_DATE TIMESTAMP 8
59 DISTRIBUTION_LINE_NUMBER BIGINT 8
60 EMPLOYEE_UNUMBER CHARACTER VARYING(30) 30
61 EMPLOYEE_UNUMBER_JOIN CHARACTER VARYING(35) 35
62 END_EXPENSE_DATE DATE 4
63 EXCHANGE_DATE DATE 4
64 EXCHANGE_RATE NUMERIC(18,6) 19
65 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
66 EXPENSE_LINE_AMOUNT NUMERIC(18,6) 19
67 EXPENSE_STATUS CHARACTER VARYING(15) 15
68 AMEX_EXPENSE_STATUS CHARACTER VARYING(15) 15
69 EXPENSED_AMOUNT NUMERIC(18,6) 19
70 FINANCIAL_CATEGORY CHARACTER VARYING(80) 80
71 FOLIO_TYPE CHARACTER VARYING(80) 80
72 HOTEL_ARRIVAL_DATE TIMESTAMP 8
73 HOTEL_CHARGE_DESC CHARACTER VARYING(80) 80
74 HOTEL_DEPART_DATE TIMESTAMP 8
75 HOTEL_GUEST_NAME CHARACTER VARYING(80) 80
76 HOTEL_HEALTH_AMOUNT NUMERIC(18,6) 19
77 HOTEL_RESTAURANT_AMOUNT NUMERIC(18,6) 19
78 HOTEL_ROOM_RATE NUMERIC(18,6) 19
79 HOTEL_STATE CHARACTER VARYING(80) 80
80 HOTEL_STAY_DURATION NUMERIC(18,6) 19
81 IMAGE_RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
82 ITEM_DESCRIPTION CHARACTER VARYING(240) 240
83 ITEMIZATION_PARENT_ID BIGINT 8
84 JUSTIFICATION CHARACTER VARYING(240) 240
85 JUSTIFICATION_REQUIRED_FLAG CHARACTER VARYING(1) 1
86 LINE_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
87 LINES_LAST_UPDATE_DATE DATE 4
88 LOCAL_TAX NUMERIC(18,6) 19
89 LOCATION CHARACTER VARYING(80) 80
90 MANAGER_UNUMBER CHARACTER VARYING(30) 30
91 MERCHANT_ADDRESS1 CHARACTER VARYING(80) 80
92 MERCHANT_ADDRESS2 CHARACTER VARYING(80) 80
93 MERCHANT_ADDRESS3 CHARACTER VARYING(80) 80
94 MERCHANT_ADDRESS4 CHARACTER VARYING(80) 80
95 MERCHANT_CITY CHARACTER VARYING(80) 80
96 MERCHANT_COUNTRY CHARACTER VARYING(80) 80
97 MERCHANT_NAME CHARACTER VARYING(240) 240
98 MERCHANT_NAME1 CHARACTER VARYING(240) 240
99 MERCHANT_NAME2 CHARACTER VARYING(80) 80
100 MERCHANT_POSTAL_CODE CHARACTER VARYING(80) 80
101 MERCHANT_PROVINCE_STATE CHARACTER VARYING(80) 80
102 MIS_INDUSTRY_CODE CHARACTER VARYING(80) 80
103 NUMBER_ATTENDEES BIGINT 8
104 PAYMENT_DUE_FROM_CODE CHARACTER VARYING(30) 30
105 PAYMENT_FLAG CHARACTER VARYING(1) 1
106 POSTED_AMOUNT NUMERIC(18,6) 19
107 POSTED_CURRENCY_CODE CHARACTER VARYING(15) 15
108 POSTED_DATE TIMESTAMP 8
109 POSTED_DECIMAL BIGINT 8
110 RECEIPT_MISSING_FLAG CHARACTER VARYING(1) 1
111 RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
112 RECEIPT_VERIFIED_FLAG CHARACTER VARYING(1) 1
113 REFERENCE_NUMBER CHARACTER VARYING(240) 240
114 REIMBURSEMENT_TYPE CHARACTER VARYING(4) 4
115 REPORT_HEADER_ID BIGINT 8
116 REPORT_LINE_ID BIGINT 8
117 RESTAURANT_TIP_AMOUNT NUMERIC(18,6) 19
118 SET_OF_BOOKS_ID BIGINT 8
119 SIC_CODE BIGINT 8
120 START_EXPENSE_DATE DATE 4
121 SUBMITTED_AMOUNT NUMERIC(18,6) 19
122 SUBMITTED_DATE TIMESTAMP 8
123 TICKET_CLASS_CODE CHARACTER VARYING(30) 30
124 TICKET_NUMBER CHARACTER VARYING(80) 80
125 TOTAL_TAX NUMERIC(18,6) 19
126 TRANSACTION_AMOUNT NUMERIC(18,6) 19
127 TRANSACTION_DATE TIMESTAMP 8
128 TRANSACTION_TYPE CHARACTER VARYING(80) 80
129 TRX_AVAILABLE_DATE TIMESTAMP 8
130 TRXN_DETAIL_FLAG CHARACTER VARYING(1) 1
131 VALIDATE_REQUEST_ID CHARACTER VARYING(50) 50
132 WEB_PARAMETER_ID BIGINT 8
133 NOTES_DETAIL CHARACTER VARYING(2000) 2000
134 EMPLOYEE_NUMBER CHARACTER VARYING(55) 55
135 EMPLOYEE_NAME CHARACTER VARYING(201) 201
136 HIRE_DATE TIMESTAMP 8
137 TERMINATIONDATE TIMESTAMP 8
138 TERMINATED_FLAG CHARACTER VARYING(10) 10
139 EMPLOYEE_HRS_PER_WEEK NUMERIC(6,2) 19
140 PAYROLL_STATUS_CODE CHARACTER VARYING(50) 50
141 PAYROLL_STATUS_NAME CHARACTER VARYING(128) 128
142 POSITIONID INTEGER 4
143 POSITION_NUMBER CHARACTER VARYING(100) 100
144 POSITION_TITLE CHARACTER VARYING(256) 256
145 POSITION_FTE NUMERIC(18,2) 19
146 POSITION_LEVEL_OF_WORK INTEGER 4
147 LEADER_PROFILE_ID INTEGER 4
148 LEADER_PROFILE_DESCRIPTION CHARACTER VARYING(128) 128
149 JOB_FAMILY_ID INTEGER 4
150 JOB_FAMILY_DESCRIPTION CHARACTER VARYING(30) 30
151 JOB_SUBFAMILY_ID INTEGER 4
152 JOB_SUBFAMILY_DESCRIPTION CHARACTER VARYING(40) 40
153 WORK_ADDRESS CHARACTER VARYING(767) 767
154 WORK_CITY CHARACTER VARYING(50) 50
155 WORK_STATECODE CHARACTER VARYING(5) 5
156 WORK_POSTCODE CHARACTER VARYING(12) 12
157 POSITION_START_DATE TIMESTAMP 8
158 CURRENT_POSITION_END_DATE TIMESTAMP 8
159 CONTRACT_END_DATE TIMESTAMP 8
160 FULLPART_CODE CHARACTER VARYING(50) 50
161 FULLPART_DESCRIPTION CHARACTER VARYING(128) 128
162 ORGANISATIONAL_UNIT_ID BIGINT 8
163 ORGANISATIONAL_UNIT_LEVEL_NAME CHARACTER VARYING(100) 100
164 BUSINESS_UNIT_CODE CHARACTER VARYING(100) 100
165 BUSINESS_UNIT_NAME CHARACTER VARYING(100) 100
166 BUSINESS_UNIT_CODE_CASCADE CHARACTER VARYING(100) 100
167 BUSINESS_UNIT_LABEL_CASCADE CHARACTER VARYING(100) 100
168 DIVISION_CODE CHARACTER VARYING(100) 100
169 DIVISION_NAME CHARACTER VARYING(100) 100
170 DIVISION_CODE_CASCADE CHARACTER VARYING(100) 100
171 DIVISION_LABEL_CASCADE CHARACTER VARYING(100) 100
172 DEPARTMENT_CODE CHARACTER VARYING(100) 100
173 DEPARTMENT_NAME CHARACTER VARYING(100) 100
174 DEPARTMENT_CODE_CASCADE CHARACTER VARYING(100) 100
175 DEPARTMENT_LABEL_CASCADE CHARACTER VARYING(100) 100
176 SECTION_CODE CHARACTER VARYING(100) 100
177 SECTION_NAME CHARACTER VARYING(100) 100
178 SECTION_CODE_CASCADE CHARACTER VARYING(100) 100
179 SECTION_LABEL_CASCADE CHARACTER VARYING(100) 100
180 TEAM_CODE CHARACTER VARYING(100) 100
181 TEAM_NAME CHARACTER VARYING(100) 100
182 TEAM_CODE_CASCADE CHARACTER VARYING(100) 100
183 TEAM_LABEL_CASCADE CHARACTER VARYING(100) 100
184 DEPARTMENT_COST_CENTRE CHARACTER VARYING(100) 100
185 LEADER_FIRST_NAME CHARACTER VARYING(100) 100
186 LEADER_PREFERRED_NAME CHARACTER VARYING(100) 100
187 LEADER_SURNAME CHARACTER VARYING(100) 100
188 LEADER_REPORTING_NAME CHARACTER VARYING(255) 255
189 LEADER_POSITION_NUMBER CHARACTER VARYING(100) 100
190 LEADER_POSITION_TITLE CHARACTER VARYING(256) 256
191 LEADER_LEADER_PROFILE CHARACTER VARYING(128) 128
192 IS_LEADER CHARACTER VARYING(1) 1
193 EFFECTIVEDATE TIMESTAMP 8
194 BUSINESS_UNIT_LABEL_PATH CHARACTER VARYING(250) 250
195 DIVISION_LABEL_PATH CHARACTER VARYING(250) 250
196 DEPARTMENT_LABEL_PATH CHARACTER VARYING(250) 250
197 SECTION_LABEL_PATH CHARACTER VARYING(250) 250
198 TEAM_LABEL_PATH CHARACTER VARYING(250) 250
199 EXTENDED_UNPAID_ABSENCE_FLAG INTEGER 4
200 EXTERNAL_COMPANY CHARACTER VARYING(255) 255
201 HEADCOUNT_MTH INTEGER 4
202 TOTAL_FTE_MTH NUMERIC(38,10) 19
203 EMP_DUPE_ROW_NUM BIGINT 8
204 SIC SMALLINT 2
205 SIC_DETAIL CHARACTER VARYING(30) 30
206 FORBIDDEN_FLAG INTEGER 4
207 TAXI_FLAG INTEGER 4
208 TAXI_EXPENSIVE_FLAG INTEGER 4
209 EXPENSE_STATUS_CODE CHARACTER VARYING(30) 30