In the Flat Configuration Items page, while defining the column mapping, all columns of the file to be imported must be entered in the correct order of the occurrence in the file, without any gaps. You can choose the appropriate item from the select list but if a column is not used in the Excel sheet, just choose IGNORE from the list of values in the Item field, so this column is not read during the import. The available items with their meanings are as follows:
Items |
Meaning |
---|---|
GUID |
Unique identifier for the record |
IGNORE |
Dummy column |
NODE_ATTR |
Horizontal Location and Interpretation of Node Property |
NODE_LEV0N |
Horizontal Location of 0th Node Name in Hierarchy on Position Level |
NODE_LEV1N |
Horizontal Location of 1st Node Name in Hierarchy on Position Level |
NODE_LEV2N |
Horizontal Location of 2nd Node Name in Hierarchy on Position Level |
NODE_LEV3N |
Horizontal Location of 3rd Node Name in Hierarchy on Position Level |
NODE_LEV4N |
Horizontal Location of 4th Node Name in Hierarchy on Position Level |
NODE_LEV5N |
Horizontal Location of 5th Node Name in Hierarchy on Position Level |
NODE_LEV6N |
Horizontal Location of 6th Node Name in Hierarchy on Position Level |
NODE_LEV7N |
Horizontal Location of 7th Node Name in Hierarchy on Position Level |
NODE_LEV8N |
Horizontal Location of 8th Node Name in Hierarchy on Position Level |
NODE_LEV9N |
Horizontal Location of 9th Node Name in Hierarchy on Position Level |
POS_ATTR |
Horizontal Location and Interpretation of Position Property |
POS_CC |
Horizontal Location of Commodity Code on Position Level |
POS_CG |
Horizontal Location of Commodity Group on position level |
POS_CP |
Horizontal Location of Commodity Part on position level |
POS_IDENT |
Horizontal Location of Ident Code on Position Level |
POS_ISTAT |
Issue status per node |
POS_ITR |
Horizontal Location of item rule on position level |
POS_LSTAT |
Horizontal Location of item rule on position level |
POS_MAIN |
Horizontal Location of main assembly position |
POS_NUM |
Horizontal Location of the position number |
POS_OPTION |
Horizontal Location of Option Code on Position Level |
POS_QTY |
Horizontal Location of Quantity on Position Level |
POS_RTYPE |
Horizontal Location of Record Type on Position Level |
POS_SHORT |
Horizontal Location of Short Code on Position Level |
POS_SIZ2WU |
Horizontal Location of Size2 with Unit on Position Level |
POS_SIZE1 |
Horizontal Location of Size1 on Position Level |
POS_SIZE2 |
Horizontal Location of Size2 on Position Level |
POS_SIZE3 |
Horizontal Location of Size3 on Position Level |
POS_SIZE4 |
Horizontal Location of Size4 on Position Level |
POS_SPEC |
Horizontal Location of Spec Code on Position Level |
POS_SUB01 |
Horizontal Location of Sub Position Number at assembly level 1 |
POS_SUB02 |
Horizontal Location of Sub Position Number at assembly level 2 |
POS_SUB03 |
Horizontal Location of Sub Position Number at assembly level 3 |
POS_SUB04 |
Horizontal Location of Sub Position Number at assembly level 4 |
POS_SUB05 |
Horizontal Location of Sub Position Number at assembly level 5 |
POS_SUB06 |
Horizontal Location of Sub Position Number at assembly level 6 |
POS_SUB07 |
Horizontal Location of Sub Position Number at assembly level 7 |
POS_SUB08 |
Horizontal Location of Sub Position Number at assembly level 8 |
POS_SUB09 |
Horizontal Location of Sub Position Number at assembly level 9 |
POS_SUB10 |
Horizontal Location of Sub Position Number at assembly level 10 |
POS_SUM_ID |
Summarize equal idents on position level |
POS_TAB |
Horizontal Location of a table detail to identify commodity code |
POS_TAG_LO |
Horizontal Location of tag number long layout (standard/login language) on position level |
POS_TAG_L2 |
Horizontal Location of tag number long layout (second language) on position level |
POS_TAG_L3 |
Horizontal Location of tag number long layout (third language) on position level |
POS_TAG_NU |
Horizontal Location of tag number on position level |
POS_TAG_SH |
Horizontal Location of tag number short layout (standard/login language) on position level |
POS_TAG_S2 |
Horizontal Location of tag number short layout (second language) on position level |
POS_TAG_S3 |
Horizontal Location of tag number short layout (third language) on position level |
POS_UNIT |
Position Quantity Unit (NO LENGTH but pcs, EA, and so on) |