1 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
2 |
TRADE_PROMOTION_ID |
|
CRMSEF_TRADE_PROMOTION_ID |
|
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 |
|
CRMSEF_TRADE_PROMOTION_ID_CONT |
|
CHAR |
24 |
0 |
Proxy Data Element (generated) |
|
8 |
DESCRIPTION |
|
CRMSEF_SHORT_DESCRIPTION_TAB |
|
TTYP |
0 |
0 |
|
|
9 |
STATUS |
|
CRMTPM_CHGRQ_STATUS |
|
STRU |
0 |
0 |
|
|
10 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
11 |
USER_STATUS_PROFILE_CODE |
|
CRMSEF_USER_STATUS_PROFILE_CO1 |
|
STRU |
0 |
0 |
|
|
12 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
13 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
14 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
15 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
16 |
AGENCY_SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
17 |
AGENCY_ID |
|
CRMSEF_AGENCY_IDENTIFICATION_C |
|
CHAR |
3 |
0 |
An AgencyIdentificationCode is a code representation of th |
|
18 |
CONTENT |
|
CRMSEF_USER_STATUS_PROFILE_COD |
|
CHAR |
8 |
0 |
Proxy Data Element (generated) |
|
19 |
SYSTEM_STATUS |
|
CRMSEF_SYSTEM_STATUS |
|
STRU |
0 |
0 |
|
|
20 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
21 |
CODE |
|
CRMSEF_SYSTEM_STATUS_CODE |
|
STRU |
0 |
0 |
|
|
22 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
23 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
24 |
CONTENT |
|
CRMSEF_SYSTEM_STATUS_CODE_CONT |
|
CHAR |
5 |
0 |
Proxy Data Element (generated) |
|
25 |
NAME |
|
CRMSEF_LEN30_NAME |
|
STRU |
0 |
0 |
|
|
26 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
27 |
LANGUAGE_CODE |
|
CRMSEF_LANGUAGE_CODE |
|
CHAR |
9 |
0 |
Proxy Data Element (Generated) |
|
28 |
CONTENT |
|
CRMSEF_LEN30_NAME_CONTENT |
|
CHAR |
30 |
0 |
Proxy Data Element (generated) |
|
29 |
ACTIVE_INDICATOR |
|
CRMSEF_INDICATOR |
|
CHAR |
5 |
0 |
Indicator is the representation of a situation that has ex |
|
30 |
USER_STATUS |
|
CRMSEF_USER_STATUS |
|
STRU |
0 |
0 |
|
|
31 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
32 |
CODE |
|
CRMSEF_USER_STATUS_CODE |
|
STRU |
0 |
0 |
|
|
33 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
34 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
35 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
36 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
37 |
AGENCY_SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
38 |
AGENCY_ID |
|
CRMSEF_AGENCY_IDENTIFICATION_C |
|
CHAR |
3 |
0 |
An AgencyIdentificationCode is a code representation of th |
|
39 |
CONTENT |
|
CRMSEF_USER_STATUS_CODE_CONTEN |
|
CHAR |
5 |
0 |
Proxy Data Element (generated) |
|
40 |
NAME |
|
CRMSEF_LEN30_NAME |
|
STRU |
0 |
0 |
|
|
41 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
42 |
LANGUAGE_CODE |
|
CRMSEF_LANGUAGE_CODE |
|
CHAR |
9 |
0 |
Proxy Data Element (Generated) |
|
43 |
CONTENT |
|
CRMSEF_LEN30_NAME_CONTENT |
|
CHAR |
30 |
0 |
Proxy Data Element (generated) |
|
44 |
ORDINAL_NUMBER_VALUE |
|
CRMSEF_ORDINAL_NUMBER_VALUE |
|
INT4 |
10 |
0 |
Proxy Data Element (generated) |
|
45 |
ACTIVE_INDICATOR |
|
CRMSEF_INDICATOR |
|
CHAR |
5 |
0 |
Indicator is the representation of a situation that has ex |
|
46 |
SALES_AREA |
|
CRMTPM_CHGRQ_SALES_AREA |
|
STRU |
0 |
0 |
|
|
47 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
48 |
ORGANISATIONAL_CENTRE_ID |
|
CRMSEF_ORGANISATIONAL_CENTRE_I |
|
CHAR |
20 |
0 |
Proxy Data Element (Generated) |
|
49 |
DISTRIBUTION_CHANNEL_CODE |
|
CRMSEF_DISTRIBUTION_CHANNEL_C1 |
|
STRU |
0 |
0 |
|
|
50 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
51 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
52 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
53 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
54 |
AGENCY_SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
55 |
AGENCY_ID |
|
CRMSEF_AGENCY_IDENTIFICATION_C |
|
CHAR |
3 |
0 |
An AgencyIdentificationCode is a code representation of th |
|
56 |
CONTENT |
|
CRMSEF_DISTRIBUTION_CHANNEL_CO |
|
CHAR |
2 |
0 |
Proxy Data Element (Generated) |
|
57 |
DIVISION_CODE |
|
CRMSEF_DIVISION_CODE |
|
STRU |
0 |
0 |
|
|
58 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
59 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
60 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
61 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
62 |
AGENCY_SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
63 |
AGENCY_ID |
|
CRMSEF_AGENCY_IDENTIFICATION_C |
|
CHAR |
3 |
0 |
An AgencyIdentificationCode is a code representation of th |
|
64 |
CONTENT |
|
CRMSEF_DIVISION_CODE_CONTENT |
|
CHAR |
2 |
0 |
Proxy Data Element (Generated) |
|
65 |
EMPLOYEE_RESPONSIBLE_ID |
|
CRMSEF_BUSINESS_PARTNER_INTERN |
|
CHAR |
10 |
0 |
Definite proprietary identifier for a business partner |
|
66 |
TERRITORY_ID |
|
CRMSEF_TERRITORY_ID |
|
STRU |
0 |
0 |
|
|
67 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
68 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
69 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
70 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
71 |
CONTENT |
|
CRMSEF_TERRITORY_ID_CONTENT |
|
CHAR |
30 |
0 |
Proxy Data Element (generated) |
|
72 |
CURRENCY_CODE |
|
CRMSEF_CURRENCY_CODE |
|
CHAR |
3 |
0 |
Proxy Data Element (Generated) |
|
73 |
PLANNING_PROFILE_GROUP_CODE |
|
CRMSEF_PLAN_PROFILE_GROUP_CODE |
|
STRU |
0 |
0 |
|
|
74 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
75 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
76 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
77 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
78 |
CONTENT |
|
CRMSEF_PLANNING_PROFILE_GROUP |
|
CHAR |
4 |
0 |
Proxy Data Element (generated) |
|
79 |
TRADE_PROMOTION_TYPE_CODE |
|
CRMSEF_TPM_TYPE_CODE |
|
STRU |
0 |
0 |
|
|
80 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
81 |
LIST_ID |
|
|
|
CHAR |
60 |
0 |
|
|
82 |
LIST_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
83 |
LIST_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
84 |
CONTENT |
|
CRMSEF_TRADE_PROMOTION_TYPE_CO |
|
CHAR |
4 |
0 |
Proxy Data Element (generated) |
|
85 |
UPLIFT_ACTIVE_INDICATOR |
|
CRMSEF_INDICATOR |
|
CHAR |
5 |
0 |
Indicator is the representation of a situation that has ex |
|
86 |
AGREEMENT_ID |
|
CRMSEF_TRADE_PROMO_AGR_ID |
|
STRU |
0 |
0 |
|
|
87 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
88 |
SCHEME_ID |
|
|
|
CHAR |
60 |
0 |
|
|
89 |
SCHEME_VERSION_ID |
|
|
|
CHAR |
15 |
0 |
|
|
90 |
SCHEME_AGENCY_ID |
|
|
|
CHAR |
60 |
0 |
|
|
91 |
CONTENT |
|
CRMSEF_TRADE_PROMO_AGR_ID_CONT |
|
CHAR |
24 |
0 |
Proxy Data Element (generated) |
|
92 |
PERIOD_TERMS |
|
CRMTPM_CHGRQ_PERIOD_TERM_T |
|
TTYP |
0 |
0 |
|
|
93 |
PLANNING_ACCOUNT |
|
CRMTPM_CHGRQ_PLANNING_ACCOUNT |
|
STRU |
0 |
0 |
|
|
94 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
95 |
CUSTOMER_ID |
|
CRMSEF_BUSINESS_PARTNER_INTERN |
|
CHAR |
10 |
0 |
Definite proprietary identifier for a business partner |
|
96 |
BUSINESS_PARTNER_GROUP_ID |
|
CRMSEF_BUSINESS_PARTNER_GRP_ID |
|
CHAR |
20 |
0 |
Proxy Data Element (generated) |
|
97 |
PLANNING_INFORMATION |
|
CRMTPM_CHGRQ_PLANNING_INFO |
|
STRU |
0 |
0 |
|
|
98 |
CONTROLLER |
|
PRXCTRLTAB |
|
TTYP |
0 |
0 |
|
|
99 |
PLANNING_PRODUCT_BASIS_CODE |
|
CRMSEF_MKTPL_PROD_BASIS_CODE |
|
CHAR |
1 |
0 |
Proxy Data Element (generated) |
|
100 |
CALENDAR_UNIT_CODE |
|
CRMSEF_CALENDAR_UNIT_CODE |
|
CHAR |
3 |
0 |
Proxy Data Element (generated) |
|
101 |
PRODUCT |
|
CRMTPM_CHGRQ_PLAN_INFO_PROD_T |
|
TTYP |
0 |
0 |
|
|
102 |
PRODUCT_CATEGORY |
|
CRMTPM_CHGRQ_PLAN_INFO_PCAT_T |
|
TTYP |
0 |
0 |
|
|
103 |
PRODUCT_GROUP |
|
CRMTPM_CHGRQ_PLAN_INFO_PGRP_T |
|
TTYP |
0 |
0 |
|
|
104 |
PRODUCT_LIST_CTI |
|
CRMSEF_INDICATOR |
|
CHAR |
5 |
0 |
Indicator is the representation of a situation that has ex |
|
105 |
PRODUCT_CATEGORY_LIST_CTI |
|
CRMSEF_INDICATOR |
|
CHAR |
5 |
0 |
Indicator is the representation of a situation that has ex |
|
106 |
PRODUCT_GROUP_LIST_CTI |
|
CRMSEF_INDICATOR |
|
CHAR |
5 |
0 |
Indicator is the representation of a situation that has ex |
|
107 |
TRADE_SPEND |
|
CRMTPM_CHGRQ_TRADE_SPEND_T |
|
TTYP |
0 |
0 |
|
|
108 |
PARTY |
|
CRMTPM_CHGRQ_PARTY_T |
|
TTYP |
0 |
0 |
|
|
109 |
PERIOD_TERM_LIST_CTI |
|
CRMSEF_INDICATOR |
|
CHAR |
5 |
0 |
Indicator is the representation of a situation that has ex |
|
110 |
TRADE_SPEND_LIST_CTI |
|
CRMSEF_INDICATOR |
|
CHAR |
5 |
0 |
Indicator is the representation of a situation that has ex |
|
111 |
PARTY_LIST_CTI |
|
CRMSEF_INDICATOR |
|
CHAR |
5 |
0 |
Indicator is the representation of a situation that has ex |
|