OEB_AP_SUPPLIERS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 VENDOR_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 VENDOR_NAME CHARACTER VARYING(240) 240
5 VENDOR_NAME_ALT CHARACTER VARYING(320) 320
6 SEGMENT1 CHARACTER VARYING(30) 30
7 SUMMARY_FLAG CHARACTER VARYING(1) 1
8 ENABLED_FLAG CHARACTER VARYING(1) 1
9 SEGMENT2 CHARACTER VARYING(30) 30
10 SEGMENT3 CHARACTER VARYING(30) 30
11 SEGMENT4 CHARACTER VARYING(30) 30
12 SEGMENT5 CHARACTER VARYING(30) 30
13 LAST_UPDATE_LOGIN BIGINT 8
14 CREATION_DATE TIMESTAMP 8
15 CREATED_BY BIGINT 8
16 EMPLOYEE_ID BIGINT 8
17 VENDOR_TYPE_LOOKUP_CODE CHARACTER VARYING(30) 30
18 CUSTOMER_NUM CHARACTER VARYING(25) 25
19 ONE_TIME_FLAG CHARACTER VARYING(1) 1
20 PARENT_VENDOR_ID BIGINT 8
21 MIN_ORDER_AMOUNT BIGINT 8
22 SHIP_TO_LOCATION_ID BIGINT 8
23 BILL_TO_LOCATION_ID BIGINT 8
24 SHIP_VIA_LOOKUP_CODE CHARACTER VARYING(25) 25
25 FREIGHT_TERMS_LOOKUP_CODE CHARACTER VARYING(25) 25
26 FOB_LOOKUP_CODE CHARACTER VARYING(25) 25
27 TERMS_ID BIGINT 8
28 SET_OF_BOOKS_ID BIGINT 8
29 CREDIT_STATUS_LOOKUP_CODE CHARACTER VARYING(25) 25
30 CREDIT_LIMIT NUMERIC(18,2) 19
31 ALWAYS_TAKE_DISC_FLAG CHARACTER VARYING(1) 1
32 PAY_DATE_BASIS_LOOKUP_CODE CHARACTER VARYING(25) 25
33 PAY_GROUP_LOOKUP_CODE CHARACTER VARYING(25) 25
34 PAYMENT_PRIORITY NUMERIC(18,2) 19
35 INVOICE_CURRENCY_CODE CHARACTER VARYING(15) 15
36 PAYMENT_CURRENCY_CODE CHARACTER VARYING(15) 15
37 INVOICE_AMOUNT_LIMIT NUMERIC(18,2) 19
38 EXCHANGE_DATE_LOOKUP_CODE CHARACTER VARYING(25) 25
39 HOLD_ALL_PAYMENTS_FLAG CHARACTER VARYING(1) 1
40 HOLD_FUTURE_PAYMENTS_FLAG CHARACTER VARYING(1) 1
41 HOLD_REASON CHARACTER VARYING(240) 240
42 DISTRIBUTION_SET_ID BIGINT 8
43 ACCTS_PAY_CODE_COMBINATION_ID BIGINT 8
44 DISC_LOST_CODE_COMBINATION_ID BIGINT 8
45 DISC_TAKEN_CODE_COMBINATION_ID BIGINT 8
46 EXPENSE_CODE_COMBINATION_ID BIGINT 8
47 PREPAY_CODE_COMBINATION_ID BIGINT 8
48 NUM_1099 CHARACTER VARYING(30) 30
49 TYPE_1099 CHARACTER VARYING(10) 10
50 WITHHOLDING_STATUS_LOOKUP_CODE CHARACTER VARYING(25) 25
51 WITHHOLDING_START_DATE TIMESTAMP 8
52 ORGANIZATION_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
53 VAT_CODE CHARACTER VARYING(30) 30
54 START_DATE_ACTIVE TIMESTAMP 8
55 END_DATE_ACTIVE TIMESTAMP 8
56 MINORITY_GROUP_LOOKUP_CODE CHARACTER VARYING(30) 30
57 PAYMENT_METHOD_LOOKUP_CODE CHARACTER VARYING(25) 25
58 BANK_ACCOUNT_NAME CHARACTER VARYING(80) 80
59 BANK_ACCOUNT_NUM CHARACTER VARYING(30) 30
60 BANK_NUM CHARACTER VARYING(25) 25
61 BANK_ACCOUNT_TYPE CHARACTER VARYING(25) 25
62 WOMEN_OWNED_FLAG CHARACTER VARYING(1) 1
63 SMALL_BUSINESS_FLAG CHARACTER VARYING(1) 1
64 STANDARD_INDUSTRY_CLASS CHARACTER VARYING(25) 25
65 HOLD_FLAG CHARACTER VARYING(1) 1
66 PURCHASING_HOLD_REASON CHARACTER VARYING(240) 240
67 HOLD_BY BIGINT 8
68 HOLD_DATE TIMESTAMP 8
69 TERMS_DATE_BASIS CHARACTER VARYING(25) 25
70 PRICE_TOLERANCE NUMERIC(18,2) 19
71 INSPECTION_REQUIRED_FLAG CHARACTER VARYING(1) 1
72 RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
73 QTY_RCV_TOLERANCE NUMERIC(18,2) 19
74 QTY_RCV_EXCEPTION_CODE CHARACTER VARYING(25) 25
75 ENFORCE_SHIP_TO_LOCATION_CODE CHARACTER VARYING(25) 25
76 DAYS_EARLY_RECEIPT_ALLOWED NUMERIC(18,2) 19
77 DAYS_LATE_RECEIPT_ALLOWED NUMERIC(18,2) 19
78 RECEIPT_DAYS_EXCEPTION_CODE CHARACTER VARYING(25) 25
79 RECEIVING_ROUTING_ID BIGINT 8
80 ALLOW_SUBSTITUTE_RECEIPTS_FLAG CHARACTER VARYING(1) 1
81 ALLOW_UNORDERED_RECEIPTS_FLAG CHARACTER VARYING(1) 1
82 HOLD_UNMATCHED_INVOICES_FLAG CHARACTER VARYING(1) 1
83 EXCLUSIVE_PAYMENT_FLAG CHARACTER VARYING(1) 1
84 AP_TAX_ROUNDING_RULE CHARACTER VARYING(1) 1
85 AUTO_TAX_CALC_FLAG CHARACTER VARYING(1) 1
86 AUTO_TAX_CALC_OVERRIDE CHARACTER VARYING(1) 1
87 AMOUNT_INCLUDES_TAX_FLAG CHARACTER VARYING(1) 1
88 TAX_VERIFICATION_DATE TIMESTAMP 8
89 NAME_CONTROL CHARACTER VARYING(4) 4
90 STATE_REPORTABLE_FLAG CHARACTER VARYING(1) 1
91 FEDERAL_REPORTABLE_FLAG CHARACTER VARYING(1) 1
92 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
93 ATTRIBUTE1 CHARACTER VARYING(150) 150
94 ATTRIBUTE2 CHARACTER VARYING(150) 150
95 ATTRIBUTE3 CHARACTER VARYING(150) 150
96 ATTRIBUTE4 CHARACTER VARYING(150) 150
97 ATTRIBUTE5 CHARACTER VARYING(150) 150
98 ATTRIBUTE6 CHARACTER VARYING(150) 150
99 ATTRIBUTE7 CHARACTER VARYING(150) 150
100 ATTRIBUTE8 CHARACTER VARYING(150) 150
101 ATTRIBUTE9 CHARACTER VARYING(150) 150
102 ATTRIBUTE10 CHARACTER VARYING(150) 150
103 ATTRIBUTE11 CHARACTER VARYING(150) 150
104 ATTRIBUTE12 CHARACTER VARYING(150) 150
105 ATTRIBUTE13 CHARACTER VARYING(150) 150
106 ATTRIBUTE14 CHARACTER VARYING(150) 150
107 ATTRIBUTE15 CHARACTER VARYING(150) 150
108 REQUEST_ID BIGINT 8
109 PROGRAM_APPLICATION_ID BIGINT 8
110 PROGRAM_ID BIGINT 8
111 PROGRAM_UPDATE_DATE TIMESTAMP 8
112 OFFSET_VAT_CODE CHARACTER VARYING(20) 20
113 VAT_REGISTRATION_NUM CHARACTER VARYING(20) 20
114 AUTO_CALCULATE_INTEREST_FLAG CHARACTER VARYING(1) 1
115 VALIDATION_NUMBER BIGINT 8
116 EXCLUDE_FREIGHT_FROM_DISCOUNT CHARACTER VARYING(1) 1
117 TAX_REPORTING_NAME CHARACTER VARYING(80) 80
118 CHECK_DIGITS CHARACTER VARYING(30) 30
119 BANK_NUMBER CHARACTER VARYING(30) 30
120 ALLOW_AWT_FLAG CHARACTER VARYING(1) 1
121 AWT_GROUP_ID BIGINT 8
122 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
123 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
124 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
125 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
126 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
127 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
128 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
129 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
130 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
131 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
132 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
133 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
134 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
135 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
136 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
137 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
138 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
139 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
140 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
141 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
142 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
143 EDI_TRANSACTION_HANDLING CHARACTER VARYING(25) 25
144 EDI_PAYMENT_METHOD CHARACTER VARYING(25) 25
145 EDI_PAYMENT_FORMAT CHARACTER VARYING(25) 25
146 EDI_REMITTANCE_METHOD CHARACTER VARYING(25) 25
147 EDI_REMITTANCE_INSTRUCTION CHARACTER VARYING(256) 256
148 BANK_CHARGE_BEARER CHARACTER VARYING(1) 1
149 BANK_BRANCH_TYPE CHARACTER VARYING(25) 25
150 MATCH_OPTION CHARACTER VARYING(25) 25
151 FUTURE_DATED_PAYMENT_CCID BIGINT 8
152 CREATE_DEBIT_MEMO_FLAG CHARACTER VARYING(25) 25
153 OFFSET_TAX_FLAG CHARACTER VARYING(1) 1
154 PARTY_ID BIGINT 8
155 PARENT_PARTY_ID BIGINT 8
156 NI_NUMBER CHARACTER VARYING(30) 30
157 TCA_SYNC_NUM_1099 CHARACTER VARYING(30) 30
158 TCA_SYNC_VENDOR_NAME CHARACTER VARYING(360) 360
159 TCA_SYNC_VAT_REG_NUM CHARACTER VARYING(50) 50
160 UNIQUE_TAX_REFERENCE_NUM BIGINT 8
161 PARTNERSHIP_UTR BIGINT 8
162 PARTNERSHIP_NAME CHARACTER VARYING(240) 240
163 CIS_ENABLED_FLAG CHARACTER VARYING(1) 1
164 FIRST_NAME CHARACTER VARYING(240) 240
165 SECOND_NAME CHARACTER VARYING(240) 240
166 LAST_NAME CHARACTER VARYING(240) 240
167 SALUTATION CHARACTER VARYING(30) 30
168 TRADING_NAME CHARACTER VARYING(240) 240
169 WORK_REFERENCE CHARACTER VARYING(30) 30
170 COMPANY_REGISTRATION_NUMBER CHARACTER VARYING(30) 30
171 NATIONAL_INSURANCE_NUMBER CHARACTER VARYING(30) 30
172 VERIFICATION_NUMBER CHARACTER VARYING(30) 30
173 VERIFICATION_REQUEST_ID BIGINT 8
174 MATCH_STATUS_FLAG CHARACTER VARYING(1) 1
175 CIS_VERIFICATION_DATE TIMESTAMP 8
176 INDIVIDUAL_1099 CHARACTER VARYING(30) 30
177 PAY_AWT_GROUP_ID BIGINT 8
178 CIS_PARENT_VENDOR_ID BIGINT 8
179 BUS_CLASS_LAST_CERTIFIED_DATE TIMESTAMP 8
180 BUS_CLASS_LAST_CERTIFIED_BY BIGINT 8
181 CDC_SOURCE_SYSTEM_CODE CHARACTER(4) 4
182 CDC_RECORD_TYPE CHARACTER(16) 16
183 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
184 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8