OEB_AP_INVOICES_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INVOICE_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 VENDOR_ID BIGINT 8
5 INVOICE_NUM CHARACTER VARYING(50) 50
6 SET_OF_BOOKS_ID BIGINT 8
7 INVOICE_CURRENCY_CODE CHARACTER VARYING(15) 15
8 PAYMENT_CURRENCY_CODE CHARACTER VARYING(15) 15
9 PAYMENT_CROSS_RATE NUMERIC(18,2) 19
10 INVOICE_AMOUNT NUMERIC(18,2) 19
11 VENDOR_SITE_ID BIGINT 8
12 AMOUNT_PAID NUMERIC(18,2) 19
13 DISCOUNT_AMOUNT_TAKEN NUMERIC(18,2) 19
14 INVOICE_DATE TIMESTAMP 8
15 SOURCE CHARACTER VARYING(25) 25
16 INVOICE_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
17 DESCRIPTION CHARACTER VARYING(240) 240
18 BATCH_ID BIGINT 8
19 AMOUNT_APPLICABLE_TO_DISCOUNT NUMERIC(18,2) 19
20 TAX_AMOUNT NUMERIC(18,2) 19
21 TERMS_ID BIGINT 8
22 TERMS_DATE TIMESTAMP 8
23 PAYMENT_METHOD_LOOKUP_CODE CHARACTER VARYING(25) 25
24 PAY_GROUP_LOOKUP_CODE CHARACTER VARYING(25) 25
25 ACCTS_PAY_CODE_COMBINATION_ID BIGINT 8
26 PAYMENT_STATUS_FLAG CHARACTER VARYING(1) 1
27 CREATION_DATE TIMESTAMP 8
28 CREATED_BY BIGINT 8
29 BASE_AMOUNT NUMERIC(18,2) 19
30 VAT_CODE CHARACTER VARYING(15) 15
31 LAST_UPDATE_LOGIN BIGINT 8
32 EXCLUSIVE_PAYMENT_FLAG CHARACTER VARYING(1) 1
33 PO_HEADER_ID BIGINT 8
34 FREIGHT_AMOUNT NUMERIC(18,2) 19
35 GOODS_RECEIVED_DATE TIMESTAMP 8
36 INVOICE_RECEIVED_DATE TIMESTAMP 8
37 VOUCHER_NUM CHARACTER VARYING(50) 50
38 APPROVED_AMOUNT NUMERIC(18,2) 19
39 RECURRING_PAYMENT_ID BIGINT 8
40 EXCHANGE_RATE NUMERIC(18,2) 19
41 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
42 EXCHANGE_DATE TIMESTAMP 8
43 EARLIEST_SETTLEMENT_DATE TIMESTAMP 8
44 ORIGINAL_PREPAYMENT_AMOUNT NUMERIC(18,2) 19
45 DOC_SEQUENCE_ID BIGINT 8
46 DOC_SEQUENCE_VALUE NUMERIC(18,2) 19
47 DOC_CATEGORY_CODE CHARACTER VARYING(30) 30
48 ATTRIBUTE1 CHARACTER VARYING(150) 150
49 ATTRIBUTE2 CHARACTER VARYING(150) 150
50 ATTRIBUTE3 CHARACTER VARYING(150) 150
51 ATTRIBUTE4 CHARACTER VARYING(150) 150
52 ATTRIBUTE5 CHARACTER VARYING(150) 150
53 ATTRIBUTE6 CHARACTER VARYING(150) 150
54 ATTRIBUTE7 CHARACTER VARYING(150) 150
55 ATTRIBUTE8 CHARACTER VARYING(150) 150
56 ATTRIBUTE9 CHARACTER VARYING(150) 150
57 ATTRIBUTE10 CHARACTER VARYING(150) 150
58 ATTRIBUTE11 CHARACTER VARYING(150) 150
59 ATTRIBUTE12 CHARACTER VARYING(150) 150
60 ATTRIBUTE13 CHARACTER VARYING(150) 150
61 ATTRIBUTE14 CHARACTER VARYING(150) 150
62 ATTRIBUTE15 CHARACTER VARYING(150) 150
63 ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
64 APPROVAL_STATUS CHARACTER VARYING(25) 25
65 APPROVAL_DESCRIPTION CHARACTER VARYING(240) 240
66 INVOICE_DISTRIBUTION_TOTAL NUMERIC(18,2) 19
67 POSTING_STATUS CHARACTER VARYING(15) 15
68 PREPAY_FLAG CHARACTER VARYING(1) 1
69 AUTHORIZED_BY CHARACTER VARYING(25) 25
70 CANCELLED_DATE TIMESTAMP 8
71 CANCELLED_BY BIGINT 8
72 CANCELLED_AMOUNT NUMERIC(18,2) 19
73 TEMP_CANCELLED_AMOUNT NUMERIC(18,2) 19
74 PROJECT_ACCOUNTING_CONTEXT CHARACTER VARYING(30) 30
75 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
76 USSGL_TRX_CODE_CONTEXT CHARACTER VARYING(30) 30
77 PROJECT_ID BIGINT 8
78 TASK_ID BIGINT 8
79 EXPENDITURE_TYPE CHARACTER VARYING(30) 30
80 EXPENDITURE_ITEM_DATE TIMESTAMP 8
81 PA_QUANTITY NUMERIC(22,5) 19
82 EXPENDITURE_ORGANIZATION_ID BIGINT 8
83 PA_DEFAULT_DIST_CCID BIGINT 8
84 VENDOR_PREPAY_AMOUNT NUMERIC(18,2) 19
85 PAYMENT_AMOUNT_TOTAL NUMERIC(18,2) 19
86 AWT_FLAG CHARACTER VARYING(1) 1
87 AWT_GROUP_ID BIGINT 8
88 REFERENCE_1 CHARACTER VARYING(30) 30
89 REFERENCE_2 CHARACTER VARYING(30) 30
90 ORG_ID BIGINT 8
91 PRE_WITHHOLDING_AMOUNT NUMERIC(18,2) 19
92 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
93 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
94 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
95 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
96 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
97 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
98 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
99 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
100 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
101 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
102 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
103 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
104 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
105 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
106 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
107 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
108 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
109 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
110 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
111 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
112 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
113 AUTO_TAX_CALC_FLAG CHARACTER VARYING(1) 1
114 PAYMENT_CROSS_RATE_TYPE CHARACTER VARYING(30) 30
115 PAYMENT_CROSS_RATE_DATE TIMESTAMP 8
116 PAY_CURR_INVOICE_AMOUNT NUMERIC(18,2) 19
117 MRC_BASE_AMOUNT CHARACTER VARYING(1000) 1000
118 MRC_EXCHANGE_RATE CHARACTER VARYING(1000) 1000
119 MRC_EXCHANGE_RATE_TYPE CHARACTER VARYING(1000) 1000
120 MRC_EXCHANGE_DATE CHARACTER VARYING(1000) 1000
121 MRC_POSTING_STATUS CHARACTER VARYING(1000) 1000
122 GL_DATE TIMESTAMP 8
123 AWARD_ID BIGINT 8
124 PAID_ON_BEHALF_EMPLOYEE_ID BIGINT 8
125 AMT_DUE_CCARD_COMPANY NUMERIC(18,2) 19
126 AMT_DUE_EMPLOYEE NUMERIC(18,2) 19
127 APPROVAL_READY_FLAG CHARACTER VARYING(1) 1
128 APPROVAL_ITERATION BIGINT 8
129 WFAPPROVAL_STATUS CHARACTER VARYING(50) 50
130 REQUESTER_ID BIGINT 8
131 VALIDATION_REQUEST_ID BIGINT 8
132 VALIDATED_TAX_AMOUNT NUMERIC(18,2) 19
133 QUICK_CREDIT CHARACTER VARYING(1) 1
134 CREDITED_INVOICE_ID BIGINT 8
135 DISTRIBUTION_SET_ID BIGINT 8
136 APPLICATION_ID BIGINT 8
137 PRODUCT_TABLE CHARACTER VARYING(30) 30
138 REFERENCE_KEY1 CHARACTER VARYING(150) 150
139 REFERENCE_KEY2 CHARACTER VARYING(150) 150
140 REFERENCE_KEY3 CHARACTER VARYING(150) 150
141 REFERENCE_KEY4 CHARACTER VARYING(150) 150
142 REFERENCE_KEY5 CHARACTER VARYING(150) 150
143 TOTAL_TAX_AMOUNT NUMERIC(18,2) 19
144 SELF_ASSESSED_TAX_AMOUNT NUMERIC(18,2) 19
145 TAX_RELATED_INVOICE_ID BIGINT 8
146 TRX_BUSINESS_CATEGORY CHARACTER VARYING(240) 240
147 USER_DEFINED_FISC_CLASS CHARACTER VARYING(240) 240
148 TAXATION_COUNTRY CHARACTER VARYING(30) 30
149 DOCUMENT_SUB_TYPE CHARACTER VARYING(150) 150
150 SUPPLIER_TAX_INVOICE_NUMBER CHARACTER VARYING(150) 150
151 SUPPLIER_TAX_INVOICE_DATE TIMESTAMP 8
152 SUPPLIER_TAX_EXCHANGE_RATE NUMERIC(18,2) 19
153 TAX_INVOICE_RECORDING_DATE TIMESTAMP 8
154 TAX_INVOICE_INTERNAL_SEQ CHARACTER VARYING(150) 150
155 LEGAL_ENTITY_ID BIGINT 8
156 HISTORICAL_FLAG CHARACTER VARYING(1) 1
157 FORCE_REVALIDATION_FLAG CHARACTER VARYING(1) 1
158 BANK_CHARGE_BEARER CHARACTER VARYING(30) 30
159 REMITTANCE_MESSAGE1 CHARACTER VARYING(150) 150
160 REMITTANCE_MESSAGE2 CHARACTER VARYING(150) 150
161 REMITTANCE_MESSAGE3 CHARACTER VARYING(150) 150
162 UNIQUE_REMITTANCE_IDENTIFIER CHARACTER VARYING(30) 30
163 URI_CHECK_DIGIT CHARACTER VARYING(2) 2
164 SETTLEMENT_PRIORITY CHARACTER VARYING(30) 30
165 PAYMENT_REASON_CODE CHARACTER VARYING(30) 30
166 PAYMENT_REASON_COMMENTS CHARACTER VARYING(240) 240
167 PAYMENT_METHOD_CODE CHARACTER VARYING(30) 30
168 DELIVERY_CHANNEL_CODE CHARACTER VARYING(30) 30
169 QUICK_PO_HEADER_ID BIGINT 8
170 NET_OF_RETAINAGE_FLAG CHARACTER VARYING(1) 1
171 RELEASE_AMOUNT_NET_OF_TAX NUMERIC(18,2) 19
172 CONTROL_AMOUNT NUMERIC(18,2) 19
173 PARTY_ID BIGINT 8
174 PARTY_SITE_ID BIGINT 8
175 PAY_PROC_TRXN_TYPE_CODE CHARACTER VARYING(30) 30
176 PAYMENT_FUNCTION CHARACTER VARYING(30) 30
177 CUST_REGISTRATION_CODE CHARACTER VARYING(50) 50
178 CUST_REGISTRATION_NUMBER CHARACTER VARYING(30) 30
179 PORT_OF_ENTRY_CODE CHARACTER VARYING(30) 30
180 EXTERNAL_BANK_ACCOUNT_ID BIGINT 8
181 VENDOR_CONTACT_ID BIGINT 8
182 INTERNAL_CONTACT_EMAIL CHARACTER VARYING(1000) 1000
183 DISC_IS_INV_LESS_TAX_FLAG CHARACTER VARYING(1) 1
184 EXCLUDE_FREIGHT_FROM_DISCOUNT CHARACTER VARYING(1) 1
185 PAY_AWT_GROUP_ID BIGINT 8
186 ORIGINAL_INVOICE_AMOUNT NUMERIC(18,2) 19
187 DISPUTE_REASON CHARACTER VARYING(100) 100
188 REMIT_TO_SUPPLIER_NAME CHARACTER VARYING(240) 240
189 REMIT_TO_SUPPLIER_ID BIGINT 8
190 REMIT_TO_SUPPLIER_SITE CHARACTER VARYING(240) 240
191 REMIT_TO_SUPPLIER_SITE_ID BIGINT 8
192 RELATIONSHIP_ID BIGINT 8
193 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
194 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
195 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
196 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8