Differences

This shows you the differences between two versions of the page.

--- tables_fields:main_tables:tender [2020/01/07 01:04] – ↷ Page moved from tables:main_tables:tender to tables_fields:main_tables:tender lou
+++ tables_fields:main_tables:tender [2026/01/28 04:21] (current) – Raksha Khadka
@@ Line 1: / Line 1: @@
 ====== Tenders ======
-[[tables:main_tables:|Back to list of main tables]]
+[[..:|Back to list of main tables]]
-^ Field name ^ Description ^ Type^ Ind ^
+^Field name ^ Description ^ mSupply Use ^ Reference link ^ Type ^ Indexed ^
-| BenchMarkSupplier_ID | The ID of the supplier we are using as a benchmark to compare prices with for this tender | UUID |  |
+| 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 (in UTC) | Time |  |
+| closing_time | The time that the tender closes (UTC) |open/create any one tender>>Response by Date/Time | | Time | |
-| comment | User entered comment | Text |  |
+| 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 by you on suppliers participating in this tender | 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 |  | UUID | * |
+| **created_by_user_ID** | User who created the tender | | | Alpha | * |
-| creation_date |  | Date |  |
+| 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 | If true, multiple deliveries for the one supplier will be created. | Boolean  |  |
+| 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 |  | Alpha (80) |  |
+| 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 | The closing date of the tender | Date |  |
+| due_date | Closing date of the tender | |https://docs.msupply.org.nz/tender_management:introduction#new_tender_manually_entered | Date | |
-| EmailSubject |   |Text |  |
+| 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** | The unique ID of the tender | UUID | * |
+| **ID** | Unique ID of the tender | | | Alpha | * |
-| issue_date |  | Date |  |
+| 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 | If true, the tender can not be deleted | Boolean |  |
+| locked | Prevents tender deletion |open/create any one tender>>Locked | | Boolean | |
-| our_ref |  | Alpha  |  |
+| our_ref | Internal reference |open/create any one tender>>Our reference | | Alpha | |
-| po_calc_method |   | Long  |  |
+| 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 |  | Boolean|  |
+| 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 | If true the tender conditions will be printed along with the list of items |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 |  | Date |  |
+| 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 |  | Alpha (3) |  |
+| 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 |  | UUID |  |
+| **store_ID** | Store issuing the tender | | | Alpha | |
-| TargetDays |  | Long Integer |  |
+| 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 |  | 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 |  | Alpha |  |
+| 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 ^ Type ^ Ind ^
+^Field name ^ Description ^ mSupply Use ^ Reference link ^ Type ^ Indexed ^
-| COLOUR |  | Long Integer |  |
+| 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 |  | Text |  |
+| 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 |  | 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 | The quantity that was suggested when (if) the tender was auto-generated. The user will edit the noOfPacks (below), not this field | Real |  |
+| 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 ID of the line | UUID  | * |
+| ID | Unique identifier for the tender line | | | Alpha | * |
-| indicative_price | User entered price that is expected for this item | Real |  |
+| 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** | The unique ID of the item that this tender line is for | UUID | * |
+| **item_ID** | Identifier of the item being tendered | | | Alpha | * |
-| item_name | Copied from the name of the item when it is chosen (to ensure the item name at the time of the tender is preserved, even if the master record in mSupply is edited | Alpha (80)|  |
+| 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 |  | Boolean |  |
+| is_synced | Indicates whether the line has been synced | | | Boolean | |
-| line_number | The row number that is saved so the row ordering can be maintained | Long Integer |  |
+| line_number | Saved row number of the tender line | | | Long Integer | |
-| noOfPacks | How many packs you expect to buy | Real |  |
+| 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 | The pack size requested (suppliers may offer in other pack sizes) | 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 | The product of noOfPacks x 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 | User entered text that may explain criteria for choosing a winner of this line.  | Text |  |
+| 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** | The ID of the item units you are specifying for this tender line | UUID | * |
+| **unit_ID** | Unit of measure used for this tender line | | | Alpha | * |
+| **tender_ID** | Identifier of the parent tender | | | Alpha | * |
 ---- struct data ----
+pagestatus.status    :
 ----