| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP15: Property Management |
1 | F15011 | Billings Generation Control Master | 2 | NK | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
2 | F15011B | OW BIllings Generation Control Master | 2 | NK | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
3 | F15012 | Tenant E.P. Class Master | 49 | NS | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
4 | F15012B | Tenant E.P. Class Master | 55 | NS | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
5 | F15013 | Sales Overage Master | 67 | NO | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
6 | F15013B | Sales Overage Master File | 13 | NO | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
7 | F15014 | Product Scales Master | 25 | NP | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
8 | F15014B | Product Scales Master | 10 | NP | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
9 | F15015 | Minimum rent/recoveries Master | 22 | NQ | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
10 | F15015B | Min/Max Rents And Recoveries Master | 7 | NQ | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
11 | F15016 | Tenant Escalation Master | 47 | NU | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
12 | F15016B | Tenant Escalation Master | 49 | NU | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
13 | F1502 | Recurring Billings Master | 42 | NF | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
14 | F15020 | Extended Billings Master File | 2 | NN | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
15 | F1502B | Recurring Billings Master | 42 | NF | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
16 | F1502WB | Estimated EP Recurring Billing Work File (OneWorld) | 44 | N4 | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
17 | F1505 | Management Fee Master | 3 | ND | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
18 | F1505B | Management Fee Master | 4 | ND | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
19 | F1505H | Revenue Fee Generation History | 2 | OK | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
20 | F1505HB | Revenue Fee Generation History | 2 | OK | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
21 | F1511 | Tenant/Lease Billings Detail | 38 | NJ | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
22 | F1511B | Tenant/Lease Billings Detail Master | 38 | NJ | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
23 | F1511H | Tenant/Lease Billings Detail History | 38 | N# | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
24 | F1511HB | Tenant/Lease Billings Detail History | 38 | NC | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
25 | F1525 | A/R Fee Interest | 26 | N0 | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
26 | F1525B | A/R Fee and Interest | 27 | NM | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
27 | F1538 | WF - Expence Participation Register | 54 | NZ | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
28 | F1538B | EP Billing Register Work File | 55 | NZ | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
29 | F1548 | Escalation Billing Register | 49 | N1 | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
30 | F1548B | Escalation Billing Register | 50 | N1 | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
31 | F1565 | Security Deposit Master | 18 | JF | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
TOP15L: Adv Real Estate Forecasting |
32 | F15L302 | AREF Prior Gross Billings | 8 | PG | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
TOP48S: Service Billing |
33 | F4812 | Billing Detail Workfile | 70 | WD | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
34 | F4812G | Retro Adjustment Workfile | 1 | WD | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
35 | F4812H | Billing Workfile - History | 70 | WD | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
36 | F4812HS | Billing Workfile History Purged Save | 70 | WD | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
37 | F48S411 | CSB Pay When Paid Table | 1 | BZ | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
38 | F48S910 | Billing Detail Journal File | 68 | W2 | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
39 | F48S912 | G/L Link File | 12 | W6 | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
40 | F48SUI01 | Billing Detail Print Workfile | 70 | WD | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
TOP52: Contract Billing |
41 | F5280W | Contract Revenue Summary Work File | 18 | GY | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
TOP74U: United Kingdom Localizations |
42 | F74U012T | Tenant EP Class Tag - 15 | 3 | PJ | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
43 | F74U0205 | Payment Profile - 15 | 25 | P8 | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |
44 | F74U02BT | Recurring Billing Tag - 15 | 8 | P6 | BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 |