OEB_MTL_ITEM_CATEGORIES

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INVENTORY_ITEM_ID BIGINT 8
2 ORGANIZATION_ID BIGINT 8
3 CATEGORY_SET_ID BIGINT 8
4 CATEGORY_ID BIGINT 8
5 LAST_UPDATE_DATE TIMESTAMP 8
6 LAST_UPDATED_BY BIGINT 8
7 CREATION_DATE TIMESTAMP 8
8 CREATED_BY BIGINT 8
9 LAST_UPDATE_LOGIN BIGINT 8
10 REQUEST_ID BIGINT 8
11 PROGRAM_APPLICATION_ID BIGINT 8
12 PROGRAM_ID BIGINT 8
13 PROGRAM_UPDATE_DATE TIMESTAMP 8
14 WH_UPDATE_DATE TIMESTAMP 8
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8