1 |
OBJECT_ID |
|
CRMT_OBJECT_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
2 |
PROSPECT |
|
CRMT_PROSPECT |
BU_PARTNER |
CHAR |
10 |
0 |
Prospect |
* |
3 |
DESCRIPTION_UC |
|
CRMT_PROCESS_DESCRIPTION_UC |
CRM_PROCESS_DESCRIPTION_UC |
CHAR |
40 |
0 |
Transaction Description (Upper Case) |
|
4 |
CURR_PHASE |
|
CRMT_CURR_PHASE |
CRM_PHASE |
CHAR |
3 |
0 |
Sales Stage |
* |
5 |
STATUS_COMMON |
|
CRMT_STATUS_COMMON |
|
CHAR |
13 |
0 |
General Status (User, System, Area) |
|
6 |
STATUS_AREA |
|
CRMT_STATUS_AREA_OIC |
CRM_STATUS_AREA_OIC |
CHAR |
13 |
0 |
Status Area (All, Completed, Not Completed) |
|
7 |
EMPLOYEE_RESP |
|
CRMT_PERSON_RESP |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible |
* |
8 |
COMPETITOR |
|
CRMT_BP_COMPETITOR |
CRM_PARTNER_NUMBER |
CHAR |
20 |
0 |
Competitor |
|
9 |
SALES_TEAM_MEMBER |
|
CRMT_BP_SLS_TEAM_MEMBER |
CRM_PARTNER_NUMBER |
CHAR |
20 |
0 |
Sales Team Member |
|
10 |
PRODUCT_ID |
|
CRMT_PRODUCT_ID |
CRM_ORDERED_PROD |
CHAR |
54 |
0 |
Product ID |
|
11 |
OPP_TYPE |
|
CRMT_OPPORT_TYPE |
CRM_OPPORT_TYPE |
CHAR |
4 |
0 |
Opportunity Type |
* |
12 |
OPP_SOURCE |
|
CRMT_SOURCE |
CRM_SOURCE |
CHAR |
3 |
0 |
Origin of Opportunity/Lead |
* |
13 |
IMPORTANCE |
|
CRMT_IMPORTANCE |
CRM_IMPORTANCE |
CHAR |
1 |
0 |
Opportunity/Lead Priority |
* |
14 |
CHANNEL_PARTNER |
|
CRMT_UIU_SALES_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Sales Partner ID |
* |
15 |
RESP_CHAN_PARTNER |
|
CRMT_RESP_AT_CHANNEL_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Responsible at Channel Partner |
* |
16 |
PROCESS_TYPE |
|
CRMT_PROCESS_TYPE |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
* |
17 |
CAMPAIGN_ID |
|
CGPL_EXTID |
CGPL_EXTID |
CHAR |
24 |
0 |
Project Planning: External Indentifier of an Element |
|
18 |
CAMPAIGN_DES |
|
CRMT_DESCRIPTION |
TEXT40 |
CHAR |
40 |
0 |
Description |
|
19 |
COMPETITOR_NAME |
|
CRMT_DESCRIPTION |
TEXT40 |
CHAR |
40 |
0 |
Description |
|
20 |
PROSPECT_NAME |
|
CRMT_DESCRIPTION |
TEXT40 |
CHAR |
40 |
0 |
Description |
|
21 |
SALESTEAM_FIRSTNAME |
|
BU_NAMEP_F |
BU_NAME |
CHAR |
40 |
0 |
First name of business partner (person) |
|
22 |
SALESTEAM_LASTNAME |
|
BU_NAMEP_L |
BU_NAME |
CHAR |
40 |
0 |
Last name of business partner (person) |
|
23 |
RESPONS_AREA |
|
CRMT_RESPONS_AREA_OIC |
CRM_RESPONS_AREA_OIC |
CHAR |
1 |
0 |
Belonging To (Me, My Department, My Group) |
|
24 |
LEAD_ID |
|
CRMT_OBJECT_ID_DB |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
25 |
LEAD_DES |
|
CRMT_DESCRIPTION |
TEXT40 |
CHAR |
40 |
0 |
Description |
|
26 |
VALID_FROM |
|
CRMT_DATES_START_DATE |
DATUM |
DATS |
8 |
0 |
Start Date |
|
27 |
CONTACT_PERSON |
|
CRMT_UIU_CONTACT_PARTY |
CRM_PARTNER_NUMBER |
CHAR |
20 |
0 |
Contact |
|
28 |
END_DATE_RANGE |
|
CRMT_EXPECT_END |
DATUM |
DATS |
8 |
0 |
Expected Closing Date |
|
29 |
TIMEFRAME |
|
CRMT_UIU_TIMEFRAME |
CHAR40 |
CHAR |
40 |
0 |
Timeframe (End Date Range) |
|
30 |
CHANNEL_PARTNER_NAME |
|
CRMT_UIU_SALES_PARTNER_NAME |
CHAR40 |
CHAR |
40 |
0 |
Sales Partner Name |
|
31 |
RESP_CHAN_PARTNER_FIRSTNAME |
|
CRMT_UIU_RESP_AT_CHAN_PART_FN |
CHAR40 |
CHAR |
40 |
0 |
Employee Resp. at Channel Partner First Name |
|
32 |
RESP_CHAN_PARTNER_LASTNAME |
|
CRMT_UIU_RESP_AT_CHAN_PART_LN |
CHAR40 |
CHAR |
40 |
0 |
Employee Resp. at Channel Partner Last Name |
|
33 |
EMPLOYEE_RESP_LASTNAME |
|
CRMT_UIU_EMPLOYEE_RESP_LASTNA |
CHAR40 |
CHAR |
40 |
0 |
Employee Responsible Last Name |
|
34 |
EMPLOYEE_RESP_FIRSTNAME |
|
CRMT_UIU_EMPLOYEE_RESP_FIRSTNA |
CHAR40 |
CHAR |
40 |
0 |
Employee Responsible First Name |
|
35 |
CONTACT_FIRSTNAME |
|
CRMT_UIU_CONTACT_FIRSTNAME |
CHAR40 |
CHAR |
40 |
0 |
Contact First Name |
|
36 |
CONTACT_LASTNAME |
|
CRMT_UIU_CONTACT_LASTNAME |
CHAR40 |
CHAR |
40 |
0 |
Contact Last Name |
|
37 |
PRODUCT_NAME |
|
CRMT_UIU_PRODUCT_NAME |
CHAR40 |
CHAR |
40 |
0 |
Product Name |
|
38 |
DESCR_OPP_UC |
|
CRMT_DESCRIPTION_OPP_UC |
TEXT40 |
CHAR |
40 |
0 |
Opportunity Description in UC |
|
39 |
PARTNER_FCT |
|
CRMT_PARTNER_FCT |
COM_PARTNER_FCT |
CHAR |
8 |
0 |
Partner Function |
|
40 |
BU_PARTNER |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
41 |
OEM_END_CUST |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
42 |
OEM_PROJECT_OWNER |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
43 |
OEM_PURCHASE_CONT |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
44 |
ASSEMBLY_OWNER |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
45 |
DESIGN_HOUSE |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
46 |
OEM_DESIGN_IN_LOC |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
47 |
PROJECT_OWNER |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
48 |
DISTRIBUTOR |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
49 |
DISTR_LOC |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
50 |
APPROVER |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
51 |
VALIDATOR |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
52 |
OWNER |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
53 |
FIELD_APPL_ENGINEER |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
54 |
CATEGORY_ID |
|
CRMT_PROD_HIERARCHY |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Product Category |
|
55 |
PARTNER_COMB |
|
CRMT_UIU_PARTNER_TO_PARTNERFCT |
CHAR40 |
CHAR |
40 |
0 |
Partner In Partner Function |
|
56 |
TERR_ID |
|
CRMT_TERRITORY_ID |
CRM_TERRITORY_ID |
CHAR |
30 |
0 |
Territory ID |
|
57 |
TERR_DESCRIPTION |
|
CRMT_TERRITORY_DESCRIPTION |
TEXT40 |
CHAR |
40 |
0 |
Territory Description |
|
58 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
59 |
SALES_OFFICE |
|
CRMT_SALES_OFFICE |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Office |
|
60 |
SALES_GROUP |
|
CRMT_SALES_GROUP |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Group |
|
61 |
DIS_CHANNEL |
|
CRMT_DISTRIBUTION_CHANNEL |
CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
* |
62 |
DIVISION |
|
CRMT_DIVISION |
CRM_DIVISION |
CHAR |
2 |
0 |
Division |
* |
63 |
.INCLUDE |
|
|
|
|
0 |
0 |
EEW Include |
|
64 |
EEW_BUS2000111_SEARCH_DUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
65 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
66 |
PRODUCT_KIND_SEL |
|
CRMT_PRODUCT_LOC_2 |
CRM_PRODUCT_LOC_2 |
CHAR |
2 |
0 |
Product/Product Selection for Locator/OIC (Product/IObject) |
|
67 |
PROD_HIERARCHY |
|
CRMT_PROD_HIERARCHY |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Product Category |
|
68 |
INCL_SUB_TERR |
|
CRMT_SUB_TERR_IND |
CRM_SUB_TERR_IND |
CHAR |
1 |
0 |
Indicator: Include Subterritories in Territory Search |
|
69 |
CREATED_BY |
|
CRMT_CREATED_BY |
UNAME |
CHAR |
12 |
0 |
User that Created the Transaction |
|