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 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 . 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
AR Account ID
Backorder Criteria
Bank Id
Bill To Address
Bill To Address 1
Bill To Address 2
Bill To Address 3
Bill To Address 4
Bill To City
Bill To Country
Bill To Name
Bill To State
Bill To Zip
Branch ID
Carrier Service
CC Authorization Code
CCAVS Street
CC Exp Date
CC Merchant Account Number CCMerchAcctNumber
CC Payment Grouping Code
CC Recon Batch ID
CC Status Code
CC Status Message
CC Trans ID
CC Txn Auth Stamp
CC Txn Auth Time
Check No
Collection Days
Company Address 1
Company Address 2
Company Address 3
Company Address 4
Company City
Company Country
Company Email
Company Fax
Company Name
Company Phone
Company State
Company Tax ID
Company Web Address
Company ZIP
Contact Email Address
Contact Fax
Contact Name
Contact Phone Number
Contract Date
Contract ID
Created By
Created Date
Credit Approval Date
Credit Approved By
Currency Code
Currency Name
Customer ID
Customer Tax ID
Date Completed
Date Posted
Date Printed
Delivered By
Delivered To
Delivery Date
Delivery Miles
Discount Amount
Discount Available
Discount Date
Discount Type
Do Not Sync
Due Date
Entered By
Entry Date
Exchange Rate
Export Date
Foreign Amount Paid
Foreign Balance
Foreign Discount Amount
Foreign Discount Available
Foreign Payment Discount
Foreign Sales Tax
Foreign Shipping Charge
Foreign Sub Total
Foreign Total Amount
Foreign Total Shipping Charges
From QB
Freight Tax Pct
Hold Released By
Hold Released Date
In Dispute
Invoice Date
Invoice Detail Report ID
Invoice Discount Account ID
Invoice Discount Percent
Invoice Format
Invoice Number
Invoice Number Sort
Invoice Report ID
Invoice Style
Invoice Text
Job ID
Job Number
Last Payment Date
Last Shipmen tDate
Location ID
Manual Hold
Marketing Code
Method Of Payment
Number Of Packages
Number Shipments
Order Date
Order Number
Package Weight
Payment Discount
Payment Method
Posted To AR
Previous Amount
Previous Retainage
Ready To Print
Reference 2
Requested Ship Date
Retainage Amount
Retainage Billed
Retainage GL Account ID
Salesperson ID
Salesperson Name
Sales Tax
Schedule Of Values Type
Shipment Promised Date
Shipping Charge
Shipping Charge Account ID
Shipping Instructions
Ship To Address
Ship To Address 1
Ship To Address 2
Ship To Addres s3
Ship To Addres s4
Ship To Attn
Ship To City
Ship To Country
Ship To Override
Ship To Phone Number
Ship To State
Ship To Zip
Ship Via
Special Instructions
Stop Number
Sub Total
Tax Code
Tax Code Description
Tax ID
Tax Included
Tax Pct
Terms Code
Terms Description
Total Amount
Total Shipping Charges
Tracking Number
Transaction Period
Transaction Year
Txn ID
Updated By
Updated Date
User Email
User Email Signature
User ID
User Message Adr
User Name