Struct |
| inventorybalancerequest | Struct | | userid | | | taskname | | | inventoryid | | | inventorybalrequestid | | | process | | | createdate | | | inventory_provider_xrefid | |
|
| ziplatlong | Struct | | zip | | | long | | | country | | | abbrev | | | pmsa | | | fips | | | tz | | | city | | | msa | | | county | | | type | | | dst | | | lat | | | ma | | | st | | | ac | | | pref | |
|
| calendar | Struct | | projectid | | | calendaryear | | | calendarmonth | | | calendarid | | | calendarday | | | eventname | | | content | |
|
| davidofforderaddress | Struct | | stprid | | | stateprovince | | | phonework | | | postalcode | | | phoneother | | | phonehome | | | namelast | | | orderheaderid | | | salutation | | | phonepager | | | phonecell | | | orderaddressid | | | namemiddle | | | countryid | | | email | | | country | | | city | | | address3 | | | address2 | | | address1 | | | fax | | | namefirst | | | createdate | | | organization | |
|
| _returntype | Struct | | sortorder | | | returntypeid | | | returntypecode | | | createdate | | | returntypename | |
|
| davidoffdelaconchaordershippinginfo | Struct | | delayshipuntil | | | ship_orderaddressid | | | insurancecharge | | | orderheaderid | | | createdate | | | shippinghandling | | | providerid | | | shipperattentionneeded | | | shipmethodid | | | dateneeded | | | declaredvalue | | | ordershippinginfoid | | | shipnotes | | | discount | | | lastdropdate | |
|
| messagetypes_xmlsearch_xref | Struct | | xmltag | | | messagetypeid | | | statusid | | | searchtagid | | | messagetypename | | | createdate | |
|
| catalog_project_xref | Struct | | projectid | | | enddate | | | catalog_project_xrefid | | | startdate | | | createdate | | | catalogid | |
|
| salesterritories | Struct | | territoryname | | | territorycode | | | zipend | | | distributionchannelid | | | zipstart | | | salesterritoryid | | | effectivedate | | | createdate | | | statusid | | | sortorder | | | defaultterritory | |
|
| survey_answers | Struct | | dynamicfield_answer | | | survey_answerid | | | statusid | | | dynamicfieldlayoutid | | | surveyid | | | createdate | | | survey_ruleid | | | memberid | |
|
| davidoffdelaconchapackage | Struct | | packagecontentid | | | quantity | | | ordershipmentid | | | trackingid | | | sku | |
|
| davidoffmadisontax | Struct | | postalcode | | | updatestamp | | | rate | | | state | | | createdate | |
|
| _dynamicfield | Struct | | sortorder | | | fieldvalue | | | fieldname | | | dynamicfieldid | | | dynamicrecordid | |
|
| providers | Struct | | statusid | | | backupproviderid | | | stprid | | | stateprovince | | | phonewarehouse2 | | | dailycutoff | | | phonewarehouse1 | | | maxordersreleasedinbatch | | | merchantdefaultprovider | | | maxordersreleasedbyday | | | projectdefaultprovider | | | dynamicrecordid | | | postalcode | | | warehouseintegrationsoftwareid | | | electronicintegration | | | enddate | | | countryid | | | email | | | timezone | | | warehousemanagementsoftware | | | country | | | providerid | | | city | | | contact | | | address3 | | | address2 | | | address1 | | | providername | | | fax | | | startdate | | | providercode | | | createdate | |
|
| salesrelationships_salesterritories_xref | Struct | | salesterritoryid | | | salesrelationshipid | | | createdate | | | salesrelationships_salesterritories_xrefid | |
|
| _orderpriority | Struct | | sortorder | | | priorityname | | | priorityid | | | prioritycode | | | createdate | |
|
| jaggedpeakorderauditreference | Struct | | columnvalue | | | orderauditid | | | columnname | |
|
| accesstypes_merchantsubmodules_xref | Struct | | accesstypeid | | | accesstypes_merchantsubmodule_xrefid | | | createdate | | | merchantsubmoduleid | |
|
| merchantsubmodules | Struct | | enddate | | | startdate | | | edgesubmoduleid | | | merchantid | | | createdate | | | merchantsubmoduleid | |
|
| workordersource | Struct | | sortorder | | | workordersourceid | | | workordersourcename | | | workordersourcecode | | | createdate | |
|
| jaggedpeakordershipments | Struct | | orderlinedetailid | | | releasedfrombackorder | | | quantity | | | ordershipmentid | | | createdate | | | shipmentgroupid | | | providerid | | | orderstatusid | |
|
| help6i | Struct | | summary | | | topichelplink | | | helpid | | | statusid | | | topicname | | | topicfuse | | | createdate | |
|
| _paymentstatus | Struct | | sortorder | | | paymentstatusid | | | paymentstatusname | | | paymentstatusdescription | | | paymentstatuscode | | | createdate | | | active | |
|
| shipmentcostrule | Struct | | sortorder | | | shipmentcostrulename | | | shipmentcostruleid | | | shipmentcostrulecode | | | createdate | |
|
| davidofforderauditreference | Struct | | columnvalue | | | orderauditid | | | columnname | |
|
| jaggedpeakorder_paymentexception_xref | Struct | | order_paymentexception_xrefid | | | dateapproved | | | orderheaderid | | | orderpaymentid | | | createdate | | | approvedbyuserid | | | exceptionapproved | | | paymentamount | | | paymentcaptured | | | paymentexceptionid | |
|
| skutype | Struct | | skutypename | | | sortorder | | | skutypecode | | | skutypeid | | | createdate | | | kittypeid | |
|
| davidoffreturnorder_order_xref | Struct | | ultimateorderheaderid | | | returnorderheaderid | | | orderheaderid | | | return_order_xrefid | | | createdate | |
|
| membertype_shipmethods_xref | Struct | | membertypeshipmethodxrefid | | | shipmethodid | | | membertypeid | | | createdate | |
|
| itemtype | Struct | | projectid | | | sortorder | | | itemtypeid | | | itemtypename | | | statusid | | | createdate | |
|
| files | Struct | | filename | | | fileid | | | width | | | originalfilename | | | projectid | | | createdate | | | fileclassid | | | filetypeid | | | title | | | description | | | height | | | filesize | |
|
| accesstypes_merchantmodules_xref | Struct | | accesstypeid | | | merchantmoduleid | | | createdate | | | accesstypes_merchantmodule_xrefid | |
|
| edgesubmodules | Struct | | edgesubmodulename | | | circuit | | | edgesubmoduleid | | | edgeaction | | | statusid | | | createdate | | | edgemoduleid | |
|
| group_members_xref | Struct | | budgetgroup | | | recordid | | | groupid | | | createdate | | | memberid | |
|
| dynamicfieldinputtypes | Struct | | inputtypename | | | inputtypecode | | | dynamicfieldinputtypeid | |
|
| members | Struct | | storepaymentinfo | | | namefirst | | | age | | | totalsales | | | budgetfrequency | | | membertypeid | | | memberid | | | prefshipmethod | | | dynamicrecordid | | | dateofbirth | | | income | | | taxnumber | | | startdate | | | promotionid | | | budgetrestore | | | salutation | | | budgetbalance | | | salesrelationshipid | | | priceschemeid | | | createdate | | | membernumber | | | lastupdated | | | email | | | marketingpermissionint | | | enddate | | | occupation | | | namemiddle | | | password | | | username | | | organization | | | externmemberxref | | | affiliateid | | | marketingpermissionext | | | totaltransaction | | | budgetlastupdated | | | prefcommunication | | | namelast | | | totalitems | | | projectid | | | adminuserid | | | gender | | | statusid | |
|
| projects_locales_xref | Struct | | projectid | | | localeid | | | createdate | |
|
| davidofforderpayment | Struct | | receiveremail | | | amount | | | bankaccountnumber | | | transactiontypeid | | | costcenter | | | orderpaymentid | | | paymentstatusid | | | creditcardname | | | addressvalidationcode | | | purchaseordernumber | | | transactionfee | | | bankroutingnumber | | | purchaseorderdate | | | taxnumber | | | paymentdate | | | primaryfororder | | | cardcoderesponsecode | | | settleamount | | | createdate | | | payerstatus | | | paymenttype | | | bankabanumber | | | authorizerid | | | orderheaderid | | | responsesubcode | | | verifysign | | | cardcode | | | bankaccounttype | | | responsereasoncode | | | approvalcode | | | creditcardexp | | | pplsubscriberid | | | pending_reason | | | authtrnno | | | bankname | | | exchangerate | | | purchaseorderexp | | | bankaccountname | | | checknumber | | | notes | | | responsecode | | | creditcardnumber | | | thirdpartyacctnumber | | | creditcardtype | | | settlecurrencycode | | | currencycode | | | responsereasontext | |
|
| catalogsubstitutions_xref | Struct | | projectid | | | enddate | | | sortorder | | | startdate | | | substitute_catalogid | | | createdate | | | catalogid | |
|
| customadmin | Struct | | circuit | | | mainnav | | | projectid | | | createdate | | | subnav | | | sortorder | | | merchantid | | | customadminid | | | fuseaction | |
|
| edgefunctions | Struct | | edgefunctionname | | | circuit | | | edgesubmoduleid | | | edgeaction | | | edgefunctionid | | | statusid | | | createdate | |
|
| faq | Struct | | question | | | projectid | | | createdate | | | faqid | | | orderby | | | faqgroupid | | | modifydate | | | answer | | | isdisplayed | |
|
| _orderstatus | Struct | | orderstatuscode | | | sortorder | | | orderstatusname | | | orderstatusdescription | | | createdate | | | active | | | orderstatusid | |
|
| addresses | Struct | | statusid | | | stprid | | | stateprovince | | | phonework | | | postalcode | | | phoneother | | | phonehome | | | namelast | | | addressobjtypeid | | | salutation | | | phonepager | | | phonecell | | | namemiddle | | | countryid | | | email | | | country | | | addressname | | | city | | | address3 | | | address2 | | | addressid | | | address1 | | | primaryfortype | | | fax | | | lastupdated | | | namefirst | | | memberid | | | addresstypeid | | | createdate | | | organization | |
|
| davidoffdelaconchatracking | Struct | | numberofboxes | | | contents | | | ship_orderaddressid | | | expdeliverytime | | | expdeliverydate | | | carrierservice | | | shipdate | | | shipcost | | | orderheaderid | | | carrier | | | billableweight | | | trackingid | | | boxnumber | | | actualcost | | | cartonid | | | trackingnumber | |
|
| davidoffmadisonorderheader | Struct | | bill_orderaddressid | | | billingcodeid | | | ordertypeid | | | custodian_userid | | | dynamicrecordid | | | workordersourceid | | | sourceid | | | edge_userid | | | promotionid | | | budgetcenterid | | | groupid | | | orderheaderid | | | comments | | | clientreference | | | workordertypeid | | | projectid | | | marketingsourceid | | | orderedby_memberid | | | priorityid | | | shipcomplete | | | releasedate | | | ordernotes | | | email | | | orderstatusid | | | workorderreference | | | providerid | | | completebydate | | | distributionid | | | ordersourceid | | | affiliateid | | | memberid | | | createdate | | | salesterritoryid | |
|
| kitheader | Struct | | kitdescription | | | revisionorder | | | kitname | | | kittypeid | | | shipcomplete | | | printdetails | | | completed | | | createdate | | | providernotes | | | kitnotes | | | inventoryid | | | shipmessage | | | kitheaderid | |
|
| memberorigins | Struct | | sortorder | | | memberorigincode | | | memberoriginid | | | statusid | | | createdate | | | memberoriginname | |
|
| davidoffmadisonordershippinginfo | Struct | | delayshipuntil | | | ship_orderaddressid | | | insurancecharge | | | orderheaderid | | | createdate | | | shippinghandling | | | providerid | | | shipperattentionneeded | | | shipmethodid | | | dateneeded | | | declaredvalue | | | ordershippinginfoid | | | shipnotes | | | discount | | | lastdropdate | |
|
| jaggedpeakorderlinedetail | Struct | | btoinventoryid | | | tax | | | orderstatusid | | | orderlineid | | | ship_orderaddressid | | | quantity | | | orderlinedetailid | | | gift | | | createdate | | | dutytax | | | releasedate | | | kitlineid | | | inventoryid | | | ordershippinginfoid | | | giftcharge | |
|
| davidofforderline | Struct | | autoinclude_allowbackorder | | | catalogname | | | orderlineid | | | createstamp | | | inventoryid | | | skutypename | | | dynamicrecordid | | | unitprice | | | budgetitem | | | chargeshipping | | | inventory_dynamicrecordid | | | bundlequantity | | | catalogitem | | | returntypeid | | | reasoncodeid | | | quantity | | | orderstatusid | | | unitweight | | | categoryid | | | itemtypename | | | orderheaderid | | | bundle_releasedays | | | bundleheader_catalogid | | | sku | | | servicecharge | | | initialprice | | | bundle_shipmethodid | | | taxable | | | catalog_dynamicrecordid | | | orderchargeruleid | | | autoinclude | | | catalogid | | | autoinclude_shipsetid | | | unitcost | | | dispositioncodeid | | | bundle_shipatonce | |
|
| davidoffdelaconchaorderheader | Struct | | bill_orderaddressid | | | billingcodeid | | | ordertypeid | | | custodian_userid | | | dynamicrecordid | | | workordersourceid | | | sourceid | | | edge_userid | | | promotionid | | | budgetcenterid | | | groupid | | | orderheaderid | | | comments | | | clientreference | | | workordertypeid | | | projectid | | | marketingsourceid | | | orderedby_memberid | | | priorityid | | | shipcomplete | | | releasedate | | | ordernotes | | | email | | | orderstatusid | | | workorderreference | | | providerid | | | completebydate | | | distributionid | | | ordersourceid | | | affiliateid | | | memberid | | | createdate | | | salesterritoryid | |
|
| budgetcenter | Struct | | budgetcenteramount | | | datecreated | | | enddate | | | dynamicrecordid | | | projectid | | | statusid | | | budgetcenterused | | | startdate | | | bcexceptiontypeid | | | budgetcentername | | | budgetcentercode | | | budgetcenterid | | | budgetcenterdescription | |
|
| communications | Struct | | sender | | | notifyname | | | communicationcode | | | subject | | | recipient | | | defaultid | | | message | | | html | | | projectid | | | notify | | | enddate | | | usemembertypes | | | cc | | | highpriority | | | includedetails | | | replyto | | | bcc | | | ordersourceid | | | startdate | | | communicationsid | | | createdate | | | communicationeventid | |
|
| status | Struct | | statusname | | | description | | | statusid | | | statuscode | | | createstamp | |
|
| davidoffordershippinginfo | Struct | | delayshipuntil | | | ship_orderaddressid | | | insurancecharge | | | orderheaderid | | | createdate | | | shippinghandling | | | providerid | | | shipperattentionneeded | | | shipmethodid | | | dateneeded | | | declaredvalue | | | ordershippinginfoid | | | shipnotes | | | discount | | | lastdropdate | |
|
| services | Struct | | enddate | | | sortorder | | | startdate | | | serviceid | | | statusid | | | servicename | |
|
| disassembleaction | Struct | | sortorder | | | disassembleactionid | | | disassembleactionname | | | disassembleactioncode | | | createdate | |
|
| grouptypes | Struct | | projectid | | | sortorder | | | internal | | | grouptypename | | | statusid | | | grouptypeid | | | createdate | |
|
| purchaseorderline | Struct | | orderquantity | | | lastupdateduser | | | linecomments | | | purchaseorderlinenumber | | | purchaseorderlineid | | | revision | | | purchaseorderheaderid | | | skudescription | | | inventoryid | | | supplierstatus | | | uomid | | | price | | | linestatus | | | buyer | | | paymentterms | | | suppliercomments | | | dynamicfieldid | | | createdate | | | lastupdateddate | |
|
| survey_rule_value | Struct | | survey_rule_valueid | | | rulevalue | | | createdate | | | survey_ruleid | |
|
| sellingrulesline | Struct | | sellingruleslineid | | | rulevalue | | | tablename | | | columnname | | | sellingrulesheaderid | |
|
| pricechangetypes | Struct | | pricechangename | | | pricechangecode | | | pricechangetypeid | |
|
| shipstation_receiving | Struct | | notes | | | batchnumber | | | asnreceiptid | | | receivingid | | | createdate | | | purchaseorder | |
|
| asnline | Struct | | supplierid | | | asnheaderid | | | asnlineid | | | expectedarrivaldate | | | createdate | | | lastmodifieduserid | | | lastmodifieddate | | | inventoryid | | | qtyexpected | |
|
| asnheader | Struct | | asnstatusid | | | dynamicrecordid | | | asnsourceid | | | asnheaderid | | | orderheaderid | | | createdate | | | lastmodifieduserid | | | lastmodifieddate | | | providerid | | | referencenumber | | | createuserid | |
|
| groups | Struct | | budget | | | enddate | | | adminuserid | | | dynamicrecordid | | | groupid | | | projectid | | | statusid | | | grouptypeid | | | createdate | | | groupname | | | groupcode | | | promotionid | | | startdate | |
|
| appsettingvalue | Struct | | projectid | | | appsettingvalue | | | appsettingid | | | merchantid | | | appsettingvalueid | |
|
| asnreceipttype | Struct | | asnreceipttypeid | | | description | | | typecode | | | createdate | |
|
| newsfeed | Struct | | newsfeedlink | | | newsfeeddesc | | | newsfeedid | | | newsfeedtitle | | | createdate | |
|
| catalogautoinclude_xref | Struct | | projectid | | | createdate | | | catalogid | | | catalogautoinclude_xrefid | | | autoincludeheaderid | |
|
| survey_rule | Struct | | tablemain | | | tablename | | | columnname | | | columnnameid | | | surveyid | | | createdate | | | survey_ruleid | | | surveyrulename | |
|
| distributionchannels | Struct | | projectid | | | sortorder | | | distributionchanneldescription | | | distributionchannelcode | | | distributionchannelid | | | statusid | | | createdate | |
|
| jaggedpeakdistributionfiles | Struct | | transferreddate | | | serverfile | | | distributionid | | | transferredtolist | | | clientfile | |
|
| audit | Struct | | processname | | | databasename | | | userid | | | projectid | | | tablename | | | actiontaken | | | memberid | | | tablerefid | | | datestamp | | | merchantid | | | auditid | | | taskname | |
|
| davidofftracking | Struct | | numberofboxes | | | contents | | | ship_orderaddressid | | | expdeliverytime | | | expdeliverydate | | | carrierservice | | | shipdate | | | shipcost | | | orderheaderid | | | carrier | | | billableweight | | | trackingid | | | boxnumber | | | actualcost | | | cartonid | | | trackingnumber | |
|
| davidoffmadisonordershipments | Struct | | orderlinedetailid | | | releasedfrombackorder | | | quantity | | | ordershipmentid | | | createdate | | | shipmentgroupid | | | providerid | | | orderstatusid | |
|
| davidofforderaudit | Struct | | orderactionid | | | notes | | | orderheaderid | | | orderauditid | | | createdate | |
|
| addressobjtype | Struct | | sortorder | |
|