Showing posts with label Tables. Show all posts
Showing posts with label Tables. Show all posts

Friday, February 25, 2011

Employee Self Service Table Updates

1. Tables updated/inserted by N0800044 (F08330 Transaction Business Function) 

F060116          Employee Master
F06106            Employee Pay Instructions
F08330            Employee Enrollment
F08330B         Employee Enrollment Tag File
F08501                  Employee Pension Activity Master

2. Tables updated/inserted by R054104 (Update Employee Personal Information to Live Tables) 

F0101                                     Address Book Master                                                                                                  
F0111                                     Address Book - Who's Who                                                  
F0115                                     Address Book - Contact Phone Numbers                   
F01151                                   Electronic Address                                                      
F0116                                     Address by Date                                                                     
F01161                                   Alternate Address                                                       
F060116                                 Employee Master                                                         
F054101                                 Employee Personal Profile Information History Table                                                
F054101W                             Employee Personal Profile Information Work Table                                
F054111                                 Employee Emergency Contact History Table             
F054111W                             Employee Emergency Contact Work Table                
F054115                                 Employee Phone Number History Table                     
F054115W                             Employee Phone Number Work Table                        
F05420                                   Workflow Approval Table                                                      Once updated, cannot update again.
F085528                                 ESS History Table Cross Reference                            
                                               F08901ParticipantFile 

3. Tables updated/inserted by R085524 (Update Benefits Information to Live Tables)


F05420                                   Workflow Approval Table                                          
F06106                                   Employee Pay Instructions                                          
F08330                                   Employee Enrollment                                                  
F08330B                                Employee Enrollment Tag File                                    
F08336                                   Dep/Ben to Employee Plan X-Reference                    
F08336B                                Dep/Ben X-Reference Tag Table                                
F08338                                   Primary Care Physician Table                                      
F08338B                                Primary Care Physician Tag Table                               
F085520                                 Available Plans and Options by Employee History Table                        
F085520W                             Available Plans and Options by Employee Work Table                           
F085528                                 ESS History Table Cross Reference                            
F085536                                 Dependent/Beneficiary X-Reference History Table   
F085536W                             Dependent/Beneficiary X-Reference Work Table      

4. Tables updated/inserted by R085520 (Available Plans Work File Build)

F085520W      Available Plans and Options by Employee Work Table

5. Tables updated/inserted by R085530 (Current Enrollment Work File Build)

F085530W      Employee Current/Pending Elections Work Table

6. Tables updated/inserted by R085537 (Build Current Dep/Ben Work File)

F085537W      Current Dep/Ben X-Reference Work Table

Saturday, February 19, 2011

Important Tables

Tables:

Address Book:

Address Book Master
F0101
Address Book – Who’s Who
F0111
Address Book – Contact Phone Numbers
F0115
Address Book – Electronic Address
F01151
Address Book – Address by Date
F0116
Address Organizational Structure Master
F0150(p02150)


Inventory:

Location Master
F4100
Inventory Constants
F41001
Item Units of Measure Conversion Factors
F41002
Item Master
F4101
Item Branch File
F4102
Item Location File
F41021
Item Cross Reference File
F4104
Item Cost File
F4105
Item Base Price File
F4106
Item Ledger File
F4111
Supplier Price/Catalog File
F41061


Purchase Order:

Purchase Order Header
F4301
Purchase Order Detail File
F4311
Purchase Order Receiver File
F43121
Purchase Order Detail Ledger File
F43199
Supplier Master
F0401
A/P Ledger
F0411
Customer Master by Line of Business
F0301 (F03012 in E900)


General Accounting:

General Ledger
F0911
Account Balances
F0902
Account Master
F0901
Customer Ledger
F03B11


Sales Order:

Sales Order Header
F4201
Sales Order Detail
F4211
Sales Order Detail - History
F42119
Sales Order Ledger
F42199
Invoice Print File
F42565