Skip to main content
Skip table of contents

Using standard custom field names

Purpose and scope

Digital Commerce Platform integrates seamlessly with your ERP, allowing you to use and extend your business data without compromising its quality and integrity. Experlogix Digital Commerce has developed and maintain a standard set of services to integrate its platform with your ERP.

Data is requested and sent through a standard data interface using a web service. Which web service you integrate with depends on the ERP you use.

Integrating your ERP with Digital Commerce Platform is a key task that occurs when your solution is being built. Often, it is necessary to use custom fields when integrating your ERP with Digital Commerce Platform so that business data can be used to carry out typical eCommerce tasks, such as placing sales orders or creating quotes.  Consequently, there is a set of custom fields that are frequently used. In order to streamline integrating Digital Commerce Platform with your ERP, there is a standard convention when naming these custom fields.

The custom fields listed in this guide are all required fields for successfully integrating Digital Commerce Platform with your ERP. 

This feature guide lists the names of the custom field that are typically used to support a seamless integration with your ERP.

Benefits

The key benefits for using this feature are:

  • Enables a more streamlined and standard integration between Digital Commerce Platform and your ERP

  • Extend your business data to create a WebShop, Mobile Apps or Multi-channel that suits your business processes

Introducing terms and concepts used in this article

Term

Definition

Enterprise resource planning

(ERP), a collection of your critical business operating systems, such as product, stock levels, financial, customers, suppliers and so on that run on the same platform.

Web service

How it fits together

Digital Commerce Platform uses standard custom field names to extend the integration between it and your ERP. 

Generally, custom field names that are used in Digital Commerce Platform are prefixed with "AX-".

Custom field names in Intact iQ

Recommendation

When creating user-defined fields in Intact iQ that map to those listed on this page, we recommend that you use the following convention: D_<Field-Name>

Feature set | Feature

Field Name

Field Format

Document

Purpose

AX_Channel_Type

alphanumeric

  • Sales Order

  • Invoice

  • Quotation

To identify how or through what channel ,the order was placed. Channels could be set to "WebShop", "SalesRep", "PocketShop" or "API" for orders, invoices and quotations in those different channels.

AX_Channel_Ref

alphanumeric

  • Sales Order

  • Invoice

  • Quotation

To identify a specific channel.

For example, you could have two WebShops called webshop-A.com and webshop-B.com; use this field to specify which WebShop to use for sales through that specific channel.

AX_Doc_Ref

alphanumeric

  • Sales Order

  • Invoice

  • Quotation

To identify a specific order, invoice or quotation. 

In WebShop, this typically is set to the next number in series.

  • Sales Order Processing | Placing an order in WebShop

AX_PhoneNumber

alphanumeric

  • Sales Order

  • Invoice

To specify a contact phone number of a delivery contact.

  • Sales Order Processing | Placing an order in WebShop

AX_EmailAddress

alphanumeric

  • Sales Order

  • Invoice

To specify an email address on sales orders and invoices.

  • Sales Order Processing | Placing an order in WebShop

  • Pricing | Using vouchers and coupons in WebShop

AX_COUPON_CODE

alphanumeric

  • Sales Order

  • Invoice

To capture the coupon code used on an order. Currently, this is only used by a percentage discount coupon.

  • Pricing | Using vouchers and coupons in WebShop

AX_VOUCHER_CODE

alphanumeric

  • Sales Order

  • Invoice

To capture the voucher code spent on an order. Currently, this is only used where the coupon amount is fixed and by shipping vouchers.

  • Pricing | Using vouchers and coupons in WebShop

AX_VOUCHER_SPENT

numeric

  • Sales Order

  • Invoice

To capture the voucher amount spent on an order. Currently, this is only used where the coupon amount is fixed and by shipping vouchers.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.