eBusiness Manager Merge Fields

 

Expand/Collapse all 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:

 

Expand/Collapse item  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

 

Expand/Collapse item  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

 

Expand/Collapse item 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]

 

Expand/Collapse item  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)

 

Expand/Collapse item  CUSTOMER

This merge field contains the customer name, followed by the customer number enclosed in parentheses.

Example:

American Business Futures (01-ABF)

 

Expand/Collapse item  PARTIAL_CC_NUMBER

This merge field contains the last four digits of the user's credit card number.

Example:

*1234

 

Expand/Collapse item  PASSWORD

This merge field contains the user's password.

Example:

OpenSesame

 

Expand/Collapse item  PAY_TYPE_DESCRIPTION

This merge field contains the payment type that the user selected on the Internet.

Example:

MasterCard

 

Expand/Collapse item  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.

 

Expand/Collapse item  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

 

Expand/Collapse item  SALES_ORDER_NUMBER

This merge field contains the sales order number.

Example:

0234567

 

Expand/Collapse item  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

 

Expand/Collapse item  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
 

 

Expand/Collapse item  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

 

Expand/Collapse item  SO_INVOICE_NUMBER

This merge field contains the invoice number, followed by the invoice type.

Example:

0000234-IN

 

Expand/Collapse item  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.

   

 

Expand/Collapse item  USER_CHANGED

This merge field contains the user name, followed by the user ID enclosed in parentheses.

Example:

John D. Dunn (JOHND)

 

Expand/Collapse item  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

 

Expand/Collapse item  USER_NAME

This merge field contains the user name.

Example:

John D. Doe (JOHND)

 

Expand/Collapse item  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.


 

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks