List of Merge Fields
  • 05 Apr 2023
  • 39 Minutes to read
  • Dark
    Light
  • PDF

List of Merge Fields

  • Dark
    Light
  • PDF

Article Summary

Required permissions

An employee must be assigned to the Shop with a Power User role or higher to create and edit templates on a Shop Owner level.

Use Merge Fields to auto-populate your Document and Email templates with the applicable data retrieved from ShopCtrl the moment the template will be generated.

A dynamic merge fields list applicable for the specific document or mail template type will be auto-generated when clicking the Available MergeFields button and providing an item code. Please check Creating and Editing Document Templates and Creating and Editing Email Templates for more information.

Note:

Merge fields that are marked as belonging to a certain collection must be inserted following a collection block syntax. Please see more in Collections in Document Templates and Collections in Email Templates.

Shop

Show the list of Shop merge fields
Merge field nameMerge field typeMerge fieldData type
Shop Owner Company NameSingle Item$$ShopOwner.CompanyName$$String
Shop Company NameSingle Item$$Shop.CompanyName$$String
Shop Country CodeSingle Item$$Shop.CountryCode$$String
Shop Icon UrlSingle Item$$Shop.IconUrl$$String
Shop Icon Url Img TagSingle Item$$Shop.IconUrlImgTag$$String
Shop IDSingle Item$$Shop.Id$$String
Shop LogoSingle Item$$Shop.Logo$$Image
Shop Logo UrlSingle Item$$Shop.LogoUrl$$String
Shop Logo Url Img TagSingle Item$$Shop.LogoUrlImgTag$$String
Shop NameSingle Item$$Shop.Name$$String
Shop SEPA Paymee IDSingle Item$$Shop.SepapayeeId$$String
Shop Site AddressSingle Item$$Shop.SiteAddress$$String
Shop Site Bank AccountSingle Item$$Shop.SiteBankAccount$$String
Shop Site Bank Account IBANSingle Item$$Shop.SiteBankAccountIban$$String
Shop Site Bank NameSingle Item$$Shop.SiteBankName$$String
Shop Site Bank SWIFT BICSingle Item$$Shop.SiteBankSwiftBic$$String
Shop Site CitySingle Item$$Shop.SiteCity$$String
Shop Site Chamber of CommerceSingle Item$$Shop.SiteCoc$$String
Shop Site Country NameSingle Item$$Shop.SiteCountryName$$String
Shop Site DirectorSingle Item$$Shop.SiteDirector$$String
Shop Site DisclaimerSingle Item$$Shop.SiteDisclaimer$$String
Shop Site EmailSingle Item$$Shop.SiteEmail$$String
Shop Site FaxSingle Item$$Shop.SiteFax$$String
Shop Site Opening HoursSingle Item$$Shop.SiteOpeningHours$$String
Shop Site PhoneSingle Item$$Shop.SitePhone$$String
Shop Site Postal CodeSingle Item$$Shop.SitePostalCode$$String
Shop Site VAT NumberSingle Item$$Shop.SiteVatNumber$$String
Shop UrlSingle Item$$Shop.Url$$String
Shop Url SecureSingle Item$$Shop.UrlSecure$$String

Customer

Show the list of Customer merge fields
Merge field nameMerge field typeMerge fieldData type
Customer Bill To And Ship To Are The SameSingle Item$$Customer.BillToAndShipToAreTheSame$$Boolean
Customer Bill To VAT NumberSingle Item$$Customer.BillToVatNumber$$String
Customer Company NameSingle Item$$Customer.CompanyName$$String
Customer Contact RefSingle Item$$Customer.ContactRef$$String
Customer Customer CodeSingle Item$$Customer.CustomerCode$$String
Customer Customer NumberSingle Item$$Customer.CustomerNumber$$String
Customer Date Of BirthSingle Item$$Customer.DateOfBirth$$Date and Time
Customer EmailSingle Item$$Customer.Email$$String
Customer First NameSingle Item$$Customer.FirstName$$String
Customer Full NameSingle Item$$Customer.FullName$$String
Customer Invoice Email AddressSingle Item$$Customer.InvoiceEmailAddress$$String
Customer Last NameSingle Item$$Customer.LastName$$String
Customer Last Name PrefixSingle Item$$Customer.LastNamePrefix$$String
Customer Middle NameSingle Item$$Customer.MiddleName$$String
Customer Order RemarkSingle Item$$Customer.OrderRemark$$String
Customer Personal NumberSingle Item$$Customer.PersonalNumber$$String
Customer Person TitleSingle Item$$Customer.PersonTitle$$String
Customer Reminder Invoice Email AddressSingle Item$$Customer.ReminderInvoiceEmailAddress$$String

Order

Show the list of Order merge fields
Merge field nameMerge field typeMerge fieldData type
Order Bill To AddressSingle Item$$Order.BillToAddress$$String
Order Bill To Address 2Single Item$$Order.BillToAddress2$$String
Order Bill To AndShip To AreTheSameSingle Item$$Order.BillToAndShipToAreTheSame$$String
Order Bill To CitySingle Item$$Order.BillToCity$$String
Order Bill To CompanySingle Item$$Order.BillToCompany$$String
Order Bill To CountrySingle Item$$Order.BillToCountry$$String
Order Bill To Country CodeSingle Item$$Order.BillToCountryCode$$String
Order Bill To EmailSingle Item$$Order.BillToEmail$$String
Order Bill To FaxSingle Item$$Order.BillToFax$$String
Order Bill To First NameSingle Item$$Order.BillToFirstName$$String
Order Bill To Last NameSingle Item$$Order.BillToLastName$$String
Order Bill To Last Name PrefixSingle Item$$Order.BillToLastNamePrefix$$String
Order Bill To NameSingle Item$$Order.BillToName$$String
Order Bill To PersonTitleSingle Item$$Order.BillToPersonTitle$$String
Order Bill To PhoneSingle Item$$Order.BillToPhone$$String
Order Bill To Phone2Single Item$$Order.BillToPhone2$$String
Order Bill To StateSingle Item$$Order.BillToState$$String
Order Bill To State ProvinceSingle Item$$Order.BillToStateProvince$$String
Order Bill To Street AddressSingle Item$$Order.BillToStreetAddress$$String
Order Bill To Street Address Additional InfoSingle Item$$Order.BillToStreetAddressAdditionalInfo$$String
Order Bill To Street Address ExtensionSingle Item$$Order.BillToStreetAddressExtension$$String
Order Bill To VAT NumberSingle Item$$Order.BillToVatNumber$$String
Order Bill To ZipSingle Item$$Order.BillToZip$$String
Order Carrier Account NameSingle Item$$Order.CarrierAccountName$$String
Order Checkout UrlSingle Item$$Order.CheckoutUrl$$String
Order Coupon CodeSingle Item$$Order.CouponCode$$String
Order CouponDiscountSingle Item$$Order.CouponDiscount$$String
Order Currency CodeSingle Item$$Order.CurrencyCode$$String
Order Currency SymbolSingle Item$$Order.CurrencySymbol$$String
Order Customer Culture CodeSingle Item$$Order.CustomerCultureCode$$String
Order Customer NoteSingle Item$$Order.CustomerNote$$String
Order Customer ReferenceSingle Item$$Order.CustomerReference$$String
Order CustomOrder Status ActionDateSingle Item$$Order.CustomOrderStatusActionDate$$String
Order CustomOrder Status CommentSingle Item$$Order.CustomOrderStatusComment$$String
Order DateSingle Item$$Order.Date$$Date and Time
Order Discount Excluding VATSingle Item$$Order.DiscountExVat$$Number
Order Discount Including VATSingle Item$$Order.DiscountIncVat$$Number
Order Down PaymentSingle Item$$Order.DownPayment$$Number
Order Down Payment In Base CurrencySingle Item$$Order.DownPaymentInBaseCurrency$$Number
Order Down Payment Rest AmountSingle Item$$Order.DownPaymentRestAmount$$Number
Order Down Payment Rest Amount In Base CurrencySingle Item$$Order.DownPaymentRestAmountInBaseCurrency$$Number
Order External Order KeySingle Item$$Order.ExternalOrderKey$$String
Order Has Registered Serial NumbersSingle Item$$Order.HasRegisteredSerialNumbers$$Boolean
Order Has Rows With DiscountSingle Item$$Order.HasRowsWithDiscount$$Boolean
Order IDSingle Item$$Order.Id$$String
Order Is PaidSingle Item$$Order.IsPaid$$Boolean
Order MainOrder Status ActionDateSingle Item$$Order.MainOrderStatusActionDate$$String
Order MainOrder Status CommentSingle Item$$Order.MainOrderStatusComment$$String
Order CodeSingle Item$$Order.OrderCode$$String
Order Products As HTML TableSingle Item$$Order.OrderProductsAsHtmlTable$$HTML table - Outdated
Order Rows As HTML TableSingle Item$$Order.OrderRowsAsHtmlTable$$HTML table - Outdated
Order Rows As Plain HTML TableSingle Item$$Order.OrderRowsAsPlainHtmlTable$$HTML table - Outdated
Order Rows Subtotal Excluding VATSingle Item$$Order.OrderRowsSubtotalExVat$$Number
Order Rows Subtotal Including VATSingle Item$$Order.OrderRowsSubtotalIncVat$$Number
Order Rows Without Article Code As HTML TableSingle Item$$Order.OrderRowsWithoutArticleCodeAsHtmlTable$$HTML table - Outdated
Order Rows With Price Excluding VAT As HTML TableSingle Item$$Order.OrderRowsWithPriceExVatAsHtmlTable$$HTML table - Outdated
Order Rows With Price Inc As Plain HTML TableSingle Item$$Order.OrderRowsWithPriceIncAsPlainHtmlTable$$HTML table - Outdated
Order TotalSingle Item$$Order.OrderTotal$$Number
Order Total Excluding VATSingle Item$$Order.OrderTotalExVat$$Number
Order Total In Base CurrencySingle Item$$Order.OrderTotalInBaseCurrency$$Number
Order Total Including VAT In Base CurrencySingle Item$$Order.OrderTotalIncVatInBaseCurrency$$Number
Order Payment Fee Excluding VATSingle Item$$Order.PaymentFeeExVat$$Number
Order Payment Fee Including VATSingle Item$$Order.PaymentFeeIncVat$$Number
Order Payment Order Status ActionDateSingle Item$$Order.PaymentOrderStatusActionDate$$String
Order Payment Order Status CommentSingle Item$$Order.PaymentOrderStatusComment$$String
Order Payment Type CodeSingle Item$$Order.PaymentTypeCode$$String
Order Payment Type IDSingle Item$$Order.PaymentTypeId$$String
Order Preferred Delivery DateSingle Item$$Order.PreferredDeliveryDate$$Date and Time
Order Registered Serial NumbersSingle Item$$Order.RegisteredSerialNumbers$$String
Order Shipment Order Status ActionDateSingle Item$$Order.ShipmentOrderStatusActionDate$$String
Order Shipment Order Status CommentSingle Item$$Order.ShipmentOrderStatusComment$$String
Order Shipments Package CountSingle Item$$Order.ShipmentsPackageCount$$Number
Order Shipment Tracking CodesSingle Item$$Order.ShipmentTrackingCodes$$String
Order Shipping Costs Excluding VATSingle Item$$Order.ShippingCostsExVat$$Number
Order Shipping Costs Including VATSingle Item$$Order.ShippingCostsIncVat$$Number
Order Ship To AddressSingle Item$$Order.ShipToAddress$$String
Order Ship To Address 2Single Item$$Order.ShipToAddress2$$String
Order Ship To CitySingle Item$$Order.ShipToCity$$String
Order Ship To CompanySingle Item$$Order.ShipToCompany$$String
Order Ship To CountrySingle Item$$Order.ShipToCountry$$String
Order Ship To Country CodeSingle Item$$Order.ShipToCountryCode$$String
Order Ship To EmailSingle Item$$Order.ShipToEmail$$String
Order Ship To FaxSingle Item$$Order.ShipToFax$$String
Order Ship To First NameSingle Item$$Order.ShipToFirstName$$String
Order Ship To Last NameSingle Item$$Order.ShipToLastName$$String
Order Ship To Last Name PrefixSingle Item$$Order.ShipToLastNamePrefix$$String
Order Ship To NameSingle Item$$Order.ShipToName$$String
Order Ship To PersonTitleSingle Item$$Order.ShipToPersonTitle$$String
Order Ship To PhoneSingle Item$$Order.ShipToPhone$$String
Order Ship To Phone2Single Item$$Order.ShipToPhone2$$String
Order Ship To StateSingle Item$$Order.ShipToState$$String
Order Ship To State ProvinceSingle Item$$Order.ShipToStateProvince$$String
Order Ship To Street AddressSingle Item$$Order.ShipToStreetAddress$$String
Order Ship To Street Address Additional InfoSingle Item$$Order.ShipToStreetAddressAdditionalInfo$$String
Order Ship To Street Address ExtensionSingle Item$$Order.ShipToStreetAddressExtension$$String
Order Ship To ZipSingle Item$$Order.ShipToZip$$String
Order Stock Order Status ActionDateSingle Item$$Order.StockOrderStatusActionDate$$String
Order Stock Order Status CommentSingle Item$$Order.StockOrderStatusComment$$String
Order Sum PaymentsSingle Item$$Order.SumPayments$$Number
Order Total DueSingle Item$$Order.TotalDue$$Number
Order Total Due In Base CurrencySingle Item$$Order.TotalDueInBaseCurrency$$Number
Order Total InvoicedSingle Item$$Order.TotalInvoiced$$Number
Order Total ReceivedSingle Item$$Order.TotalReceived$$Number
Order Total Received In Base CurrencySingle Item$$Order.TotalReceivedInBaseCurrency$$Number
Order Tracking UrlSingle Item$$Order.TrackingUrl$$String
Order Tracking Url LinkSingle Item$$Order.TrackingUrlLink$$String
Order VAT TotalSingle Item$$Order.VatTotal$$Number
Order Bill To Bank BicSingle Item$$OrderBillTo.BankBic$$String
Order Bill To Bank IbanSingle Item$$OrderBillTo.BankIban$$String
Order Bill To Bank NumberSingle Item$$OrderBillTo.BankNr$$String
Order Bill To Chamber of CommerceSingle Item$$OrderBillTo.ChamberOfCommerce$$String
Order Bill To Chamber of Commerce CitySingle Item$$OrderBillTo.ChamberOfCommerceCity$$String
Order Bill To CitySingle Item$$OrderBillTo.City$$String
Order Bill To Company NameSingle Item$$OrderBillTo.CompanyName$$String
Order Bill To Country CodeSingle Item$$OrderBillTo.CountryCode$$String
Order Bill To Country NameSingle Item$$OrderBillTo.CountryName$$String
Order Bill To Display NameSingle Item$$OrderBillTo.DisplayName$$String
Order Bill To EmailSingle Item$$OrderBillTo.Email$$String
Order Bill To Full NameSingle Item$$OrderBillTo.FullName$$String
Order Bill To Is Part Of The EUSingle Item$$OrderBillTo.IsPartOfTheEu$$Boolean
Order Bill To PersonTitleSingle Item$$OrderBillTo.PersonTitle$$String
Order Bill To PhoneSingle Item$$OrderBillTo.Phone$$String
Order Bill To Phone2Single Item$$OrderBillTo.Phone2$$String
Order Bill To Postal CodeSingle Item$$OrderBillTo.PostalCode$$String
Order Bill To State ProvinceSingle Item$$OrderBillTo.StateProvince$$String
Order Bill To State Province CodeSingle Item$$OrderBillTo.StateProvinceCode$$String
Order Bill To Street Address 1Single Item$$OrderBillTo.StreetAddress1$$String
Order Bill To Street Address 2Single Item$$OrderBillTo.StreetAddress2$$String
Order Bill To VAT NumberSingle Item$$OrderBillTo.VatNumber$$String
Order Ship To Bank BicSingle Item$$OrderShipTo.BankBic$$String
Order Ship To Bank IbanSingle Item$$OrderShipTo.BankIban$$String
Order Ship To Bank NumberSingle Item$$OrderShipTo.BankNr$$String
Order Ship To Chamber of CommerceSingle Item$$OrderShipTo.ChamberOfCommerce$$String
Order Ship To Chamber of Commerce CitySingle Item$$OrderShipTo.ChamberOfCommerceCity$$String
Order Ship To CitySingle Item$$OrderShipTo.City$$String
Order Ship To Company NameSingle Item$$OrderShipTo.CompanyName$$String
Order Ship To Country CodeSingle Item$$OrderShipTo.CountryCode$$String
Order Ship To Country NameSingle Item$$OrderShipTo.CountryName$$String
Order Ship To Display NameSingle Item$$OrderShipTo.DisplayName$$String
Order Ship To EmailSingle Item$$OrderShipTo.Email$$String
Order Ship To Full NameSingle Item$$OrderShipTo.FullName$$String
Order Ship To Is Part Of The EUSingle Item$$OrderShipTo.IsPartOfTheEu$$Boolean
Order Ship To PersonTitleSingle Item$$OrderShipTo.PersonTitle$$String
Order Ship To PhoneSingle Item$$OrderShipTo.Phone$$String
Order Ship To Phone2Single Item$$OrderShipTo.Phone2$$String
Order Ship To Postal CodeSingle Item$$OrderShipTo.PostalCode$$String
Order Ship To State ProvinceSingle Item$$OrderShipTo.StateProvince$$String
Order Ship To State Province CodeSingle Item$$OrderShipTo.StateProvinceCode$$String
Order Ship To Street Address 1Single Item$$OrderShipTo.StreetAddress1$$String
Order Ship To Street Address 2Single Item$$OrderShipTo.StreetAddress2$$String
Order Ship To VAT NumberSingle Item$$OrderShipTo.VatNumber$$String
Order Row Allocation Item QuantityOrderRow Collection$$OrderRow.AllocationItemQuantity$$Number
Order Row CommentOrderRow Collection$$OrderRow.Comment$$String
Order Row IDOrderRow Collection$$OrderRow.Id$$String
Order Row Item Base Price Excluding VATOrderRow Collection$$OrderRow.ItemBasePriceExVat$$Number
Order Row Item Base Price Including VATOrderRow Collection$$OrderRow.ItemBasePriceIncVat$$Number
Order Row Item Price Excluding VATOrderRow Collection$$OrderRow.ItemPriceExVat$$Number
Order Row Item Price Including VATOrderRow Collection$$OrderRow.ItemPriceIncVat$$Number
Order Row Item Purchase PriceOrderRow Collection$$OrderRow.ItemPurchasePrice$$Number
Order Row Item QuantityOrderRow Collection$$OrderRow.ItemQuantity$$Number
Order Row Item VAT AmountOrderRow Collection$$OrderRow.ItemVatAmount$$Number
Order Row Number Of Items InvoicedOrderRow Collection$$OrderRow.NrOfItemsInvoiced$$Number
Order Row Number Of Items RefundedOrderRow Collection$$OrderRow.NrOfItemsRefunded$$Number
Order Row Order IDOrderRow Collection$$OrderRow.OrderId$$String
Order Row Order Shipment IDOrderRow Collection$$OrderRow.OrderShipmentId$$String
Order Row Product CodeOrderRow Collection$$OrderRow.ProductCode$$String
Order Row Product Country Of OriginOrderRow Collection$$OrderRow.ProductCountryOfOrigin$$String
Order Row Product DescriptionOrderRow Collection$$OrderRow.ProductDescription$$String
Order Row Product EANOrderRow Collection$$OrderRow.ProductEAN$$String
Order Row Product HS CodeOrderRow Collection$$OrderRow.ProductHscode$$String
Order Row Product HS Code2OrderRow Collection$$OrderRow.ProductHscode2$$String
Order Row Product NameOrderRow Collection$$OrderRow.ProductName$$String
Order Row Product Weight, KgOrderRow Collection$$OrderRow.ProductWeightKg$$Number
Order Row Discount Excluding VATOrderRow Collection$$OrderRow.RowDiscountExVat$$Number
Order Row Discount Including VATOrderRow Collection$$OrderRow.RowDiscountIncVat$$Number
Order Row Total Excluding VATOrderRow Collection$$OrderRow.RowTotalExVat$$Number
Order Row Total Including VATOrderRow Collection$$OrderRow.RowTotalIncVat$$Number
Order Row VAT AmountOrderRow Collection$$OrderRow.RowVatAmount$$Number
Order Row Shop Product Image UrlOrderRow Collection$$OrderRow.ShopProductImageUrl$$String
Order Row Stock StatusOrderRow Collection$$OrderRow.StockStatus$$String
Order Row VAT percOrderRow Collection$$OrderRow.Vatperc$$Number
Order Row Base Product NameOrderRow Collection$$OrderRow.BaseProductName$$String
Order Row Product Name TranslationOrderRow Collection$$OrderRow.ProductNameTranslation$$String
Order Row Product DescriptionTranslationOrderRow Collection$$OrderRow.ProductDescriptionTranslation$$String
FieldsOrderGroupedVatSum CollectionFields
Order Grouped VAT Sum Total Excluding VATOrderGroupedVatSum Collection$$OrderGroupedVatSum.TotalExVat$$Number
Order Grouped VAT Sum Total Including VATOrderGroupedVatSum Collection$$OrderGroupedVatSum.TotalIncVat$$Number
Order Grouped VAT Sum VAT CodeOrderGroupedVatSum Collection$$OrderGroupedVatSum.VatCode$$Number
Order Grouped VAT Sum VAT PercOrderGroupedVatSum Collection$$OrderGroupedVatSum.VatPerc$$Number
Order Grouped VAT Sum VAT TariffIDOrderGroupedVatSum Collection$$OrderGroupedVatSum.VatTariffId$$Number
Order Grouped VAT Sum VAT TotalOrderGroupedVatSum Collection$$OrderGroupedVatSum.VatTotal$$Number
Payment Type CodeSingle Item$$PaymentType.Code$$String
Payment Type IDSingle Item$$PaymentType.Id$$String
Payment Type Is Auto Collect TypeSingle Item$$PaymentType.IsAutoCollectType$$Boolean
Payment Type Is Bank TransferSingle Item$$PaymentType.IsBankTransfer$$Boolean
Payment Type Is Cash On DeliverySingle Item$$PaymentType.IsCashOnDelivery$$Boolean
Payment Type Is Direct Money TransferSingle Item$$PaymentType.IsDirectMoneyTransfer$$Boolean
Payment Type Is Payment On InvoiceSingle Item$$PaymentType.IsPaymentOnInvoice$$Boolean
Product Registration CommentProductRegistration Collection$$ProductRegistration.Comment$$String
Product Registration Order Row IDProductRegistration Collection$$ProductRegistration.OrderRowId$$String
Product Registration Serial NumberProductRegistration Collection$$ProductRegistration.SerialNumber$$String
Product Registration Use By DateProductRegistration Collection$$ProductRegistration.UseByDate$$Date and Time

Relations based on current Order Row item
'ProductRegistration' links to ProductRegistration
Relations
'PaymentType' links to Order
'OrderRow' links to OrderRow

Order expected delivery date change

Show the list of Order expected delivery date change merge fields
Merge field nameMerge field typeMerge fieldData type
Order Expected Delivery DateSingle Item$$Order.ExpectedDeliveryDate$$Date
Order Expected Delivery Date WeekSingle Item$$Order.ExpectedDeliveryWeek$$Number
Order Row Expected Delivery DateOrder Row Collection$$Order Row.ExpectedDeliveryDate$$Date
Order Row Expected Delivery Date Change StatusOrder Row Collection$$Order Row.ExpectedDeliveryDateChange$$String
Order Row Expected Delivery Date Status valueOrder Row Collection$$Order Row.ExpectedDeliveryDateStatusEnumValue$$Number
Order Row Expected Delivery Date WeekOrder Row Collection$$Order Row.ExpectedDeliveryWeek$$Number
Order Row Previous Expected Delivery DateOrder Row Collection$$Order Row.PreviousExpectedDeliveryDate$$Date
Expected Delivery Date Change Allocation Item QuantityExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.AllocationItemQuantity$$Number
Expected Delivery Date Change CommentExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.Comment$$String
Expected Delivery Date Change Expected Delivery DateExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ExpectedDeliveryDate$$Date
Expected Delivery Date Change Expected Delivery Date ChangeExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ExpectedDeliveryDateChange$$String
Expected Delivery Date Change Expected Delivery Date Status Enum ValueExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ExpectedDeliveryDateStatusEnumValue$$Number
Expected Delivery Date Change Expected Delivery WeekExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ExpectedDeliveryWeek$$Number
Expected Delivery Date Change IdExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.Id$$Number
Expected Delivery Date Change Item Base PriceExVatExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ItemBasePriceExVat$$Number
Expected Delivery Date Change Item Base PriceIncVatExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ItemBasePriceIncVat$$Number
Expected Delivery Date Change Item Price ExVatExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ItemPriceExVat$$Number
Expected Delivery Date Change Item Price Inc VatExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ItemPriceIncVat$$Number
Expected Delivery Date Change Item Purchase PriceExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ItemPurchasePrice$$Number
Expected Delivery Date Change Item QuantityExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ItemQuantity$$Number
Expected Delivery Date Change Item Vat AmountExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ItemVatAmount$$Number
Expected Delivery Date Change NrOfItems InvoicedExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.NrOfItemsInvoiced$$Number
Expected Delivery Date Change NrOfItems RefundedExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.NrOfItemsRefunded$$Number
Expected Delivery Date Change OrderIdExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.OrderId$$Number
Expected Delivery Date Change Order Shipment IdExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.OrderShipmentId$$Number
Expected Delivery Date Change PreviousExpectedDeliveryDateExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.PreviousExpectedDeliveryDate$$Date
Expected Delivery Date Change Product CodeExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ProductCode$$String
Expected Delivery Date Change Product Country Of OriginExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ProductCountryOfOrigin$$String
Expected Delivery Date Change Product DescriptionExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ProductDescription$$String
Expected Delivery Date Change Product EANExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ProductEAN$$Number
Expected Delivery Date Change Product HscodeExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ProductHscode$$Number
Expected Delivery Date Change Product Hscode2Expected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ProductHscode2$$Number
Expected Delivery Date Change Product NameExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ProductName$$String
Expected Delivery Date Change Product WeightKgExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ProductWeightKg$$Number
Expected Delivery Date Change Row Discount ExVatExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.RowDiscountExVat$$Number
Expected Delivery Date Change Row Discount IncVatExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.RowDiscountIncVat$$Number
Expected Delivery Date Change Row Total ExVatExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.RowTotalExVat$$Number
Expected Delivery Date Change Row Total IncVatExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.RowTotalIncVat$$Number
Expected Delivery Date Change Row Vat AmountExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.RowVatAmount$$Number
Expected Delivery Date Change ShippedExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.Shipped$$Boolean
Expected Delivery Date Change Shop Product Image UrlExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.ShopProductImageUrl$$Url
Expected Delivery Date Change Stock StatusExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.StockStatus$$String
Expected Delivery Date Change Vat percExpected Delivery Date Change Collection$$ExpectedDeliveryDateChange.Vatperc$$Number

Relations
'ExpectedDeliveryDateChangeRows' links to ExpectedDeliveryDateChange

Invoice

Show the list of Invoice merge fields
Merge field nameMerge field typeMerge fieldData type
Invoice Auto Collect DateSingle Item$$Invoice.AutoCollectDate$$Date and Time
Invoice Auto Collect DaysSingle Item$$Invoice.AutoCollectDays$$Date and Time
Invoice Currency SymbolSingle Item$$Invoice.CurrencySymbol$$String
Invoice Customer ReferenceSingle Item$$Invoice.CustomerReference$$String
Invoice Discount Excluding VATSingle Item$$Invoice.DiscountExVat$$Number
Invoice Discount Including VATSingle Item$$Invoice.DiscountIncVat$$Number
Invoice External Invoice CodeSingle Item$$Invoice.ExternalInvoiceCode$$String
Invoice Has Rows With DiscountSingle Item$$Invoice.HasRowsWithDiscount$$Boolean
Invoice IDSingle Item$$Invoice.Id$$String
Invoice CodeSingle Item$$Invoice.InvoiceCode$$String
Invoice DateSingle Item$$Invoice.InvoiceDate$$Date and Time
Invoice Rows Subtotal Excluding VATSingle Item$$Invoice.InvoiceRowsSubtotalExVat$$Number
Invoice Rows Subtotal Including VATSingle Item$$Invoice.InvoiceRowsSubtotalIncVat$$Number
Invoice Total Excluding VATSingle Item$$Invoice.InvoiceTotalExVat$$Number
Invoice Total Including VATSingle Item$$Invoice.InvoiceTotalIncVat$$Number
Invoice Total Including VAT In Base CurrencySingle Item$$Invoice.InvoiceTotalIncVatInBaseCurrency$$Number
Invoice Is ConceptSingle Item$$Invoice.IsConcept$$Boolean
Invoice Is CreditInvoiceSingle Item$$Invoice.IsCreditInvoice$$Boolean
Invoice Is Must Pay Before ExpiredSingle Item$$Invoice.IsMustPayBeforeExpired$$Boolean
Invoice Is Not Credit InvoiceSingle Item$$Invoice.IsNotCreditInvoice$$Boolean
Invoice Is NotPaidSingle Item$$Invoice.IsNotPaid$$Boolean
Invoice Is PaidSingle Item$$Invoice.IsPaid$$Boolean
Invoice Is Reminder InvoiceSingle Item$$Invoice.IsReminderInvoice$$Boolean
Invoice Is VAT FreeInvoiceSingle Item$$Invoice.IsVatFreeInvoice$$Boolean
Invoice Is Zero Amount InvoiceSingle Item$$Invoice.IsZeroAmountInvoice$$Boolean
Invoice Must Pay BeforeSingle Item$$Invoice.MustPayBefore$$Date and Time
Invoice NoteSingle Item$$Invoice.Note$$String
Invoice Payment Fee Excluding VATSingle Item$$Invoice.PaymentFeeExVat$$Number
Invoice Payment Fee Including VATSingle Item$$Invoice.PaymentFeeIncVat$$Number
Invoice Payment Terms Days To PaySingle Item$$Invoice.PaymentTermsDaysToPay$$Number
Invoice Payment Terms NameSingle Item$$Invoice.PaymentTermsName$$String
Invoice Payment Type CodeSingle Item$$Invoice.PaymentTypeCode$$String
Invoice Reminder Create DateSingle Item$$Invoice.ReminderCreateDate$$Date and Time
Invoice Shipping Costs Excluding VATSingle Item$$Invoice.ShippingCostsExVat$$Number
Invoice Shipping Costs Including VATSingle Item$$Invoice.ShippingCostsIncVat$$Number
Invoice Shipping Costs VATSingle Item$$Invoice.ShippingCostsVat$$Number
Invoice Sum PaymentsSingle Item$$Invoice.SumPayments$$Number
Invoice Total DueSingle Item$$Invoice.TotalDue$$Number
Invoice Total Due In Base CurrencySingle Item$$Invoice.TotalDueInBaseCurrency$$Number
Invoice VAT TotalSingle Item$$Invoice.VatTotal$$Number
Invoice Row CommentInvoiceRow Collection$$InvoiceRow.Comment$$String
Invoice Row Discount Excluding VATInvoiceRow Collection$$InvoiceRow.DiscountExVat$$Number
Invoice Row Discount Including VATInvoiceRow Collection$$InvoiceRow.DiscountIncVat$$Number
Invoice Row IDInvoiceRow Collection$$InvoiceRow.Id$$String
Invoice Row Invoice IDInvoiceRow Collection$$InvoiceRow.InvoiceId$$String
Invoice Row Item Price Excluding VATInvoiceRow Collection$$InvoiceRow.ItemPriceExVat$$Number
Invoice Row Item Price Including VATInvoiceRow Collection$$InvoiceRow.ItemPriceIncVat$$Number
Invoice Row Item QuantityInvoiceRow Collection$$InvoiceRow.ItemQuantity$$Number
Invoice Row Item VAT AmountInvoiceRow Collection$$InvoiceRow.ItemVatAmount$$Number
Invoice Row Order Row IDInvoiceRow Collection$$InvoiceRow.OrderRowId$$String
Invoice Row Product CodeInvoiceRow Collection$$InvoiceRow.ProductCode$$String
Invoice Row Product Country Of OriginInvoiceRow Collection$$InvoiceRow.ProductCountryOfOrigin$$String
Invoice Row Product HS CodeInvoiceRow Collection$$InvoiceRow.ProductHsCode$$String
Invoice Row Product HS Code 2InvoiceRow Collection$$InvoiceRow.ProductHsCode2$$String
Invoice Row Product NameInvoiceRow Collection$$InvoiceRow.ProductName$$String
Invoice Row Total Excluding VATInvoiceRow Collection$$InvoiceRow.RowTotalExVat$$Number
Invoice Row Total Including VATInvoiceRow Collection$$InvoiceRow.RowTotalIncVat$$Number
Invoice Row VAT AmountInvoiceRow Collection$$InvoiceRow.RowVatAmount$$Number
Invoice Row VAT percInvoiceRow Collection$$InvoiceRow.Vatperc$$Number
Invoice Row Stock Item Row CountInvoiceRow Collection$$InvoiceRow.StockItemRowCount$$Number
Invoice Row Base Product NameInvoiceRow Collection$$InvoiceRow.BaseProductName$$String
Invoice Row Product Name TranslationInvoiceRow Collection$$InvoiceRow.ProductNameTranslation$$String
Invoice Row Product DescriptionTranslationInvoiceRow Collection$$InvoiceRow.ProductDescriptionTranslation$$String
Invoice Stock Item Expiry DateInvoiceStockItem Collection$$InvoiceStockItem.ExpiryDate$$String
Invoice Stock Item IDInvoiceStockItem Collection$$InvoiceStockItem.Id$$String
Invoice Stock Item Lot NumberInvoiceStockItem Collection$$InvoiceStockItem.LotNumber$$String
Invoice Stock Item Order Row IDInvoiceStockItem Collection$$InvoiceStockItem.OrderRowId$$String
Invoice Stock Item Serial NumberInvoiceStockItem Collection$$InvoiceStockItem.SerialNumber$$String
Grouped VAT Sum Total Excluding VATGroupedVatSum Collection$$GroupedVatSum.TotalExVat$$Number
Grouped VAT Sum Total Including VATGroupedVatSum Collection$$GroupedVatSum.TotalIncVat$$Number
Grouped VAT Sum VAT CodeGroupedVatSum Collection$$GroupedVatSum.VatCode$$Number
Grouped VAT Sum VAT PercGroupedVatSum Collection$$GroupedVatSum.VatPerc$$Number
Grouped VAT Sum VAT TariffIDGroupedVatSum Collection$$GroupedVatSum.VatTariffId$$Number
Grouped VAT Sum VAT TotalGroupedVatSum Collection$$GroupedVatSum.VatTotal$$Number
Invoice Shipment Invoice IDInvoiceShipment Collection$$InvoiceShipment.InvoiceId$$String
Invoice Shipment Order Shipment IDInvoiceShipment Collection$$InvoiceShipment.OrderShipmentId$$String
Invoice Shipment Packed TimestampInvoiceShipment Collection$$InvoiceShipment.PackedTimestamp$$Date and Time
Invoice Shipment Shipped TimestampInvoiceShipment Collection$$InvoiceShipment.ShippedTimestamp$$Date and Time
Invoice Shipment Shipping CodeInvoiceShipment Collection$$InvoiceShipment.ShippingCode$$String

Relations
'Invoice Row' links to 'InvoiceRow'
'Invoice Invoice Shipment ' links to 'InvoiceShipment'
'Invoice Stock Items ' links to 'InvoiceStockItem'

Offer

Show the list of Offer merge fields
Merge field nameMerge field typeMerge fieldData type
Offer Bill To AddressSingle Item$$Offer.BillToAddress$$String
Offer Bill To Address 2Single Item$$Offer.BillToAddress2$$String
Offer Bill To And Ship To Are The SameSingle Item$$Offer.BillToAndShipToAreTheSame$$Boolean
Offer Bill To CitySingle Item$$Offer.BillToCity$$String
Offer Bill To CompanySingle Item$$Offer.BillToCompany$$String
Offer Bill To CountrySingle Item$$Offer.BillToCountry$$String
Offer Bill To Country CodeSingle Item$$Offer.BillToCountryCode$$String
Offer Bill To EmailSingle Item$$Offer.BillToEmail$$String
Offer Bill To FaxSingle Item$$Offer.BillToFax$$String
Offer Bill To First NameSingle Item$$Offer.BillToFirstName$$String
Offer Bill To Last NameSingle Item$$Offer.BillToLastName$$String
Offer Bill To Last Name PrefixSingle Item$$Offer.BillToLastNamePrefix$$String
Offer Bill To NameSingle Item$$Offer.BillToName$$String
Offer Bill To Person TitleSingle Item$$Offer.BillToPersonTitle$$String
Offer Bill To PhoneSingle Item$$Offer.BillToPhone$$String
Offer Bill To Phone2Single Item$$Offer.BillToPhone2$$String
Offer Bill To StateSingle Item$$Offer.BillToState$$String
Offer Bill To State ProvinceSingle Item$$Offer.BillToStateProvince$$String
Offer Bill To Street AddressSingle Item$$Offer.BillToStreetAddress$$String
Offer Bill To Street Address Additional InfoSingle Item$$Offer.BillToStreetAddressAdditionalInfo$$String
Offer Bill To Street Address ExtensionSingle Item$$Offer.BillToStreetAddressExtension$$String
Offer Bill To VAT NumberSingle Item$$Offer.BillToVatNumber$$String
Offer Bill To ZipSingle Item$$Offer.BillToZip$$String
Offer Carrier Account NameSingle Item$$Offer.CarrierAccountName$$String
Offer Currency CodeSingle Item$$Offer.CurrencyCode$$String
Offer Currency SymbolSingle Item$$Offer.CurrencySymbol$$String
Offer Customer ReferenceSingle Item$$Offer.CustomerReference$$String
Offer Discount Excluding VATSingle Item$$Offer.DiscountExVat$$String
Offer Discount Including VATSingle Item$$Offer.DiscountIncVat$$String
Offer Has Rows With DiscountSingle Item$$Offer.HasRowsWithDiscount$$Boolean
Offer IDSingle Item$$Offer.Id$$String
Offer NoteSingle Item$$Offer.Note$$String
Offer CodeSingle Item$$Offer.OfferCode$$String
Offer DateSingle Item$$Offer.OfferDate$$Date and Time
Offer Products As HTML TableSingle Item$$Offer.OfferProductsAsHtmlTable$$HTML table - Outdated
Offer Rows As HTML TableSingle Item$$Offer.OfferRowsAsHtmlTable$$HTML table - Outdated
Offer Rows Subtotal Excluding VATSingle Item$$Offer.OfferRowsSubtotalExVat$$Number
Offer Rows Subtotal Including VATSingle Item$$Offer.OfferRowsSubtotalIncVat$$Number
Offer Total Excluding VATSingle Item$$Offer.OfferTotalExVat$$Number
Offer Total Including VATSingle Item$$Offer.OfferTotalIncVat$$Number
Offer Total Including VAT In Base CurrencySingle Item$$Offer.OfferTotalIncVatInBaseCurrency$$Number
Offer Payment Type CodeSingle Item$$Offer.PaymentTypeCode$$String
Offer Shipping Costs Excluding VATSingle Item$$Offer.ShippingCostsExVat$$Number
Offer Shipping Costs Including VATSingle Item$$Offer.ShippingCostsIncVat$$Number
Offer Ship To AddressSingle Item$$Offer.ShipToAddress$$String
Offer Ship To Address 2Single Item$$Offer.ShipToAddress2$$String
Offer Ship To CitySingle Item$$Offer.ShipToCity$$String
Offer Ship To CompanySingle Item$$Offer.ShipToCompany$$String
Offer Ship To CountrySingle Item$$Offer.ShipToCountry$$String
Offer Ship To Country CodeSingle Item$$Offer.ShipToCountryCode$$String
Offer Ship To EmailSingle Item$$Offer.ShipToEmail$$String
Offer Ship To FaxSingle Item$$Offer.ShipToFax$$String
Offer Ship To First NameSingle Item$$Offer.ShipToFirstName$$String
Offer Ship To Last NameSingle Item$$Offer.ShipToLastName$$String
Offer Ship To Last Name PrefixSingle Item$$Offer.ShipToLastNamePrefix$$String
Offer Ship To NameSingle Item$$Offer.ShipToName$$String
Offer Ship To PersonTitleSingle Item$$Offer.ShipToPersonTitle$$String
Offer Ship To PhoneSingle Item$$Offer.ShipToPhone$$String
Offer Ship To Phone2Single Item$$Offer.ShipToPhone2$$String
Offer Ship To StateSingle Item$$Offer.ShipToState$$String
Offer Ship To State ProvinceSingle Item$$Offer.ShipToStateProvince$$String
Offer Ship To Street AddressSingle Item$$Offer.ShipToStreetAddress$$String
Offer Ship To Street Address Additional InfoSingle Item$$Offer.ShipToStreetAddressAdditionalInfo$$String
Offer Ship To Street Address ExtensionSingle Item$$Offer.ShipToStreetAddressExtension$$String
Offer Ship To ZipSingle Item$$Offer.ShipToZip$$String
Offer Validity DaysSingle Item$$Offer.ValidityDays$$Number
Offer Valid UntilSingle Item$$Offer.ValidUntil$$Date and Time
Offer VAT TotalSingle Item$$Offer.VatTotal$$Number
Offer Row CommentOfferRow Collection$$OfferRow.Comment$$String
Offer Row IDOfferRow Collection$$OfferRow.Id$$String
Offer Row Item Price Excluding VATOfferRow Collection$$OfferRow.ItemPriceExVat$$Number
Offer Row Item Price Including VATOfferRow Collection$$OfferRow.ItemPriceIncVat$$Number
Offer Row Item QuantityOfferRow Collection$$OfferRow.ItemQuantity$$Number
Offer Row Offer IDOfferRow Collection$$OfferRow.OfferId$$String
Offer Row Product CodeOfferRow Collection$$OfferRow.ProductCode$$String
Offer Row Product DescriptionOfferRow Collection$$OfferRow.ProductDescription$$String
Offer Row Product NameOfferRow Collection$$OfferRow.ProductName$$String
Offer Row Discount Excluding VATOfferRow Collection$$OfferRow.RowDiscountExVat$$Number
Offer Row Discount Including VATOfferRow Collection$$OfferRow.RowDiscountIncVat$$Number
Offer Row Total Excluding VATOfferRow Collection$$OfferRow.RowTotalExVat$$Number
Offer Row Total Including VATOfferRow Collection$$OfferRow.RowTotalIncVat$$Number
Offer Row VAT AmountOfferRow Collection$$OfferRow.RowVatAmount$$Number
Offer Row VAT percOfferRow Collection$$OfferRow.Vatperc$$Number
Grouped VAT Sum Total Excluding VATGroupedVatSum Collection$$GroupedVatSum.TotalExVat$$Number
Grouped VAT Sum Total Including VATGroupedVatSum Collection$$GroupedVatSum.TotalIncVat$$Number
Grouped VAT Sum VAT PercGroupedVatSum Collection$$GroupedVatSum.VatPerc$$Number
Grouped VAT Sum VAT TotalGroupedVatSum Collection$$GroupedVatSum.VatTotal$$Number
Offer Bill To Bank BICSingle Item$$OfferBillTo.BankBic$$String
Offer Bill To Bank IBANSingle Item$$OfferBillTo.BankIban$$String
Offer Bill To Bank NumberSingle Item$$OfferBillTo.BankNr$$String
Offer Bill To Chamber of CommerceSingle Item$$OfferBillTo.ChamberOfCommerce$$String
Offer Bill To Chamber of Commerce CitySingle Item$$OfferBillTo.ChamberOfCommerceCity$$String
Offer Bill To CitySingle Item$$OfferBillTo.City$$String
Offer Bill To Company NameSingle Item$$OfferBillTo.CompanyName$$String
Offer Bill To Country CodeSingle Item$$OfferBillTo.CountryCode$$String
Offer Bill To Country NameSingle Item$$OfferBillTo.CountryName$$String
Offer Bill To Display NameSingle Item$$OfferBillTo.DisplayName$$String
Offer Bill To EmailSingle Item$$OfferBillTo.Email$$String
Offer Bill To Full NameSingle Item$$OfferBillTo.FullName$$String
Offer Bill To Is Part Of The EUSingle Item$$OfferBillTo.IsPartOfTheEu$$Boolean
Offer Bill To PersonTitleSingle Item$$OfferBillTo.PersonTitle$$String
Offer Bill To PhoneSingle Item$$OfferBillTo.Phone$$String
Offer Bill To Phone2Single Item$$OfferBillTo.Phone2$$String
Offer Bill To Postal CodeSingle Item$$OfferBillTo.PostalCode$$String
Offer Bill To State ProvinceSingle Item$$OfferBillTo.StateProvince$$String
Offer Bill To State Province CodeSingle Item$$OfferBillTo.StateProvinceCode$$String
Offer Bill To Street Address 1Single Item$$OfferBillTo.StreetAddress1$$String
Offer Bill To Street Address 2Single Item$$OfferBillTo.StreetAddress2$$String
Offer Bill To VAT NumberSingle Item$$OfferBillTo.VatNumber$$String
Offer Ship To Bank BICSingle Item$$OfferShipTo.BankBic$$String
Offer Ship To Bank IBANSingle Item$$OfferShipTo.BankIban$$String
Offer Ship To Bank NumberSingle Item$$OfferShipTo.BankNr$$String
Offer Ship To Chamber of CommerceSingle Item$$OfferShipTo.ChamberOfCommerce$$String
Offer Ship To Chamber of Commerce CitySingle Item$$OfferShipTo.ChamberOfCommerceCity$$String
Offer Ship To CitySingle Item$$OfferShipTo.City$$String
Offer Ship To Company NameSingle Item$$OfferShipTo.CompanyName$$String
Offer Ship To Country CodeSingle Item$$OfferShipTo.CountryCode$$String
Offer Ship To Country NameSingle Item$$OfferShipTo.CountryName$$String
Offer Ship To Display NameSingle Item$$OfferShipTo.DisplayName$$String
Offer Ship To EmailSingle Item$$OfferShipTo.Email$$String
Offer Ship To Full NameSingle Item$$OfferShipTo.FullName$$String
Offer Ship To Is Part Of The EUSingle Item$$OfferShipTo.IsPartOfTheEu$$Boolean
Offer Ship To PersonTitleSingle Item$$OfferShipTo.PersonTitle$$String
Offer Ship To PhoneSingle Item$$OfferShipTo.Phone$$String
Offer Ship To Phone2Single Item$$OfferShipTo.Phone2$$String
Offer Ship To Postal CodeSingle Item$$OfferShipTo.PostalCode$$String
Offer Ship To State ProvinceSingle Item$$OfferShipTo.StateProvince$$String
Offer Ship To State Province CodeSingle Item$$OfferShipTo.StateProvinceCode$$String
Offer Ship To Street Address 1Single Item$$OfferShipTo.StreetAddress1$$String
Offer Ship To Street Address 2Single Item$$OfferShipTo.StreetAddress2$$String
Offer Ship To VAT NumberSingle Item$$OfferShipTo.VatNumber$$String

Relations
'OfferRow' links to 'OfferRow'

Order Shipment

Show the list of Order Shipment merge fields
Merge field nameMerge field typeMerge fieldData type
Order Shipment Carrier Account NameSingle Item$$OrderShipment.CarrierAccountName$$String
Order Shipment Cash On Delivery PaymentSingle Item$$OrderShipment.CashOnDeliveryPayment$$String
Order Shipment Create TimestampSingle Item$$OrderShipment.CreateTimestamp$$Date and Time
Order Shipment Delivery DateSingle Item$$OrderShipment.DeliveryDate$$Date and Time
Order Shipment HandOver TimestampSingle Item$$OrderShipment.HandOverTimestamp$$Date and Time
Order Shipment IDSingle Item$$OrderShipment.Id$$String
Order Shipment Open Pick List Scan CodeSingle Item$$OrderShipment.OpenPickListScanCode$$Scan Code
Order Shipment Order Rows As HTML TableSingle Item$$OrderShipment.OrderRowsAsHtmlTable$$HTML table - Outdated
Order Shipment Order Shipment Rows Without Article Code As HTML TableSingle Item$$OrderShipment.OrderShipmentRowsWithoutArticleCodeAsHtmlTable$$HTML table - Outdated
Order Shipment PackageCountSingle Item$$OrderShipment.PackageCount$$Number
Order Shipment Parcel Carrier AppModule IDSingle Item$$OrderShipment.ParcelCarrierAppModuleId$$String
Order Shipment Preferred Ship DateSingle Item$$OrderShipment.PreferredShipDate$$Date and Time
Order Shipment Scan CodeSingle Item$$OrderShipment.ScanCode$$Scan Code
Order Shipment Shipment StatusSingle Item$$OrderShipment.ShipmentStatus$$String
Order Shipment Shipment TypeSingle Item$$OrderShipment.ShipmentType$$String
Order Shipment Shipped TimestampSingle Item$$OrderShipment.ShippedTimestamp$$Date and Time
Order Shipment Shipping CodeSingle Item$$OrderShipment.ShippingCode$$String
Order Shipment Total Excluding VATSingle Item$$OrderShipment.TotalExVat$$Number
Order Shipment Total Including VATSingle Item$$OrderShipment.TotalIncVat$$Number
Order Shipment Total Item QuantitySingle Item$$OrderShipment.TotalItemQuantity$$Number
Order Shipment Total VATSingle Item$$OrderShipment.TotalVat$$Number
Order Shipment Total Volume, M3Single Item$$OrderShipment.TotalVolumeM3$$Number
Order Shipment Total Weight, KgSingle Item$$OrderShipment.TotalWeightKg$$Number
Order Shipment Tracking CodeSingle Item$$OrderShipment.TrackingCode$$String
Order Shipment WeightSingle Item$$OrderShipment.Weight$$Number
Pick Row CommentPickRow Collection$$PickRow.Comment$$String
Pick Row EanPickRow Collection$$PickRow.Ean$$String
Pick Row Expiry DatePickRow Collection$$PickRow.ExpiryDate$$Date and Time
Pick Row Has Advanced Stock ItemsPickRow Collection$$PickRow.HasAdvancedStockItems$$Boolean
Pick Row Is Hard ExpiredPickRow Collection$$PickRow.IsHardExpired$$Boolean
Pick Row Is Soft ExpiredPickRow Collection$$PickRow.IsSoftExpired$$Boolean
Pick Row LocationPickRow Collection$$PickRow.Location$$String
Pick Row Lot NumberPickRow Collection$$PickRow.LotNumber$$String
Pick Row Order CodePickRow Collection$$PickRow.OrderCode$$String
Pick Row Order IDPickRow Collection$$PickRow.OrderId$$String
Pick Row Order Row IDPickRow Collection$$PickRow.OrderRowId$$String
Pick Row Order Shipment IDPickRow Collection$$PickRow.OrderShipmentId$$String
Pick Row Product CodePickRow Collection$$PickRow.ProductCode$$String
Pick Row Product IDPickRow Collection$$PickRow.ProductId$$String
Pick Row Product NamePickRow Collection$$PickRow.ProductName$$String
Pick Row Product Requires Expiry DatePickRow Collection$$PickRow.ProductRequiresExpiryDate$$Boolean
Pick Row Product Requires Lot NumberPickRow Collection$$PickRow.ProductRequiresLotNumber$$Boolean
Pick Row Product Requires Serial NumberPickRow Collection$$PickRow.ProductRequiresSerialNumber$$Boolean
Pick Row Qty NeededPickRow Collection$$PickRow.QtyNeeded$$Number
Pick Row Qty PickedPickRow Collection$$PickRow.QtyPicked$$Number
Pick Row Serial NumberPickRow Collection$$PickRow.SerialNumber$$String
Pick Row Stock Item IDPickRow Collection$$PickRow.StockItemId$$String
Pick Row Warehouse LocationIDPickRow Collection$$PickRow.WarehouseLocationId$$String
Order Shipment Package Belt Size, MOrderShipmentPackage Collection$$OrderShipmentPackage.BeltSizeM$$Number
Order Shipment Package DescriptionOrderShipmentPackage Collection$$OrderShipmentPackage.Description$$String
Order Shipment Package Height, CmOrderShipmentPackage Collection$$OrderShipmentPackage.HeightCm$$Number
Order Shipment Package Length, CmOrderShipmentPackage Collection$$OrderShipmentPackage.LengthCm$$Number
Order Shipment Package Order Shipment IDOrderShipmentPackage Collection$$OrderShipmentPackage.OrderShipmentId$$String
Order Shipment Package Tracking CodeOrderShipmentPackage Collection$$OrderShipmentPackage.TrackingCode$$String
Order Shipment Package Volume, M3OrderShipmentPackage Collection$$OrderShipmentPackage.VolumeM3$$Number
Order Shipment Package Weight, KgOrderShipmentPackage Collection$$OrderShipmentPackage.WeightKg$$Number
Order Shipment Package Width, CmOrderShipmentPackage Collection$$OrderShipmentPackage.WidthCm$$Number
Pack Row Allocation Item QuantityPackRow Collection$$PackRow.AllocationItemQuantity$$Number
Pack Row CommentPackRow Collection$$PackRow.Comment$$String
Pack Row IDPackRow Collection$$PackRow.Id$$String
Pack Row Item Base Price Excluding VATPackRow Collection$$PackRow.ItemBasePriceExVat$$Number
Pack Row Item Base Price Including VATPackRow Collection$$PackRow.ItemBasePriceIncVat$$Number
Pack Row Item Price Excluding VATPackRow Collection$$PackRow.ItemPriceExVat$$Number
Pack Row Item Price Including VATPackRow Collection$$PackRow.ItemPriceIncVat$$Number
Pack Row Item Purchase PricePackRow Collection$$PackRow.ItemPurchasePrice$$Number
Pack Row Item QuantityPackRow Collection$$PackRow.ItemQuantity$$Number
Pack Row Item VAT AmountPackRow Collection$$PackRow.ItemVatAmount$$Number
Pack Row Number Of Items InvoicedPackRow Collection$$PackRow.NrOfItemsInvoiced$$Number
Pack Row Number Of Items RefundedPackRow Collection$$PackRow.NrOfItemsRefunded$$Number
Pack Row OrderIDPackRow Collection$$PackRow.OrderId$$String
Pack Row Order Shipment IDPackRow Collection$$PackRow.OrderShipmentId$$String
Pack Row Product CodePackRow Collection$$PackRow.ProductCode$$String
Pack Row Product Country Of OriginPackRow Collection$$PackRow.ProductCountryOfOrigin$$String
Pack Row Product DescriptionPackRow Collection$$PackRow.ProductDescription$$String
Pack Row Product EANPackRow Collection$$PackRow.ProductEAN$$String
Pack Row Product HS CodePackRow Collection$$PackRow.ProductHscode$$String
Pack Row Product HS Code2PackRow Collection$$PackRow.ProductHscode2$$String
Pack Row Product NamePackRow Collection$$PackRow.ProductName$$String
Pack Row Product Weight, KgPackRow Collection$$PackRow.ProductWeightKg$$Number
Pack Row Discount Excluding VATPackRow Collection$$PackRow.RowDiscountExVat$$Number
Pack Row Discount Including VATPackRow Collection$$PackRow.RowDiscountIncVat$$Number
Pack Row Total Excluding VATPackRow Collection$$PackRow.RowTotalExVat$$Number
Pack Row Total Including VATPackRow Collection$$PackRow.RowTotalIncVat$$Number
Pack Row VAT AmountPackRow Collection$$PackRow.RowVatAmount$$Number
Pack Row Shop Product Image UrlPackRow Collection$$PackRow.ShopProductImageUrl$$String
Pack Row Stock StatusPackRow Collection$$PackRow.StockStatus$$String
Pack Row VAT percPackRow Collection$$PackRow.Vatperc$$Number
Pack Row Supplier SKUPackRow Collection$$PackRow.SupplierSKU$$String
Pack Row Base Product NamePackRow Collection$$PackRow.BaseProductName$$String
Ship From Bank BICSingle Item$$ShipFromContactInfo.BankBic$$String
Ship From Bank IBANSingle Item$$ShipFromContactInfo.BankIban$$String
Ship From Bank NumberSingle Item$$ShipFromContactInfo.BankNr$$String
Ship From Chamber of CommerceSingle Item$$ShipFromContactInfo.ChamberOfCommerce$$String
Ship From Chamber of Commerce CitySingle Item$$ShipFromContactInfo.ChamberOfCommerceCity$$String
Ship From CitySingle Item$$ShipFromContactInfo.City$$String
Ship From Company NameSingle Item$$ShipFromContactInfo.CompanyName$$String
Ship From Country CodeSingle Item$$ShipFromContactInfo.CountryCode$$String
Ship From Country NameSingle Item$$ShipFromContactInfo.CountryName$$String
Ship From Display NameSingle Item$$ShipFromContactInfo.DisplayName$$String
Ship From EmailSingle Item$$ShipFromContactInfo.Email$$String
Ship From Full NameSingle Item$$ShipFromContactInfo.FullName$$String
Ship From Is Part Of The EUSingle Item$$ShipFromContactInfo.IsPartOfTheEu$$Boolean
Ship From Person TitleSingle Item$$ShipFromContactInfo.PersonTitle$$String
Ship From PhoneSingle Item$$ShipFromContactInfo.Phone$$String
Ship From Phone2Single Item$$ShipFromContactInfo.Phone2$$String
Ship From Postal CodeSingle Item$$ShipFromContactInfo.PostalCode$$String
Ship From State ProvinceSingle Item$$ShipFromContactInfo.StateProvince$$String
Ship From State Province CodeSingle Item$$ShipFromContactInfo.StateProvinceCode$$String
Ship From Street Address 1Single Item$$ShipFromContactInfo.StreetAddress1$$String
Ship From Street Address 2Single Item$$ShipFromContactInfo.StreetAddress2$$String
Ship From VAT NumberSingle Item$$ShipFromContactInfo.VatNumber$$String
Transport Category CodeTransportCategory Collection$$TransportCategory.Code$$String
Transport Category IDTransportCategory Collection$$TransportCategory.Id$$String
Pack Row Product Registration CommentPackRowProductRegistration Collection$$PackRowProductRegistration.Comment$$String
Pack Row Product Registration Order Row IDPackRowProductRegistration Collection$$PackRowProductRegistration.OrderRowId$$String
Pack Row Product Registration Serial NumberPackRowProductRegistration Collection$$PackRowProductRegistration.SerialNumber$$String
Pack Row Product Registration Use By DatePackRowProductRegistration Collection$$PackRowProductRegistration.UseByDate$$Date and Time

Relations
'OrderShipmentPickRow' links to 'PickRow'
'OrderShipmentOrderShipmentPackage' links to 'OrderShipmentPackage'
'PackRows' links to 'PackRow'
Relations based on current PackRow item
'PackRowProductRegistration' links to 'PackRowProductRegistration'

Parcel

Show the list of Parcel merge fields
Merge field nameMerge field typeMerge fieldData type
Parcel Carrier Account Additional Info1Single Item$$Parcel.CarrierAccountAdditionalInfo1$$String
Parcel Carrier Account Additional Info2Single Item$$Parcel.CarrierAccountAdditionalInfo2$$String
Parcel Carrier Account IDSingle Item$$Parcel.CarrierAccountId$$String
Parcel Carrier Account NameSingle Item$$Parcel.CarrierAccountName$$String
Parcel Carrier AppModule IDSingle Item$$Parcel.CarrierAppModuleId$$String
Parcel Create TimestampSingle Item$$Parcel.CreateTimestamp$$Date and Time
Parcel Delivered DateSingle Item$$Parcel.DeliveredDate$$Date and Time
Parcel IDSingle Item$$Parcel.Id$$String
Parcel Is ReturnSingle Item$$Parcel.IsReturn$$Boolean
Parcel Last Carrier UpdateSingle Item$$Parcel.LastCarrierUpdate$$String
Parcel Ship From Bank BicSingle Item$$ParcelShipFrom.BankBic$$String
Parcel Ship From Bank IbanSingle Item$$ParcelShipFrom.BankIban$$String
Parcel Ship From Bank NumberSingle Item$$ParcelShipFrom.BankNr$$String
Parcel Ship From Chamber of CommerceSingle Item$$ParcelShipFrom.ChamberOfCommerce$$String
Parcel Ship From Chamber of Commerce CitySingle Item$$ParcelShipFrom.ChamberOfCommerceCity$$String
Parcel Ship From CitySingle Item$$ParcelShipFrom.City$$String
Parcel Ship From Company NameSingle Item$$ParcelShipFrom.CompanyName$$String
Parcel Ship From Country CodeSingle Item$$ParcelShipFrom.CountryCode$$String
Parcel Ship From Country NameSingle Item$$ParcelShipFrom.CountryName$$String
Parcel Ship From Display NameSingle Item$$ParcelShipFrom.DisplayName$$String
Parcel Ship From EmailSingle Item$$ParcelShipFrom.Email$$String
Parcel Ship From Full NameSingle Item$$ParcelShipFrom.FullName$$String
Parcel Ship From Is Part Of The EUSingle Item$$ParcelShipFrom.IsPartOfTheEu$$Boolean
Parcel Ship From PersonTitleSingle Item$$ParcelShipFrom.PersonTitle$$String
Parcel Ship From PhoneSingle Item$$ParcelShipFrom.Phone$$String
Parcel Ship From Phone2Single Item$$ParcelShipFrom.Phone2$$String
Parcel Ship From Postal CodeSingle Item$$ParcelShipFrom.PostalCode$$String
Parcel Ship From State ProvinceSingle Item$$ParcelShipFrom.StateProvince$$String
Parcel Ship From State Province CodeSingle Item$$ParcelShipFrom.StateProvinceCode$$String
Parcel Ship From Street Address 1Single Item$$ParcelShipFrom.StreetAddress1$$String
Parcel Ship From Street Address 2Single Item$$ParcelShipFrom.StreetAddress2$$String
Parcel Ship From VAT NumberSingle Item$$ParcelShipFrom.VatNumber$$String
Parcel Ship To Bank BicSingle Item$$ParcelShipTo.BankBic$$String
Parcel Ship To Bank IbanSingle Item$$ParcelShipTo.BankIban$$String
Parcel Ship To Bank NumberSingle Item$$ParcelShipTo.BankNr$$String
Parcel Ship To Chamber of CommerceSingle Item$$ParcelShipTo.ChamberOfCommerce$$String
Parcel Ship To Chamber of Commerce CitySingle Item$$ParcelShipTo.ChamberOfCommerceCity$$String
Parcel Ship To CitySingle Item$$ParcelShipTo.City$$String
Parcel Ship To Company NameSingle Item$$ParcelShipTo.CompanyName$$String
Parcel Ship To Country CodeSingle Item$$ParcelShipTo.CountryCode$$String
Parcel Ship To Country NameSingle Item$$ParcelShipTo.CountryName$$String
Parcel Ship To Display NameSingle Item$$ParcelShipTo.DisplayName$$String
Parcel Ship To EmailSingle Item$$ParcelShipTo.Email$$String
Parcel Ship To Full NameSingle Item$$ParcelShipTo.FullName$$String
Parcel Ship To Is Part Of The EUSingle Item$$ParcelShipTo.IsPartOfTheEu$$Boolean
Parcel Ship To Person TitleSingle Item$$ParcelShipTo.PersonTitle$$String
Parcel Ship To PhoneSingle Item$$ParcelShipTo.Phone$$String
Parcel Ship To Phone2Single Item$$ParcelShipTo.Phone2$$String
Parcel Ship To Postal CodeSingle Item$$ParcelShipTo.PostalCode$$String
Parcel Ship To State ProvinceSingle Item$$ParcelShipTo.StateProvince$$String
Parcel Ship To State Province CodeSingle Item$$ParcelShipTo.StateProvinceCode$$String
Parcel Ship To Street Address 1Single Item$$ParcelShipTo.StreetAddress1$$String
Parcel Ship To Street Address 2Single Item$$ParcelShipTo.StreetAddress2$$String
Parcel Ship To VAT NumberSingle Item$$ParcelShipTo.VatNumber$$String
Parcel Package Height, CmParcelPackage Collection$$ParcelPackage.HeightCm$$Number
Parcel Package Label ImageParcelPackage Collection$$ParcelPackage.LabelImage$$Image
Parcel Package Length, CmParcelPackage Collection$$ParcelPackage.LengthCm$$Number
Parcel Package Parcel IDParcelPackage Collection$$ParcelPackage.ParcelId$$String
Parcel Package Tracking CodeParcelPackage Collection$$ParcelPackage.TrackingCode$$String
Parcel Package Tracking UrlParcelPackage Collection$$ParcelPackage.TrackingUrl$$String
Parcel Package Weight, KgParcelPackage Collection$$ParcelPackage.WeightKg$$Number
Parcel Package Width, CmParcelPackage Collection$$ParcelPackage.WidthCm$$Number

Relations
'ParcelPackage' links to 'ParcelPackage'

Purchase Order

Show the list of Purchase Order merge fields
Merge field nameMerge field typeMerge fieldData type
Purchase Order CommentSingle Item$$PurchaseOrder.Comment$$String
Purchase Order Currency SymbolSingle Item$$PurchaseOrder.CurrencySymbol$$String
Purchase Order DateSingle Item$$PurchaseOrder.Date$$Date and Time
Purchase Order Dropship Order CodeSingle Item$$PurchaseOrder.DropshipOrderCode$$String
Purchase Order Expected Delivery DateSingle Item$$PurchaseOrder.ExpectedDeliveryDate$$Date and Time
Purchase Order IDSingle Item$$PurchaseOrder.Id$$String
Purchase Order CodeSingle Item$$PurchaseOrder.OrderCode$$Number
Purchase Order Rows As HTML TableSingle Item$$PurchaseOrder.OrderRowsAsHtmlTable$$HTML table - Outdated
Purchase Order Rows Subtotal Excluding VATSingle Item$$PurchaseOrder.OrderRowsSubtotalExVat$$Number
Purchase Order Total Excluding VATSingle Item$$PurchaseOrder.OrderTotalExVat$$Number
Purchase Order Our ReferenceSingle Item$$PurchaseOrder.OurReference$$String
Purchase Order Shipping Costs Excluding VATSingle Item$$PurchaseOrder.ShippingCostsExVat$$Number
Purchase Order Supplier Invoice CodeSingle Item$$PurchaseOrder.SupplierInvoiceCode$$String
Purchase Order Supplier NoteSingle Item$$PurchaseOrder.SupplierNote$$String
Purchase Order Row CommentPurchaseOrderRow Collection$$PurchaseOrderRow.Comment$$String
Purchase Order Row IDPurchaseOrderRow Collection$$PurchaseOrderRow.Id$$String
Purchase Order Row Is DeliveredPurchaseOrderRow Collection$$PurchaseOrderRow.IsDelivered$$Boolean
Purchase Order Row Item Price Excluding VATPurchaseOrderRow Collection$$PurchaseOrderRow.ItemPriceExVat$$Number
Purchase Order Row Item QuantityPurchaseOrderRow Collection$$PurchaseOrderRow.ItemQuantity$$Number
Purchase Order Row Item Quantity DeliveredPurchaseOrderRow Collection$$PurchaseOrderRow.ItemQuantityDelivered$$Number
Purchase Order Row Item Quantity OutstandingPurchaseOrderRow Collection$$PurchaseOrderRow.ItemQuantityOutstanding$$Number
Purchase Order Row Product CodePurchaseOrderRow Collection$$PurchaseOrderRow.ProductCode$$String
Purchase Order Row Product DescriptionPurchaseOrderRow Collection$$PurchaseOrderRow.ProductDescription$$String
Purchase Order Row Product NamePurchaseOrderRow Collection$$PurchaseOrderRow.ProductName$$String
Purchase Order Row Purchase Order IDPurchaseOrderRow Collection$$PurchaseOrderRow.PurchaseOrderId$$String
Purchase Order Row Total Excluding VATPurchaseOrderRow Collection$$PurchaseOrderRow.RowTotalExVat$$Number
Purchase Order Row Supplier SkuPurchaseOrderRow Collection$$PurchaseOrderRow.SupplierSku$$String
Purchase Order Bill To Bank BICSingle Item$$PurchaseOrderBillTo.BankBic$$String
Purchase Order Bill To Bank IBANSingle Item$$PurchaseOrderBillTo.BankIban$$String
Purchase Order Bill To Bank NumberSingle Item$$PurchaseOrderBillTo.BankNr$$String
Purchase Order Bill To Chamber of CommerceSingle Item$$PurchaseOrderBillTo.ChamberOfCommerce$$String
Purchase Order Bill To Chamber of Commerce CitySingle Item$$PurchaseOrderBillTo.ChamberOfCommerceCity$$String
Purchase Order Bill To CitySingle Item$$PurchaseOrderBillTo.City$$String
Purchase Order Bill To Company NameSingle Item$$PurchaseOrderBillTo.CompanyName$$String
Purchase Order Bill To Country CodeSingle Item$$PurchaseOrderBillTo.CountryCode$$String
Purchase Order Bill To Country NameSingle Item$$PurchaseOrderBillTo.CountryName$$String
Purchase Order Bill To Display NameSingle Item$$PurchaseOrderBillTo.DisplayName$$String
Purchase Order Bill To EmailSingle Item$$PurchaseOrderBillTo.Email$$String
Purchase Order Bill To Full NameSingle Item$$PurchaseOrderBillTo.FullName$$String
Purchase Order Bill To Is Part Of The EUSingle Item$$PurchaseOrderBillTo.IsPartOfTheEu$$Boolean
Purchase Order Bill To Person TitleSingle Item$$PurchaseOrderBillTo.PersonTitle$$String
Purchase Order Bill To PhoneSingle Item$$PurchaseOrderBillTo.Phone$$String
Purchase Order Bill To Phone2Single Item$$PurchaseOrderBillTo.Phone2$$String
Purchase Order Bill To Postal CodeSingle Item$$PurchaseOrderBillTo.PostalCode$$String
Purchase Order Bill To State ProvinceSingle Item$$PurchaseOrderBillTo.StateProvince$$String
Purchase Order Bill To State Province CodeSingle Item$$PurchaseOrderBillTo.StateProvinceCode$$String
Purchase Order Bill To Street Address 1Single Item$$PurchaseOrderBillTo.StreetAddress1$$String
Purchase Order Bill To Street Address 2Single Item$$PurchaseOrderBillTo.StreetAddress2$$String
Purchase Order Bill To VAT NumberSingle Item$$PurchaseOrderBillTo.VatNumber$$String
Purchase Order Bank BICSingle Item$$PurchaseOrderShipTo.BankBic$$String
Purchase Order Bank IBANSingle Item$$PurchaseOrderShipTo.BankIban$$String
Purchase Order Bank NumberSingle Item$$PurchaseOrderShipTo.BankNr$$String
Purchase Order Chamber of CommerceSingle Item$$PurchaseOrderShipTo.ChamberOfCommerce$$String
Purchase Order Chamber of Commerce CitySingle Item$$PurchaseOrderShipTo.ChamberOfCommerceCity$$String
Purchase Order CitySingle Item$$PurchaseOrderShipTo.City$$String
Purchase Order Company NameSingle Item$$PurchaseOrderShipTo.CompanyName$$String
Purchase Order Country CodeSingle Item$$PurchaseOrderShipTo.CountryCode$$String
Purchase Order Country NameSingle Item$$PurchaseOrderShipTo.CountryName$$String
Purchase Order Display NameSingle Item$$PurchaseOrderShipTo.DisplayName$$String
Purchase Order EmailSingle Item$$PurchaseOrderShipTo.Email$$String
Purchase Order Full NameSingle Item$$PurchaseOrderShipTo.FullName$$String
Purchase Order Is Part Of The EUSingle Item$$PurchaseOrderShipTo.IsPartOfTheEu$$Boolean
Purchase Order PersonTitleSingle Item$$PurchaseOrderShipTo.PersonTitle$$String
Purchase Order PhoneSingle Item$$PurchaseOrderShipTo.Phone$$String
Purchase Order Phone2Single Item$$PurchaseOrderShipTo.Phone2$$String
Purchase Order Postal CodeSingle Item$$PurchaseOrderShipTo.PostalCode$$String
Purchase Order State ProvinceSingle Item$$PurchaseOrderShipTo.StateProvince$$String
Purchase Order State Province CodeSingle Item$$PurchaseOrderShipTo.StateProvinceCode$$String
Purchase Order Street Address 1Single Item$$PurchaseOrderShipTo.StreetAddress1$$String
Purchase Order Street Address 2Single Item$$PurchaseOrderShipTo.StreetAddress2$$String
Purchase Order VAT NumberSingle Item$$PurchaseOrderShipTo.VatNumber$$String
Relations
PurchaseOrderRow' links to 'PurchaseOrderRow'

Supplier

Show the list of Supplier merge fields
Merge field nameMerge field typeMerge fieldData type
Supplier Company NameSingle Item$$Supplier.CompanyName$$String
Supplier Contact RefSingle Item$$Supplier.ContactRef$$String
Supplier First NameSingle Item$$Supplier.FirstName$$String
Supplier Full NameSingle Item$$Supplier.FullName$$String
Supplier Last NameSingle Item$$Supplier.LastName$$String
Supplier Last Name PrefixSingle Item$$Supplier.LastNamePrefix$$String
Supplier Middle NameSingle Item$$Supplier.MiddleName$$String
Supplier Person TitleSingle Item$$Supplier.PersonTitle$$String
Supplier Bank BICSingle Item$$SupplierContactInfo.BankBic$$String
Supplier Bank IBANSingle Item$$SupplierContactInfo.BankIban$$String
Supplier Bank NumberSingle Item$$SupplierContactInfo.BankNr$$String
Supplier Chamber of CommerceSingle Item$$SupplierContactInfo.ChamberOfCommerce$$String
Supplier Chamber of Commerce CitySingle Item$$SupplierContactInfo.ChamberOfCommerceCity$$String
Supplier CitySingle Item$$SupplierContactInfo.City$$String
Supplier Company NameSingle Item$$SupplierContactInfo.CompanyName$$String
Supplier Country CodeSingle Item$$SupplierContactInfo.CountryCode$$String
Supplier Country NameSingle Item$$SupplierContactInfo.CountryName$$String
Supplier Display NameSingle Item$$SupplierContactInfo.DisplayName$$String
Supplier EmailSingle Item$$SupplierContactInfo.Email$$String
Supplier Full NameSingle Item$$SupplierContactInfo.FullName$$String
Supplier Is Part Of The EUSingle Item$$SupplierContactInfo.IsPartOfTheEu$$Boolean
Supplier PersonTitleSingle Item$$SupplierContactInfo.PersonTitle$$String
Supplier PhoneSingle Item$$SupplierContactInfo.Phone$$String
Supplier Phone2Single Item$$SupplierContactInfo.Phone2$$String
Supplier Postal CodeSingle Item$$SupplierContactInfo.PostalCode$$String
Supplier State ProvinceSingle Item$$SupplierContactInfo.StateProvince$$String
Supplier State Province CodeSingle Item$$SupplierContactInfo.StateProvinceCode$$String
Supplier Street Address 1Single Item$$SupplierContactInfo.StreetAddress1$$String
Supplier Street Address 2Single Item$$SupplierContactInfo.StreetAddress2$$String
Supplier VAT NumberSingle Item$$SupplierContactInfo.VatNumber$$String

Warehouse

Show the list of Warehouse merge fields
Merge field nameMerge field typeMerge fieldData type
Warehouse NameSingle Item$$Warehouse.Name$$String
Warehouse PrioritySingle Item$$Warehouse.Priority$$String
Warehouse TypeSingle Item$$Warehouse.WarehouseType$$String
Warehouse Location AisleSingle Item$$WarehouseLocation.Aisle$$String
Warehouse Location BaySingle Item$$WarehouseLocation.Bay$$String
Warehouse Location BinSingle Item$$WarehouseLocation.Bin$$String
Warehouse Location IDSingle Item$$WarehouseLocation.Id$$String
Warehouse Location NameSingle Item$$WarehouseLocation.Name$$String
Warehouse Location Scan CodeSingle Item$$WarehouseLocation.ScanCode$$Scan Code
Warehouse Location ShelfSingle Item$$WarehouseLocation.Shelf$$String

Stock Item

Merge field nameMerge field typeMerge fieldData type
Stock Item CommentSingle Item$$StockItem.Comment$$String
Stock Item Expiry DateSingle Item$$StockItem.ExpiryDate$$Date and Time
Stock Item IDSingle Item$$StockItem.Id$$String
Stock Item Lot NumberSingle Item$$StockItem.LotNumber$$String
Stock Item Scan CodeSingle Item$$StockItem.ScanCode$$Scan Code
Stock Item Serial NumberSingle Item$$StockItem.SerialNumber$$String
Stock Item Stock Item StatusSingle Item$$StockItem.StockItemStatus$$String

Product

Show the list of Product merge fields
Merge field nameMerge field typeMerge fieldData type
Product Changed TimestampSingle Item$$Product.ChangedTimestamp$$Date and Time
Product CodeSingle Item$$Product.Code$$String
Product Creation DateSingle Item$$Product.CreationDate$$Date and Time
Product DiameterSingle Item$$Product.Diameter$$Number
Product HeightSingle Item$$Product.Height$$Number
Product Is ShippableSingle Item$$Product.IsShippable$$Boolean
Product Keep StockSingle Item$$Product.KeepStock$$Boolean
Product LengthSingle Item$$Product.Length$$Number
Product Price Excluding VATSingle Item$$Product.PriceExVat$$Number
Product Price UoM IDSingle Item$$Product.PriceUomId$$String
Product GroupSingle Item$$Product.ProductProductGroup$$String
Product Property Def Set IDSingle Item$$Product.ProductPropertyDefSetId$$String
Product PublishedSingle Item$$Product.Published$$Boolean
Product Qty AvailableSingle Item$$Product.QtyAvailable$$Number
Product Qty On HandSingle Item$$Product.QtyOnHand$$Number
Product Qty OrderedSingle Item$$Product.QtyOrdered$$Number
Product Qty ReservedSingle Item$$Product.QtyReserved$$String
Product Ref CodeSingle Item$$Product.RefCode$$String
Product Requires Expiry DateSingle Item$$Product.RequiresExpiryDate$$Boolean
Product Requires Lot NumberSingle Item$$Product.RequiresLotNumber$$Boolean
Product Requires Serial NumberSingle Item$$Product.RequiresSerialNumber$$Boolean
Product Scan CodeSingle Item$$Product.ScanCode$$Scan Code
Product Size UoM IDSingle Item$$Product.SizeUomId$$String
Product Storage Life Pre-Warning DaysSingle Item$$Product.StorageLifePreWarningDays$$Number
Product VolumeSingle Item$$Product.Volume$$Number
Product Volume UoM IDSingle Item$$Product.VolumeUomId$$String
Product WeightSingle Item$$Product.Weight$$Number
Product Weight UoM IDSingle Item$$Product.WeightUomId$$String
Product WidthSingle Item$$Product.Width$$Number
Product NameSingle Item$$Product.Name$$String
Product DescriptionSingle Item$$Product.Description$$String
Product Description LongSingle Item$$Product.DescriptionLong$$String

Alerts notification

Show the list of Alerts merge fields
Merge field nameMerge field typeMerge fieldData type
Unread alert notification countSingle Item$$UnreadAlertNotification.Count$$Number
Alert urlSingle Item$$UnreadAlertNotification.AlertPageUrl$$Url
Main Shop nameSingle Item$$UnreadAlertNotification.MainShopName$$String
Single or plural suffixSingle Item$$UnreadAlertNotification.PluralSuffix$$String
Alert IdAlerts Collection$$Alerts.Id$$Number
Alerts TitleAlerts Collection$$Alerts.Title$$String
Alerts CategoryAlerts Collection$$Alerts.Category$$String
Alerts SeverityAlerts Collection$$Alerts.SeverityStr$$String
Alerts Create TimestampAlerts Collection$$Alerts.CreateTimestamp$$Date and Time
Alerts ChangedTimestampAlerts Collection$$Alerts.ChangedTimestamp$$Date and Time

What's Next