Tenders
| Field name | Description | mSupply Use | Reference link | Type | Indexed |
|---|---|---|---|---|---|
| BenchMarkSupplier_ID | The ID of the supplier used as a benchmark for price comparison | ID are not shown in UI but used to display open/create any one tender»goto Tender preferences tab»Bench mark supplier | https://docs.msupply.org.nz/tender_management:introduction#tender_preferences_tab | Alpha | |
| closing_time | The time that the tender closes (UTC) | open/create any one tender»Response by Date/Time | Time | ||
| comment | User entered comment | open/create any one tender»Comment | https://docs.msupply.org.nz/tender_management:introduction#new_tender_manually_entered | Text | |
| conditions | Specific conditions imposed on suppliers | open/create any one tender»goto Notes tab | https://docs.msupply.org.nz/tender_management:introduction#notes_tab | Text | |
| created_by_user_ID | User who created the tender | Alpha | * | ||
| creation_date | Date the tender was created | Open/create any one tender»Created date | https://docs.msupply.org.nz/tender_management:introduction#new_tender_manually_entered | Date | |
| Create_split_deliveries | Allows multiple deliveries per supplier | Open/create any one tender»goto Tender preferences tab»Create split deliveries | https://docs.msupply.org.nz/tender_management:introduction#tender_preferences_tab | Boolean | |
| desc | Short tender description | pen/create any one tender»Description | https://docs.msupply.org.nz/tender_management:introduction#new_tender_manually_entered | Alpha | |
| due_date | Closing date of the tender | https://docs.msupply.org.nz/tender_management:introduction#new_tender_manually_entered | Date | ||
| EmailSubject | Email subject used when sending tender | open/create any one tender»goto Choose Supplier and Enter responses tab»Subject For Email: | https://docs.msupply.org.nz/tender_management:introduction#choose_suppliers_and_enter_responses_tab | Text | |
| ID | Unique ID of the tender | Alpha | * | ||
| issue_date | Date tender was issued | open/create any one tender»Issue date | https://docs.msupply.org.nz/tender_management:introduction#new_tender_manually_entered | Date | |
| locked | Prevents tender deletion | open/create any one tender»Locked | Boolean | ||
| our_ref | Internal reference | open/create any one tender»Our reference | Alpha | ||
| po_calc_method | Method used to calculate purchase orders | Used to display Open/create any one tender»goto Tender preferences tab»PO calculation method | Long | ||
| Print_Item_desc | Print item descriptions on tender | Open/create any one tender»goto Tender preferences tab»Print item description instead of item name | https://docs.msupply.org.nz/tender_management:introduction#tender_preferences_tab | Boolean | |
| Print_Tender_conditions | Print tender conditions with item list | Open/create any one tender»goto Tender preferences tab»Print tender conditions | https://docs.msupply.org.nz/tender_management:introduction#tender_preferences_tab | Boolean | |
| RequestDeliveryDate | Requested delivery date | Open/create any one tender»goto Tender preferences tab»Requested | https://docs.msupply.org.nz/tender_management:introduction#tender_preferences_tab | Date | |
| status | Tender status code | open/create any one tender»Status | https://docs.msupply.org.nz/tender_management:introduction#new_tender_manually_entered | Alpha | |
| store_ID | Store issuing the tender | Alpha | |||
| TargetDays | Target lead time in days | Open/create any one tender»goto Tender preferences tab»Targer days | https://docs.msupply.org.nz/tender_management:introduction#tender_preferences_tab | Long Integer | |
| tender_inter_month | Tender interval in months | Used to display Open/create any one tender»goto Tender preferences tab»Based on tender_inter_month months usage | https://docs.msupply.org.nz/tender_management:introduction#tender_preferences_tab | Long Integer | |
| TenderSyncStatus | Tender sync status | Alpha | |||
| serial_number | System-generated tender number | Open/create any one tender»Serial number | Long Integer | ||
| incoterm_ID | Incoterm used for the tender | ID are not shown in UI but used to display open/create any one tender»goto Items and Compare Prices tab»Incoterm | https://docs.msupply.org.nz/tender_management:introduction#items_and_compare_prices_tab | Alpha | |
| category_ID | Tender category | ID are not shown in UI but used to display open/create any one tender»goto Items and Compare Prices tab»Category | https://docs.msupply.org.nz/tender_management:introduction#items_and_compare_prices_tab | Alpha |
Tender lines
| Field name | Description | mSupply Use | Reference link | Type | Indexed |
|---|---|---|---|---|---|
| COLOUR | UI colour indicator for the tender line | Open/create tender»New line»tender line window will open»You see the colour picker | Long Integer | ||
| comment | User-entered comment for this tender line | Open/create tender»New line»tender line window will open»Set tender item criteria tab»Comment | Text | ||
| conditions | Conditions specific to this tender line | Open/create tender»New line»tender line window will open»Set tender item criteria tab»Conditions | Text | ||
| generated_qty | Quantity suggested when the tender was auto-generated | Open/create tender»New line»tender line window will open»Original Generated quantity | Real | ||
| ID | Unique identifier for the tender line | Alpha | * | ||
| indicative_price | Expected unit price entered by the user | Open/create tender»New line»tender line window will open»Set tender item criteria tab»Estimated price | Real | ||
| item_ID | Identifier of the item being tendered | Alpha | * | ||
| item_name | Item name copied at time of tender creation | Open/create tender»New line»tender line window will open»Item name | https://docs.msupply.org.nz/tender_management:introduction#adding_items_to_a_tender | Alpha | |
| is_synced | Indicates whether the line has been synced | Boolean | |||
| line_number | Saved row number of the tender line | Long Integer | |||
| noOfPacks | Number of packs expected to be purchased | Open/create tender»New line»tender line window will open»Set tender item criteria tab»Number of packs | https://docs.msupply.org.nz/tender_management:introduction#adding_items_to_a_tender | Real | |
| pack_size | Pack size requested for the tender | Open/create tender»New line»tender line window will open»Set tender item criteria tab»Multiplied by pack size | Real | ||
| totalQuantity | Total quantity (noOfPacks × pack_size) | Open/create tender»New line»tender line window will open»Set tender item criteria tab»=total quantity | Real | ||
| SELECTION_NOTES | Notes explaining how the winning supplier will be selected | Open/create tender»New line»tender line window will open»Compare supplier responses tab»Note | Text | ||
| unit_ID | Unit of measure used for this tender line | Alpha | * | ||
| tender_ID | Identifier of the parent tender | Alpha | * |