Table of Contents

Business Central OData v4 blueprint

The Business Central OData v4 blueprint is a comprehensive collection of integration activities to integrate Business Central entities with your DynamicWeb solution.

Workflow

The activities in the OData v4 blueprint work by importing and exporting data to and from standard Business Central entities exposed through pages via OData v4 webservices. This means that while the OData v4 blueprint comes with an extensive set of pre-configurations on the DynamicWeb side, such as table - and columns mappings, some minor tasks need to be made on the Business Central side.

In order to expose all of the relevant entities in Business Central, a series of pages must be exposed as OData v4 web services in the Business Central environment. Since the activities rely on predefined mappings between DynamicWeb entities and Business Central exposed tables, it is important that all web services adhere to the naming conventions outlined in the following section.

Exposing Business Central standard entities through pages via OData v4 web services, as opposed to just using the default OData API, may naturally raise the question "Why?".

The short answer is that the Business Central API has some gaps in terms of missing entities and custom fields, and that it is currently not possible to make up for these gaps for instance with custom extensions af the API. Having each page exposed as an OData v4 web service makes up for this by allowing exposure of custom fields.

Another aspect of the OData v4 approach is that it allows DynamicWeb users to configure an ERP integration that requires no logic on the external system. Essentially, the OData v4 blueprint is designed to have the smallest possible footprint on the ERP and require no AL-developer expertise.

So while the V4 blueprint requires some exposure of web services, it offers a more complete range of tables and fields ready to integrate with your DynamicWeb solution.

Business Central v4 entities - imports

The blueprint includes activities for importing the following list of Business Central entities:

Object Name Business Central Object ID Web Service Name
Countries/Regions 10 DynamicwebCountries
Currencies 5 DynamicwebCurrencies
Salesperson/Purchaser card 5116 DynamicwebSalespersonPurchaserCard
Contact Card 5050 DynamicwebContactCard
Customer Card 21 DynamicwebCustomerCard
Contact Alt. Address Card 5056 DynamicwebAltAddressCard
Ship-to Address 300 DynamicwebShipToAddress
Vendor Card 26 DynamicwebVendorCard
Locations 15 DynamicwebLocations
Item Category Card 5733 DynamicwebItemCategoryCard
Item Card 30 DynamicwebItemCard
Item Variants 5401 DynamicwebItemVariants
Units of Measure 209 DynamicwebUnitsOfMeasure
Item Units of Measure 5404 DynamicwebItemUnits
Item translations 35 DynamicwebItemTranslations
Unit of Measure Translation 5402 DynamicwebUnitOfMeasureTranslation
Stockkeeping Unit Card 5700 DynamicwebStockKeepingUnitCard
Resources 77 DynamicwebResources
AssemblyBOM 36 AssemblyBOM
Sales Orders 42 DynamicwebSalesOrder
Sales Order Lines 20044 DynamicwebSalesOrderLines
Prices 7002 DynamicwebSalesPrices
Discounts 7004 DynamicwebSalesLineDiscounts
Prices & Discounts (New Pricing Experience) 7016 DynamicwebSalesPriceList

Business Central v4 entities - exports

The template also includes a separate activity group for exporting the following list of entities.

DynamicWeb object Name Business Central Object ID Web Service Name
Countries/Regions 10 DynamicwebCountries
Employees 5116 DynamicwebSalespersonPurchaserCard
Customers 21 DynamicwebCustomerCard
Contacts 5050 DynamicwebContactCard
User addresses 5056 DynamicwebAltAddressCard
Vendors 26 DynamicwebVendorCard
Stock 15 DynamicwebLocations
Items 30 DynamicwebItemCard
Item variants 5401 DynamicwebItemVariants
Units of measure) 209 DynamicwebUnitsOfMeasure
Orders 42 DynamicwebSalesOrder
Sales Order Lines 20044 DynamicwebSalesOrderLines
AssemblyBOM 36 AssemblyBOM

Exposing V4 pages in Business Central

To expose a Business Central page as an OData V4 web service open your Business Central web interface and search for the Web Services list.

Web services URLs in BC

To add a Web service to the list follow these steps:

  • Click New
  • Select Page in the Object Type cell
  • Enter the Object ID of the given page (as shown in the table above)
  • Provide a Service Name that exactly matches the service names given in the above table (ie. DynamicwebItemCard, DynamicwebLocations etc.)
  • Check the Published checkbox

Adding the exposed web services as endpoints in DynamicWeb

There are two ways of adding the Business Central web services to an endpoint collection in your DynamicWeb solution.

One way is to add a generic OData v4 API URL in the following format:

https://api.businesscentral.dynamics.com/v2.0/[TENANT_ID]/[ENVIROMENT_NAME]/ODataV4/Company(['COMPANY_ID'])

The other way is to add separate endpoints for each entity in the same format as the general V4 API followed by a '/' and the specific web service name. While this method implies a more cumbersome manual configuration it does however have the advantage of better testing possibilities within the DynamicWeb endpoint request interface.

The full OData V4 URL of the specific web services can also be copy-pasted from the Web services list in the Business Central web interface.

Web services URLs in BC

The OData provider automatically detects if the selected endpoint is a single - or multi entity endpoint when an activity is run. If the endpoint does not reference a specific entity the provider adds the name of the mapped source table as the entity name in the request URL.

Note

When an integration activity imports from or exports to multiple entities, such as Orders and Orderlines, the predefined endpoint used must be the generic v4 API with no entity specified.

Regardless of how many unique endpoints you wish to work with, the recommended way to organize them is to use a single endpoint collection with an OAuth S2S authentication.

Activities and mappings - imports

The following section gives an overview of the mappings defined in each of the activities included in the blueprint. It also lists the needed manual configurations for each activity.

Import Countries

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebCountries)

Predefined mappings

DynamicwebCountries EcomCountries
Code CountryCode2
ISO_Numeric_Code CountryNumber
Constant: "" CountryCultureInfo

Import Currencies

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebCurrencies)

Predefined mappings

DynamicwebCurrencies EcomCurrencies
Code CurrencyCode
Description CurrencyName
ExchangeRateAmt CurrencyRate
ISO_Numeric_Code CurrencyPayGatewayCode
Constant: "LANG1" CurrencyLanguageId

Import Salespersons/purchasers

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebSalespersonPurchaserCard) Destination settings: Select Destination group (ie. the user group you wish to import to)

Predefined mappings

DynamicwebSalespersonPurchaserCard AccessUser
Code AccessUserExternalId
E_Mail AccessUserEmail
Job_Title AccessUserJobTitle
Name AccessUserName
Phone_No AccessUserPhone
E_Mail AccessUserUserName

Import Contacts

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or DynamicwebContactCard) Destination settings: Select Destination group (ie. the user group you wish to import to)

Predefined mappings

DynamicwebContactCard AccessUser
Address AccessUserAddress
Address_2 AccessUserAddress2
City AccessUserCity
Company_Name AccessUserCompany
Country_Region_Code AccessUserCountryCode
Currency_Code AccessUserCurrencyCharacter
E_Mail AccessUserEmail
Fax_No AccessUserFax
IntegrationCustomerNo AccessUserCustomerNumber
Mobile_Phone_No AccessUserMobile
Name AccessUserName
Phone_No AccessUserPhone
Post_Code AccessUserZip
E_Mail AccessUserUserName
No AccessUserExternalId
DynamicwebContactCard AccessUserSecondaryRelation
No AccessUserSecondaryRelationSecondaryUserId
Salesperson_Code AccessUserSecondaryRelationUserId

By default, the Contact import is filtered to import only import contacts of the type Person (conditional on the accessUser table mapping).

Import Customers

The customer import part of the OData v4 blueprint package is split into 4 activities to handle Price and discount groups configured in Business Central. Make sure to run the activities in the order described in the following section.

If your integration setup does not entail user specific prices and discounts, simply running the DynamicWebCustomerCard - 2 activity (Customers, addresses and relations) will suffice.

Manual configuration

Acitivity 1 - Price and discount groups

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebCustomerCard)

Predefined mappings

Conditional: Customer_Price_Group Different from "" (empty)

DynamicwebCustomerCard AccessUserGroup Note
Customer_Price_Group AccessGroupName Prepend: "Price_"

Conditional: Customer_Disc_Group Different from "" (empty)

DynamicwebCustomerCard AccessUserGroup Note
Customer_Price_Group AccessGroupName Prepend: "Disc_"

Activity 2 - Customers, addresses and relations

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebCustomerCard) Destination settings: Select Destination group (ie. the user group you wish to import to)

Predefined mappings

DynamicwebCustomerCard AccessUser
Address AccessUserAddress
Address_2 AccessUserAddress2
City AccessUserCity
Country_Region_Code AccessUserCountryCode
Currency_Code AccessUserCurrencyCharacter
E_Mail AccessUserEmail
Fax_No AccessUserFax
MobilePhoneNo AccessUserMobile
Name AccessUserName
No AccessUserCustomerNumber
Phone_No AccessUserPhone
Post_Code AccessUserZip
E_Mail AccessUserUserName
No AccessUserExternalId
DynamicwebCustomerCard AccessUserAddress
Address AccessUserAddressAddress
Constant: "False" AccessUserAddressType
Address_2 AccessUserAddressAddress2
No AccessUserAddressCustomerNumber
No AccessUserAddressUserId
City AccessUserAddressCity
Post_Code AccessUserAddressZip
Phone_No AccessUserAddressPhone
MobilePhoneNo AccessUserAddressCell
Fax_No AccessUserAddressFax
E_Mail AccessUserAddressEmail
Name AccessUserAddressName
Name AccessUserAddressCallName
Country_Region_Code AccessUserAddressCountryCode
Constant: "True" AccessUserAddressIsDefault
DynamicwebCustomerCard AccessUserSecondaryRelation
No AccessUserSecondaryRelationSecondaryUserId
Salesperson_Code AccessUserSecondaryRelationUserId

Activity 3 - Customer price group import

Source settings: Select Predefined endpoint (V4 general API or DynamicwebCustomerCard)

Predefined mappings

Conditional: Customer_Price_Group different from "" (empty)

DynamicwebCustomerCard AccessUser
Address AccessUserAddress
Address_2 AccessUserAddress2
City AccessUserCity
Country_Region_Code AccessUserCountryCode
Currency_Code AccessUserCurrencyCharacter
E_Mail AccessUserEmail
Fax_No AccessUserFax
MobilePhoneNo AccessUserMobile
Name AccessUserName
No AccessUserCustomerNumber
Phone_No AccessUserPhone
Post_Code AccessUserZip
E_Mail AccessUserUserName
No AccessUserExternalId
Customer_Price_Group AccessUserGroups Prepend: "Price_"

Activity 4 - Customer discount group import

Source settings: Select Predefined endpoint (V4 general API or DynamicwebCustomerCard)

Predefined mappings

Conditional: Customer_Disc_Group different from "" (empty)

DynamicwebCustomerCard AccessUser
Address AccessUserAddress
Address_2 AccessUserAddress2
City AccessUserCity
Country_Region_Code AccessUserCountryCode
Currency_Code AccessUserCurrencyCharacter
E_Mail AccessUserEmail
Fax_No AccessUserFax
MobilePhoneNo AccessUserMobile
Name AccessUserName
No AccessUserCustomerNumber
Phone_No AccessUserPhone
Post_Code AccessUserZip
E_Mail AccessUserUserName
No AccessUserExternalId
Customer_Price_Group AccessUserGroups Prepend: "Disc_"

Import Contact Alt. Addresses

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebAltAddressCard) Destination settings: Select Destination group (ie. the user group you wish to import to)

Predefined mappings

DynamicwebAltAddressCard AccessUserAddress
Address AccessUserAddressAddress
Address_2 AccessUserAddressAddress2
City AccessUserAddressCity
Code AccessUserAddressName
Company_Name AccessUserAddressCompany
Country_Region_Code AccessUserAddressCountryCode
E_Mail AccessUserAddressEmail
Fax_No AccessUserAddressFax
Mobile_Phone_No AccessUserAddressCell
Phone_No AccessUserAddressPhone
Post_Code AccessUserAddressZip
Code AccessUserAddressCallName
Company_Name AccessUserAddressUserId
Constant: "False" AccessUserAddressIsDefault
Code AccessUserAddressExternalId

Import Ship-to Addresses

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebShipToAddress)

Predefined mappings

DynamicwebShipToAddress AccessUserAddress
Address AccessUserAddressAddress
Address_2 AccessUserAddressAddress2
City AccessUserAddressCity
Code AccessUserAddressName
Country_Region_Code AccessUserAddressCountryCode
E_Mail AccessUserAddressEmail
Fax_No AccessUserAddressFax
Name AccessUserAddressCompany
Phone_No AccessUserAddressPhone
Post_Code AccessUserAddressZip
Code AccessUserAddressCallName
Customer_No AccessUserAddressUserId
Code AccessUserAddressExternalId

Import Vendors

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebVendorCard)

Predefined mappings

DynamicwebVendorCard EcomManufacturers
Address ManufacturerAddress
Address_2 ManufacturerAddress
City ManufacturerCity
Country_Region_Code ManufacturerCountry
E_Mail ManufacturerEmail
Fax_No ManufacturerFax
Home_Page ManufacturerWeb
Name ManufacturerName
No ManufacturerId
Phone_No ManufacturerPhone
Post_Code ManufacturerZipCode

Import Locations

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebLocations) Default language: The stock location languageId is mapped to "LANG1" by default, if this does not match your default language, you should change the Constant value defined in the mappings.

Predefined mappings

DynamicwebLocations EcomStockLocation
Code StockLocationName
Name StockLocationDescription
Constant: "LANG1" StockLocationLanguageId

Import Item Categories

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebItemCategoryCard) Shop: The activity maps the imported item categories to "SHOP1" - if this does match the shop you wish to import categories into, you should manually change the Constant value defined in the Shops column.

Predefined mappings

DynamicwebItemCategoryCard EcomGroups
Code GroupId
Description GroupName
Parent_Category ParentGroups
Constant: "True" GroupNavigationShowInMenu
Constant: "True" GroupNavigationShowInSiteMap
Constant: "True" GroupNavigationClickable
Constant: "True" GroupInheritOrderLineFields
Constant: "True" GroupInheritCategoryFieldsFromParent
Constant: "SHOP1" Shops

Import Items

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebItemCard)

Predefined mappings

Conditional: AssemblyBOM EqualTo True

DynamicwebItemCard EcomProducts
Base_Unit_of_Measure ProductDefaultUnitId
Blocked ProductActive
Description ProductName
Gross_Weight ProductWeight
GTIN ProductEAN
Item_Category_Code PrimaryGroup
Minimum_Order_Quantity ProductPurchaseMinimumQuantity
No ProductNumber
Unit_Cost ProductCost
Unit_Price ProductPrice
Unit_Volume ProductVolume
Vendor_No ProductManufacturerId
Constant: 2 ProductType (only applied on create)
No ProductId
Item_Category_Code Groups
No ProductExternalId
Constant: "" ProductVariantId
Constant: "" ProductExternalVariantId

Conditional: AssemblyBOM EqualTo False

DynamicwebItemCard EcomProducts
Base_Unit_of_Measure ProductDefaultUnitId
Blocked ProductActive
Description ProductName
Gross_Weight ProductWeight
GTIN ProductEAN
Item_Category_Code PrimaryGroup
Minimum_Order_Quantity ProductPurchaseMinimumQuantity
No ProductNumber
Unit_Cost ProductCost
Unit_Price ProductPrice
Unit_Volume ProductVolume
Vendor_No ProductManufacturerId
Constant: 0 ProductType (applied only on create)
No ProductId
Item_Category_Code Groups
No ProductExternalId
Constant: "" ProductVariantId
Constant: "" ProductExternalVariantId

Import Item Variants

The Item Variant import of the blueprint package includes four separate activities that each handle their part of import. Make sure to run the activities in the order described in the following section.

Activity 1 - Variant groups

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebUnitsOfMeasure)

Predefined mappings

DynamicwebItemVariants EcomVariantGroups
Item_No VariantGroupId
Constant: "True" VariantGroupFamily
Item_No VariantGroupName
Constant: "ERP Variant" VariantGroupLabel

Activity 2 - Variant options

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebUnitsOfMeasure)

Predefined mappings

DynamicwebItemVariants EcomVariantOptions
Item_No VariantOptionId
Code VariantOptionId
Item_No VariantOptionGroupId
Code VariantOptionName

Activity 3 - Variant product information

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebUnitsOfMeasure)

Predefined mappings

DynamicwebItemVariants EcomProducts
Item_No ProductVariantId
Code ProductVariantId
Item_No VariantGroups
Item_No VariantOptions
Code VariantOptions
Item_No ProductNumber
Item_No ProductId
Code ProductName
Item_No ProductExternalId
Code ProductExternalVariantId
Description ProductShortDescription

Activity 4 - Variant product relations

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebUnitsOfMeasure)

Predefined mappings

DynamicwebItemVariants EcomVariantOptionsProductRelation
Item_No VariantOptionsProductRelationProductId
Item_No VariantOptionsProductRelationVariantId
Code VariantOptionsProductRelationVariantId

Import Units of Measure

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebUnitsOfMeasure)

Predefined mappings

DynamicwebUnitsOfMeasure EcomUnits
Code UnitId
Code UnitExternalId

Import Item Units of Measure

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebItemUnits)

Predefined mappings

DynamicwebItemUnits EcomStockUnit
Code StockUnitId
Height StockUnitHeight
Item_No StockUnitProductId
Length StockUnitDepth
Qty_per_Unit_of_Measure StockUnitQuantity
Weight StockUnitWeight
Width StockUnitWidth
Item_No StockUnitProductNumber
Constant: "" (empty) StockUnitVariantId

Import Item Translations

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebItemTranslations)

Predefined mappings

Table 1 (Non-variants):

| DynamicwebItemTranslations | EcomProducts | | Description | ProductShortDescription | | Item_No | ProductNumber | | Language_Code | ProductLanguageId | | Item_No | ProductVariantId | | Variant_Code | ProductVariantId | | Variant_Code | ProductName | | Constant: (empty) | ProductVariantId | | Variant_Code | ProductName | | Item_No | ProductExternalId | | Constant: (empty) | ProductExternalVariantId | | Item_No | ProductId |

Table 2 (Variants):

DynamicwebItemTranslations EcomProducts
Description ProductShortDescription
Item_No ProductNumber
Language_Code ProductLanguageId
Item_No ProductVariantId
Variant_Code ProductName
Item_No ProductExternalId
Variant_Code ProductExternalVariantId
Item_No ProductId

Import Unit of Measure Translations

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebUnitOfMeasureTranslation)

Predefined mappings

DynamicwebUnitOfMeasureTranslation EcomUnitTranslations
Code UnitTranslationUnitId
Description UnitTranslationName
Language_Code UnitTranslationLanguageId

Import Stock

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebStockKeepingUnitCard)

Predefined mappings

DynamicwebStockKeepingUnitCard EcomStockUnit
Inventory StockUnitQuantity
Item_No StockUnitProductId
Item_No StockUnitProductNumber
Location_Code StockUnitStockLocationId
Item_No StockUnitVariantId
Variant_Code StockUnitVariantId

Import Resources

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebResources)

Predefined mappings

DynamicwebResources EcomProducts
Base_Unit_of_Measure ProductDefaultUnitId
Name ProductName
No ProductNumber
Unit_Cost ProductCost
Unit_Price ProductPrice
Constant: 1 ProductType
No ExternalId

Import Assembly BOM

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /AssemblyBOM)
Destination settings: Select Default Language and Shop

Predefined mappings

AssemblyBOM EcomProductItems
Parent_Item_No ProductItemProductId
No ProductItemBomProductId
Description ProductItemName
Quantity_per ProductItemQuantity
Variant_Code ProductItemBomVariantId
Parent_Item_No ProductItemId
No ProductItemId
Variant_Code ProductItemId

Import Orders

Manual configuration

Source settings: Select Predefined endpoint (V4 general API).

Note

The Import Orders activity maps data from two distinct entities DynamicwebSalesOrder and DynamicwebSalesOrderSalesLines. The predefined endpoint must therefore be the generic v4 API with no entity specified.

Predefined mappings

DynamicwebSalesOrder EcomOrders
Bill_to_Address OrderCustomerAddress
Bill_to_Address_2 OrderCustomerAddress2
Bill_to_City OrderCustomerCity
Bill_to_Country_Region_Code OrderCustomerCountryCode
Bill_to_Post_Code OrderCustomerZip
Currency_Code OrderCurrencyCode
External_Document_No OrderIntegrationOrderId
Language_Code OrderLanguageId
No OrderIntegrationOrderId
Order_Date OrderCompletedDate
Sell_to_Address OrderDeliveryAddress
Sell_to_Address_2 OrderDeliveryAddress2
Sell_to_City OrderDeliveryCity
Sell_to_Country_Region_Code OrderDeliveryCountryCode
Sell_to_Customer_No OrderCustomerAccessUserId
Sell_to_Customer_Name OrderDeliveryName
No OrderId
Sell_to_Customer_No OrderCustomerAccessUserExternalId
Sell_to_E_Mail OrderCustomerEmail
Sell_to_Phone_No OrderCustomerPhone
Sell_to_Post_Code OrderDeliveryZip
SellToMobilePhoneNo OrderCustomerCell
Sell_to_Customer_Name OrderCustomerName
Payment_Discount_Percent OrderDiscountPercentage
Order_Date OrderDate
DynamicwebSalesOrderSalesLines EcomOrderLines
Document_No OrderLineOrderId
Line_Discount_Amount OrderLineTotalDiscountWithoutVAT
Line_Discount_Percent OrderLineDiscountPercentage
No OrderLineProductId
Quantity OrderLineQuantity
Line_Amount OrderLinePriceWithoutVAT
Total_Amount_Incl_VAT OrderLinePriceWithVAT
Total_VAT_Amount OrderLinePriceVAT
Unit_of_Measure OrderLineUnitId
Document_No OrderLineId
Unit_Price OrderLineUnitPrice
Line_No OrderLineId
Variant_Code OrderLineProductVariantId
No OrderLineProductNumber
Variant_Code OrderLineProductName
Unit_Price OrderLineUnitPriceWithoutVAT

Import Prices (Old price experience)

Activity 1 - All customers

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebSalesPrices)

Conditional: Sales_type equalTo "All Customers"

Predefined mappings

DynamicwebSalesPrices EcomPrices
Variant_Code PriceProductVariantId
Starting_Date PriceValidFrom
Ending_Date PriceValidTo
Unit_of_Measure_Code PriceUnitId
Unit_Price PriceAmount
Minimum_Quantity PriceQuantity
Price_Includes_VAT PriceIsWithVat
Item_No PriceProductId
Currency_Code PriceCurrency
Sales_Code PriceExternalId

Activity 2 - Customer

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebSalesPrices)

Conditional: Sales_type equalTo "Customer"

Predefined mappings

DynamicwebSalesPrices3 EcomPrices
Variant_Code PriceProductVariantId
Starting_Date PriceValidFrom
Ending_Date PriceValidTo
Unit_of_Measure_Code PriceUnitId
Unit_Price PriceAmount
Minimum_Quantity PriceQuantity
Price_Includes_VAT PriceIsWithVat
Item_No PriceProductId
Sales_Code PriceUserCustomerNumber
Currency_Code PriceCurrency
Sales_Code PriceExternalId
Sales_Code PriceUserId

Activity 3 - Customer Price Group

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebSalesPrices)

Conditional: Sales_type equalTo "Customer Price Group"

Predefined mappings

DynamicwebSalesPrices3 EcomPrices
Variant_Code PriceProductVariantId
Starting_Date PriceValidFrom
Ending_Date PriceValidTo
Unit_of_Measure_Code PriceUnitId
Unit_Price PriceAmount
Minimum_Quantity PriceQuantity
Price_Includes_VAT PriceIsWithVat
Item_No PriceProductId
Sales_Code (prepend: "Price_") PriceUserGroupId
Currency_Code PriceCurrency
Sales_Code PriceExternalId

Import Discounts (Old price experience)

Activity 1 - All Customers

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebSalesLineDiscounts)

Conditional: SalesType equalTo "All Customers"

Predefined mappings

DynamicwebSalesLineDiscounts EcomDiscount Notes
Variant_Code DiscountProductVariantId
Starting_Date DiscountValidFrom
Ending_Date DiscountValidTo
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
Constant: 2 DiscountType
Constant: 2 DiscountDiscountType
Constant: 2 DiscountProductQuantification
Constant: 1 DiscountApplyToProduct
*Constant: "[some]" DiscountExcludedProductsAndGroups
Constant: "DataIntegration import" DiscountDescription
Code DiscountProductsAndGroups Prepend: "[some][p:"
Variant_Code DiscountProductsAndGroups Append: "]"
Currency_Code DiscountCurrencyCode
Constant: "ERP Import" DiscountExternalId
Code DiscountProductId

Activity 2 - Customer Discount groups

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebSalesLineDiscounts)

Conditional: SalesType equalTo "Customer Disc. Group"

Predefined mappings

DynamicwebSalesLineDiscounts EcomDiscount Notes
Variant_Code DiscountProductVariantId
Starting_Date DiscountValidFrom
Ending_Date DiscountValidTo
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
SalesCode DiscountAccessUserGroup Prepend: "Disc_"
Constant: 2 DiscountType
Constant: 2 DiscountDiscountType
Constant: 2 DiscountProductQuantification
Constant: 1 DiscountApplyToProduct
*Constant: "[some]" DiscountExcludedProductsAndGroups
Constant: "DataIntegration import" DiscountDescription
Code DiscountProductsAndGroups Prepend: "[some][p:"
Variant_Code DiscountProductsAndGroups Append: "]"
Currency_Code DiscountCurrencyCode
Constant: "ERP Import" DiscountExternalId
Code DiscountProductId

Activity 3 - Customer

Manual configuration

Source settings: Select Predefined endpoint (V4 general API or /DynamicwebSalesLineDiscounts)

Conditional: SalesType equalTo "Customer"

Predefined mappings

DynamicwebSalesLineDiscounts EcomDiscount Notes
Variant_Code DiscountProductVariantId
Starting_Date DiscountValidFrom
Ending_Date DiscountValidTo
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
SalesCode DiscountAccessUser
Constant: 2 DiscountType
Constant: 2 DiscountDiscountType
Constant: 2 DiscountProductQuantification
Constant: 1 DiscountApplyToProduct
*Constant: "[some]" DiscountExcludedProductsAndGroups
Constant: "DataIntegration import" DiscountDescription
Code DiscountProductsAndGroups Prepend: "[some][p:"
Variant_Code DiscountProductsAndGroups Append: "]"
Currency_Code DiscountCurrencyCode
Constant: "ERP Import" DiscountExternalId
Code DiscountProductId
SalesCode DiscountAccessUserCustomerNumber

Import Prices & Discounts (New Pricing Experience)

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebSalesPriceList)

Predefined mappings

The predefined mappings for the Prices & Discounts activity contains a total of 16 table mappings: 8 for prices and 8 for discounts. The table mappings each contain conditionals that filter the source according to the AmountType, StartingDate, and EndingDate. The Business Central data does not contain NULL values in the date fields for records with no dates - instead Price and Discount records are equipped with a default date of 0001-01-01, but as the SQL server used by DynamicWeb does not support dates earlier than the year 1753, the source data is filtered to handle the PriceValidFrom and PriceValidTo fields accordingly.

Table 1 - Price type with valid StartingDates and EndingDates
DynamicwebSalesPriceListLines EcomPrices Notes
Variant_Code PriceProductVariantId
StartingDate PriceValidFrom
EndingDate PriceValidTo
Unit_of_Measure_Code PriceUnitId
CurrencyCode PriceCurrency
Minimum_Quantity PriceQuantity
PriceIncludesVAT PriceIsWithVat
Product_No PriceProductId
Unit_Price PriceAmount
AssignToNo PriceAccessUserGroup
AssignToNo PriceAccessUser Prepend: Price_
AssignToNo PriceExternalId Prepend: Price_
Price_List_Code PriceId
Line_No PriceId
Table 2 - Price and discount type with valid StartingDates and EndingDates
DynamicwebSalesPriceListLines EcomPrices Notes
Variant_Code PriceProductVariantId
StartingDate PriceValidFrom
EndingDate PriceValidTo
Unit_of_Measure_Code PriceUnitId
CurrencyCode PriceCurrency
Minimum_Quantity PriceQuantity
PriceIncludesVAT PriceIsWithVat
Product_No PriceProductId
Unit_Price PriceAmount
AssignToNo PriceAccessUserGroup
AssignToNo PriceAccessUser Prepend: Price_
AssignToNo PriceExternalId Prepend: Price_
Price_List_Code PriceId
Line_No PriceId
Table 3 - Price type with invalid StartingDates and EndingDates
DynamicwebSalesPriceListLines EcomPrices Notes
Variant_Code PriceProductVariantId
Unit_of_Measure_Code PriceUnitId
CurrencyCode PriceCurrency
Minimum_Quantity PriceQuantity
PriceIncludesVAT PriceIsWithVat
Product_No PriceProductId
Unit_Price PriceAmount
AssignToNo PriceAccessUserGroup
AssignToNo PriceAccessUser Prepend: Price_
AssignToNo PriceExternalId Prepend: Price_
Price_List_Code PriceId
Line_No PriceId
Table 4 - Price and discount type with invalid StartingDates an EndingDates
DynamicwebSalesPriceListLines EcomPrices Notes
Variant_Code PriceProductVariantId
Unit_of_Measure_Code PriceUnitId
CurrencyCode PriceCurrency
Minimum_Quantity PriceQuantity
PriceIncludesVAT PriceIsWithVat
Product_No PriceProductId
Unit_Price PriceAmount
AssignToNo PriceAccessUserGroup
AssignToNo PriceAccessUser Prepend: Price_
AssignToNo PriceExternalId Prepend: Price_
Price_List_Code PriceId
Line_No PriceId
Table 5 - Price type with valid StartingDate
DynamicwebSalesPriceListLines EcomPrices Notes
Variant_Code PriceProductVariantId
StartingDate PriceValidFrom
Unit_of_Measure_Code PriceUnitId
CurrencyCode PriceCurrency
Minimum_Quantity PriceQuantity
PriceIncludesVAT PriceIsWithVat
Product_No PriceProductId
Unit_Price PriceAmount
AssignToNo PriceAccessUserGroup
AssignToNo PriceAccessUser Prepend: Price_
AssignToNo PriceExternalId Prepend: Price_
Price_List_Code PriceId
Line_No PriceId
Table 6 - Price and discount type with valid StartingDate
DynamicwebSalesPriceListLines EcomPrices Notes
Variant_Code PriceProductVariantId
StartingDate PriceValidFrom
Unit_of_Measure_Code PriceUnitId
CurrencyCode PriceCurrency
Minimum_Quantity PriceQuantity
PriceIncludesVAT PriceIsWithVat
Product_No PriceProductId
Unit_Price PriceAmount
AssignToNo PriceAccessUserGroup
AssignToNo PriceAccessUser Prepend: Price_
AssignToNo PriceExternalId Prepend: Price_
Table 7 - Price type with valid EndingDate
DynamicwebSalesPriceListLines EcomPrices Notes
Variant_Code PriceProductVariantId
EndingDate PriceValidTo
Unit_of_Measure_Code PriceUnitId
CurrencyCode PriceCurrency
Minimum_Quantity PriceQuantity
PriceIncludesVAT PriceIsWithVat
Product_No PriceProductId
Unit_Price PriceAmount
AssignToNo PriceAccessUserGroup Prepend: Price_
AssignToNo PriceAccessUser
AssignToNo PriceExternalId
Price_List_Code PriceId
Line_No PriceId
Table 8 - Price and discount type with valid endingDate
DynamicwebSalesPriceListLines EcomPrices Notes
Variant_Code PriceProductVariantId
EndingDate PriceValidTo
Unit_of_Measure_Code PriceUnitId
CurrencyCode PriceCurrency
Minimum_Quantity PriceQuantity
PriceIncludesVAT PriceIsWithVat
Product_No PriceProductId
Unit_Price PriceAmount
AssignToNo PriceAccessUserGroup Prepend: Price_
AssignToNo PriceAccessUser
AssignToNo PriceExternalId
Price_List_Code PriceId
Line_No PriceId
Table 9 - Discount type with valid Starting and EndingDate
DynamicwebSalesPriceListLines EcomDiscount Notes
Variant_Code DiscountProductVariantId
StartingDate DiscountValidFrom
EndingDate DiscountValidTo
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
Product_No DiscountProductsAndGroups
CurrencyCode DiscountCurrencyCode
Product_No DiscountProductId
DiscountType Constant: 2
DiscountDiscountType Constant: 2
DiscountProductQuantification Constant: 2
DiscountApplyToProduct Constant: 1
DiscountExcludedProductsAndGroups Constant: [some]
Description DiscountDescription
AssignToNo DiscountExternalId
AssignToNo DiscountAccessUserGroup Prepend: Disc_
AssignToNo DiscountAccessUser
PriceIncludesVAT DiscountAmountIncludesVat
Description DiscountName
Table 10 - Price & Discount type with valid StartingDate and EndingDate
DynamicwebSalesPriceListLines EcomDiscount Notes
Variant_Code DiscountProductVariantId
StartingDate DiscountValidFrom
EndingDate DiscountValidTo
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
Product_No DiscountProductsAndGroups
CurrencyCode DiscountCurrencyCode
Product_No DiscountProductId
DiscountType Constant: 2
DiscountDiscountType Constant: 2
DiscountProductQuantification Constant: 2
DiscountApplyToProduct Constant: 1
DiscountExcludedProductsAndGroups Constant: [some]
Description DiscountDescription
AssignToNo DiscountExternalId
AssignToNo DiscountAccessUserGroup Prepend: Disc_
AssignToNo DiscountAccessUser
PriceIncludesVAT DiscountAmountIncludesVat
Description DiscountName
Table 11 - Discount type with invalid StartingDate and EndingDate
DynamicwebSalesPriceListLines EcomDiscount Notes
Variant_Code DiscountProductVariantId
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
Product_No DiscountProductsAndGroups
DiscountProductsAndGroups Prepend: [some][p:
DiscountProductsAndGroups Prepend: ,
DiscountProductsAndGroups Constant: ]
CurrencyCode DiscountCurrencyCode
Product_No DiscountProductId
DiscountType Constant: 2
DiscountDiscountType Constant: 2
DiscountProductQuantification Constant: 2
DiscountApplyToProduct Constant: 1
DiscountExcludedProductsAndGroups Constant: [some]
Description DiscountDescription
AssignToNo DiscountExternalId
AssignToNo DiscountAccessUserGroup Prepend: Disc_
AssignToNo DiscountAccessUser
PriceIncludesVAT DiscountAmountIncludesVat
Description DiscountName
Table 12 - Price & Discount type with invalid StartingDate and EndingDate
DynamicwebSalesPriceListLines EcomDiscount Notes
Variant_Code DiscountProductVariantId
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
Product_No DiscountProductsAndGroups
DiscountProductsAndGroups Prepend: [some][p:
DiscountProductsAndGroups Prepend: ,
DiscountProductsAndGroups Constant: ]
CurrencyCode DiscountCurrencyCode
Product_No DiscountProductId
DiscountType Constant: 2
DiscountDiscountType Constant: 2
DiscountProductQuantification Constant: 2
DiscountApplyToProduct Constant: 1
DiscountExcludedProductsAndGroups Constant: [some]
Description DiscountDescription
AssignToNo DiscountExternalId
AssignToNo DiscountAccessUserGroup Prepend: Disc_
AssignToNo DiscountAccessUser
PriceIncludesVAT DiscountAmountIncludesVat
Description DiscountName
Table 13 - Discount type with valid StartingDate
DynamicwebSalesPriceListLines EcomDiscount Notes
Variant_Code DiscountProductVariantId
StartingDate DiscountValidFrom
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
Product_No DiscountProductsAndGroups
DiscountProductsAndGroups Prepend: [some][p:
DiscountProductsAndGroups Prepend: ,
DiscountProductsAndGroups Constant: ]
CurrencyCode DiscountCurrencyCode
Product_No DiscountProductId
DiscountType Constant: 2
DiscountDiscountType Constant: 2
DiscountProductQuantification Constant: 2
DiscountApplyToProduct Constant: 1
DiscountExcludedProductsAndGroups Constant: [some]
Description DiscountDescription
AssignToNo DiscountExternalId
AssignToNo DiscountAccessUserGroup Prepend: Disc_
AssignToNo DiscountAccessUser
PriceIncludesVAT DiscountAmountIncludesVat
Description DiscountName
Table 14 - Price & Discount type with valid StartingDate
DynamicwebSalesPriceListLines EcomDiscount Notes
Variant_Code DiscountProductVariantId
StartingDate DiscountValidFrom
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
Product_No DiscountProductsAndGroups
DiscountProductsAndGroups Prepend: [some][p:
DiscountProductsAndGroups Prepend: ,
DiscountProductsAndGroups Constant: ]
CurrencyCode DiscountCurrencyCode
Product_No DiscountProductId
DiscountType Constant: 2
DiscountDiscountType Constant: 2
DiscountProductQuantification Constant: 2
DiscountApplyToProduct Constant: 1
DiscountExcludedProductsAndGroups Constant: [some]
Description DiscountDescription
AssignToNo DiscountExternalId
AssignToNo DiscountAccessUserGroup Prepend: Disc_
AssignToNo DiscountAccessUser
PriceIncludesVAT DiscountAmountIncludesVat
Description DiscountName
Table 15 - Discount type with valid EndingDate
DynamicwebSalesPriceListLines EcomDiscount Notes
Variant_Code DiscountProductVariantId
EndingDate DiscountValidTo
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
Product_No DiscountProductsAndGroups
DiscountProductsAndGroups Prepend: [some][p:
DiscountProductsAndGroups Prepend: ,
DiscountProductsAndGroups Constant: ]
CurrencyCode DiscountCurrencyCode
Product_No DiscountProductId
DiscountType Constant: 2
DiscountDiscountType Constant: 2
DiscountProductQuantification Constant: 2
DiscountApplyToProduct Constant: 1
DiscountExcludedProductsAndGroups Constant: [some]
Description DiscountDescription
AssignToNo DiscountExternalId
AssignToNo DiscountAccessUserGroup Prepend: Disc_
AssignToNo DiscountAccessUser
PriceIncludesVAT DiscountAmountIncludesVat
Description DiscountName
Table 16 - Price & Discount type with valid EndingDate
DynamicwebSalesPriceListLines EcomDiscount Notes
Variant_Code DiscountProductVariantId
EndingDate DiscountValidTo
Line_Discount_Percent DiscountPercentage
Minimum_Quantity DiscountProductQuantity
Product_No DiscountProductsAndGroups
DiscountProductsAndGroups Prepend: [some][p:
DiscountProductsAndGroups Prepend: ,
DiscountProductsAndGroups Constant: ]
CurrencyCode DiscountCurrencyCode
Product_No DiscountProductId
DiscountType Constant: 2
DiscountDiscountType Constant: 2
DiscountProductQuantification Constant: 2
DiscountApplyToProduct Constant: 1
DiscountExcludedProductsAndGroups Constant: [some]
Description DiscountDescription
AssignToNo DiscountExternalId
AssignToNo DiscountAccessUserGroup Prepend: Disc_
AssignToNo DiscountAccessUser
PriceIncludesVAT DiscountAmountIncludesVat
Description DiscountName

Activities and mappings - exports

Export countries

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebCountries)

Predefined mappings

EcomCountries DynamicwebCountries
CountryCode2 Code
CountryNumber ISO_Numeric_Code

Export AccessUsers - Employees

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebSalespersonPuchaserCard)

Predefined mappings

AccessUser DynamicwebSalespersonPuchaserCard
AccessUserExternalId Code
AccessUserEmail E_Mail
AccessUserJobTitle Job_Title
AccessUserName Name
AccessUserPhone Phone_No

Export AccessUsers - Contacts

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebContactCard)

Predefined mappings

AccessUser DynamicwebContactCard
AccessUserAddress Address
AccessUserAddress2 Address_2
AccessUserCity City
AccessUserCompany Company_Name
AccessUserCountryCode Country_Region_Code
AccessUserCurrencyCharacter Currency_Code
AccessUserCustomerNumber IntegrationCustomerNo
AccessUserEmail E_Mail
AccessUserExternalId No
AccessUserFax Fax_No
AccessUserMobile Mobile_Phone_No
AccessUserName Name
AccessUserPhone Phone_No
AccessUserZip Post_Code

Export AccessUsers - customers

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebCustomerCard)

Predefined mappings

AccessUser DynamicwebCustomerCard
AccessUserAddress Address
AccessUserAddress2 Address_2
AccessUserCity City
AccessUserCountryCode Country_Region_Code
AccessUserCurrencyCharacter Currency_Code
AccessUserEmail E_Mail
AccessUserExternalId No
AccessUserFax Fax_No
AccessUserMobile MobilePhoneNo
AccessUserName Name
AccessUserPhone Phone_No
AccessUserZip Post_Code

Export user addresses

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebAltAddressCard)

Predefined mappings

AccessUserAddress DynamicwebAltAddressCard
AccessUserAddressAddress Address
AccessUserAddressAddress2 Address_2
AccessUserAddressCell Mobile_Phone_No
AccessUserAddressCity City
AccessUserAddressCompany Company_Name
AccessUserAddressCountryCode Country_Region_Code
AccessUserAddressEmail E_Mail
AccessUserAddressFax Fax_No
AccessUserAddressName Code
AccessUserAddressPhone Phone_No
AccessUserAddressZip Post_Code

Export vendors

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebVendorCard)

Predefined mappings

EcomManufacturers DynamicwebVendorCard
ManufacturerAddress Address
ManufacturerCity City
ManufacturerCountry Country_Region_Code
ManufacturerEmail E_Mail
ManufacturerFax Fax_No
ManufacturerId No
ManufacturerName Name
ManufacturerPhone Phone_No
ManufacturerWeb Home_Page
ManufacturerZipCode Post_Code

Export item categories

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebItemCategoryCard)

Predefined mappings

EcomGroups DynamicwebItemCategoryCard
GroupId Code
GroupName Description
EcomGroupRelations DynamicwebItemCategoryCard
GroupRelationsGroupId Code
GroupRelationsParentId Parent_Category

Export items

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebItemCard)

Predefined mappings

Table 1 - Product type 0
EcomProducts DynamicwebItemCard
PrimaryGroup Item_Category_Code
ProductActive Blocked
ProductCost Unit_Cost
ProductDefaultUnitId Base_Unit_of_Measure
ProductEAN GTIN
ProductManufacturerId Vendor_No
ProductName Description
ProductExternalId No
ProductPrice Unit_Price
ProductPurchaseMinimumQuantity Minimum_Order_Quantity
ProductVolume Unit_Volume
ProductWeight Gross_Weight
Table 2 - Product type 2
EcomProducts DynamicwebItemCard
PrimaryGroup Item_Category_Code
ProductActive Blocked
ProductCost Unit_Cost
ProductDefaultUnitId Base_Unit_of_Measure
ProductEAN GTIN
ProductManufacturerId Vendor_No
ProductName Description
ProductExternalId No
ProductPrice Unit_Price
ProductPurchaseMinimumQuantity Minimum_Order_Quantity
ProductVolume Unit_Volume
ProductWeight Gross_Weight

Export item variants

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebItemVariants)

Predefined mappings

EcomProducts DynamicwebItemVariants Notes
No
ProductExternalId Item_No
ProductExternalVariantId Code
ProductShortDescription Description

Export Units of measure

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebUnitsOfMeasure)

Predefined mappings

EcomUnitTranslations DynamicwebUnitsOfMeasure Notes
UnitTranslationUnitId Code
UnitTranslationName Description

Export item units

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebItemUnits)

Predefined mappings

EcomStockUnit DynamicwebItemUnits Notes
StockUnitDepth Length
StockUnitHeight Height
StockUnitId Code
StockUnitProductId Item_No
StockUnitQuantity Qty_per_Unit_of_Measure
StockUnitWeight Weight
StockUnitWidth Width

Export Unit of measure translations

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebUnitOfMeasureTranslation)

Predefined mappings

EcomUnitTranslations DynamicwebUnitOfMeasureTranslation Notes
UnitTranslationUnitId Code
UnitTranslationLanguageId Language_Code
UnitTranslationName Description

Export Stock

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /DynamicwebStockKeepingUnitCard)

Predefined mappings

EcomStockUnit DynamicwebStockKeepingUnitCard Notes
StockUnitProductId Item_No
StockLocationName Location_Code
ProductName Variant_Code

Export Assembly BOM

Manual configuration

Destination settings: Select Destination endpoint (V4 general API or /AssemblyBOM)

Predefined mappings

EcomProductItems AssemblyBOM Notes
ProductItemProductId Parent_Item_No
ProductItemBomProductId No
ProductItemBomVariantId Variant_Code
ProductItemName Description
ProductItemQuantity Quantity_per

Export Orders

Manual configuration

Destination settings: Select Destination endpoint (V4 general API)

Note

The Export Orders activity maps data to two distinct entities DynamicwebSalesOrder and DynamicwebSalesOrderSalesLines. The predefined endpoint must therefore be the generic v4 API with no entity specified.

Predefined mappings

Table 1 - Orders
EcomOrders DynamicwebSalesOrder Notes
OrderCurrencyCode Currency_Code
Constant: "Order"
Constant: "Default (Sell-to Address)" ShippingOptions
Constant: "Default (Customer)" BillToOptions
OrderCustomerName Sell_to_Customer_Name
OrderDeliveryAddress Sell_to_Address
OrderDeliveryAddress2 Sell_to_Address_2
OrderDeliveryCity Sell_to_City
OrderDeliveryCountryCode Sell_to_Country_Region_Code
OrderCustomerEmail Sell_to_E_Mail
OrderCustomerPhone Sell_to_Phone_No
OrderDeliveryZip Sell_to_Post_Code
OrderDiscountPercentage Payment_Discount_Percent
OrderId External_Document_No
OrderLanguageId Language_Code
Table 2 - Order lines
EcomOrderLines DynamicwebSalesOrderSalesLines Notes
Constant: "Order" Document_Type
OrderLineAutoId Line_No
Constant: "Item" Type
OrderLineDiscountPercentage Line_Discount_Percent
OrderIntegrationOrderId Document_No
OrderLinePriceVAT Total_VAT_Amount
OrderLinePriceWithoutVAT Line_Amount
OrderLinePriceWithVAT Total_Amount_Incl_VAT
OrderLineProductId No
OrderLineProductName Variant_Code
OrderLineQuantity Quantity
OrderLineTotalDiscountWithoutVAT Line_Discount_Amount
OrderLineUnitId Unit_of_Measure
OrderLineUnitPrice Unit_Price
To top