Goods received line
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 |