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 |