| 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 | 34 | AI | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
2 | F03012Z1 | Customer Master LOB-Batch File | 47 | VO | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B11 | Customer Ledger | 137 | RP | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
4 | F03B11P | Customer Ledger Purge File | 137 | RP | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
5 | F03B11Z1 | Invoice Transactions - Batch File | 187 | VJ | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
6 | F03B11Z2 | F03B11 Interoperability Table | 151 | SY | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
7 | F03B15 | Credit and Cash Management | 7 | RT | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
8 | F03B16 | A/R Statistical History | 40 | RV | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
9 | F03B16S | A/R Statistical Summary | 42 | RS | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
10 | F03B20 | A/R Notification History | 39 | ZR | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
11 | F03B22 | A/R Fee Journal History | 25 | RS | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
TOP15: Property Management |
12 | F15525W | PM Statements Credit/Cash Build Workfile | 3 | RT | CLMG | Collection Manager | String | Generic Edit | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.