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