INT_EMP_CATEGORISE3_V

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 REPORT_HEADER_ID BIGINT 8
2 LINES_LAST_UPDATE_DATE DATE 4
3 ITEM_DESCRIPTION CHARACTER VARYING(240) 240
4 EXPENSE_LINE_AMOUNT NUMERIC(18,6) 19
5 AVERAGE_COST_PER_ATTENDEE NUMERIC(37,25) 19
6 SET_OF_BOOKS_ID BIGINT 8
7 ATTRIBUTE_CATEGORY CHARACTER VARYING(80) 80
8 CURRENCY_CODE CHARACTER VARYING(15) 15
9 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
10 EXCHANGE_RATE NUMERIC(18,6) 19
11 EXCHANGE_DATE DATE 4
12 VAT_CODE CHARACTER VARYING(30) 30
13 LINE_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
14 SUBMITTED_DATE TIMESTAMP 8
15 APPROVED_DATE TIMESTAMP 8
16 CREATION_DATE DATE 4
17 CREATED_BY BIGINT 8
18 DISTRIBUTION_LINE_NUMBER BIGINT 8
19 RECEIPT_VERIFIED_FLAG CHARACTER VARYING(1) 1
20 JUSTIFICATION_REQUIRED_FLAG CHARACTER VARYING(1) 1
21 RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
22 RECEIPT_MISSING_FLAG CHARACTER VARYING(1) 1
23 JUSTIFICATION CHARACTER VARYING(240) 240
24 START_EXPENSE_DATE DATE 4
25 END_EXPENSE_DATE DATE 4
26 RECEIPT_CURRENCY_CODE CHARACTER VARYING(15) 15
27 RECEIPT_CONVERSION_RATE NUMERIC(18,6) 19
28 DAILY_AMOUNT NUMERIC(18,6) 19
29 RECEIPT_CURRENCY_AMOUNT NUMERIC(18,6) 19
30 WEB_PARAMETER_ID BIGINT 8
31 AMOUNT_INCLUDES_TAX_FLAG CHARACTER VARYING(1) 1
32 MERCHANT_NAME CHARACTER VARYING(240) 240
33 TAX_CODE_OVERRIDE_FLAG CHARACTER VARYING(1) 1
34 CREDIT_CARD_TRX_ID BIGINT 8
35 ATTENDEES CHARACTER VARYING(240) 240
36 NUMBER_ATTENDEES BIGINT 8
37 TICKET_CLASS_CODE CHARACTER VARYING(30) 30
38 TICKET_NUMBER CHARACTER VARYING(80) 80
39 ITEMIZATION_PARENT_ID BIGINT 8
40 FLEX_CONCATENATED CHARACTER VARYING(240) 240
41 LOCATION CHARACTER VARYING(80) 80
42 CATEGORY_CODE CHARACTER VARYING(30) 30
43 ADJUSTMENT_REASON_CODE CHARACTER VARYING(30) 30
44 AP_VALIDATION_ERROR CHARACTER VARYING(240) 240
45 SUBMITTED_AMOUNT NUMERIC(18,6) 19
46 REPORT_LINE_ID BIGINT 8
47 ALLOCATION_REASON CHARACTER VARYING(240) 240
48 ALLOCATION_SPLIT_CODE CHARACTER VARYING(30) 30
49 IMAGE_RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
50 CARD_PROGRAM_ID BIGINT 8
51 EXPENSED_AMOUNT NUMERIC(18,6) 19
52 REFERENCE_NUMBER CHARACTER VARYING(240) 240
53 TRANSACTION_TYPE CHARACTER VARYING(80) 80
54 TRANSACTION_DATE TIMESTAMP 8
55 TRANSACTION_AMOUNT NUMERIC(18,6) 19
56 DEBIT_FLAG CHARACTER VARYING(1) 1
57 DAYS_BILLED_DATE_TO_SUBMITTED_DATE BIGINT 8
58 DAYS_SUBMITTED_DATE_TO_APPROVED_DATE BIGINT 8
59 DAYS_BILLED_DATE_TO_APPROVED_DATE BIGINT 8
60 BILLED_DATE TIMESTAMP 8
61 BILLED_AMOUNT NUMERIC(18,6) 19
62 BILLED_DECIMAL BIGINT 8
63 BILLED_CURRENCY_CODE CHARACTER VARYING(15) 15
64 POSTED_DATE TIMESTAMP 8
65 POSTED_AMOUNT NUMERIC(18,6) 19
66 POSTED_DECIMAL BIGINT 8
67 POSTED_CURRENCY_CODE CHARACTER VARYING(15) 15
68 CURRENCY_CONVERSION_EXPONENT BIGINT 8
69 CURRENCY_CONVERSION_RATE NUMERIC(18,6) 19
70 MIS_INDUSTRY_CODE CHARACTER VARYING(80) 80
71 SIC_CODE BIGINT 8
72 MERCHANT_NAME1 CHARACTER VARYING(240) 240
73 MERCHANT_NAME2 CHARACTER VARYING(80) 80
74 MERCHANT_ADDRESS1 CHARACTER VARYING(80) 80
75 MERCHANT_ADDRESS2 CHARACTER VARYING(80) 80
76 MERCHANT_ADDRESS3 CHARACTER VARYING(80) 80
77 MERCHANT_ADDRESS4 CHARACTER VARYING(80) 80
78 MERCHANT_CITY CHARACTER VARYING(80) 80
79 MERCHANT_PROVINCE_STATE CHARACTER VARYING(80) 80
80 MERCHANT_POSTAL_CODE CHARACTER VARYING(80) 80
81 MERCHANT_COUNTRY CHARACTER VARYING(80) 80
82 TOTAL_TAX NUMERIC(18,6) 19
83 LOCAL_TAX NUMERIC(18,6) 19
84 CREDIT_CARD_TRXN_LAST_UPDATE_DATE TIMESTAMP 8
85 CREDIT_CARD_TRXN_LAST_UPDATED_BY BIGINT 8
86 CREDIT_CARD_TRXN_LAST_UPDATE_LOGIN BIGINT 8
87 CREDIT_CARD_TRXN_CREATION_DATE TIMESTAMP 8
88 FOLIO_TYPE CHARACTER VARYING(80) 80
89 ATM_CASH_ADVANCE NUMERIC(18,6) 19
90 ATM_TRANSACTION_DATE TIMESTAMP 8
91 ATM_FEE_AMOUNT NUMERIC(18,6) 19
92 ATM_TYPE CHARACTER VARYING(80) 80
93 ATM_ID CHARACTER VARYING(80) 80
94 ATM_NETWORK_ID CHARACTER VARYING(80) 80
95 RESTAURANT_TIP_AMOUNT NUMERIC(18,6) 19
96 CAR_RENTAL_DATE TIMESTAMP 8
97 CAR_RETURN_DATE TIMESTAMP 8
98 CAR_RENTAL_LOCATION CHARACTER VARYING(80) 80
99 CAR_RENTAL_STATE CHARACTER VARYING(80) 80
100 CAR_RETURN_LOCATION CHARACTER VARYING(80) 80
101 CAR_RETURN_STATE CHARACTER VARYING(80) 80
102 CAR_RENTER_NAME CHARACTER VARYING(240) 240
103 CAR_RENTAL_DAYS CHARACTER VARYING(80) 80
104 CAR_RENTAL_AGREEMENT_NUMBER CHARACTER VARYING(80) 80
105 CAR_MILEAGE_AMOUNT NUMERIC(18,6) 19
106 CAR_DAILY_RATE NUMERIC(18,6) 19
107 HOTEL_ARRIVAL_DATE TIMESTAMP 8
108 HOTEL_DEPART_DATE TIMESTAMP 8
109 HOTEL_CHARGE_DESC CHARACTER VARYING(80) 80
110 HOTEL_GUEST_NAME CHARACTER VARYING(80) 80
111 HOTEL_STAY_DURATION NUMERIC(18,6) 19
112 HOTEL_ROOM_RATE NUMERIC(18,6) 19
113 HOTEL_HEALTH_AMOUNT NUMERIC(18,6) 19
114 HOTEL_RESTAURANT_AMOUNT NUMERIC(18,6) 19
115 HOTEL_STATE CHARACTER VARYING(80) 80
116 AIR_DEPARTURE_DATE TIMESTAMP 8
117 AIR_DEPARTURE_CITY CHARACTER VARYING(80) 80
118 AIR_ROUTING CHARACTER VARYING(80) 80
119 AIR_SERVICE_CLASS CHARACTER VARYING(80) 80
120 AIR_CARRIER_CODE CHARACTER VARYING(80) 80
121 AIR_TICKET_ISSUER CHARACTER VARYING(240) 240
122 AIR_ISSUER_CITY CHARACTER VARYING(80) 80
123 AIR_PASSENGER_NAME CHARACTER VARYING(80) 80
124 AIR_TICKET_NUMBER CHARACTER VARYING(80) 80
125 FINANCIAL_CATEGORY CHARACTER VARYING(80) 80
126 PAYMENT_FLAG CHARACTER VARYING(1) 1
127 CATEGORY CHARACTER VARYING(30) 30
128 AMEX_EXPENSE_STATUS CHARACTER VARYING(15) 15
129 EXPENSE_STATUS CHARACTER VARYING(11) 11
130 CC_COMPANY_PREPAID_INVOICE_ID BIGINT 8
131 CC_REQUEST_ID BIGINT 8
132 DISPUTE_DATE TIMESTAMP 8
133 PAYMENT_DUE_FROM_CODE CHARACTER VARYING(30) 30
134 TRX_AVAILABLE_DATE TIMESTAMP 8
135 TRXN_DETAIL_FLAG CHARACTER VARYING(1) 1
136 DESCRIPTION CHARACTER VARYING(240) 240
137 CARD_ID BIGINT 8
138 VALIDATE_REQUEST_ID CHARACTER VARYING(50) 50
139 DEVICE_DOWNLOAD_FLAG CHARACTER VARYING(10) 10
140 REIMBURSEMENT_TYPE CHARACTER VARYING(4) 4
141 EMPLOYEE_UNUMBER CHARACTER VARYING(30) 30
142 MANAGER_UNUMBER CHARACTER VARYING(30) 30
143 EMPLOYEE_NUMBER CHARACTER VARYING(35) 35
144 ITEM_JUSTIFICATION_CAT CHARACTER VARYING(481) 481
145 DERIVED_CAT1 CHARACTER VARYING(16) 16
146 DERIVED_CAT2 CHARACTER VARYING(81) 81
147 DERIVED_CAT3 CHARACTER VARYING(81) 81
148 CATEGORY_L2 CHARACTER VARYING(20) 20
149 CATEGORY_L1 CHARACTER VARYING(18) 18