| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 44 | GL | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP03: Accounts Receivable |
2 | F0311 | Accounts Receivable Ledger | 77 | RP | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP03B: Enhanced Accounts Receivable |
3 | F03B11 | Customer Ledger | 73 | RP | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
4 | F03B112 | Invoice Revisions | 9 | RW | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
5 | F03B112P | Invoice Revisions Purge File | 9 | RW | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
6 | F03B11P | Customer Ledger Purge File | 73 | RP | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
7 | F03B11Z1 | Batch Invoices | 89 | VJ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
8 | F03B11Z2 | F03B11 Interoperability Table | 86 | SY | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
9 | F03B14 | Receipts Detail | 83 | RZ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
10 | F03B14P | Receipts Detail Purge File | 83 | RZ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
11 | F03B14Z2 | F03B14 Interoperability Table | 96 | SZ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
12 | F03B40 | A/R Deduction Management | 16 | RB | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
13 | F03B575 | Auto Debit Invoice Select and Build | 82 | RD | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
14 | F09UI011 | Receipt Prepost Work File | 48 | GL | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP04: Accounts Payable |
15 | F0411 | Accounts Payable Ledger | 59 | RP | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
16 | F0411A | WF - As Of Accounts Payable Ledger | 59 | RP | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
17 | F0411P | Purge - Accounts Payable Ledger | 59 | RP | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
18 | F0411Z1 | Voucher Transactions - Batch Upload | 77 | VL | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
19 | F0411Z3 | F0411 Interoperability Table | 82 | SZ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
20 | F09UI005 | Tax Offsets User Index | 53 | GL | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP09: General Accounting |
21 | F0911P | Purge - Account Ledger | 44 | GL | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
22 | F0911R | WF - Account Ledger Reconciliation | 84 | GL | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
23 | F0911Z1 | Journal Entry Transactions - Batch File | 61 | VN | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
24 | F0911Z4 | F0911 Interoperability Table | 66 | SZ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
25 | F09UI015 | Indexed Computations Multi-Tiered Entries | 44 | GL | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP15: Property Management |
26 | F1511 | Tenant/Lease Billings Detail | 84 | NJ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
27 | F1511B | Lease Billings Master | 80 | NJ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
28 | F1511H | Tenant/Lease Billings Detail History | 83 | N# | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
29 | F1511HB | Lease Billings History | 79 | NC | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP17: Customer Service Management |
30 | F1720 | Contract Header | 8 | CH | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
31 | F1721 | Contract Detail | 9 | CD | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP43: Procurement |
32 | F43080 | Approvals Fields Constants | 188 | PD | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
33 | F4311 | Purchase Order Detail File | 191 | PD | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
34 | F4311Z | Purchase Order Generator File | 217 | PW | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
35 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 206 | SZ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
36 | F43199 | P.O. Detail Ledger File - Flexible Version | 193 | OL | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP44H: Homebuilder Management |
37 | F44H711 | Lot Start Workfile | 23 | SW | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
38 | F44H711P | After Start Purchasing | 27 | TP | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
39 | F44H711Z | HB Lot Start Unedited Transaction File | 36 | SZ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
40 | F44H71W1 | Lot Start Generation Workfile | 23 | GW | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP47: Electronic Commerce |
41 | F47057 | EDI Payment Order Remittance Advice - Outbound | 45 | D3 | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
42 | F47057W | EDI Payment Order Remittance Advice - Work | 45 | D3 | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP48S: Service Billing |
43 | F4812 | Billing Detail Workfile | 22 | WD | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
44 | F4812H | Billing Workfile History | 22 | WD | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
45 | F4812HS | Billing Workfile History Purged Save | 22 | WD | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
46 | F48SUI01 | Billing Detail Print Workfile | 22 | WD | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP70: Multi-National Products - obsolete-do not reuse |
47 | F704001 | Payment WH Info TEMP - COMM - 04 | 9 | PT | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
48 | F704002 | Payment WH Info - COMM - 04 | 8 | PF | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
49 | F704002P | Payment WH Info Purge - COMM - 04 | 8 | PF | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP76B: Brazil - Reporting System Only |
50 | F76B411A | PIS - COFINS and CSLL bellow minimum - BR - 04 | 4 | WM | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
51 | F76B473T | F04573 Brazilian Temp WH File - BR - 04 | 24 | W3 | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP76C: Colombia |
52 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 72 | RP | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
53 | F76C034A | A/R Check Detail file As Of - COL - 03B | 84 | RZ | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP76M: Mexico |
54 | F76M0314 | Receipt Detail Tag File - Mexico | 14 | MA | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
55 | F76M0414 | F0414 - Payment Detail Tag File - Mexico | 15 | RT | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
TOP89: Conversion Programs |
56 | F4311TA | Temp table for ERP 9.0 upgrade | 6 | PD | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |
57 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 187 | OL | OSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 |