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

Default Field Name
Element

 

imasterid

 

imastersku

 

imasterupc

 

imasterbarcode

 

imasterdesc

 

perishable

 

tracklot

 

companyname

 

lotnumber

 

pohaltid

 

projectno

 

notes

 

clientname

 

destlocname

These are also available sometimes:

Default Field Name
Element

 

expirydate

 

lotnumber

 

serialno

 

serialfield1

 

serialfield2

 

serialfield3

 

serialfield4

  userfield1
  userfield2
  userfield3
  userfield4
  userfield5
  userfield6
alternate UOM name

uomname

alternate UOM qty of base unit of measure

uomquantity

barcode of the UPC value of the UOM

uombarcode

will display SKU number if no alternate UOM is defined skuoruombarcode

Put Away Report / Material Receipt

Printed after accepting receipt of inventory.

putawayreport.xml

Default Field Name
Datasourcefield

 

palletno

 

barcode

 

ponumber

 

date

 

suppliername

 

supplieraddress1

 

supplieraddress2

 

suppliercity

 

supplierstate

 

supplierzip

 

notes

  clientname

Items

 

 

invitemid

 

deliveredquantity

 

deliveryuom

 

stockquantity

 

datedelivered

 

expirydate

 

imastersku

 

imasterdesc

 

imastercategory

 

imasteruom

 

imasterweight

 

serialized

 

currentlocname

 

currentlocid

 

destlocname

 

destlocid

 

lotnumber

 

imasterid

 

perishable

receipt #

receiptid

 

palletno

 

packageno

 

itemno

 

putawaynotes

 

qrcode

 

imasteridbarcode

 

stockquantitybarcode

 

expirydatebarcode

 

lotnumberbarcode

ordered UOM poluom
ordered UOM qty polqtyuom

ordered qty from PO,

broken down to base UOM

polqty

Inventory

Materials Receipt / Put away report

Printed from actions menu on Put Items Away

Default Field Name
Element

Lot Number

lotnumber
Pallet Number palletno
Expiration Date expirydate

Work Order Allocation

Printed when creating work order assembly.

workorderallocation.xml

Default Field Name Datasourcefield

 

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

  clientname

Items

 

workorderitemid

 

companyid

 

workorderid

 

imasterid

 

buildquantity

 

builduom

 

quantity

 

allocatedquantity

 

pickedquantity

 

quantitytoallocate

 

imastersku

 

imasterdesc

 

imasteruom

 

serialized

 

tracklot

 

perishable

 

lotnumber

 

expirydate

 

locationname

 

sku

 

description