OEB_AP_SUPPLIER_SITES_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 VENDOR_SITE_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 VENDOR_ID BIGINT 8
5 VENDOR_SITE_CODE CHARACTER VARYING(15) 15
6 VENDOR_SITE_CODE_ALT CHARACTER VARYING(320) 320
7 LAST_UPDATE_LOGIN BIGINT 8
8 CREATION_DATE TIMESTAMP 8
9 CREATED_BY BIGINT 8
10 PURCHASING_SITE_FLAG CHARACTER VARYING(1) 1
11 RFQ_ONLY_SITE_FLAG CHARACTER VARYING(1) 1
12 PAY_SITE_FLAG CHARACTER VARYING(1) 1
13 ATTENTION_AR_FLAG CHARACTER VARYING(1) 1
14 ADDRESS_LINE1 CHARACTER VARYING(240) 240
15 ADDRESS_LINES_ALT CHARACTER VARYING(560) 560
16 ADDRESS_LINE2 CHARACTER VARYING(240) 240
17 ADDRESS_LINE3 CHARACTER VARYING(240) 240
18 CITY CHARACTER VARYING(60) 60
19 STATE CHARACTER VARYING(150) 150
20 ZIP CHARACTER VARYING(60) 60
21 PROVINCE CHARACTER VARYING(150) 150
22 COUNTRY CHARACTER VARYING(60) 60
23 AREA_CODE CHARACTER VARYING(10) 10
24 PHONE CHARACTER VARYING(15) 15
25 CUSTOMER_NUM CHARACTER VARYING(25) 25
26 SHIP_TO_LOCATION_ID BIGINT 8
27 BILL_TO_LOCATION_ID BIGINT 8
28 SHIP_VIA_LOOKUP_CODE CHARACTER VARYING(25) 25
29 FREIGHT_TERMS_LOOKUP_CODE CHARACTER VARYING(25) 25
30 FOB_LOOKUP_CODE CHARACTER VARYING(25) 25
31 INACTIVE_DATE TIMESTAMP 8
32 FAX CHARACTER VARYING(15) 15
33 FAX_AREA_CODE CHARACTER VARYING(10) 10
34 TELEX CHARACTER VARYING(15) 15
35 PAYMENT_METHOD_LOOKUP_CODE CHARACTER VARYING(25) 25
36 BANK_ACCOUNT_NAME CHARACTER VARYING(80) 80
37 BANK_ACCOUNT_NUM CHARACTER VARYING(30) 30
38 BANK_NUM CHARACTER VARYING(25) 25
39 BANK_ACCOUNT_TYPE CHARACTER VARYING(25) 25
40 TERMS_DATE_BASIS CHARACTER VARYING(25) 25
41 CURRENT_CATALOG_NUM CHARACTER VARYING(20) 20
42 VAT_CODE CHARACTER VARYING(30) 30
43 DISTRIBUTION_SET_ID BIGINT 8
44 ACCTS_PAY_CODE_COMBINATION_ID BIGINT 8
45 PREPAY_CODE_COMBINATION_ID BIGINT 8
46 PAY_GROUP_LOOKUP_CODE CHARACTER VARYING(25) 25
47 PAYMENT_PRIORITY NUMERIC(18,2) 19
48 TERMS_ID BIGINT 8
49 INVOICE_AMOUNT_LIMIT NUMERIC(18,2) 19
50 PAY_DATE_BASIS_LOOKUP_CODE CHARACTER VARYING(25) 25
51 ALWAYS_TAKE_DISC_FLAG CHARACTER VARYING(1) 1
52 INVOICE_CURRENCY_CODE CHARACTER VARYING(15) 15
53 PAYMENT_CURRENCY_CODE CHARACTER VARYING(15) 15
54 HOLD_ALL_PAYMENTS_FLAG CHARACTER VARYING(1) 1
55 HOLD_FUTURE_PAYMENTS_FLAG CHARACTER VARYING(1) 1
56 HOLD_REASON CHARACTER VARYING(240) 240
57 HOLD_UNMATCHED_INVOICES_FLAG CHARACTER VARYING(1) 1
58 AP_TAX_ROUNDING_RULE CHARACTER VARYING(1) 1
59 AUTO_TAX_CALC_FLAG CHARACTER VARYING(1) 1
60 AUTO_TAX_CALC_OVERRIDE CHARACTER VARYING(1) 1
61 AMOUNT_INCLUDES_TAX_FLAG CHARACTER VARYING(1) 1
62 EXCLUSIVE_PAYMENT_FLAG CHARACTER VARYING(1) 1
63 TAX_REPORTING_SITE_FLAG CHARACTER VARYING(1) 1
64 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
65 ATTRIBUTE1 CHARACTER VARYING(150) 150
66 ATTRIBUTE2 CHARACTER VARYING(150) 150
67 ATTRIBUTE3 CHARACTER VARYING(150) 150
68 ATTRIBUTE4 CHARACTER VARYING(150) 150
69 ATTRIBUTE5 CHARACTER VARYING(150) 150
70 ATTRIBUTE6 CHARACTER VARYING(150) 150
71 ATTRIBUTE7 CHARACTER VARYING(150) 150
72 ATTRIBUTE8 CHARACTER VARYING(150) 150
73 ATTRIBUTE9 CHARACTER VARYING(150) 150
74 ATTRIBUTE10 CHARACTER VARYING(150) 150
75 ATTRIBUTE11 CHARACTER VARYING(150) 150
76 ATTRIBUTE12 CHARACTER VARYING(150) 150
77 ATTRIBUTE13 CHARACTER VARYING(150) 150
78 ATTRIBUTE14 CHARACTER VARYING(150) 150
79 ATTRIBUTE15 CHARACTER VARYING(150) 150
80 REQUEST_ID BIGINT 8
81 PROGRAM_APPLICATION_ID BIGINT 8
82 PROGRAM_ID BIGINT 8
83 PROGRAM_UPDATE_DATE TIMESTAMP 8
84 VALIDATION_NUMBER BIGINT 8
85 EXCLUDE_FREIGHT_FROM_DISCOUNT CHARACTER VARYING(1) 1
86 VAT_REGISTRATION_NUM CHARACTER VARYING(20) 20
87 OFFSET_VAT_CODE CHARACTER VARYING(20) 20
88 ORG_ID BIGINT 8
89 CHECK_DIGITS CHARACTER VARYING(30) 30
90 BANK_NUMBER CHARACTER VARYING(30) 30
91 ADDRESS_LINE4 CHARACTER VARYING(240) 240
92 COUNTY CHARACTER VARYING(150) 150
93 ADDRESS_STYLE CHARACTER VARYING(30) 30
94 LANGUAGE CHARACTER VARYING(30) 30
95 ALLOW_AWT_FLAG CHARACTER VARYING(1) 1
96 AWT_GROUP_ID BIGINT 8
97 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
98 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
99 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
100 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
101 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
102 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
103 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
104 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
105 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
106 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
107 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
108 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
109 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
110 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
111 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
112 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
113 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
114 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
115 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
116 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
117 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
118 EDI_TRANSACTION_HANDLING CHARACTER VARYING(25) 25
119 EDI_ID_NUMBER CHARACTER VARYING(30) 30
120 EDI_PAYMENT_METHOD CHARACTER VARYING(25) 25
121 EDI_PAYMENT_FORMAT CHARACTER VARYING(25) 25
122 EDI_REMITTANCE_METHOD CHARACTER VARYING(25) 25
123 BANK_CHARGE_BEARER CHARACTER VARYING(1) 1
124 EDI_REMITTANCE_INSTRUCTION CHARACTER VARYING(256) 256
125 BANK_BRANCH_TYPE CHARACTER VARYING(25) 25
126 PAY_ON_CODE CHARACTER VARYING(25) 25
127 DEFAULT_PAY_SITE_ID BIGINT 8
128 PAY_ON_RECEIPT_SUMMARY_CODE CHARACTER VARYING(25) 25
129 TP_HEADER_ID BIGINT 8
130 ECE_TP_LOCATION_CODE CHARACTER VARYING(60) 60
131 PCARD_SITE_FLAG CHARACTER VARYING(1) 1
132 MATCH_OPTION CHARACTER VARYING(25) 25
133 COUNTRY_OF_ORIGIN_CODE CHARACTER VARYING(2) 2
134 FUTURE_DATED_PAYMENT_CCID BIGINT 8
135 CREATE_DEBIT_MEMO_FLAG CHARACTER VARYING(25) 25
136 OFFSET_TAX_FLAG CHARACTER VARYING(1) 1
137 SUPPLIER_NOTIF_METHOD CHARACTER VARYING(25) 25
138 EMAIL_ADDRESS CHARACTER VARYING(1000) 1000
139 REMITTANCE_EMAIL CHARACTER VARYING(1000) 1000
140 PRIMARY_PAY_SITE_FLAG CHARACTER VARYING(1) 1
141 SHIPPING_CONTROL CHARACTER VARYING(30) 30
142 SELLING_COMPANY_IDENTIFIER CHARACTER VARYING(10) 10
143 GAPLESS_INV_NUM_FLAG CHARACTER VARYING(1) 1
144 DUNS_NUMBER CHARACTER VARYING(30) 30
145 TOLERANCE_ID BIGINT 8
146 LOCATION_ID BIGINT 8
147 PARTY_SITE_ID BIGINT 8
148 SERVICES_TOLERANCE_ID BIGINT 8
149 RETAINAGE_RATE NUMERIC(18,2) 19
150 TCA_SYNC_STATE CHARACTER VARYING(150) 150
151 TCA_SYNC_PROVINCE CHARACTER VARYING(150) 150
152 TCA_SYNC_COUNTY CHARACTER VARYING(150) 150
153 TCA_SYNC_CITY CHARACTER VARYING(60) 60
154 TCA_SYNC_ZIP CHARACTER VARYING(60) 60
155 TCA_SYNC_COUNTRY CHARACTER VARYING(60) 60
156 PAY_AWT_GROUP_ID BIGINT 8
157 CAGE_CODE CHARACTER VARYING(5) 5
158 LEGAL_BUSINESS_NAME CHARACTER VARYING(240) 240
159 DOING_BUS_AS_NAME CHARACTER VARYING(240) 240
160 DIVISION_NAME CHARACTER VARYING(60) 60
161 SMALL_BUSINESS_CODE CHARACTER VARYING(10) 10
162 CCR_COMMENTS CHARACTER VARYING(240) 240
163 DEBARMENT_START_DATE TIMESTAMP 8
164 DEBARMENT_END_DATE TIMESTAMP 8
165 CDC_SOURCE_SYSTEM_CODE CHARACTER(4) 4
166 CDC_RECORD_TYPE CHARACTER(16) 16
167 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
168 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8