- 05 Apr 2023
- 39 Minutes to read
- Print
- DarkLight
- PDF
List of Merge Fields
- Updated on 05 Apr 2023
- 39 Minutes to read
- Print
- DarkLight
- PDF
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.
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 name | Merge field type | Merge field | Data type |
---|---|---|---|
Shop Owner Company Name | Single Item | $$ShopOwner.CompanyName$$ | String |
Shop Company Name | Single Item | $$Shop.CompanyName$$ | String |
Shop Country Code | Single Item | $$Shop.CountryCode$$ | String |
Shop Icon Url | Single Item | $$Shop.IconUrl$$ | String |
Shop Icon Url Img Tag | Single Item | $$Shop.IconUrlImgTag$$ | String |
Shop ID | Single Item | $$Shop.Id$$ | String |
Shop Logo | Single Item | $$Shop.Logo$$ | Image |
Shop Logo Url | Single Item | $$Shop.LogoUrl$$ | String |
Shop Logo Url Img Tag | Single Item | $$Shop.LogoUrlImgTag$$ | String |
Shop Name | Single Item | $$Shop.Name$$ | String |
Shop SEPA Paymee ID | Single Item | $$Shop.SepapayeeId$$ | String |
Shop Site Address | Single Item | $$Shop.SiteAddress$$ | String |
Shop Site Bank Account | Single Item | $$Shop.SiteBankAccount$$ | String |
Shop Site Bank Account IBAN | Single Item | $$Shop.SiteBankAccountIban$$ | String |
Shop Site Bank Name | Single Item | $$Shop.SiteBankName$$ | String |
Shop Site Bank SWIFT BIC | Single Item | $$Shop.SiteBankSwiftBic$$ | String |
Shop Site City | Single Item | $$Shop.SiteCity$$ | String |
Shop Site Chamber of Commerce | Single Item | $$Shop.SiteCoc$$ | String |
Shop Site Country Name | Single Item | $$Shop.SiteCountryName$$ | String |
Shop Site Director | Single Item | $$Shop.SiteDirector$$ | String |
Shop Site Disclaimer | Single Item | $$Shop.SiteDisclaimer$$ | String |
Shop Site Email | Single Item | $$Shop.SiteEmail$$ | String |
Shop Site Fax | Single Item | $$Shop.SiteFax$$ | String |
Shop Site Opening Hours | Single Item | $$Shop.SiteOpeningHours$$ | String |
Shop Site Phone | Single Item | $$Shop.SitePhone$$ | String |
Shop Site Postal Code | Single Item | $$Shop.SitePostalCode$$ | String |
Shop Site VAT Number | Single Item | $$Shop.SiteVatNumber$$ | String |
Shop Url | Single Item | $$Shop.Url$$ | String |
Shop Url Secure | Single Item | $$Shop.UrlSecure$$ | String |
Customer
Show the list of Customer merge fields
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Customer Bill To And Ship To Are The Same | Single Item | $$Customer.BillToAndShipToAreTheSame$$ | Boolean |
Customer Bill To VAT Number | Single Item | $$Customer.BillToVatNumber$$ | String |
Customer Company Name | Single Item | $$Customer.CompanyName$$ | String |
Customer Contact Ref | Single Item | $$Customer.ContactRef$$ | String |
Customer Customer Code | Single Item | $$Customer.CustomerCode$$ | String |
Customer Customer Number | Single Item | $$Customer.CustomerNumber$$ | String |
Customer Date Of Birth | Single Item | $$Customer.DateOfBirth$$ | Date and Time |
Customer Email | Single Item | $$Customer.Email$$ | String |
Customer First Name | Single Item | $$Customer.FirstName$$ | String |
Customer Full Name | Single Item | $$Customer.FullName$$ | String |
Customer Invoice Email Address | Single Item | $$Customer.InvoiceEmailAddress$$ | String |
Customer Last Name | Single Item | $$Customer.LastName$$ | String |
Customer Last Name Prefix | Single Item | $$Customer.LastNamePrefix$$ | String |
Customer Middle Name | Single Item | $$Customer.MiddleName$$ | String |
Customer Order Remark | Single Item | $$Customer.OrderRemark$$ | String |
Customer Personal Number | Single Item | $$Customer.PersonalNumber$$ | String |
Customer Person Title | Single Item | $$Customer.PersonTitle$$ | String |
Customer Reminder Invoice Email Address | Single Item | $$Customer.ReminderInvoiceEmailAddress$$ | String |
Order
Show the list of Order merge fields
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Order Bill To Address | Single Item | $$Order.BillToAddress$$ | String |
Order Bill To Address 2 | Single Item | $$Order.BillToAddress2$$ | String |
Order Bill To AndShip To AreTheSame | Single Item | $$Order.BillToAndShipToAreTheSame$$ | String |
Order Bill To City | Single Item | $$Order.BillToCity$$ | String |
Order Bill To Company | Single Item | $$Order.BillToCompany$$ | String |
Order Bill To Country | Single Item | $$Order.BillToCountry$$ | String |
Order Bill To Country Code | Single Item | $$Order.BillToCountryCode$$ | String |
Order Bill To Email | Single Item | $$Order.BillToEmail$$ | String |
Order Bill To Fax | Single Item | $$Order.BillToFax$$ | String |
Order Bill To First Name | Single Item | $$Order.BillToFirstName$$ | String |
Order Bill To Last Name | Single Item | $$Order.BillToLastName$$ | String |
Order Bill To Last Name Prefix | Single Item | $$Order.BillToLastNamePrefix$$ | String |
Order Bill To Name | Single Item | $$Order.BillToName$$ | String |
Order Bill To PersonTitle | Single Item | $$Order.BillToPersonTitle$$ | String |
Order Bill To Phone | Single Item | $$Order.BillToPhone$$ | String |
Order Bill To Phone2 | Single Item | $$Order.BillToPhone2$$ | String |
Order Bill To State | Single Item | $$Order.BillToState$$ | String |
Order Bill To State Province | Single Item | $$Order.BillToStateProvince$$ | String |
Order Bill To Street Address | Single Item | $$Order.BillToStreetAddress$$ | String |
Order Bill To Street Address Additional Info | Single Item | $$Order.BillToStreetAddressAdditionalInfo$$ | String |
Order Bill To Street Address Extension | Single Item | $$Order.BillToStreetAddressExtension$$ | String |
Order Bill To VAT Number | Single Item | $$Order.BillToVatNumber$$ | String |
Order Bill To Zip | Single Item | $$Order.BillToZip$$ | String |
Order Carrier Account Name | Single Item | $$Order.CarrierAccountName$$ | String |
Order Checkout Url | Single Item | $$Order.CheckoutUrl$$ | String |
Order Coupon Code | Single Item | $$Order.CouponCode$$ | String |
Order CouponDiscount | Single Item | $$Order.CouponDiscount$$ | String |
Order Currency Code | Single Item | $$Order.CurrencyCode$$ | String |
Order Currency Symbol | Single Item | $$Order.CurrencySymbol$$ | String |
Order Customer Culture Code | Single Item | $$Order.CustomerCultureCode$$ | String |
Order Customer Note | Single Item | $$Order.CustomerNote$$ | String |
Order Customer Reference | Single Item | $$Order.CustomerReference$$ | String |
Order CustomOrder Status ActionDate | Single Item | $$Order.CustomOrderStatusActionDate$$ | String |
Order CustomOrder Status Comment | Single Item | $$Order.CustomOrderStatusComment$$ | String |
Order Date | Single Item | $$Order.Date$$ | Date and Time |
Order Discount Excluding VAT | Single Item | $$Order.DiscountExVat$$ | Number |
Order Discount Including VAT | Single Item | $$Order.DiscountIncVat$$ | Number |
Order Down Payment | Single Item | $$Order.DownPayment$$ | Number |
Order Down Payment In Base Currency | Single Item | $$Order.DownPaymentInBaseCurrency$$ | Number |
Order Down Payment Rest Amount | Single Item | $$Order.DownPaymentRestAmount$$ | Number |
Order Down Payment Rest Amount In Base Currency | Single Item | $$Order.DownPaymentRestAmountInBaseCurrency$$ | Number |
Order External Order Key | Single Item | $$Order.ExternalOrderKey$$ | String |
Order Has Registered Serial Numbers | Single Item | $$Order.HasRegisteredSerialNumbers$$ | Boolean |
Order Has Rows With Discount | Single Item | $$Order.HasRowsWithDiscount$$ | Boolean |
Order ID | Single Item | $$Order.Id$$ | String |
Order Is Paid | Single Item | $$Order.IsPaid$$ | Boolean |
Order MainOrder Status ActionDate | Single Item | $$Order.MainOrderStatusActionDate$$ | String |
Order MainOrder Status Comment | Single Item | $$Order.MainOrderStatusComment$$ | String |
Order Code | Single Item | $$Order.OrderCode$$ | String |
Order Products As HTML Table | Single Item | $$Order.OrderProductsAsHtmlTable$$ | HTML table - Outdated |
Order Rows As HTML Table | Single Item | $$Order.OrderRowsAsHtmlTable$$ | HTML table - Outdated |
Order Rows As Plain HTML Table | Single Item | $$Order.OrderRowsAsPlainHtmlTable$$ | HTML table - Outdated |
Order Rows Subtotal Excluding VAT | Single Item | $$Order.OrderRowsSubtotalExVat$$ | Number |
Order Rows Subtotal Including VAT | Single Item | $$Order.OrderRowsSubtotalIncVat$$ | Number |
Order Rows Without Article Code As HTML Table | Single Item | $$Order.OrderRowsWithoutArticleCodeAsHtmlTable$$ | HTML table - Outdated |
Order Rows With Price Excluding VAT As HTML Table | Single Item | $$Order.OrderRowsWithPriceExVatAsHtmlTable$$ | HTML table - Outdated |
Order Rows With Price Inc As Plain HTML Table | Single Item | $$Order.OrderRowsWithPriceIncAsPlainHtmlTable$$ | HTML table - Outdated |
Order Total | Single Item | $$Order.OrderTotal$$ | Number |
Order Total Excluding VAT | Single Item | $$Order.OrderTotalExVat$$ | Number |
Order Total In Base Currency | Single Item | $$Order.OrderTotalInBaseCurrency$$ | Number |
Order Total Including VAT In Base Currency | Single Item | $$Order.OrderTotalIncVatInBaseCurrency$$ | Number |
Order Payment Fee Excluding VAT | Single Item | $$Order.PaymentFeeExVat$$ | Number |
Order Payment Fee Including VAT | Single Item | $$Order.PaymentFeeIncVat$$ | Number |
Order Payment Order Status ActionDate | Single Item | $$Order.PaymentOrderStatusActionDate$$ | String |
Order Payment Order Status Comment | Single Item | $$Order.PaymentOrderStatusComment$$ | String |
Order Payment Type Code | Single Item | $$Order.PaymentTypeCode$$ | String |
Order Payment Type ID | Single Item | $$Order.PaymentTypeId$$ | String |
Order Preferred Delivery Date | Single Item | $$Order.PreferredDeliveryDate$$ | Date and Time |
Order Registered Serial Numbers | Single Item | $$Order.RegisteredSerialNumbers$$ | String |
Order Shipment Order Status ActionDate | Single Item | $$Order.ShipmentOrderStatusActionDate$$ | String |
Order Shipment Order Status Comment | Single Item | $$Order.ShipmentOrderStatusComment$$ | String |
Order Shipments Package Count | Single Item | $$Order.ShipmentsPackageCount$$ | Number |
Order Shipment Tracking Codes | Single Item | $$Order.ShipmentTrackingCodes$$ | String |
Order Shipping Costs Excluding VAT | Single Item | $$Order.ShippingCostsExVat$$ | Number |
Order Shipping Costs Including VAT | Single Item | $$Order.ShippingCostsIncVat$$ | Number |
Order Ship To Address | Single Item | $$Order.ShipToAddress$$ | String |
Order Ship To Address 2 | Single Item | $$Order.ShipToAddress2$$ | String |
Order Ship To City | Single Item | $$Order.ShipToCity$$ | String |
Order Ship To Company | Single Item | $$Order.ShipToCompany$$ | String |
Order Ship To Country | Single Item | $$Order.ShipToCountry$$ | String |
Order Ship To Country Code | Single Item | $$Order.ShipToCountryCode$$ | String |
Order Ship To Email | Single Item | $$Order.ShipToEmail$$ | String |
Order Ship To Fax | Single Item | $$Order.ShipToFax$$ | String |
Order Ship To First Name | Single Item | $$Order.ShipToFirstName$$ | String |
Order Ship To Last Name | Single Item | $$Order.ShipToLastName$$ | String |
Order Ship To Last Name Prefix | Single Item | $$Order.ShipToLastNamePrefix$$ | String |
Order Ship To Name | Single Item | $$Order.ShipToName$$ | String |
Order Ship To PersonTitle | Single Item | $$Order.ShipToPersonTitle$$ | String |
Order Ship To Phone | Single Item | $$Order.ShipToPhone$$ | String |
Order Ship To Phone2 | Single Item | $$Order.ShipToPhone2$$ | String |
Order Ship To State | Single Item | $$Order.ShipToState$$ | String |
Order Ship To State Province | Single Item | $$Order.ShipToStateProvince$$ | String |
Order Ship To Street Address | Single Item | $$Order.ShipToStreetAddress$$ | String |
Order Ship To Street Address Additional Info | Single Item | $$Order.ShipToStreetAddressAdditionalInfo$$ | String |
Order Ship To Street Address Extension | Single Item | $$Order.ShipToStreetAddressExtension$$ | String |
Order Ship To Zip | Single Item | $$Order.ShipToZip$$ | String |
Order Stock Order Status ActionDate | Single Item | $$Order.StockOrderStatusActionDate$$ | String |
Order Stock Order Status Comment | Single Item | $$Order.StockOrderStatusComment$$ | String |
Order Sum Payments | Single Item | $$Order.SumPayments$$ | Number |
Order Total Due | Single Item | $$Order.TotalDue$$ | Number |
Order Total Due In Base Currency | Single Item | $$Order.TotalDueInBaseCurrency$$ | Number |
Order Total Invoiced | Single Item | $$Order.TotalInvoiced$$ | Number |
Order Total Received | Single Item | $$Order.TotalReceived$$ | Number |
Order Total Received In Base Currency | Single Item | $$Order.TotalReceivedInBaseCurrency$$ | Number |
Order Tracking Url | Single Item | $$Order.TrackingUrl$$ | String |
Order Tracking Url Link | Single Item | $$Order.TrackingUrlLink$$ | String |
Order VAT Total | Single Item | $$Order.VatTotal$$ | Number |
Order Bill To Bank Bic | Single Item | $$OrderBillTo.BankBic$$ | String |
Order Bill To Bank Iban | Single Item | $$OrderBillTo.BankIban$$ | String |
Order Bill To Bank Number | Single Item | $$OrderBillTo.BankNr$$ | String |
Order Bill To Chamber of Commerce | Single Item | $$OrderBillTo.ChamberOfCommerce$$ | String |
Order Bill To Chamber of Commerce City | Single Item | $$OrderBillTo.ChamberOfCommerceCity$$ | String |
Order Bill To City | Single Item | $$OrderBillTo.City$$ | String |
Order Bill To Company Name | Single Item | $$OrderBillTo.CompanyName$$ | String |
Order Bill To Country Code | Single Item | $$OrderBillTo.CountryCode$$ | String |
Order Bill To Country Name | Single Item | $$OrderBillTo.CountryName$$ | String |
Order Bill To Display Name | Single Item | $$OrderBillTo.DisplayName$$ | String |
Order Bill To Email | Single Item | $$OrderBillTo.Email$$ | String |
Order Bill To Full Name | Single Item | $$OrderBillTo.FullName$$ | String |
Order Bill To Is Part Of The EU | Single Item | $$OrderBillTo.IsPartOfTheEu$$ | Boolean |
Order Bill To PersonTitle | Single Item | $$OrderBillTo.PersonTitle$$ | String |
Order Bill To Phone | Single Item | $$OrderBillTo.Phone$$ | String |
Order Bill To Phone2 | Single Item | $$OrderBillTo.Phone2$$ | String |
Order Bill To Postal Code | Single Item | $$OrderBillTo.PostalCode$$ | String |
Order Bill To State Province | Single Item | $$OrderBillTo.StateProvince$$ | String |
Order Bill To State Province Code | Single Item | $$OrderBillTo.StateProvinceCode$$ | String |
Order Bill To Street Address 1 | Single Item | $$OrderBillTo.StreetAddress1$$ | String |
Order Bill To Street Address 2 | Single Item | $$OrderBillTo.StreetAddress2$$ | String |
Order Bill To VAT Number | Single Item | $$OrderBillTo.VatNumber$$ | String |
Order Ship To Bank Bic | Single Item | $$OrderShipTo.BankBic$$ | String |
Order Ship To Bank Iban | Single Item | $$OrderShipTo.BankIban$$ | String |
Order Ship To Bank Number | Single Item | $$OrderShipTo.BankNr$$ | String |
Order Ship To Chamber of Commerce | Single Item | $$OrderShipTo.ChamberOfCommerce$$ | String |
Order Ship To Chamber of Commerce City | Single Item | $$OrderShipTo.ChamberOfCommerceCity$$ | String |
Order Ship To City | Single Item | $$OrderShipTo.City$$ | String |
Order Ship To Company Name | Single Item | $$OrderShipTo.CompanyName$$ | String |
Order Ship To Country Code | Single Item | $$OrderShipTo.CountryCode$$ | String |
Order Ship To Country Name | Single Item | $$OrderShipTo.CountryName$$ | String |
Order Ship To Display Name | Single Item | $$OrderShipTo.DisplayName$$ | String |
Order Ship To Email | Single Item | $$OrderShipTo.Email$$ | String |
Order Ship To Full Name | Single Item | $$OrderShipTo.FullName$$ | String |
Order Ship To Is Part Of The EU | Single Item | $$OrderShipTo.IsPartOfTheEu$$ | Boolean |
Order Ship To PersonTitle | Single Item | $$OrderShipTo.PersonTitle$$ | String |
Order Ship To Phone | Single Item | $$OrderShipTo.Phone$$ | String |
Order Ship To Phone2 | Single Item | $$OrderShipTo.Phone2$$ | String |
Order Ship To Postal Code | Single Item | $$OrderShipTo.PostalCode$$ | String |
Order Ship To State Province | Single Item | $$OrderShipTo.StateProvince$$ | String |
Order Ship To State Province Code | Single Item | $$OrderShipTo.StateProvinceCode$$ | String |
Order Ship To Street Address 1 | Single Item | $$OrderShipTo.StreetAddress1$$ | String |
Order Ship To Street Address 2 | Single Item | $$OrderShipTo.StreetAddress2$$ | String |
Order Ship To VAT Number | Single Item | $$OrderShipTo.VatNumber$$ | String |
Order Row Allocation Item Quantity | OrderRow Collection | $$OrderRow.AllocationItemQuantity$$ | Number |
Order Row Comment | OrderRow Collection | $$OrderRow.Comment$$ | String |
Order Row ID | OrderRow Collection | $$OrderRow.Id$$ | String |
Order Row Item Base Price Excluding VAT | OrderRow Collection | $$OrderRow.ItemBasePriceExVat$$ | Number |
Order Row Item Base Price Including VAT | OrderRow Collection | $$OrderRow.ItemBasePriceIncVat$$ | Number |
Order Row Item Price Excluding VAT | OrderRow Collection | $$OrderRow.ItemPriceExVat$$ | Number |
Order Row Item Price Including VAT | OrderRow Collection | $$OrderRow.ItemPriceIncVat$$ | Number |
Order Row Item Purchase Price | OrderRow Collection | $$OrderRow.ItemPurchasePrice$$ | Number |
Order Row Item Quantity | OrderRow Collection | $$OrderRow.ItemQuantity$$ | Number |
Order Row Item VAT Amount | OrderRow Collection | $$OrderRow.ItemVatAmount$$ | Number |
Order Row Number Of Items Invoiced | OrderRow Collection | $$OrderRow.NrOfItemsInvoiced$$ | Number |
Order Row Number Of Items Refunded | OrderRow Collection | $$OrderRow.NrOfItemsRefunded$$ | Number |
Order Row Order ID | OrderRow Collection | $$OrderRow.OrderId$$ | String |
Order Row Order Shipment ID | OrderRow Collection | $$OrderRow.OrderShipmentId$$ | String |
Order Row Product Code | OrderRow Collection | $$OrderRow.ProductCode$$ | String |
Order Row Product Country Of Origin | OrderRow Collection | $$OrderRow.ProductCountryOfOrigin$$ | String |
Order Row Product Description | OrderRow Collection | $$OrderRow.ProductDescription$$ | String |
Order Row Product EAN | OrderRow Collection | $$OrderRow.ProductEAN$$ | String |
Order Row Product HS Code | OrderRow Collection | $$OrderRow.ProductHscode$$ | String |
Order Row Product HS Code2 | OrderRow Collection | $$OrderRow.ProductHscode2$$ | String |
Order Row Product Name | OrderRow Collection | $$OrderRow.ProductName$$ | String |
Order Row Product Weight, Kg | OrderRow Collection | $$OrderRow.ProductWeightKg$$ | Number |
Order Row Discount Excluding VAT | OrderRow Collection | $$OrderRow.RowDiscountExVat$$ | Number |
Order Row Discount Including VAT | OrderRow Collection | $$OrderRow.RowDiscountIncVat$$ | Number |
Order Row Total Excluding VAT | OrderRow Collection | $$OrderRow.RowTotalExVat$$ | Number |
Order Row Total Including VAT | OrderRow Collection | $$OrderRow.RowTotalIncVat$$ | Number |
Order Row VAT Amount | OrderRow Collection | $$OrderRow.RowVatAmount$$ | Number |
Order Row Shop Product Image Url | OrderRow Collection | $$OrderRow.ShopProductImageUrl$$ | String |
Order Row Stock Status | OrderRow Collection | $$OrderRow.StockStatus$$ | String |
Order Row VAT perc | OrderRow Collection | $$OrderRow.Vatperc$$ | Number |
Order Row Base Product Name | OrderRow Collection | $$OrderRow.BaseProductName$$ | String |
Order Row Product Name Translation | OrderRow Collection | $$OrderRow.ProductNameTranslation$$ | String |
Order Row Product DescriptionTranslation | OrderRow Collection | $$OrderRow.ProductDescriptionTranslation$$ | String |
Fields | OrderGroupedVatSum Collection | Fields | |
Order Grouped VAT Sum Total Excluding VAT | OrderGroupedVatSum Collection | $$OrderGroupedVatSum.TotalExVat$$ | Number |
Order Grouped VAT Sum Total Including VAT | OrderGroupedVatSum Collection | $$OrderGroupedVatSum.TotalIncVat$$ | Number |
Order Grouped VAT Sum VAT Code | OrderGroupedVatSum Collection | $$OrderGroupedVatSum.VatCode$$ | Number |
Order Grouped VAT Sum VAT Perc | OrderGroupedVatSum Collection | $$OrderGroupedVatSum.VatPerc$$ | Number |
Order Grouped VAT Sum VAT TariffID | OrderGroupedVatSum Collection | $$OrderGroupedVatSum.VatTariffId$$ | Number |
Order Grouped VAT Sum VAT Total | OrderGroupedVatSum Collection | $$OrderGroupedVatSum.VatTotal$$ | Number |
Payment Type Code | Single Item | $$PaymentType.Code$$ | String |
Payment Type ID | Single Item | $$PaymentType.Id$$ | String |
Payment Type Is Auto Collect Type | Single Item | $$PaymentType.IsAutoCollectType$$ | Boolean |
Payment Type Is Bank Transfer | Single Item | $$PaymentType.IsBankTransfer$$ | Boolean |
Payment Type Is Cash On Delivery | Single Item | $$PaymentType.IsCashOnDelivery$$ | Boolean |
Payment Type Is Direct Money Transfer | Single Item | $$PaymentType.IsDirectMoneyTransfer$$ | Boolean |
Payment Type Is Payment On Invoice | Single Item | $$PaymentType.IsPaymentOnInvoice$$ | Boolean |
Product Registration Comment | ProductRegistration Collection | $$ProductRegistration.Comment$$ | String |
Product Registration Order Row ID | ProductRegistration Collection | $$ProductRegistration.OrderRowId$$ | String |
Product Registration Serial Number | ProductRegistration Collection | $$ProductRegistration.SerialNumber$$ | String |
Product Registration Use By Date | ProductRegistration 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 name | Merge field type | Merge field | Data type |
---|---|---|---|
Order Expected Delivery Date | Single Item | $$Order.ExpectedDeliveryDate$$ | Date |
Order Expected Delivery Date Week | Single Item | $$Order.ExpectedDeliveryWeek$$ | Number |
Order Row Expected Delivery Date | Order Row Collection | $$Order Row.ExpectedDeliveryDate$$ | Date |
Order Row Expected Delivery Date Change Status | Order Row Collection | $$Order Row.ExpectedDeliveryDateChange$$ | String |
Order Row Expected Delivery Date Status value | Order Row Collection | $$Order Row.ExpectedDeliveryDateStatusEnumValue$$ | Number |
Order Row Expected Delivery Date Week | Order Row Collection | $$Order Row.ExpectedDeliveryWeek$$ | Number |
Order Row Previous Expected Delivery Date | Order Row Collection | $$Order Row.PreviousExpectedDeliveryDate$$ | Date |
Expected Delivery Date Change Allocation Item Quantity | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.AllocationItemQuantity$$ | Number |
Expected Delivery Date Change Comment | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.Comment$$ | String |
Expected Delivery Date Change Expected Delivery Date | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ExpectedDeliveryDate$$ | Date |
Expected Delivery Date Change Expected Delivery Date Change | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ExpectedDeliveryDateChange$$ | String |
Expected Delivery Date Change Expected Delivery Date Status Enum Value | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ExpectedDeliveryDateStatusEnumValue$$ | Number |
Expected Delivery Date Change Expected Delivery Week | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ExpectedDeliveryWeek$$ | Number |
Expected Delivery Date Change Id | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.Id$$ | Number |
Expected Delivery Date Change Item Base PriceExVat | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ItemBasePriceExVat$$ | Number |
Expected Delivery Date Change Item Base PriceIncVat | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ItemBasePriceIncVat$$ | Number |
Expected Delivery Date Change Item Price ExVat | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ItemPriceExVat$$ | Number |
Expected Delivery Date Change Item Price Inc Vat | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ItemPriceIncVat$$ | Number |
Expected Delivery Date Change Item Purchase Price | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ItemPurchasePrice$$ | Number |
Expected Delivery Date Change Item Quantity | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ItemQuantity$$ | Number |
Expected Delivery Date Change Item Vat Amount | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ItemVatAmount$$ | Number |
Expected Delivery Date Change NrOfItems Invoiced | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.NrOfItemsInvoiced$$ | Number |
Expected Delivery Date Change NrOfItems Refunded | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.NrOfItemsRefunded$$ | Number |
Expected Delivery Date Change OrderId | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.OrderId$$ | Number |
Expected Delivery Date Change Order Shipment Id | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.OrderShipmentId$$ | Number |
Expected Delivery Date Change PreviousExpectedDeliveryDate | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.PreviousExpectedDeliveryDate$$ | Date |
Expected Delivery Date Change Product Code | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ProductCode$$ | String |
Expected Delivery Date Change Product Country Of Origin | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ProductCountryOfOrigin$$ | String |
Expected Delivery Date Change Product Description | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ProductDescription$$ | String |
Expected Delivery Date Change Product EAN | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ProductEAN$$ | Number |
Expected Delivery Date Change Product Hscode | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ProductHscode$$ | Number |
Expected Delivery Date Change Product Hscode2 | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ProductHscode2$$ | Number |
Expected Delivery Date Change Product Name | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ProductName$$ | String |
Expected Delivery Date Change Product WeightKg | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ProductWeightKg$$ | Number |
Expected Delivery Date Change Row Discount ExVat | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.RowDiscountExVat$$ | Number |
Expected Delivery Date Change Row Discount IncVat | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.RowDiscountIncVat$$ | Number |
Expected Delivery Date Change Row Total ExVat | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.RowTotalExVat$$ | Number |
Expected Delivery Date Change Row Total IncVat | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.RowTotalIncVat$$ | Number |
Expected Delivery Date Change Row Vat Amount | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.RowVatAmount$$ | Number |
Expected Delivery Date Change Shipped | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.Shipped$$ | Boolean |
Expected Delivery Date Change Shop Product Image Url | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.ShopProductImageUrl$$ | Url |
Expected Delivery Date Change Stock Status | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.StockStatus$$ | String |
Expected Delivery Date Change Vat perc | Expected Delivery Date Change Collection | $$ExpectedDeliveryDateChange.Vatperc$$ | Number |
Relations
'ExpectedDeliveryDateChangeRows' links to ExpectedDeliveryDateChange
Invoice
Show the list of Invoice merge fields
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Invoice Auto Collect Date | Single Item | $$Invoice.AutoCollectDate$$ | Date and Time |
Invoice Auto Collect Days | Single Item | $$Invoice.AutoCollectDays$$ | Date and Time |
Invoice Currency Symbol | Single Item | $$Invoice.CurrencySymbol$$ | String |
Invoice Customer Reference | Single Item | $$Invoice.CustomerReference$$ | String |
Invoice Discount Excluding VAT | Single Item | $$Invoice.DiscountExVat$$ | Number |
Invoice Discount Including VAT | Single Item | $$Invoice.DiscountIncVat$$ | Number |
Invoice External Invoice Code | Single Item | $$Invoice.ExternalInvoiceCode$$ | String |
Invoice Has Rows With Discount | Single Item | $$Invoice.HasRowsWithDiscount$$ | Boolean |
Invoice ID | Single Item | $$Invoice.Id$$ | String |
Invoice Code | Single Item | $$Invoice.InvoiceCode$$ | String |
Invoice Date | Single Item | $$Invoice.InvoiceDate$$ | Date and Time |
Invoice Rows Subtotal Excluding VAT | Single Item | $$Invoice.InvoiceRowsSubtotalExVat$$ | Number |
Invoice Rows Subtotal Including VAT | Single Item | $$Invoice.InvoiceRowsSubtotalIncVat$$ | Number |
Invoice Total Excluding VAT | Single Item | $$Invoice.InvoiceTotalExVat$$ | Number |
Invoice Total Including VAT | Single Item | $$Invoice.InvoiceTotalIncVat$$ | Number |
Invoice Total Including VAT In Base Currency | Single Item | $$Invoice.InvoiceTotalIncVatInBaseCurrency$$ | Number |
Invoice Is Concept | Single Item | $$Invoice.IsConcept$$ | Boolean |
Invoice Is CreditInvoice | Single Item | $$Invoice.IsCreditInvoice$$ | Boolean |
Invoice Is Must Pay Before Expired | Single Item | $$Invoice.IsMustPayBeforeExpired$$ | Boolean |
Invoice Is Not Credit Invoice | Single Item | $$Invoice.IsNotCreditInvoice$$ | Boolean |
Invoice Is NotPaid | Single Item | $$Invoice.IsNotPaid$$ | Boolean |
Invoice Is Paid | Single Item | $$Invoice.IsPaid$$ | Boolean |
Invoice Is Reminder Invoice | Single Item | $$Invoice.IsReminderInvoice$$ | Boolean |
Invoice Is VAT FreeInvoice | Single Item | $$Invoice.IsVatFreeInvoice$$ | Boolean |
Invoice Is Zero Amount Invoice | Single Item | $$Invoice.IsZeroAmountInvoice$$ | Boolean |
Invoice Must Pay Before | Single Item | $$Invoice.MustPayBefore$$ | Date and Time |
Invoice Note | Single Item | $$Invoice.Note$$ | String |
Invoice Payment Fee Excluding VAT | Single Item | $$Invoice.PaymentFeeExVat$$ | Number |
Invoice Payment Fee Including VAT | Single Item | $$Invoice.PaymentFeeIncVat$$ | Number |
Invoice Payment Terms Days To Pay | Single Item | $$Invoice.PaymentTermsDaysToPay$$ | Number |
Invoice Payment Terms Name | Single Item | $$Invoice.PaymentTermsName$$ | String |
Invoice Payment Type Code | Single Item | $$Invoice.PaymentTypeCode$$ | String |
Invoice Reminder Create Date | Single Item | $$Invoice.ReminderCreateDate$$ | Date and Time |
Invoice Shipping Costs Excluding VAT | Single Item | $$Invoice.ShippingCostsExVat$$ | Number |
Invoice Shipping Costs Including VAT | Single Item | $$Invoice.ShippingCostsIncVat$$ | Number |
Invoice Shipping Costs VAT | Single Item | $$Invoice.ShippingCostsVat$$ | Number |
Invoice Sum Payments | Single Item | $$Invoice.SumPayments$$ | Number |
Invoice Total Due | Single Item | $$Invoice.TotalDue$$ | Number |
Invoice Total Due In Base Currency | Single Item | $$Invoice.TotalDueInBaseCurrency$$ | Number |
Invoice VAT Total | Single Item | $$Invoice.VatTotal$$ | Number |
Invoice Row Comment | InvoiceRow Collection | $$InvoiceRow.Comment$$ | String |
Invoice Row Discount Excluding VAT | InvoiceRow Collection | $$InvoiceRow.DiscountExVat$$ | Number |
Invoice Row Discount Including VAT | InvoiceRow Collection | $$InvoiceRow.DiscountIncVat$$ | Number |
Invoice Row ID | InvoiceRow Collection | $$InvoiceRow.Id$$ | String |
Invoice Row Invoice ID | InvoiceRow Collection | $$InvoiceRow.InvoiceId$$ | String |
Invoice Row Item Price Excluding VAT | InvoiceRow Collection | $$InvoiceRow.ItemPriceExVat$$ | Number |
Invoice Row Item Price Including VAT | InvoiceRow Collection | $$InvoiceRow.ItemPriceIncVat$$ | Number |
Invoice Row Item Quantity | InvoiceRow Collection | $$InvoiceRow.ItemQuantity$$ | Number |
Invoice Row Item VAT Amount | InvoiceRow Collection | $$InvoiceRow.ItemVatAmount$$ | Number |
Invoice Row Order Row ID | InvoiceRow Collection | $$InvoiceRow.OrderRowId$$ | String |
Invoice Row Product Code | InvoiceRow Collection | $$InvoiceRow.ProductCode$$ | String |
Invoice Row Product Country Of Origin | InvoiceRow Collection | $$InvoiceRow.ProductCountryOfOrigin$$ | String |
Invoice Row Product HS Code | InvoiceRow Collection | $$InvoiceRow.ProductHsCode$$ | String |
Invoice Row Product HS Code 2 | InvoiceRow Collection | $$InvoiceRow.ProductHsCode2$$ | String |
Invoice Row Product Name | InvoiceRow Collection | $$InvoiceRow.ProductName$$ | String |
Invoice Row Total Excluding VAT | InvoiceRow Collection | $$InvoiceRow.RowTotalExVat$$ | Number |
Invoice Row Total Including VAT | InvoiceRow Collection | $$InvoiceRow.RowTotalIncVat$$ | Number |
Invoice Row VAT Amount | InvoiceRow Collection | $$InvoiceRow.RowVatAmount$$ | Number |
Invoice Row VAT perc | InvoiceRow Collection | $$InvoiceRow.Vatperc$$ | Number |
Invoice Row Stock Item Row Count | InvoiceRow Collection | $$InvoiceRow.StockItemRowCount$$ | Number |
Invoice Row Base Product Name | InvoiceRow Collection | $$InvoiceRow.BaseProductName$$ | String |
Invoice Row Product Name Translation | InvoiceRow Collection | $$InvoiceRow.ProductNameTranslation$$ | String |
Invoice Row Product DescriptionTranslation | InvoiceRow Collection | $$InvoiceRow.ProductDescriptionTranslation$$ | String |
Invoice Stock Item Expiry Date | InvoiceStockItem Collection | $$InvoiceStockItem.ExpiryDate$$ | String |
Invoice Stock Item ID | InvoiceStockItem Collection | $$InvoiceStockItem.Id$$ | String |
Invoice Stock Item Lot Number | InvoiceStockItem Collection | $$InvoiceStockItem.LotNumber$$ | String |
Invoice Stock Item Order Row ID | InvoiceStockItem Collection | $$InvoiceStockItem.OrderRowId$$ | String |
Invoice Stock Item Serial Number | InvoiceStockItem Collection | $$InvoiceStockItem.SerialNumber$$ | String |
Grouped VAT Sum Total Excluding VAT | GroupedVatSum Collection | $$GroupedVatSum.TotalExVat$$ | Number |
Grouped VAT Sum Total Including VAT | GroupedVatSum Collection | $$GroupedVatSum.TotalIncVat$$ | Number |
Grouped VAT Sum VAT Code | GroupedVatSum Collection | $$GroupedVatSum.VatCode$$ | Number |
Grouped VAT Sum VAT Perc | GroupedVatSum Collection | $$GroupedVatSum.VatPerc$$ | Number |
Grouped VAT Sum VAT TariffID | GroupedVatSum Collection | $$GroupedVatSum.VatTariffId$$ | Number |
Grouped VAT Sum VAT Total | GroupedVatSum Collection | $$GroupedVatSum.VatTotal$$ | Number |
Invoice Shipment Invoice ID | InvoiceShipment Collection | $$InvoiceShipment.InvoiceId$$ | String |
Invoice Shipment Order Shipment ID | InvoiceShipment Collection | $$InvoiceShipment.OrderShipmentId$$ | String |
Invoice Shipment Packed Timestamp | InvoiceShipment Collection | $$InvoiceShipment.PackedTimestamp$$ | Date and Time |
Invoice Shipment Shipped Timestamp | InvoiceShipment Collection | $$InvoiceShipment.ShippedTimestamp$$ | Date and Time |
Invoice Shipment Shipping Code | InvoiceShipment 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 name | Merge field type | Merge field | Data type |
---|---|---|---|
Offer Bill To Address | Single Item | $$Offer.BillToAddress$$ | String |
Offer Bill To Address 2 | Single Item | $$Offer.BillToAddress2$$ | String |
Offer Bill To And Ship To Are The Same | Single Item | $$Offer.BillToAndShipToAreTheSame$$ | Boolean |
Offer Bill To City | Single Item | $$Offer.BillToCity$$ | String |
Offer Bill To Company | Single Item | $$Offer.BillToCompany$$ | String |
Offer Bill To Country | Single Item | $$Offer.BillToCountry$$ | String |
Offer Bill To Country Code | Single Item | $$Offer.BillToCountryCode$$ | String |
Offer Bill To Email | Single Item | $$Offer.BillToEmail$$ | String |
Offer Bill To Fax | Single Item | $$Offer.BillToFax$$ | String |
Offer Bill To First Name | Single Item | $$Offer.BillToFirstName$$ | String |
Offer Bill To Last Name | Single Item | $$Offer.BillToLastName$$ | String |
Offer Bill To Last Name Prefix | Single Item | $$Offer.BillToLastNamePrefix$$ | String |
Offer Bill To Name | Single Item | $$Offer.BillToName$$ | String |
Offer Bill To Person Title | Single Item | $$Offer.BillToPersonTitle$$ | String |
Offer Bill To Phone | Single Item | $$Offer.BillToPhone$$ | String |
Offer Bill To Phone2 | Single Item | $$Offer.BillToPhone2$$ | String |
Offer Bill To State | Single Item | $$Offer.BillToState$$ | String |
Offer Bill To State Province | Single Item | $$Offer.BillToStateProvince$$ | String |
Offer Bill To Street Address | Single Item | $$Offer.BillToStreetAddress$$ | String |
Offer Bill To Street Address Additional Info | Single Item | $$Offer.BillToStreetAddressAdditionalInfo$$ | String |
Offer Bill To Street Address Extension | Single Item | $$Offer.BillToStreetAddressExtension$$ | String |
Offer Bill To VAT Number | Single Item | $$Offer.BillToVatNumber$$ | String |
Offer Bill To Zip | Single Item | $$Offer.BillToZip$$ | String |
Offer Carrier Account Name | Single Item | $$Offer.CarrierAccountName$$ | String |
Offer Currency Code | Single Item | $$Offer.CurrencyCode$$ | String |
Offer Currency Symbol | Single Item | $$Offer.CurrencySymbol$$ | String |
Offer Customer Reference | Single Item | $$Offer.CustomerReference$$ | String |
Offer Discount Excluding VAT | Single Item | $$Offer.DiscountExVat$$ | String |
Offer Discount Including VAT | Single Item | $$Offer.DiscountIncVat$$ | String |
Offer Has Rows With Discount | Single Item | $$Offer.HasRowsWithDiscount$$ | Boolean |
Offer ID | Single Item | $$Offer.Id$$ | String |
Offer Note | Single Item | $$Offer.Note$$ | String |
Offer Code | Single Item | $$Offer.OfferCode$$ | String |
Offer Date | Single Item | $$Offer.OfferDate$$ | Date and Time |
Offer Products As HTML Table | Single Item | $$Offer.OfferProductsAsHtmlTable$$ | HTML table - Outdated |
Offer Rows As HTML Table | Single Item | $$Offer.OfferRowsAsHtmlTable$$ | HTML table - Outdated |
Offer Rows Subtotal Excluding VAT | Single Item | $$Offer.OfferRowsSubtotalExVat$$ | Number |
Offer Rows Subtotal Including VAT | Single Item | $$Offer.OfferRowsSubtotalIncVat$$ | Number |
Offer Total Excluding VAT | Single Item | $$Offer.OfferTotalExVat$$ | Number |
Offer Total Including VAT | Single Item | $$Offer.OfferTotalIncVat$$ | Number |
Offer Total Including VAT In Base Currency | Single Item | $$Offer.OfferTotalIncVatInBaseCurrency$$ | Number |
Offer Payment Type Code | Single Item | $$Offer.PaymentTypeCode$$ | String |
Offer Shipping Costs Excluding VAT | Single Item | $$Offer.ShippingCostsExVat$$ | Number |
Offer Shipping Costs Including VAT | Single Item | $$Offer.ShippingCostsIncVat$$ | Number |
Offer Ship To Address | Single Item | $$Offer.ShipToAddress$$ | String |
Offer Ship To Address 2 | Single Item | $$Offer.ShipToAddress2$$ | String |
Offer Ship To City | Single Item | $$Offer.ShipToCity$$ | String |
Offer Ship To Company | Single Item | $$Offer.ShipToCompany$$ | String |
Offer Ship To Country | Single Item | $$Offer.ShipToCountry$$ | String |
Offer Ship To Country Code | Single Item | $$Offer.ShipToCountryCode$$ | String |
Offer Ship To Email | Single Item | $$Offer.ShipToEmail$$ | String |
Offer Ship To Fax | Single Item | $$Offer.ShipToFax$$ | String |
Offer Ship To First Name | Single Item | $$Offer.ShipToFirstName$$ | String |
Offer Ship To Last Name | Single Item | $$Offer.ShipToLastName$$ | String |
Offer Ship To Last Name Prefix | Single Item | $$Offer.ShipToLastNamePrefix$$ | String |
Offer Ship To Name | Single Item | $$Offer.ShipToName$$ | String |
Offer Ship To PersonTitle | Single Item | $$Offer.ShipToPersonTitle$$ | String |
Offer Ship To Phone | Single Item | $$Offer.ShipToPhone$$ | String |
Offer Ship To Phone2 | Single Item | $$Offer.ShipToPhone2$$ | String |
Offer Ship To State | Single Item | $$Offer.ShipToState$$ | String |
Offer Ship To State Province | Single Item | $$Offer.ShipToStateProvince$$ | String |
Offer Ship To Street Address | Single Item | $$Offer.ShipToStreetAddress$$ | String |
Offer Ship To Street Address Additional Info | Single Item | $$Offer.ShipToStreetAddressAdditionalInfo$$ | String |
Offer Ship To Street Address Extension | Single Item | $$Offer.ShipToStreetAddressExtension$$ | String |
Offer Ship To Zip | Single Item | $$Offer.ShipToZip$$ | String |
Offer Validity Days | Single Item | $$Offer.ValidityDays$$ | Number |
Offer Valid Until | Single Item | $$Offer.ValidUntil$$ | Date and Time |
Offer VAT Total | Single Item | $$Offer.VatTotal$$ | Number |
Offer Row Comment | OfferRow Collection | $$OfferRow.Comment$$ | String |
Offer Row ID | OfferRow Collection | $$OfferRow.Id$$ | String |
Offer Row Item Price Excluding VAT | OfferRow Collection | $$OfferRow.ItemPriceExVat$$ | Number |
Offer Row Item Price Including VAT | OfferRow Collection | $$OfferRow.ItemPriceIncVat$$ | Number |
Offer Row Item Quantity | OfferRow Collection | $$OfferRow.ItemQuantity$$ | Number |
Offer Row Offer ID | OfferRow Collection | $$OfferRow.OfferId$$ | String |
Offer Row Product Code | OfferRow Collection | $$OfferRow.ProductCode$$ | String |
Offer Row Product Description | OfferRow Collection | $$OfferRow.ProductDescription$$ | String |
Offer Row Product Name | OfferRow Collection | $$OfferRow.ProductName$$ | String |
Offer Row Discount Excluding VAT | OfferRow Collection | $$OfferRow.RowDiscountExVat$$ | Number |
Offer Row Discount Including VAT | OfferRow Collection | $$OfferRow.RowDiscountIncVat$$ | Number |
Offer Row Total Excluding VAT | OfferRow Collection | $$OfferRow.RowTotalExVat$$ | Number |
Offer Row Total Including VAT | OfferRow Collection | $$OfferRow.RowTotalIncVat$$ | Number |
Offer Row VAT Amount | OfferRow Collection | $$OfferRow.RowVatAmount$$ | Number |
Offer Row VAT perc | OfferRow Collection | $$OfferRow.Vatperc$$ | Number |
Grouped VAT Sum Total Excluding VAT | GroupedVatSum Collection | $$GroupedVatSum.TotalExVat$$ | Number |
Grouped VAT Sum Total Including VAT | GroupedVatSum Collection | $$GroupedVatSum.TotalIncVat$$ | Number |
Grouped VAT Sum VAT Perc | GroupedVatSum Collection | $$GroupedVatSum.VatPerc$$ | Number |
Grouped VAT Sum VAT Total | GroupedVatSum Collection | $$GroupedVatSum.VatTotal$$ | Number |
Offer Bill To Bank BIC | Single Item | $$OfferBillTo.BankBic$$ | String |
Offer Bill To Bank IBAN | Single Item | $$OfferBillTo.BankIban$$ | String |
Offer Bill To Bank Number | Single Item | $$OfferBillTo.BankNr$$ | String |
Offer Bill To Chamber of Commerce | Single Item | $$OfferBillTo.ChamberOfCommerce$$ | String |
Offer Bill To Chamber of Commerce City | Single Item | $$OfferBillTo.ChamberOfCommerceCity$$ | String |
Offer Bill To City | Single Item | $$OfferBillTo.City$$ | String |
Offer Bill To Company Name | Single Item | $$OfferBillTo.CompanyName$$ | String |
Offer Bill To Country Code | Single Item | $$OfferBillTo.CountryCode$$ | String |
Offer Bill To Country Name | Single Item | $$OfferBillTo.CountryName$$ | String |
Offer Bill To Display Name | Single Item | $$OfferBillTo.DisplayName$$ | String |
Offer Bill To Email | Single Item | $$OfferBillTo.Email$$ | String |
Offer Bill To Full Name | Single Item | $$OfferBillTo.FullName$$ | String |
Offer Bill To Is Part Of The EU | Single Item | $$OfferBillTo.IsPartOfTheEu$$ | Boolean |
Offer Bill To PersonTitle | Single Item | $$OfferBillTo.PersonTitle$$ | String |
Offer Bill To Phone | Single Item | $$OfferBillTo.Phone$$ | String |
Offer Bill To Phone2 | Single Item | $$OfferBillTo.Phone2$$ | String |
Offer Bill To Postal Code | Single Item | $$OfferBillTo.PostalCode$$ | String |
Offer Bill To State Province | Single Item | $$OfferBillTo.StateProvince$$ | String |
Offer Bill To State Province Code | Single Item | $$OfferBillTo.StateProvinceCode$$ | String |
Offer Bill To Street Address 1 | Single Item | $$OfferBillTo.StreetAddress1$$ | String |
Offer Bill To Street Address 2 | Single Item | $$OfferBillTo.StreetAddress2$$ | String |
Offer Bill To VAT Number | Single Item | $$OfferBillTo.VatNumber$$ | String |
Offer Ship To Bank BIC | Single Item | $$OfferShipTo.BankBic$$ | String |
Offer Ship To Bank IBAN | Single Item | $$OfferShipTo.BankIban$$ | String |
Offer Ship To Bank Number | Single Item | $$OfferShipTo.BankNr$$ | String |
Offer Ship To Chamber of Commerce | Single Item | $$OfferShipTo.ChamberOfCommerce$$ | String |
Offer Ship To Chamber of Commerce City | Single Item | $$OfferShipTo.ChamberOfCommerceCity$$ | String |
Offer Ship To City | Single Item | $$OfferShipTo.City$$ | String |
Offer Ship To Company Name | Single Item | $$OfferShipTo.CompanyName$$ | String |
Offer Ship To Country Code | Single Item | $$OfferShipTo.CountryCode$$ | String |
Offer Ship To Country Name | Single Item | $$OfferShipTo.CountryName$$ | String |
Offer Ship To Display Name | Single Item | $$OfferShipTo.DisplayName$$ | String |
Offer Ship To Email | Single Item | $$OfferShipTo.Email$$ | String |
Offer Ship To Full Name | Single Item | $$OfferShipTo.FullName$$ | String |
Offer Ship To Is Part Of The EU | Single Item | $$OfferShipTo.IsPartOfTheEu$$ | Boolean |
Offer Ship To PersonTitle | Single Item | $$OfferShipTo.PersonTitle$$ | String |
Offer Ship To Phone | Single Item | $$OfferShipTo.Phone$$ | String |
Offer Ship To Phone2 | Single Item | $$OfferShipTo.Phone2$$ | String |
Offer Ship To Postal Code | Single Item | $$OfferShipTo.PostalCode$$ | String |
Offer Ship To State Province | Single Item | $$OfferShipTo.StateProvince$$ | String |
Offer Ship To State Province Code | Single Item | $$OfferShipTo.StateProvinceCode$$ | String |
Offer Ship To Street Address 1 | Single Item | $$OfferShipTo.StreetAddress1$$ | String |
Offer Ship To Street Address 2 | Single Item | $$OfferShipTo.StreetAddress2$$ | String |
Offer Ship To VAT Number | Single Item | $$OfferShipTo.VatNumber$$ | String |
Relations
'OfferRow' links to 'OfferRow'
Order Shipment
Show the list of Order Shipment merge fields
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Order Shipment Carrier Account Name | Single Item | $$OrderShipment.CarrierAccountName$$ | String |
Order Shipment Cash On Delivery Payment | Single Item | $$OrderShipment.CashOnDeliveryPayment$$ | String |
Order Shipment Create Timestamp | Single Item | $$OrderShipment.CreateTimestamp$$ | Date and Time |
Order Shipment Delivery Date | Single Item | $$OrderShipment.DeliveryDate$$ | Date and Time |
Order Shipment HandOver Timestamp | Single Item | $$OrderShipment.HandOverTimestamp$$ | Date and Time |
Order Shipment ID | Single Item | $$OrderShipment.Id$$ | String |
Order Shipment Open Pick List Scan Code | Single Item | $$OrderShipment.OpenPickListScanCode$$ | Scan Code |
Order Shipment Order Rows As HTML Table | Single Item | $$OrderShipment.OrderRowsAsHtmlTable$$ | HTML table - Outdated |
Order Shipment Order Shipment Rows Without Article Code As HTML Table | Single Item | $$OrderShipment.OrderShipmentRowsWithoutArticleCodeAsHtmlTable$$ | HTML table - Outdated |
Order Shipment PackageCount | Single Item | $$OrderShipment.PackageCount$$ | Number |
Order Shipment Parcel Carrier AppModule ID | Single Item | $$OrderShipment.ParcelCarrierAppModuleId$$ | String |
Order Shipment Preferred Ship Date | Single Item | $$OrderShipment.PreferredShipDate$$ | Date and Time |
Order Shipment Scan Code | Single Item | $$OrderShipment.ScanCode$$ | Scan Code |
Order Shipment Shipment Status | Single Item | $$OrderShipment.ShipmentStatus$$ | String |
Order Shipment Shipment Type | Single Item | $$OrderShipment.ShipmentType$$ | String |
Order Shipment Shipped Timestamp | Single Item | $$OrderShipment.ShippedTimestamp$$ | Date and Time |
Order Shipment Shipping Code | Single Item | $$OrderShipment.ShippingCode$$ | String |
Order Shipment Total Excluding VAT | Single Item | $$OrderShipment.TotalExVat$$ | Number |
Order Shipment Total Including VAT | Single Item | $$OrderShipment.TotalIncVat$$ | Number |
Order Shipment Total Item Quantity | Single Item | $$OrderShipment.TotalItemQuantity$$ | Number |
Order Shipment Total VAT | Single Item | $$OrderShipment.TotalVat$$ | Number |
Order Shipment Total Volume, M3 | Single Item | $$OrderShipment.TotalVolumeM3$$ | Number |
Order Shipment Total Weight, Kg | Single Item | $$OrderShipment.TotalWeightKg$$ | Number |
Order Shipment Tracking Code | Single Item | $$OrderShipment.TrackingCode$$ | String |
Order Shipment Weight | Single Item | $$OrderShipment.Weight$$ | Number |
Pick Row Comment | PickRow Collection | $$PickRow.Comment$$ | String |
Pick Row Ean | PickRow Collection | $$PickRow.Ean$$ | String |
Pick Row Expiry Date | PickRow Collection | $$PickRow.ExpiryDate$$ | Date and Time |
Pick Row Has Advanced Stock Items | PickRow Collection | $$PickRow.HasAdvancedStockItems$$ | Boolean |
Pick Row Is Hard Expired | PickRow Collection | $$PickRow.IsHardExpired$$ | Boolean |
Pick Row Is Soft Expired | PickRow Collection | $$PickRow.IsSoftExpired$$ | Boolean |
Pick Row Location | PickRow Collection | $$PickRow.Location$$ | String |
Pick Row Lot Number | PickRow Collection | $$PickRow.LotNumber$$ | String |
Pick Row Order Code | PickRow Collection | $$PickRow.OrderCode$$ | String |
Pick Row Order ID | PickRow Collection | $$PickRow.OrderId$$ | String |
Pick Row Order Row ID | PickRow Collection | $$PickRow.OrderRowId$$ | String |
Pick Row Order Shipment ID | PickRow Collection | $$PickRow.OrderShipmentId$$ | String |
Pick Row Product Code | PickRow Collection | $$PickRow.ProductCode$$ | String |
Pick Row Product ID | PickRow Collection | $$PickRow.ProductId$$ | String |
Pick Row Product Name | PickRow Collection | $$PickRow.ProductName$$ | String |
Pick Row Product Requires Expiry Date | PickRow Collection | $$PickRow.ProductRequiresExpiryDate$$ | Boolean |
Pick Row Product Requires Lot Number | PickRow Collection | $$PickRow.ProductRequiresLotNumber$$ | Boolean |
Pick Row Product Requires Serial Number | PickRow Collection | $$PickRow.ProductRequiresSerialNumber$$ | Boolean |
Pick Row Qty Needed | PickRow Collection | $$PickRow.QtyNeeded$$ | Number |
Pick Row Qty Picked | PickRow Collection | $$PickRow.QtyPicked$$ | Number |
Pick Row Serial Number | PickRow Collection | $$PickRow.SerialNumber$$ | String |
Pick Row Stock Item ID | PickRow Collection | $$PickRow.StockItemId$$ | String |
Pick Row Warehouse LocationID | PickRow Collection | $$PickRow.WarehouseLocationId$$ | String |
Order Shipment Package Belt Size, M | OrderShipmentPackage Collection | $$OrderShipmentPackage.BeltSizeM$$ | Number |
Order Shipment Package Description | OrderShipmentPackage Collection | $$OrderShipmentPackage.Description$$ | String |
Order Shipment Package Height, Cm | OrderShipmentPackage Collection | $$OrderShipmentPackage.HeightCm$$ | Number |
Order Shipment Package Length, Cm | OrderShipmentPackage Collection | $$OrderShipmentPackage.LengthCm$$ | Number |
Order Shipment Package Order Shipment ID | OrderShipmentPackage Collection | $$OrderShipmentPackage.OrderShipmentId$$ | String |
Order Shipment Package Tracking Code | OrderShipmentPackage Collection | $$OrderShipmentPackage.TrackingCode$$ | String |
Order Shipment Package Volume, M3 | OrderShipmentPackage Collection | $$OrderShipmentPackage.VolumeM3$$ | Number |
Order Shipment Package Weight, Kg | OrderShipmentPackage Collection | $$OrderShipmentPackage.WeightKg$$ | Number |
Order Shipment Package Width, Cm | OrderShipmentPackage Collection | $$OrderShipmentPackage.WidthCm$$ | Number |
Pack Row Allocation Item Quantity | PackRow Collection | $$PackRow.AllocationItemQuantity$$ | Number |
Pack Row Comment | PackRow Collection | $$PackRow.Comment$$ | String |
Pack Row ID | PackRow Collection | $$PackRow.Id$$ | String |
Pack Row Item Base Price Excluding VAT | PackRow Collection | $$PackRow.ItemBasePriceExVat$$ | Number |
Pack Row Item Base Price Including VAT | PackRow Collection | $$PackRow.ItemBasePriceIncVat$$ | Number |
Pack Row Item Price Excluding VAT | PackRow Collection | $$PackRow.ItemPriceExVat$$ | Number |
Pack Row Item Price Including VAT | PackRow Collection | $$PackRow.ItemPriceIncVat$$ | Number |
Pack Row Item Purchase Price | PackRow Collection | $$PackRow.ItemPurchasePrice$$ | Number |
Pack Row Item Quantity | PackRow Collection | $$PackRow.ItemQuantity$$ | Number |
Pack Row Item VAT Amount | PackRow Collection | $$PackRow.ItemVatAmount$$ | Number |
Pack Row Number Of Items Invoiced | PackRow Collection | $$PackRow.NrOfItemsInvoiced$$ | Number |
Pack Row Number Of Items Refunded | PackRow Collection | $$PackRow.NrOfItemsRefunded$$ | Number |
Pack Row OrderID | PackRow Collection | $$PackRow.OrderId$$ | String |
Pack Row Order Shipment ID | PackRow Collection | $$PackRow.OrderShipmentId$$ | String |
Pack Row Product Code | PackRow Collection | $$PackRow.ProductCode$$ | String |
Pack Row Product Country Of Origin | PackRow Collection | $$PackRow.ProductCountryOfOrigin$$ | String |
Pack Row Product Description | PackRow Collection | $$PackRow.ProductDescription$$ | String |
Pack Row Product EAN | PackRow Collection | $$PackRow.ProductEAN$$ | String |
Pack Row Product HS Code | PackRow Collection | $$PackRow.ProductHscode$$ | String |
Pack Row Product HS Code2 | PackRow Collection | $$PackRow.ProductHscode2$$ | String |
Pack Row Product Name | PackRow Collection | $$PackRow.ProductName$$ | String |
Pack Row Product Weight, Kg | PackRow Collection | $$PackRow.ProductWeightKg$$ | Number |
Pack Row Discount Excluding VAT | PackRow Collection | $$PackRow.RowDiscountExVat$$ | Number |
Pack Row Discount Including VAT | PackRow Collection | $$PackRow.RowDiscountIncVat$$ | Number |
Pack Row Total Excluding VAT | PackRow Collection | $$PackRow.RowTotalExVat$$ | Number |
Pack Row Total Including VAT | PackRow Collection | $$PackRow.RowTotalIncVat$$ | Number |
Pack Row VAT Amount | PackRow Collection | $$PackRow.RowVatAmount$$ | Number |
Pack Row Shop Product Image Url | PackRow Collection | $$PackRow.ShopProductImageUrl$$ | String |
Pack Row Stock Status | PackRow Collection | $$PackRow.StockStatus$$ | String |
Pack Row VAT perc | PackRow Collection | $$PackRow.Vatperc$$ | Number |
Pack Row Supplier SKU | PackRow Collection | $$PackRow.SupplierSKU$$ | String |
Pack Row Base Product Name | PackRow Collection | $$PackRow.BaseProductName$$ | String |
Ship From Bank BIC | Single Item | $$ShipFromContactInfo.BankBic$$ | String |
Ship From Bank IBAN | Single Item | $$ShipFromContactInfo.BankIban$$ | String |
Ship From Bank Number | Single Item | $$ShipFromContactInfo.BankNr$$ | String |
Ship From Chamber of Commerce | Single Item | $$ShipFromContactInfo.ChamberOfCommerce$$ | String |
Ship From Chamber of Commerce City | Single Item | $$ShipFromContactInfo.ChamberOfCommerceCity$$ | String |
Ship From City | Single Item | $$ShipFromContactInfo.City$$ | String |
Ship From Company Name | Single Item | $$ShipFromContactInfo.CompanyName$$ | String |
Ship From Country Code | Single Item | $$ShipFromContactInfo.CountryCode$$ | String |
Ship From Country Name | Single Item | $$ShipFromContactInfo.CountryName$$ | String |
Ship From Display Name | Single Item | $$ShipFromContactInfo.DisplayName$$ | String |
Ship From Email | Single Item | $$ShipFromContactInfo.Email$$ | String |
Ship From Full Name | Single Item | $$ShipFromContactInfo.FullName$$ | String |
Ship From Is Part Of The EU | Single Item | $$ShipFromContactInfo.IsPartOfTheEu$$ | Boolean |
Ship From Person Title | Single Item | $$ShipFromContactInfo.PersonTitle$$ | String |
Ship From Phone | Single Item | $$ShipFromContactInfo.Phone$$ | String |
Ship From Phone2 | Single Item | $$ShipFromContactInfo.Phone2$$ | String |
Ship From Postal Code | Single Item | $$ShipFromContactInfo.PostalCode$$ | String |
Ship From State Province | Single Item | $$ShipFromContactInfo.StateProvince$$ | String |
Ship From State Province Code | Single Item | $$ShipFromContactInfo.StateProvinceCode$$ | String |
Ship From Street Address 1 | Single Item | $$ShipFromContactInfo.StreetAddress1$$ | String |
Ship From Street Address 2 | Single Item | $$ShipFromContactInfo.StreetAddress2$$ | String |
Ship From VAT Number | Single Item | $$ShipFromContactInfo.VatNumber$$ | String |
Transport Category Code | TransportCategory Collection | $$TransportCategory.Code$$ | String |
Transport Category ID | TransportCategory Collection | $$TransportCategory.Id$$ | String |
Pack Row Product Registration Comment | PackRowProductRegistration Collection | $$PackRowProductRegistration.Comment$$ | String |
Pack Row Product Registration Order Row ID | PackRowProductRegistration Collection | $$PackRowProductRegistration.OrderRowId$$ | String |
Pack Row Product Registration Serial Number | PackRowProductRegistration Collection | $$PackRowProductRegistration.SerialNumber$$ | String |
Pack Row Product Registration Use By Date | PackRowProductRegistration 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 name | Merge field type | Merge field | Data type |
---|---|---|---|
Parcel Carrier Account Additional Info1 | Single Item | $$Parcel.CarrierAccountAdditionalInfo1$$ | String |
Parcel Carrier Account Additional Info2 | Single Item | $$Parcel.CarrierAccountAdditionalInfo2$$ | String |
Parcel Carrier Account ID | Single Item | $$Parcel.CarrierAccountId$$ | String |
Parcel Carrier Account Name | Single Item | $$Parcel.CarrierAccountName$$ | String |
Parcel Carrier AppModule ID | Single Item | $$Parcel.CarrierAppModuleId$$ | String |
Parcel Create Timestamp | Single Item | $$Parcel.CreateTimestamp$$ | Date and Time |
Parcel Delivered Date | Single Item | $$Parcel.DeliveredDate$$ | Date and Time |
Parcel ID | Single Item | $$Parcel.Id$$ | String |
Parcel Is Return | Single Item | $$Parcel.IsReturn$$ | Boolean |
Parcel Last Carrier Update | Single Item | $$Parcel.LastCarrierUpdate$$ | String |
Parcel Ship From Bank Bic | Single Item | $$ParcelShipFrom.BankBic$$ | String |
Parcel Ship From Bank Iban | Single Item | $$ParcelShipFrom.BankIban$$ | String |
Parcel Ship From Bank Number | Single Item | $$ParcelShipFrom.BankNr$$ | String |
Parcel Ship From Chamber of Commerce | Single Item | $$ParcelShipFrom.ChamberOfCommerce$$ | String |
Parcel Ship From Chamber of Commerce City | Single Item | $$ParcelShipFrom.ChamberOfCommerceCity$$ | String |
Parcel Ship From City | Single Item | $$ParcelShipFrom.City$$ | String |
Parcel Ship From Company Name | Single Item | $$ParcelShipFrom.CompanyName$$ | String |
Parcel Ship From Country Code | Single Item | $$ParcelShipFrom.CountryCode$$ | String |
Parcel Ship From Country Name | Single Item | $$ParcelShipFrom.CountryName$$ | String |
Parcel Ship From Display Name | Single Item | $$ParcelShipFrom.DisplayName$$ | String |
Parcel Ship From Email | Single Item | $$ParcelShipFrom.Email$$ | String |
Parcel Ship From Full Name | Single Item | $$ParcelShipFrom.FullName$$ | String |
Parcel Ship From Is Part Of The EU | Single Item | $$ParcelShipFrom.IsPartOfTheEu$$ | Boolean |
Parcel Ship From PersonTitle | Single Item | $$ParcelShipFrom.PersonTitle$$ | String |
Parcel Ship From Phone | Single Item | $$ParcelShipFrom.Phone$$ | String |
Parcel Ship From Phone2 | Single Item | $$ParcelShipFrom.Phone2$$ | String |
Parcel Ship From Postal Code | Single Item | $$ParcelShipFrom.PostalCode$$ | String |
Parcel Ship From State Province | Single Item | $$ParcelShipFrom.StateProvince$$ | String |
Parcel Ship From State Province Code | Single Item | $$ParcelShipFrom.StateProvinceCode$$ | String |
Parcel Ship From Street Address 1 | Single Item | $$ParcelShipFrom.StreetAddress1$$ | String |
Parcel Ship From Street Address 2 | Single Item | $$ParcelShipFrom.StreetAddress2$$ | String |
Parcel Ship From VAT Number | Single Item | $$ParcelShipFrom.VatNumber$$ | String |
Parcel Ship To Bank Bic | Single Item | $$ParcelShipTo.BankBic$$ | String |
Parcel Ship To Bank Iban | Single Item | $$ParcelShipTo.BankIban$$ | String |
Parcel Ship To Bank Number | Single Item | $$ParcelShipTo.BankNr$$ | String |
Parcel Ship To Chamber of Commerce | Single Item | $$ParcelShipTo.ChamberOfCommerce$$ | String |
Parcel Ship To Chamber of Commerce City | Single Item | $$ParcelShipTo.ChamberOfCommerceCity$$ | String |
Parcel Ship To City | Single Item | $$ParcelShipTo.City$$ | String |
Parcel Ship To Company Name | Single Item | $$ParcelShipTo.CompanyName$$ | String |
Parcel Ship To Country Code | Single Item | $$ParcelShipTo.CountryCode$$ | String |
Parcel Ship To Country Name | Single Item | $$ParcelShipTo.CountryName$$ | String |
Parcel Ship To Display Name | Single Item | $$ParcelShipTo.DisplayName$$ | String |
Parcel Ship To Email | Single Item | $$ParcelShipTo.Email$$ | String |
Parcel Ship To Full Name | Single Item | $$ParcelShipTo.FullName$$ | String |
Parcel Ship To Is Part Of The EU | Single Item | $$ParcelShipTo.IsPartOfTheEu$$ | Boolean |
Parcel Ship To Person Title | Single Item | $$ParcelShipTo.PersonTitle$$ | String |
Parcel Ship To Phone | Single Item | $$ParcelShipTo.Phone$$ | String |
Parcel Ship To Phone2 | Single Item | $$ParcelShipTo.Phone2$$ | String |
Parcel Ship To Postal Code | Single Item | $$ParcelShipTo.PostalCode$$ | String |
Parcel Ship To State Province | Single Item | $$ParcelShipTo.StateProvince$$ | String |
Parcel Ship To State Province Code | Single Item | $$ParcelShipTo.StateProvinceCode$$ | String |
Parcel Ship To Street Address 1 | Single Item | $$ParcelShipTo.StreetAddress1$$ | String |
Parcel Ship To Street Address 2 | Single Item | $$ParcelShipTo.StreetAddress2$$ | String |
Parcel Ship To VAT Number | Single Item | $$ParcelShipTo.VatNumber$$ | String |
Parcel Package Height, Cm | ParcelPackage Collection | $$ParcelPackage.HeightCm$$ | Number |
Parcel Package Label Image | ParcelPackage Collection | $$ParcelPackage.LabelImage$$ | Image |
Parcel Package Length, Cm | ParcelPackage Collection | $$ParcelPackage.LengthCm$$ | Number |
Parcel Package Parcel ID | ParcelPackage Collection | $$ParcelPackage.ParcelId$$ | String |
Parcel Package Tracking Code | ParcelPackage Collection | $$ParcelPackage.TrackingCode$$ | String |
Parcel Package Tracking Url | ParcelPackage Collection | $$ParcelPackage.TrackingUrl$$ | String |
Parcel Package Weight, Kg | ParcelPackage Collection | $$ParcelPackage.WeightKg$$ | Number |
Parcel Package Width, Cm | ParcelPackage Collection | $$ParcelPackage.WidthCm$$ | Number |
Relations
'ParcelPackage' links to 'ParcelPackage'
Purchase Order
Show the list of Purchase Order merge fields
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Purchase Order Comment | Single Item | $$PurchaseOrder.Comment$$ | String |
Purchase Order Currency Symbol | Single Item | $$PurchaseOrder.CurrencySymbol$$ | String |
Purchase Order Date | Single Item | $$PurchaseOrder.Date$$ | Date and Time |
Purchase Order Dropship Order Code | Single Item | $$PurchaseOrder.DropshipOrderCode$$ | String |
Purchase Order Expected Delivery Date | Single Item | $$PurchaseOrder.ExpectedDeliveryDate$$ | Date and Time |
Purchase Order ID | Single Item | $$PurchaseOrder.Id$$ | String |
Purchase Order Code | Single Item | $$PurchaseOrder.OrderCode$$ | Number |
Purchase Order Rows As HTML Table | Single Item | $$PurchaseOrder.OrderRowsAsHtmlTable$$ | HTML table - Outdated |
Purchase Order Rows Subtotal Excluding VAT | Single Item | $$PurchaseOrder.OrderRowsSubtotalExVat$$ | Number |
Purchase Order Total Excluding VAT | Single Item | $$PurchaseOrder.OrderTotalExVat$$ | Number |
Purchase Order Our Reference | Single Item | $$PurchaseOrder.OurReference$$ | String |
Purchase Order Shipping Costs Excluding VAT | Single Item | $$PurchaseOrder.ShippingCostsExVat$$ | Number |
Purchase Order Supplier Invoice Code | Single Item | $$PurchaseOrder.SupplierInvoiceCode$$ | String |
Purchase Order Supplier Note | Single Item | $$PurchaseOrder.SupplierNote$$ | String |
Purchase Order Row Comment | PurchaseOrderRow Collection | $$PurchaseOrderRow.Comment$$ | String |
Purchase Order Row ID | PurchaseOrderRow Collection | $$PurchaseOrderRow.Id$$ | String |
Purchase Order Row Is Delivered | PurchaseOrderRow Collection | $$PurchaseOrderRow.IsDelivered$$ | Boolean |
Purchase Order Row Item Price Excluding VAT | PurchaseOrderRow Collection | $$PurchaseOrderRow.ItemPriceExVat$$ | Number |
Purchase Order Row Item Quantity | PurchaseOrderRow Collection | $$PurchaseOrderRow.ItemQuantity$$ | Number |
Purchase Order Row Item Quantity Delivered | PurchaseOrderRow Collection | $$PurchaseOrderRow.ItemQuantityDelivered$$ | Number |
Purchase Order Row Item Quantity Outstanding | PurchaseOrderRow Collection | $$PurchaseOrderRow.ItemQuantityOutstanding$$ | Number |
Purchase Order Row Product Code | PurchaseOrderRow Collection | $$PurchaseOrderRow.ProductCode$$ | String |
Purchase Order Row Product Description | PurchaseOrderRow Collection | $$PurchaseOrderRow.ProductDescription$$ | String |
Purchase Order Row Product Name | PurchaseOrderRow Collection | $$PurchaseOrderRow.ProductName$$ | String |
Purchase Order Row Purchase Order ID | PurchaseOrderRow Collection | $$PurchaseOrderRow.PurchaseOrderId$$ | String |
Purchase Order Row Total Excluding VAT | PurchaseOrderRow Collection | $$PurchaseOrderRow.RowTotalExVat$$ | Number |
Purchase Order Row Supplier Sku | PurchaseOrderRow Collection | $$PurchaseOrderRow.SupplierSku$$ | String |
Purchase Order Bill To Bank BIC | Single Item | $$PurchaseOrderBillTo.BankBic$$ | String |
Purchase Order Bill To Bank IBAN | Single Item | $$PurchaseOrderBillTo.BankIban$$ | String |
Purchase Order Bill To Bank Number | Single Item | $$PurchaseOrderBillTo.BankNr$$ | String |
Purchase Order Bill To Chamber of Commerce | Single Item | $$PurchaseOrderBillTo.ChamberOfCommerce$$ | String |
Purchase Order Bill To Chamber of Commerce City | Single Item | $$PurchaseOrderBillTo.ChamberOfCommerceCity$$ | String |
Purchase Order Bill To City | Single Item | $$PurchaseOrderBillTo.City$$ | String |
Purchase Order Bill To Company Name | Single Item | $$PurchaseOrderBillTo.CompanyName$$ | String |
Purchase Order Bill To Country Code | Single Item | $$PurchaseOrderBillTo.CountryCode$$ | String |
Purchase Order Bill To Country Name | Single Item | $$PurchaseOrderBillTo.CountryName$$ | String |
Purchase Order Bill To Display Name | Single Item | $$PurchaseOrderBillTo.DisplayName$$ | String |
Purchase Order Bill To Email | Single Item | $$PurchaseOrderBillTo.Email$$ | String |
Purchase Order Bill To Full Name | Single Item | $$PurchaseOrderBillTo.FullName$$ | String |
Purchase Order Bill To Is Part Of The EU | Single Item | $$PurchaseOrderBillTo.IsPartOfTheEu$$ | Boolean |
Purchase Order Bill To Person Title | Single Item | $$PurchaseOrderBillTo.PersonTitle$$ | String |
Purchase Order Bill To Phone | Single Item | $$PurchaseOrderBillTo.Phone$$ | String |
Purchase Order Bill To Phone2 | Single Item | $$PurchaseOrderBillTo.Phone2$$ | String |
Purchase Order Bill To Postal Code | Single Item | $$PurchaseOrderBillTo.PostalCode$$ | String |
Purchase Order Bill To State Province | Single Item | $$PurchaseOrderBillTo.StateProvince$$ | String |
Purchase Order Bill To State Province Code | Single Item | $$PurchaseOrderBillTo.StateProvinceCode$$ | String |
Purchase Order Bill To Street Address 1 | Single Item | $$PurchaseOrderBillTo.StreetAddress1$$ | String |
Purchase Order Bill To Street Address 2 | Single Item | $$PurchaseOrderBillTo.StreetAddress2$$ | String |
Purchase Order Bill To VAT Number | Single Item | $$PurchaseOrderBillTo.VatNumber$$ | String |
Purchase Order Bank BIC | Single Item | $$PurchaseOrderShipTo.BankBic$$ | String |
Purchase Order Bank IBAN | Single Item | $$PurchaseOrderShipTo.BankIban$$ | String |
Purchase Order Bank Number | Single Item | $$PurchaseOrderShipTo.BankNr$$ | String |
Purchase Order Chamber of Commerce | Single Item | $$PurchaseOrderShipTo.ChamberOfCommerce$$ | String |
Purchase Order Chamber of Commerce City | Single Item | $$PurchaseOrderShipTo.ChamberOfCommerceCity$$ | String |
Purchase Order City | Single Item | $$PurchaseOrderShipTo.City$$ | String |
Purchase Order Company Name | Single Item | $$PurchaseOrderShipTo.CompanyName$$ | String |
Purchase Order Country Code | Single Item | $$PurchaseOrderShipTo.CountryCode$$ | String |
Purchase Order Country Name | Single Item | $$PurchaseOrderShipTo.CountryName$$ | String |
Purchase Order Display Name | Single Item | $$PurchaseOrderShipTo.DisplayName$$ | String |
Purchase Order Email | Single Item | $$PurchaseOrderShipTo.Email$$ | String |
Purchase Order Full Name | Single Item | $$PurchaseOrderShipTo.FullName$$ | String |
Purchase Order Is Part Of The EU | Single Item | $$PurchaseOrderShipTo.IsPartOfTheEu$$ | Boolean |
Purchase Order PersonTitle | Single Item | $$PurchaseOrderShipTo.PersonTitle$$ | String |
Purchase Order Phone | Single Item | $$PurchaseOrderShipTo.Phone$$ | String |
Purchase Order Phone2 | Single Item | $$PurchaseOrderShipTo.Phone2$$ | String |
Purchase Order Postal Code | Single Item | $$PurchaseOrderShipTo.PostalCode$$ | String |
Purchase Order State Province | Single Item | $$PurchaseOrderShipTo.StateProvince$$ | String |
Purchase Order State Province Code | Single Item | $$PurchaseOrderShipTo.StateProvinceCode$$ | String |
Purchase Order Street Address 1 | Single Item | $$PurchaseOrderShipTo.StreetAddress1$$ | String |
Purchase Order Street Address 2 | Single Item | $$PurchaseOrderShipTo.StreetAddress2$$ | String |
Purchase Order VAT Number | Single Item | $$PurchaseOrderShipTo.VatNumber$$ | String |
Relations | |||
PurchaseOrderRow' links to 'PurchaseOrderRow' |
Supplier
Show the list of Supplier merge fields
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Supplier Company Name | Single Item | $$Supplier.CompanyName$$ | String |
Supplier Contact Ref | Single Item | $$Supplier.ContactRef$$ | String |
Supplier First Name | Single Item | $$Supplier.FirstName$$ | String |
Supplier Full Name | Single Item | $$Supplier.FullName$$ | String |
Supplier Last Name | Single Item | $$Supplier.LastName$$ | String |
Supplier Last Name Prefix | Single Item | $$Supplier.LastNamePrefix$$ | String |
Supplier Middle Name | Single Item | $$Supplier.MiddleName$$ | String |
Supplier Person Title | Single Item | $$Supplier.PersonTitle$$ | String |
Supplier Bank BIC | Single Item | $$SupplierContactInfo.BankBic$$ | String |
Supplier Bank IBAN | Single Item | $$SupplierContactInfo.BankIban$$ | String |
Supplier Bank Number | Single Item | $$SupplierContactInfo.BankNr$$ | String |
Supplier Chamber of Commerce | Single Item | $$SupplierContactInfo.ChamberOfCommerce$$ | String |
Supplier Chamber of Commerce City | Single Item | $$SupplierContactInfo.ChamberOfCommerceCity$$ | String |
Supplier City | Single Item | $$SupplierContactInfo.City$$ | String |
Supplier Company Name | Single Item | $$SupplierContactInfo.CompanyName$$ | String |
Supplier Country Code | Single Item | $$SupplierContactInfo.CountryCode$$ | String |
Supplier Country Name | Single Item | $$SupplierContactInfo.CountryName$$ | String |
Supplier Display Name | Single Item | $$SupplierContactInfo.DisplayName$$ | String |
Supplier Email | Single Item | $$SupplierContactInfo.Email$$ | String |
Supplier Full Name | Single Item | $$SupplierContactInfo.FullName$$ | String |
Supplier Is Part Of The EU | Single Item | $$SupplierContactInfo.IsPartOfTheEu$$ | Boolean |
Supplier PersonTitle | Single Item | $$SupplierContactInfo.PersonTitle$$ | String |
Supplier Phone | Single Item | $$SupplierContactInfo.Phone$$ | String |
Supplier Phone2 | Single Item | $$SupplierContactInfo.Phone2$$ | String |
Supplier Postal Code | Single Item | $$SupplierContactInfo.PostalCode$$ | String |
Supplier State Province | Single Item | $$SupplierContactInfo.StateProvince$$ | String |
Supplier State Province Code | Single Item | $$SupplierContactInfo.StateProvinceCode$$ | String |
Supplier Street Address 1 | Single Item | $$SupplierContactInfo.StreetAddress1$$ | String |
Supplier Street Address 2 | Single Item | $$SupplierContactInfo.StreetAddress2$$ | String |
Supplier VAT Number | Single Item | $$SupplierContactInfo.VatNumber$$ | String |
Warehouse
Show the list of Warehouse merge fields
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Warehouse Name | Single Item | $$Warehouse.Name$$ | String |
Warehouse Priority | Single Item | $$Warehouse.Priority$$ | String |
Warehouse Type | Single Item | $$Warehouse.WarehouseType$$ | String |
Warehouse Location Aisle | Single Item | $$WarehouseLocation.Aisle$$ | String |
Warehouse Location Bay | Single Item | $$WarehouseLocation.Bay$$ | String |
Warehouse Location Bin | Single Item | $$WarehouseLocation.Bin$$ | String |
Warehouse Location ID | Single Item | $$WarehouseLocation.Id$$ | String |
Warehouse Location Name | Single Item | $$WarehouseLocation.Name$$ | String |
Warehouse Location Scan Code | Single Item | $$WarehouseLocation.ScanCode$$ | Scan Code |
Warehouse Location Shelf | Single Item | $$WarehouseLocation.Shelf$$ | String |
Stock Item
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Stock Item Comment | Single Item | $$StockItem.Comment$$ | String |
Stock Item Expiry Date | Single Item | $$StockItem.ExpiryDate$$ | Date and Time |
Stock Item ID | Single Item | $$StockItem.Id$$ | String |
Stock Item Lot Number | Single Item | $$StockItem.LotNumber$$ | String |
Stock Item Scan Code | Single Item | $$StockItem.ScanCode$$ | Scan Code |
Stock Item Serial Number | Single Item | $$StockItem.SerialNumber$$ | String |
Stock Item Stock Item Status | Single Item | $$StockItem.StockItemStatus$$ | String |
Product
Show the list of Product merge fields
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Product Changed Timestamp | Single Item | $$Product.ChangedTimestamp$$ | Date and Time |
Product Code | Single Item | $$Product.Code$$ | String |
Product Creation Date | Single Item | $$Product.CreationDate$$ | Date and Time |
Product Diameter | Single Item | $$Product.Diameter$$ | Number |
Product Height | Single Item | $$Product.Height$$ | Number |
Product Is Shippable | Single Item | $$Product.IsShippable$$ | Boolean |
Product Keep Stock | Single Item | $$Product.KeepStock$$ | Boolean |
Product Length | Single Item | $$Product.Length$$ | Number |
Product Price Excluding VAT | Single Item | $$Product.PriceExVat$$ | Number |
Product Price UoM ID | Single Item | $$Product.PriceUomId$$ | String |
Product Group | Single Item | $$Product.ProductProductGroup$$ | String |
Product Property Def Set ID | Single Item | $$Product.ProductPropertyDefSetId$$ | String |
Product Published | Single Item | $$Product.Published$$ | Boolean |
Product Qty Available | Single Item | $$Product.QtyAvailable$$ | Number |
Product Qty On Hand | Single Item | $$Product.QtyOnHand$$ | Number |
Product Qty Ordered | Single Item | $$Product.QtyOrdered$$ | Number |
Product Qty Reserved | Single Item | $$Product.QtyReserved$$ | String |
Product Ref Code | Single Item | $$Product.RefCode$$ | String |
Product Requires Expiry Date | Single Item | $$Product.RequiresExpiryDate$$ | Boolean |
Product Requires Lot Number | Single Item | $$Product.RequiresLotNumber$$ | Boolean |
Product Requires Serial Number | Single Item | $$Product.RequiresSerialNumber$$ | Boolean |
Product Scan Code | Single Item | $$Product.ScanCode$$ | Scan Code |
Product Size UoM ID | Single Item | $$Product.SizeUomId$$ | String |
Product Storage Life Pre-Warning Days | Single Item | $$Product.StorageLifePreWarningDays$$ | Number |
Product Volume | Single Item | $$Product.Volume$$ | Number |
Product Volume UoM ID | Single Item | $$Product.VolumeUomId$$ | String |
Product Weight | Single Item | $$Product.Weight$$ | Number |
Product Weight UoM ID | Single Item | $$Product.WeightUomId$$ | String |
Product Width | Single Item | $$Product.Width$$ | Number |
Product Name | Single Item | $$Product.Name$$ | String |
Product Description | Single Item | $$Product.Description$$ | String |
Product Description Long | Single Item | $$Product.DescriptionLong$$ | String |
Alerts notification
Show the list of Alerts merge fields
Merge field name | Merge field type | Merge field | Data type |
---|---|---|---|
Unread alert notification count | Single Item | $$UnreadAlertNotification.Count$$ | Number |
Alert url | Single Item | $$UnreadAlertNotification.AlertPageUrl$$ | Url |
Main Shop name | Single Item | $$UnreadAlertNotification.MainShopName$$ | String |
Single or plural suffix | Single Item | $$UnreadAlertNotification.PluralSuffix$$ | String |
Alert Id | Alerts Collection | $$Alerts.Id$$ | Number |
Alerts Title | Alerts Collection | $$Alerts.Title$$ | String |
Alerts Category | Alerts Collection | $$Alerts.Category$$ | String |
Alerts Severity | Alerts Collection | $$Alerts.SeverityStr$$ | String |
Alerts Create Timestamp | Alerts Collection | $$Alerts.CreateTimestamp$$ | Date and Time |
Alerts ChangedTimestamp | Alerts Collection | $$Alerts.ChangedTimestamp$$ | Date and Time |