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