BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_PO_ENT_ADDL_INFO - Purchase Order Additional attributes 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 numeric 20 Unique ID for Po Entitilement
PO_GUID nvarchar 64  √  null Unique GUID for Po Entitilement
PO_HASH nvarchar 64  √  null Unique HASH for Po Entitilement
PROCESS_ID numeric 20 Process ID
Customer_Order_1 nvarchar 4096  √  null
Contact_Name nvarchar 4096  √  null
Original_Date_o3 nvarchar 4096  √  null
Order_Number nvarchar 4096  √  null
Invoice_Number nvarchar 4096  √  null
Item_class nvarchar 4096  √  null
Product_Class_D8 nvarchar 4096  √  null
Item_Type nvarchar 4096  √  null
Product_Type_De10 nvarchar 4096  √  null
Item_Number nvarchar 4096  √  null
MFG_Code nvarchar 4096  √  null
Users nvarchar 4096  √  null
Delivery_Type nvarchar 4096  √  null
Reference_Line_18 nvarchar 4096  √  null
Serial_Number nvarchar 4096  √  null
Ship_To_Name nvarchar 4096  √  null
Ship_To_Address nvarchar 4096  √  null
Ship_To_Attention nvarchar 4096  √  null
Ship_To_City nvarchar 4096  √  null
Ship_to_State_Code nvarchar 4096  √  null
Ship_To_Zip_Code nvarchar 4096  √  null

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA