| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP01: Address Book |
1 | F01301 | Activity Master | 46 | AM | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
2 | F01301D | Activity Detail | 47 | AD | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
3 | F01301W | Mobile Client Deleted Activities | 47 | AW | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
4 | F01311 | Centralized Calendar Master | 30 | CC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
5 | F01321 | Recurrence Master | 13 | RM | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
6 | F01331 | Recurrence Exclusion | 9 | RE | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
7 | F01401 | Action Plan | 12 | AP | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
8 | F01411 | Action Plan Activity | 17 | AC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
TOP42: Sales Management |
9 | F42140 | Customer Master Commission Information | 18 | CM | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
TOP90CA: CRM Foundation |
10 | F4107 | Item Feature Table | 24 | IF | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
11 | F90CA000 | CRM_Constants Table | 13 | CO | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
12 | F90CA001 | F0101 Used Address Book Number Table | 3 | UA | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
13 | F90CA020 | Person Table | 12 | TT | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
14 | F90CA040 | Employee Table | 11 | EE | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
15 | F90CA041 | Employee and Subordinates | 5 | ES | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
16 | F90CA042 | Flat Employee Hierarchy | 4 | EM | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
17 | F90CA050 | Partner Table | 8 | PP | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
18 | F90CA05A | Partner_Employee Table | 6 | PA | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
19 | F90CA060 | Competitor Table | 28 | RC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
20 | F90CA06A | Competitor_KillSheet Table | 29 | RA | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
21 | F90CA070 | Contact Table | 11 | CT | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
22 | F90CA080 | Customer Table | 6 | UU | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
23 | F90CA086 | Flat Customer Related Address Table | 4 | CR | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
24 | F90CA08A | Customer_Employee Table | 5 | UA | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
25 | F90CA100 | CRM Item Table | 5 | IT | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
26 | F90CA10A | Item_Hierarchy Table | 7 | IH | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
27 | F90CA10C | Item_Hierarchy_Employee Table | 5 | IE | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
28 | F90CA120 | Industry Grouping Table | 6 | IG | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
29 | F90CA121 | Industry Grouping Recursive Children Temp Table | 9 | IG | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
30 | F90CA12A | Industry Grouping Industry | 26 | IA | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
31 | F90CA12B | Industry Grouping Employee Table | 13 | IB | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
32 | F90CA130 | Industry Buying Issues | 27 | BI | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
33 | F90CA140 | Territory Table | 7 | TY | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
34 | F90CA142 | Territory Recursive Children Temp Table | 9 | TY | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
35 | F90CA14A | Territory Employee Table | 14 | TE | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
36 | F90CA14B | Territory Country Table | 11 | TB | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
37 | F90CA14C | Territory State Table | 12 | TC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
38 | F90CA14D | Territory Zip Code Table | 13 | TD | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
39 | F90CA14E | Territory City Table | 14 | TE | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
40 | F90CA180 | Territory Alignment Table | 4 | TA | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
41 | F90CA18B | Industry Grouping Alignment Table | 4 | IG | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
42 | F90CA18C | Sales Team Alignment Table | 3 | ST | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
43 | F90CA31 | Activity Extension Table | 39 | EX | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
44 | F90CA31H | Activity Employee Extension Table | 22 | EX | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
45 | F90CA500 | E-MAIL Table | 8 | EM | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
46 | F90CA50A | MEMBER Table | 6 | ME | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
47 | F90CA50B | MEMBER PERSON Table | 6 | ME | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
48 | F90CA50C | MEMBER EMAIL GROUP Table | 3 | ME | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
49 | F90CA50D | EMAIL CONTACT Table | 5 | EM | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
50 | F90CA510 | E-MAIL GROUP Table | 8 | EG | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
51 | F90CA60E | Activity Lead Associative Table (FOR CRM UPGRADE) | 5 | AC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
52 | F90CA61E | Activity Opportunity Associative Table (FOR CRM UPGRADE) | 5 | AC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
53 | F90CA62E | Activity Contact Associative Table (FOR CRM UPGRADE) | 6 | AC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
54 | F90CA65 | Call Plan Table | 13 | EX | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
55 | F90CA900 | Address_Extension Table | 6 | AE | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
TOP90CB: CRM Sales Force Automation |
56 | F90CB010 | Lead Table | 30 | LD | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
57 | F90CB020 | Opportunity Table | 31 | OT | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
58 | F90CB02D | Opportunity_Contact Table | 7 | OD | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
59 | F90CB02E | Opportunity_Employee Table | 10 | OE | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
60 | F90CB02I | Opportunity_Item Table | 28 | OI | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
61 | F90CB02J | Opportunity_Sales_Cycle Table | 6 | OJ | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
62 | F90CB02M | Cost Table | 14 | OM | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
63 | F90CB030 | CRM Address Table (Lead related information) | 14 | AD | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
64 | F90CB040 | Qualification Table | 21 | QL | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
65 | F90CB041 | Qualification_Answer Table | 6 | QA | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
66 | F90CB042 | Qualification_Question Table | 22 | QQ | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
67 | F90CB043 | Qualification_Object Table | 14 | QO | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
68 | F90CB050 | Sales_Methodology Table | 5 | SM | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
69 | F90CB05A | Sales_Cycle Table | 13 | OP | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
70 | F90CB05B | Sale_Driver Table | 10 | ON | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
71 | F90CB060 | Forecast | 16 | FC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
72 | F90CB06B | Opportunity_For_Forecast Table | 31 | OF | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
73 | F90CB06C | Opportunity_Item_For_Forecast Table | 30 | OH | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
74 | F90CB06Z | Opportunity for Forecast WTF | 32 | ZF | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
TOP90CC: CRM Marketing Automation |
75 | F90CC01C | Campaign Event Address table | 18 | CA | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
76 | F90CC040 | Campaign table | 19 | CM | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
TOP90CE: CRM Solution Advisor |
77 | F90CE01 | Solution Table | 15 | ST | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
78 | F90CE01A | Solution/ Work Order Intersection | 4 | WO | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
79 | F90CE01B | Solution/ Case Intersection | 5 | SC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
80 | F90CE01D | Solution/ Item Intersection | 5 | SP | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
81 | F90CE02 | Library | 8 | LI | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
82 | F90CE999 | Test Audit Table | 3 | AU | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |
TOP90CG: CRM Case Management |
83 | F90CG507 | Case/ Workflow Intersection | 6 | CC | EDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 |