Through this EndPoint you can query the material requisitions generated from OTs and in a given date range.
Input parameters
Parameter | Type | Required | Description |
---|---|---|---|
folio
|
*Text* | Optional | WO Id. |
ot_status
|
*Number* | Optional | Status of WO. 1: Process 2: Revision 3: Completed 4: Cancelled |
warehouse_code
|
*Text* | Optional | Warehouse code of the warehouse to which the material requisition is linked |
since
|
*Text* | Optional | Initial date of the query. Format: 'YYYYY-MM-DDTHH:MM:SS-UTC' Example: '2016-07-12T20:00:00-03'. (Default 30 days before) |
until
|
*Text* | Optional | End date of the query. Format: 'YYYYY-MM-DDTHH:MM:SS-UTC' Example:'2016-07-12T20:00:00-03'. (Defaults to the current date. |
id_movements_details
|
*Integer* | Optional | Warehouse movement ID (applies only to inventory type resources with associated material requisitions). |
page
|
*Integer* | Optional | Page number to consult. |
start
|
*Integer* | Optional | Initial record number to be displayed by the query |
limit
|
*Integer* | Optional | Final record number to be returned by the query. |
Output parameters
Parameter | Type | Description | |||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
warehouses_source_description
|
*Text* | Warehouse Description | |||||||||||||||||||||||||||||||
warehouses_source_description
|
*Integer* | Warehouse Code | |||||||||||||||||||||||||||||||
folio_source
|
*Integer* | Movement ID | |||||||||||||||||||||||||||||||
date
|
*Text* | Date of resource creation in WO | |||||||||||||||||||||||||||||||
document
|
*Text* | WO Id. | |||||||||||||||||||||||||||||||
costs_center_description
|
*Text* | Descripción centro de costos del movimiento | |||||||||||||||||||||||||||||||
movements_states_description
|
*Text* | Movement status can be: NOT_DELIVERED: NOT DELIVERED, PARTIAL_DELIVERY: PARTIAL DELIVERY, TOTAL_DELIVERY: TOTAL DELIVERY, DELIVERY_CANCELLED: CANCELLED. | |||||||||||||||||||||||||||||||
responsible_description
|
*Text* | Responsible | |||||||||||||||||||||||||||||||
date_create
|
*Text* | Requisition creation date | |||||||||||||||||||||||||||||||
number_details
|
*Real* | Amount of requisition resources | |||||||||||||||||||||||||||||||
currency_description
|
*Text* | Description of the currency | |||||||||||||||||||||||||||||||
currency_symbol
|
*Text* | Currency symbol | |||||||||||||||||||||||||||||||
list_items
|
*JSON* |
List of requisition resources
|
Example:
Request: (GET)https://app.fracttal.com/api/work_orders_movements/742
{
"success": true,
"message": "200",
"data": [
{
"warehouses_source_description": "Almacen 01",
"code": "ALM-01",
"folio_source": "MOV10A",
"date": "2016-11-14",
"document": "742",
"movements_states_description": "NOT_DELIVERED",
"costs_center_description": null,
"responsible_description": "RICARDO ROMAN",
"date_create": "2016-11-14T19:30:42.811553",
"number_details": 1,
"currency_description": "Dollar",
"currency_symbol": "$",
"list_items": [
{
"code": "DIES-01",
"items_description": "DIESEL OIL ",
"qty": 200,
"qty_pending": 200,
"units_description": "LITROS",
"unit_cost_company": 1000,
"total_cost_company": 200000,
"item_status": 1,
"id_movements_details": 572,
"location": "Sin definir"
}
],
}
],
"total": 1
}
Example Request with Date range:
Exemple Petition: https://app.fracttal.com/api/work_orders_movements/?since=2016-11-10T20:00:00-03&until=2016-11-13T20:00:00-03
Example Response:
{
"success": true,
"message": "200",
"data": [
{
"warehouses_source_description": "Almacen 01",
"code": "ALM-01",
"folio_source": "MOV9A",
"date": "2016-11-11",
"document": "733",
"movements_states_description": "NOT_DELIVERED",
"costs_center_description": null,
"responsible_description": "Pedro Perez",
"date_create": "2016-11-11T17:30:32.110634",
"number_details": 1,
"currency_description": "Dollar",
"currency_symbol": "$",
"list_items": [
{
"code": null,
"items_description": "FILTRO DE COMBUSTIBLE VW AUV-3290 VW 3290",
"qty": 5,
"qty_pending": 5,
"units_description": "PIEZA",
"unit_cost_company": 1050,
"total_cost_company": 5250,
"id_parent": null,
"item_status": 1,
"id_movements_details": 572,
"location": "Sin definir"
}
],
"id_company": 133
},
{
"warehouses_source_description": "BODEGA DE CONSUMIBLES",
"code": "ALM-01",
"folio_source": "ALM22MED",
"date": "2016-11-11",
"document": "736",
"movements_states_description": "NOT_DELIVERED",
"costs_center_description": null,
"responsible_description": "Akbar Guevara",
"date_create": "2016-11-11T19:40:32.551836",
"number_details": 1,
"currency_description": "Dollar",
"currency_symbol": "$",
"list_items": [
{
"code": null,
"items_description": "ACEITE MOBIL 600 W ALA020 600W",
"qty": 2,
"qty_pending": 2,
"units_description": "UNIDAD",
"unit_cost_company": 18337,
"total_cost_company": 36674,
"id_parent": null,
"item_status": 1,
"id_movements_details": 572,
"location": "Sin definir"
}
],
"id_company": 133
},
{
"warehouses_source_description": "LA BODEGUITA DEL MELO",
"code": "A25",
"folio_source": "3",
"date": "2016-11-11",
"document": "738",
"movements_states_description": "NOT_DELIVERED",
"costs_center_description": null,
"responsible_description": "RICARDO ROMAN (TECNICO)",
"date_create": "2016-11-11T19:55:23.311522",
"number_details": 1,
"currency_description": "Dollar",
"currency_symbol": "$",
"list_items": [
{
"code": null,
"items_description": "ACEITE HIDRAULICO HY-GARD X L MMRVF4315",
"qty": 1,
"qty_pending": 1,
"units_description": "LITROS",
"unit_cost_company": 0,
"total_cost_company": 0,
"id_parent": null,
"item_status": 1,
"id_movements_details": 572,
"location": "Sin definir"
}
],
"id_company": 133
},
{
"warehouses_source_description": "ALMACEN CENTRAL MALVINAS ARGENTINAS",
"code": "C-001",
"folio_source": "M17",
"date": "2016-11-11",
"document": "740",
"movements_states_description": "NOT_DELIVERED",
"costs_center_description": null,
"responsible_description": "Alberto Baraona ",
"date_create": "2016-11-11T20:33:39.146271",
"number_details": 1,
"currency_description": "Dollar",
"currency_symbol": "$",
"list_items": [
{
"code": "CF 02",
"items_description": "EMPAQUETADURA 2P-6132 14G",
"qty": 1,
"qty_pending": 1,
"units_description": "UNIDAD",
"unit_cost_company": 100,
"total_cost_company": 100,
"id_parent": null,
"item_status": 1,
"id_movements_details": 572,
"location": "Sin definir"
}
],
}
],
"total": 4
}
Test It