1
CONTROLLER
PRXCTRLTAB
TTYP
0
0
2
INTERNAL_ID
CRMSE_CONTACT_PERSON_INT_ID
STRU
0
0
3
CONTROLLER
PRXCTRLTAB
TTYP
0
0
4
SCHEME_ID
CHAR
60
0
5
SCHEME_AGENCY_ID
CHAR
60
0
6
VALUE
CRMSE_CONT_PERSON_INT_ID_CNT
CHAR
32
0
Proxy Data Element (Generated)
7
BUYER_ID
CRMSE_CONTACT_PERSON_PARTY_ID
CHAR
60
0
Proxy Data Element (Generated)
8
SELLER_ID
CRMSE_CONTACT_PERSON_PARTY_ID
CHAR
60
0
Proxy Data Element (Generated)
9
PRODUCT_RECIPIENT_ID
CRMSE_CONTACT_PERSON_PARTY_ID
CHAR
60
0
Proxy Data Element (Generated)
10
VENDOR_ID
CRMSE_CONTACT_PERSON_PARTY_ID
CHAR
60
0
Proxy Data Element (Generated)
11
BILL_TO_ID
CRMSE_CONTACT_PERSON_PARTY_ID
CHAR
60
0
Proxy Data Element (Generated)
12
BILL_FROM_ID
CRMSE_CONTACT_PERSON_PARTY_ID
CHAR
60
0
Proxy Data Element (Generated)
13
BIDDER_ID
CRMSE_CONTACT_PERSON_PARTY_ID
CHAR
60
0
Proxy Data Element (Generated)
14
ADDRESS
CRMSE_ADDRESS
STRU
0
0
15
CONTROLLER
PRXCTRLTAB
TTYP
0
0
16
ORGANISATION_FORMATTED_NAME
CRMSE_ADDR_ORGANISATION_TAB
TTYP
0
0
17
PERSON_NAME
CRMSE_PERSON_NAME
STRU
0
0
18
CONTROLLER
PRXCTRLTAB
TTYP
0
0
19
FORM_OF_ADDRESS_CODE
CRMSE_FORM_OF_ADDRESS_CODE
STRU
0
0
20
CONTROLLER
PRXCTRLTAB
TTYP
0
0
21
LIST_ID
CHAR
60
0
22
LIST_VERSION_ID
CHAR
15
0
23
LIST_AGENCY_ID
CHAR
60
0
24
LIST_AGENCY_SCHEME_ID
CHAR
60
0
25
LIST_AGENCY_SCHEME_AGENCY_ID
CHAR
3
0
26
VALUE
CRMSE_FORM_OF_ADDRESS_CODE_CON
CHAR
4
0
Proxy Data Element (Generated)
27
FORM_OF_ADDRESS_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
28
GIVEN_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
29
MIDDLE_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
30
FAMILY_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
31
ADDITIONAL_FAMILY_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
32
BIRTH_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
33
NICK_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
34
INITIALS_NAME
CRMSE_LANGU_INDEPENDENT_SHORT
CHAR
10
0
Proxy Data Element (Generated)
35
ACADEMIC_TITLE_CODE
CRMSE_ACADEMIC_TITLE_CODE
STRU
0
0
36
CONTROLLER
PRXCTRLTAB
TTYP
0
0
37
LIST_ID
CHAR
60
0
38
LIST_VERSION_ID
CHAR
15
0
39
LIST_AGENCY_ID
CHAR
60
0
40
LIST_AGENCY_SCHEME_ID
CHAR
60
0
41
LIST_AGENCY_SCHEME_AGENCY_ID
CRMSE_AGENCYIDENTIFICATIONCODE
CHAR
3
0
Proxy Data Element (Generated)
42
VALUE
CRMSE_ACADEMIC_TITLE_CODE_CNT
CHAR
4
0
Proxy Data Element (Generated)
43
ACADEMIC_TITLE_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
44
ADDITIONAL_ACADEMIC_TITLE_CODE
CRMSE_ACADEMIC_TITLE_CODE
STRU
0
0
45
CONTROLLER
PRXCTRLTAB
TTYP
0
0
46
LIST_ID
CHAR
60
0
47
LIST_VERSION_ID
CHAR
15
0
48
LIST_AGENCY_ID
CHAR
60
0
49
LIST_AGENCY_SCHEME_ID
CHAR
60
0
50
LIST_AGENCY_SCHEME_AGENCY_ID
CRMSE_AGENCYIDENTIFICATIONCODE
CHAR
3
0
Proxy Data Element (Generated)
51
VALUE
CRMSE_ACADEMIC_TITLE_CODE_CNT
CHAR
4
0
Proxy Data Element (Generated)
52
ADDITIONAL_ACADEMIC_TITLE_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
53
NAME_PREFIX_CODE
CRMSE_FAMILY_NAME_PREFIX_CODE1
STRU
0
0
54
CONTROLLER
PRXCTRLTAB
TTYP
0
0
55
LIST_ID
CHAR
60
0
56
LIST_VERSION_ID
CHAR
15
0
57
LIST_AGENCY_ID
CHAR
60
0
58
LIST_AGENCY_SCHEME_ID
CHAR
60
0
59
LIST_AGENCY_SCHEME_AGENCY_ID
CRMSE_AGENCYIDENTIFICATIONCODE
CHAR
3
0
Proxy Data Element (Generated)
60
VALUE
CRMSE_FAMILY_NAME_PREFIX_CODE
CHAR
4
0
Proxy Data Element (Generated)
61
NAME_PREFIX_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
62
ADDITIONAL_NAME_PREFIX_CODE
CRMSE_FAMILY_NAME_PREFIX_CODE1
STRU
0
0
63
CONTROLLER
PRXCTRLTAB
TTYP
0
0
64
LIST_ID
CHAR
60
0
65
LIST_VERSION_ID
CHAR
15
0
66
LIST_AGENCY_ID
CHAR
60
0
67
LIST_AGENCY_SCHEME_ID
CHAR
60
0
68
LIST_AGENCY_SCHEME_AGENCY_ID
CRMSE_AGENCYIDENTIFICATIONCODE
CHAR
3
0
Proxy Data Element (Generated)
69
VALUE
CRMSE_FAMILY_NAME_PREFIX_CODE
CHAR
4
0
Proxy Data Element (Generated)
70
ADDITIONAL_NAME_PREFIX_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
71
NAME_SUPPLEMENT_CODE
CRMSE_PERSON_NAME_SUPPLEMENT
STRU
0
0
72
CONTROLLER
PRXCTRLTAB
TTYP
0
0
73
LIST_ID
CHAR
60
0
74
LIST_VERSION_ID
CHAR
15
0
75
LIST_AGENCY_ID
CHAR
60
0
76
LIST_AGENCY_SCHEME_ID
CHAR
60
0
77
LIST_AGENCY_SCHEME_AGENCY_ID
CRMSE_AGENCYIDENTIFICATIONCODE
CHAR
3
0
Proxy Data Element (Generated)
78
VALUE
CRMSE_PERSON_NAME_SUPPL_CODE
CHAR
4
0
Proxy Data Element (Generated)
79
NAME_SUPPLEMENT_NAME
CRMSE_LANGU_INDEPENDENT_MEDIUM
CHAR
40
0
Proxy Data Element (Generated)
80
DEVIATING_FULL_NAME
CRMSE_LANGUAGEINDEP_LONG_NAME
CHAR
80
0
Proxy Data Element (Generated)
81
NAME_FORMAT_COUNTRY_CODE
CRMSE_COUNTRY_CODE
CHAR
3
0
Proxy Data Element (Generated)
82
NAME_FORMAT_CODE
CRMSE_PERSON_NAME_FORMAT_CODE1
STRU
0
0
83
CONTROLLER
PRXCTRLTAB
TTYP
0
0
84
LIST_ID
CHAR
60
0
85
LIST_AGENCY_ID
CHAR
60
0
86
LIST_VERSION_ID
CHAR
15
0
87
LIST_AGENCY_SCHEME_ID
CHAR
60
0
88
LIST_AGENCY_SCHEME_AGENCY_ID
CRMSE_AGENCYIDENTIFICATIONCODE
CHAR
3
0
Proxy Data Element (Generated)
89
VALUE
CRMSE_PERSON_NAME_FORMAT_CODE
CHAR
2
0
Proxy Data Element (Generated)
90
FUNCTIONAL_TITLE_NAME
CHAR
40
0
91
DEPARTMENT_NAME
CHAR
40
0
92
OFFICE
CRMSE_ADDRESS_OFFICE
STRU
0
0
93
CONTROLLER
PRXCTRLTAB
TTYP
0
0
94
BUILDING_ID
CHAR
10
0
95
FLOOR_ID
CHAR
10
0
96
ROOM_ID
CHAR
10
0
97
INHOUSE_MAIL_ID
CHAR
10
0
98
CORRESPONDENCE_SHORT_NAME
CHAR
10
0
99
PHYSICAL_ADDRESS
CRMSE_ADDRESS_PHYSICAL_ADDRESS
STRU
0
0
100
CONTROLLER
PRXCTRLTAB
TTYP
0
0
101
COUNTRY_CODE
CRMSE_COUNTRY_CODE
CHAR
3
0
Proxy Data Element (Generated)
102
REGION_CODE
CRMSE_REGION_CODE
STRU
0
0
103
CONTROLLER
PRXCTRLTAB
TTYP
0
0
104
LIST_ID
CHAR
60
0
105
LIST_VERSION_ID
CHAR
15
0
106
LIST_AGENCY_ID
CHAR
60
0
107
LIST_AGENCY_SCHEME_ID
CHAR
60
0
108
LIST_AGENCY_SCHEME_AGENCY_ID
CHAR
3
0
109
VALUE
CRMSE_REGION_CODE_CONTENT
CHAR
6
0
Proxy Data Element (Generated)
110
STREET_POSTAL_CODE
CHAR
10
0
111
POBOX_POSTAL_CODE
CHAR
10
0
112
COMPANY_POSTAL_CODE
CHAR
10
0
113
CITY_NAME
CHAR
40
0
114
ADDITIONAL_CITY_NAME
CHAR
40
0
115
DISTRICT_NAME
CHAR
40
0
116
POBOX_ID
CHAR
10
0
117
POBOX_INDICATOR
CHAR
5
0
118
POBOX_COUNTRY_CODE
CRMSE_COUNTRY_CODE
CHAR
3
0
Proxy Data Element (Generated)
119
POBOX_REGION_CODE
CRMSE_REGION_CODE
STRU
0
0
120
CONTROLLER
PRXCTRLTAB
TTYP
0
0
121
LIST_ID
CHAR
60
0
122
LIST_VERSION_ID
CHAR
15
0
123
LIST_AGENCY_ID
CHAR
60
0
124
LIST_AGENCY_SCHEME_ID
CHAR
60
0
125
LIST_AGENCY_SCHEME_AGENCY_ID
CHAR
3
0
126
VALUE
CRMSE_REGION_CODE_CONTENT
CHAR
6
0
Proxy Data Element (Generated)
127
POBOX_CITY_NAME
CHAR
40
0
128
STREET_NAME
CHAR
60
0
129
STREET_PREFIX_NAME
CRMSE_ADDR_STREET_PREFIX_TAB
TTYP
0
0
130
STREET_SUFFIX_NAME
CRMSE_ADDR_STREET_SUFFIX_TAB
TTYP
0
0
131
HOUSE_ID
CHAR
10
0
132
ADDITIONAL_HOUSE_ID
CHAR
10
0
133
BUILDING_ID
CHAR
20
0
134
FLOOR_ID
CHAR
10
0
135
ROOM_ID
CHAR
10
0
136
CARE_OF_NAME
CHAR
40
0
137
DESCRIPTION
CRMSE_DESCRIPTION_TAB
TTYP
0
0
138
TAX_JURISDICTION_CODE
CRMSE_TAX_JURISDICTION_CODE
STRU
0
0
139
CONTROLLER
PRXCTRLTAB
TTYP
0
0
140
LIST_ID
CHAR
60
0
141
LIST_VERSION_ID
CHAR
15
0
142
LIST_AGENCY_ID
CHAR
60
0
143
LIST_AGENCY_SCHEME_ID
CHAR
60
0
144
LIST_AGENCY_SCHEME_AGENCY_ID
CHAR
3
0
145
VALUE
CRMSE_TAX_JUR_CODE_CONT
CHAR
15
0
Proxy Data Element (Generated)
146
TIME_ZONE_DIFFERENCE_VALUE
CRM_TIME_ZONE_DIFF_VALUE
DEC
4
2
Proxy Data Element (Generated)
147
GEO_COORDINATES
CRMSE_GEO_COORDINATES
STRU
0
0
148
CONTROLLER
PRXCTRLTAB
TTYP
0
0
149
LATITUDE_MEASURE
CRMSE_MEASURE
STRU
0
0
150
CONTROLLER
PRXCTRLTAB
TTYP
0
0
151
UNIT_CODE
CHAR
3
0
152
VALUE
CRMSE_MEASURE_CONTENT
DEC
19
6
Proxy Data Element (Generated)
153
LONGITUDE_MEASURE
CRMSE_MEASURE
STRU
0
0
154
CONTROLLER
PRXCTRLTAB
TTYP
0
0
155
UNIT_CODE
CHAR
3
0
156
VALUE
CRMSE_MEASURE_CONTENT
DEC
19
6
Proxy Data Element (Generated)
157
COMMUNICATION
CRMSE_ADDRESS_COMMUNICATION
STRU
0
0
158
CONTROLLER
PRXCTRLTAB
TTYP
0
0
159
CORRESPONDENCE_LANGUAGE_CODE
CRMSE_LANGUAGE_CODE
CHAR
2
0
Proxy Data Element (Generated)
160
TELEPHONE
CRMSE_ADDRESS_TELEPHONE_TAB
TTYP
0
0
161
MOBILE_PHONE
CRMSE_ADDRESS_MOBILE_PHONE_TAB
TTYP
0
0
162
FACSIMILE
CRMSE_ADDRESS_FACSIMILE_TAB
TTYP
0
0
163
EMAIL
CRMSE_ADDRESS_EMAIL_TAB
TTYP
0
0
164
WEB
CRMSE_ADDRESS_WEB_TAB
TTYP
0
0