Query budget

id = The id of the budget if you want to filter by a particular budget.

Input parameters

Parameter Type Required Description
id *Text* Optional Budget Id
wo_folio *Text* Optional TO ID (If the budget ID is sent, the TO ID will not be taken into account and vice versa).
since *Text* Optional Initial date of the query. Format: 'YYYYY-MM-DDTHH:MM:SS-UTC' Example:'2016-07-12T20:00:00-03′. (Default is 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.
type_date *Text* Optional Type of date to make the query. It can be:
Value Description
creation_date Date of creation of the TO (Default value)
initial_date
Date of creation of the TO (Default value). Initial date of the task
final_date End date of the task
approval_date Approval date
.
start *Integer* Optional Number of records from which you want to start the query. All queries are limited to 100 records, when there are more than that amount you must use this parameter for pagination.
limit *Integer* Optional Final record number to be returned by the query.

Output parameters

Paramter Type Description
folio *Text* Budget Id
reference *Text* Budget reference
note *Integer* Budget notes
exchange_value *Integer* Exchange value
id_priority *Integer* Budget Priority 1: Very High 2: High 3: Medium 4: Low 5: Very Low
date_create *Date* Budget creation date
status *Text* Budget status 1: Pending approval 2: Approved 3: Rejected
approved_by *Text* Approved by
note_status *Text* Notes to the budget status change
discount *Real* Discount
id_currency *Integer* Coin ID
created_by *Text* Created by
third_parties_name *Text* Name of the third party associated with the budget
third_parties_code *Text* Code of the third party associated with the budget
third_parties_address *Text* Address of the third party associated with the budget
third_parties_email *Text* True if the asset is stopped and False if the asset is NOT stopped.
third_parties_city *Integer* Asset stop time (seconds)
third_parties_country *Text* Type of task
third_parties_telephone_1 *Text* Location of the asset
third_parties_telephone_2 *Text* Sum of hours of human resources used
costs_center_description *Text* Activator Type
items_description *Text* Name of the WO asset that is associated with the budget
items_groups_description *Text* Type of asset
items_groups_1_description *Text* Asset classification 1
items_groups_2_description *Integer* Asset classification 2
conditions_description *Text* Description of conditions
currency_description *Text* Description of the coin
symbol *Text* Currency symbol
wo_folio *Text* Number of WO to which the budget is associated
id_status_work_order *Text* 1: WO in Process 2: WO in Review
final_date *Text* 3: WO terminated 4: WO cancelled WO end date
user_assigned *Text* User assigned to the WO
list_items *json* List of assets that are associated with the budget
approval_date *Date* Budget approval date

Example:

Request: (GET)https://app.fracttal.com/api/wo_budget/22

{
    "success": true,
    "message": "200",
    "data": [
        {
            "id": 22,
            "id_company": 69,
            "id_work_order": 1243,
            "id_third_parties_log": 16,
            "id_cost_center": 2,
            "folio": "22",
            "id_currency": 4,
            "exchange_value": 1,
            "reference": "Referencia",
            "id_priority": 1,
            "note": "Notas",
            "id_item_log": 170,
            "date_create": "2019-05-07T14:15:24.607382+00:00",
            "id_condition": 1,
            "status": 1,
            "approved_by": null,
            "note_status": null,
            "discount": 0,
            "created_by": "Laura Marcela Peña Jaramillo",
            "third_parties_name": "Fracttal SPA - Tercero",
            "third_parties_code": "Fttl_Tre02",
            "third_parties_address": "San Pio X",
            "third_parties_email": "[email protected]",
            "third_parties_city": "Providencia",
            "third_parties_country": "Chile",
            "third_parties_telephone_1": "555-555-55",
            "third_parties_telephone_2": null,
            "costs_center_description": "Materiales",
            "items_description": "Edificio prinicipal San pio X Santiago 000000 Región Metropolitana Chile { 7543 }",
            "items_groups_description": "Tipo 1",
            "items_groups_1_description": null,
            "items_groups_2_description": null,
            "conditions_description": "30 días",
            "currency_description": "Peso Colombiano",
            "symbol": "$",
            "wo_folio": "1279",
            "id_status_work_order": 1,
            "final_date": null,
            "user_assigned": "Carlos Jaramillo",
            "parent_description": "// Edificio prinicipal/ ",
            "list_items": [
                {
                    "id_company": 69,
                    "type_resource": 1,
                    "qty": 5,
                    "unit_cost_company": 54000,
                    "total_cost_company": 270000,
                    "unit_cost": 54000,
                    "total_cost": 270000,
                    "id_taxes": 1,
                    "hrl_description": null,
                    "items_log_description": "O-RING 24,2X3 BOMBA TRIDO 45 H (ATLASCOPCO 0663 2127-00)  -Diamec 232    { 200426 }",
                    "stl_description": null
                }
            ],
            "approval_date": null
        }
    ],
    "total": 1
}

Test It