Table of Contents

Public Objects

Codeunits

Name Description
Communication Method Mgt Functions used by Communication Methods.
Disable Settings
Ext. System Public API Contains public functions and events for External Systems.
Ftp Wrapper Ftp Azure Function wrapper.
Integration Type Mgt. Functions and events used by Integration Types.
IQ Archive This is the Integration Queue Step that archives the record.
IQ Azure Storage Mgt. Functions to get Azure File Storage and Azure Blob Storage clients from a Communication Method.
IQ Delete Data This is the Integration Queue Import Step that deletes the remote data (eg. file on file share, ftp etc.).
IQ Execute Linked This is the Integration Queue Step that processes linked records, if any.
IQ Export Data This is an Integration Queue Step for the Transfer Data integration type.
IQ FTP Mgt. Functions to use the Ftp Wrapper with the Integration Queue.
IQ Http Mgt. Functions to use the Web Wrapper with the Integration Queue.
IQ Import Check This is the Integration Queue Import Step that verifies that the data has not been imported already.
IQ Import Data This is the Integration Queue Import Step that imports the data.
IQ Import FA Jnl. The public codeunit for the "Import FA Entries" integration type.
IQ Import Gen. Jnl. The public codeunit for the "Import G/L Entries" integration type.
IQ Invoke Function This is an Integration Queue Step for the Function integration type.
IQ Main Functions to use the Integration Queue functionality.
IQ S/FTP Mgt. Functions to use the S/Ftp Wrapper with the Integration Queue.
IQ Transfer Create New This is an Integration Queue Step for the Transfer Data integration type.
IQCM Not Implemented A "Not Implemented" implementation of interfaces. This is used if the Communication Method does not need all features.
IQCM Sample File Handler This is a sample implementation of a "IQ Communication Method".
IQIT Not Implemented A "Not Implemented" implementation of interfaces. This is used if the Integration Type does not need all features.
JQ Ext. Sys. FullSync This codeunit is used to schedule a "full synchronization" of an External System.
JQ Ext. Sys. RefreshSync This codeunit is used to schedule a "refresh synchronization" of an External System.
JQ Ext. Sys. Sync. This codeunit is used to schedule a synchronization of an External System.
JQ IQ Check OK This codeunit is used to schedule an error check of the Integration Queue.
JQ IQ Cleanup This codeunit is used to schedule a cleanup in the Integration Queue History.
JQ IQ Execute This codeunit is used to schedule a processing of entries in the Integration Queue.
JQ IQ Execute No Err This codeunit is used to schedule a processing of entries in the Integration Queue, not stopping on errors.
JQ IQ Imp. Exec. No Err This codeunit is used to schedule an import into the Integration Queue and then processing the imported entries, not stopping on errors.
JQ IQ Import This codeunit is used to schedule an import into the Integration Queue.
JQ IQ Import and Execute This codeunit is used to schedule an import into the Integration Queue and then a processing of the imported entries.
Mandatory Fields Mgt. Functions to manage mandatory fields.
S/Ftp Wrapper S/Ftp Azure Function wrapper.
Sample Function Handler This is a sample implementation of a "IQ Communication Method".
WS External System API Functions for integrating with External System via Web Services.
WS General Jnl Posting Post G/L Journal Lines via Web Services.
WS Master Data API Functions to create Items and Customers via Web Services.
WS Page Extension Provides functions that can be used together with published Web Service Pages.
WS Sales Document API Functions to handle sales documents via Web Services.

Tables

Name Description
EXT Sync Record A temporary table that contains data about a record that is logged in External System Change Log. Used when an external system gets changed records.
Ext. Sys. Sync Fld Map
Ext. Sys. Sync Fld Trans
Ext. Sys. Sync Hist. Lne
Ext. Sys. Sync Stp (Fld)
Ext. Sys. Sync Stp (Tbl)
Ext. System Field Filter
Ext. System Sync History
External Subsystem
External Subsystem Group
External System
Extra Fields Code
Extra Fields Setup
Integration Category
Integration Queue
Integration Queue Hist
Integration Queue Import
Integration Setup
IQ Communication Method
IQ FA Jnl. Line
IQ Gen. Jnl. Line
IQ Hist. FA Jnl. Line
IQ Hist. Gen. Jnl. Line
IQ Jnl. Import Column
IQ Jnl. Import Setup
IQ Sample Function This is the Setup Table for a sample implementation of a "IQ Communication Method".
IQ System Settings
IQCM Az. St. Snapshot
IQCM Azure Storage
IQCM Client File
IQCM Credential
IQCM Ftp
IQCM Ftp Snapshot
IQCM Http
IQCM Http Hdr. Snapshot
IQCM Http Header
IQCM Http Snapshot
IQCM IQ Export
IQCM IQ Export Snapshot
IQCM OAuth Scope
IQCM S/Ftp
IQCM S/Ftp Snapshot
IQCM Sample File This is the Setup Table for a sample implementation of a "IQ Communication Method".
IQCM Sample File Snapsh. This is the Setup Snapshot Table for a sample implementation of a "IQ Communication Method".
IQCM SharePoint
IQCM SharePoint Snapsh.
IQIT Import SIE Setup
IQIT Transfer Data Setup
IQIT XmlPort Imp. Setup
Mandatory Fields
Sample Function Snapshot This is the Setup Snapshot Table for a sample implementation of a "IQ Communication Method".
tAzureBlob
tAzureBlobContainer
tAzureFileObject
tAzureFileShare
tBusinessProcessTemplate
tExternalSystem
tExtraFields
tExtSystemSyncSetupTable
tFieldUsed
tFieldValue
tGenJnlLine
tIntegrationImport
tIQStepOrder
tWSCustomer
tWSItem
tWSSalesHeader
tWSSalesLine
WS System Reference

Table Extensions

Name Extends
Customer Customer
Customer Templ. Customer Templ.
Item Item
Item Templ. Item Templ.
Picture Entity Picture Entity
Vendor Vendor
Vendor Templ. Vendor Templ.

Pages

Name Source Table Read-only
API Pages Page Metadata Yes
Azure Blob List QWESR tAzureBlob Yes
Azure Container List QWESR tAzureBlobContainer Yes
Azure File List QWESR tAzureFileObject Yes
Azure File Share List QWESR tAzureFileShare Yes
Business Processes List QWESR tBusinessProcessTemplate Yes
Confirm Missing Perm.
Encrypted Storage List QWESR Encrypted Storage
ExFld Tbl Setup Wz Subp. QWESR tExtraFields
ExFld Tbl Stp Wz Subp. 2 QWESR Extra Fields Code
Ext Sys Sync Fld Sort QWESR Ext. Sys. Sync Stp (Fld) Yes
Ext Sys Sync Setup (Fld) Field
Ext. Fld. Setup Wz Subp. AllObjWithCaption Yes
Ext. Fld. Tbl. Stp. Wiz. AllObjWithCaption
Ext. Subsystem Groups QWESR External Subsystem Group
Ext. Sys. Field Filters QWESR Ext. System Field Filter
Ext. Sys. Setup Wizard QWESR tExternalSystem
Ext. Sys. Setup Wz Subp. QWESR tExtSystemSyncSetupTable
Ext. Sys. Sync Chg. Log QWESR Ext. Sys. Sync Chg Log
Ext. Sys. Sync Fld Map QWESR Ext. Sys. Sync Fld Map
Ext. Sys. Sync Fld Trans QWESR Ext. Sys. Sync Fld Trans
Ext. Sys. Sync Hist Card QWESR Ext. System Sync History Yes
Ext. Sys. Sync Hist List QWESR Ext. System Sync History
Ext. Sys. Sync Hist Subp QWESR Ext. Sys. Sync Hist. Lne Yes
Ext. Sys. Sync Hist. Lns QWESR Ext. Sys. Sync Hist. Lne Yes
Ext. Sys. Tbl Setup Wiz. QWESR tExtSystemSyncSetupTable
Ext. Sys. TblWzFilt Subp QWESR Ext. System Field Filter
Ext. Sys. TblWzFld Subp. QWESR Ext. Sys. Sync Stp (Fld)
Ext. System Table List AllObjWithCaption Yes
External Subsystems QWESR External Subsystem
External System Card QWESR External System
External System Subp. QWESR Ext. Sys. Sync Stp (Tbl)
External Systems List QWESR External System Yes
Extra Field Cust. Subp. Customer
Extra Field Item Subp. Item
Extra Field Setup Wizard QWESR Extra Fields Setup
Extra Field Vendor Subp. Vendor
Extra Fields Codes QWESR Extra Fields Code
Extra Fields Setup QWESR Extra Fields Setup
Field List Field Yes
Integration Categories QWESR Integration Category
Integration List QWESR Integration Setup Yes
Integration Queue QWESR Integration Queue
Integration Queue Hist QWESR Integration Queue Hist Yes
Integration Queue Import QWESR Integration Queue Import Yes
Integration Setup QWESR Integration Setup
Integration Setup Card QWESR Integration Setup
Integration Setup List QWESR Integration Setup Yes
IQ Comm. Method List QWESR IQ Communication Method
IQ FA Jnl. Lines QWESR IQ FA Jnl. Line
IQ Gen. Jnl. Lines QWESR IQ Gen. Jnl. Line
IQ Hist. FA Jnl. Lines QWESR IQ Hist. FA Jnl. Line Yes
IQ Hist. Gen. Jnl. Lines QWESR IQ Hist. Gen. Jnl. Line Yes
IQ Jnl. Imp. Cols. Ord. QWESR IQ Jnl. Import Column Yes
IQ Jnl. Import Columns QWESR IQ Jnl. Import Column
IQ Jnl. Import Setup QWESR IQ Jnl. Import Setup
IQ Sample Function Card QWESR IQ Sample Function
IQCM Az. St. Snapsh Card QWESR IQCM Az. St. Snapshot Yes
IQCM Azure Storage Card QWESR IQCM Azure Storage
IQCM Client File Card QWESR IQCM Client File
IQCM Credential QWESR IQCM Credential
IQCM Credentials QWESR IQCM Credential Yes
IQCM File List QWESR tIntegrationImport Yes
IQCM Ftp Card QWESR IQCM Ftp
IQCM Ftp Snapshot Card QWESR IQCM Ftp Snapshot Yes
IQCM Http Card QWESR IQCM Http
IQCM Http Hdr. Snapshot QWESR IQCM Http Hdr. Snapshot Yes
IQCM Http Headers QWESR IQCM Http Header
IQCM Http Snapshot Card QWESR IQCM Http Snapshot Yes
IQCM IQ Export Card QWESR IQCM IQ Export
IQCM IQ Export Snap. Crd QWESR IQCM IQ Export Snapshot Yes
IQCM OAuth Scopes QWESR IQCM OAuth Scope
IQCM S/Ftp Card QWESR IQCM S/Ftp
IQCM S/Ftp Snapshot Card QWESR IQCM S/Ftp Snapshot Yes
IQCM Sam. Fl Snapsh. Crd QWESR IQCM Sample File Snapsh. Yes
IQCM Sample File Card QWESR IQCM Sample File
IQCM SharePoint Card QWESR IQCM SharePoint
IQCM SP Snapsh. Card QWESR IQCM SharePoint Snapsh. Yes
IQCM Tenant Id Prompt
IQIT Import SIE Setup QWESR IQIT Import SIE Setup
IQIT Transfer Data Setup QWESR IQIT Transfer Data Setup
IQIT XmlPort Imp. Setup QWESR IQIT XmlPort Imp. Setup
Mandatory Fields QWESR Mandatory Fields
Name/Quota Prompt
Sample Function Snapshot QWESR Sample Function Snapshot Yes
Spider Role Center
Spider Setup Wizard QWESR tExternalSystem
SSH Private Keys QWESR Encrypted Storage
Web Services SubPage Tenant Web Service Yes
WS Customer Customer
WS Item Item
WS Item Attribute Item Attribute Value Mapping Yes
WS Item Inventory Item Yes
WS Item On Purchase Purchase Line Yes
WS Item On Sales Sales Line Yes
WS Item Reference Item Reference
WS Item UoM Item Unit of Measure
WS Item Variant Item Variant
WS S. Receipt Subpage Return Receipt Line Yes
WS S. Return Receipt Return Receipt Header Yes
WS Sales Order Sales Header Yes
WS Sales Order Subform Sales Line Yes
WS Sales Return Order Sales Header Yes
WS Sales Shipm. Subp. Sales Shipment Line Yes
WS Sales Shipment Sales Shipment Header Yes
WS Sls. Ret. Order Subp. Sales Line Yes

Page Extensions

Name Extends
Customer Card Customer Card
Customer Details FactBox Customer Details FactBox
Customer List Customer List
Customer Templ. Card Customer Templ. Card
Item Card Item Card
Item Invoicing FactBox Item Invoicing FactBox
Item List Item List
Item Repl. FactBox Item Replenishment FactBox
Item Templ. Card Item Templ. Card
Vendor Card Vendor Card
Vendor Details FactBox Vendor Details FactBox
Vendor List Vendor List
Vendor Templ. Card Vendor Templ. Card
WS Test Menu QWETB WS Test Menu

Interfaces

Name Description
EXT Block Changes This interface should be implemented if the External System Type supports blocking of some changes.
EXT Full Sync This interface should be implemented if the External System Type supports full synchronization.
EXT Polling This interface should be implemented if the External System Type supports polling synchronization.
EXT Pre Test This interface should be implemented if the External System Type supports pre-tests.
EXT Sync Batch This interface should be implemented if the External System Type supports synchronization of a batch of records.
EXT Sync Single This interface should be implemented if the External System Type supports synchronization record by record.
EXT Synchronization This interface should be implemented if the External System Type supports push synchronization.
EXT Type This interface must be implemented by all implementations of External System Types.
IQ Integration Type This interface must be implemented for all Integration Types for the Integration Queue.
IQCM This interface must be implemented for all Communication Methods for the Integration Queue.
IQCM Export This interface must be implemented for all Communication Methods that supports data export.
IQCM Function This interface must be implemented for all Communication Methods that supports functions calls.
IQCM Import This interface must be implemented for all Communication Methods that supports data import.

Enums

Name Description
EXT Type
IQ Integration Type Specifies the types of all the integrations that are implemented in the Integration Queue.
IQ Step Specifies the different steps that an integration is made of.
IQCM Specifies the different kinds of Communication Methods used by the Integration Queue.

Permission Sets

Name Description
QWESR Execute
QWESR EXTFIELDS-ADM Permissions to configure the Extra Fields in Spider.
QWESR EXTFIELDS-ALL Permissions automatically assigned to all users to allow the use of the Extra Fields set up in Spider.
QWESR EXTSYS-ADMIN Permissions to configure an External System in Spider.
QWESR EXTSYS-ALL Permissions automatically assigned to all users to allow an External System in Spider to log changes.
QWESR EXTSYS-SYNC Permissions to synchronize an External System in Spider.
QWESR EXTSYS-WS Permissions to retrieve records from the External Systems Changelog in Spider.
QWESR IQ-ADMIN Permissions to configure and use the Integration Queue in Spider.
QWESR Mand. Fld. Adm

This documentation is generated from Spider v27.2