OEB_AP_INVOICE_DISTRIBUTIONS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNTING_DATE TIMESTAMP 8
2 ACCRUAL_POSTED_FLAG CHARACTER VARYING(1) 1
3 ASSETS_ADDITION_FLAG CHARACTER VARYING(1) 1
4 ASSETS_TRACKING_FLAG CHARACTER VARYING(1) 1
5 CASH_POSTED_FLAG CHARACTER VARYING(1) 1
6 DISTRIBUTION_LINE_NUMBER BIGINT 8
7 DIST_CODE_COMBINATION_ID BIGINT 8
8 INVOICE_ID BIGINT 8
9 LAST_UPDATED_BY BIGINT 8
10 LAST_UPDATE_DATE TIMESTAMP 8
11 LINE_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
12 PERIOD_NAME CHARACTER VARYING(15) 15
13 SET_OF_BOOKS_ID BIGINT 8
14 ACCTS_PAY_CODE_COMBINATION_ID BIGINT 8
15 AMOUNT NUMERIC(18,2) 19
16 BASE_AMOUNT NUMERIC(18,2) 19
17 BASE_INVOICE_PRICE_VARIANCE NUMERIC(18,2) 19
18 BATCH_ID BIGINT 8
19 CREATED_BY BIGINT 8
20 CREATION_DATE TIMESTAMP 8
21 DESCRIPTION CHARACTER VARYING(240) 240
22 EXCHANGE_RATE_VARIANCE NUMERIC(18,2) 19
23 FINAL_MATCH_FLAG CHARACTER VARYING(1) 1
24 INCOME_TAX_REGION CHARACTER VARYING(10) 10
25 INVOICE_PRICE_VARIANCE NUMERIC(18,2) 19
26 LAST_UPDATE_LOGIN BIGINT 8
27 MATCH_STATUS_FLAG CHARACTER VARYING(1) 1
28 POSTED_FLAG CHARACTER VARYING(1) 1
29 PO_DISTRIBUTION_ID BIGINT 8
30 PROGRAM_APPLICATION_ID BIGINT 8
31 PROGRAM_ID BIGINT 8
32 PROGRAM_UPDATE_DATE TIMESTAMP 8
33 QUANTITY_INVOICED NUMERIC(18,2) 19
34 RATE_VAR_CODE_COMBINATION_ID BIGINT 8
35 REQUEST_ID BIGINT 8
36 REVERSAL_FLAG CHARACTER VARYING(1) 1
37 TYPE_1099 CHARACTER VARYING(10) 10
38 UNIT_PRICE NUMERIC(18,2) 19
39 AMOUNT_ENCUMBERED NUMERIC(18,2) 19
40 BASE_AMOUNT_ENCUMBERED NUMERIC(18,2) 19
41 ENCUMBERED_FLAG CHARACTER VARYING(1) 1
42 EXCHANGE_DATE TIMESTAMP 8
43 EXCHANGE_RATE NUMERIC(18,2) 19
44 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
45 PRICE_ADJUSTMENT_FLAG CHARACTER VARYING(1) 1
46 PRICE_VAR_CODE_COMBINATION_ID BIGINT 8
47 QUANTITY_UNENCUMBERED NUMERIC(18,2) 19
48 STAT_AMOUNT NUMERIC(18,2) 19
49 AMOUNT_TO_POST NUMERIC(18,2) 19
50 ATTRIBUTE1 CHARACTER VARYING(150) 150
51 ATTRIBUTE10 CHARACTER VARYING(150) 150
52 ATTRIBUTE11 CHARACTER VARYING(150) 150
53 ATTRIBUTE12 CHARACTER VARYING(150) 150
54 ATTRIBUTE13 CHARACTER VARYING(150) 150
55 ATTRIBUTE14 CHARACTER VARYING(150) 150
56 ATTRIBUTE15 CHARACTER VARYING(150) 150
57 ATTRIBUTE2 CHARACTER VARYING(150) 150
58 ATTRIBUTE3 CHARACTER VARYING(150) 150
59 ATTRIBUTE4 CHARACTER VARYING(150) 150
60 ATTRIBUTE5 CHARACTER VARYING(150) 150
61 ATTRIBUTE6 CHARACTER VARYING(150) 150
62 ATTRIBUTE7 CHARACTER VARYING(150) 150
63 ATTRIBUTE8 CHARACTER VARYING(150) 150
64 ATTRIBUTE9 CHARACTER VARYING(150) 150
65 ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
66 BASE_AMOUNT_TO_POST NUMERIC(18,2) 19
67 CASH_JE_BATCH_ID BIGINT 8
68 EXPENDITURE_ITEM_DATE TIMESTAMP 8
69 EXPENDITURE_ORGANIZATION_ID BIGINT 8
70 EXPENDITURE_TYPE CHARACTER VARYING(30) 30
71 JE_BATCH_ID BIGINT 8
72 PARENT_INVOICE_ID BIGINT 8
73 PA_ADDITION_FLAG CHARACTER VARYING(1) 1
74 PA_QUANTITY NUMERIC(22,5) 19
75 POSTED_AMOUNT NUMERIC(18,2) 19
76 POSTED_BASE_AMOUNT NUMERIC(18,2) 19
77 PREPAY_AMOUNT_REMAINING NUMERIC(18,2) 19
78 PROJECT_ACCOUNTING_CONTEXT CHARACTER VARYING(30) 30
79 PROJECT_ID BIGINT 8
80 TASK_ID BIGINT 8
81 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
82 USSGL_TRX_CODE_CONTEXT CHARACTER VARYING(30) 30
83 EARLIEST_SETTLEMENT_DATE TIMESTAMP 8
84 REQ_DISTRIBUTION_ID BIGINT 8
85 QUANTITY_VARIANCE NUMERIC(18,2) 19
86 BASE_QUANTITY_VARIANCE NUMERIC(18,2) 19
87 PACKET_ID BIGINT 8
88 AWT_FLAG CHARACTER VARYING(1) 1
89 AWT_GROUP_ID BIGINT 8
90 AWT_TAX_RATE_ID BIGINT 8
91 AWT_GROSS_AMOUNT NUMERIC(18,2) 19
92 AWT_INVOICE_ID BIGINT 8
93 AWT_ORIGIN_GROUP_ID BIGINT 8
94 REFERENCE_1 CHARACTER VARYING(30) 30
95 REFERENCE_2 CHARACTER VARYING(30) 30
96 ORG_ID BIGINT 8
97 OTHER_INVOICE_ID BIGINT 8
98 AWT_INVOICE_PAYMENT_ID BIGINT 8
99 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
100 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
101 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
102 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
103 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
104 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
105 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
106 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
107 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
108 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
109 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
110 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
111 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
112 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
113 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
114 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
115 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
116 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
117 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
118 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
119 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
120 LINE_GROUP_NUMBER BIGINT 8
121 RECEIPT_VERIFIED_FLAG CHARACTER VARYING(1) 1
122 RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
123 RECEIPT_MISSING_FLAG CHARACTER VARYING(1) 1
124 JUSTIFICATION CHARACTER VARYING(240) 240
125 EXPENSE_GROUP CHARACTER VARYING(80) 80
126 START_EXPENSE_DATE TIMESTAMP 8
127 END_EXPENSE_DATE TIMESTAMP 8
128 RECEIPT_CURRENCY_CODE CHARACTER VARYING(15) 15
129 RECEIPT_CONVERSION_RATE NUMERIC(18,2) 19
130 RECEIPT_CURRENCY_AMOUNT NUMERIC(18,2) 19
131 DAILY_AMOUNT NUMERIC(18,2) 19
132 WEB_PARAMETER_ID NUMERIC(18,2) 19
133 ADJUSTMENT_REASON CHARACTER VARYING(240) 240
134 AWARD_ID BIGINT 8
135 MRC_ACCRUAL_POSTED_FLAG CHARACTER VARYING(2000) 2000
136 MRC_CASH_POSTED_FLAG CHARACTER VARYING(2000) 2000
137 MRC_DIST_CODE_COMBINATION_ID CHARACTER VARYING(2000) 2000
138 MRC_AMOUNT CHARACTER VARYING(2000) 2000
139 MRC_BASE_AMOUNT CHARACTER VARYING(2000) 2000
140 MRC_BASE_INV_PRICE_VARIANCE CHARACTER VARYING(2000) 2000
141 MRC_EXCHANGE_RATE_VARIANCE CHARACTER VARYING(2000) 2000
142 MRC_POSTED_FLAG CHARACTER VARYING(2000) 2000
143 MRC_PROGRAM_APPLICATION_ID CHARACTER VARYING(2000) 2000
144 MRC_PROGRAM_ID CHARACTER VARYING(2000) 2000
145 MRC_PROGRAM_UPDATE_DATE CHARACTER VARYING(2000) 2000
146 MRC_RATE_VAR_CCID CHARACTER VARYING(2000) 2000
147 MRC_REQUEST_ID CHARACTER VARYING(2000) 2000
148 MRC_EXCHANGE_DATE CHARACTER VARYING(2000) 2000
149 MRC_EXCHANGE_RATE CHARACTER VARYING(2000) 2000
150 MRC_EXCHANGE_RATE_TYPE CHARACTER VARYING(2000) 2000
151 MRC_AMOUNT_TO_POST CHARACTER VARYING(2000) 2000
152 MRC_BASE_AMOUNT_TO_POST CHARACTER VARYING(2000) 2000
153 MRC_CASH_JE_BATCH_ID CHARACTER VARYING(2000) 2000
154 MRC_JE_BATCH_ID CHARACTER VARYING(2000) 2000
155 MRC_POSTED_AMOUNT CHARACTER VARYING(2000) 2000
156 MRC_POSTED_BASE_AMOUNT CHARACTER VARYING(2000) 2000
157 MRC_RECEIPT_CONVERSION_RATE CHARACTER VARYING(2000) 2000
158 CREDIT_CARD_TRX_ID BIGINT 8
159 DIST_MATCH_TYPE CHARACTER VARYING(25) 25
160 RCV_TRANSACTION_ID BIGINT 8
161 INVOICE_DISTRIBUTION_ID BIGINT 8
162 PARENT_REVERSAL_ID BIGINT 8
163 TAX_RECOVERABLE_FLAG CHARACTER VARYING(1) 1
164 PA_CC_AR_INVOICE_ID BIGINT 8
165 PA_CC_AR_INVOICE_LINE_NUM BIGINT 8
166 PA_CC_PROCESSED_CODE CHARACTER VARYING(1) 1
167 MERCHANT_DOCUMENT_NUMBER CHARACTER VARYING(80) 80
168 MERCHANT_NAME CHARACTER VARYING(80) 80
169 MERCHANT_REFERENCE CHARACTER VARYING(240) 240
170 MERCHANT_TAX_REG_NUMBER CHARACTER VARYING(80) 80
171 MERCHANT_TAXPAYER_ID CHARACTER VARYING(80) 80
172 COUNTRY_OF_SUPPLY CHARACTER VARYING(5) 5
173 MATCHED_UOM_LOOKUP_CODE CHARACTER VARYING(25) 25
174 GMS_BURDENABLE_RAW_COST NUMERIC(22,5) 19
175 ACCOUNTING_EVENT_ID BIGINT 8
176 PREPAY_DISTRIBUTION_ID BIGINT 8
177 UPGRADE_POSTED_AMT NUMERIC(18,2) 19
178 UPGRADE_BASE_POSTED_AMT NUMERIC(18,2) 19
179 INVENTORY_TRANSFER_STATUS CHARACTER VARYING(1) 1
180 COMPANY_PREPAID_INVOICE_ID BIGINT 8
181 CC_REVERSAL_FLAG CHARACTER VARYING(1) 1
182 AWT_WITHHELD_AMT NUMERIC(18,2) 19
183 INVOICE_INCLUDES_PREPAY_FLAG CHARACTER VARYING(1) 1
184 PRICE_CORRECT_INV_ID BIGINT 8
185 PRICE_CORRECT_QTY NUMERIC(18,2) 19
186 PA_CMT_XFACE_FLAG CHARACTER VARYING(1) 1
187 CANCELLATION_FLAG CHARACTER VARYING(1) 1
188 INVOICE_LINE_NUMBER NUMERIC(18,2) 19
189 CORRECTED_INVOICE_DIST_ID BIGINT 8
190 ROUNDING_AMT NUMERIC(18,2) 19
191 CHARGE_APPLICABLE_TO_DIST_ID BIGINT 8
192 CORRECTED_QUANTITY NUMERIC(18,2) 19
193 RELATED_ID BIGINT 8
194 ASSET_BOOK_TYPE_CODE CHARACTER VARYING(15) 15
195 ASSET_CATEGORY_ID BIGINT 8
196 DISTRIBUTION_CLASS CHARACTER VARYING(30) 30
197 FINAL_PAYMENT_ROUNDING NUMERIC(18,2) 19
198 FINAL_APPLICATION_ROUNDING NUMERIC(18,2) 19
199 AMOUNT_AT_PREPAY_XRATE NUMERIC(18,2) 19
200 CASH_BASIS_FINAL_APP_ROUNDING NUMERIC(18,2) 19
201 AMOUNT_AT_PREPAY_PAY_XRATE NUMERIC(18,2) 19
202 INTENDED_USE CHARACTER VARYING(30) 30
203 DETAIL_TAX_DIST_ID BIGINT 8
204 REC_NREC_RATE NUMERIC(18,2) 19
205 RECOVERY_RATE_ID BIGINT 8
206 RECOVERY_RATE_NAME CHARACTER VARYING(150) 150
207 RECOVERY_TYPE_CODE CHARACTER VARYING(30) 30
208 RECOVERY_RATE_CODE CHARACTER VARYING(30) 30
209 WITHHOLDING_TAX_CODE_ID BIGINT 8
210 TAX_ALREADY_DISTRIBUTED_FLAG CHARACTER VARYING(1) 1
211 SUMMARY_TAX_LINE_ID BIGINT 8
212 TAXABLE_AMOUNT NUMERIC(18,2) 19
213 TAXABLE_BASE_AMOUNT NUMERIC(18,2) 19
214 EXTRA_PO_ERV NUMERIC(18,2) 19
215 PREPAY_TAX_DIFF_AMOUNT NUMERIC(18,2) 19
216 TAX_CODE_ID BIGINT 8
217 VAT_CODE CHARACTER VARYING(80) 80
218 AMOUNT_INCLUDES_TAX_FLAG CHARACTER VARYING(1) 1
219 TAX_CALCULATED_FLAG CHARACTER VARYING(1) 1
220 TAX_RECOVERY_RATE NUMERIC(18,2) 19
221 TAX_RECOVERY_OVERRIDE_FLAG CHARACTER VARYING(1) 1
222 TAX_CODE_OVERRIDE_FLAG CHARACTER VARYING(1) 1
223 TOTAL_DIST_AMOUNT NUMERIC(18,2) 19
224 TOTAL_DIST_BASE_AMOUNT NUMERIC(18,2) 19
225 PREPAY_TAX_PARENT_ID BIGINT 8
226 CANCELLED_FLAG CHARACTER VARYING(1) 1
227 OLD_DISTRIBUTION_ID BIGINT 8
228 OLD_DIST_LINE_NUMBER BIGINT 8
229 AMOUNT_VARIANCE NUMERIC(18,2) 19
230 BASE_AMOUNT_VARIANCE NUMERIC(18,2) 19
231 HISTORICAL_FLAG CHARACTER VARYING(1) 1
232 RCV_CHARGE_ADDITION_FLAG CHARACTER VARYING(1) 1
233 AWT_RELATED_ID BIGINT 8
234 RELATED_RETAINAGE_DIST_ID BIGINT 8
235 RETAINED_AMOUNT_REMAINING NUMERIC(18,2) 19
236 BC_EVENT_ID BIGINT 8
237 RETAINED_INVOICE_DIST_ID BIGINT 8
238 FINAL_RELEASE_ROUNDING NUMERIC(18,2) 19
239 FULLY_PAID_ACCTD_FLAG CHARACTER VARYING(1) 1
240 ROOT_DISTRIBUTION_ID BIGINT 8
241 XINV_PARENT_REVERSAL_ID BIGINT 8
242 RECURRING_PAYMENT_ID BIGINT 8
243 RELEASE_INV_DIST_DERIVED_FROM BIGINT 8
244 PAY_AWT_GROUP_ID BIGINT 8
245 CDC_SOURCE_SYSTEM_CODE CHARACTER(4) 4
246 CDC_RECORD_TYPE CHARACTER(16) 16
247 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
248 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8