When exporting a bill of materials, the parts data is output to an export file. Data exported in this manner can then be edited and re-imported. However, only the properties listed below are written back on import:
Export file field name |
Property |
---|---|
P_ARTICLEREF_PARTNO |
Part number |
P_ARTICLEREF_VARIANT |
Part variant, category Part reference data |
P_ARTICLEREF_PARTTYPE |
Record type, category Part reference data |
P_ARTICLEREF_COUNT |
Number of units / quantity |
P_ARTICLEREF_FUNCTIONGROUP |
Function group, category Part reference data |
P_ARTICLEREF_PIECETYPE |
Part group, category Part reference data |
P_ARTICLEREF_ASSIGNMENT |
Part allocation, category Part reference data |
P_ARTICLEREF_ASSEMBLY |
Assembly, category Part reference data |
P_ARTICLEREF_POSNR |
Item number, category Part reference data |
P_ARTICLEREF_ADDITIONAL_TEXTFIELD |
Supplementary field text, category Part reference data |
P_ARTICLEREF_ADDITIONAL_BOOLFIELD |
Supplementary field yes/no, category Part reference data |
P_ARTICLE_EXTERNAL_PLACEMENT |
External placement, category Part reference data |
The following table provides an overview of all properties written to the export file:
Export file field name |
Property |
---|---|
P_ARTICLEREF_IDENTNAME |
DT |
P_DESIGNATION_PLANT |
Higher-level function (main identifier) |
P_DESIGNATION_FULLPLANT |
Higher-level function |
P_DESIGNATION_LOCATION |
Mounting location (main identifier) |
P_DESIGNATION_FULLLOCATION |
Mounting location |
P_DESIGNATION_FUNCTIONALASSIGNMENT |
Functional assignment (main identifier) |
P_DESIGNATION_FULLFUNCTIONALASSIGNMENT |
Functional assignment |
P_DESIGNATION_PLACEOFINSTALLATION |
Installation site (main identifier) |
P_DESIGNATION_FULLPLACEOFINSTALLATION |
Installation site |
P_DESIGNATION_USERDEFINED |
User-defined structure (main identifier) |
P_DESIGNATION_FULLUSERDEFINED |
User-defined structure |
P_DESIGNATION_INSTALLATIONNUMBER |
Higher-level function number (main identifier) |
P_DESIGNATION_FULLINSTALLATIONNUMBER |
Higher-level function number |
P_DESIGNATION_FULLSUBINSTALLATIONNUMBER |
Installation subnumber |
P_PROPUSER_DBOBJECTID |
Object identification |
P_INSTANCE_FULLPLACEMENTLOCATION |
Placement |
P_FUNC_DEVICETAG_MAIN |
DT (superior, without project structures) |
P_FUNC_DEVICETAG_NESTED |
DT (subordinate, without project structures) |
P_FUNC_PREFIX |
DT: Prefix |
P_FUNC_CODE |
DT: Identifier |
P_FUNC_COUNTER |
DT: Counter |
P_FUNC_SUFFIX |
DT: Subcounter |
P_FUNC_NESTEDPREFIX |
DT (subordinate): Prefix |
P_FUNC_NESTEDCODE |
DT (subordinate): Identifier |
P_FUNC_NESTEDCOUNTER |
DT (subordinate):Counter |
P_FUNC_NESTEDSUFFIX |
DT (subordinate): Subcounter |
P_FUNC_MOUNTINGLOCATION |
Mounting site (describing) |
P_FUNC_GRAVINGTEXT |
Engraving text |
P_FUNC_COMPONENTTYPE |
Function definition |
P_FUNC_TECHNICAL_CHARACTERISTIC |
Technical characteristics |
P_FUNC_TEXT_AUTOMATIC |
Function text (automatic) |
P_FUNC_DEVICETAG_FULLNAME |
Name (without project structures) |
P_FUNC_CABLE_LAYOUT_FORM |
Cable assignment diagram form |
P_FUNC_TYPE |
Representation type |
P_FUNC_DT_PAGECOUNTER |
DT: Page |
P_FUNC_DT_PAGESUBCOUNTER |
DT: Subpage |
P_FUNC_DT_COLUMN |
DT: Column |
P_FUNC_DT_ROW |
DT: Row |
P_FUNC_DT_SECTION |
DT: Section |
P_FUNC_DT_FUNCTIONCODE |
DT: Application |
P_FUNC_DT_SUPPLEMENTARYFIELD01 |
DT: Supplementary field 1 |
P_FUNC_DT_SUPPLEMENTARYFIELD02 |
DT: Supplementary field 2 |
P_FUNC_DT_SUPPLEMENTARYFIELD03 |
DT: Supplementary field 3 |
P_FUNC_DT_SUPPLEMENTARYFIELD04 |
DT: Supplementary field 4 |
P_FUNC_DT_SUPPLEMENTARYFIELD05 |
DT: Supplementary field 5 |
P_FUNC_DT2_PAGECOUNTER |
DT (subordinate): Page |
P_FUNC_DT2_PAGESUBCOUNTER |
DT (subordinate): Subpage |
P_FUNC_DT2_COLUMN |
DT (subordinate): Column |
P_FUNC_DT2_ROW |
DT (subordinate): Row |
P_FUNC_DT2_SECTION |
DT (subordinate): Section |
P_FUNC_DT2_FUNCTIONCODE |
DT (subordinate): Application |
P_FUNC_DT2_SUPPLEMENTARYFIELD01 |
DT (subordinate): Supplementary field 1 |
P_FUNC_DT2_SUPPLEMENTARYFIELD02 |
DT (subordinate): Supplementary field 2 |
P_FUNC_DT2_SUPPLEMENTARYFIELD03 |
DT (subordinate): Supplementary field 3 |
P_FUNC_DT2_SUPPLEMENTARYFIELD04 |
DT (subordinate): Supplementary field 4 |
P_FUNC_DT2_SUPPLEMENTARYFIELD05 |
DT (subordinate): Supplementary field 5 |
P_FUNC_CRAFT |
Trade |
P_FUNC_SUBCRAFT |
Subtrade |
P_FUNC_ISPLACEDIN_CIRCUIT |
Function has the "Multi-line" representation type |
P_FUNC_ISPLACEDIN_SINGLELINE |
Function has the "Single-line" representation type |
P_FUNC_ISPLACEDIN_PAIRCROSSREFERENCE |
Function has the "Pair cross-reference" representation type |
P_FUNC_ISPLACEDIN_OVERVIEW |
Function has the "Overview" representation type |
P_FUNC_ISPLACEDIN_PROCESSANDINSTDIAGRAM |
Function has the "P&I diagram" representation type |
P_ARTICLEREF_PARTNO |
Part number |
P_ARTICLEREF_COUNT |
Quantity |
P_ARTICLEREF_COUNT_PLACED |
Quantity (placed) |
P_ARTICLEREF_COUNT_NOTPLACED |
Quantity (unplaced) |
P_ARTICLEREF_MOUNTINGPLATE |
Mounting panel |
P_ARTICLEREF_PARTTYPE |
Record type |
P_ARTICLEREF_POSNR |
Item number |
P_ARTICLEREF_VARIANT |
Variant |
P_ARTICLEREF_FUNCTIONGROUP |
Function group |
P_ARTICLEREF_PIECETYPE |
Part group |
P_ARTICLEREF_ASSIGNMENT |
Part allocation |
P_ARTICLEREF_ASSEMBLY |
Assembly |
P_ARTICLEREF_MODULE_PART |
Module part |
P_ARTICLEREF_SUPPRESSINPARTSLIST |
Suppress in bill of materials (if filtered) |
P_ARTICLEREF_PROJECTARTICLE |
Project parts |
P_ARTICLEREF_COUNT_TOTAL |
Total amount (number of units) |
P_ARTICLEREF_LENGTH_SUM |
Total cable length |
P_ARTICLEREF_ADDITIONAL_TEXTFIELD |
Suppl. field: Text |
P_ARTICLEREF_ADDITIONAL_BOOLFIELD |
Supplementary field Yes / No |
P_ARTICLEREF_TOTALPURCHASEPRICE_1 |
Total purchase price 1 |
P_ARTICLEREF_TOTALPURCHASEPRICE_2 |
Total purchase price 2 |
P_ARTICLE_TYPENR |
Type number |
P_ARTICLE_ORDERNR |
Order number |
P_ARTICLE_DESCR1 |
Designation 1 |
P_ARTICLE_DESCR2 |
Designation 2 |
P_ARTICLE_DESCR3 |
Designation 3 |
P_ARTICLE_MANUFACTURER |
Manufacturer |
P_ARTICLE_SUPPLIER |
Supplier |
P_ARTICLE_MACRO |
Graphical macro (incl. directory) |
P_ARTICLE_HEIGHT |
Height |
P_ARTICLE_WIDTH |
Width |
P_ARTICLE_DEPTH |
Depth |
P_ARTICLE_MACRONAME |
Graphical macro |
P_ARTICLE_PRODUCTSUBGROUP |
Product subgroup |
P_ARTICLE_PICTUREFILE |
Image file |
P_ARTICLE_CABLEDESIGNATION |
Cable designation in graphic |
P_ARTICLE_SALESPRICE_1 |
Sales price 1 |
P_ARTICLE_SALESPRICE_2 |
Sales price 2 |
P_ARTICLE_WEAR |
Wearing part |
P_ARTICLE_SPARE |
Spare part |
P_ARTICLE_MAINTENANCE |
Lubrication / maintenance |
P_ARTICLE_LIFETIME |
Service time |
P_ARTICLE_STRESS |
Stress |
P_ARTICLE_USAGE |
Procurement |
P_ARTICLE_FREE_DATA_DESCRIPTION |
Free property: Description |
P_ARTICLE_FREE_DATA_VALUE |
Free property: Value |
P_ARTICLE_FREE_DATA_UNIT |
Free property / unit |
P_ARTICLE_EXTERNAL_PLACEMENT |
External placement |
REFERENCE_POS |
Reference position of the part; when assigning several parts, this defines the sequence in which parts are entered into the Part tab in the Properties <...> dialog. |
See also