eBusiness Manager Merge Fields Home | FAQs & Troubleshooting

 

 Show/Hide All

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.

Example:

Customer: Address: City/State: ZIP/Postal: Country: Phone Number: Fax Number: E-mail Address: URL Address:

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.

Example:

MasterCard

 

 REASON

This merge field contains the description of a reason code entered in E-mail Reason Code Maintenance. Reason codes can be applied to entries in UID/Customer Accept/Reject Entry and Shopping Cart Accept/Reject Entry to indicate why an entry is being accepted or rejected. A reason code can also be entered in Sales Order Entry when you are deleting a sales order that originated from the Internet.

Example:

An obsolete item was submitted.

 

 SALES_ORDER_INFO

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.

To use the <<SO_INV_WITH_WARRNTY>> merge field, the Enable Warranty Tracking check box must be selected in Inventory Management Options and warranty descriptions must be set up in Warranty Code Maintenance.

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:	.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:	.00 397.85 7.50 .00 59.68 345.67
Item Code GB-EL04MS-07 RJ-11 4 WIRE GB-EL04MS-25 RJ-11 4 WIRE GB-EQ380-1—MM CENTRONICS	Qty Ordered 3.00 15.00 0.00   10.00 0.00	Qty on BO 0.00	Qty Shipped 3.00 15.00 4.61 10.00 32.09	Unit Price 2.60	Extension 7.80 69.15 320.90

 

 SO_INVOICE_NUMBER

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.

To use the <<SO_ORD_INFO_W_WARRNTY>> merge field, the Enable Warranty Tracking check box must be selected in Inventory Management Options and warranty descriptions must be set up in Warranty Code Maintenance.

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 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
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.

Example:

John D. Dunn (JOHND)

 

For more information, seeE-mail Notifications and Merge Fields.