tables_fields:main_tables:quote

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
tables_fields:main_tables:quote [2020/01/07 01:04] – ↷ Page moved from tables:main_tables:quote to tables_fields:main_tables:quote loutables_fields:main_tables:quote [2026/01/25 12:28] (current) – Raksha Khadka
Line 1: Line 1:
 ====== Quotes ====== ====== Quotes ======
  
-[[tables:main_tables:|Back to list of main tables]]+[[tables_fields:main_tables:|Back to list of main tables]]
  
-^ Field name ^ Description ^ Type ^ Length ^ Ind ^ 
-| **currency_ID** | The currency ID for quotes | String |  20 |  *  | 
-| deliveries_requested | Delivery requested date for quote | Long |  |  | 
-| downloaded | Quote downloaded | Boolean |  |  | 
-| **ID** | Unique ID for quote | Long |  |  *  | 
-| MyComment | Comment for quote | Text |  |  | 
-| **names_ID** | The name id for quote | Long |  |  *  | 
-| responded_date | The responded date for quote | Date |  |  | 
-| rate_per_m3 | The freight rate per m3 in the same currency as the quote | Real |  |  | 
-| rate_per_kg | The freight rate per kg in the same currency as the quote | Real |  |  | 
-| sent_date | The date the quote was sent to the supplier | Date |  |  | 
-| supplier_ref | Supplier reference for quote | String |  80 |  | 
-| SupplierComment | Supplier comment for quote | Text |  |  | 
-| **tender_ID** | The tender id for quote | Long |  |  *  | 
-| ValidityDate | The validity date of the quote | Date |  |  | 
  
 +^ Field name    ^ Description          ^ mSupply Use        ^ Reference link      ^ Type       ^ Indexed ^
 +| **currency_ID** | The currency ID for quotes |Id are not shown in UI but used to display Open any supplier>>Quotes tab>>New/edit Quote>>Their quote currency |https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#adding_supplier_responses_to_a_tender| Alpha  |  *  |
 +| deliveries_requested | Delivery requested date for quote | | | Long |  |
 +| downloaded | Quote downloaded | | | Boolean |  |
 +| **ID** | Unique ID for quote | | | Alpha  |  *  |
 +| MyComment | Comment for quote |Open any supplier>>Quotes tab>>New/edit Quote>>Comments tab>>My comment(Same window open in tender>>Choose suppliers and enter response tab>>open any supplier)|https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#comments_tab| Text |  |
 +| **names_ID** | The name id for quote | | | Alpha |  *  |
 +| responded_date | The responded date for quote | | | Date |  |
 +| rate_per_m3 | The freight rate per m3 in the same currency as the quote | | | Real |   |
 +| rate_per_kg | The freight rate per kg in the same currency as the quote | | | Real |  |
 +| sent_date | The date the quote was sent to the supplier | | | Date |  |
 +| supplier_ref | Supplier reference for quote |Open any supplier>>Quotes tab>>Their reference
 +| | Alpha |  |
 +| SupplierComment | Supplier comment for quote |Open any supplier>>Quotes tab>>New/edit Quote>>Comments tab>>Supplier comment(Same window open in tender>>Choose suppliers and enter response tab>>open any supplier)|https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#comments_tab| Text |  |
 +| **tender_ID** | The tender id for quote | | | Alpha |  *  |
 +| ValidityDate | The validity date of the quote | | | Date |  |
  
 ====== Quote lines ====== ====== Quote lines ======
  
-^ Field name ^ Description ^ Type ^ Length ^ Ind ^ +^ Field name ^ Description ^ mSupply Use ^ Reference link ^ Type ^ Indexed ^ 
-| adj cost | The adjusted cost for quote line shows you the cost in local currency of the reference pack that has been set for that item. |  Real  |  |  | +| adj cost | Adjusted cost in local currency of the reference pack | Open any quote line>>Edit tender response>>Adjusted cost | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#cost_local_pack | Real |  | 
-| **currency_ID** | The currency id for quote line | String |  20 |  *  | +| **currency_ID** | Currency id for quote line | Not shown in UI but used to display any quote>>Edit tender response>>Currency | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#currency | Alpha | * | 
-| comment | The comment for quote line | Text |  |  | +| comment | Comment for quote line | Open any quote line>>Edit tender response>>Supplier comment | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#supplier_comment | Text |  | 
-| currency_rate | The currency rate for quote line | Real |  |  | +| currency_rate | Currency rate for quote line | Open any quote line>>Edit tender response>>Rate to use | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#rate_to_use | Real |  | 
-| **disqualified** | If true, the quote line has been disqualified. e.g. it doesn't meet the requirement that you asked for  | Boolean |  |  | +| disqualified | Indicates if quote line is disqualified | Open any quote>>Edit tender response>>Disqualified | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#disqualified | Boolean |  | 
-| DeliveryTime | Expected delivery time- you can choose to either enter a date or a number of days/weeks/months/years from the date the order is received by the supplier | Text |  |  | +| DeliveryTime | Expected delivery time | Open any quote line>>Edit tender response>>Delivery time | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#delivery_time | Text |  | 
-| date_created | Creation date for quote line | Date |  |  | +| date_created | Creation date for quote line |  |  | Date |  | 
-| edit_date | The edited date for quote line | Date |  |  | +| edit_date | Edited date for quote line | Open any quote line>>Edit tender response>>Date | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#general | Date |  | 
-| ExpiryDate | The expiry date for quote line | Text |  |  | +| ExpiryDate | Expiry date for quote line | Open any quote line>>Edit tender response>>Exp date | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#exp_date | Text |  | 
-| Freight_comment | The freight comment for quote line | Text |  |  | +| Freight_comment | Freight comment | Open any quote line>>Edit tender response>>Freight notes | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#freight_notes | Text |  | 
-| Freight_per_preferred_pack | The freight per preferred pack for quote line | Real |  |  | +| Freight_per_preferred_pack | Freight per preferred pack | Open any quote line>>Edit tender response>>Freight for preferred pack | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#freight_for_preferred_pack | Real |  | 
-| freight_factor | Freight factor for quote line | Real |  |  | +| freight_factor | Freight factor | Open any quote line>>Edit tender response>>Freight factor | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#freight_factor | Real |  | 
-| freight_total | Freight total for quote line | Real |  |  | +| freight_total | Freight total |  |  | Real |  | 
-| **item_ID** | Item id for a quote line | Long |  |  *  | +| **item_ID** | Item id for quote line | Not shown in UI but used to display any quote>>Edit tender response>>Item |  | Alpha | * | 
-| **ID** | Unique id for quote line | Long |  |  *  | +| **ID** | Unique id for quote line |  |  | Alpha | * | 
-| lead_time_days | The total lead time for quote line | Long |  |  | +| lead_time_days | Total lead time |  |  | Long |  | 
-| manufacturer_ID | The manufacturer id for quote line | Long |  |  | +| manufacturer_ID | Manufacturer id | Not shown in UI but used to display any quote>>Edit tender response>>Manufacturer | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#manufacturer | Alpha |  | 
-| **name_ID** | The name id for quote line | Long |  |  *  | +| **name_ID** | Name id for quote line | Not shown in UI but used to display any quote>>Edit tender response>>Supplier | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#general | Alpha | * | 
-| net_cost | Net cost of quote line | Real |  |  | +| net_cost | Net cost | Open any quote line>>Edit tender response>>Net cost |  | Real |  | 
-| price | Price for quote line | Real |  |  | +| price | Price | Open any quote line>>Edit tender response>>Price | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#price | Real |  | 
-| **preferred** | Quote line preferred from supplier and that supplier has won the tender  | Boolean |  |  | +| preferred | Preferred quote line | Open any quote line>>Edit tender response>>Preferred | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#preferred | Boolean |  | 
-| pack_size | Pack size for quote line | Real |  |  | +| pack_size | Pack size | Open any quote line>>Edit tender response>>Pack size | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#pack | Real |  | 
-| price_break_comment | Price break note for quote line | Text |  |  | +| price_break_comment | Price break note | Open any quote line>>Edit tender response>>Price break notes | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#price_break | Text |  | 
-| price_break_quanity | Price break quantity for quote line | Real |  |  | +| price_break_quanity | Price break quantity | Open any quote line>>Price break quantity | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#price_break_quantity | Real |  | 
-| price_break_discount | Price discount for quote line | Real |  |  | +| price_break_discount | Price break discount | Open any quote line>>Edit tender response>>Discount | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#discount | Real |  | 
-| **quote_ID** | The quote id for quote line | Long |  |  *  | +| **quote_ID** | Quote id |  |  | Alpha | * | 
-| **RTM_id** | The Remote Tender Module id for quote line | Long |  |  | +| strip pack | Strip pack indicator | Open any quote line>>Edit tender response>>Strip pack |  | Boolean |  | 
-| strip pack | Strip pack for quote line | Boolean |  |  | +| supplier_code | Supplier code | Open any quote line>>Edit tender response>>Supplier's code | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#supplier_s_code | String |  | 
-| supplier_code | The supplier code for quote line | String |  50 |  | +| supplier_bar_code | Supplier bar code | Open any quote line>>Edit tender response>>Supplier's bar code | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#supplier_bar_code | String |  | 
-| supplier_bar_code | The supplier bar code for quote line | String |  50 |  | +| supplier_preferred_pack_size | Supplier preferred pack size | Open any quote line>>Edit tender response>>Preferred pack |  | Real |  | 
-| supplier_preferred_pack_size | The supplier preferred pack size for quote line | Real |  |  | +| **tender_line_ID** | Tender line id |  |  | Alpha | * | 
-| tender_line_ID | The tender line id for quote line | Long |  |  *  | +| valid_until_date | Quote line validity date | Open any quote line>>Edit tender response>>Valid until | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#valid_until | Date |  | 
-| valid_until_date | Quote line validity date | Date |  |  | +| volume_per_pack | Volume per pack |  |  | Real |  | 
-| volume_per_pack | Volume per pack for quote line | Real |  |  |+| spare | Indicates spare status |  |  | Long |  | 
 +| line_num | Line sequence number |  |  | Long |  | 
 +| custom_data | Custom or extended data (JSON/object) |  |  | Object |  | 
 +| min_price | Minimum price |  |  | Real |  | 
 +| max_price | Maximum price |  |  | Real |  | 
 +| purchase_order_line_ID | Related purchase order line |  |  | Alpha |  | 
 +| total_cost | Total calculated cost | Open any quote line>>Edit tender response>>Total cost |  | Real |  | 
 +| supplier_number_of_packs | Number of packs quoted | Open any quote line>>Edit tender response>>Supplier number of packs |  | Long |  | 
 +| method_of_delivery | Method of delivery | Open any quote line>>Edit tender response>>Method of delivery | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#method_of_delivery | Alpha |  | 
 +| evaluator_comment | Internal evaluator comment | Open any quote line>>Edit tender response>>Evaluator comment | https://docs.msupply.org.nz/tender_management:receiving_quotations_from_suppliers#evaluator_comment | Text |  | 
 +| tender_currency_ID | Tender evaluation currency |  |  | Alpha |  |
  
 <WRAP center round info 60%> <WRAP center round info 60%>
Line 63: Line 74:
 </WRAP> </WRAP>
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2026/01/25 12:28
  • by Raksha Khadka