| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0040Z1 | Error Message Log Table | 6 | ZB | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
2 | F0041Z1 | Transaction Control File | 7 | ZF | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP02: Electronic Mail |
3 | F01132 | PPAT Message Text File | 1 | CY | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP03B: Enhanced Accounts Receivable |
4 | F03B20 | A/R Notification History | 53 | ZR | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
5 | F03B22 | A/R Fee Journal History | 21 | RS | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP05: Time Accounting and HRM Base |
6 | F05102 | Goal Master | 10 | SM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP05A: PeopleSoft HR & PR Foundation |
7 | F05842 | Employee/Supervisor Approval History | 12 | AT | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
8 | F060120 | Employee Master Additional Information File | 25 | YA | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP08: Human Resources |
9 | F087711 | CBPA Appraisal Header | 43 | XJ | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
10 | F087711A | CBPA Appraisal Header Tag Table | 5 | XJ | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
11 | F087711B | Performance Appraisal Header Template Keys | 1 | XK | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
12 | F087715 | CBPA Diary Table | 10 | XM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
13 | F087721 | CBPA Appraisal Creation Work File | 12 | XP | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP10: Financial Reporting |
14 | F1002 | Multi-Site Consolidation Transfer File | 5 | GQ | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
15 | F1002Z1 | Unedited MSC Interoperability Table | 14 | SZ | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
16 | F1017 | Consolidation Specifications | 2 | CS | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
17 | F10470 | Consolidation Specifications (OW) | 2 | CS | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
18 | F10471 | Elimination Rules (OW) | 2 | ER | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
19 | F10UI006 | MSC - F1002 Elimination Work File | 4 | GE | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP17C: Call Management |
20 | F1755 | Case Master | 13 | ZA | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
21 | F1757 | Task Master | 22 | ZA | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP41: Inventory Management |
22 | F4101A | Item File | 8 | IM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
23 | F4101B | Item Master Bulk Data | 8 | IM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
24 | F4101C | Item Category Codes | 8 | IM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
25 | F4101F | Item Customer Service Data | 8 | IM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
26 | F4101G | Item Branch Quantities | 8 | IB | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
27 | F4101M | Item Manufacturing Data | 8 | IM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
28 | F4101P | Item Master Packaging | 8 | IM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
29 | F4101S | Item Master Shipping Data | 8 | IM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
30 | F4101W | Item Profile Data | 8 | IM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP43E: Requisition Self Service |
31 | F43E09 | F43E09 - Approvals Activity Table | 1 | AA | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOP89: Conversion Programs |
32 | F0086 | Conversion Audit File for Euro Conversion | 1 | AU | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOPH90: EnterpriseOne TOOLS |
33 | F01131 | PPAT Message Control File | 1 | ZZ | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
34 | F01131M | JDEM Multi Level Message | 2 | ZM | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
35 | F01131T | Message Attachment Tag File | 1 | ZC | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
36 | F01133 | PPAT Message Detail File | 1 | ZT | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
37 | F1761 | Electronic Help JDE Request Log | 24 | ZA | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |
TOPH95: Object and Environment Tech |
38 | F00166 | Media Object Categories | 83 | GT | SERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 |