| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP42B: Sales Order Entry |
1 | F4211UR | F4211 CRM User Reserved Tag File | 19 | UR | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
2 | F4211URZ | F4211Z1 CRM User Reserved Tag File | 28 | UR | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
TOP90CA: CRM Foundation |
3 | F90CA020 | Person Table | 27 | TT | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
4 | F90CA040 | Employee Table | 26 | EE | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
5 | F90CA050 | Partner Table | 24 | PP | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
6 | F90CA070 | Contact Table | 27 | CT | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
7 | F90CA080 | Customer Table | 22 | UU | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
8 | F90CA31 | Activity Extension Table | 20 | EX | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
9 | F90CA31A | Action Plan Extension Table | 16 | EX | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
10 | F90CA31B | Action Plan Activity Extension Table | 17 | EX | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
11 | F90CA31C | Reccurrence Extension Table | 16 | EX | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
12 | F90CA31D | Reccurrence Exclusion Extension Table | 16 | EX | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
TOP90CB: CRM Sales Force Automation |
13 | F90CB010 | Lead Table | 75 | LD | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
14 | F90CB020 | Opportunity Table | 46 | OT | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
15 | F90CB060 | Forecast | 40 | FC | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
16 | F90CB06B | Opportunity_For_Forecast Table | 46 | OF | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
17 | F90CB06Z | Opportunity for Forecast WTF | 47 | ZF | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
TOP90CC: CRM Marketing Automation |
18 | F90CC040 | Campaign table | 35 | CM | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
TOP90CD: CRM Service Management |
19 | F4801UR | F4801 CRM User Reserved Tag File | 30 | UR | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |
TOP90CG: CRM Case Management |
20 | F1755UR | F1755 - CRM User Reserved Tag File | 16 | CA | EXVAR14 | Ext Varchar14 | Variable String | Generic Edit | 25 | 0 |