Skip to main content

​
Asset Queries

​
GetAllActivosFijos

Retrieves all fixed assets from the inventory system. 
query {
  getAllActivosFijos {
    numero
    compSubn
    fecha
    descripcion1
    descripcion2
    descripcion3
    cantidad
    numSerie
    numInventario
    placa
    valorAdq
    ceCoste
    localizacion
    custodio1
    custodio2
    saldoNeto
    depAcum
  }
}
​
numero
string
Asset number (main identifier)
​
compSubn
string
Component sub-number
​
fecha
DateTime
Asset registration date
​
descripcion1
string
Primary asset description
​
descripcion2
string
Secondary asset description
​
descripcion3
string
Additional asset description
​
cantidad
string
Quantity
​
unid
decimal
Unit value
​
numSerie
string
Serial number
​
numInventario
string
Inventory number
​
placa
string
License plate or identification plate number
​
valorAdq
decimal
Acquisition value
​
creadoPor
string
User who created the asset record
​
fecCreacion
DateTime
Creation date
​
modificadoPor
string
User who last modified the record
​
fecModificacion
DateTime
Last modification date
​
altaOrig
DateTime
Original registration date
​
feCapit
DateTime
Capitalization date
​
ultBaja
DateTime
Last disposal date
​
ceCoste
string
Cost center code
​
ordCoste
string
Cost order
​
centro
string
Center code
​
localizacion
string
Physical location
​
vidaUtil
string
Useful life in years
​
numFactura
string
Invoice number
​
acreedor
string
Vendor/creditor
​
custodio1
string
Primary custodian
​
custodio2
string
Secondary custodian (employee ID or email)
​
saldoNeto
decimal
Net balance (book value)
​
depAcumA
decimal
Accumulated depreciation A
​
depAcum
decimal
Total accumulated depreciation
​
saldoDep
decimal
Depreciation balance

​
GetActivoFijoByCodigoSerieCustodio2

Searches for assets by asset code, serial number, or custodian. Returns all assets matching any of the provided criteria. 
query {
  getActivoFijoByCodigoSerieCustodio2(
    codigo: "123456"
    serie: "SN123456"
    custodio2: "[email protected]"
  ) {
    numero
    compSubn
    descripcion1
    numSerie
    custodio2
    localizacion
    saldoNeto
  }
}
​
codigo
string
required
Asset code (concatenation of numero and compSubn)
​
serie
string
required
Serial number to search for
​
custodio2
string
required
Custodian identifier (employee ID or email)
​
returns
ActFijosAppInvActivosDataDTO[]
Array of assets matching any of the search criteria. See GetAllActivosFijos for field descriptions.

​
GetActivoFijoByCodigos

Retrieves multiple assets by their asset codes. 
query {
  getActivoFijoByCodigos(codigos: ["123456-1", "123456-2", "789012-1"]) {
    numero
    compSubn
    descripcion1
    numSerie
    saldoNeto
    custodio2
  }
}
​
codigos
string[]
required
Array of asset codes in format “numero-compSubn”
​
returns
ActFijosAppInvActivosDataDTO[]
Array of assets matching the provided codes. See GetAllActivosFijos for field descriptions.

​
Request Queries

​
GetAllSolicitudesActivosFijos

Retrieves all fixed asset requests (solicitudes) in the system. 
query {
  getAllSolicitudesActivosFijos {
    idSolicitud
    tipoSolicitud {
      nombre
    }
    motivo {
      nombre
    }
    localidad {
      nombre
      compania {
        nombre
      }
    }
    custodio {
      nombre
      email
    }
    estado
    correo
    detalle
    codigoActivoFijo
    valorNegociado
    createdAt
    createdBy
  }
}
​
idSolicitud
int
Unique request identifier
​
id_tipo_solicitud
int
Request type ID (references catalog)
​
tipoSolicitud
CatalogoDTO
Request type details (e.g., Transfer, Assignment, Disposal)
​
id_motivo
int
Reason/motive ID (references catalog)
​
motivo
CatalogoDTO
Reason details (e.g., Relocation, Retirement, Damage)
​
id_localidad
int
Destination location ID
​
localidad
IndAfLocalidadDTO
Location details including company
​
id_usuario
int
Requesting user ID
​
id_custodio
int
New custodian user ID
​
custodio
UsuarioDTO
Custodian user details
​
id_centro_costo
int
Cost center ID
​
centroCosto
IndReCentroCostosDTO
Cost center details
​
estado
string
Request status (e.g., PENDING, APPROVED, REJECTED, FINALIZADO)
​
correo
string
Contact email for the request
​
detalle
string
Detailed description of the request
​
informeTecnico
string
URL or path to technical report document
​
guiaRemision
string
URL or path to shipping/transfer guide
​
fotoFrente
string
URL to front photo of the asset
​
fotoAf
string
URL to asset tag photo
​
fotoSerie
string
URL to serial number photo
​
fotoDamage
string
URL to damage photo (if applicable)
​
tipoBeneficiario
byte
Beneficiary type code
​
pesaje
string
Weight documentation (for disposal)
​
factura
string
Invoice reference
​
contrato
string
Contract reference
​
codigoActivoFijo
string
Asset code being requested
​
valorNegociado
decimal
Negotiated value (for disposal transactions)
​
createdAt
DateTime
Request creation timestamp
​
updatedAt
DateTime
Last update timestamp
​
createdBy
string
Email of user who created the request
​
pickedBy
string
Email of fixed assets staff member handling the request
​
resumen
string
Summary document URL
​
excel
string
Excel report URL
​
externo
string
External party information
​
pertenece
int
Ownership indicator

​
GetAllSolicitudesActivosFijosByCorreo

Retrieves all requests created by a specific user. 
query {
  getAllSolicitudesActivosFijosByCorreo(correo: "[email protected]") {
    idSolicitud
    tipoSolicitud {
      nombre
    }
    estado
    codigoActivoFijo
    createdAt
  }
}
​
correo
string
required
Email address of the user who created the requests
​
returns
IndAfSolicitudDTO[]
Array of requests created by the specified user. See GetAllSolicitudesActivosFijos for field descriptions.

​
GetAllSolicitudesActivosFijosByCorreoAF

Retrieves all requests assigned to a specific fixed assets staff member. 
query {
  getAllSolicitudesActivosFijosByCorreoAF(correo: "[email protected]") {
    idSolicitud
    tipoSolicitud {
      nombre
    }
    estado
    codigoActivoFijo
    createdBy
    pickedBy
  }
}
​
correo
string
required
Email address of the fixed assets staff member
​
returns
IndAfSolicitudDTO[]
Array of requests assigned to (picked by) the specified staff member. See GetAllSolicitudesActivosFijos for field descriptions.

​
GetAllByActivoFijo

Retrieves all active requests for a specific fixed asset. 
query {
  getAllByActivoFijo(af: "123456-1") {
    idSolicitud
    tipoSolicitud {
      nombre
    }
    estado
    detalle
    createdAt
    createdBy
  }
}
​
af
string
required
Asset code to search for
​
returns
IndAfSolicitudDTO[]
Array of requests for the specified asset that are not finalized or rejected. See GetAllSolicitudesActivosFijos for field descriptions.

​
GetActivoFijoById

Retrieves a specific request by its ID. 
query {
  getActivoFijoById(id: 123) {
    idSolicitud
    tipoSolicitud {
      nombre
    }
    motivo {
      nombre
    }
    localidad {
      nombre
    }
    custodio {
      nombre
      email
    }
    estado
    detalle
    codigoActivoFijo
    createdAt
  }
}
​
id
int
required
Request ID
​
returns
IndAfSolicitudDTO
Complete request details. See GetAllSolicitudesActivosFijos for field descriptions.

​
GetActivoFijoByIdSolicitante

Retrieves a specific request by ID, but only if the requesting user is the creator. 
query {
  getActivoFijoByIdSolicitante(id: 123, email: "[email protected]") {
    idSolicitud
    estado
    detalle
    codigoActivoFijo
  }
}
​
id
int
required
Request ID
​
email
string
required
Email of the user requesting the data (must match createdBy)
​
returns
IndAfSolicitudDTO
Request details if the email matches the creator, null otherwise. See GetAllSolicitudesActivosFijos for field descriptions.

Build docs developers (and LLMs) love

Get started for freeTalk to us