| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | A634 | Camp. ID/Material | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
2 | A635 | Camp. ID/PH1/PH2/PH3 | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
3 | A636 | Camp. ID/Matl grp 1 | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
4 | A637 | Camp. ID | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
5 | A651 | Camp. ID/Material | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
6 | A652 | Camp. ID/PH1/PH2/PH3 | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
7 | A653 | Camp. ID/Matl grp 1 | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
8 | A925 | Camp. ID/Shpg Cond. | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
9 | A999 | Camp. ID/Sales org./Distr. Chl/Division/Material | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
TOPBasic Functions |
10 | KOND3 | Conditions: Campaign Determination - Data Part | 3 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
TOPConditions |
11 | A172 | Campaign ID/Material | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
12 | A521 | Campaign/Material | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
13 | A523 | Camp. ID/Matl grp 1 | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
14 | A524 | Camp. ID/Customer/Material | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
15 | A525 | Camp. ID/Customer/Matl grp 1 | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
16 | CMPB_MAP | Conversion Table CAIMPAIGN CRM <> CMPGN_ID | 3 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
17 | KOTE017 | Campaign ID/Customer/Material | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
18 | KOTE522 | Camp. ID/Customer/Material | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
19 | KOTE523 | Camp. ID/Customer/Matl grp 1 | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
20 | KOTE524 | Camp. ID/Customer/Matl grp 1 | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
21 | KOTN017 | Campaign ID/Material | 4 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |
TOPRebate Agreements |
22 | AGR_REL_KNUMA_CM | Assignment: Agreement --> Campaign | 3 | CMPGN_ID | Campaign ID | nvarchar | 10 | 0 | | |