CyberStore Ecommerce 2023 Documentation
Supported SYSPRO e.net Business Objects
CyberStore E-Commerce requires access to the following e.net Business Objects to provide full SYSPRO integration:
| Object | Function | XML Out | XSLT File |
|---|---|---|---|
| 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 | ORQDN.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.ascx | SORQSO.xslt | |
| TPMQPP | TPM Pricing Query | TPMQPP.xslt | |
| TPMQQP | TPM Qualified Promotions Query | TPMQQP.xslt |
| Object | Function | XSLT File |
|---|---|---|
| SORRSH | S/O Build Sales Order Header | |
| SORRSL | S/O Build Sales Order Line | SORRSL.xslt |
| Object | Function | XSLT File |
|---|---|---|
| ARSSCS | A/R Customer Maintenance | |
| COMSFM | COM Custom Form Setup (SYSPRO 6.x) | COMSFM.xslt |
| COMTFM | Custom Form Setup (SYSPRO 7.0+) | COMTFM.xslt |
| INVSPR | Inventory Price Maintenance | INVSPR.xslt |
| INVSSR | Serial Number Maintenance | |
| INVSST | Inventory Stock Code Maintenance | INVSST.xslt |
| Object | Function | XSLT File |
|---|---|---|
| APSTIN | Accounts Payable Invoice Posting | APSTIN.xslt, APSTIN-Params.xslt |
| ARSTIN | Accounts Receivable Invoice Posting | |
| ARSTPY | Post AR Payments, Adjustments and Miscellaneous Receipts | ARSTPY.xslt, ARSTPY-Params.xslt |
| ICVTCM | Credit Card Maintenance | |
| INVTSR | Serial Tracking Transaction Posting | |
| QOTTQI | Quotation Entry and Maintenance | |
| RMATRH | Create/Update RMA Header | |
| RMATRL | Create/Update RMA Detail | |
| SORTBO | S/O Backorder Release | SORTBO.xslt, SORTBO-Params.xslt |
| SORTOI | S/O Sales Order Import | SORTOI.xslt, SORTOI-Params.xslt |
| SORTOS | S/O Change Order Status | SORTOS.xslt, SORTOS-Params.xslt |
| WIPTJB | Job Creation and Maintenance |
| Object | Function | XSLT File |
|---|---|---|
| COMBRW | Generic Browse | |
| COMFCH | Generic Fetch | |
| COMFND | Generic Find | |
| COMKEY | Get Previous/Next key | |
| LOGON | Log On | |
| LOGOFF | Log Off |