OEB_ICX_CAT_ITEMS_B

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RT_ITEM_ID BIGINT 8
2 OBJECT_VERSION_NUMBER BIGINT 8
3 ORG_ID BIGINT 8
4 SUPPLIER_ID BIGINT 8
5 SUPPLIER CHARACTER VARYING(700) 700
6 SUPPLIER_PART_NUM CHARACTER VARYING(700) 700
7 SUPPLIER_PART_AUXID CHARACTER VARYING(255) 255
8 INTERNAL_ITEM_ID BIGINT 8
9 INTERNAL_ITEM_NUM CHARACTER VARYING(700) 700
10 EXTRACTOR_UPDATED_FLAG CHARACTER VARYING(1) 1
11 REQUEST_ID BIGINT 8
12 CATALOG_NAME CHARACTER VARYING(255) 255
13 LAST_UPDATE_LOGIN BIGINT 8
14 LAST_UPDATED_BY BIGINT 8
15 LAST_UPDATE_DATE TIMESTAMP 8
16 CREATED_BY BIGINT 8
17 CREATION_DATE TIMESTAMP 8
18 PROGRAM_APPLICATION_ID BIGINT 8
19 PROGRAM_ID BIGINT 8
20 PROGRAM_UPDATE_DATE TIMESTAMP 8
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8