Query Movements Details

get

https://app.fracttal.com/api/warehouse_details_movements/

Query the details of a warehouse movement by movement ID or date range.

Use this endpoint when you already know the movement number you want to query. You can obtain that number from the incoming and outgoing movement query APIs.

Endpoint

GET https://app.fracttal.com/api/warehouse_details_movements/

Query parameters

Parameter	Type	Required	Description
`id_movement`	Text	Optional	ID of the movement.
`since`	Text	Optional	Initial date for the query. Format: `YYYY-MM-DDTHH:MM:SS-UTC`. Example: `2016-07-12T20:00:00-03`. Default: 30 days before the current date.
`until`	Text	Optional	End date for the query. Format: `YYYY-MM-DDTHH:MM:SS-UTC`. Example: `2016-07-12T20:00:00-03`. Default: current date.
`type_date`	Text	Optional	Date type used for the query. Accepted values: `date` or `date_create`. Default: `date`.
`start`	Integer	Optional	Initial record number to display in the query.
`limit`	Integer	Optional	Final record number to return in the query.

`type_date` values

Value	Description
`date`	Date of the transaction. This is the default value.
`date_create`	Creation date of the transaction.

Response parameters

Parameter	Type	Description
`id_movement`	Integer	ID of the movement.
`qty`	Number	Quantity.
`unit_cost`	Number	Unit cost.
`total_cost`	Number	Total cost.
`items_description`	Text	Item description.
`is_serial_control`	Boolean	Indicates whether the item is controlled by serial number.
`units_description`	Text	Unit description.
`tax_name`	Text	Tax name.
`serial_numbers`	Text	Serial number.
`code`	Text	Item code.
`date`	Text	Movement date.
`date_create`	Text	Movement creation date.
`qty_order`	Integer	Total quantity requested in the purchase order related to the material entry. It represents the number of units originally ordered.
`qty_pending`	Integer	Quantity pending in the purchase order that has not yet been processed, dispatched, or completed in the material entry. It represents the units that have not yet been fulfilled against the total requested.
`id_responsible`	Integer	Unique identifier of the responsible person associated with the record.
`responsible`	Text	Name or description of the person responsible for the operation or record.

Example

Request

GET https://app.fracttal.com/api/warehouse_details_movements/?id_movement=2112

Response

{
  "success": true,
  "message": "200",
  "data": [
    {
      "id": 8890702,
      "id_movement": 5412687,
      "id_company": 1190,
      "id_item": 5295055,
      "qty": 4,
      "unit_cost": 8000,
      "id_taxes": 1,
      "total_cost": 32000,
      "items_description": " CASCO DE PROTECCIÓN { Item-seg-001-Ruben }",
      "is_serial_control": false,
      "units_description": "Unidad",
      "units_code": "Unidad",
      "id_item_original": 30423151,
      "tax_name": "Exempt",
      "item_tax_rate": 0,
      "serial_numbers": null,
      "unit_cost_company": 8000,
      "total_cost_company": 32000,
      "code": "Item-seg-001-Ruben",
      "item_status": 1,
      "date": "2023-08-31",
      "date_create": "2023-08-31T14:07:15.1413+00:00",
      "id_warehouse_source": null,
      "id_warehouse_target": 33483,
      "id_movement_type": 10,
      "qty_order": 1,
      "qty_pending": 1,
      "id_responsible": 111,
      "responsible": "1- Lavadero"
    },
    {
      "id": 8890703,
      "id_movement": 5412687,
      "id_company": 1190,
      "id_item": 5295056,
      "qty": 5,
      "unit_cost": 2500,
      "id_taxes": 1,
      "total_cost": 12500,
      "items_description": " Lentes de seguridad { Item-seg-002-Ruben }",
      "is_serial_control": false,
      "units_description": "Unidad",
      "units_code": "Unidad",
      "id_item_original": 30423172,
      "tax_name": "Exempt",
      "item_tax_rate": 0,
      "serial_numbers": null,
      "unit_cost_company": 2500,
      "total_cost_company": 12500,
      "code": "Item-seg-002-Ruben",
      "item_status": 1,
      "date": "2023-08-31",
      "date_create": "2023-08-31T14:07:15.1413+00:00",
      "id_warehouse_source": null,
      "id_warehouse_target": 33483,
      "id_movement_type": 10,
      "qty_order": 1,
      "qty_pending": 1,
      "id_responsible": 111,
      "responsible": "1- Lavadero"
    }
  ],
  "total": 2
}

Response

200

Language

Loading…