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
}

Did this answer your question?