1 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
2 |
ID |
|
CRM_IU_DSMAGREEMENTID |
|
STRU |
0 |
0 |
|
|
3 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
4 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
5 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
6 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
7 |
CONTENT |
|
CRM_IU_DEMAND_SIDE_MANAGEMENT4 |
|
CHAR |
10 |
0 |
Proxy Data Element (generated) |
|
8 |
BUSINESS_AGREEMENT |
|
CRM_IU_SERV_INDUS_BUS_AGRMT_ID |
|
STRU |
0 |
0 |
|
|
9 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
10 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
11 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
12 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
13 |
CONTENT |
|
CRM_IU_SERVICE_INDUSTRIES_BUSI |
|
CHAR |
12 |
0 |
Proxy Data Element (generated) |
|
14 |
DESCRIPTION |
|
CRM_IU_LANGUAGEINDEPENDENT_SHO |
|
CHAR |
40 |
0 |
LANGUAGEINDEPENDENT_SHORT_Description |
|
15 |
VALIDITY_DATE_PERIOD |
|
CRM_IU_DATE_PERIOD |
|
STRU |
0 |
0 |
|
|
16 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
17 |
START_DATE |
|
CRM_IU_DATE |
XSDDATE_D |
DATS |
8 |
0 |
Date |
|
18 |
END_DATE |
|
CRM_IU_DATE |
XSDDATE_D |
DATS |
8 |
0 |
Date |
|
19 |
DURATION |
|
CRM_IU_DURATION |
|
STRG |
0 |
0 |
Duration |
|
20 |
POSTING_DATE |
|
CRM_IU_DATE |
XSDDATE_D |
DATS |
8 |
0 |
Date |
|
21 |
PROJECT_COST_AMOUNT |
|
CRM_IU_AMOUNT |
|
STRU |
0 |
0 |
|
|
22 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
23 |
CURRENCY_CODE |
|
CRM_IU_CURRENCY_CODE |
|
CHAR |
3 |
0 |
Currency |
|
24 |
CONTENT |
|
CRM_IU_AMOUNT_CONTENT |
|
DEC |
28 |
6 |
Amount |
|
25 |
APPROVED_TOTAL_AMOUNT |
|
CRM_IU_AMOUNT |
|
STRU |
0 |
0 |
|
|
26 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
27 |
CURRENCY_CODE |
|
CRM_IU_CURRENCY_CODE |
|
CHAR |
3 |
0 |
Currency |
|
28 |
CONTENT |
|
CRM_IU_AMOUNT_CONTENT |
|
DEC |
28 |
6 |
Amount |
|
29 |
MEASURE_ITEM |
|
CRM_IU_DSMAGRMPIFNO_MSR_TAB |
|
TTYP |
0 |
0 |
|
|
30 |
BUYER_PARTY |
|
CRM_IU_DSMAGRMPIFNO_BUYPTY_IDT |
|
STRU |
0 |
0 |
|
|
31 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
32 |
INTERNAL_ID |
|
CRM_IU_PARTY_INTERNAL_ID |
|
STRU |
0 |
0 |
|
|
33 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
34 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
35 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
36 |
CONTENT |
|
CRM_IU_PARTY_INTERNAL_ID_CONTE |
|
CHAR |
32 |
0 |
PartyInternalID |
|
37 |
FORMATTED_NAME |
|
CRM_IU_LONG_NAME |
|
STRU |
0 |
0 |
|
|
38 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
39 |
LANGUAGE_CODE |
|
CRM_IU_LANGUAGE_CODE |
|
CHAR |
9 |
0 |
Language |
|
40 |
CONTENT |
|
CRM_IU_LONG_NAME_CONTENT |
|
CHAR |
80 |
0 |
Proxy Data Element (generated) |
|
41 |
PARTY |
|
CRM_IU_DSMAGRMPIFNO_PTY_TAB |
|
TTYP |
0 |
0 |
|
|
42 |
SALES_SERVICE_BUSINESS_AREA |
|
CRM_IU_DSMAGRMPIFNO_BUAREA_IDT |
|
STRU |
0 |
0 |
|
|
43 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
44 |
SALES_ORGANISATION_ID |
|
CRM_IU_ORGANISATIONAL_CENTRE_I |
|
CHAR |
20 |
0 |
Organisational Centre |
|
45 |
DISTRIBUTION_CHANNEL_CODE |
|
CRM_IU_DISTRIBUTION_CHANNEL_C1 |
|
STRU |
0 |
0 |
|
|
46 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
47 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
48 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
49 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
50 |
LIST_AGENCY_SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
51 |
LIST_AGENCY_SCHEME_AGENCY_ID |
|
CRM_IU_AGENCY_IDENTIFICATION_C |
|
CHAR |
3 |
0 |
AgencyIdentificationCode |
|
52 |
CONTENT |
|
CRM_IU_DISTRIBUTION_CHANNEL_CO |
|
CHAR |
2 |
0 |
Distribution Channel |
|
53 |
DIVISION_CODE |
|
CRM_IU_DIVISION_CODE |
|
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 |
|
CRM_IU_AGENCY_IDENTIFICATION_C |
|
CHAR |
3 |
0 |
AgencyIdentificationCode |
|
60 |
CONTENT |
|
CRM_IU_DIVISION_CODE_CONTENT |
|
CHAR |
2 |
0 |
Proxy Data Element (generated) |
|
61 |
SALES_OFFICE_ID |
|
CRM_IU_ORGANISATIONAL_CENTRE_I |
|
CHAR |
20 |
0 |
Organisational Centre |
|
62 |
SALES_GROUP_ID |
|
CRM_IU_ORGANISATIONAL_CENTRE_I |
|
CHAR |
20 |
0 |
Organisational Centre |
|
63 |
SERVICE_ORGANISATION_UNIT_ID |
|
CRM_IU_ORGANISATIONAL_CENTRE_I |
|
CHAR |
20 |
0 |
Organisational Centre |
|
64 |
SERVICE_ORGANISATION_ID |
|
CRM_IU_ORGANISATIONAL_CENTRE_I |
|
CHAR |
20 |
0 |
Organisational Centre |
|
65 |
COMPANY_ID |
|
CRM_IU_COMPANY_ID |
|
STRU |
0 |
0 |
|
|
66 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
67 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
68 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
69 |
CONTENT |
|
CRM_IU_COMPANY_ID_CONTENT |
|
CHAR |
20 |
0 |
Proxy Data Element (generated) |
|
70 |
BACKEND_SYSTEM_SENDER_BUSINESS |
|
CRM_IU_BUSINESS_SYSTEM_ID |
|
CHAR |
60 |
0 |
System |
|
71 |
PREMISE_DATA |
|
CRM_IU_DSMAGRMPIFNO_PREMSD_IDT |
|
STRU |
0 |
0 |
|
|
72 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
73 |
ADDRESS |
|
CRM_IU_DSMAGRMPIFNO_DATADR_IDT |
|
STRU |
0 |
0 |
|
|
74 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
75 |
ADDRESS_ID |
|
CRM_IU_ADDRESS_ID |
|
CHAR |
40 |
0 |
Unique identifier for an address |
|
76 |
PHYSICAL_ADDRESS |
|
CRM_IU_DSMAGRMPIFNO_PHYADR_IDT |
|
STRU |
0 |
0 |
|
|
77 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
78 |
COUNTRY_CODE |
|
CRM_IU_COUNTRY_CODE |
|
CHAR |
3 |
0 |
Country |
|
79 |
COUNTRY_NAME |
|
CRM_IU_LONG_NAME |
|
STRU |
0 |
0 |
|
|
80 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
81 |
LANGUAGE_CODE |
|
CRM_IU_LANGUAGE_CODE |
|
CHAR |
9 |
0 |
Language |
|
82 |
CONTENT |
|
CRM_IU_LONG_NAME_CONTENT |
|
CHAR |
80 |
0 |
Proxy Data Element (generated) |
|
83 |
REGION_CODE |
|
CRM_IU_REGION_CODE |
|
STRU |
0 |
0 |
|
|
84 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
85 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
86 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
87 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
88 |
LIST_AGENCY_SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
89 |
LIST_AGENCY_SCHEME_AGENCY_ID |
|
CRM_IU_AGENCY_IDENTIFICATION_C |
|
CHAR |
3 |
0 |
AgencyIdentificationCode |
|
90 |
CONTENT |
|
CRM_IU_REGION_CODE_CONTENT |
|
CHAR |
6 |
0 |
RegionCode |
|
91 |
REGION_NAME |
|
CRM_IU_LANGUAGEINDEPENDENT_MED |
|
CHAR |
40 |
0 |
LANGUAGEINDEPENDENT_MEDIUM_Name |
|
92 |
CITY_NAME |
|
CRM_IU_LANGUAGEINDEPENDENT_MED |
|
CHAR |
40 |
0 |
LANGUAGEINDEPENDENT_MEDIUM_Name |
|
93 |
ADDITIONAL_CITY_NAME |
|
CRM_IU_LANGUAGEINDEPENDENT_MED |
|
CHAR |
40 |
0 |
LANGUAGEINDEPENDENT_MEDIUM_Name |
|
94 |
STREET_POSTAL_CODE |
|
CRM_IU_POSTAL_CODE |
|
CHAR |
10 |
0 |
Postal Code |
|
95 |
STREET_NAME |
|
CRM_IU_STREET_NAME |
|
CHAR |
60 |
0 |
Street |
|
96 |
REGIONAL_STRUCTURE_STREET_CODE |
|
CRM_IU_REGION_STRUCT_CITY_CODE |
|
STRU |
0 |
0 |
|
|
97 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
98 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
99 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
100 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
101 |
LIST_AGENCY_SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
102 |
LIST_AGENCY_SCHEME_AGENCY_ID |
|
CRM_IU_AGENCY_IDENTIFICATION_C |
|
CHAR |
3 |
0 |
AgencyIdentificationCode |
|
103 |
CONTENT |
|
CRM_IU_REGIONAL_STRUCTURE_CITY |
|
CHAR |
12 |
0 |
Proxy Data Element (generated) |
|
104 |
REGIONAL_STRUCTURE_STREET_NAME |
|
CRM_IU_LANGUAGEINDEPENDENT_MED |
|
CHAR |
40 |
0 |
LANGUAGEINDEPENDENT_MEDIUM_Name |
|
105 |
STREET_SUFFIX_NAME |
|
CRM_IU_LANGUAGEINDEPENDENT_MED |
|
CHAR |
40 |
0 |
LANGUAGEINDEPENDENT_MEDIUM_Name |
|
106 |
ADDITIONAL_STREET_SUFFIX_NAME |
|
CRM_IU_LANGUAGEINDEPENDENT_MED |
|
CHAR |
40 |
0 |
LANGUAGEINDEPENDENT_MEDIUM_Name |
|
107 |
HOUSE_ID |
|
CRM_IU_HOUSE_ID |
|
CHAR |
10 |
0 |
House Number |
|
108 |
ADDITIONAL_HOUSE_ID |
|
CRM_IU_HOUSE_ID |
|
CHAR |
10 |
0 |
House Number |
|
109 |
BUILDING_ID |
|
CRM_IU_BUILDING_ID |
|
CHAR |
10 |
0 |
Building |
|
110 |
ROOM_ID |
|
CRM_IU_ROOM_ID |
|
CHAR |
10 |
0 |
Room Number |
|
111 |
TIME_ZONE_CODE |
|
CRM_IU_TIME_ZONE_CODE |
|
CHAR |
10 |
0 |
Time Zone |
|
112 |
ADDRESS_SUPPLEMENT |
|
CRM_IU_DSMAGRMPIFNO_ADRSUP_IDT |
|
STRU |
0 |
0 |
|
|
113 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
114 |
FLOOR_ID |
|
CRM_IU_FLOOR_ID |
|
CHAR |
10 |
0 |
Floor |
|
115 |
ROOM_ID |
|
CRM_IU_ROOM_ID |
|
CHAR |
10 |
0 |
Room Number |
|
116 |
ADDITIONAL_INFORMATION_TEXT |
|
CRM_IU_LEN40_ADDITIONAL_INFOR1 |
|
STRU |
0 |
0 |
|
|
117 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
118 |
LANGUAGE_CODE |
|
CRM_IU_LANGUAGE_CODE |
|
CHAR |
9 |
0 |
Language |
|
119 |
CONTENT |
|
CRM_IU_LEN40_ADDITIONAL_INFORM |
|
CHAR |
40 |
0 |
LEN40_AdditionalInformationText |
|
120 |
DSM_PROGRAMME_REFERENCE |
|
CRM_IU_DSMAGRMPIFNO_PRGREF_IDT |
|
STRU |
0 |
0 |
|
|
121 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
122 |
ID |
|
CRM_IU_DSMPROGRAMMEID |
|
STRU |
0 |
0 |
|
|
123 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
124 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
125 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
126 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
127 |
CONTENT |
|
CRM_IU_DEMAND_SIDE_MANAGEMENT |
|
CHAR |
20 |
0 |
Proxy Data Element (generated) |
|
128 |
DSM_APPLICATION_REFERENCE |
|
CRM_IU_DSMAGRMPIFNO_APLREF_IDT |
|
STRU |
0 |
0 |
|
|
129 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
130 |
ID |
|
CRM_IU_DSMAPPLICATIONID |
|
STRU |
0 |
0 |
|
|
131 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
132 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
133 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
134 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
135 |
CONTENT |
|
CRM_IU_DEMAND_SIDE_MANAGEMENT2 |
|
CHAR |
10 |
0 |
Proxy Data Element (generated) |
|
136 |
BUSTRANS_DOCUMENT_REFERENCE |
|
CRM_IU_DSMAGRMPIFNO_DOCREF_TAB |
|
TTYP |
0 |
0 |
|
|