Business Central codeunit mappings
The following article contains an overview of how Business Central data is mapped to Dynamicweb in the Business Central plug-in unit. The overview is divided into sections for each relevant table in the Dynamicweb database. The specific data fields of Business Central are marked in bold in the tables below.
Importing data to Dynamicweb
Each section below shows a Dynamicweb entity (e.g. EcomProducts) and a list of the Business Central entities relevant for the entity. The mapping tables show a Dynamicweb field and it's corresponding data source. The source may be a direct mapping with a Business Central data field, a simple inputted string or a calculated variable.
AccessUserGroup
Customers:
Dynamicweb destination field |
Source/value |
AccessUserGroupName |
“Customers” |
AccessGroupName |
“Customers” |
Salespersons:
Dynamicweb destination field | Source/value |
AccessUserGroupName |
“Sales” |
AccessGroupName |
“Sales” |
AccessUser
AccesUserGroupName: Customers
Imports data from the following Business Central tables:
- Table 18 Customer
- Table 5050 Contact
- Table 5054 Contact Business Relation (ContactBusiness)
- table 98 "General Ledger Setup" (glsetup)
Dynamicweb destination field | Source/Value |
AccessUserUserName |
Contact.”E-Mail” |
AccessUserExternalID |
Contact.”No.” |
AccessUserCustomerNumber |
“ContactBusiness.”No.” |
AccessUserName |
Contact.”Name” |
AccessUserEmail |
Contact.”Email” |
AccessUserPhone |
Customer.”Phone No.” |
AccessUserFax |
Customer.”Fax No.” |
AccessUserAddress |
Customer.”Address” |
AccessUserAddress2 |
Customer.”Address 2” |
AccessUserZip |
Customer.”Post Code” |
AccessUserCity |
Customer.”City” |
AccessUserCountry |
Customer.”Country/Region Code” |
AccessUserCountryCode |
Customer.”Country/Region Code” |
AccessUserAddressTitle |
“Company address” |
AccessUserCompany |
Contact.”Company Name” |
AccessUserCurrencyCharacter |
Customer.”Currency Code” or glsetup.”LCY Code” |
AccessUserActive |
“true” |
AccessUserWeb |
Contact.”Home Page” |
AccessUserGroups |
“Customers” |
AccessUserGroupName: Sales
Imports data from the following Business Central tables:
- Table 13 “Salesperson/Purchaser” (SalesPerson)
AccessUserUserName |
SalesPerson.”E-Mail” |
AccessUserExternalID |
SalesPerson.”Code” |
AccessUserCustomerNumber |
SalesPerson.”Code” |
AccessUserName |
SalesPerson.”Name |
AccessUserEmail |
SalesPerson.”Email” |
AccessUserPhone |
SalesPerson.”Phone No.” |
AccessUserFax |
”” |
AccessUserAddress |
”” |
AccessUserAddress2 |
”” |
AccessUserZip |
”” |
AccessUserCity |
”” |
AccessUserCountry |
”” |
AccessUserCountryCode |
”” |
AccessUserAddressTitle |
“” |
AccessUserCompany |
”” |
AccessUserCurrencyCharacter |
”” |
AccessUserActive |
“true” |
AccessUserWeb |
”” |
AccessUserGroups |
“Sales” |
AccessUserSecondaryRelation
Imports data from the following Business Central tables:
- Table 18 customer
- Table 5050 Contact
- Table 13 “Salesperson/Purchaser” (Salesperson)
- Table 5054 Contact Business Relation
AccessUserSecondaryRelationId |
SalesPerson.”Code” |
AccessUserSecondaryRelationSecondaryUserId |
Contact.”No.” or Customer.”No.” |
AccessUserAddress
Imports data from the following Business Central tables:
- Table 222 “Ship-to Address” (addresses)
- table 5051 "Contact Alt. Address"
- table 5050 Contact
- table 5054 "Contact Business Relation" (ContactBusiness)
- table 18 Customer
Contact address:
If Contact.”Company Name” = Customer.Name:
Dynamicweb destination field |
Source |
AccessUserAddressUserID |
Contact.”No.” |
AccessUserAddressType |
“1” |
AccessUserAddressCallName |
“Contact Address” |
AccessUserAddressCompany |
Contact.”Company Name” |
AccessUserAddressName |
“Contact Address” |
AccessUserAddressAddress |
Contact.”Address” |
AccessUserAddressAddress2 |
Contact.”Address 2” |
AccessUserAddressZip |
Contact.”Post Code” |
AccessUserAddressCity |
Contact.”City” |
AccessUserAddressCountry |
Contact."Country/Region Code" |
AccessUserAddressCell |
Contact.”Mobile Phone No.” |
AccessUserAddressFax |
Contact.”Fax No.” |
AccessUserAddressEmail |
Contact.”E-mail” |
AccessUserAddressCustomerNumber |
ContactBusiness.”No.” |
AccessUserAddressUID |
Contact.”No.” + “_ContactAddress” |
AccessUserAddressState |
Contact."Country/Region Code" |
AccessUserAddressPhoneBusiness |
Contact."Phone No." |
AccessUserAddressCountryCode |
Contact."Country/Region Code" |
AccessUserAddressDefaultAddressCustomFields |
“False” |
Contact alt address:
Dynamicweb destination field |
Source |
AccessUserAddressUserID |
ContactAltAddress.”No.” |
AccessUserAddressType |
“1” |
AccessUserAddressCallName |
ContactAltAddress.”Code” |
AccessUserAddressCompany |
Contact.”Company Name” |
AccessUserAddressName |
ContactAltAddress.”Code” |
AccessUserAddressAddress |
ContactAltAddress.”Address” |
AccessUserAddressAddress2 |
ContactAltAddress.”Address2” |
AccessUserAddressZip |
ContactAltAddress.”Post Code” |
AccessUserAddressCity |
ContactAltAddress.”City” |
AccessUserAddressCountry |
ContactAltAddress."Country/Region Code" |
AccessUserAddressCell |
ContactAltAddress.”Mobile Phone No.” |
AccessUserAddressFax |
ContactAltAddress.”Fax No.” |
AccessUserAddressEmail |
ContactAltAddress.”E-mail” |
AccessUserAddressCustomerNumber |
ContactBusiness.”No.” |
AccessUserAddressUID |
ContactAltAddress.”Contact No.” + “_” + ContactAltAddress.”Code” |
AccessUserAddressState |
ContactAltAddress."Country/Region Code" |
AccessUserAddressPhoneBusiness |
ContactAltAddress."Phone No." |
AccessUserAddressCountryCode |
ContactAltAddress."Country/Region Code" |
AccessUserAddressDefaultAddressCustomFields |
“False” |
Ship-to addresses:
Dynamicweb destination field |
Source |
AccessUserAddressUserId |
Contact.”No.” |
AccessUserAddressCompany |
Contact.”Company Name” |
AccessUserAddressCustomerNumber |
ContactBusiness.”No.” |
AccessUserAddressUID |
Customer.”No. + “_” + Adresses.”Code” |
EcomCountries
Imports data from the following Business Central tables:
- Table 9 Country/Region
Dynamicweb destination field |
Source |
CountryCode2 |
Country/Region.”Code” |
CountryCultureInfo |
Country/Region.”Code” |
EcomCountryText
Imports data from the following Business Central tables:
- Table 9 Country/Region
Dynamicweb destination field |
Source |
CountryTextCode2 |
Country/Region.”Code” |
CountryTextLanguageId |
DefaultLanguageId (parsed parameter) |
CountryTextName |
Country/Region.”Name” |
EcomCurrencies
Imports data from the following Business Central tables:
- Table 4 Currency
- Table 98 General Ledger Setup
Dynamicweb destination field |
Source |
CurrencyCode |
Currency.”Code” |
CurrencyName |
Currency.”Description” |
CurrencyLanguageID |
Method: GetUserLanguageCode() from codeunit “Language” |
CurrencyRate |
Calculated exchange rate |
IsLCY |
Evaluates if Currency.”Code” is equal toGeneral ledger LCY code (true/false) |
If general ledger currency does not exist in “Currency” table:
Dynamicweb destination field |
Source |
CurrencyCode |
glsetup.”LCY Code” |
CurrencyName |
“Local” |
CurrencyLanguageID |
Method: GetUserLanguageCode() from codeunit “Language” |
CurrencyRate |
100 |
IsLCY |
True |
EcomLanguages
Imports data from the following Business Central tables:
- Table 8 Languages
Dynamicweb destination field |
Source |
LanguageID |
Languages.”Code” |
LanguageCode2 |
Languages.”Code” |
LanguageName |
Languages.”Name” |
EcomManufacturers
Imports data from the following Business Central tables:
- Table 23 Vendor
Dynamicweb destination field |
Source |
ManufacturerID |
Vendor.”No.” |
ManufacturerName |
Vendor.”Name” |
ManufacturerAddress |
Vendor.”Address” |
ManufacturerZipCode |
Vendor.”Post Code” |
ManufacturerCity |
Vendor.”City” |
ManufacturerCountry |
Vendor.”Country/Region Code” |
ManufacturerPhone |
Vendor.”Phone No.” |
ManufacturerFax |
Vendor.”Fax No.” |
ManufacturerEmail |
Vendor.”E-Mail” |
ManufacturerWeb |
Vendor.”Home Page” |
EcomStockLocation
Imports data from the following Business Central tables:
- Table 14 Location
Dynamicweb destination field |
Source |
StockLocationId |
Sets ID as Last ID + 1 |
StockLocationName |
Location.”Code” |
StockLocationDescription |
If not empty: Location.”Name” else: Location.”Code” |
StockLocationLangaugeId |
DefaultLanguageId (parsed param) |
StockLocationGroupId |
Sets ID as Last ID + 1 |
EcomStockUnit
Imports data from the following Business Central tables:
- Table 27 item
Dynamicweb destination field |
Source |
StockUnitProductId |
Item.”No.” |
StockUnitVariantId |
‘’ |
StockUnitId |
“Unit_” + item. “Base Unit Of Measure” |
StockUnitQuantity |
Item.“Inventory” |
StockUnitStockLocationId |
LocationId (last ID + 1) |
EcomProducts
Imports data from the following Business Central tables:
- Table 27 Item
- Table 32 “Item Ledger Entry”
- table 5401 "Item Variant"
- table 30 "Item Translation"
- table 7501 "Item Attribute Value"
- table 7505 "Item Attribute Value Mapping"
- table 4 Currency
Dynamicweb destination field |
Source |
ProductID |
item.”No.” |
ProductVariantID |
itemvariants.”Code” or “” if variant is empty. |
ProductNumber |
item.”No.” |
ProductStock |
If variant: itemLedgerEntry.”Quantity” else: tem.”Inventory” |
ProductPrice |
Item Base Unit price. If Live integration GetProductInfo request: the lowest price for the current customer |
ProductPriceBefore |
Item Base Unit price |
ProductLanguageID |
If language is parsed: language else: GetUserLanguageCode (method) |
ProductName |
Description1 (parsed int parameter) or if variant is empty: item.”Description” else itemvariants.”Description” |
ProductShortDescription |
Description2 (parsed parameter) |
ProductStock |
If variant not empty: itemLedgerEntry.”Inventory” else item.”Inventory” |
ProductWeight |
item."Net Weight" |
ProductVolume |
item."Unit Volume" |
ProductManufacturerID |
item."Vendor No." |
ProductActive |
Boolean: item.”blocked” (false/true) |
ProductVariantCounter |
Counts number of variants |
ProductDefaultUnitID |
“Unit_” + item.”Base Unit of Measure” |
ProductEAN |
itemIdentifier.”Code” or item.”Identifier Code” |
ProductIdentifier |
Fetched text from XML node “ProductIdentifier” |
ProductCurrencyCode |
Currency.”Code” |
ProductPriceWithVat |
Price With VAT |
EcomVariantGroups
Imports data from the following Business Central tables:
- Table 8 Language
Dynamicweb destination field |
Source |
VariantGroupID |
NavUnits |
VariantGroupLanguageID |
Language.”Code”. If there is no language in BC: ‘’ |
VariantGroupName |
“DW_units” |
VariantGroupLabel |
“” |
VariantGroupUnit |
“true” |
EcomVariantOptions
Imports data from the following Business Central tables:
- Table 204 Unit of Measure
- Table 5402 Unit of Measure Translation (unitofmeasuretranslation)
Dynamicweb destination field |
Source |
VariantOptionId |
“Unit_” + UnitofMeasure.”Code” |
VariantOptionLanguageID |
DefaultLangaugeId or unitofmeasuretranslation.”Language Code” |
VariantOptionGroupID |
“NavUnits” |
VartiantOptionName |
UnitofMeasure.”Description” or unitofmeasuretranslation.”Description” |
EcomPrices
Imports data from the following Business Central tables:
- table 5404 "Item Unit of Measure" (itemUOM)
- table 18 Customer
- table 27 Item
- table 7001 "Price List Line"
- table 5401 "Item Variant"
Dynamicweb destination field |
Source |
PriceId |
Id generated from composing itemNo, variant, language, currency, quantity, startDate, uom, salesCode and salesType |
PriceProductId |
Item.”No” |
PriceProductVariantId |
itemvariants.”Code” or if empty: “” |
PriceProductLanguageId |
Language |
PriceCurrency |
LCYCore (parsed parameter) orPriceListLine.”Currency Code” |
PriceAmount |
PriceListLine."Unit Price" |
PriceUnitId |
“Unit_” + itemUOM.”Code” |
PriceValidFrom |
“” or PriceListLine."Starting Date" |
PriceValidTo |
“” or PriceListLine."Ending Date" |
PriceIsInformative |
Boolean |
PriceUserCustomerNumber |
Customer.”No.” |
PriceQuantity |
itemUOM.”Qty. per Unit of Measure” orPriceListLine."Minimum Quantity" |
PriceUnitId |
Item Unit of Measure |
EcomGroupProductRelation
Imports data from the following Business Central tables:
- table 27 Item
If item has an “Item category code”:
Dynamicweb destination field |
Source |
GroupProductRelationGroupID |
item.”Item Category Code” |
GroupProductRelationProductID |
item.”No.” |
GroupProductRelationIsPrimary |
“True” |
EcomGroups
Imports data from the following Business Central tables:
- table 5722 "Item Category"
Dynamicweb destination field |
Source |
GroupID |
ItemCategory.”Code” |
GroupLanguageID |
setLanguage (parsed parameter) orlanguageId |
GroupName |
ItemCategory.”Description” or if empty: ItemCategory.”Code” or ItemCategory.”Code” + ”_” + languageId + “_” + “NotTranslated” |
GroupInheritCategoryFieldsFromParent |
“true” |
EcomShopGroupRelation
Imports data from the following Business Central tables:
- table 5722 "Item Category"
Dynamicweb destination field |
Source |
ShopGroupShopID |
shopId (parsed parameter) |
ShopGroupGroupID |
ItemCategory.”Code” |
EcomGroupRelations
Imports data from the following Business Central tables:
- table 5722 "Item Category"
If ItemCategory.”Parent Category” is not empty:
Dynamicweb destination field |
Source |
GroupRelationGroupID |
ItemCategory.”Code” |
GroupRelationParentID |
ItemCategory.”Parent Category” |
GroupRelationsSorting |
ItemCategory.”Presentation Order” – ItemCategory.”Indentation” |
EcomGroupProductRelation
Imports data from the following Business Central tables:
- table 27 Item
Products request:
Dynamicweb destination field |
Source |
GroupProductRelationGroupID |
GroupId (from request) |
GroupProductRelationProductID |
item No |
GroupProductRelationIsPrimary |
True |
ProductsGroups request:
Dynamicweb destination field |
Source |
GroupProductRelationGroupID |
item."Item Category Code" |
GroupProductRelationProductID |
item No |
GroupProductRelationIsPrimary |
True |
EcomShopGroupRelation
Imports data from the following Business Central tables:
- table 5722 "Item Category"
Dynamicweb destination field |
Source |
ShopGroupShopID |
shopId (parsed parameter) |
ShopGroupGroupID |
ItemCategory.”Code” |
EcomProductCategory
Dynamicweb destination field |
Source |
CategoryId |
“ImportedNAVItemAttributes” |
CategoryType |
“1” |
CategoryProductProperties |
“true” |
EcomProductCategoryTranslation
Dynamicweb destination field |
Source |
CategoryTranslationCategoryId |
“ImportedNAVItemAttributes” |
CategoryTranslationLanguageId |
setLanguage (parsed param) or language (parsed for each lang in langList) |
CategoryTranslationCategoryName |
“Imported NAV Item Attributes” |
EcomProductCategoryField
Imports data from the following Business Central tables:
- table 7500 "Item Attribute"
- table 7501 "Item Attribute Value"
Dynamicweb destination field |
Source |
FieldId |
ItemCategoryCode + “_” + ItemAttributes.”ID” |
FieldCategoryId |
ItemCategoryCode |
FieldTemplateTag |
ItemCategoryCode + “_” + ItemAttributes.ID |
FieldType |
“1” (text) or “6” (int) or “7” (decimal) or “15” (option) if empty Fieldtype is set to “1” |
FieldDefaultValue |
ItemAttributeValues.”ID” or ItemAttributeValues.”Value” or “” |
FieldPresentationType |
“1” |
FieldDoNotRender |
“false” |
FieldHideEmpty |
“false” |
EcomProductCategoryFieldTranslation
Imports data from the following Business Central tables:
- table 7500 "Item Attribute"
- table 7503 "Item Attr. Value Translation"
FieldTranslationFieldId |
ItemCategoryCode + “_” + ItemAttributes.”ID” |
FieldTranslationFieldCategoryId |
ItemCategoryCode |
FieldTranslationLanguageId |
languageId (parsed param) |
FieldTranslationFieldLabel |
ItemAttributeTranslation.”Name” or ItemAttributes.”Name” |
EcomFieldOption
Imports data from the following Business Central tables:
- table 7500 "Item Attribute"
- table 7501 "Item Attribute Value"
FieldOptionId |
ItemCategoryCode + “_” + ItemAttributes.”ID” + “_” + ItemAttributeValues.”ID” |
FieldOptionFieldId |
ItemCategoryCode + “_” + ItemAttributes.”ID” |
FieldOptionName |
ItemAttributeValues.”Value” |
FieldOptionValue |
ItemAttributeValues.”ID” |
FieldTranslationFieldOptions |
Composed string representing default options |
EcomFieldOptionTranslation
Imports data from the following Business Central tables:
- table 7500 "Item Attribute"
- table 7501 "Item Attribute Value"
- table 7503 "Item Attr. Value Translation"
EcomFieldOptionTranslationOptionID |
ItemCategoryCode + “_” + ItemAttributes.”ID” + “_” + ItemAttributeValues.”ID” |
EcomFieldOptionTranslationLanguageID |
setLanguage (parsed parameter) |
EcomFieldOptionTranslationName |
ItemAttributeValues.”Value” |
EcomFieldOptionTranslationOptionID |
ItemCategoryCode + “_” + ItemAttributes.”ID” + “_” + ItemAttributeValueTranslation.”ID” |
EcomFieldOptionTranslationLanguageID |
ItemAttributeValueTranslation."Language Code" |
EcomFieldOptionTranslationName |
ItemAttributeValueTranslation.”Name” |
EcomProductCategoryFieldValue
Imports data from the following Business Central tables:
- table 7500 "Item Attribute"
- table 7501 "Item Attribute Value"
- table 7505 "Item Attribute Value Mapping"
FieldValueFieldId |
itemCategoryCode + “_” + ItemAttributeValueMapping."Item Attribute ID" |
FieldValueFieldCategoryId |
itemCategoryCode |
FieldValueProductId |
ItemAttributeValueMapping."No." |
FieldValueProductVariantId |
“” |
FieldValueProductLanguageId |
setLanguage (parsed parameter) |
'FieldValueValue' |
ItemAttributeValues.”ID” or ItemAttributeValues.”Value” |
EcomOrders
Function AddSalesHeader
Imports data from the following Business Central tables:
- table 36 "Sales Header"
All table fields for orders that are not from the Customer Center are added with a prefix of “Order”.
Prefix + Id |
Salesheader.”No.” |
Prefix + CurrencyCode |
salesheader."Currency Code" |
Prefix + Date |
salesheader."Order Date" |
Prefix + PaymentMethod |
salesheader."Payment Method Code" |
Prefix + CustomerName |
salesheader."Sell-to Customer Name" |
Prefix + CustomerAddress |
salesheader."Sell-to Address" |
Prefix + CustomerAddress2 |
salesheader."Sell-to Address 2" |
Prefix + CustomerCity |
salesheader."Sell-to City" |
Prefix + CustomerCountryCode |
salesheader."Sell-to Country/Region Code" |
Prefix + CustomerEmail |
“” |
Prefix + CustomerFax |
“” |
Prefix + CustomerPhone |
“” |
Prefix + CustomerZip |
salesheader."Ship-to Post Code" |
Prefix + DeliveryName |
salesheader."Ship-to Name" |
Prefix + DeliveryAddress |
salesheader."Ship-to Address" |
Prefix + DeliveryAddress2 |
salesheader."Ship-to Address 2" |
Prefix + DeliveryCity |
salesheader."Ship-to City" |
Prefix + DeliveryCountryCode |
salesheader."Ship-to Country/Region Code" |
Prefix + DeliveryEmail |
“” |
Prefix + DeliveryFax |
“” |
Prefix + DeliveryPhone |
“” |
Prefix + DeliveryZip |
salesheader."Ship-to Post Code" |
Prefix + PriceWIthVat |
Order Price With VAT |
Prefix + PriceWithoutVat |
Order Price Without VAT |
Prefix + PriceVat |
Order Price VAT |
Prefix + SalesDiscount |
Order Sales Discount |
Function AddSalesCrMemoheader
Imports data from the following Business Central tables:
- table 114 "Sales Cr.Memo Header" (salescrmemoheader)
Id |
Salescrmemoheader.”No.” |
CurrencyCode |
salescrmemoheader."Currency Code" |
PaymentMethodName |
salescrmemoheader."Payment Method Code" |
ShippingMethodName |
salescrmemoheader."Shipment Method Code" |
CustomerName |
salescrmemoheader."Sell-to Customer Name" |
CustomerAddress |
salescrmemoheader."Sell-to Address" |
CustomerAddress2 |
salescrmemoheader."Sell-to Address 2" |
CustomerCity |
salescrmemoheader."Sell-to City" |
CustomerCountryCode |
salescrmemoheader."Sell-to Country/Region Code" |
CustomerEmail |
“” |
CustomerFax |
“” |
CustomerPhone |
“” |
CustomerZip |
salescrmemoheader."Ship-to Post Code" |
DeliveryName |
salescrmemoheader."Ship-to Name" |
DeliveryAddress |
salescrmemoheader."Ship-to Address" |
DeliveryAddress2 |
salescrmemoheader."Ship-to Address 2" |
DeliveryCity |
salescrmemoheader."Ship-to City" |
DeliveryCountryCode |
salescrmemoheader."Ship-to Country/Region Code" |
DeliveryEmail |
“” |
DeliveryFax |
“” |
DeliveryPhone |
“” |
DeliveryZip |
salescrmemoheader."Ship-to Post Code" |
PriceWIthVat |
OrderPriceWithVAT |
PriceWithoutVat |
OrderPriceWithoutVAT |
PriceVat |
OrderPriceVAT |
SalesDiscount |
OrderSalesDiscount |
Function AddSalesInvHeader
Imports data from the following Business Central tables:
- table 112 "Sales Invoice Header" (salesInvheader)
Id |
SalesInvheader.”No.” |
CurrencyCode |
salesInvheader."Currency Code" |
Date |
salesInvheader."Order Date" |
PaymentMethodName |
salesInvheader."Payment Method Code" |
ShippingMethodName |
salesInvheader."Shipment Method Code" |
CustomerName |
salesInvheader."Sell-to Customer Name" |
CustomerAddress |
salesInvheader."Sell-to Address" |
CustomerAddress2 |
salesInvheader."Sell-to Address 2" |
CustomerCity |
salesInvheader."Sell-to City" |
CustomerCountryCode |
salesInvheader."Sell-to Country/Region Code" |
CustomerEmail |
“” |
CustomerFax |
“” |
CustomerPhone |
“” |
CustomerZip |
salesInvheader."Ship-to Post Code" |
DeliveryName |
salesInvheader."Ship-to Name" |
DeliveryAddress |
salesInvheader."Ship-to Address" |
DeliveryAddress2 |
salesInvheader."Ship-to Address 2" |
DeliveryCity |
salesInvheader."Ship-to City" |
DeliveryCountryCode |
salesInvheader."Ship-to Country/Region Code" |
DeliveryEmail |
“” |
DeliveryFax |
“” |
DeliveryPhone |
“” |
DeliveryZip |
salesInvheader."Ship-to Post Code" |
PriceWithVAT |
OrderPriceWithVAT |
PriceWithoutVAT |
OrderPriceWithoutVAT |
PriceVAT |
OrderPriceVAT |
SalesDiscount |
OrderSalesDiscount |
ShippingFee |
“” |
EcomOrderLines
Function AddSalesLine
Imports data from the following Business Central tables:
- table 37 "Sales Line"
- table 36 "Sales Header"
All table field names for order lines that are not from the Customer Center are added with a prefix of “OrderLine”.
Some field names are also added with either an idPrefix (“Id”) or a VatPrefix (“Vat”) if the cancelAdd parameter is not set to true.
Prefix + ProductNumber |
salesLine.”No.” |
Prefix + ProductVariant + idPrefix |
salesLine."Variant Code" |
Prefix + UnitId* |
“Unit_” + salesLine."Unit of Measure Code" |
Prefix + ParentLine + idPrefix** |
salesLine."Line No.” |
Prefix + Type |
“3” (if it is product discount line), 1 if it is order discount or “0” (if it is regular product order line) |
Prefix + Quantity |
salesLine.”Quantity” |
Prefix + DiscountId*** |
If UseDynamciwebDiscount is ON the OrderLineDiscountId value from the request is inserted. |
Prefix + ProductName** *** |
If UseDynamciwebDiscount is ON the OrderLineDiscountName value from the request is inserted. |
Prefix + PriceWith + vatPrefix** *** |
Price WithWAT (calculated variable) |
Prefix + UnitPriceWith + vatPrefix |
Unit Price With VAT (calculated variable) |
Prefix + PriceWithout + VatPrefix |
Price Without VAT (calculated variable) |
Prefix + UnitPriceWithout + VatPrefix |
Unit price Without VAT (calculated variable) |
Prefix + DiscountPercentage |
salesLine."Line Discount %" |
Prefix + Price + VatPrefix |
Calculates PriceWithWAT – PriceWithoutWAT |
Prefix + UnitPrice + VatPrefix |
Calculates (UnitPriceWithWAT – UnitPriceWithoutWAT) if salesLine.”Quantity” is not 0, the UnitPrice calculation is divided by the quantity. |
Prefix + Price + VatPrefix + Percent |
salesLine."VAT %" |
Prefix + UnitPrice + VatPrefix + Percent |
salesLine."VAT %" |
*only if isUomRequest is true in the request and “Unit of Measure Code” in the salesLine.”Variant Code” is not empty.
**Only if parent is not empty.
***Only if dynamicwebDiscountId is not empty.
Function AddNavOrderDiscountSalesLine
Imports data from the following Business Central tables:
- table 325 "VAT Posting Setup"
- table 36 "Sales Header"
OrderLineProductNumber |
”” |
OrderLineProductVariantID |
”” |
OrderLineId |
”” |
OrderLineQuantity |
”1” |
OrderLineType |
”1” |
OrderLinePriceWithoutVat |
Discount Amount without VAT |
OrderLineUnitPriceWithoutVat |
Discount Amount without VAT |
OrderLinePriceWithVat |
Considers if any sales line has a different Vat percent and if so, uses the invoiceDiscountAmountWithVat variable. Otherwise the variable is calculated by using VATPostingSetup.”VAT %” and thediscount amount. |
OrderLineUnitPriceWithVat |
Considers if any sales line has a different Vat percent and if so, uses the invoiceDiscountAmountWithVat variable. Otherwise the variable is calculated by using VATPostingSetup.”VAT %” and thediscount amount. |
OrderLinePriceVat |
Calculates TempWithWAT – TempWithoutWAT (rounded to two decimal points) |
OrderLineUnitPriceVat |
Calculates TempWithWAT – TempWithoutWAT (rounded to two decimal points) |
OrderLinePriceVatPercent |
VatPercent, variable, that holds the value from VATPostingSetup."VAT %" unless VATPostingSetup."VAT Calculation Type"is “Reverse Charge VAT” |
OrderLineUnitPriceVatPercent |
VatPercent, variable, that holds the value from VATPostingSetup."VAT %" unless VATPostingSetup."VAT Calculation Type"is “Reverse Charge VAT” |
Function AddSalesCrMemoLine
Imports data from the following Business Central tables:
- table 114 "Sales Cr.Memo Header" (salescrmemoheader)
- table 115 "Sales Cr.Memo Line" (SalesCrMemoLine)
- table 37 "Sales Line"
ProductNumber |
salesCrMemoLine.”No.” |
ProductVariantID |
SalesCrMemoLine."Variant Code" |
ParentLineID (only if parent exists) |
salesLine."Line No." |
Type |
“3” (if parent is not empty) or “0” (if parent is empty) |
Quantity |
“1” (if parent is not empty) orsalesCrMemoLine.”Quantity” |
PriceWithVAT |
salesCrMemoLine."Line Discount Amount" or TempWithVAT (calculated variable, quantity * unit price) |
UnitPriceWithVAT |
salesCrMemoLine."Unit Price" to string) orcalculated UnitPrice from salesCrMemoLine.”Unit Price” and salesCrMemoLine.”VAT %” |
PriceWithoutVAT |
TempWithoutVAT (calculated variable) or salesCrMemoLine."Line Discount Amount" |
UnitPriceWithoutVat |
Calculation from salesCrMemoLine."Unit Price" and salesCrMemoLine."VAT %" or salesCrMemoLine."Unit Price" |
DiscountPercentage |
salesCrMemoLine."Line Discount %" |
PriceVAT |
Calculates TempWithWAT – TempWithoutWAT (variables) |
PriceVATPercent |
salesCrMemoLine."VAT %" |
UnitPriceVATPercent |
salesCrMemoLine."VAT %" |
Function AddSalesInvLine
Imports data from the following Business Central tables:
- Table 113 "Sales Invoice Line" (salesInvLine)
- table 37 "Sales Line"
ProductNumber |
salesInvLine.”No.” |
ProductVariantID |
SalesInvLine."Variant Code" |
ParentLineID (only if parent exists) |
salesLine."Line No." |
Type |
“3” (if parent is not empty) or “0” (if parent is empty) |
Quantity |
“1” (if parent is not empty) orsalesInvLine.Quantity |
PriceWithVAT |
salesInvLine."Line Discount Amount" or TempWithVAT (calculated variable) |
UnitPriceWithVAT |
salesInvLine."Unit Price" or calculated UnitPrice from salesInvLine.”Unit Price”and salesInvLine.”VAT %” |
PriceWithoutVAT |
TempWithoutVAT (calculated variable) or salesInvLine."Line Discount Amount" |
UnitPriceWithoutVat |
Calculation from salesInvLine."Unit Price"and salesInvLine."VAT %" or salesInvLine."Unit Price" |
DiscountPercentage |
salesInvLine."Line Discount %" |
PriceVAT |
Calculates TempWithWAT – TempWithoutWAT (variables) |
PriceVATPercent |
salesInvLine."VAT %" |
UnitPriceVATPercent |
salesInvLine."VAT %" |