Purchase Order Fields for Message Templates

The following table lists the data fields that can be entered into the body of an Email Message Template to request specific purchase order information from the database. Use the message template field as shown in the table. These message template fields can be used when the email message template type is set to PO or All.

Database Field Message Template Field
PO Template Type
PONumber {{PONumber}}
POStatus {{POStatus}}
Type {{Type}}
ApprovedBy {{ApprovedBy}}
ApprovedByID {{ApprovedByID}}
ApprovedInvoiceDate {{ApprovedInvoiceDate}}
ApprovedInvoiceDiscountAmount {{ApprovedInvoiceDiscountAmount}}
ApprovedInvoiceDiscountDate {{ApprovedInvoiceDiscountDate}}
ApprovedInvoiceDueDate {{ApprovedInvoiceDueDate}}
ApprovedInvoiceNumber {{ApprovedInvoiceNumber}}
DateApproved {{DateApproved}}
DateCompleted {{DateCompleted}}
DateEntered {{DateEntered}}
DateIssued {{DateIssued}}
DatePrinted {{DatePrinted}}
DateRequested {{DateRequested}}
DontShipAfter {{DontShipAfter}}
DontShipBefore {{DontShipBefore}}
EnteredBy {{EnteredBy}}
FOB {{FOB}}
IssuedBy {{IssuedBy}}
Notes {{Notes}}
Printed {{Printed}}
PromisedDate {{PromisedDate}}
ReadyToPrint {{ReadyToPrint}}
RequestDate {{RequestDate}}
RequestedBy {{RequestedBy}}
RequestedByID {{RequestedByID}}
ShipToAddress1 {{ShipToAddress1}}
ShipToAddress2 {{ShipToAddress2}}
ShipToAddress3 {{ShipToAddress3}}
ShipToAddress4 {{ShipToAddress4}}
ShipToAttention {{ShipToAttention}}
ShipToCity {{ShipToCity}}
ShipToCountry {{ShipToCountry}}
ShipToName {{ShipToName}}
ShipToOverride {{ShipToOverride}}
ShipToState {{ShipToState}}
ShipToZip {{ShipToZip}}
ShipVia {{ShipVia}}
SpecialInstructions {{SpecialInstructions}}
StatusChangedBy {{StatusChangedBy}}
StatusDate {{StatusDate}}
SubTotalAmountApproved {{SubTotalAmountApproved}}
VendorID {{VendorID}}
SupplierName {{SupplierName}}
SupplierAddress1 {{SupplierAddress1}}
SupplierAddress2 {{SupplierAddress2}}
SupplierAddress3 {{SupplierAddress3}}
SupplierAddress4 {{SupplierAddress4}}
SupplierCity {{SupplierCity}}
SupplierCountry {{SupplierCountry}}
SupplierOverride {{SupplierOverride}}
SupplierState {{SupplierState}}
SupplierZip {{SupplierZip}}
TaxExempt {{TaxExempt}}
TotalAmount {{TotalAmount}}
TotalAmountApproved {{TotalAmountApproved}}
TotalAmountInvoiced {{TotalAmountInvoiced}}
TotalAmountOutstanding {{TotalAmountOutstanding}}
TotalAmountReceived {{TotalAmountReceived}}
TotalOtherAmount {{TotalOtherAmount}}
Warehouse {{Warehouse}}
Reference {{Reference}}
RelatedDocument {{RelatedDocument}}
VendCustID {{VendCustID}}
Contact {{Contact}}
Phone {{Phone}}
FAX {{FAX}}
Email {{Email}}
SalesOrderNumber {{SalesOrderNumber}}
SupplierAddress {{SupplierAddress}}
ShipToAddress {{ShipToAddress}}
Terms {{Terms}}
VendorType {{VendorType}}
APAccountID {{APAccountID}}
PurchaseAccountID {{PurchaseAccountID}}

Posted in Configuration, Email - Last modified on April 24, 2013Audra DePew
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.