<< Click to Display Table of Contents >> Navigation: Excel - Export en Import > Creating import & export excel templates > Available keywords for lockchart import/export > Cylinders |
Field |
Description |
CYL.Name |
Name of the cylinder article (repeated on instance line) |
CYL.Code |
Code of the CMC used on the position of the cylinder article (repeated on instance line) |
CYL.UserType |
UserType of the CMC used on the position of the cylinder article. |
CYL.Marking1 |
Marking1 of the cylinder instance |
CYL.Marking2 |
Marking2 of the cylinder instance |
CYL.Marking3 |
Marking3 of the cylinder instance |
CYL.Marking4 |
Marking4 of the cylinder instance |
CYL.Quantity |
Quantity of the cylinder article (total quantity of instances with status = NEW) |
CYL.ProducedQuantity |
Quantity of the cylinder article (total quantity of instances with status != NEW) |
CYL.ProdSetting |
Production setting of the cylinder article |
CYL.Product |
Product name of the configuration of the cylinder article |
CYL.ProductCode |
Product code of the configuration of the cylinder article |
CYL.ArticleCode |
SKU product code |
CYL.ATTRValue.xxx |
Attribute value part of the configuration of the cylinder article for the attribute for which the attribute code matches the ‘xxx’ E.g. CYL.ATTRValue.SF Subtract ‘CYL.ATTRValue.’ and match the code for the attribute. |
CYL.LVLName.xxx |
Name of the level instance for which the level name matches the ‘xxx’ E.g. CYL.LVLName.Gebouw Subtract ‘CYL.LVLName.’ and match the name for the level.
Only level instances which are in the upstream path of the CMC used on the position of the cylinder article are used to build up this information. In case multiple level instances for the same level are relevant, the value is a concatenation of the single names using the separator as defined in 6.5. |
CYL.GRPName |
Name of the Cylinder Group Only Cylinder Group which is in the upstream path of the CMC used on the position of the cylinder article is used. |
CYL.SETName |
Name of the Cylinder Set Only Cylinder Set which is in the upstream path of the CMC used on the position of the cylinder article is used. |
CYL.PropCard |
Property card status of the CMC used on the position of the cylinder article (status can have value: None, Single, Multi) |
CYL.ESQuantity |
Own keys quantity |
CYL.ESProducedQuantity |
Own keys produced quantity |
CYL.Direction |
Direction of the cylinder |