PRT_CTP_PRODUCT_HIERARCHY

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO INTEGER 4
2 PRODUCT_TYPE_CODE CHARACTER VARYING(10) 10
3 PRODUCT_CLASS_CODE CHARACTER VARYING(10) 10
4 PRODUCT_SUBCLASS_CODE CHARACTER VARYING(10) 10
5 PRODUCT_TYPE_DESC CHARACTER VARYING(510) 510
6 PRODUCT_CLASS_DESC CHARACTER VARYING(510) 510
7 PRODUCT_SUBCLASS_DESC CHARACTER VARYING(510) 510
8 PRODUCT_SUBCLASS_GROUP CHARACTER VARYING(10) 10
9 PRODUCT_TYPE_GROUP CHARACTER VARYING(1) 1
10 PRODUCT_STRUCT1 CHARACTER VARYING(50) 50
11 PRODUCT_STRUCT2 CHARACTER VARYING(50) 50
12 PRODUCT_STRUCT3 CHARACTER VARYING(50) 50
13 PRODUCT_STRUCT4 CHARACTER VARYING(50) 50
14 PRODUCT_STRUCT5 CHARACTER VARYING(50) 50
15 PRODUCT_STRUCT6 CHARACTER VARYING(50) 50
16 PRODUCT_STRUCT7 CHARACTER VARYING(50) 50
17 PRODUCT_STRUCT8 CHARACTER VARYING(50) 50
18 SOURCE_KEY1 CHARACTER VARYING(10) 10
19 SOURCE_KEY2 CHARACTER VARYING(10) 10
20 SOURCE_KEY3 CHARACTER VARYING(10) 10
21 SOURCE_KEY4 CHARACTER VARYING(10) 10
22 PACKAGE_STRUCT1 CHARACTER VARYING(50) 50
23 PACKAGE_STRUCT2 CHARACTER VARYING(50) 50
24 BUSUNIT CHARACTER VARYING(20) 20
25 MAJOR_CLASS_DSCR CHARACTER VARYING(60) 60