| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F15019 | Billing Frequency Master | 1 | NL | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
TOP15: Property Management |
2 | F15012 | Tenant E.P. Class Master | 23 | NS | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
3 | F15012B | Tenant E.P. Class Master | 24 | NS | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
4 | F15013 | Sales Overage Master | 19 | NO | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
5 | F15013B | Sales Overage Master File | 15 | NO | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
6 | F15015 | Minimum rent/recoveries Master | 26 | NQ | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
7 | F15015B | Min/Max Rents And Recoveries Master | 26 | NQ | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
8 | F15016 | Tenant Escalation Master | 38 | NU | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
9 | F15016B | Tenant Escalation Master | 39 | NU | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
10 | F15019D | Billing Frequency - Alternate Description | 1 | NL | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
11 | F1502 | Recurring Billings Master | 11 | NF | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
12 | F15020 | Extended Billings Master File | 3 | NN | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
13 | F1502B | Recurring Billings Master | 11 | NF | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
14 | F1502WB | Estimated EP Recurring Billing Work File (OneWorld) | 13 | N4 | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
15 | F1505 | Management Fee Master | 24 | ND | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
16 | F1505B | Management Fee Master | 28 | ND | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
17 | F1548 | Escalation Billing Register | 46 | N1 | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
18 | F1548B | Escalation Billing Register | 47 | N1 | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |
TOP17: Customer Service Management |
19 | F1721 | Contract Detail | 56 | CD | BLFC | Billing Frequency Code | Character | UDC | 1 | 0 |