Through this EndPoint you can query the material requisitions generated from TOs and in a given date range.
EndPoint
https://app.fracttal.com/api/work_orders_movements/:folio
Input Parameters
Parameter | Field type | Required | Description |
folio | Text | Optional | TO ID. |
ot_status | Number | Optional | Status of the TO 1: Processing, 2: Revision, 3: Completed, 4: Canceled |
warehouse_code | Text | Optional | Code of the warehouse to which the material requisition is associated. |
since | Text | Optional | Initial date of the inquiry. Formato: 'YYYY-MM-DDTHH:MM:SS-UTC' Ejemplo:'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'. (Default 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 query. |
start | Integer | Optional | Initial record number to be displayed by the query. |
limit | Integer | Optional | Final record number that the query will return. |
Output parameters
Parameter | Field type | Description |
warehouses_source_description | Text | Warehouse Description |
code | Integer | Warehouse Code |
folio_source | Integer | Movement ID |
date | Text | Date of resource creation in the TO |
document | Text | ID of the TO. |
costs_center_description | Text | Description of the cost center of the movement |
movements_states_description | Text | Status of the movement, 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 | Requisition Resource Quantity |
currency_description | Text | Currency Description |
currency_symbol | Text | Currency Symbol |
list_items | JSON | List of requisition resources Parameter/Field Type/Description code / Text /Code of the resource items_description / Text / Description of the resource qty / Actual / Quantity Requested qty_pending / Actual / Quantity Pending delivery units_description / Text / Description of the unit unit_cost_company / Actual / Costo unitario total_cost_company / Actual / Real / Costo Total item_status / Number / 1: Item created 2: Item removed from the TO |
Output parameters
Example:
Example Request: https://app.fracttal.com/api/work_orders_movements/742
Example Response:
{
"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:
Ejemplo Petición: 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": "PIECE",
"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": " CONSUMABLES WAREHOUSE ",
"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": " HYDRAULIC OIL HY-GARD X L MMRVF4315",
"qty": 1,
"qty_pending": 1,
"units_description": "LITERS",
"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": "MALVINAS ARGENTINAS CENTRAL WAREHOUSE", "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": " PACKAGING 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": " Not defined "
}
],
}
],
"total": 4
}