Bills of Materials: Export File Fields

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.