> ## Documentation Index > Fetch the complete documentation index at: https://docs.orquestr.dev/llms.txt > Use this file to discover all available pages before exploring further. # SICAR V4 functions > Default Cloud Functions for adapter `sicarv4` (device POS / MySQL). # SICAR V4 functions These functions appear when you list functions for a device with `adapter = "sicarv4"` (UI label **Sicar V4**). Invoke with: ```http theme={"system"} POST /v1/devices/{device_id}/functions/{function_id} Authorization: Bearer sk_live_… Content-Type: application/json { "input": { ... } } ``` Write functions (`*.create`) run a **pre-validation SELECT** on the device before any INSERT. ## Catalog (76) | Function | Description | | ----------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------- | | [`device.health`](/functions/adapters/sicarv4/fn/device-health) | Agent / database health check | | [`sicarv4.schema`](/functions/adapters/sicarv4/fn/sicarv4-schema) | List SICAR tables with column names and data types | | [`sicarv4.products.list`](/functions/adapters/sicarv4/fn/sicarv4-products-list) | List SICAR products (tabla articulo) | | [`sicarv4.products.search`](/functions/adapters/sicarv4/fn/sicarv4-products-search) | Search articulo by text (art\_id/clave/claveAlterna/descripcion/caracteristicas), ids, status, servicio, existencia, cat\_id | | [`sicarv4.inventory.list`](/functions/adapters/sicarv4/fn/sicarv4-inventory-list) | List SICAR inventory levels (existencia en articulo) | | [`sicarv4.categories.list`](/functions/adapters/sicarv4/fn/sicarv4-categories-list) | List SICAR categories (tabla categoria) | | [`sicarv4.categories.search`](/functions/adapters/sicarv4/fn/sicarv4-categories-search) | Search categories by cat\_id (comma-separated) | | [`sicarv4.customers.list`](/functions/adapters/sicarv4/fn/sicarv4-customers-list) | List SICAR customers (tabla cliente) | | [`sicarv4.customers.search`](/functions/adapters/sicarv4/fn/sicarv4-customers-search) | Search customers by cli\_id (comma-separated) | | [`sicarv4.departments.list`](/functions/adapters/sicarv4/fn/sicarv4-departments-list) | List SICAR departments (tabla departamento) | | [`sicarv4.departments.search`](/functions/adapters/sicarv4/fn/sicarv4-departments-search) | Search departments by dep\_id (comma-separated) | | [`sicarv4.invoices.list`](/functions/adapters/sicarv4/fn/sicarv4-invoices-list) | List SICAR invoices (tabla factura) | | [`sicarv4.invoices.search`](/functions/adapters/sicarv4/fn/sicarv4-invoices-search) | Search invoices by fac\_id (comma-separated) | | [`sicarv4.registers.list`](/functions/adapters/sicarv4/fn/sicarv4-registers-list) | List SICAR cash registers (tabla caja) | | [`sicarv4.registers.search`](/functions/adapters/sicarv4/fn/sicarv4-registers-search) | Search cash registers by caj\_id (comma-separated) | | [`sicarv4.cash_cuts.list`](/functions/adapters/sicarv4/fn/sicarv4-cash_cuts-list) | List SICAR cash-register cuts (tabla cortecaja) — newest cor\_id first | | [`sicarv4.cash_cuts.search`](/functions/adapters/sicarv4/fn/sicarv4-cash_cuts-search) | Search cash-register cuts by cor\_id (comma-separated) | | [`sicarv4.cash_cut_payments.list`](/functions/adapters/sicarv4/fn/sicarv4-cash_cut_payments-list) | List SICAR cash-cut amounts by payment type (tabla cortetipopago) | | [`sicarv4.cash_cut_payments.search`](/functions/adapters/sicarv4/fn/sicarv4-cash_cut_payments-search) | Search cash-cut payment rows by cor\_id. No row id: every line of that cut | | [`sicarv4.cash_cut_summaries.list`](/functions/adapters/sicarv4/fn/sicarv4-cash_cut_summaries-list) | List SICAR cash-cut summaries (tabla resumencortecaja) — newest rcc\_id first | | [`sicarv4.cash_cut_summaries.search`](/functions/adapters/sicarv4/fn/sicarv4-cash_cut_summaries-search) | Search cash-cut summaries by rcc\_id (comma-separated) | | [`sicarv4.cash_cut_payment_summaries.list`](/functions/adapters/sicarv4/fn/sicarv4-cash_cut_payment_summaries-list) | List SICAR cash-cut summary lines by payment type (tabla resumentipopago) | | [`sicarv4.cash_cut_payment_summaries.search`](/functions/adapters/sicarv4/fn/sicarv4-cash_cut_payment_summaries-search) | Search cash-cut payment summaries by rcc\_id. No row id: every line of that summary | | [`sicarv4.tip_cuts.list`](/functions/adapters/sicarv4/fn/sicarv4-tip_cuts-list) | List SICAR tip cuts (tabla cortepropina) — newest cpr\_id first | | [`sicarv4.tip_cuts.search`](/functions/adapters/sicarv4/fn/sicarv4-tip_cuts-search) | Search tip cuts by cpr\_id (comma-separated) | | [`sicarv4.currencies.list`](/functions/adapters/sicarv4/fn/sicarv4-currencies-list) | List SICAR currencies (tabla moneda) | | [`sicarv4.currencies.search`](/functions/adapters/sicarv4/fn/sicarv4-currencies-search) | Search currencies by mon\_id (comma-separated) | | [`sicarv4.payment_types.list`](/functions/adapters/sicarv4/fn/sicarv4-payment_types-list) | List SICAR payment types (tabla tipopago) — tpa\_id for sales | | [`sicarv4.payment_types.search`](/functions/adapters/sicarv4/fn/sicarv4-payment_types-search) | Search payment types by tpa\_id (comma-separated) | | [`sicarv4.users.list`](/functions/adapters/sicarv4/fn/sicarv4-users-list) | List SICAR users (tabla usuario) — usu\_id for historial / quotes / orders | | [`sicarv4.users.search`](/functions/adapters/sicarv4/fn/sicarv4-users-search) | Search users by usu\_id (comma-separated) | | [`sicarv4.sellers.list`](/functions/adapters/sicarv4/fn/sicarv4-sellers-list) | List SICAR sellers (vendedor) without binary columns. Optional status + columns. | | [`sicarv4.sellers.search`](/functions/adapters/sicarv4/fn/sicarv4-sellers-search) | Search sellers by vnd\_id and/or text (nombre\|clave\|alias). Same column projection as list. | | [`sicarv4.seller_groups.list`](/functions/adapters/sicarv4/fn/sicarv4-seller_groups-list) | List SICAR seller groups (tabla grupovendedor) — gvn\_id for sellers.create | | [`sicarv4.seller_groups.search`](/functions/adapters/sicarv4/fn/sicarv4-seller_groups-search) | Search seller groups by gvn\_id (comma-separated) | | [`sicarv4.shifts.list`](/functions/adapters/sicarv4/fn/sicarv4-shifts-list) | List SICAR shifts (tabla turno) — tur\_id for sellers.create | | [`sicarv4.shifts.search`](/functions/adapters/sicarv4/fn/sicarv4-shifts-search) | Search shifts by tur\_id (comma-separated) | | [`sicarv4.positions.list`](/functions/adapters/sicarv4/fn/sicarv4-positions-list) | List SICAR job positions (tabla puesto) — pue\_id for sellers.create | | [`sicarv4.positions.search`](/functions/adapters/sicarv4/fn/sicarv4-positions-search) | Search job positions by pue\_id (comma-separated) | | [`sicarv4.vacations.list`](/functions/adapters/sicarv4/fn/sicarv4-vacations-list) | List SICAR vacation policies (tabla vacaciones) — vac\_id for sellers.create | | [`sicarv4.vacations.search`](/functions/adapters/sicarv4/fn/sicarv4-vacations-search) | Search vacation policies by vac\_id (comma-separated) | | [`sicarv4.shifts.create`](/functions/adapters/sicarv4/fn/sicarv4-shifts-create) | Create SICAR shift (turno + historial). Optional for sellers — tur\_id is nullable. | | [`sicarv4.suppliers.list`](/functions/adapters/sicarv4/fn/sicarv4-suppliers-list) | List SICAR suppliers (tabla proveedor) — pro\_id for purchase orders | | [`sicarv4.suppliers.search`](/functions/adapters/sicarv4/fn/sicarv4-suppliers-search) | Search suppliers by pro\_id (comma-separated) | | [`sicarv4.units.list`](/functions/adapters/sicarv4/fn/sicarv4-units-list) | List SICAR units (tabla unidad) | | [`sicarv4.units.search`](/functions/adapters/sicarv4/fn/sicarv4-units-search) | Search units by uni\_id (comma-separated) | | [`sicarv4.taxes.list`](/functions/adapters/sicarv4/fn/sicarv4-taxes-list) | List SICAR taxes (tabla impuesto) — imp\_id for products.create / articuloimpuesto | | [`sicarv4.taxes.search`](/functions/adapters/sicarv4/fn/sicarv4-taxes-search) | Search taxes by imp\_id (comma-separated) | | [`sicarv4.roles.list`](/functions/adapters/sicarv4/fn/sicarv4-roles-list) | List SICAR roles (tabla rol) — rol\_id for users.create / sellers.create | | [`sicarv4.roles.search`](/functions/adapters/sicarv4/fn/sicarv4-roles-search) | Search roles by rol\_id (comma-separated) | | [`sicarv4.tax_regimes.list`](/functions/adapters/sicarv4/fn/sicarv4-tax_regimes-list) | List SICAR tax regimes (tabla regimenfiscal) — rgf\_id for customers.create | | [`sicarv4.tax_regimes.search`](/functions/adapters/sicarv4/fn/sicarv4-tax_regimes-search) | Search tax regimes by rgf\_id (comma-separated) | | [`sicarv4.customer_groups.list`](/functions/adapters/sicarv4/fn/sicarv4-customer_groups-list) | List SICAR customer groups (tabla grupocliente) — grc\_id for customers.create | | [`sicarv4.customer_groups.search`](/functions/adapters/sicarv4/fn/sicarv4-customer_groups-search) | Search customer groups by grc\_id (comma-separated) | | [`sicarv4.images.search`](/functions/adapters/sicarv4/fn/sicarv4-images-search) | Search images by img\_id (comma-separated) | | [`sicarv4.custom.select`](/functions/adapters/sicarv4/fn/sicarv4-custom-select) | Custom SELECT on a whitelisted table — choose columns, optional ids filter, limit | | [`sicarv4.custom.query`](/functions/adapters/sicarv4/fn/sicarv4-custom-query) | Read-only free-form SQL (SELECT / SHOW / DESCRIBE only). INSERT/UPDATE/DELETE/DROP rejected. Mutations use registry \*.create functions. | | [`sicarv4.custom.validate`](/functions/adapters/sicarv4/fn/sicarv4-custom-validate) | Validate read-only SQL only (same policy as custom.query) | | [`sicarv4.sales.create`](/functions/adapters/sicarv4/fn/sicarv4-sales-create) | Create SICAR sale (TICKET\|NOTA\|REMISION): folio + venta + lines + taxes + cash + stock. Registry write only — not custom.query. | | [`sicarv4.sales.list`](/functions/adapters/sicarv4/fn/sicarv4-sales-list) | List SICAR sales (tabla venta) — newest first | | [`sicarv4.sales.search`](/functions/adapters/sicarv4/fn/sicarv4-sales-search) | Search sales by ven\_id (comma-separated) | | [`sicarv4.quotes.create`](/functions/adapters/sicarv4/fn/sicarv4-quotes-create) | Create SICAR quotation (cotización): NO stock/cash. Registry write only — not custom.query. | | [`sicarv4.quotes.list`](/functions/adapters/sicarv4/fn/sicarv4-quotes-list) | List SICAR quotes (tabla cotizacion) — newest first | | [`sicarv4.quotes.search`](/functions/adapters/sicarv4/fn/sicarv4-quotes-search) | Search quotes by cot\_id (comma-separated) | | [`sicarv4.purchase_orders.create`](/functions/adapters/sicarv4/fn/sicarv4-purchase_orders-create) | Create SICAR supplier purchase order (pedido). Registry write only — not custom.query. | | [`sicarv4.purchase_orders.list`](/functions/adapters/sicarv4/fn/sicarv4-purchase_orders-list) | List SICAR purchase orders (tabla pedido) — newest first | | [`sicarv4.purchase_orders.search`](/functions/adapters/sicarv4/fn/sicarv4-purchase_orders-search) | Search purchase orders by ped\_id (comma-separated) | | [`sicarv4.inventory.adjust`](/functions/adapters/sicarv4/fn/sicarv4-inventory-adjust) | Adjust SICAR article stock (ajusteinventario): type adjustment\|entry\|exit + cantidad + comentario. Registry write — not custom.query. | | [`sicarv4.customers.create`](/functions/adapters/sicarv4/fn/sicarv4-customers-create) | Create SICAR customer (cliente + historial). Registry write — clave unique. | | [`sicarv4.units.create`](/functions/adapters/sicarv4/fn/sicarv4-units-create) | Create SICAR unit (unidad + historial). Registry write — nombre unique. | | [`sicarv4.products.create`](/functions/adapters/sicarv4/fn/sicarv4-products-create) | Create SICAR product (articulo + articuloimpuesto + historial). Registry write — clave unique. | | [`sicarv4.suppliers.create`](/functions/adapters/sicarv4/fn/sicarv4-suppliers-create) | Create SICAR supplier (proveedor + historial). Registry write. | | [`sicarv4.sellers.create`](/functions/adapters/sicarv4/fn/sicarv4-sellers-create) | Create SICAR seller (vendedor + historial). Registry write — clave unique. Not a login user. | | [`sicarv4.users.create`](/functions/adapters/sicarv4/fn/sicarv4-users-create) | Create SICAR user (usuario + historial). Copies encrypted password from an existing user — no plaintext. Change password in SICAR UI. | | [`sicarv4.products.with_images`](/functions/adapters/sicarv4/fn/sicarv4-products-with_images) | Articulo LEFT JOIN articuloimagen — product rows with linked image ids (if any) | | [`sicarv4.product_images.search`](/functions/adapters/sicarv4/fn/sicarv4-product_images-search) | Search articuloimagen by art\_id and/or img\_id (comma-separated) |