Goods received

Back to list of main tables

Table name is Goods received. Goods received are created only after purchase order from supplier.

Field name	Description	mSupply use	Report reference link	Type	Indexed
ID	Unique system generated UUID for the Goods Received (record not normally visible to end users)	Not use in UI	Alpha
purchase_order_ID	Reference ID of the purchase order linked to this Goods Received record	Not use in UI	Alpha
entry_date	The date the Goods Received record was entered into the system.	goods received window»Entry date	https://docs.msupply.org.nz/receiving_goods:goods_receipts#goods_receipts	Date
received_date	The actual date the goods were physically received	goods received window»Received date	Date
supplier_reference	Reference number or code provided by the supplier (e.g., delivery note or invoice reference)	goods received window»supplier reference	Alpha
user_id_created	ID of the user who created the Goods Received record	ID are not used in UI. User name can be seen in goods received window>created by	Alpha
user_id_modified	ID of the user who last modified the Goods Received record	ID are not used in UI. User name can be seen in goods received window>modified by	Alpha
status	Current status of the Goods Received record (e.g., nw = new, fn = finalised)	goods received window»status	Alpha
store_ID	Identifier of the store where the goods were received	ID are not used in UI. Store name can be seen in goods received window>Store	Alpha
budget_ID	Identifier of the budget comes from purchase order	ID are not used in UI	https://docs.msupply.org.nz/other_stuff:budgets#budgets	Alpha
donor_id	Identifier of the donor, used when goods are tracked by donor	ID are not used in UI. Donor name can be seen in goods received window>Donor	Alpha
serial_number	System-generated serial number for the Goods Received transaction	goods received window>Goods received:	Long Integer
comment	Additional notes or remarks entered by the user	goods received window>Comment	Text
linked_transact_ID	Transaction ID linked to this good received	not used in UI	Alpha