Order/Quote 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 sales 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 Order/Quote or All.

Database Field Message Template Field
Order/Quote Template Type
OrderNumber {{OrderNumber}}
Type {{Type}}
BranchID {{BranchID}}
OrderDate {{OrderDate}}
EntryDate {{EntryDate}}
EnteredBy {{EnteredBy}}
OrderStatus {{OrderStatus}}
StatusDate {{StatusDate}}
StatusChangedBy {{StatusChangedBy}}
Completed {{Completed}}
InvoiceFormat {{InvoiceFormat}}
Printed {{Printed}}
ReadyToPrint {{ReadyToPrint}}
PickTicketPrinted {{PickTicketPrinted}}
PickTicketReadyToPrint {{PickTicketReadyToPrint}}
ShippingDocumentPrinted {{ShippingDocumentPrinted}}
ShippingDocumentReadyToPrint {{ShippingDocumentReadyToPrint}}
CreditApprovedBy {{CreditApprovedBy}}
CreditApprovalDate {{CreditApprovalDate}}
ShipVia {{ShipVia}}
FOB {{FOB}}
RequestedShipDate {{RequestedShipDate}}
ShipmentPromisedDate {{ShipmentPromisedDate}}
DontShipBefore {{DontShipBefore}}
DontShipAfter {{DontShipAfter}}
QuotedDaysToShip {{QuotedDaysToShip}}
BackorderCriteria {{BackorderCriteria}}
ManualHold {{ManualHold}}
HoldReleasedBy {{HoldReleasedBy}}
HoldReleasedDate {{HoldReleasedDate}}
LastShipmentDate {{LastShipmentDate}}
SoldToOverride {{SoldToOverride}}
SoldToName {{SoldToName}}
SoldToAddress1 {{SoldToAddress1}}
SoldToAddress2 {{SoldToAddress2}}
SoldToAddress3 {{SoldToAddress3}}
SoldToAddress4 {{SoldToAddress4}}
SoldToCity {{SoldToCity}}
SoldToState {{SoldToState}}
SoldToZip {{SoldToZip}}
SoldToCountry {{SoldToCountry}}
ShipToOverride {{ShipToOverride}}
ShipToAttn {{ShipToAttn}}
ShipToDescription {{ShipToDescription}}
ShipToAddress1 {{ShipToAddress1}}
ShipToAddress2 {{ShipToAddress2}}
ShipToAddress3 {{ShipToAddress3}}
ShipToAddress4 {{ShipToAddress4}}
ShipToCity {{ShipToCity}}
ShipToState {{ShipToState}}
ShipToZip {{ShipToZip}}
ShipToCountry {{ShipToCountry}}
PO {{PO}}
Taxable {{Taxable}}
TaxPct {{TaxPct}}
TaxPercentText {{TaxPercentText}}
SchedSubTotal {{SchedSubTotal}}
SchedDiscountAmount {{SchedDiscountAmount}}
SchedSalesTax {{SchedSalesTax}}
SchedShippingCharge {{SchedShippingCharge}}
SchedTotalAmount {{SchedTotalAmount}}
SubTotal {{SubTotal}}
DiscountType {{DiscountType}}
InvoiceDiscountPct {{InvoiceDiscountPct}}
DiscountAmount {{DiscountAmount}}
SalesTax {{SalesTax}}
TotalAmount {{TotalAmount}}
Reference {{Reference}}
Reference2 {{Reference2}}
TermsDescription {{TermsDescription}}
SchedTermsDiscountAvailable {{SchedTermsDiscountAvailable}}
NextInvoiceNumber {{NextInvoiceNumber}}
ContractID {{ContractID}}
JobNumber {{JobNumber}}
DeliveredTo {{DeliveredTo}}
DeliveredBy {{DeliveredBy}}
DeliveryDate {{DeliveryDate}}
DeliveryMiles {{DeliveryMiles}}
NumberOfPackages {{NumberOfPackages}}
PackageWeight {{PackageWeight}}
ShippingInstructions {{ShippingInstructions}}
SpecialInstructions {{SpecialInstructions}}
Comment {{Comment}}
LostBusinessCode {{LostBusinessCode}}
LostBusinessComment {{LostBusinessComment}}
Note {{Note}}
ContactName {{ContactName}}
ContactPhoneNumber {{ContactPhoneNumber}}
ContactFax {{ContactFax}}
ContactEMailAddress {{ContactEMailAddress}}
PendingShippingCharges {{PendingShippingCharges}}
AmtPaid {{AmtPaid}}
CCExpDate {{CCExpDate}}
CheckNo {{CheckNo}}
DiscAmt {{DiscAmt}}
Carrier {{Carrier}}
CarrierService {{CarrierService}}
NextShipmentNumber {{NextShipmentNumber}}
MarketingCode {{MarketingCode}}
WebOrder {{WebOrder}}
WorkFlowStatusChangedBy {{WorkFlowStatusChangedBy}}
WorkFlowStatusDate {{WorkFlowStatusDate}}
CCNumber {{CCNumber}}
CCName {{CCName}}
CCAddress {{CCAddress}}
CCPostalCode {{CCPostalCode}}
SalespersonID {{SalespersonID}}
SalespersonName {{SalespersonName}}
CustomerID {{CustomerID}}
CompanyName {{CompanyName}}
LocationID {{LocationID}}
TaxCatID {{TaxCatID}}
SoldToAddress {{SoldToAddress}}
ShipToAddress {{ShipToAddress}}
TotalShippingCharges {{TotalShippingCharges}}
TermsCode {{TermsCode}}
WorkFlowStatus {{WorkFlowStatus}}
WorkFlowStatusAbbreviation {{WorkFlowStatusAbbreviation}}
WebOrder Number {{WebOrderNumber}}

 

Posted in Configuration, Email - Last modified on October 15, 2015Lauren Stine
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.