Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
PO_PROD_ID |
numeric |
20 |
|
|
|
|
|
CATEGORY |
nvarchar |
510 |
√ |
|
null |
|
|
REASONS |
nvarchar |
512 |
√ |
|
null |
|
|
PO_GUID |
nvarchar |
64 |
√ |
|
null |
|
|
PO_HASH |
nvarchar |
64 |
√ |
|
null |
|
|
PO_MFG_PART_NO |
nvarchar |
2048 |
√ |
|
null |
|
|
PO_MANUFACTURER |
nvarchar |
2048 |
√ |
|
null |
|
|
PO_PRODUCT_DESC |
nvarchar |
2048 |
√ |
|
null |
|
|
PO_UNIT_OF_MEASURE |
nvarchar |
8000 |
√ |
|
null |
|
|
PO_OTHER_INFO |
nvarchar |
2048 |
√ |
|
null |
|
|
PO_RESELLER |
nvarchar |
2048 |
√ |
|
null |
|
|
PO_SKU_NO |
nvarchar |
2048 |
√ |
|
null |
|
|
PO_QUANTITY |
nvarchar |
2048 |
√ |
|
null |
|
|
PO_UNIT_PRICE |
nvarchar |
2048 |
√ |
|
null |
|
|
PO_TOTAL_PRICE |
nvarchar |
2048 |
√ |
|
null |
|
|
PO_START_DATE |
datetime |
16,3 |
√ |
|
null |
|
|
CAT_SW_FULLNAME |
varchar |
500 |
√ |
|
null |
|
|
CAT_HW_FULLNAME |
varchar |
500 |
√ |
|
null |
|
|
CAT_MANUFACTURER_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_SW_PRODUCT_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_SW_EDITION_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_SW_VERSION_GROUP_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_SW_VERSION_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_SW_RELEASE_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_SW_LIC_RELEASE_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_PLATFORMS_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_HW_LIC_MODEL_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_HW_PRODUCT_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_HW_MODEL_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_HW_MODEL_PROFILE_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_TAXONOMY2012_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_TAXONOMY_TYPE |
varchar |
100 |
√ |
|
null |
|
|
CAT_TAXONOMY_CATEGORY1 |
varchar |
100 |
√ |
|
null |
|
|
CAT_TAXONOMY_CATEGORY2 |
varchar |
100 |
√ |
|
null |
|
|
CAT_MANUFACTURER |
varchar |
255 |
√ |
|
null |
|
|
CAT_HW_PRODUCT |
varchar |
255 |
√ |
|
null |
|
|
CAT_HW_MODEL |
varchar |
255 |
√ |
|
null |
|
|
CAT_HW_MODEL_PROFILE |
varchar |
255 |
√ |
|
null |
|
|
CAT_SW_PRODUCT |
varchar |
255 |
√ |
|
null |
|
|
CAT_SW_FAMILY |
varchar |
255 |
√ |
|
null |
|
|
CAT_SW_COMPONENT |
varchar |
64 |
√ |
|
null |
|
|
CAT_SW_EDITION |
varchar |
255 |
√ |
|
null |
|
|
CAT_SW_VERSION_GROUP |
varchar |
64 |
√ |
|
null |
|
|
CAT_SW_VERSION |
varchar |
64 |
√ |
|
null |
|
|
CAT_SW_SUBVERSION |
varchar |
64 |
√ |
|
null |
|
|
CAT_PATCHLEVEL |
varchar |
64 |
√ |
|
null |
|
|
CAT_SW_PLATFORM |
varchar |
255 |
√ |
|
null |
|
|
NFAMILY |
numeric |
20 |
√ |
|
null |
|
|
CAT_LIC_METRICS |
varchar |
4000 |
√ |
|
null |
|
|
CAT_LIC_TYPES |
varchar |
4000 |
√ |
|
null |
|
|
CAT_LIC_PACK_COUNT |
numeric |
20 |
√ |
|
null |
|
|
CAT_LIC_TERM |
varchar |
30 |
√ |
|
null |
|
|
CALC_START_DATE |
datetime |
16,3 |
√ |
|
null |
|
|
CALC_END_DATE |
datetime |
16,3 |
√ |
|
null |
|
|
CALC_MAINT_START_DATE |
datetime |
16,3 |
√ |
|
null |
|
|
CALC_MAINT_END_DATE |
datetime |
16,3 |
√ |
|
null |
|
|
CALC_UNIT_PRICE |
numeric |
20,2 |
√ |
|
null |
|
|
CALC_TOTAL_PRICE |
numeric |
20,2 |
√ |
|
null |
|
|
CALC_TOTAL_QUANTITY |
numeric |
20 |
√ |
|
null |
|
|
REQ_SPECIFIC_VERSION |
numeric |
20 |
√ |
|
null |
|
|
CAT_SW_LIC_UUID |
varchar |
255 |
√ |
|
null |
|
|
CAT_HW_LIC_UUID |
varchar |
255 |
√ |
|
null |
|
|
CAT_SW_LIC_PRODUCT_ID |
numeric |
20 |
√ |
|
null |
|
|
CAT_HW_LIC_PRODUCT_ID |
numeric |
20 |
√ |
|
null |
|
|
TASK_ID |
numeric |
20 |
|
|
|
|
|
INVENTORY_ID |
numeric |
20 |
|
|
|
|
|
DATASRC |
nvarchar |
50 |
√ |
|
null |
|
|
PROCESS_ID |
numeric |
20 |
√ |
|
null |
|
|
Analyzed at Thu Jul 20 12:14 PDT 2017
|