Query WO material requisitions

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 . .

Parameter	Type of field	Description
code	Text	Resource code	Text	Code of the resource
items_description	Text	Resource description
qty	Real	Quantity requested
qty_pending	Actual	Quantity Pending Delivery
units_description	text	Unit Description
Unit Description
unit_unit_cost_company	Actual	Unit cost
total_cost_company	Actual	Total cost	Total cost	item_status	Number	1: Item created 2: Item removed from the TO

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