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