Tenders

Back to list of main tables

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	*