Table Schema: mf_delivery_items

This topic describes the columns in the mf_delivery_items table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
delivery_item_guid uniqueidentifier 1 0 1   0  
delivery_guid uniqueidentifier 0 0 2   0 mf_deliveries.delivery_guid
item_guid uniqueidentifier 0 0 3   0  
site_location_guid uniqueidentifier 0 1 4   0  
delivery_item_line_id smallint 0 1 5   0  
delivery_item_quantity int 0 0 6   0  
delivery_item_description varchar (255) 0 1 7   0  
delivery_item_received tinyint 0 0 8   0  
delivery_item_void tinyint 0 0 9   0  
delivery_item_closed tinyint 0 0 10   0  
lu_dt datetime 0 0 11   0  
cr_dt datetime 0 0 12   0  
lu_guid uniqueidentifier 0 1 13   0  
cr_guid uniqueidentifier 0 1 14   0  

Return to index of tables

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.