Fracttal →

Query Movements Details

Through this EndPoint you can see the details of a warehouse movement.

To perform this query, the number of the movement to be queried must be known. This number can be known through the APIS for incoming and outgoing movement queries.

Input parameters

ParameterTypeRequierdDescription
id_movementTextOptionalId of the movement
sinceTextOptionalInitial date of the query. Format: 'YYYYY-MM-DDTHH:MM:SS-UTC'
Example: '2016-07-12T20:00:00-03'.
(Default 30 days before)
untilTextOptionalEnd date of the query.
Format: 'YYYYY-MM-DDTHH:MM:SS-UTC' Example:'2016-07-12T20:00:00-03'.
(Defaults to the current date.
type_dateTextOptionalType of date to make the query. It can be :

ValueDescription
dateDate of the transaction (Default value)
date_createDate of creation of the transaction
.
startIntegerOptionalInitial record number to be displayed by the query.
limitIntegerOptionalFinal record number to be returned by the query.

Output parameters

ParameterTypeDescription
id_movementIntegerId of the movement
qtyNumberQuantity
qty_pendingNumberQuantity Pending
unit_costNumberUnit Cost
total_costNumberTotal Cost.
items_descriptionTextItem description
is_serial_controlBooleanIt is controlled by serial
units_descriptionTextUnit
tax_nameTextTax
serial_numbersTextSerial number
codeTextItem code
dateTextDate of movement
date_createTextDate of creation of the movement

Example:

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

{
    "success": true,
    "message": "200",
    "data": [
        {
            "id": 31310,
            "id_movement": 2112,
            "id_company": 133,
            "id_item": 21630,
            "qty": 7,
            "qty_pending": 7,
            "unit_cost": 29566,
            "id_taxes": 2,
            "total_cost": 250424,
            "items_description": "ACEITE HIDRAULICO HY-GARD X L MMRVF4315   { MMRVF4315 }",
            "is_serial_control": false,
            "units_description": "LITROS",
            "id_item_original": 12439,
            "tax_name": "IVA 2",
            "item_tax_rate": 21,
            "serial_numbers": null,
            "unit_cost_company": 29566,
            "total_cost_company": 250424,
            "code": "MMRVF4315",
            "date": "2021-07-21",
            "date_create": "2021-07-21T21:34:55.150866+00:00"
        },
        {
            "id": 31309,
            "id_movement": 2112,
            "id_company": 133,
            "id_item": 21987,
            "qty": 50,
            "qty_pending": 50,
            "unit_cost": 0,
            "id_taxes": 2,
            "total_cost": 0,
            "items_description": "CLAVO { HERR-0001 }",
            "is_serial_control": false,
            "units_description": "Maquina",
            "id_item_original": 37611,
            "tax_name": "IVA 2",
            "item_tax_rate": 21,
            "serial_numbers": null,
            "unit_cost_company": 0,
            "total_cost_company": 0,
            "code": "HERR-0001",
            "date": "2021-07-21",
            "date_create": "2021-07-21T21:34:55.150866+00:00"
        },
        {
            "id": 31308,
            "id_movement": 2112,
            "id_company": 133,
            "id_item": 21988,
            "qty": 30,
            "qty_pending": 30,
            "unit_cost": 537500,
            "id_taxes": 2,
            "total_cost": 19511200,
            "items_description": "CABLE ARNES DE 55 A 32 PINES CAB209 B10M VOLVO { CAB209 }",
            "is_serial_control": false,
            "units_description": "Maquina",
            "id_item_original": 13835,
            "tax_name": "IVA 2",
            "item_tax_rate": 21,
            "serial_numbers": null,
            "unit_cost_company": 537500,
            "total_cost_company": 19511200,
            "code": "CAB209",
            "date": "2021-07-21",
            "date_create": "2021-07-21T21:34:55.150866+00:00"
        }
    ],
    "total": 3
}

Test it

Language