Table Schema: mf_shipping_order_site_assignments

This topic describes the columns in the mf_shipping_order_site_assignments table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
shipping_order_site_assignment_guid uniqueidentifier 1 0 1   1  
shipping_order_guid uniqueidentifier 0 1 2   0 mf_shipping_orders.shipping_order_guid
site_guid uniqueidentifier 0 1 3   0 mf_sites.site_guid
shipping_order_site_assignment_reject_reason_guid uniqueidentifier 0 1 4   0 mf_shipping_order_site_assignment_reject_reasons.shipping_order_site_assignment_reject_reason_guid
assignment_notified tinyint 0 0 5   0  
assignment_notified_date datetime 0 1 6   0  
assignment_accept_expiration datetime 0 1 7   0  
assignment_accepted tinyint 0 0 8   0  
assignment_accepted_date datetime 0 1 9   0  
assignment_accepted_user_guid uniqueidentifier 0 1 10   0  
assignment_rejected tinyint 0 0 11   0  
assignment_rejected_date datetime 0 1 12   0  
assignment_rejected_user_guid uniqueidentifier 0 1 13   0  
assignment_expiration datetime 0 1 14   0  
assignment_expired tinyint 0 0 15   0  
assignment_closed tinyint 0 0 16   0  
lu_dt datetime 0 1 17   0  
cr_dt datetime 0 1 18   0  
lu_guid uniqueidentifier 0 1 19   0  
cr_guid uniqueidentifier 0 1 20   0  

Return to index of tables