Available Data Source Fields for Receiving and Inventory XML Templates

Receiving


 

Item Label

Printed when you select print from the page where you receive items

Data Source Fields

  • imasterid
  • imastersku
  • imasterupc
  • imasterbarcode
  • imasterdesc
  • perishable
  • tracklot
  • companyname
  • lotnumber
  • pohaltid
  • projectno
  • notes

 

Put Away Report / Material Receipt

Printed after accepting receipt of inventory.

Data Source Field

  • palletno
  • barcode
  • ponumber
  • date
  • suppliername
  • supplieraddress1
  • supplieraddress2
  • suppliercity
  • supplierstate
  • supplierzip
  • notes

Items

  • invitemid
  • deliveredquantity
  • deliveryuom
  • stockquantity
  • datedelivered
  • expirydate
  • imastersku
  • imasterdesc
  • imastercategory
  • imasteruom
  • imasterweight
  • serialized
  • currentlocname
  • currentlocid
  • destlocname
  • destlocid
  • lotnumber
  • imasterid
  • perishable
  • receiptid
  • palletno
  • packageno
  • itemno
  • putawaynotes
  • qrcode
  • imasteridbarcode
  • stockquantitybarcode
  • expirydatebarcode
  • lotnumberbarcode

 

Inventory


 

Work Order Allocation

Printed when creating work order assembly

Data Source Field

  • workorderid
  • companyid
  • whid
  • clientid
  • imasterid
  • ordernumber
  • createddate
  • createdbyuserid
  • claimerid
  • completed
  • completedby
  • completeddate
  • deleted
  • deletedby
  • deleteddate
  • buildquantity
  • builduom
  • quantity
  • imastersku
  • imasterdesc
  • createdbyname
  • claimer
  • deletedbyname
  • sku
  • description
  • orderbarcode
  • total

Items

  • workorderitemid
  • companyid
  • workorderid
  • imasterid
  • buildquantity
  • builduom
  • quantity
  • allocatedquantity
  • pickedquantity
  • quantitytoallocate
  • imastersku
  • imasterdesc
  • imasteruom
  • serialized
  • tracklot
  • perishable
  • lotnumber
  • expirydate
  • locationname
  • sku
  • description