Table Schema: mf_item_backorder_authorizations

This topic describes the columns in the mf_item_backorder_authorizations table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
item_backorder_authorization_guid uniqueidentifier 1 0 1   0  
item_guid uniqueidentifier 0 0 2   0 mf_items.item_guid
catalog_guid uniqueidentifier 0 1 3   0  
item_backorder_authorization_type_id smallint 0 1 4   0 mf_item_backorder_authorization_types.item_backorder_authorization_type_id
item_backorder_authorization_cd varchar (50) 0 1 5   0  
item_backorder_authorization_label varchar (50) 0 1 6   0  
item_backorder_authorization_label_short varchar (50) 0 1 7   0  
item_backorder_authorization_description varchar (255) 0 1 8   0  
item_backorder_authorization_quantity int 0 0 9   0  
item_backorder_authorization_quantity_fulfilled int 0 0 10   0  
item_backorder_authorization_start_date datetime 0 1 11   0  
item_backorder_authorization_end_date datetime 0 1 12   0  
item_backorder_authorization_promise_date datetime 0 1 13   0  
item_backorder_authorization_promise_fulfill_date datetime 0 1 14   0  
item_backorder_authorization_fulfill_date datetime 0 1 15   0  
item_backorder_authorization_visible tinyint 0 0 16   0  
item_backorder_authorization_closed tinyint 0 0 17   0  
lu_dt datetime 0 0 18   0  
cr_dt datetime 0 0 19   0  
lu_guid uniqueidentifier 0 1 20   0  
cr_guid uniqueidentifier 0 1 21   0  

Return to index of tables