1 |
OBJECT_KEY |
|
CRMT_BSP_OBJECTKEY |
|
CHAR |
100 |
0 |
Object Key |
|
2 |
RECORD_NO |
|
CRMT_MKTLIST_RECORD_NO |
CRM_MKTLIST_RECORD_NO |
INT4 |
10 |
0 |
Record Number |
|
3 |
ORG_TITLE_KEY |
|
AD_TITLE |
AD_TITLE |
CHAR |
4 |
0 |
Form-of-Address Key |
* |
4 |
ORG_NAME1 |
|
BU_NAMEOR1 |
BU_NAME |
CHAR |
40 |
0 |
Name 1 of organization |
|
5 |
ORG_NAME2 |
|
BU_NAMEOR2 |
BU_NAME |
CHAR |
40 |
0 |
Name 2 of organization |
|
6 |
ORG_NAME3 |
|
BU_NAMEOR3 |
BU_NAME |
CHAR |
40 |
0 |
Name 3 of organization |
|
7 |
ORG_LEGALFORM |
|
BU_LEGENTY |
BU_LEGENTY |
CHAR |
2 |
0 |
BP: Legal form of organization |
* |
8 |
ORG_FOUND_DATE |
|
BU_FOUND_DAT |
DATUM |
DATS |
8 |
0 |
Date organization founded |
|
9 |
ORG_TELEPHONE |
|
AD_TLNMBR |
CHAR30 |
CHAR |
30 |
0 |
Telephone no.: dialling code+number |
|
10 |
ORG_TEL_EXT |
|
AD_TLXTNS |
CHAR10 |
CHAR |
10 |
0 |
Telephone no.: Extension |
|
11 |
ORG_FAX |
|
AD_FXNMBR |
CHAR30 |
CHAR |
30 |
0 |
Fax number: dialling code+number |
|
12 |
ORG_FAX_EXT |
|
AD_FXXTNS |
CHAR10 |
CHAR |
10 |
0 |
Fax no.: Extension |
|
13 |
ORG_URI |
|
AD_URISCR |
AD_URISCR |
CHAR |
132 |
0 |
URI, e.g. Homepage or ftp Address |
|
14 |
ORG_LANGUAGE |
|
CRMT_MKTLIST_BU_LANG |
LAISO |
CHAR |
2 |
0 |
Business Partner: Language |
|
15 |
ORG_CITY |
|
AD_CITY1 |
TEXT40 |
CHAR |
40 |
0 |
City |
|
16 |
ORG_POSTL_COD1 |
|
AD_PSTCD1 |
CHAR10 |
CHAR |
10 |
0 |
City postal code |
|
17 |
ORG_POSTL_COD2 |
|
AD_PSTCD2 |
CHAR10 |
CHAR |
10 |
0 |
PO Box postal code |
|
18 |
ORG_PO_BOX |
|
AD_POBX |
CHAR10 |
CHAR |
10 |
0 |
PO Box |
|
19 |
ORG_PO_BOX_CIT |
|
AD_POBXLOC |
TEXT40 |
CHAR |
40 |
0 |
PO Box city |
|
20 |
ORG_STREET |
|
AD_STREET |
TEXT60 |
CHAR |
60 |
0 |
Street |
|
21 |
ORG_HOUSE_NO |
|
AD_HSNM1 |
TEXT10 |
CHAR |
10 |
0 |
House Number |
|
22 |
ORG_COUNTRYISO |
|
INTCA |
INTCA |
CHAR |
2 |
0 |
Country ISO code |
|
23 |
ORG_REGION |
|
REGIO |
REGIO |
CHAR |
3 |
0 |
Region (State, Province, County) |
* |
24 |
ORG_ID_NUMBER |
|
BU_ID_NUMBER |
CHAR60 |
CHAR |
60 |
0 |
Identification Number |
|
25 |
PERS_TITLE_KEY |
|
AD_TITLE |
AD_TITLE |
CHAR |
4 |
0 |
Form-of-Address Key |
* |
26 |
PERS_FIRSTNAME |
|
BU_NAMEP_F |
BU_NAME |
CHAR |
40 |
0 |
First name of business partner (person) |
|
27 |
PERS_LASTNAME |
|
BU_NAMEP_L |
BU_NAME |
CHAR |
40 |
0 |
Last name of business partner (person) |
|
28 |
PERS_INITIAL |
|
BU_NAMEMID |
BU_NAME |
CHAR |
40 |
0 |
Middle name or second forename of a person |
|
29 |
PERS_TITLE_ACA1 |
|
AD_TITLE1 |
AD_TITLE1 |
CHAR |
4 |
0 |
Academic Title: Key |
* |
30 |
PERS_BIRTHDATE |
|
BU_BIRTHDT |
DATUM |
DATS |
8 |
0 |
Date of Birth of Business Partner |
|
31 |
PERS_SEX |
|
BU_SEXID |
BU_SEXID |
CHAR |
1 |
0 |
Sex of business partner (person) |
|
32 |
PERS_MARITALSTAT |
|
BU_MARST |
BU_MARST |
CHAR |
1 |
0 |
Marital Status of Business Partner |
* |
33 |
PERS_TELEPHON |
|
AD_TLNMBR |
CHAR30 |
CHAR |
30 |
0 |
Telephone no.: dialling code+number |
|
34 |
PERS_TEL_EXT |
|
AD_TLXTNS |
CHAR10 |
CHAR |
10 |
0 |
Telephone no.: Extension |
|
35 |
PERS_FAX |
|
AD_FXNMBR |
CHAR30 |
CHAR |
30 |
0 |
Fax number: dialling code+number |
|
36 |
PERS_FAX_EXT |
|
AD_FXXTNS |
CHAR10 |
CHAR |
10 |
0 |
Fax no.: Extension |
|
37 |
PERS_E_MAIL |
|
AD_SMTPADR |
AD_SMTPADR |
CHAR |
241 |
0 |
E-Mail Address |
|
38 |
PERS_PAGER |
|
AD_PAGNMBR |
TEXT30 |
CHAR |
30 |
0 |
Pager number |
|
39 |
PERS_LANGUAGE |
|
CRMT_MKTLIST_BU_LANG |
LAISO |
CHAR |
2 |
0 |
Business Partner: Language |
|
40 |
PERS_LANGU_CORR |
|
CRMT_MKTLIST_BU_CORR_LANG |
LAISO |
CHAR |
2 |
0 |
Business Partner: Correspondence Language |
|
41 |
PERS_CITY |
|
AD_CITY1 |
TEXT40 |
CHAR |
40 |
0 |
City |
|
42 |
PERS_POSTL_COD1 |
|
AD_PSTCD1 |
CHAR10 |
CHAR |
10 |
0 |
City postal code |
|
43 |
PERS_POSTL_COD2 |
|
AD_PSTCD2 |
CHAR10 |
CHAR |
10 |
0 |
PO Box postal code |
|
44 |
PERS_PO_BOX |
|
AD_POBX |
CHAR10 |
CHAR |
10 |
0 |
PO Box |
|
45 |
PERS_PO_BOX_CIT |
|
AD_POBXLOC |
TEXT40 |
CHAR |
40 |
0 |
PO Box city |
|
46 |
PERS_STREET |
|
AD_STREET |
TEXT60 |
CHAR |
60 |
0 |
Street |
|
47 |
PERS_HOUSE_NO |
|
AD_HSNM1 |
TEXT10 |
CHAR |
10 |
0 |
House Number |
|
48 |
PERS_COUNTRYISO |
|
INTCA |
INTCA |
CHAR |
2 |
0 |
Country ISO code |
|
49 |
PERS_REGION |
|
REGIO |
REGIO |
CHAR |
3 |
0 |
Region (State, Province, County) |
* |
50 |
PERS_ID_NUMBER |
|
BU_ID_NUMBER |
CHAR60 |
CHAR |
60 |
0 |
Identification Number |
|
51 |
CP_FUNCTIONNAME |
|
BU_FNCTN |
TEXT40 |
CHAR |
40 |
0 |
Function name of partner |
|
52 |
BP_ORG |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
53 |
BP_PER |
|
BU_PARTNER |
BU_PARTNER |
CHAR |
10 |
0 |
Business Partner Number |
* |
54 |
ORG_OBJECT_ID |
|
CRMT_BSP_OBJECTKEY |
|
CHAR |
100 |
0 |
Object Key |
|
55 |
PERS_OBJECT_ID |
|
CRMT_BSP_OBJECTKEY |
|
CHAR |
100 |
0 |
Object Key |
|
56 |
ACT_TEMPLATE_ID |
|
CRMT_MKTLIST_TEMPLATE_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Template ID |
|
57 |
ACT_PROCESS_TYPE |
|
CRMT_PROCESS_TYPE |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
* |
58 |
ACT_DESCRIPTION |
|
CRMT_PROCESS_DESCRIPTION |
CRM_PROCESS_DESCRIPTION |
CHAR |
40 |
0 |
Transaction Description |
|
59 |
ACT_ACTUAL_DATE_FROM |
|
CRMT_MKTLIST_ACTUAL_DATE_FROM |
DATUM |
DATS |
8 |
0 |
Actual Date From |
|
60 |
ACT_ACTUAL_TIME_FROM |
|
CRMT_MKTLIST_ACTUAL_TIME_FROM |
SYTIME |
TIMS |
6 |
0 |
Actual Time From |
|
61 |
ACT_ACTUAL_DATE_TO |
|
CRMT_MKTLIST_ACTUAL_DATE_TO |
DATUM |
DATS |
8 |
0 |
Actual Date To |
|
62 |
ACT_ACTUAL_TIME_TO |
|
CRMT_MKTLIST_ACTUAL_TIME_TO |
SYTIME |
TIMS |
6 |
0 |
Actual Time To |
|
63 |
ACT_USER_STATUS |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
64 |
ACT_PRIORITY |
|
CRMT_PRIORITY |
SC_PRIO |
NUMC |
1 |
0 |
Activity Priority |
* |
65 |
ACT_CATEGORY |
|
CRMT_ACTIVITY_CATEGORY |
CRM_ACTIVITY_CATEGORY |
CHAR |
3 |
0 |
Activity Category (Communication Type) |
* |
66 |
LEA_TEMPLATE_ID |
|
CRMT_MKTLIST_TEMPLATE_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Template ID |
|
67 |
LEA_PROCESS_TYPE |
|
CRMT_PROCESS_TYPE |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
* |
68 |
LEA_DESCRIPTION |
|
CRMT_PROCESS_DESCRIPTION |
CRM_PROCESS_DESCRIPTION |
CHAR |
40 |
0 |
Transaction Description |
|
69 |
LEA_START_DATE |
|
CRMT_MKTLIST_LEAD_START_DATE |
DATUM |
DATS |
8 |
0 |
Start Date of the Lead |
|
70 |
LEA_EXP_END_DATE |
|
CRMT_MKTLIST_LEAD_END_DATE |
DATUM |
DATS |
8 |
0 |
Expected End Date of the Lead |
|
71 |
LEA_USER_STATUS |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
72 |
LEA_LEAD_PRIORITY |
|
CRMT_IMPORTANCE |
CRM_IMPORTANCE |
CHAR |
1 |
0 |
Opportunity/Lead Priority |
* |
73 |
LEA_LEAD_GROUP |
|
CRMT_LEAD_TYPE |
CRM_LEAD_TYPE |
CHAR |
4 |
0 |
Lead Group |
* |
74 |
LEA_MANUAL_QUAL_LEV |
|
CRMT_LEAD_QUAL_LEVEL_MAN |
CRM_LEAD_QUAL_LEVEL |
CHAR |
2 |
0 |
Lead Qualification Level |
* |
75 |
LEA_ORIGIN |
|
CRMT_SOURCE |
CRM_SOURCE |
CHAR |
3 |
0 |
Origin of Opportunity/Lead |
* |
76 |
BCI_PERS_RESP_CODE |
|
CRMT_MKT_ICRH_PRC_CHAR |
CRM_MKT_ICRH_PRC_CHAR |
CHAR |
12 |
0 |
CRM Marketing: ICRH - Personalized Response Code - character |
|
77 |
BCI_COUPON_CODE |
|
CRM_MKTPL_OFRCODE |
CRM_MKTPL_OFRCODE |
CHAR |
16 |
0 |
Coupon Code |
|
78 |
BCI_CAMPAIGN_ELEMENT |
|
CRM_MKTPL_CAMPAIGN_TASKID |
CGPL_EXTID |
CHAR |
24 |
0 |
Campaign Element |
|
79 |
BCI_ORG_NUMBER |
|
CRMT_MKTLIST_ORG_ID |
BU_PARTNER |
CHAR |
10 |
0 |
ID of the Organization |
* |
80 |
BCI_PER_NUMBER |
|
CRMT_MKTLIST_PER_ID |
BU_PARTNER |
CHAR |
10 |
0 |
ID of the Person |
* |
81 |
TRANSACTION_GUID |
|
CRMT_BSP_OBJECTKEY |
|
CHAR |
100 |
0 |
Object Key |
|
82 |
TRANSACTION_ID |
|
CRMT_MKTLIST_TRANSACTION_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Transaction ID |
|
83 |
ORG_CASE_NUMBER |
|
CRMT_MKTLIST_BPORG_CASE_NUMBER |
CRM_MKTLIST_CLRCASE_NUMBER |
CHAR |
10 |
0 |
Organization Cleansing Case Number |
|
84 |
PERS_CASE_NUMMBER |
|
CRMT_MKTLIST_BPPER_CASE_NUMBER |
CRM_MKTLIST_CLRCASE_NUMBER |
CHAR |
10 |
0 |
Person Cleansing Case Number |
|