Available Datasourcefields for Report XML Templates

Purchasing Reports/Inventory Reports


 

Stock In/Out

Data Source Fields

  • imasterid
  • companyid
  • imastersku
  • imasterupc
  • imasterdesc
  • imastercategory
  • imasteruom
  • imasterprice
  • imasterweight
  • imastereconorder
  • imasterleadtime
  • imasterkit
  • imasterimage
  • imasterbarcode
  • perishable
  • tracklot
  • active
  • leakageriskid
  • ccfrequencyid
  • minccfrequencyid
  • clientid
  • finishedgood
  • rawmaterial
  • nonmaterial
  • dropship
  • serialized
  • needsapproval
  • baseprice
  • assembly
  • listid
  • rrp
  • userfield1
  • userfield2
  • userfield3
  • notes
  • userfield4
  • userfield5
  • userfield6
  • orderlimit
  • importlogid
  • manufacturerwebsite
  • createddate
  • filename
  • currentQty
  • reorderlvl

Events

  • totalitems
  • totalchange
  • receiptId
  • purchaseOrderId
  • purchaseOrderNumber
  • customerId
  • date
  • supplierId
  • supplierName
  • receiverId
  • receiverName
  • accepted
  • itemCount
  • invoiceno
  • purchasedprice
  • eventUser
  • transactionType
  • referenceId

Fulfillment Reports


 

Detailed Customer Order Report

Default Field Name

  • customerorderid
  • companyid
  • customerid
  • ordersourceref
  • integrationsource
  • status
  • ordereddate
  • extordernumber
  • ordernumber
  • itemcount
  • ordervalue
  • customertitle
  • customername
  • customersurname
  • customeraccount
  • customercity
  • customercompany
  • pickedcount
  • orderedcount
  • reservedcount
  • unprinted
  • here
  • nonmaterialcount
  • shippingbillingmode
  • clientid
  • completeddate
  • completed
  • cancelled
  • cancelledby
  • cancelleddate
  • cancelledreason
  • projectno
  • orderplacedbyuserid
  • orderplaced
  • userfield1
  • userfield2
  • userfield3
  • mylist1
  • mylist2
  • orderplacedbyname
  • customerfullname
  • shippingaddressid
  • billingaddressid
  • shippingaddress1
  • shippingaddress2
  • shippingaddress3
  • shippingcity
  • shippingstate
  • shippingzip
  • shippingaddressname
  • shippingaddresscompany
  • shippingcountry
  • shippingphone
  • customeremail
  • customeraddress1
  • customeraddress2
  • customeraddress3
  • customerstate
  • customerzip
  • customercountry
  • customerphone
  • billingaddress1
  • billingaddress2
  • billingaddress3
  • billingcity
  • billingstate
  • billingzip
  • billingcountry
  • billingphone
  • billaddressname
  • billingaddressname
  • billingaddresscompany
  • shippedcount
  • dropshipcount
  • lotnumber
  • pickprintdate
  • shipvia
  • discountpercentage
  • note
  • weight
  • packages

 

Items

  • imastersku
  • imasterprice
  • imasterdesc
  • userfield1
  • userfield2
  • userfield3
  • userfield4
  • userfield5
  • userfield6
  • customerorderitemid
  • imasterid
  • orderquantity
  • orderuom
  • quantity
  • partofkit
  • pickeddate
  • completed
  • discountpercentage
  • purchasedprice
  • customerprice
  • customertotalprice
  • linenumber