|
<< Click to Display Table of Contents >> Navigation: Excel - Export en Import > Creating import & export excel templates > Available keywords for OrderSummary > Order lines |
The line information refers to the data added for order lines.
Key Studio™ makes use of different line types because not all lines are added for articles to be produced. Some lines are added because the article has another supplement article to be added or because additional charges will be applied.
These lines are linked to the initial article line, so the export logic will also take this concept into account.
OrderLineType |
Description |
ProductItem |
The order line represents the order information for a product item |
AdditionalProductItem |
The order line represents an additional product chosen by the user |
ArchitecturalHardwareProductItem |
The order line represents architectural hardware (doors) |
ServiceItem ▪MKSFunctionalityServiceItem |
The order line represents the order information for a service item ▪…added when specific functionality is used in the order |
MKSProcessingServiceItem |
The order line represents the service item added for MKS processing |
KeyManagementSubscriptionNew |
The order line represents a new key management subscription, so the subscription does not yet exist |
KeyManagementSubscriptionRenew |
The order line represents a renewal of an existing subscription |
LineSupplement |
The order line represents a supplement of a product item |
OrderSupplement |
The order line represents a supplement that is not related to another order line, but only to the order itself |
Line are exported in following order:
-Product item
oLineSupplement
-ArchitecturalHardwareProductItem
-KeyManagementSubscriptionNew
-KeyManagementSubscriptionRenew
-OrderSupplement
-ServiceItem (MKSFunctionalityServiceItem)
-MKSProcessingServiceItem
-AdditionalProductItem
The Line supplements are linked to another line. Supplement lines are added just like other lines but they are always positioned after the product item line to which they relate and the content for the named cell, LINE.Type will be prefixed with 3 empty characters.
The TYPE for supplements is to be retrieved from additional meta data defined for the supplement, SupplementType (Product/Charge/...).
Field |
Description |
LINE.Type |
The type of product. (These will be translated in the resx similar to Cylinder/Key/PropertyCard/…) |
LINE.ArticleCode |
The erp article code which is added to the order |
LINE.Product |
The product description |
LINE.Shipping |
Shipping address as formatted in the summary view |
LINE.Currency |
Currency as retrieved from webshop |
LINE.UnitPrice |
Unit price as retrieved from webshop |
LINE.Quantity |
Quantity as retrieved from webshop |
LINE.ListPrice |
ListPrice as retrieved from webshop |