| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0006 | Business Unit Master | 14 | MC | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
2 | F0006D | Business Unit Alternate Description Master | 6 | LJ | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
3 | F0006DZ1 | Business Unit Alternate Description Z file | 20 | SZ | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
4 | F0006S | Date Effective Business Unit Master | 16 | MC | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
5 | F0006Z1 | Cost Center Unedited Transaction Table | 27 | SZ | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
6 | F0006Z2 | Business Unit Master Z File | 27 | SZ | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
7 | F0012 | Automatic Accounting Instructions Master | 9 | KG | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
8 | F0012D | AAI Alternate Description Master | 7 | LJ | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
TOP05A: PeopleSoft HR & PR Foundation |
9 | F060116W | EE Master Request File | 228 | YA | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
10 | F08096 | HR Generic Table Headings | 6 | H$ | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
TOP07: Payroll |
11 | F069026 | Payroll Generic Tables | 16 | Y2 | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
12 | F078504 | Vertex Geo Code to ADP Code | 7 | VA | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
13 | F8907427 | New Hire Detail File - Montana (27) | 40 | MT | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
14 | F8907444 | New Hire Detail File Transfer - Texas (44) | 19 | TX | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
TOP08: Human Resources |
15 | F08391 | User Program Parameters | 19 | B0 | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
TOP09: General Accounting |
16 | F09UI009 | Trial Balance Generic Work File - OneWorld ONLY | 10 | GB | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
TOP15: Real Estate Management |
17 | F1507 | Unit Master | 8 | NH | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
18 | F1507D | Unit Master - Alternate Description | 7 | NH | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
TOP44H: Homebuilder Management |
19 | F44H401 | Option Master | 10 | OC | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
20 | F44H4011 | Option by Community | 11 | OC | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
21 | F44H401W | Option Master Work File | 11 | OW | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
TOP75I: India |
22 | F75I406 | State / Branch Plant Cross Reference | 7 | SB | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
23 | F75I407 | Item Category Relationship | 9 | IC | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
TOP89: Conversion Programs |
24 | F75I101A | TDS Ceritificate Master Tabel Extension | 21 | QB | DL04 | Description 04 | String | Generic Edit | 30 | 0 |
TOPH92: Interactive Engine/OL |
25 | F98231H | OMW Transfer Activity Rule Director - Header | 7 | TR | DL04 | Description 04 | String | Generic Edit | 30 | 0 |