---
title: What are the Acctivate Invoice Fields for Email Templates?
description: The following table lists the data fields that can be entered into the body of an Email Message Template to request specific customer Invoice information from the database. Use the message template fi
---

[Skip to content](https://hub.acctivate.com/articles/email-template/invoice#main-content)

[Go to Customer Portal](https://hub.acctivate.com/tickets?hsLang=en)

![Acctivate - A CAI Solution](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg)

- [Knowledge Base](https://hub.acctivate.com/articles)

Open main navigation

Close main navigation

- [Knowledge Base](https://hub.acctivate.com/articles)
- [Go to Customer Portal](https://hub.acctivate.com/tickets)
- [Support Resources / Create Ticket](https://acctivate.com/support)

[Support Resources / Create Ticket](https://acctivate.com/support)

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://hub.acctivate.com/articles?hsLang=en)
2. [Customers](https://hub.acctivate.com/articles/customers?hsLang=en)
3. [Broadcast Email](https://hub.acctivate.com/articles/customers?hsLang=en#broadcast-email)

April 14, 2025

# What are the Acctivate Invoice Fields for Email Templates?

### Acctivate Invoice Fields for Email Templates

The following table lists the data fields that can be entered into the body of an [**Email Message Template**](https://hub.acctivate.com/articles/create-and-use-email-templates?hsLang=en) to request specific customer **Invoice** 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 **Invoice or All.**

When manually entering the field name while creating a template, add double { to the beginning of the value and double } to the end. For example, AmtPaid would be typed as ![](https://hub.acctivate.com/hubfs/image-611.png). We've added the fields which do not match the Database Field 100% in the Message Template Field cells below. All others match the Database Field without the spaces.

| Database Field | Message Template Field |
| --- | --- |
| Amt Paid | AmtPaid |
| AR Account ID | ARAccountID |
| Backorder Criteria | BackorderCriteria |
| Balance | Balance |
| Bank Id | BankId |
| Bill To Address | BillToAddress |
| Bill To Address 1 | BillToAddress1 |
| Bill To Address 2 | BillToAddress2 |
| Bill To Address 3 | BillToAddress3 |
| Bill To Address 4 | BillToAddress4 |
| Bill To City | BillToCity |
| Bill To Country | BillToCountry |
| Bill To Name | BillToName |
| Bill To State | BillToState |
| Bill To Zip | BillToZip |
| Branch ID | BranchID |
| Carrier | Carrier |
| Carrier Service | CarrierService |
| CC Authorization Code | CCAuthorizationCode |
| CCAVS Street | CCAVSStreet |
| CCAVS Zip | CCAVSZip |
| CC Exp Date | CCExpDate |
| CC Merchant Account Number | CCMerchAcctNumber |
| CC Payment Grouping Code | CCPaymentGroupingCode |
| CC Recon Batch ID | CCReconBatchID |
| CC Status Code | CCStatusCode |
| CC Status Message | CCStatusMessage |
| CC Trans ID | CCTransID |
| CC Txn Auth Stamp | CCTxnAuthStamp |
| CC Txn Auth Time | CCTxnAuthTime |
| Check No | CheckNo |
| Class | Class |
| Collection Days | CollectionDays |
| Comment | Comment |
| Company Address 1 | CompanyAddress1 |
| Company Address 2 | CompanyAddress2 |
| Company Address 3 | CompanyAddress3 |
| Company Address 4 | CompanyAddress4 |
| Company City | CompanyCity |
| Company Country | CompanyCountry |
| Company Email | CompanyEmail |
| Company Fax | CompanyFax |
| Company Name | CompanyName |
| Company Phone | CompanyPhone |
| Company State | CompanyState |
| Company Tax ID | CompanyTaxID |
| Company Web Address | CompanyWebAddress |
| Company ZIP | CompanyZIP |
| Completed | Completed |
| Contact Email Address | ContactEMailAddress |
| Contact Fax | ContactFAX |
| Contact Name | ContactName |
| Contact Phone Number | ContactPhoneNumber |
| Contract Date | ContractDate |
| Contract ID | ContractID |
| Created By | CreatedBy |
| Created Date | CreatedDate |
| Credit Approval Date | CreditApprovalDate |
| Credit Approved By | CreditApprovedBy |
| Currency Code | CurrencyCode |
| Currency Name | CurrencyName |
| Customer ID | CustomerID |
| Customer Tax ID | CustomerTaxID |
| Date Completed | DateCompleted |
| Date Posted | DatePosted |
| Date Printed | DatePrinted |
| Delivered By | DeliveredBy |
| Delivered To | DeliveredTo |
| Delivery Date | DeliveryDate |
| Delivery Miles | DeliveryMiles |
| Discount Amount | DiscountAmount |
| Discount Available | DiscountAvailable |
| Discount Date | DiscountDate |
| Discount Type | DiscountType |
| Do Not Sync | DoNotSync |
| Due Date | DueDate |
| Entered By | EnteredBy |
| Entry Date | EntryDate |
| Exchange Rate | ExchangeRate |
| Export Date | ExportDate |
| Exported | Exported |
| FOB | FOB |
| Foreign Amount Paid | ForeignAmtPaid |
| Foreign Balance | ForeignBalance |
| Foreign Discount Amount | ForeignDiscountAmount |
| Foreign Discount Available | ForeignDiscountAvailable |
| Foreign Payment Discount | ForeignPaymentDiscount |
| Foreign Sales Tax | ForeignSalesTax |
| Foreign Shipping Charge | ForeignShippingCharge |
| Foreign Sub Total | ForeignSubTotal |
| Foreign Total Amount | ForeignTotalAmount |
| Foreign Total Shipping Charges | ForeignTotalShippingCharges |
| From QB | FromQB |
| Freight Tax Pct | FrtTaxPct |
| Hold Released By | HoldReleasedBy |
| Hold Released Date | HoldReleasedDate |
| In Dispute | InDispute |
| Invoice Date | InvoiceDate |
| Invoice Detail Report ID | InvoiceDetailReportID |
| Invoice Discount Account ID | InvoiceDiscountAccountID |
| Invoice Discount Percent | InvoiceDiscountPct |
| Invoice Format | InvoiceFormat |
| Invoice Link (QBO Only) | InvoiceLink |
| Invoice Number | InvoiceNumber |
| Invoice Number Sort | InvoiceNumberSort |
| Invoice Report ID | InvoiceReportID |
| Invoice Style | InvoiceStyle |
| Invoice Text | InvoiceText |
| Job ID | JobID |
| Job Number | JobNumber |
| Last Payment Date | LastPaymentDate |
| Last Shipmen tDate | LastShipmentDate |
| Location ID | LocationID |
| Manual Hold | ManualHold |
| Marketing Code | MarketingCode |
| Method Of Payment | MethodOfPayment |
| Note | Note |
| Number Of Packages | NumberOfPackages |
| Number Shipments | NumberShipments |
| Order Date | OrderDate |
| Order Number | OrderNumber |
| Package Weight | PackageWeight |
| Payment Discount | PaymentDiscount |
| Payment Method | PaymentMethod |
| PO | PO |
| Posted To AR | PostedToAR |
| Previous Amount | PreviousAmount |
| Previous Retainage | PreviousRetainage |
| Printed | Printed |
| Ready To Print | ReadyToPrint |
| Reference | Reference |
| Reference 2 | Reference2 |
| Requested Ship Date | RequestedShipDate |
| Retainage Amount | RetainageAmount |
| Retainage Billed | RetainageBilled |
| Retainage GL Account ID | RetainageGLAccountID |
| Route | Route |
| Routing | Routing |
| Salesperson ID | SalespersonID |
| Salesperson Name | SalespersonName |
| Sales Tax | SalesTax |
| Schedule Of Values Type | ScheduleOfValuesType |
| Shipment Promised Date | ShipmentPromisedDate |
| Shipping Charge | ShippingCharge |
| Shipping Charge Account ID | ShippingChargeAccountID |
| Shipping Instructions | ShippingInstructions |
| Ship To Address | ShipToAddress |
| Ship To Address 1 | ShipToAddress1 |
| Ship To Address 2 | ShipToAddress2 |
| Ship To Addres s3 | ShipToAddress3 |
| Ship To Addres s4 | ShipToAddress4 |
| Ship To Attn | ShipToAttn |
| Ship To City | ShipToCity |
| Ship To Country | ShipToCountry |
| Ship To Override | ShipToOverride |
| Ship To Phone Number | ShipToPhoneNumber |
| Ship To State | ShipToState |
| Ship To Zip | ShipToZip |
| Ship Via | ShipVia |
| Special Instructions | SpecialInstructions |
| Stop Number | StopNumber |
| Sub Total | SubTotal |
| Taxable | Taxable |
| Tax Code | TaxCode |
| Tax Code Description | TaxCodeDescription |
| Tax ID | TaxID |
| Tax Included | TaxIncluded |
| Tax Pct | TaxPct |
| Terms Code | TermsCode |
| Terms Description | TermsDescription |
| Total Amount | TotalAmount |
| Total Shipping Charges | TotalShippingCharges |
| Tracking Number | TrackingNumber |
| Transaction Period | TransactionPeriod |
| Transaction Year | TransactionYear |
| Txn ID | TxnID |
| Type | Type |
| Updated By | UpdatedBy |
| Updated Date | UpdatedDate |
| User Email | UserEmail |
| User Email Signature | UserEmailSignature |
| User ID | UserID |
| User Message Adr | UserMessageAdr |
| User Name | UserName |

 

- [Getting Started](https://hub.acctivate.com/articles/getting-started?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/getting-started?hsLang=en#basics)
    - [User Interface](https://hub.acctivate.com/articles/getting-started?hsLang=en#user-interface)
    - [Manager windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#manager-windows)
    - [List windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#list-windows)
    - [Transaction windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#transaction-windows)
    - [License and Users](https://hub.acctivate.com/articles/getting-started?hsLang=en#license-and-users)
    - [Email](https://hub.acctivate.com/articles/getting-started?hsLang=en#email)
    - [Getting Help](https://hub.acctivate.com/articles/getting-started?hsLang=en#getting-help)
- [Installation](https://hub.acctivate.com/articles/installation?hsLang=en#main-content)

    - [Acctivate](https://hub.acctivate.com/articles/installation?hsLang=en#acctivate)
    - [Database Server](https://hub.acctivate.com/articles/installation?hsLang=en#database-server)
    - [Mobile WMS Setup](https://hub.acctivate.com/articles/installation?hsLang=en#mobile-wms-setup)
    - [Software Updates](https://hub.acctivate.com/articles/installation?hsLang=en#software-updates)
    - [Email Setup](https://hub.acctivate.com/articles/installation?hsLang=en#email-setup)
    - [Remote Access](https://hub.acctivate.com/articles/installation?hsLang=en#remote-access)
- [Configuration](https://hub.acctivate.com/articles/configuration?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/configuration?hsLang=en#basics)
    - [Users](https://hub.acctivate.com/articles/configuration?hsLang=en#users)
    - [Company Info](https://hub.acctivate.com/articles/configuration?hsLang=en#company-info)
    - [Customers](https://hub.acctivate.com/articles/configuration?hsLang=en#customers)
    - [Sales Orders](https://hub.acctivate.com/articles/configuration?hsLang=en#sales-orders)
    - [Inventory](https://hub.acctivate.com/articles/configuration?hsLang=en#inventory)
    - [Custom Fields](https://hub.acctivate.com/articles/configuration?hsLang=en#custom-fields)
    - [Email Message Templates](https://hub.acctivate.com/articles/configuration?hsLang=en#email-message-templates)
    - [Services](https://hub.acctivate.com/articles/configuration?hsLang=en#services)
- [Inventory](https://hub.acctivate.com/articles/inventory?hsLang=en#main-content)

    - [Products](https://hub.acctivate.com/articles/inventory?hsLang=en#products)
    - [Costing](https://hub.acctivate.com/articles/inventory?hsLang=en#costing)
    - [Prices and Units](https://hub.acctivate.com/articles/inventory?hsLang=en#prices-and-units)
    - [Warehouses and Locations](https://hub.acctivate.com/articles/inventory?hsLang=en#warehouses-and-locations)
    - [Lot Numbers](https://hub.acctivate.com/articles/inventory?hsLang=en#lot-numbers)
    - [Inventory Manager](https://hub.acctivate.com/articles/inventory?hsLang=en#inventory-manager)
    - [Receipts](https://hub.acctivate.com/articles/inventory?hsLang=en#receipts)
    - [Assemblies](https://hub.acctivate.com/articles/inventory?hsLang=en#assemblies)
    - [Kits and Assortments](https://hub.acctivate.com/articles/inventory?hsLang=en#kits-and-assortments)
    - [Landed Cost](https://hub.acctivate.com/articles/inventory?hsLang=en#landed-cost)
    - [Transfers](https://hub.acctivate.com/articles/inventory?hsLang=en#transfers)
    - [Adjustments](https://hub.acctivate.com/articles/inventory?hsLang=en#adjustments)
    - [Counts](https://hub.acctivate.com/articles/inventory?hsLang=en#counts)
    - [Reports](https://hub.acctivate.com/articles/inventory?hsLang=en#reports)
- [Purchasing](https://hub.acctivate.com/articles/purchasing?hsLang=en#main-content)

    - [Purchase Orders](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-orders)
    - [Purchase Order Manager](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-order-manager)
    - [Purchase Invoices](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-invoices)
    - [Vendors](https://hub.acctivate.com/articles/purchasing?hsLang=en#vendors)
- [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#main-content)

    - [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#customers)
    - [Locations](https://hub.acctivate.com/articles/customers?hsLang=en#locations)
    - [Credit & Terms](https://hub.acctivate.com/articles/customers?hsLang=en#credit-terms)
    - [Pricing](https://hub.acctivate.com/articles/customers?hsLang=en#pricing)
    - [Broadcast Email](https://hub.acctivate.com/articles/customers?hsLang=en#broadcast-email)
- [Sales](https://hub.acctivate.com/articles/sales?hsLang=en#main-content)

    - [Orders](https://hub.acctivate.com/articles/sales?hsLang=en#orders)
    - [Sales Order Manager](https://hub.acctivate.com/articles/sales?hsLang=en#sales-order-manager)
    - [Picking](https://hub.acctivate.com/articles/sales?hsLang=en#picking)
    - [Drop Shipments](https://hub.acctivate.com/articles/sales?hsLang=en#drop-shipments)
    - [Sales Tax](https://hub.acctivate.com/articles/sales?hsLang=en#sales-tax)
    - [Packaging](https://hub.acctivate.com/articles/sales?hsLang=en#packaging)
    - [Shipping](https://hub.acctivate.com/articles/sales?hsLang=en#shipping)
    - [Invoices](https://hub.acctivate.com/articles/sales?hsLang=en#invoices)
    - [Payments](https://hub.acctivate.com/articles/sales?hsLang=en#payments)
    - [Credits](https://hub.acctivate.com/articles/sales?hsLang=en#credits)
- [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#main-content)

    - [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-activities)
    - [Business Alerts](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-alerts)
- [QuickBooks](https://hub.acctivate.com/articles/quickbooks?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/quickbooks?hsLang=en#basics)
    - [QuickBooks Online](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-online)
    - [QuickBooks Desktop](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-desktop)
- [Mobile WMS](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#basics)
    - [Picking](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#picking)
    - [Receiving](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#receiving)
    - [Counts](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#counts)
    - [Assemblies](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#assemblies)
- [Web Store Integrations](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#basics)
    - [Templates and Options](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#templates-and-options)
- [EDI](https://hub.acctivate.com/articles/edi?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/edi?hsLang=en#basics)
    - [Orders - 850](https://hub.acctivate.com/articles/edi?hsLang=en#orders-850)
    - [Shipments - 856](https://hub.acctivate.com/articles/edi?hsLang=en#shipments-856)
    - [Invoices - 810](https://hub.acctivate.com/articles/edi?hsLang=en#invoices-810)
    - [Warehouse - 940/945](https://hub.acctivate.com/articles/edi?hsLang=en#warehouse-940-945)
- [Reports](https://hub.acctivate.com/articles/reports?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/reports?hsLang=en#basics)
    - [Standard Reports](https://hub.acctivate.com/articles/reports?hsLang=en#standard-reports)
    - [Crystal Reports](https://hub.acctivate.com/articles/reports?hsLang=en#crystal-reports)
    - [Excel](https://hub.acctivate.com/articles/reports?hsLang=en#excel)
- [Database](https://hub.acctivate.com/articles/database?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/database?hsLang=en#basics)
    - [Backup & Restore](https://hub.acctivate.com/articles/database?hsLang=en#backup-restore)
    - [Microsoft SQL Server](https://hub.acctivate.com/articles/database?hsLang=en#microsoft-sql-server)
    - [Imports](https://hub.acctivate.com/articles/database?hsLang=en#imports)
- [Troubleshoot](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#main-content)

    - [General](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#general)
    - [Installation](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#installation)
    - [Inventory](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#inventory)
    - [Purchasing](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#purchasing)
    - [Sales](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#sales)
    - [Shipping](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#shipping)
    - [QuickBooks Desktop](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-desktop)
    - [QuickBooks Online](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-online)
    - [Mobile WMS](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#mobile-wms)
    - [Web Store Integration](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#web-store-integration)
    - [EDI](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#edi)
    - [Reports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#reports)
    - [Database](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#database)
    - [Imports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#imports)
    - [Email](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#email)
    - [Integrations](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#integrations)

[![Acctivate Inventory Software](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg "Acctivate Inventory Software")](https://acctivate.com)

Acctivate Knowledge Base

<https://www.twitter.com/acctivate> <https://www.linkedin.com/company/alterity-inc-/> [mailto:support@acctivate.com](mailto:support@acctivate.com)

Copyright © 2025, Alterity, LLC