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.

Note: Message Template fields use brackets around the field. For Example to use the OrderNumber type .

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