BDNA Data Platform 5.4 July 2017 (SQL Server)
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 numeric 20 MATCH_PO_PROD table unique identifier
CATEGORY nvarchar 510  √  null Category of this particular PO record (Mapped/Ignored/Other etc
REASONS nvarchar 512  √  null Reasons for the Categorization if there are any exceptions
PO_GUID nvarchar 64  √  null GUID of the complete row
PO_HASH nvarchar 64  √  null GUID for the combined mapping columns
PO_MFG_PART_NO nvarchar 2048  √  null Manufactuer part number
PO_MANUFACTURER nvarchar 2048  √  null Manufacturer
PO_PRODUCT_DESC nvarchar 2048  √  null Product description
PO_UNIT_OF_MEASURE nvarchar 8000  √  null Unit of Measurement
PO_OTHER_INFO nvarchar 2048  √  null Other information
PO_RESELLER nvarchar 2048  √  null Reseller information
PO_SKU_NO nvarchar 2048  √  null SKU Number
PO_QUANTITY nvarchar 2048  √  null PO Quantity
PO_UNIT_PRICE nvarchar 2048  √  null PO unit price
PO_TOTAL_PRICE nvarchar 2048  √  null PO total price
PO_START_DATE datetime 16,3  √  null PO start date
CAT_SW_FULLNAME varchar 500  √  null Software name
CAT_HW_FULLNAME varchar 500  √  null Hardware name
CAT_MANUFACTURER_ID numeric 20  √  null Catalog Manufacturer ID
CAT_SW_PRODUCT_ID numeric 20  √  null Catalog Product ID
CAT_SW_EDITION_ID numeric 20  √  null Catalog Edition ID
CAT_SW_VERSION_GROUP_ID numeric 20  √  null Catalog version group ID
CAT_SW_VERSION_ID numeric 20  √  null Catalog version ID
CAT_SW_RELEASE_ID numeric 20  √  null Catalog release ID
CAT_SW_LIC_RELEASE_ID numeric 20  √  null Catalog Lic release ID
CAT_PLATFORMS_ID numeric 20  √  null Catalog Platforms ID
CAT_HW_LIC_MODEL_ID numeric 20  √  null Catalog Lic model ID
CAT_HW_PRODUCT_ID numeric 20  √  null Catalog HW product ID
CAT_HW_MODEL_ID numeric 20  √  null Catalog HW model ID
CAT_HW_MODEL_PROFILE_ID numeric 20  √  null Catalog HW model profile ID
CAT_TAXONOMY2012_ID numeric 20  √  null Catalog Taxonomy ID
CAT_TAXONOMY_TYPE varchar 100  √  null Taxonomy type (sotware/hardware)
CAT_TAXONOMY_CATEGORY1 varchar 100  √  null Catalog Catagory1
CAT_TAXONOMY_CATEGORY2 varchar 100  √  null Catalog Catagory2 (sub category)
CAT_MANUFACTURER varchar 255  √  null Catalog Manufacturer
CAT_HW_PRODUCT varchar 255  √  null Catalog HW product
CAT_HW_MODEL varchar 255  √  null Catalog HW model
CAT_HW_MODEL_PROFILE varchar 255  √  null Catalog HW profile
CAT_SW_PRODUCT varchar 255  √  null Catalog SW product
CAT_SW_FAMILY varchar 255  √  null Catalog SW product family
CAT_SW_COMPONENT varchar 64  √  null Catalog SW component
CAT_SW_EDITION varchar 255  √  null Catalog SW edition
CAT_SW_VERSION_GROUP varchar 64  √  null Catalog Major version
CAT_SW_VERSION varchar 64  √  null Catalog version
CAT_SW_SUBVERSION varchar 64  √  null Catalog subversion
CAT_PATCHLEVEL varchar 64  √  null Catalog patch level
CAT_SW_PLATFORM varchar 255  √  null Catalog Platform
NFAMILY numeric 20  √  null PO Name Includes Brand/Family
CAT_LIC_METRICS varchar 4000  √  null License Metrics
CAT_LIC_TYPES varchar 4000  √  null License Types
CAT_LIC_PACK_COUNT numeric 20  √  null Catalog License pack count
CAT_LIC_TERM varchar 30  √  null Catalog Lic term (Term, Perpetual, etc.)
CALC_START_DATE datetime 16,3  √  null PO calculated start date
CALC_END_DATE datetime 16,3  √  null PO calculated end date
CALC_MAINT_START_DATE datetime 16,3  √  null PO calculated Min. start date
CALC_MAINT_END_DATE datetime 16,3  √  null PO calculated Min. end date
CALC_UNIT_PRICE numeric 20,2  √  null PO calculated unit price
CALC_TOTAL_PRICE numeric 20,2  √  null PO calculated total price
CALC_TOTAL_QUANTITY numeric 20  √  null PO calculated total quantity
REQ_SPECIFIC_VERSION numeric 20  √  null Flag indicating version of software product as specified in the license is required
CAT_SW_LIC_UUID varchar 255  √  null Unique UUID for SW License
CAT_HW_LIC_UUID varchar 255  √  null Unique UUID for HW License
CAT_SW_LIC_PRODUCT_ID numeric 20  √  null Catalog SW Lic Product Id
CAT_HW_LIC_PRODUCT_ID numeric 20  √  null Catalog HW Lic Product Id
TASK_ID numeric 20 Task ID
INVENTORY_ID numeric 20 Inventory ID
DATASRC nvarchar 50  √  null Input Data Source
PROCESS_ID numeric 20  √  null Process ID

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA