function ctDynamicsSL.orders.getOrders Default name|value paramater/filters:
Stored Procedure: xct_spDSLGetOrders
Param: @ordersParams
ORDNBR|anOrderNumber; --Searches soHeader.ordNbr
CUSTID|aCustID; --Searches soHeader.custID
STATUS|theStatus; --Searches soHeader.status
BEGINDATE|1/1/1900 00:00:00; --Searches daterange on soHeader.crtd_dateTime
ENDDATE|1/1/2095 00:00:00; --Searches daterange on soHeader.crtd_dateTime
Note: all fields except dates accept wild cards: %
all fields are optional
all filters are cumulative
_______________________________
function ctDynamicsSL.customers.getCustomers Default name|value paramater/filters:
Stored Procedure: xct_spDSLGetCustomers
Param: @customersParams
CUSTID|aCustID; --Searches customer.custID
NAME|aName; --Searches customer.custID
BILLADDR1|aStreet; --Searches customer.billAddr1
BILLCITY|aCity; --Searches customer.billCity
BILLSTATE|aState; --Searches customer.billState
BILLZIP|aZip; --Searches customer.billZip
PHONE|aPhone; --Searches customer.phone
STATUS|theStatus; --Searches customer.status
Note: all fields except dates accept wild cards: %
all fields are optional
all filters are cumulative
_______________________________
function ctDynamicsSL.products.getProducts Default name|value paramater/filters:
Stored Procedure: xct_spDSLgetProduct
Param: @productsParams
INVTID|anInvtID; --Searches inventory.invtID
DESCR|aDescr; --Searches inventory.descr
CLASSID|aClassID; --Searches inventory.classID
Note: all fields except dates accept wild cards: %
all fields are optional
all filters are cumulative
_______________________________
function ctDynamicsSL.products.getProduct Default name|value paramater/filters:
Stored Procedure: xct_spDSLgetProduct
Param: @productsParams
CUSTID|aCustID;
QTYORD|aQty;
SITEID|theSiteID;
UOM|theUOM;
Note: all fields for this function are meant for customizations and are not required by default