OEB_AP_EXPENSE_REPORT_LINES_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_HEADER_ID BIGINT 8
2 LAST_UPDATE_DATE DATE 4
3 LAST_UPDATED_BY BIGINT 8
4 CODE_COMBINATION_ID BIGINT 8
5 ITEM_DESCRIPTION CHARACTER VARYING(240) 240
6 SET_OF_BOOKS_ID BIGINT 8
7 AMOUNT NUMERIC(18,6) 19
8 ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
9 ATTRIBUTE1 CHARACTER VARYING(150) 150
10 ATTRIBUTE2 CHARACTER VARYING(150) 150
11 ATTRIBUTE3 CHARACTER VARYING(150) 150
12 ATTRIBUTE4 CHARACTER VARYING(150) 150
13 ATTRIBUTE5 CHARACTER VARYING(150) 150
14 ATTRIBUTE6 CHARACTER VARYING(150) 150
15 ATTRIBUTE7 CHARACTER VARYING(150) 150
16 ATTRIBUTE8 CHARACTER VARYING(150) 150
17 ATTRIBUTE9 CHARACTER VARYING(150) 150
18 ATTRIBUTE10 CHARACTER VARYING(150) 150
19 ATTRIBUTE11 CHARACTER VARYING(150) 150
20 ATTRIBUTE12 CHARACTER VARYING(150) 150
21 ATTRIBUTE13 CHARACTER VARYING(150) 150
22 ATTRIBUTE14 CHARACTER VARYING(150) 150
23 ATTRIBUTE15 CHARACTER VARYING(150) 150
24 CURRENCY_CODE CHARACTER VARYING(15) 15
25 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
26 EXCHANGE_RATE NUMERIC(18,6) 19
27 EXCHANGE_DATE DATE 4
28 VAT_CODE CHARACTER VARYING(30) 30
29 LINE_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
30 LAST_UPDATE_LOGIN BIGINT 8
31 CREATION_DATE DATE 4
32 CREATED_BY BIGINT 8
33 STAT_AMOUNT NUMERIC(18,6) 19
34 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
35 USSGL_TRX_CODE_CONTEXT CHARACTER VARYING(30) 30
36 PROJECT_ACCOUNTING_CONTEXT CHARACTER VARYING(30) 30
37 PROJECT_ID BIGINT 8
38 TASK_ID BIGINT 8
39 EXPENDITURE_ORGANIZATION_ID BIGINT 8
40 EXPENDITURE_TYPE CHARACTER VARYING(30) 30
41 EXPENDITURE_ITEM_DATE DATE 4
42 PA_QUANTITY NUMERIC(18,6) 19
43 DISTRIBUTION_LINE_NUMBER BIGINT 8
44 REFERENCE_1 CHARACTER VARYING(30) 30
45 REFERENCE_2 CHARACTER VARYING(30) 30
46 AWT_GROUP_ID BIGINT 8
47 ORG_ID BIGINT 8
48 RECEIPT_VERIFIED_FLAG CHARACTER VARYING(1) 1
49 JUSTIFICATION_REQUIRED_FLAG CHARACTER VARYING(1) 1
50 RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
51 RECEIPT_MISSING_FLAG CHARACTER VARYING(1) 1
52 JUSTIFICATION CHARACTER VARYING(240) 240
53 EXPENSE_GROUP CHARACTER VARYING(80) 80
54 START_EXPENSE_DATE DATE 4
55 END_EXPENSE_DATE DATE 4
56 RECEIPT_CURRENCY_CODE CHARACTER VARYING(15) 15
57 RECEIPT_CONVERSION_RATE NUMERIC(18,6) 19
58 DAILY_AMOUNT NUMERIC(18,6) 19
59 RECEIPT_CURRENCY_AMOUNT NUMERIC(18,6) 19
60 WEB_PARAMETER_ID BIGINT 8
61 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
62 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
63 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
64 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
65 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
66 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
67 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
68 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
69 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
70 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
71 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
72 AMOUNT_INCLUDES_TAX_FLAG CHARACTER VARYING(1) 1
73 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
74 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
75 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
76 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
77 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
78 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
79 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
80 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
81 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
82 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
83 ADJUSTMENT_REASON CHARACTER VARYING(240) 240
84 POLICY_SHORTPAY_FLAG CHARACTER VARYING(1) 1
85 AWARD_ID BIGINT 8
86 MERCHANT_DOCUMENT_NUMBER CHARACTER VARYING(80) 80
87 MERCHANT_NAME CHARACTER VARYING(240) 240
88 MERCHANT_REFERENCE CHARACTER VARYING(240) 240
89 MERCHANT_TAX_REG_NUMBER CHARACTER VARYING(80) 80
90 MERCHANT_TAXPAYER_ID CHARACTER VARYING(80) 80
91 COUNTRY_OF_SUPPLY CHARACTER VARYING(5) 5
92 TAX_CODE_OVERRIDE_FLAG CHARACTER VARYING(1) 1
93 TAX_CODE_ID BIGINT 8
94 CREDIT_CARD_TRX_ID BIGINT 8
95 ITEMIZE_ID BIGINT 8
96 PROJECT_NAME CHARACTER VARYING(30) 30
97 TASK_NAME CHARACTER VARYING(30) 30
98 COMPANY_PREPAID_INVOICE_ID BIGINT 8
99 PA_INTERFACED_FLAG CHARACTER VARYING(1) 1
100 PROJECT_NUMBER CHARACTER VARYING(30) 30
101 TASK_NUMBER CHARACTER VARYING(30) 30
102 AWARD_NUMBER CHARACTER VARYING(15) 15
103 VEHICLE_CATEGORY_CODE CHARACTER VARYING(30) 30
104 VEHICLE_TYPE CHARACTER VARYING(30) 30
105 FUEL_TYPE CHARACTER VARYING(30) 30
106 NUMBER_PEOPLE BIGINT 8
107 DAILY_DISTANCE NUMERIC(18,6) 19
108 DISTANCE_UNIT_CODE CHARACTER VARYING(30) 30
109 AVG_MILEAGE_RATE NUMERIC(18,6) 19
110 DESTINATION_FROM CHARACTER VARYING(80) 80
111 DESTINATION_TO CHARACTER VARYING(80) 80
112 TRIP_DISTANCE NUMERIC(18,6) 19
113 LICENSE_PLATE_NUMBER CHARACTER VARYING(30) 30
114 MILEAGE_RATE_ADJUSTED_FLAG CHARACTER VARYING(1) 1
115 LOCATION_ID BIGINT 8
116 NUM_PDM_DAYS1 NUMERIC(18,6) 19
117 NUM_PDM_DAYS2 NUMERIC(18,6) 19
118 NUM_PDM_DAYS3 NUMERIC(18,6) 19
119 PER_DIEM_RATE1 NUMERIC(18,6) 19
120 PER_DIEM_RATE2 NUMERIC(18,6) 19
121 PER_DIEM_RATE3 NUMERIC(18,6) 19
122 DEDUCTION_ADDITION_AMT1 NUMERIC(18,6) 19
123 DEDUCTION_ADDITION_AMT2 NUMERIC(18,6) 19
124 DEDUCTION_ADDITION_AMT3 NUMERIC(18,6) 19
125 NUM_FREE_BREAKFASTS1 NUMERIC(18,6) 19
126 NUM_FREE_LUNCHES1 NUMERIC(18,6) 19
127 NUM_FREE_DINNERS1 NUMERIC(18,6) 19
128 NUM_FREE_ACCOMMODATIONS1 NUMERIC(18,6) 19
129 NUM_FREE_BREAKFASTS2 NUMERIC(18,6) 19
130 NUM_FREE_LUNCHES2 NUMERIC(18,6) 19
131 NUM_FREE_DINNERS2 NUMERIC(18,6) 19
132 NUM_FREE_ACCOMMODATIONS2 NUMERIC(18,6) 19
133 NUM_FREE_BREAKFASTS3 NUMERIC(18,6) 19
134 NUM_FREE_LUNCHES3 NUMERIC(18,6) 19
135 NUM_FREE_DINNERS3 NUMERIC(18,6) 19
136 NUM_FREE_ACCOMMODATIONS3 NUMERIC(18,6) 19
137 ATTENDEES CHARACTER VARYING(240) 240
138 NUMBER_ATTENDEES BIGINT 8
139 TRAVEL_TYPE CHARACTER VARYING(30) 30
140 TICKET_CLASS_CODE CHARACTER VARYING(30) 30
141 TICKET_NUMBER CHARACTER VARYING(80) 80
142 FLIGHT_NUMBER CHARACTER VARYING(80) 80
143 LOCATION_TO_ID BIGINT 8
144 ITEMIZATION_PARENT_ID BIGINT 8
145 FLEX_CONCATENATED CHARACTER VARYING(240) 240
146 FUNC_CURRENCY_AMT NUMERIC(18,6) 19
147 LOCATION CHARACTER VARYING(80) 80
148 CATEGORY_CODE CHARACTER VARYING(30) 30
149 ADJUSTMENT_REASON_CODE CHARACTER VARYING(30) 30
150 AP_VALIDATION_ERROR CHARACTER VARYING(240) 240
151 SUBMITTED_AMOUNT NUMERIC(18,6) 19
152 REPORT_LINE_ID BIGINT 8
153 RATE_PER_PASSENGER NUMERIC(18,6) 19
154 PASSENGER_RATE_TYPE CHARACTER VARYING(30) 30
155 PASSENGER_AMOUNT NUMERIC(18,6) 19
156 RANGE_LOW NUMERIC(18,6) 19
157 RANGE_HIGH NUMERIC(18,6) 19
158 UOM_DAYS NUMERIC(18,6) 19
159 ALLOCATION_REASON CHARACTER VARYING(240) 240
160 ALLOCATION_SPLIT_CODE CHARACTER VARYING(30) 30
161 IMAGE_RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
162 RECEIPTS_ISSUE CHARACTER VARYING(240) 240
163 ADJUSTMENT_REASON_COPY CHARACTER VARYING(30) 30
164 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
165 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
166 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
167 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
168 MERCHANT_NAME_1 CHARACTER VARYING(240) 240