| # Relation Management - predefined variables in the Text Editor If you use the Text Editor to define the layout of a letter or to create a selection expression, you can use predefined variables. General predefined variables for customers/opportunities/contacts Within order documents, addresses are stripped off empty fields. Such a stripped address is available by using the following fields:
cor.nama | First field of Postal Address
cor.namb | Second field of Postal Address
cor.namc | Third field of Postal Address
cor.namd | Fourth field of Postal Address
cor.name | Fifth field of Postal Address
cor.namf | Sixth field of Postal Address
cor.ccty.dsca | Description of Postal Address Country
del.nama | First field of Delivery Address
del.namb | Second field of Delivery Address
del.namc | Third field of Delivery Address
del.namd | Fourth field of Delivery Address
del.name | Fifth field of Delivery Address
del.namf | Sixth field of Delivery Address
del.ccty.dsca | Description of Delivery Address Country
pad.nama | First field of Private Address
pad.namb | Second field of Private Address
pad.namc | Third field of Private Address
pad.namd | Fourth field of Private Address
pad.name | Fifth field of Private Address
pad.namf | Sixth field of Private Address
pad.ccty.dsca | Description of Private Address Country
Predefined variables for customers
pldd_mcs034.dsca | Description of Price List
pcpr_com010.nama | Name of Parent Customer for Prices/Discounts
pctx_com010.nama | Name of Parent Customer for Texts
pctf_com010.nama | Name of Parent Customer for Finance
ccus_com010.nama | Name of Parent Customer for Statistics Update
iscn_com000.nama | Name 1 of Affiliated Company
iscn_com000.namb | Name 2 of Affiliated Company
iscn_com000.namc | Address 1 of Affiliated Company
iscn_com000.namd | Address 2 of Affiliated Company
iscn_com000.name | City 1 of Affiliated Company
iscn_com000.namf | City 2 of Affiliated Company
iscn_com000.pstc | ZIP Code of Affiliated Company
Predefined variables for opportunities
mprj_com001.nama | Name of Sales Representative
mprj_com012.nama | Name A of Postal Address
mprj_com012.namb | Name B of Postal Address
mprj_com012.namc | Address A of Postal Address
mprj_com012.namd | Address B of Postal Address
mprj_com012.name | City A of Postal Address
mprj_com012.namf | City B of Postal Address
mprj_com012.pstc | ZIP Code of Postal Address
Predefined variables for contacts
cper_smi006.dsca | Description of Attention
cper_mcs046.dsca | Description of Language
cper_mcs019.dsca | Description of Title
wadr_com012.nama | Name A of Work Address
wadr_com012.namb | Name B of Work Address
wadr_com012.namc | Address A of Work Address
wadr_com012.namd | Address B of Work Address
wadr_com012.name | City A of Work Address
wadr_com012.namf | City B of Work Address
wadr_com012.pstc | ZIP Code of Work Address
padr_com012.nama | Name A of Private Address
padr_com012.namb | Name B of Private Address
padr_com012.namc | Address A of Private Address
padr_com012.namd | Address B of Private Address
padr_com012.name | City A of Private Address
padr_com012.namf | City B of Private Address
padr_com012.pstc | ZIP Code of Private Address
Predefined variables for activities and activity history
acti_smi002.dsca | Description of Source
acti_smi003.dsca | Description of Phase
acti_smi004.dsca | Description of Jobtitle
acti_smi006.dsca | Description of Attention
empl_com001.nama | Name of Employee
crep_com001.nama | Name of Sales Representative
Predefined variable for selection expressions
bp.turnover.previous.year | The turnover from the Invoice-to Business Partner Balances (tccom4513s000) session. This value represents last year's turnover for all departments that belong to the financial company of: The sales office that is linked to the business partner. The current logistic company if this company is also a financial company and no sales office is linked to the business partner.
Example bp.turnover.previous.year < 15000.00 and bp.turnover.previous.year > 0.0 Based on the selection expression, business partners that match the turnover criteria can be retrieved in the Mail Merge by Standard Letter (tdsmi2410m000) and Flexible Printing (tdsmi2410m100) sessions. You can, for example, send a letter to all business partners with a turnover value below 15000 and above 0. The following limitations apply to the turnover: The turnover value of only one financial company is calculated. Turnover of multiple financial companies are not totalized. For a business partner, only one record can be retrieved from the Invoice-to Business Partner Balances (tccom4513s000) session. Related topics Relation Management - Text Editor Overview of Relation Management |