tables_fields:main_tables:requisition

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:requisition [2020/01/07 01:04] – ↷ Page moved from tables:main_tables:requisition to tables_fields:main_tables:requisition loutables_fields:main_tables:requisition [2026/01/26 06:45] (current) – Raksha Khadka
Line 1: Line 1:
 ====== Requisition ====== ====== Requisition ======
  
-[[tables:main_tables:|Back to list of main tables]]+[[..:|Back to list of main tables]]
 <WRAP center round info 60%> <WRAP center round info 60%>
  
Line 9: Line 9:
  
  
-^ Field name ^ Description ^ Type ^ Ind ^ +^Field name ^ Description ^ mSupply Use ^ Reference link ^ Type ^ Indexed ^ 
-| custom_data | Contains any custom values set for a requisition. Key “reporting_period_size” (values “month” or “quarter”) contains the size of reporting period the requisition is for | Object |  | +| **ID** | The unique ID of this requisition record | Primary key | | Alpha | * | 
-| comment | Comment for the entire requisition (response type will show the request number here) |  text  | | +| **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 | | 
-| date_entered | The date the customer's data was entered | Date |  | +| **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 | | 
-| date_order_received | Date the order reached your premises (from the customer) | Date |  | +| 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 | | 
-| date_stock_take | The date the customer recorded the stock on hand data at their store | Date |  | +| 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 | | 
-| daystosupply | The number of days stock they should be given | long |  | +| **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 | | 
-| **ID** | The unique ID of this record | UUID |  *  | +| date_stock_take | The date the customer recorded the stock on hand data at their store | | | Date | | 
-| linked_purchase_order_id | The unique ID of the purchase order related to the request | UUID |  | +| date_entered | The date the requisition was entered |Open any Requisition/Internal order>>Entry date| | Date | | 
-| linked_requisition_id | The unique ID link to the request requisition (case type is response) | UUID |  | +| date_order_received | Date the order reached your premises (from the customer) | | | Date | | 
-| **name_ID** | The name ID of the other party of the request (supplier) or response (customer) | UUID |  *  | +| serial_number | Next sequence number to be used for virtual on next requisition |Requisition/Internal order>>ID| | Long | | 
-| nsh_custinv_ID | The ID of the customer invoice created from this record | UUID |  | +| 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 | UUID |  | +| previous_csh_id | The ID of the requisition that was submitted before this one | | | Alpha | | 
-| requester_reference | Text with the serial_number of other store requisition (case type is response)  | text |  | +| nsh_custInv_ID | The ID of the customer invoice created from this record | | | Alpha | | 
-| serial_number | Next sequence number to be used for virtual on next requisition | long |  | +| daysToSupply | The number of days stock they should be given |Used to display Requisition/Internal order>>Max MOS | | Long | | 
-| status | The status of the record **SG** = suggested \\ **CN** = confirmed \\ **FN** = finalised \\ **WP** = web: still in progress \\ **WF** = finalised by customer after web submission| text |  | +| linked_requisition_id | The unique ID link to the request requisition (case type is response) | | | Alpha | | 
-| store_ID | The ID of the store the order belongs to (request) or ID of the supplying store (response) | UUID |   | +| linked_purchase_order_ID | The unique ID of the purchase order related to the request | | | Alpha | | 
-| type | **im** for imprest (where each item has a pre-determined max quantity and the facility submits their current stock on hand) or \\ **sh** for stock history, where the facility submits stock on hand, and their history is used to determine a supply quantity \\ **request** A request from a facility where they determine the quantity. If between facilities, duplicate supply requisition is created on finalisation in the supplying store \\ **response** A response to the request created for the suppling store \\ **supply** the supplying store's copy of a request requisition \\ **report** A requisition that is for reporting purposes only.  | Alpha |    | +| comment | Comment for the entire requisition (response type will show the request number here) |Requisition/Internal order>>Comment | | Alpha | | 
-| user_ID | The ID of the user who entered the data | UUID |   |+| 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 ====== ====== Requisition Line ======
Line 34: Line 54:
   * was "nsh_line" up to and including version 3.5   * was "nsh_line" up to and including version 3.5
  
-^ Field name ^ Description ^  Type  ^  Ind  ^ +^ Field name ^ Description ^ mSupply Use ^ Reference link ^ Type ^ Indexed ^ 
-| actualquan | quantity to be supplied |  real  |  | +| actualquan | Quantity to be supplied | | | real | | 
-| adjusted_consumption | A consumption value for an item adjusted for days out of stock |  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  |  | +| colour | Colour of the row when displayed | | | long | | 
-| comment | Comment per each line |  text  | | +| comment | Comment per each line |Open any Requisition>> Data entry tab>>Comment column | | text | | 
-| Cust_loss_adjust | Records any losses or gains in stock levels that aren't normal consumption/receipts. |  real  |  | +| Cust_loss_adjust | Records losses or gains not due to normal consumption/receipts | | | real | | 
-| Cust_prev_stock_balance | the stock on hand at the previous stocktake (calculated) |  real  |  | +| Cust_prev_stock_balance | Stock on hand at the previous stocktake (calculated) | | | real | | 
-| Cust_stock_order | The calculated amount of stock to give the user. |  real |  | +| Cust_stock_order | Calculated amount of stock to give the user | | | real | | 
-| Cust_stock_received | The amount of stock received by customer between previous requisition record \\ for this item and the current stocktake (calculated). |  real  |  | +| Cust_stock_received | Stock received between previous requisition and current stocktake (calculated) | | | real | | 
-| daily_usage | ID of the record |  UUID  |   *   | +| Cust_stock_issued | Stock issued to the customer | | | real | | 
-| **ID** | ID of the record |  UUID  |   *   | +| daily_usage | Daily usage / average monthly consumption value | | | real | | 
-| imprest_or_prev_quantity | Imprest quantity defined for each item for the user.|  real  |  | +| days_out_or_new_demand | Days out of stock or new demand value used for AMC adjustment | | | real | | 
-| **item_ID** | ID of the item this line is for |  UUID  |   *   | +| DOSforAMCadjustment | Days of stock used for AMC adjustment | | | long | | 
-| linked_requisition_line_id | ID of the same requisition_line on the request (for response requisition_lines) |  UUID  |   | +| **ID** | ID of the record | | | Alpha | * | 
-| line_number | The saved row number for ordering items in the requisition. (1,2, etc)  |  long  |  | +| imprest_or_prev_quantity | Imprest quantity defined for each item | | | real | | 
-| previous_stock_on_hand | the previous amount of stock on hand on the customer store |  real  |  | +| **item_ID** | ID of the item this line is for | | | Alpha | * | 
-| **requisition_ID** | ID of the **requisition** record this record is related to (see above) |  UUID  |   *   | +| itemName | Name of the item | | | Alpha | | 
-| stock_on_hand | the stock the customer reported for this item this stocktake |  real  |  | +| **linked_requisition_line_ID** | ID of the related requisition line | | | Alpha | | 
-| suggested_quantity | the amount of stock suggested for the customer to order |  real  |  | +| 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 | |
  
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2026/01/26 06:45
  • by Raksha Khadka