Query Module
The following Query-module objects are listed in the CyberStore 2023 reference.
| Object | Function | Legacy output or transform |
|---|---|---|
ARSQCR | A/R Credit Management Query | |
ARSQRY | A/R Customer Query | |
BOMQRY | BOM Costing Query | |
COMPRF | Profile Settings Query | |
COMQCO | List of Valid SYSPRO Companies | |
COMQFM | Custom Form Query | |
CSHQ45 | Cash Book Bank Balance Query | |
IMPQIK | System Key Information Query | |
INVQAT | Inventory Available to Promise Query | |
INVQRY | Inventory Query | INVQRY.xslt |
INVQSE | Inventory Serial Number Query | INVQSE.xslt |
INVQWR | Inventory Where-Referenced Query | INVQWR.xslt |
RMAQPC | RMA Problem Codes Query | |
RMAQRL | List of RMAs | |
RMAQRY | RMA Query | |
SORQCP | S/O Sales Order Contract Price Query | SORQCP.xslt |
SORQDL | S/O List of Dispatch Notes | SORQDL.xslt |
SORQDN | S/O Dispatch Note Query | SORQDNOUT; SORQDN.xslt |
SORQID | S/O Sales Order Invoice Query | SORQIDOUT; SORQID.xslt |
SORQND | S/O Dispatch Invoice Document Query | SORQNDOUT; SORQND.xslt |
SORQOV | S/O Sales Order Valuation Query | SORQOV.xslt |
SORQPL | Customer Price Lookup Query | SORQPL.xslt |
SORQRY | S/O Sales Order Query | SORQRYOUT; SORQRY.xslt; SORQRY-CFF.xslt |
SORQSO | S/O List of Sales Orders | SORQSO.xslt |
TPMQPP | TPM Pricing Query | TPMQPP.xslt |
TPMQQP | TPM Qualified Promotions Query | TPMQQP.xslt |