List Purchase Orders By Document
Modelo alineado al schema de salida de Fracttal ETL para órdenes de compra por documento.
Output Parameters
conditions_description: str, opcional Condiciones de la orden de compra.costs_center_description: str, opcional Descripción del centro de costos.costs_center_value: str, opcional Valor del centro de costos.currency_description: str, opcional Descripción de la moneda.currency_symbol: str, opcional Símbolo de la moneda.date: str, opcional Fecha de la orden de compra.date_create: str, opcional Fecha de creación.description: str, opcional Descripción general.document: str, opcional Documento asociado.folio_source: str, opcional Folio fuente.folio_target: str, opcional Folio destino.id_company: int, opcional ID de la compañía.id_movement: int, opcional ID del movimiento.
Información general:
| Module | Category |
|---|---|
Budget |
Read |
ListPurchaseOrdersByDocument
Parámetros:
No parameters.
Parámetros de entrada:
| Campo | Tipo | Obligatorio | Descripción | Default Value | Examples |
|---|---|---|---|---|---|
Ejemplo de uso:
{
"conditions_description": "Pago a 30 días",
"costs_center_description": "Mantenimiento",
"costs_center_value": "CC001",
"currency_description": "USD",
"currency_symbol": "$",
"date": "2024-01-01",
"date_create": "2024-01-01T10:00:00Z",
"description": "Compra de repuestos",
"document": "PO-001",
"folio_source": "FS-001",
"folio_target": "FT-001",
"id_company": 300,
"id_movement": 400,
"id_movement_type": 1,
"id_warehouse_source": "WH-001",
"id_warehouse_target": 2,
"movements_states_description": "Aprobado",
"movements_types_description": "Compra",
"number_details": 5,
"priorities_description": "Alta",
"responsible_code": "USR-001",
"responsible_description": "Juan Pérez",
"third_parties_address": "Calle 123",
"third_parties_code": "TP-001",
"third_parties_email": "tp@correo.com",
"third_parties_name": "Proveedor S.A.",
"third_parties_telephone_1": "+56 9 1234 5678",
"third_parties_telephone_2": "+56 2 2345 6789",
"warehouse": {
"active": true,
"address": "Av. Central 123",
"allow_negative_stock": false,
"city": "Santiago",
"code": "WH-001",
"code_location": "LOC-001",
"country": "Chile",
"description": "Almacén Central",
"external_integration": false,
"folio": 10,
"folio_po": 20,
"id": 1,
"id_company": 300,
"id_location": "LOC-001",
"latitude": "-33.4489",
"location_description": "Zona Norte",
"longitude": "-70.6693",
"material_request_approval": false,
"mode": 1,
"prefix": "PRE-",
"prefix_po": "PREPO-",
"state": "Activo",
"suffix": "-SFX",
"suffix_po": "-SFXPO",
"total_cost_stock": 10000,
"transfer_approval": false,
"visible_to_all": true,
"zip_code": "8320000"
},
"warehouse_details_movements": [
{
"code": "MOV-001",
"date": "2024-01-01",
"date_create": "2024-01-01T10:00:00Z",
"id": 500,
"id_company": 300,
"id_item": 100,
"id_item_original": 101,
"id_movement": 400,
"id_movement_type": 1,
"id_taxes": 1,
"id_warehouse_source": "WH-001",
"id_warehouse_target": 2,
"is_serial_control": false,
"item": {
"active": true,
"anual_depreciation": "5%",
"available": true,
"barcode": "1234567890",
"budgets_description": "Presupuesto 2024",
"code": "ITM-001",
"cost_average": 100,
"costs_center_description": "Mantenimiento",
"custom_fields_groups_description": "Grupo 1",
"custom_fields_values": "{}",
"description": "Repuesto X",
"field_1": "F1",
"field_2": "F2",
"field_3": "F3",
"field_4": "F4",
"field_5": "F5",
"field_6": "F6",
"groups_1_description": "Grupo 1",
"groups_2_description": "Grupo 2",
"groups_description": "Grupo General",
"groups_tasks_description": "Tarea 1",
"hours_average_daily_use": "8",
"id": 100,
"id_company": 300,
"id_group_task": "GT-001",
"id_parent": "PARENT-001",
"id_type_item": 1,
"initial_date_out_of_service": "2024-01-01",
"is_serial_control": false,
"item_url": "http://item.url",
"items_types_description": "Tipo X",
"last_final_date_available": "2024-01-01",
"latitude": "-33.4489",
"lead_time": 10,
"longitud": "-70.6693",
"min_stock_warning": "5",
"notes": "Nota",
"parent_description": "Padre X",
"priorities_description": "Alta",
"purchase_date": "2023-12-01",
"salvage_value": "100",
"startup_date": "2024-01-01",
"third_parties_name": "Proveedor S.A.",
"total_cost": "1000",
"total_replacement_cost": "1200",
"units_code": "UNI",
"units_description": "Unidad",
"visible_to_all": true,
"weight": 10
},
"item_status": 1,
"item_tax_rate": 19,
"items_description": "Repuesto X",
"qty": 10,
"qty_pending": 2,
"serial_numbers": "SN-001",
"tax_name": "IVA",
"total_cost": 1000,
"total_cost_company": 950,
"unit_cost": 100,
"unit_cost_company": 95,
"units_code": "UNI",
"units_description": "Unidad"
}
],
"warehouses_source_code": "WH-001",
"warehouses_source_description": "Almacén Central",
"warehouses_target_code": "WH-002",
"warehouses_target_description": "Almacén Secundario"
}
Notas:
Este modelo representa la respuesta de la consulta de órdenes de compra por documento, alineado 100% al schema de salida.