| 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 | 15 | AI | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
2 | F03012Z1 | Customer Master LOB-Batch Table | 28 | VO | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
TOP15: Real Estate Management |
3 | F1501 | Tenant/Lease Master | 19 | NE | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
4 | F15012 | Tenant E.P. Class Master | 44 | NS | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
5 | F15012B | Tenant E.P. Class Master | 49 | NS | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
6 | F15013 | Sales Overage Master | 43 | NO | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
7 | F15013B | Sales Overage Master File | 35 | NO | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
8 | F15016 | Tenant Escalation Master | 42 | NU | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
9 | F15016B | Tenant Escalation Master | 43 | NU | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
10 | F1501B | Lease Master Header | 19 | NE | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
11 | F1502 | Recurring Billings Master | 30 | NF | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
12 | F1502B | Recurring Billings Master | 30 | NF | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
13 | F1502WB | Estimated EP Recurring Billings | 32 | N4 | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
14 | F1538 | WF - Expence Participation Register | 59 | NZ | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
15 | F1538B | EP Billing Register | 61 | NZ | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
TOP42: Sales Management |
16 | F42UI01 | SO Header Cache File (MBF) | 122 | ZH | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |
TOP48S: Service Billing |
17 | F48128 | G/L Offset and Retainage Information | 3 | WI | TRAR | Payment Terms - A/R | String | Generic Edit | 3 | 0 |