Available Datasourcefields for Order XML Templates

Orders


 

Customer Order

Prints when you create a customer order or re-print from the View Order popup

Data Source Fields

  • clientname
  • customerorderid
  • companyid
  • customerid
  • ordersourceref
  • status
  • ordereddate
  • completeddate
  • completed
  • extordernumber
  • orderplacedbyuserid
  • orderplaced
  • orderplacedbyname
  • ordernumber
  • clientid
  • cancelled
  • cancelledby
  • cancelleddate
  • cancelledreason
  • deleted
  • deletedby
  • projectno
  • userfield1
  • userfield2
  • userfield3
  • mylist1
  • mylist2
  • discountpercentage
  • shippingbillingmode
  • carriercode
  • servicecode
  • txnid
  • shippingaddressid
  • billingaddressid
  • shipvia
  • pickprintdate
  • note
  • preferwhid
  • notifyemail
  • integrationsource
  • deleteddate
  • weight
  • packages
  • customertitle
  • customername
  • customersurname
  • customeremail
  • customeraddresscompany
  • customeraddressname
  • customeraddress1
  • customeraddress2
  • customeraddress3
  • customercity
  • customerstate
  • customerzip
  • custaccount
  • customercitystate
  • customerphone
  • customercountry
  • shiptoaddress
  • customercompanyname
  • billingaddresscompany
  • billingaddressname
  • billingaddress1
  • billingaddress2
  • billingaddress3
  • billingcity
  • billingstate
  • billingzip
  • billingcitystate
  • billingphone
  • billingcountry
  • billtoaddress
  • companyname
  • companyaddress1
  • companyaddress2
  • companyaddress3
  • companycity
  • companystate
  • companyzip
  • citystate
  • companytel
  • companyfax
  • printedby
  • ordertotalprice

Items

  • customerorderitemid
  • companyid
  • customerorderid
  • imasterid
  • orderquantity
  • orderuom
  • quantity
  • pickeddate
  • pickedbyuserid
  • completed
  • discountpercentage
  • partofkit
  • allocatemultiplesof
  • tobuildimasterid
  • purchasedprice
  • customerprice
  • txnlineid
  • pickedcount
  • allocatedcount
  • shippedcount
  • imastersku
  • imasterdesc
  • imasteruom
  • imasterweight
  • imastersalesprice
  • linetotalprice
  • itemuserfield1
  • itemuserfield2
  • itemuserfield3
  • itemuserfield4
  • itemuserfield5
  • itemuserfield6

 

Pick List

Prints from the actions drop-down on the pick page

Data Source Field

  • clientname
  • customerorderid
  • companyid
  • customerid
  • ordersourceref
  • integrationsource
  • status
  • ordereddate
  • extordernumber
  • ordernumber
  • itemcount
  • ordervalue
  • customertitle
  • customername
  • customersurname
  • customeraccount
  • customercity
  • 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
  • shippingcity
  • shippingaddressname
  • billingaddressname
  • shippedcount
  • dropshipcount
  • lotnumber
  • serialized
  • pickprintdate
  • shipvia
  • discountpercentage
  • note
  • weight
  • packages
  • customer
  • orderbarcode
  • customerno
  • shiptoaddress
  • billtoaddress
  • consigneename
  • consigneecompany
  • customerbillingphone
  • customerbillingcountry
  • customershippingphone
  • customershippingcountry
  • total
  • totalorderprice
  • totalfullprice

 

Items

  • customerorderitemid
  • companyid
  • customerorderid
  • imasterid
  • quantity (actual quantity of the base unit)
  • pickeddate
  • pickedbyuserid
  • completed
  • orderuom
  • orderquantity  (applicable if alternate UOM was used)
  • allocatedwarehouseid
  • allocatedwarehousename
  • sku
  • imasterdesc
  • lotnumber
  • expirydate
  • serialized
  • locID
  • locname
  • discountpercentage
  • allocatemultiplesof
  • tobuildimasterid
  • partofkit
  • purchasedprice
  • customerprice
  • reservedcount
  • pickedquantity
  • allocatedquantity
  • quantitytoallocate
  • imasterupc
  • imasteruom
  • notes
  • imastersku
  • imasteruserfield1
  • imasteruserfield2
  • imasteruserfield3
  • imasteruserfield4
  • imasteruserfield5
  • imasteruserfield6
  • orderlimit
  • orderprice
  • imasterweight
  • qrcode
  • imasterimage

    • When using type="IMAGE" you can now also include imageW="##" and imageH="##" to control the width and height of an image respectively.  When not used, it defaults to the cells width attribute.  If you use both, the aspect will forced to match that H/W.  If you use only one, aspect will adjust automatically (as it currently does with just “width”)
  • imasterimagethumb

  • imasterimagetiny


 

Packing Slip

Customer Order

Data Source Field

  • clientname
  • customerorderid
  • companyid
  • customerid
  • ordersourceref
  • status
  • ordereddate
  • completeddate
  • completed
  • extordernumber
  • orderplacedbyuserid
  • orderplaced
  • orderplacedbyname
  • ordernumber
  • clientid
  • cancelled
  • cancelledby
  • cancelleddate
  • cancelledreason
  • deleted
  • deletedby
  • projectno
  • userfield1
  • userfield2
  • userfield3
  • mylist1
  • mylist2
  • discountpercentage
  • shippingbillingmode
  • carriercode
  • servicecode
  • txnid
  • shippingaddressid
  • billingaddressid
  • shipvia
  • pickprintdate
  • note
  • preferwhid
  • notifyemail
  • integrationsource
  • deleteddate
  • weight
  • packages
  • totalcost
  • orderno
  • shippingno
  • customerno
  • customeremail
  • trackingno
  • customertitle
  • customername
  • customersurname
  • shiptoaddress
  • billtoaddress
  • consigneename
  • consigneecompany
  • customercompany
  • customerbillingphone
  • customerbillingcountry
  • customershippingphone
  • customershippingcountry
  • shippinglabel
  • companyaddress
  • totalitems
  • totalitemsshipped
  • packingslip

Items

  • customerorderitemid
  • companyid
  • customerorderid
  • imasterid
  • orderquantity
  • orderuom
  • quantity
  • pickeddate
  • pickedbyuserid
  • completed
  • discountpercentage
  • partofkit
  • allocatemultiplesof
  • tobuildimasterid
  • purchasedprice
  • customerprice
  • txnlineid
  • rrp
  • itemdesc
  • imastersku
  • shippedquantity
  • totalcost