| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP15L: Adv Real Estate Forecasting |
1 | F15L301 | AREF Projected Sales | 10 | PS | AN8 | Address Number | Numeric | UDC | 8 | 0 |
TOP75A: Australia - Reporting System Only |
2 | F75A0220 | Payment Summary Workfile | 3 | PS | AN8 | Address Number | Numeric | UDC | 8 | 0 |
TOP89: Conversion Programs |
3 | F89CA020 | Lookup Table for CRM and EOne Person Ids | 1 | PS | PSAN8 | Person Address Number | Numeric | Generic Edit | 8 | 0 |
TOP90CA: CRM Foundation |
4 | F90CA020 | Person Table | 1 | TT | PSAN8 | Person Address Number | Numeric | Generic Edit | 8 | 0 |
5 | F90CA02A | Person_Notification Table | 2 | TA | PSAN8 | Person Address Number | Numeric | Generic Edit | 8 | 0 |
6 | F90CA07A | Contact_Event Table | 1 | CA | PSAN8 | Person Address Number | Numeric | Generic Edit | 8 | 0 |
7 | F90CA07B | Contact_Profile Table | 3 | CB | PSAN8 | Person Address Number | Numeric | Generic Edit | 8 | 0 |
8 | F90CA10C | Item_Hierarchy_Employee Table | 2 | IE | PSAN8 | Person Address Number | Numeric | Generic Edit | 8 | 0 |