This appendix contains these topics and tables:
The following lists contain the table numbers, names and prefixes of all tables used by the payroll system. (A table's prefix is the first two characters of all the data names in that table.) An asterisk (*) identifies a table that includes data when JD Edwards World ships the software to the customer.
| Number | Name | Prefix |
|---|---|---|
| F060116 | Employee Master | YA |
| F060117 | Employee International Data | YA |
| F060146 | Occupational Pay Rates | JI |
| F06017 | Employee Tax Exemptions/Overrides | YA |
| F06018 | Data Parameter Extension | YF |
| F06022 | Employee Piecerate | JA |
| F06042 | Employee Future Data Changes | JO |
| F06106 | Employee DBA Instructions and Labor Distribution Instructions | YM |
| F06107 | Employee Wage Attachment Rules | J$ |
| F061071 | Employee Wage Attachment Fees | J$ |
| F065016 | Auto Deposit Instructions | YG |
| F068606 | COBRA Policy | JP |
| F068616 | COBRA Participants | JQ |
| Number | Name | Prefix |
|---|---|---|
| F06022 | Employee Piece Rate | JA |
| F06024 | Beneficiary/Co-owner | YJ |
| F06041 | Employee Master Future Data Select | JK |
| F0605 | DBA Period Control | J@ |
| F0626 | Wage Attachment Control | JG |
| F06270 | Retro Pay Parameter | JP |
| F06271 | Retro Pay Selection Parameters | JQ |
| F06209 | Execution Control Parameters | Y@ |
| F06900 | Non-U.S. Fiscal Date Patterns | Y$ |
| F069016* | Tax Area Information | YP |
| F069026 | DBA Calculation Tables | Y2 |
| F069027* | Calculation Table Methods | Y2 |
| F069036 | DBA Basis of Calculation | Y@ |
| F06904 | Automatic Accounting Instructions | Y# |
| F069056 | Cost Center Constants | YO |
| F069066 | Master Pay Cycles | JD |
| F069076 | Workers Compensation Insured Pay Types | YF |
| F069086 | Corporate Tax IDs | YI |
| F069096 | Payroll Company Constants | YK |
| F069106 | Union Benefit Plan Master | Y1 |
| F069116 | PDBA Transaction Constants | YC |
| F069117 | DBA State/Local Tax Exemptions | YB |
| F069126 | Union Pay Rates | YL |
| F06914 | Journal Entry Summarization Rules | JG |
| F06915 | Holiday Tables | JH |
| F069151 | Holiday Table Codes | JG |
| F06916 | Piecework Item Master | JJ |
| F069161 | Piecework Item Cross Reference | JE |
| F069162 | Piecework Item/Job Type Cross Reference | JH |
| F06917 | Tax Payment Schedule | YK |
| F069171 | Payment/Reporting Terms | YK |
| F06918 | Piecerate Constants | JN |
| F06919 | Denomination Table | YB |
| F069216 | Workers Compensation Rates Tables | YB |
| F069226 | Unemployment Insurance Rates | YH |
| F06923 | Job Classification Constants | YH |
| F069246 | Shift Differential Tables | Y3 |
| F06925 | Employee/Payee Cross Reference | YG |
| F06926 | Tax Area/Payee Cross Reference | Y# |
| F06927 | Payee Voucher Rules | J5 |
| F069306 | Union/Job Type Cross Reference | Y@ |
| F06931 | Wage Attachments | J3 |
| F069311 | Wage Attachments - Additional Exemptions | J3 |
| F069312 | Wage Attachments - Annual Exemptions | J3 |
| F06932 | Job Type/Pay Type Cross Reference | J4 |
| F06933 | Step Progression Parameters | J@ |
| F06936 | Retro Pay types Rate | JA |
| F06972 | Retro Pay Type Table | YR |
| Number | Name | Prefix |
|---|---|---|
| F06005 | Payroll Reporting Parameters | JE |
| F06053 | Interim Check Parameters | YW |
| F060531 | Interim Check Tax Overrides | YW |
| F06210 | Pre-Payroll Processing Parameters | YD |
| F06211* | Reports Only - DREAM Writer IDs | YD |
| F062101 | Pre-Payroll Country Parameters | YD |
| F062102 | Pre-Payroll Additional Parameters | YE |
| F063920* | Archive Versions | Y1 |
| F063921* | Archive Members | Y2 |
| Number | Name | Prefix |
|---|---|---|
| F0607 | Wage Attachment Ledger | JI |
| F06136 | Taxation Summary | YZ |
| F06145 | Calendar Month DBA Summary | YH |
| F06146 | Payroll Month DBA Summary | YN |
| F06147 | Fiscal/Anniversary Year to Date | YD |
| F06148 | Tax Area/Transaction Repost Summary | Y@ |
| F06156 | Paycheck History | YU |
| F06166 | Tax Ledger Detail | YV |
| F06176 | EI History | YS |
| F0618 | Timecard Detail | YT |
| F0619 | DBA Transaction Detail | Y$ |
| F0620 | Pay Period Integrity | YJ |
| F06216 | Employee Tip History | JA |
| F06226 | Business Unit Tip History | JB |
| F0623 | Piecework History | JL |
| F0624 | Burden Distribution Detail | J# |
| F0625 | Step Progression History | JB |
| F06251 | Step Progression Pay Rate History | JB |
| F0627 | Workers Compensation Summary History | JH |
| F0628 | Accrual Distribution History | J8 |
| F06502 | Auto Deposit History | YE |
| F068500 | Tax Reporting History | YZ |
| F0713 | Taxation Summary by Province | YZ |
| F0716 | Tax Ledger Detail | YV |
| Number | Name | Prefix |
|---|---|---|
| F0609 | DBA Transaction Detail (current) | Y$ |
| F06116 | Timecard Detail (current) | YT |
| F06116Z1 | Employee Transactions - Batch | VL |
| F0611Z2 | Employee Transactions - Multi-Member PC Support Batch | VR |
| Number | Name | Prefix |
|---|---|---|
| T06136 | W-2 Processing | YZ |
| T06176 | Unemployment Insurance History | YS |
| T06216 | Employee Tip Allocation | |
| T062161 | Employee Tip Allocation | JA |
| T06226 | Cost Center Tip Allocation | JB |
| T06226A | Federal Tip Reporting Form 8027 JB | JB |
| T062261 | Cost Center Tip Allocation Summary | JB |
| T063100 | Health and Welfare Reports | Y$ |
| T063106 | DBA Workfile | Y7 |
| T063170 | Tax Distribution Summary | Y4 |
| T063200 | Job Billing Reports | YT |
| T067011 | Tax Integrity Report Errors | Y$ |
| T067021 | Transaction Integrity Report Errors | Y$ |
| T06703 | Payroll History Audit Report Errors | |
| T068900 | EEO Utilization | YT |
| T068901 | EEO Utilization | YT |
| T068902 | EEO Utilization | YT |
| Number | Name | Prefix |
|---|---|---|
| F06290 | Detail Journal Entry | YR |
| F06126 | Payroll Tax | YY |
| F06126I | Interim Check Tax (VertexT) | YY |
| F06149 | Fiscal/Anniversary Year to Date Rollover | Y7 |
| F06278 | Retro Timecard | YT |
| F063106 | Deduction/Benefit | Y7 |
| F06345 | Historical Payroll Payroll Register | JL |
| F063451 | Historical Payroll Payroll Register | JK |
| F063501 | Paycheck Workfile | Y4 |
| F06350I | Interim Paycheck | Y4 |
| F063505 | Piecework Paycheck | Y6 |
| F06395 | Summarized Journal Entry | YR |
| F063922 | Archive Members, Workfile for Count | Y3 |
| F06490 | A/P Detail | JR |
| F06491 | A/P Summary | J6 |
| F06492 | A/P Control | JC |
| F065516 | Auto Deposit | Y6 |
| F06560 | Bank Reconciliation - Issue | Y8 |
| F06561 | Bank Reconciliation - Paid | Y9 |
| F06603 | Sales Allocation/Entry | JU |
| F066031 | Sales Allocation Amount | JT |
| F068500 | Federal 941 History | YZ |
| F069136 | Tip Disbursement | JE |
| Number | Name | Prefix |
|---|---|---|
| F0611Z | Batch Time and Pay Transaction - Database format | JL |
| F06650 | Batch Control Upload File - PC Format | PF |
| F06651 | Time and Pay Transactions - PC Format | JN |
| F06720 | Build W-2 Workfile Parameters | JE |
| F067201 | Version Form Count Control | JE |
| F06721 | Company Form Count | JG |
| F067211 | 1099 Constants | JH |
| F06722 | Company Federal Control | JI |
| F06723 | W-2 Audit Reports | YF |
| F06724 | Company State/Local Control | JD |
| F06725 | Company Special Handling Control | JA |
| F06726 | Workfile Build Selection Criteria | JB |
| F06730 | Employee Federal Control | YO |
| F06731 | Employee State/Local Control | YB |
| F06732 | Employee Special Handling Control | YH |
| F06762 | W - 2 Magnetic Media S Record | Y2 |