D&B Marketing Details - Customers
D&B Marketing Details - Customers
Technical name: 0DB_MC01_Q0010
Based on InfoCube:
D&B Marketing Universe (0DB_MC01)Use
For further information on this query, refer to the query
D&B Marketing Details – All Businesses.Filter
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DB_MAKTCO = 1 |
Marketability Code |
|
0DBCUSTAT = customer |
Indicator of Current Customer Status |
|
0DBREGCOD |
Region Code |
|
0DBAREACOD |
Area Code |
|
0DBDISTRCOD |
District Code |
Free Characteristics
|
InfoObject |
Description |
|
0DBGUDUNS |
Global Ultimate D-U-N-S |
|
0DBEMPBND |
Employee Band |
|
0DBSALBND |
Annual Turnover Band |
|
0DBYRSBND |
Year Started Band |
|
0DBLGLSTAT |
Legal Status |
|
0DBSECTCOD |
Sector Code |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DBDUNS_NUM |
D-U-N-S |
|
0DBCTYNAM |
City Name |
|
0DBCTRYCOD |
Country Code |
|
0DB87SIC1 |
US 1987 SIC Code |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DB_MC01_RK0001 |
Revenue |
|
0DB_MC01_RK005 |
Annual Turnover (000’s) |
|
0DB_MC01_RK004 |
Number of Employees |
|
0DB_MC01_RK002 |
Number of Customers |
Report Report Interface Targets
|
Query |
Description of the Query |
|
RSCRMBW_TG_GENERATE_DB |
Target Group Selection |