| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F1501 | Tenant/Lease Master | 7 | NE | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
TOP03: Accounts Receivable |
2 | F0311 | Accounts Receivable Ledger | 20 | RP | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B11 | Customer Ledger | 18 | RP | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
4 | F03B11P | Customer Ledger Purge File | 18 | RP | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
5 | F03B11Z1 | Invoice Transactions - Batch File | 36 | VJ | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
6 | F03B11Z2 | F03B11 Interoperability Table | 31 | SY | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
7 | F03B575 | Auto Debit Invoice Select and Build | 21 | RD | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
TOP15: Property Management |
8 | F15012 | Tenant E.P. Class Master | 43 | NS | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
9 | F15012B | Tenant E.P. Class Master | 47 | NS | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
10 | F15013 | Sales Overage Master | 4 | NO | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
11 | F15013B | Sales Overage Master File | 14 | NO | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
12 | F15016 | Tenant Escalation Master | 39 | NU | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
13 | F15016B | Tenant Escalation Master | 40 | NU | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
14 | F1501B | Lease Master Header File | 9 | NE | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
15 | F1502 | Recurring Billings Master | 27 | NF | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
16 | F1502B | Recurring Billings Master | 27 | NF | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
17 | F1502WB | Estimated EP Recurring Billing Work File (OneWorld) | 29 | N4 | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
18 | F1511 | Tenant/Lease Billings Detail | 10 | NJ | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
19 | F1511B | Tenant/Lease Billings Detail Master | 10 | NJ | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
20 | F1511H | Tenant/Lease Billings Detail History | 10 | N# | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
21 | F1511HB | Tenant/Lease Billings Detail History | 10 | NC | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
22 | F1513 | FASB 13 Lease Control File | 10 | O3 | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
23 | F1513B | FASB 13 Lease Control File | 10 | O3 | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
24 | F1538 | WF - Expence Participation Register | 3 | NZ | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
25 | F1538B | EP Billing Register Work File | 3 | NZ | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
26 | F1548 | Escalation Billing Register | 3 | N1 | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
27 | F1548B | Escalation Billing Register | 3 | N1 | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
28 | F1565 | Security Deposit Master | 22 | JF | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
TOP47: Electronic Commerce |
29 | F47041 | EDI Invoice Header - Inbound | 29 | SY | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
TOP48S: Service Billing |
30 | F4822 | Invoice Summary Work File | 15 | W4 | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
31 | F4823 | Voucher Summary | 13 | W0 | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
TOP74: EMEA Localization |
32 | F74900 | Foreign Receivables and Payables - EMEA | 24 | RP | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
TOP76A: Argentina |
33 | F76A0110 | UTE Members - 76A | 2 | U1 | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
34 | F76A09 | Invoice Total - ARG - 00 - 00 | 18 | TT | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
35 | F76A09P | Invoice Total Purge - ARG - 03B - 76A | 18 | TT | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
36 | F76A401 | UTE Members Type - ARG - 04 | 3 | UT | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
TOP76B: Brazil - Reporting System Only |
37 | F76B0401 | Tax Code - 04 | 7 | CT | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
38 | F76B0411 | Voucher Additional Information Brazil - 04 | 19 | VB | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
39 | F76B473T | F04573 Brazilian Temp WH File - BR - 04 | 23 | W3 | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |
TOP76C: Colombia |
40 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 18 | RP | AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 |