BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_PO_PROD_ADDL_INFO - Purchase Order Additional attributes 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_GUID nvarchar2 32  √  null
PO_HASH nvarchar2 32  √  null
DATASRC nvarchar2 25  √  null
TASK_ID number 0  √  null
INVENTORY_ID number 18  √  null
PROCESS_ID number 18  √  null
CUSTOMER_ORDER_1 nvarchar2 2000  √  null
CONTACT_NAME nvarchar2 2000  √  null
ORIGINAL_DATE_O3 nvarchar2 2000  √  null
ORDER_NUMBER nvarchar2 2000  √  null
INVOICE_NUMBER nvarchar2 2000  √  null
ITEM_CLASS nvarchar2 2000  √  null
PRODUCT_CLASS_D8 nvarchar2 2000  √  null
ITEM_TYPE nvarchar2 2000  √  null
PRODUCT_TYPE_DE10 nvarchar2 2000  √  null
ITEM_NUMBER nvarchar2 2000  √  null
MFG_CODE nvarchar2 2000  √  null
USERS_ nvarchar2 2000  √  null
DELIVERY_TYPE nvarchar2 2000  √  null
REFERENCE_LINE_18 nvarchar2 2000  √  null
SERIAL_NUMBER nvarchar2 2000  √  null
SHIP_TO_NAME nvarchar2 2000  √  null
SHIP_TO_ADDRESS nvarchar2 2000  √  null
SHIP_TO_ATTENTION nvarchar2 2000  √  null
SHIP_TO_CITY nvarchar2 2000  √  null
SHIP_TO_STATE_CODE nvarchar2 2000  √  null
SHIP_TO_ZIP_CODE nvarchar2 2000  √  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_ADDL_INFO These unique columns are also nullable
Confidential and Proprietary to BDNA