BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_PO_PROD - Purchase Order table per task matched

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
PO_PROD_ID number 0  √  null PO_PROD_ID table unique identifier
CATEGORY nvarchar2 255  √  null Other, Mapped, Unknown
REASONS nvarchar2 256  √  null Reason for category, if any
PO_GUID nvarchar2 32  √  null GUID of the complete row
PO_HASH nvarchar2 32  √  null GUID for the combined mapping columns
PO_MFG_PART_NO nvarchar2 1024  √  null Manufactuer part number
PO_MANUFACTURER nvarchar2 1024  √  null Manufacturer
PO_PRODUCT_DESC nvarchar2 1024  √  null Product description
PO_UNIT_OF_MEASURE nvarchar2 2000  √  null Unit of Measurement
PO_OTHER_INFO nvarchar2 1024  √  null Other information
PO_RESELLER nvarchar2 1024  √  null Reseller information
PO_SKU_NO nvarchar2 1024  √  null SKU Number
PO_QUANTITY nvarchar2 1024  √  null PO Quantity
PO_UNIT_PRICE nvarchar2 1024  √  null PO unit price
PO_TOTAL_PRICE nvarchar2 1024  √  null PO total price
PO_START_DATE date 7  √  null PO start date
CAT_SW_FULLNAME varchar2 500  √  null Software name
CAT_HW_FULLNAME varchar2 500  √  null Hardware name
CAT_MANUFACTURER_ID number 18  √  null Catalog Manufacturer ID
CAT_SW_PRODUCT_ID number 18  √  null Catalog Product ID
CAT_SW_EDITION_ID number 18  √  null Catalog Edition ID
CAT_SW_VERSION_GROUP_ID number 18  √  null Catalog version group ID
CAT_SW_VERSION_ID number 18  √  null Catalog version ID
CAT_SW_RELEASE_ID number 18  √  null Catalog release ID
CAT_SW_LIC_RELEASE_ID number 18  √  null Catalog Lic release ID
CAT_PLATFORMS_ID number 18  √  null Catalog Platforms ID
CAT_HW_LIC_MODEL_ID number 18  √  null Catalog Lic model ID
CAT_HW_PRODUCT_ID number 18  √  null Catalog HW product ID
CAT_HW_MODEL_ID number 18  √  null Catalog HW model ID
CAT_HW_MODEL_PROFILE_ID number 18  √  null Catalog HW model profile ID
CAT_TAXONOMY2012_ID number 18  √  null Catalog Taxonomy ID
CAT_TAXONOMY_TYPE varchar2 100  √  null Taxonomy type (sotware/hardware)
CAT_TAXONOMY_CATEGORY1 varchar2 100  √  null Catalog Catagory1
CAT_TAXONOMY_CATEGORY2 varchar2 100  √  null Catalog Catagory2 (sub category)
CAT_MANUFACTURER varchar2 255  √  null Catalog Manufacturer ID
CAT_HW_PRODUCT varchar2 255  √  null Catalog HW product
CAT_HW_MODEL varchar2 255  √  null Catalog HW model
CAT_HW_MODEL_PROFILE varchar2 255  √  null Catalog HW profile
CAT_SW_PRODUCT varchar2 255  √  null Catalog SW product
CAT_SW_FAMILY varchar2 255  √  null Catalog SW product family
CAT_SW_COMPONENT varchar2 64  √  null Catalog SW component
CAT_SW_EDITION varchar2 255  √  null Catalog SW edition
CAT_SW_VERSION_GROUP varchar2 64  √  null Catalog Major version
CAT_SW_VERSION varchar2 64  √  null Catalog version
CAT_SW_SUBVERSION varchar2 64  √  null Catalog subversion
CAT_PATCHLEVEL varchar2 64  √  null Catalog patch level
CAT_SW_PLATFORM varchar2 255  √  null Catalog Platform
NFAMILY number 0  √  null PO Name Includes Brand/Family
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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + PO_PROD_ID Primary key Asc/Asc/Asc PK_MATCH_PO_PROD These unique columns are also nullable
Confidential and Proprietary to BDNA