BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_PO_ENT - Purchase Order Entitlement table per process 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_ENT_ID number 0  √  null MATCH_PO_ENT table unique identifier
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_TAXONOMY_TYPE nvarchar2 100  √  null Taxonomy type (sotware/hardware)
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_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_PLATFORMS_ID number 18  √  null Catalog Platforms ID
CAT_TAXONOMY2012_ID number 18  √  null Catalog Taxonomy ID
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
CAT_LIC_METRIC varchar2 500  √  null Catalog Lic Metric
CAT_LIC_GROUP_TYPE varchar2 200  √  null Catalog Lic Group
CAT_LIC_TYPE varchar2 4000  √  null Catalog Lic Type (Maintenance, Purchase, License etc.)
CAT_LIC_PACK_COUNT number 0  √  null Catalog License pack count
CAT_LIC_TERM varchar2 30  √  null Catalog Lic term (Term, Perpetual, etc.)
CALC_START_DATE date 7  √  null PO calculated start date
CALC_END_DATE date 7  √  null PO calculated end date
CALC_UNIT_PRICE number 18,2  √  null PO calculated unit price
CALC_TOTAL_PRICE number 18,2  √  null PO calculated total price
CALC_TOTAL_QUANTITY number 0  √  null PO calculated total quantity
NFAMILY number 0  √  null PO Name Includes Brand/Family
REQ_SPECIFIC_VERSION number 0  √  null Flag indicating version of software product as specified in the license is required
CAT_SW_LIC_UUID varchar2 255  √  null Unique UUID for SW License
CAT_HW_LIC_UUID varchar2 255  √  null Unique UUID for HW License
CAT_SW_LIC_PRODUCT_ID number 18  √  null Catalog SW Lic Product Id
CAT_HW_LIC_PRODUCT_ID number 18  √  null Catalog HW Lic Product Id
PROCESS_ID number 18  √  null Process ID

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
PO_ENT_ID + PROCESS_ID Primary key Asc/Asc PK_MATCH_PO_ENT These unique columns are also nullable
PROCESS_ID + CAT_HW_PRODUCT_ID + CAT_HW_MODEL_ID + CAT_HW_MODEL_PROFILE_ID + CAT_HW_LIC_MODEL_ID + CAT_HW_LIC_PRODUCT_ID + CAT_HW_LIC_UUID Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc MATCH_PO_ENT_HW_IDX  
PROCESS_ID + CAT_SW_PRODUCT_ID + CAT_SW_EDITION_ID + CAT_SW_VERSION_GROUP_ID + CAT_SW_VERSION_ID + CAT_SW_RELEASE_ID + CAT_SW_LIC_RELEASE_ID + CAT_SW_LIC_PRODUCT_ID + CAT_SW_LIC_UUID Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc MATCH_PO_ENT_SW_IDX  
Confidential and Proprietary to BDNA