This functionality is only available for certain module packages. Info / Copyright

XML Export / Import: Tags and Associated Attributes

The following tables list the tags used for export and import, their attributes, and additional information. Here, the data types in the "Type" column have the following meanings:

Bool

"0" or " " mean "no", "false", or "off", "1" means "yes", "true", or "on".

Integer / Long

"" means the same as "0".

For attributes of a selection list, only certain values may be used which can be selected in parts management. An overview of the valid values can be found in the section Overview of Selection Lists.

Double / Currency

The decimal separator is the period.

"" means the same as "0".

Text / memo

Multilingual text

Language parts in a multilingual text are defined starting with the language code and ending with a semicolon. Between the language code and the text there must be an "@".

<partsmanagement>

Attribute

Field name

Remark

length-unit Unit of length Unit in which lengths are imported, for instance "mm" or "inch". Optional, default "mm".
type Type Type of parts management. Currently the only supported value is "EPLAN.PartsManagement". Optional.
build Build number Build number at the time of export. Optional.

<part>

Attribute

Type

Length

Field name

Remark

P_ARTICLE_PARTTYPE Integer 2 bytes Type This attribute must be set to the value "1" ("Component"), "4" ("Assembly") or "5" ("Module")!
P_ARTICLE_PARTNR Text 255 characters Part number

P_ARTICLE_IS_ACCESSORY Bool 1 bytes Accessories

P_ARTICLE_CERTIFICATE Text 50 characters Certification: General

P_ARTICLE_CERTIFICATE_CE Bool 1 bytes Certification: CE

P_ARTICLE_CERTIFICATE_UL Text 50 characters Certification: UL

P_ARTICLE_CERTIFICATE_VDE Text 50 characters Certification: VDE

P_ARTICLE_CERTIFICATE_ATEX Text 50 characters Certification: ATEX identifier

P_ARTICLE_REF_CONSTRUCTION_NAME Text 40 characters Drilling pattern

P_ARTICLE_CRAFT_COOLING Bool 1 bytes Trade: Cooling

P_ARTICLE_CRAFT_ELECTRICAL Bool 1 bytes Trade: Electrical engineering

P_ARTICLE_CRAFT_FLUID Bool 1 bytes Fluid power trade

P_ARTICLE_CRAFT_HYDRAULICS Bool 1 bytes Trade: Hydraulics

P_ARTICLE_CRAFT_LUBRICATION Bool 1 bytes Trade: Lubrication

P_ARTICLE_CRAFT_MECHANICS Bool 1 bytes Trade: Mechanics

P_ARTICLE_CRAFT_PNEUMATICS Bool 1 bytes Trade: Pneumatics

P_ARTICLE_CRAFT_COOLINGLUBRICANT Bool 1 bytes Trade cooling lubricant

P_ARTICLE_CRAFT_GASTECHNOLOGY Bool 1 bytes Trade gas engineering

P_ARTICLE_CRAFT_FLUID_UNDEFINED Bool 1 bytes Trade fluid power (undefined)

P_ARTICLE_CRAFT_PROCESS Bool 1 bytes Process engineering trade

P_PART_CREATE Text 40 characters Creation date

P_ARTICLE_DEPTH Double 8 bytes Depth

P_ARTICLE_DISCONTINUED Bool 1 bytes Discontinued part

P_ARTICLE_SPACING_FRONT Double 8 bytes Mounting clearance Depth: Front

P_ARTICLE_SPACING_REAR Double 8 bytes Mounting clearance Depth: Rear

P_ARTICLE_DESCR1 Memo 0 characters Designation 1 Multilingual
P_ARTICLE_DESCR2 Memo 0 characters Designation 2 Multilingual
P_ARTICLE_DESCR3 Memo 0 characters Designation 3 Multilingual
P_ARTICLE_DISCOUNT Double 8 bytes Discount

P_ARTICLE_ECABINET_MACRO Text 255 characters Texture Example: "C:\texture.jpg" or
"$(MD_IMAGES)\texture.jpg"
P_ARTICLE_ERPNR Text 50 characters ERP no.

P_ARTICLE_EXTERNAL_DOCUMENT_1 Memo 0 characters External document 1
P_ARTICLE_EXTERNAL_DOCUMENT_2 Memo 0 characters External document 2
P_ARTICLE_EXTERNAL_DOCUMENT_3 Memo 0 characters External document 3
P_ARTICLE_EXTERNAL_DOCUMENT_4 Memo 0 characters External document 4
P_ARTICLE_EXTERNAL_DOCUMENT_5 Memo 0 characters External document 5
P_ARTICLE_EXTERNAL_DOCUMENT_6 Memo 0 characters External document 6
P_ARTICLE_EXTERNAL_DOCUMENT_7 Memo 0 characters External document 7
P_ARTICLE_EXTERNAL_DOCUMENT_8 Memo 0 characters External document 8
P_ARTICLE_EXTERNAL_DOCUMENT_9 Memo 0 characters External document 9
P_ARTICLE_EXTERNAL_DOCUMENT_10 Memo 0 characters External document 10
P_ARTICLE_EXTERNAL_DOCUMENT_11 Memo 0 characters External document 11
P_ARTICLE_EXTERNAL_DOCUMENT_12 Memo 0 characters External document 12
P_ARTICLE_EXTERNAL_DOCUMENT_13 Memo 0 characters External document 13
P_ARTICLE_EXTERNAL_DOCUMENT_14 Memo 0 characters External document 14
P_ARTICLE_EXTERNAL_DOCUMENT_15 Memo 0 characters External document 15
P_ARTICLE_EXTERNAL_DOCUMENT_16 Memo 0 characters External document 16
P_ARTICLE_EXTERNAL_DOCUMENT_17 Memo 0 characters External document 17
P_ARTICLE_EXTERNAL_DOCUMENT_18 Memo 0 characters External document 18
P_ARTICLE_EXTERNAL_DOCUMENT_19 Memo 0 characters External document 19
P_ARTICLE_EXTERNAL_DOCUMENT_20 Memo 0 characters External document 20
P_ARTICLE_EXTERNAL_PLACEMENT Bool 1 bytes External placement

P_ARTICLE_FUNCTIONGROUP Text 30 characters Function group

P_ARTICLE_IDENTCODE Text 20 characters Barcode number

P_ARTICLE_IDENTTYPE Text 20 characters Barcode type

P_ARTICLE_MACRO Text 255 characters Graphical macro (incl. directory)

P_ARTICLE_GROUPNUMBER Text 10 characters Group number

P_ARTICLE_GROUPSYMBOLMACRO Text 255 characters Macro Example: "C:\macro.ema" or
"$(MD_MACROS)\Macro.ema"
P_ARTICLE_HEIGHT Double 8 bytes Height

P_ARTICLE_SPACING_ABOVE Double 8 bytes Mounting clearance Height: Above

P_ARTICLE_SPACING_BELOW Double 8 bytes Mounting clearance Height: Below

P_PART_LASTCHANGE Text 40 characters Last change

P_ARTICLE_LIFETIME Text 16 characters Service time

P_ARTICLE_MAINTENANCE Text 16 characters Lubrication / maintenance

P_ARTICLE_MANUFACTURER Text 30 characters Manufacturer

P_ARTICLE_MOUNTINGSITE Long 4 bytes Mounting surface Selection list
P_ARTICLE_MOUNTINGSPACE Double 8 bytes Space requirement

P_ARTICLE_NOTE Memo 0 characters Description Multilingual
P_ARTICLE_ORDERNR Text 255 characters Order number

P_ARTICLE_PACKAGINGPRICE_1 Currency 8 bytes Purchase price 1/packaging

P_ARTICLE_PACKAGINGPRICE_2 Currency 8 bytes Purchase price 2/packaging

P_ARTICLE_PACKAGINGQUANTITY Double 8 bytes Quantity/packaging

P_ARTICLE_PICTUREFILE Text 255 characters Image file

P_ARTICLE_PIECETYPE Text 10 characters Part group

P_ARTICLE_PRICEUNIT Integer 2 bytes Price unit

P_ARTICLE_PRODUCTTOPGROUP Integer 2 bytes Generic product group Selection list
P_ARTICLE_PRODUCTGROUP Integer 2 bytes Product group Selection list
P_ARTICLE_PRODUCTSUBGROUP Integer 2 bytes Product subgroup Selection list
P_ARTICLE_PURCHASEPRICE_1 Currency 8 bytes Purchase price 1/price unit

P_ARTICLE_PURCHASEPRICE_2 Currency 8 bytes Purchase price 2/price unit

P_ARTICLE_QUANTITYUNIT Memo 0 characters Quantity unit Multilingual
P_ARTICLE_REF_TERMINAL_OFFSET_X Double 8 bytes Offset in X direction (connection point pattern)
P_ARTICLE_REF_TERMINAL_OFFSET_Y Double 8 bytes Offset in Y direction (connection point pattern)
P_ARTICLE_REPORT_IDENTIFIER Text 20 characters Identifier for reports

P_ARTICLE_REPORT_SYMBOL Memo 0 characters Symbol for reports

P_ARTICLE_SALESPRICE_1 Currency 8 bytes Sales price 1

P_ARTICLE_SALESPRICE_2 Currency 8 bytes Sales price 2

P_ARTICLE_SNAPHEIGHT Double 8 bytes Clip-on height

P_ARTICLE_SNAPHEIGHTMIDDLEOFFSET Double 8 bytes Center mismatch

P_ARTICLE_INSTALLATION_DEPTH Double 8 bytes Mounting depth

P_ARTICLE_SPARE Text 16 characters Spare part

P_ARTICLE_STRESS Text 16 characters Stress

P_ARTICLE_SUBCRAFT_ELECTRICAL Memo 0 characters Subtrade "Electrical engineering" Multilingual; if you yourself have produced a subtrade under a trade, this is output in the form P_ARTICLE_SUBCRAFT_<Trade>-1="??_??@<Subtrade name>;" (so e.g. P_ARTICLE_SUBCRAFT_ELECTRICAL-1="??_??@test;" for the first subtrade under "Electrical engineering" with the name "test"). As the properties are indexed, the index is output with a "minus".
P_ARTICLE_SUBCRAFT_MECHANICS Memo 0 characters Subtrade "Mechanics" Multilingual
P_ARTICLE_SUBCRAFT_HYDRAULICS Memo 0 characters Subtrade "Hydraulics" Multilingual
P_ARTICLE_SUBCRAFT_PNEUMATICS Memo 0 characters Subtrade "Pneumatics" Multilingual
P_ARTICLE_SUBCRAFT_LUBRICATION Memo 0 characters Subtrade "Lubrication" Multilingual
P_ARTICLE_SUBCRAFT_COOLING Memo 0 characters Subtrade "Cooling" Multilingual
P_ARTICLE_SUBCRAFT_PROCESS Memo 0 characters Subtrade "Process engineering" Multilingual
P_ARTICLE_SUPPLIER Text 30 characters Supplier

P_ARTICLE_REF_TERMINAL_NAME Text 40 characters Connection point designation (connection points)

P_ARTICLE_TERMINALSIZE_DESTINATION Text 255 characters Connection dimension target

P_ARTICLE_TERMINALSIZE_SOURCE Text 255 characters Connection dimension source

P_ARTICLE_TYPENR Text 255 characters Type number

P_ARTICLE_UNIQUEID Text 50 characters Unique part ID

Derives from Data Portal.

P_ARTICLE_USAGE Text 16 characters Procurement

P_ARTICLE_WEAR Text 16 characters Wearing part

P_ARTICLE_WEIGHT Double 8 bytes Weight

P_ARTICLE_WIDTH Double 8 bytes Width

P_ARTICLE_SPACING_LEFT Double 8 bytes Mounting clearance Width: Left

P_ARTICLE_SPACING_RIGHT Double 8 bytes Mounting clearance Width: Right

P_ARTICLE_3DMACRO Text 255 characters Graphical macro

The following additional attributes are for mechanical parts:

Attribute

Type

Length

Field name

Remark

P_ARTICLE_HINGEPOSITION Long 4 bytes Door: hinge Properties; Selection list

<variant>

Attribute

Type

Length

Field name

Remark

P_ARTICLE_VARIANT Text 3 characters Variant

P_ARTICLE_ASSEMBLY_POS_PLACE_SPREADED Bool 1 bytes Distributed placement of assembly Assembly
P_ARTICLE_CONNECTIONDESIGNATION Text 255 characters Connection point designation

P_ARTICLE_SYMBOLFILE Text 30 characters Symbol library

P_ARTICLE_SYMBOLNUMBER Text 30 characters Symbol number

P_ARTICLE_CHARACTERISTICS Text 60 characters Technical characteristics

P_ARTICLE_WIRECROSSSECTION_UNIT Integer 2 bytes Unit for connection cross-section / diameter Properties; Selection list

<functiontemplate>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

functiondefcategory Integer 2 bytes Category (function data) Selection list
functiondefgroup Integer 2 bytes Group (function data) Selection list
functiondefid Integer 2 bytes Function definition (function data) Selection list; the attributes "functiondefcategory", "functiondefgroup", and "functiondefid" together make up a function definition (see also Overview of Function Definitions).
additionaldescription Memo 0 Description (function data) Multilingual
characteristics Text 60 characters Technical characteristics The meaning of this attribute depends on the type of part:
Product group
"General": "Technical characteristics"
Product group
"Cables": "Potential type" (Selection list)
Product group
"Relays, contactors": "Technical characteristics"
Product group
"Plugs": is not used
Product group
"Terminals": is not used
Product group
"PLC": is not used
connectioncrosssection Text 255 characters Connection point cross-section / diameter

connectionDesignation Text 255 characters Connection point designations The meaning of this attribute depends on the type of part:
Product group
"General": "Connection point designations"
Product group
"Cables": "Connection color / number"
Product group
"Relays, contactors": "Connection point designations"
Product group
"Plugs": "Connection point designations"
Product group
"Terminals": "Connection point designations"
Product group
"PLC": "Connection point designations"
A line break is used as a separator!
connectiondescription Text 255 characters Connection point descriptions

connectiondimension Text 255 characters Connection dimension

description Text 30 characters Terminal / pin description

hasled Bool 1 bytes Terminal with LED

hasplugadapter Bool 1 bytes Terminal with plug-in adapter Only available for function templates of terminals.
idx1 Text 30 characters Index 1 The meaning of this attribute depends on the type of part:
Product group
"General": is not used
Product group
"Cables": "Shielded by"
Product group
"Relays, contactors": "Contact / coil index"
Product group
"Plugs": is not used
Product group
"Terminals": "Level"
Product group
"PLC": "Channel designation"
idx2 Text 30 characters Index 2 The meaning of this attribute depends on the type of part:
Product group
"General": is not used
Product group
"Cables": "Pair index"
Product group
"Relays, contactors": is not used
Product group
"Plugs": is not used
Product group
"Terminals": is not used
Product group
"PLC": is not used
intrinsicsafety Bool 1 bytes Intrinsically safe

nesteddevicetag Text 30 characters Subordinate DT

pipeclass Text 20 characters Pipe class

plcbussystem Integer 2 bytes Bus system Selection list
safetyrelevant Bool 1 bytes Safety function

symbol Text 50 characters Symbol

Symbolmacro Text 255 characters Symbol macro

terminalfunction Integer 2 bytes Terminal category Selection list
terminallabeltype Text 20 characters Labeling type

terminalNr Text 30 characters Terminal number The meaning of this attribute depends on the type of part:
Product group
"General": is not used
Product group
"Cables": "Connection cross-section / diameter"
Product group
"Relays, contactors": is not used
Product group
"Plugs": "Terminal / pin designation"
Product group
"Terminals": "Terminal / pin designation"
Product group
"PLC": "Plug designation"

<freeproperty>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position No more than 200 allowed!
P_ARTICLE_FREE_DATA_DESCRIPTION Memo 0 characters Free properties: Description Multilingual
P_ARTICLE_FREE_DATA_UNIT Text 50 characters Free properties: Unit

P_ARTICLE_FREE_DATA_VALUE Memo 0 characters Free properties: Value Multilingual

<blockingSurfacePosition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

frontside Bool 1 bytes Front

height Double 8 bytes Height

type Long 4 bytes Type Selection list
width Double 8 bytes Width

xpos Double 8 bytes X position

ypos Double 8 bytes Y position

<doorPosition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

partnr Text 255 characters Part number

variant Text 3 characters Variant

xpos Double 8 bytes X position

ypos Double 8 bytes Y position

zpos Double 8 bytes Z position

<mountingPanelPosition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

angle Double 8 bytes Angle

location Long 4 bytes Mounting location Selection list
partnr Text 255 characters Part number

variant Text 3 characters Variant

xpos Double 8 bytes X position

ypos Double 8 bytes Y position

zpos Double 8 bytes Z position

<supportBarPosition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

length Double 8 bytes Length

partnr Text 255 characters Part number

variant Text 3 characters Variant

xpos Double 8 bytes X position

ypos Double 8 bytes Y position

zpos Double 8 bytes Z position

<assemblyposition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

count Integer 2 bytes Quantity

partnr Text 255 characters Part number

variant Text 3 characters Variant

posnr Text 50 characters Item number

additionaltext Text 50 characters Supplementary text

<moduleposition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

count Integer 2 bytes Quantity

devicetag Text 255 characters DT

moduleid Text 16 characters Module ID

partnr Text 255 characters Part number

variant Text 3 characters Variant

<attributeposition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

val Text 80 characters Value

<accessoryposition>

Attribute

Type

Length

Field name

Remark

necessary Bool 1 bytes Required

partnr Text 255 characters Part number

pos Integer 2 bytes Position

variant Text 3 characters Variant

parttype Integer 2 bytes Record type Selection list; only "Component" and "Accessory list" are supported!
placement Text 50 characters Accessory placement

<accessorylist>

Attribute

Type

Length

Field name

Remark

class Integer 2 bytes Type Only the value 13 is supported!
P_PART_ACCESSORYLIST_CREATE Text 40 characters Creation date

P_PART_ACCESSORYLIST_DESCRIPTION Memo 0 characters Description

P_PART_ACCESSORYLIST_LASTCHANGE Text 40 characters Last change

P_PART_ACCESSORYLIST_NAME Text 40 characters Name

<accessorylistposition>

Attribute

Type

Length

Field name

Remark

partnr Text 255 characters Part number

pos Integer 2 bytes Position

variant Text 3 characters Variant

placement Text 50 characters Accessory placement

<accessoryplacement>

Attribute

Type

Length

Field name

Remark

class Integer 2 bytes Type Only the value 14 is supported!
P_PART_ACCESSORYPLACEMENT_CREATE Text 40 characters Creation date

P_PART_ACCESSORYPLACEMENT_DESCRIPTION Memo 0 characters Description

P_PART_ACCESSORYPLACEMENT_LASTCHANGE Text 40 characters Last change

P_PART_ACCESSORYPLACEMENT_NAME Text 50 characters Name

<accessoryplacementposition>

Attribute

Type

Length

Field name

Remark

name Text 40 characters Installation variant

pos Integer 2 bytes Position

referencepoint Integer 2 bytes Base point

rotation Double 8 bytes Rotation

xspacing Double 8 bytes Offset in X-direction

yspacing Double 8 bytes Offset in Y-direction

zspacing Double 8 bytes Offset in Z-direction

movable Bool 1 bytes Can be moved

<construction>

Attribute

Type

Length

Field name

Remark

class Integer 2 bytes Type Only the value 6 is supported!
P_PART_CONSTRUCTION_CREATE Text 40 characters Creation date

P_PART_CONSTRUCTION_DESCRIPTION Memo 0 characters Description Multilingual
P_PART_CONSTRUCTION_LASTCHANGE Text 40 characters Last change

P_PART_CONSTRUCTION_NAME Text 40 characters Name

<constructionPosition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

name Text 40 characters Name

offsetx Double 8 bytes Offset in X-direction

offsety Double 8 bytes Offset in Y-direction

<drillingPosition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

angle Double 8 bytes Angle

dimension1 Double 8 bytes 1st dimension

dimension2 Double 8 bytes 2nd dimension

dimension3 Double 8 bytes 3rd dimension

drillnthhole Long 4 bytes Drill every n-th hole

outlinename Text 255 characters Outline name

spacingend Double 8 bytes End spacing

spacingrepeat Double 8 bytes Repetitive spacing

subtype Long 4 bytes Subtype Selection list
type Long 4 bytes Drill type Selection list
xpos Double 8 bytes X position

ypos Double 8 bytes Y position

fabricatealways Bool 1 bytes Always make

<terminal>

Attribute

Type

Length

Field name

Remark

class Integer 2 bytes Type Only the value 7 is supported!
P_PART_TERMINAL_ADDITIONALLENGTHDEFAULT Double 8 bytes Additional length

P_PART_TERMINAL_CREATE Text 40 characters Creation date

P_PART_TERMINAL_DESCRIPTION Memo 0 characters Description Multilingual
P_PART_TERMINAL_DIRECTION Long 4 bytes Routing direction Selection list
P_PART_TERMINAL_LASTCHANGE Text 40 characters Last change

P_PART_TERMINAL_NAME Text 40 characters Name

P_PART_TERMINAL_TYPEDEFAULT Long 4 bytes Wire termination processing (EPLAN Cabinet) Selection list
P_PART_TERMINAL_TERMINALSIZE_DEFAULT Text 20 characters Connection dimension

P_PART_TERMINAL_TYPEOFTERMINAL_DEFAULT Long 4 bytes Connection category Selection list

<terminalPosition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

additionallength Double 8 bytes Additional length

devicetag Text 255 characters Plug designation

direction Long 4 bytes Routing direction Selection list
level Integer 2 bytes Level

maxcrosssection Double 8 bytes Max. cross-section / diameter

maxwirecount Long 4 bytes Max. number of connections

mincrosssection Double 8 bytes Min. cross-section / diameter

maxcrosssectionawg Text 20 characters Max. AWG

mincrosssectionawg Text 20 characters Min. AWG

name Text 20 characters Connection point designation

targetinfo Integer 2 bytes Internal / External index

terminalsize Text 20 characters Connection dimension

twinsleeve Bool 1 bytes Dual sleeve prescribed

typeofterminal Long 4 bytes Connection category Selection list
xpos Double 8 bytes X position

ypos Double 8 bytes Y position

zpos Double 8 bytes Z position

xdir Double 8 bytes X vector

ydir Double 8 bytes Y vector

zdir Double 8 bytes Z vector

<safetyRelatedValuePosition>

Attribute

Type

Length

Field name

Remark

pos Integer 2 bytes Position

posid Integer 2 bytes Position ID

hierarchy1 Memo 0 Level 1 (text in tree structure) Multilingual
hierarchy2 Memo 0 Level 2 (text in tree structure) Multilingual
hierarchy3 Memo 0 Level 3 (text in tree structure) Multilingual
hierarchy4 Memo 0 Level 4 (text in tree structure) Multilingual
hierarchy5 Memo 0 Level 5 (text in tree structure) Multilingual
input Bool 1 bytes Input (collect)

logic Bool 1 bytes Logic (Generate report)

output Bool 1 bytes Output (React)

pl Text 30 characters PL

silcl Text 30 characters SIL CL

pfhd Double 8 bytes PFHD

tmt1 Double 8 bytes TMT1

mttfd Double 8 bytes MTTFD

lamdad Double 8 bytes Lambda-d

mttf Double 8 bytes MTTF

mtbf Double 8 bytes MTBF

rdf Double 8 bytes RDF

b10 Double 8 bytes B10

b10d Double 8 bytes B10 D

<address>

Attribute

Type

Length

Field name

Remark

class Integer 2 bytes Type Selection list; only "Customer" and "Manufacturer / supplier" are supported!
P_PART_ADDRESS_EMAIL Text 70 characters E-mail

P_PART_ADDRESS_FAX Text 30 characters Fax

P_PART_ADDRESS_LASTCHANGE Text 40 characters Last change

P_PART_ADDRESS_LONGNAME Text 70 characters Full name

P_PART_ADDRESS_NAME1 Text 40 characters Name 1

P_PART_ADDRESS_NAME2 Text 40 characters Name 2

P_PART_ADDRESS_NAME3 Text 40 characters Name 3

P_PART_ADDRESS_NOTE Memo 0 characters Description

P_PART_ADDRESS_NUMBER Text 30 characters Customer number

P_PART_ADDRESS_PHONE Text 50 characters Phone

P_PART_ADDRESS_POBOX Text 30 characters P.O. box

P_PART_ADDRESS_SHORTNAME Text 30 characters Short name

P_PART_ADDRESS_STATE Text 30 characters Country

P_PART_ADDRESS_STREET Text 100 characters Street

P_PART_ADDRESS_TITLE Text 30 characters Title

P_PART_ADDRESS_TOWN Text 100 characters City

P_PART_ADDRESS_ZIPPOBOX Text 30 characters Zip code / P.O. box

P_PART_ADDRESS_ZIPTOWN Text 30 characters Zip code / City