ctDynamicsSL functions' customizable filters


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