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

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