The merge fields available in E-mail
Notification Maintenance, along with an example of the data contained
in the merge field, are listed as follows:
CHANGED_CUST_INFO
This data block contains information that
reflects changes to the customer record entered via the Internet.
All information is included in the merge field, regardless of
which fields are actually changed. The Customer field contains
the customer name, followed by the customer number enclosed in
parentheses.
Airway
Corporation (01-Airway)
1234 Main Street
Apt 100
Irvine, CA
92618
USA
(949) 555-1111
(949) 555-2222 [email protected]
http://www.example.com
CHANGED_USER_INFO
This data block contains information that
reflects changes to a user's record entered via the Internet.
All information is included in the merge field, regardless of
which fields are actually changed. If the Suspend Access field
is set to YES, the following message is included at the end of
the data block.
***NOTE: User access has been suspended.***
Example:
Name:
Title:
Address:
City/State:
ZIP/Postal:
Country:
E-mail Address:
Phone Number 1:
Phone Number 2:
Fax Number:
Suspend Access:
Shopping Cart:
John
Dunn
Purchasing Mgr
1234 Main Street
Apt 100
Irvine, CA
92618
USA [email protected]
949-555-1234
949-555-5678
949-555-0000
NO
YES
CHNGD_USER_PROFILE
This merge field contains information that
reflects changes to the user's profile information entered via
the Internet. All information is included in the merge field,
regardless of which fields are actually changed.
Example:
Name:
Address:
City/State:
ZIP/Postal:
Country:
Phone Number 1:
Phone Number 2:
Fax Number:
E-mail Address:
John
Doe
1234 Main Street
Suite 100
Irvine, CA
92618
USA
949-555-1234
949-555-5678
949-555-000 [email protected]
COMPANY
This merge field contains the company name,
followed by the three-character company code enclosed in parentheses.
Example:
ABC Distribution and Service Corp. (ABC)
CUSTOMER
This merge field contains the customer name,
followed by the customer number enclosed in parentheses.
Example:
American Business Futures (01-ABF)
PARTIAL_CC_NUMBER
This merge field contains the last four digits
of the user's credit card number.
Example:
*1234
PASSWORD
This merge field contains the user's password.
Example:
OpenSesame
PAY_TYPE_DESCRIPTION
This merge field contains the payment type
that the user selected on the Internet.
This data block contains detailed information
for a shopping cart order that was submitted via the Internet.
The information is broken down into three separate sections: addresses,
totals, and order detail. If an order is accepted into the accounting
system and placed on hold (either for insufficient quantities
or for exceeding the customer's credit limit), the following note
is included at the beginning of the data block.
Note: This order has been placed on hold.
Reason: (description of cancellation/hold code)
The description for this reason is maintained
in Cancel/Reason
Code Maintenance. Use the following permanent cancellation/hold
codes to maintain these descriptions.
Cancellation/
Hold Code
Criteria
CRED
Credit
limit exceeded
NSQTY
Insufficient
quantity for one or more lines
CLQTY
Credit
limit exceeded and insufficient quantity
NOCC
Credit
Card pre-authorization failed or did not occur
ESTAX
Estimated
sales tax schedule used to calculate sales tax
KITER
A quantity
mask overflow error occurred on one or more of a kit’s
exploded component lines. When this occurs, the quantity
on the line containing the error is set to 0.
Example:
Bill-to
Address:
Jellco Packing
1889 E. Ball Road
Ship-to
Address:
Jellco Packing
1889 E. Ball Road
Orange,
CA 92553
Orange,
CA 92553
Ship Via:
Terms:
Customer PO:
Ship Date:
UPS Red
01
Net 30 Days
steve0
06/15/2003
Taxable:
Non-Taxable:
Freight:
Sales Tax:
Discount:
Order Total:
.00
168.00
.00
.00
25.20
142.80
Item Code
1001-HON-H252
Quantity
2.00
Unit Price
84.000
Extension
168.00
SALES_ORDER_NUMBER
This merge field contains the sales order
number.
Example:
0234567
SHIP_TO_DATA
This data block contains information that
was entered via the Internet to either add a new ship-to location
or to make changes to an existing ship-to location. All information
is included in the merge field, regardless of which fields are
actually changed. The Ship To Code field will contain *NEW* if
a new ship-to location is being requested.
Example:
Ship
To Code:
Ship To Name:
Address:
City, State:
ZIP/Postal:
Country:
Phone/Ext:
Fax:
0001
John Dunn
1234 Main Street
Apt 100
Irvine, CA
92618
USA
(949) 555-1223 Ext 123
(949) 555-1224
SO_INV_WITH_WARRNTY
This data block contains detailed information
for an invoiced shopping cart order and the warranty code descriptions
associated with the products ordered. The information is broken
down into three separate sections: addresses, totals, and invoice
detail. The only difference between this data block and the <<SALES_ORDER_INFO>>
data block is that this data block contains the Qty on BO and
Qty Shipped fields, in addition to the Qty Ordered field.
Taxable:
Non-Taxable:
Freight:
Sales Tax:
Discount:
Order Total:
.00
397.85
7.50
.00
59.68
345.67
Item
Code
GB-EL04MS-07
RJ-11 4 WIRE
Warranty Information:
60 DAYS
Labor and parts guaranteed for 60 days.
Qty Ordered
3.00
Qty on
BO
0.00
Qty Shipped
3.00
Unit
Price
2.60
Extension
7.80
SO_INVOICE_INFO
This data block contains detailed information
for an invoiced shopping cart order submitted via the Internet.
The information is broken down into three separate sections: addresses,
totals, and invoice detail. The only difference between this data
block and the <<SALES_ORDER_INFO>> data block is that
this data block contains the Qty on BO and Qty Shipped fields,
in addition to the Qty Ordered field.
Example:
Bill-to Address:
Jellco Packing
1889 E. Ball Road
Orange, CA 92553
Ship-to
Address:
Jellco Packing
1889 E. Ball Road
Orange, CA 92553
Ship
Via:
Terms:
Customer PO:
Ship Date:
UPS Blue
01
Net 30 Days
steve0
06/30/2003
Taxable:
Non-Taxable:
Freight:
Sales Tax:
Discount:
Order Total:
This merge field contains the invoice number,
followed by the invoice type.
Example:
0000234-IN
S_ORD_INFO_W_WARRNTY
This data block contains detailed information
from a submitted shopping cart order and the warranty code descriptions
associated with the products ordered. The information is broken
down into three separate sections: addresses, totals, and order
detail. If an order is accepted into the accounting system and
placed on hold (either for insufficient quantities or for exceeding
the customer's credit limit), the following note is included at
the beginning of the data block.
Note: This order has been placed on hold.
Reason: (description of cancellation/hold code)
The description for this reason is maintained
in Cancel/Reason
Code Maintenance. Use the following permanent cancellation/hold
codes to maintain these descriptions.
Cancellation/
Hold Code
Criteria
CRED
Credit
limit exceeded
NSQTY
Insufficient
quantity for one or more lines
CLQTY
Credit
limit exceeded and insufficient quantity
NOCC
Credit
Card pre-authorization failed or did not occur
ESTAX
Estimated
sales tax schedule used to calculate sales tax
KITER
A quantity
mask overflow error occurred on one or more of a kit’s
exploded component lines. When this occurs, the quantity
on the line containing the error is set to 0.
Taxable:
Non-Taxable:
Freight:
Sales Tax:
Discount:
Order Total:
.00
168.00
.00
.00
25.20
142.80
Item Code
1001-HON-H252
Quantity
2.00
Unit Price
84.000
Extension
168.00
Warranty Information: 90 DAYS
90-day warranty from date of purchase for defective parts.
USER_CHANGED
This merge field contains the user name,
followed by the user ID enclosed in parentheses.
Example:
John D. Dunn (JOHND)
USER_INFORMATION
This data block is used to e-mail the user
ID and password to a user. It contains the company description,
followed by the three-character company code in parentheses, as
well as the URL to access the Web site directly from the e-mail.
Example:
ABC
Distribution and Service Corp. (ABC)
User ID:
Password:
http://www.example.com
JOHND
jddunn
USER_NAME
This merge field contains the user name.
Example:
John D. Doe (JOHND)
USER_SUBMITTING
This merge field contains the user name,
followed by the user ID enclosed in parentheses.
Show/Hide
All
