Importing Deduction Codes
The following tables show examples of data fields used in the Deduction Codes section of the MasterPR.DEF file:
Header
| Table: tblPRDeductCode | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,DEDUCTIONCODE,HEADER,HDED | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
DEDUC_CODE |
Y |
User Defined |
Deduction Code ID |
|
|
DEDUC_STATUS |
N |
1 |
A |
A (Active), I (Inactive), or D (Discontinued) |
|
DEDUC_TITLE |
Y |
User Defined |
Deduction Code Title |
|
|
DEDUC_LIABACCT |
Y |
User Defined |
Liability G/L code. Must be a valid chart of accounts code (Maintain>Chart of Accounts Codes). |
|
|
DEDUC_W2_BOX_NUM |
N |
2 |
W-2 Box Number, if any |
|
|
DEDUC_W2_BOX_CODE |
N |
14 |
W-2 Box Code, if any |
|
|
DEDUC_CALC_METHOD |
N |
2 |
FA |
Valid Calculation Methods: FP, FH, FA, AT, and PT. See Table 3. |
|
DEDUC_AMOUNT |
Y |
Currency |
0.0000 |
Required for FH or FA. |
|
DEDUC_PERCENT |
Y |
Single |
000.0000 |
Required for FP. Enter 5% as 05 or 5. |
|
DEDUC_MAX |
N |
Currency |
999,999.99 |
Required for all calculation methods. |
|
DEDUC_FED_FIT |
N |
2 |
Decreases subject earnings. 0 = No; 1 = Yes |
|
|
DEDUC_FED_SOCIAL_ |
N |
2 |
Decreases subject earnings. 0 = No; 1 = Yes |
|
|
DEDUC_FED_MEDICARE |
N |
2 |
Decreases subject earnings. 0 = No; 1 = Yes |
|
|
DEDUC_FED_FUTA |
N |
2 |
Decreases subject earnings. 0 = No; 1 = Yes |
|
|
DEDUC_STATE_SWT |
N |
2 |
Decreases subject earnings. 0 = No; 1 = Yes |
|
|
DEDUC_STATE_SUTA |
N |
2 |
Decreases subject earnings. 0 = No; 1 = Yes |
|
|
DEDUC_LOCAL_LWT |
N |
2 |
Decreases subject earnings. 0 = No; 1 = Yes |
|
|
DEDUC_LOCAL_ |
N |
2 |
Decreases subject earnings. 0 = No; 1 = Yes |
|
|
DEDUC_MAX_PERC |
N |
8 |
000.0000 |
Maximum percentage allowed on timesheet for PT. Enter 5% as 05 or 5. |
Detail
| Table: tblPRDeductCodeEarning | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,DEDUCTIONCODE,DETAIL,DDED | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
PR_EC_CODE |
Y |
User Defined |
Required if calculation method of FP or FH. Can have more than one earning code. Must be a valid code (Maintain>Payroll>Earning Codes). |
|