Goods received line

Back to list of main tables

Table name is goods_received_line. Contains the lines that belong to goods received.

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
goods_received_ID	Stores the lines that are received from supplier	Not use in UI	https://docs.msupply.org.nz/receiving_goods:goods_receipts#goods_receipt_line_entry	Alpha
order_line_ID	UUID of the purchase order line associated with the Goods_received (if any)	mSupply»Goods received	Alpha
pack_received	Number of pack size received	Goods received»edit Item»Pack size	Real
quantity_received	Stores the number of quantity received	Goods received»edit Item»Quantity	Real
batch_received	batch received from supplier	Goods received»edit Item»Batch	Text
weight_per_pack	the weight per pack for the line currently selected in the table	Goods received»edit Item»Weight Per Pack	Real
expiry_date	Expiry date of the item line	Goods received»edit Item»Expiry	Date
line_number	The sequence number of the item line in the Goods Received record	Goods received»Line	Real
item_ID	Store the item ID	Not use in UI	Alpha
item_name	Name of the item we're entering the information about	Goods received»Item name	Alpha
location_ID	The storage location where the received stock will be placed (warehouse, shelf, room, etc.)	Good received»edit Item»Location	Alpha
volume_per_pack	The volume per pack for the line currently selected in the table	Goods received»edit Item»Volume per pack	Real
manufacturer_ID	Manufacturer ID associate with good received line	goodReceived»edit Item»manufacturer(need to on pref)	Alpha
pack_quan_in_inner	Number of packs in inner pack	If pref is on Goods received line window> Inner pack column	Long integer
pack_inners_in_outer	Number of inner packs in outer pack	If pref is on good received line window»Outer pack column	Long integer
spare_note_has_been_actioned	Boolean
is_authorised	Is true which will authorise the selected batch line	If the permission Authorise goods received is on Goods received»good received line `Authorise` column	https://docs.msupply.org.nz/other_stuff:invoice_authorization#goods_receipt_authorisation	Boolean
authorised_comment	Explanation or notes added when a batch fails authorisation	Goods received»Authorise comment	https://docs.msupply.org.nz/receiving_goods:goods_receipts#authorising_items_on_goods_received_notes	Text
comment	The Comment text enter by user	Goods received»edit Item»Comment	Text
kit_data	Object
cost_price	Cost price from Purchase order line	Real
remoteCustomerInvoiceLineID	Customer invoice id posted from Supplier hub integrated	Alpha
custom_stock_field_1	User-defined custom stock field for additional tracking	If pref stock is enable the custom feilds it will shown on both goods received and good received line window	https://docs.msupply.org.nz/preferences:general#stock_tab	Text
custom_stock_field_2	User-defined custom stock field for additional tracking	If pref stock is enable the custom feilds it will shown on both goods received and good received line window	https://docs.msupply.org.nz/preferences:general#stock_tab	Text
custom_stock_field_3	User-defined custom stock field for additional tracking	If pref stock is enable the custom feilds it will shown on both goods received and good received line window	https://docs.msupply.org.nz/preferences:general#stock_tab	Text
custom_stock_field_4	User-defined custom stock field for additional tracking	If pref stock is enable the custom feilds it will shown on both goods received and good received line window	https://docs.msupply.org.nz/preferences:general#stock_tab	Text