Ir para o conteúdo

Listar pedidos de compra por documento

Modelo alinhado ao esquema de saída Fracttal ETL para pedidos de compras por documento.

Parâmetros de saída

  • conditions_description: str, opcional Condições do pedido de compra.
  • costs_center_description: str, opcional Descrição do centro de custo.
  • costs_center_value: str, opcional Valor do centro de custo.
  • currency_description: str, opcional Descrição da moeda.
  • currency_symbol: str, opcional Símbolo de moeda.
  • data: str, opcional Data do pedido de compra.
  • date_create: str, opcional Data de criação.
  • descrição: str, opcional Descrição geral.
  • documento: str, opcional Documento associado.
  • folio_source: str, opcional Fólio de origem.
  • folio_target: str, opcional Fólio de destino.
  • id_company: int, opcional ID da empresa.
  • id_movement: int, opcional ID do movimento.

Informação geral:

Module Category
Orçamento Ler

ListPurchaseOrdersByDocument

Parâmetros:

No parameters.

Parâmetros de entrada:

Campo Tipo Obrigatório Descrição Default Value Examples

Exemplo 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 a resposta à consulta do pedido de compra por documento, 100% alinhado ao esquema de saída.

Relacionado: