IMMEX Lookups
The ONESOURCE Lookups screen is a cross-platform functionality that provides a high-level overview of all records stored in each ONESOURCE product. For more information on the Lookup functionality, refer to the Lookup user guide.
The IMMEX Lookup contains different categories which are described in the subsections listed below. You can access them by clicking the sub-menu Lookups.
important
Avoid using
Lookups
for extracting large volumes of data (e.g., tens of thousands of records). For such extractions, use the available Outbound reports
or request a customization for specific cases. IMMEX Catalogs
Provides queries to get master data information for:
- Company Catalog
- Item Master Catalog
- Fixed Assets Catalog
Vision Authority (Spanish)
- Business Catalog
- Representatives and Customs Agents
- Materials
- Products
- General Taxpayer Information
IMMEX Pedimentos
It allows you to review Broker Pedimento data, orgazined by each section of the pedimento file:
- Archivos M Cargados
- Archivos de Firma Cargados
- Pedimento - Encabezado (501)
- Pedimentos Rectificados
- Pedimento - Facturas (505)
- Pedimento - Partidas (551)
- Pedimento - Encabezado (501 Broker)
- Pedimento - Facturas (505 Broker)
- Pedimento - Tasas (509-510 Broker)
- Pedimento - Partidas (551 Broker)
- Pedimento - Tasas Detalle (556/557 Broker)
IMMEX Pre-FIFO
This category should be used to review validation errors, pending processes and transactions before processing FIFO. These queries can help avoiding issues during FIFO.
- Pedimentos available for FIFO
- Pedimento Ready for FIFO BUT with Open Invoices
- Open Invoices
- Closed Invoices (Pending FIFO)
- Receipts without Expiration
- Validation Errors
- Receipt and Shipment Errors (General Validation)
- Product Transactions
- Staging Transactions
- Direct Discharges
IMMEX Post-FIFO
This category should be used to review validation errors, pending processes and transactions after processing FIFO. These queries can help troubleshooting the FIFO resulting issues.
- Pedimento Aging Inquiry (Extract)
- Pending IM
- Pending PC
- Issued PC
- Issues IM
IMMEX DataStage
Provides queries to extract master Data Stage files, organized by each layout:
- Pedimentos Anexo 30 (IVA Pago 21 y 22)
- DS Folios Cargados
- DS Encabezado (501)
- DS Transportes (502)
- DS Guias (503)
- DS Contenedores (504)
- DS Facturas (505)
- DS Fechas (506)
- DS Identificadores Global (507)
- DS Cuentas Global (508)
- DS Contribuciones Global (509)
- DS Pago Contribuciones Global (510)
- DS Descargos (512)
- DS Destino Embarque (520)
- DS Partidas (551)
- DS Mercancias (552)
- DS Permisos (553)
- DS Identificadores Partidas (554)
- DS Cuentas Partida (555)
- DS Contribuciones Partida (556)
- DS Pago Contribuciones Detalle (557)
- DS Rectificaciones (701)
- DS Contribuciones Rectificación (702)
IMMEX CTM
This provides errors and inconsistences found during the upload of the details when the workflow runs.
- IMMEX CTM Workflow errors
IMMEX INEGI
This lookup allows you to view all the sections within the
INEGI report
and it also provides details on the sections outlined below.- INEGI - Detalles M310
- INEGI - Detalles M710
- INEGI - Detalles M100
- INEGI - Detalles K316
- INEGI - Detalles K317
- INEGI - Detalles K100
- INEGI - Detalles K910