Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
PO_PROD_ID |
number |
0 |
√ |
|
null |
|
|
CATEGORY |
nvarchar2 |
255 |
√ |
|
null |
|
|
REASONS |
nvarchar2 |
256 |
√ |
|
null |
|
|
PO_GUID |
nvarchar2 |
32 |
√ |
|
null |
|
|
PO_HASH |
nvarchar2 |
32 |
√ |
|
null |
|
|
PO_MFG_PART_NO |
nvarchar2 |
1024 |
√ |
|
null |
|
|
PO_MANUFACTURER |
nvarchar2 |
1024 |
√ |
|
null |
|
|
PO_PRODUCT_DESC |
nvarchar2 |
1024 |
√ |
|
null |
|
|
PO_UNIT_OF_MEASURE |
nvarchar2 |
2000 |
√ |
|
null |
|
|
PO_OTHER_INFO |
nvarchar2 |
1024 |
√ |
|
null |
|
|
PO_RESELLER |
nvarchar2 |
1024 |
√ |
|
null |
|
|
PO_SKU_NO |
nvarchar2 |
1024 |
√ |
|
null |
|
|
PO_QUANTITY |
nvarchar2 |
1024 |
√ |
|
null |
|
|
PO_UNIT_PRICE |
nvarchar2 |
1024 |
√ |
|
null |
|
|
PO_TOTAL_PRICE |
nvarchar2 |
1024 |
√ |
|
null |
|
|
PO_START_DATE |
date |
7 |
√ |
|
null |
|
|
CAT_SW_FULLNAME |
varchar2 |
500 |
√ |
|
null |
|
|
CAT_HW_FULLNAME |
varchar2 |
500 |
√ |
|
null |
|
|
CAT_MANUFACTURER_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_PRODUCT_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_EDITION_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_VERSION_GROUP_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_VERSION_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_RELEASE_ID |
number |
18 |
√ |
|
null |
|
|
CAT_SW_LIC_RELEASE_ID |
number |
18 |
√ |
|
null |
|
|
CAT_PLATFORMS_ID |
number |
18 |
√ |
|
null |
|
|
CAT_HW_LIC_MODEL_ID |
number |
18 |
√ |
|
null |
|
|
CAT_HW_PRODUCT_ID |
number |
18 |
√ |
|
null |
|
|
CAT_HW_MODEL_ID |
number |
18 |
√ |
|
null |
|
|
CAT_HW_MODEL_PROFILE_ID |
number |
18 |
√ |
|
null |
|
|
CAT_TAXONOMY2012_ID |
number |
18 |
√ |
|
null |
|
|
CAT_TAXONOMY_TYPE |
varchar2 |
100 |
√ |
|
null |
|
|
CAT_TAXONOMY_CATEGORY1 |
varchar2 |
100 |
√ |
|
null |
|
|
CAT_TAXONOMY_CATEGORY2 |
varchar2 |
100 |
√ |
|
null |
|
|
CAT_MANUFACTURER |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_HW_PRODUCT |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_HW_MODEL |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_HW_MODEL_PROFILE |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_SW_PRODUCT |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_SW_FAMILY |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_SW_COMPONENT |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_SW_EDITION |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_SW_VERSION_GROUP |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_SW_VERSION |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_SW_SUBVERSION |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_PATCHLEVEL |
varchar2 |
64 |
√ |
|
null |
|
|
CAT_SW_PLATFORM |
varchar2 |
255 |
√ |
|
null |
|
|
NFAMILY |
number |
0 |
√ |
|
null |
|
|
CAT_LIC_METRICS |
varchar2 |
500 |
√ |
|
null |
|
|
CAT_LIC_TYPES |
varchar2 |
4000 |
√ |
|
null |
|
|
CAT_LIC_PACK_COUNT |
number |
0 |
√ |
|
null |
|
|
CAT_LIC_TERM |
varchar2 |
30 |
√ |
|
null |
|
|
CALC_START_DATE |
date |
7 |
√ |
|
null |
|
|
CALC_END_DATE |
date |
7 |
√ |
|
null |
|
|
CALC_MAINT_START_DATE |
date |
7 |
√ |
|
null |
|
|
CALC_MAINT_END_DATE |
date |
7 |
√ |
|
null |
|
|
CALC_UNIT_PRICE |
number |
18,2 |
√ |
|
null |
|
|
CALC_TOTAL_PRICE |
number |
18,2 |
√ |
|
null |
|
|
CALC_TOTAL_QUANTITY |
number |
0 |
√ |
|
null |
|
|
REQ_SPECIFIC_VERSION |
number |
0 |
√ |
|
null |
|
|
CAT_SW_LIC_UUID |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_HW_LIC_UUID |
varchar2 |
255 |
√ |
|
null |
|
|
CAT_SW_LIC_PRODUCT_ID |
number |
18 |
√ |
|
null |
|
|
CAT_HW_LIC_PRODUCT_ID |
number |
18 |
√ |
|
null |
|
|
TASK_ID |
number |
18 |
√ |
|
null |
|
|
INVENTORY_ID |
number |
18 |
√ |
|
null |
|
|
DATASRC |
nvarchar2 |
25 |
√ |
|
null |
|
|
PROCESS_ID |
number |
18 |
√ |
|
null |
|
|
Analyzed at Thu Jul 20 12:13 PDT 2017
|