get https://app.fracttal.com/api/work_orders_movements
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