OEB_PO_APPROVED_SUPPLIER_LIST

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ASL_ID BIGINT 8
2 USING_ORGANIZATION_ID BIGINT 8
3 OWNING_ORGANIZATION_ID BIGINT 8
4 VENDOR_BUSINESS_TYPE CHARACTER VARYING(25) 25
5 ASL_STATUS_ID BIGINT 8
6 LAST_UPDATE_DATE TIMESTAMP 8
7 LAST_UPDATED_BY BIGINT 8
8 CREATION_DATE TIMESTAMP 8
9 CREATED_BY BIGINT 8
10 MANUFACTURER_ID BIGINT 8
11 VENDOR_ID BIGINT 8
12 ITEM_ID BIGINT 8
13 CATEGORY_ID BIGINT 8
14 VENDOR_SITE_ID BIGINT 8
15 PRIMARY_VENDOR_ITEM CHARACTER VARYING(25) 25
16 MANUFACTURER_ASL_ID BIGINT 8
17 REVIEW_BY_DATE TIMESTAMP 8
18 COMMENTS CHARACTER VARYING(240) 240
19 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
20 ATTRIBUTE1 CHARACTER VARYING(150) 150
21 ATTRIBUTE2 CHARACTER VARYING(150) 150
22 ATTRIBUTE3 CHARACTER VARYING(150) 150
23 ATTRIBUTE4 CHARACTER VARYING(150) 150
24 ATTRIBUTE5 CHARACTER VARYING(150) 150
25 ATTRIBUTE6 CHARACTER VARYING(150) 150
26 ATTRIBUTE7 CHARACTER VARYING(150) 150
27 ATTRIBUTE8 CHARACTER VARYING(150) 150
28 ATTRIBUTE9 CHARACTER VARYING(150) 150
29 ATTRIBUTE10 CHARACTER VARYING(150) 150
30 ATTRIBUTE11 CHARACTER VARYING(150) 150
31 ATTRIBUTE12 CHARACTER VARYING(150) 150
32 ATTRIBUTE13 CHARACTER VARYING(150) 150
33 ATTRIBUTE14 CHARACTER VARYING(150) 150
34 ATTRIBUTE15 CHARACTER VARYING(150) 150
35 LAST_UPDATE_LOGIN BIGINT 8
36 REQUEST_ID BIGINT 8
37 PROGRAM_APPLICATION_ID BIGINT 8
38 PROGRAM_ID BIGINT 8
39 PROGRAM_UPDATE_DATE TIMESTAMP 8
40 DISABLE_FLAG CHARACTER VARYING(1) 1
41 IP_CATEGORY_ID BIGINT 8
42 LAST_UPDATED_PROGRAM CHARACTER VARYING(255) 255
43 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
44 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
45 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
46 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8