Requisition

Back to list of main tables

internal name: requisition was “name_stock_history” up to & including version 3.5. “Requisition” from version 3.6

Field name	Description	mSupply Use	Reference link	Type	Indexed
ID	The unique ID of this requisition record	Primary key	Alpha	*
name_ID	The name ID of the other party of the request (supplier) or response (customer)	Not shown in UI but used display Requisition/Internal order»Name	Alpha
user_ID	The ID of the user who entered the data	Not shown in UI but used display open any Requisition/Internal order»Entered by	Alpha
status	The status of the record (SG = suggested, CN = confirmed, FN = finalised, WP = web: in progress, WF = finalised by customer after web submission)	Requisition/Internal order»Status	Alpha
type	im for imprest, sh for stock history, request, response, supply, report	Open any Requisition/Internal order»Type	https://docs.msupply.org.nz/issuing_goods:stock_control_methods#requisition_type	Alpha
store_ID	The ID of the store the order belongs to (request) or ID of the supplying store (response)	Not shown in UI but used display Requisition/Internal order»Store	Alpha
date_stock_take	The date the customer recorded the stock on hand data at their store	Date
date_entered	The date the requisition was entered	Open any Requisition/Internal order»Entry date	Date
date_order_received	Date the order reached your premises (from the customer)	Date
serial_number	Next sequence number to be used for virtual on next requisition	Requisition/Internal order»ID	Long
requester_reference	Text with the serial_number of other store requisition (case type is response)	Requisition/Internal order»Their ref/Reference	Alpha
previous_csh_id	The ID of the requisition that was submitted before this one	Alpha
nsh_custInv_ID	The ID of the customer invoice created from this record	Alpha
daysToSupply	The number of days stock they should be given	Used to display Requisition/Internal order»Max MOS	Long
linked_requisition_id	The unique ID link to the request requisition (case type is response)	Alpha
linked_purchase_order_ID	The unique ID of the purchase order related to the request	Alpha
comment	Comment for the entire requisition (response type will show the request number here)	Requisition/Internal order»Comment	Alpha
colour	Colour assigned to requisition (internal/system use)	Long
custom_data	Contains any custom values set for a requisition	Object
authorisationStatus	Status of authorisation workflow	Alpha
thresholdMOS	Threshold months of stock for requisition	Used to display open any Requisition/Internal order»Threshold MOS	Double
orderType	Order type used in	New customer requisition»Order type	https://docs.msupply.org.nz/issuing_goods:stock_control_methods#new_customer_requisition	Alpha
periodID	Reporting period ID	Alpha
programID	Program ID for reporting or categorisation	https://docs.msupply.org.nz/purchasing:ordering_from_one_store_to_another#programs	Alpha
lastModifiedAt	Timestamp of last modification	Long
is_emergency	True if requisition is marked as emergency	Boolean
isRemoteOrder	True if requisition was entered remotely	Boolean
om_created_datetime	OMS: date/time requisition created in OMS system	Alpha
om_sent_datetime	OMS: date/time requisition sent to supplier	Alpha
om_finalised_datetime	OMS: date/time requisition finalised in OMS system	Alpha
om_max_months_of_stock	Maximum months of stock used in OMS calculations	Double
om_status	OMS status of requisition	Alpha
om_colour	OMS colour code for requisition	Alpha
om_expected_delivery_date	Expected delivery date used for requisition charts	Date
date_required	Date the requisition is required	Date
requisition_category_ID	ID of the requisition category	Not shown in UI but used display Requisition/Internal order»Category	https://docs.msupply.org.nz/issuing_goods:stock_control_methods#requisition_categories	Alpha
donor_ID	ID of donor associated with this requisition	Not shown in UI but used display Requisition»Donor	Alpha
oms_fields	OMS extended fields	Object

Requisition Line

Contains all the lines on a requisition

internal name: requisition_line

was “nsh_line” up to and including version 3.5

Field name	Description	mSupply Use	Reference link	Type	Indexed
actualquan	Quantity to be supplied	real
adjusted_consumption	Consumption value adjusted for days out of stock	Open any Requisition» Data entry tab»Consumed column	real
colour	Colour of the row when displayed	long
comment	Comment per each line	Open any Requisition» Data entry tab»Comment column	text
Cust_loss_adjust	Records losses or gains not due to normal consumption/receipts	real
Cust_prev_stock_balance	Stock on hand at the previous stocktake (calculated)	real
Cust_stock_order	Calculated amount of stock to give the user	real
Cust_stock_received	Stock received between previous requisition and current stocktake (calculated)	real
Cust_stock_issued	Stock issued to the customer	real
daily_usage	Daily usage / average monthly consumption value	real
days_out_or_new_demand	Days out of stock or new demand value used for AMC adjustment	real
DOSforAMCadjustment	Days of stock used for AMC adjustment	long
ID	ID of the record	Alpha	*
imprest_or_prev_quantity	Imprest quantity defined for each item	real
item_ID	ID of the item this line is for	Alpha	*
itemName	Name of the item	Alpha
linked_requisition_line_ID	ID of the related requisition line	Alpha
line_number	Row number for ordering items (1,2,…)	long
optionID	Option identifier	Alpha
om_snapshot_datetime	Datetime of AMC and SOH calculation	Alpha
purchase_order_line_ID	Linked purchase order line ID	Alpha
previous_stock_on_hand	Previous stock on hand at the customer store	real
requestedPackSize	Requested pack size	real
approved_quantity	Quantity approved by authoriser	real
authoriser_comment	Comment from authoriser	text
requisition_ID	ID of the requisition record	Alpha	*
spare_text	Spare text field	text
stock_on_hand	Stock reported at this stocktake	real
stockLosses	Stock losses recorded	real
stockAdditions	Stock additions recorded	real
stockExpiring	Stock that is expiring	real
suggested_quantity	Suggested quantity to order	real
custom_data	Custom data	Object
oms_fields	OMS-related data	Object