| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP03: Accounts Receivable |
1 | F03012 | Customer Master by Line of Business | 204 | AI | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
2 | F03012Z1 | Customer Master LOB-Batch File | 219 | VO | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
TOP90CA: CRM Foundation |
3 | F90CA140 | Territory Table | 1 | TY | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
4 | F90CA141 | Territory and Subordinates | 2 | TS | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
5 | F90CA142 | Territory Recursive Children Temp Table | 1 | TY | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
6 | F90CA14A | Territory Employee Table | 1 | TE | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
7 | F90CA14B | Territory Country Table | 1 | TB | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
8 | F90CA14C | Territory State Table | 1 | TC | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
9 | F90CA14D | Territory Zip Code Table | 1 | TD | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
10 | F90CA14E | Territory City Table | 1 | TE | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |
11 | F90CA180 | Territory Alignment Table | 2 | TA | TERRID | Territory Id | Numeric | Generic Edit | 15 | 0 |