Table Schema: mf_purchase_order_receipts

This topic describes the columns in the mf_purchase_order_receipts table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
purchase_order_receipt_guid uniqueidentifier 1 0 1   0  
purchase_order_guid uniqueidentifier 0 1 2 Primary Key 0 mf_purchase_orders.purchase_order_guid
purchase_order_item_guid uniqueidentifier 0 1 3   0 mf_purchase_order_items.purchase_order_item_guid
purchase_order_receipt_reference_id varchar (50) 0 1 4   0  
receipt_quantity int 0 0 5   0  
receipt_quantity_damaged int 0 1 6   0  
receipt_unit_price money 0 0 7   0  
receipt_note varchar (2000) 0 1 8   0  
lu_dt datetime 0 0 9   0  
cr_dt datetime 0 0 10   0  
lu_guid uniqueidentifier 0 1 11   0  
cr_guid uniqueidentifier 0 1 12   0  

Return to index of tables