select objectid mfrid from tbl_import_aliases where ownerid = and ownertype = and objecttype = 'mfrid' and alias =
Order Detail
Manufacturer #qcf_orderDetail.manufacturername#
Order Date #dateformat(qcf_orderDetail.OrderDate,"mm/dd/yyyy")# Ship Date #dateformat(qcf_orderDetail.reportShipDate,"mm/dd/yyyy")#
Order Number #qcf_orderDetail.OrderNumber#
Invoice Number #qcf_orderDetail.InvoiceNumber#
PO Number #qcf_orderDetail.DistributorPoNumber#
Order Amount #numberformat(qcf_orderDetail.TotalOrderAmount,"9,999.99")#
Line Items
#itemcode# - #description#
Qty #numberformat(Quantity,"9,999")#
Amount #numberformat(LineNetAmount,"9,999.99")#
Net Wt #numberformat(NetWeight,"9,999.99")#
Dst Code #DistributorCode#