PR_Department P/R Department Master File Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/PR"+%C$+"/PR_Department.M4T"
KPRIMARY: DepartmentNo
Fld Column Name M/L TUR Description/Notes Class
1 DepartmentNo. . . . . . . . . 2 SYY Department Number . . . . . . . 2 DepartmentDesc. . . . . . . . 30 SNN Department Description. . . . .DESCRIPTION 3 PayrollExpenseAcctKey . . . . 9 SYN Account Key . . . . . . . . . .ACCOUNT 4 EmployerFICAAcctKey . . . . . 9 SYN Employer FICA Account Key . . .ACCOUNT 5 FederalUnemploymentAcctKey. . 9 SYN Federal Unemployement InsuranceACCOUNT 6 StateUnemploymentAcctKey. . . 9 SYN State Unemployment Account Key.ACCOUNT 7 WorkerCompensationAcctKey . . 9 SYN Worker's Compensation Account KACCOUNT 8 EmployerMedicareAcctKey . . . 9 SYN Employer Medicare Account Key .ACCOUNT 9 EarningsCode01. . . . . . . . 2 SNN Earnings Code 01. . . . . . . . 10 Earnings01AcctKey . . . . . . 9 SYN Earnings 01 Account Key . . . .ACCOUNT 11 EarningsCode02. . . . . . . . 2 SNN Earnings Code 02. . . . . . . . 12 Earnings02AcctKey . . . . . . 9 SYN Earnings 02 Account Key . . . .ACCOUNT 13 EarningsCode03. . . . . . . . 2 SNN Earnings Code 03. . . . . . . . 14 Earnings03AcctKey . . . . . . 9 SYN Earnings 03 Account Key . . . .ACCOUNT 15 EarningsCode04. . . . . . . . 2 SNN Earnings Code 04. . . . . . . . 16 Earnings04AcctKey . . . . . . 9 SYN Earnings 04 Account Key . . . .ACCOUNT 17 EarningsCode05. . . . . . . . 2 SNN Earnings Code 05. . . . . . . . 18 Earnings05AcctKey . . . . . . 9 SYN Earnings 05 Account Key . . . .ACCOUNT 19 EarningsCode06. . . . . . . . 2 SNN Earnings Code 06. . . . . . . . 20 Earnings06AcctKey . . . . . . 9 SYN Earnings 06 Account Key . . . .ACCOUNT 21 EarningsCode07. . . . . . . . 2 SNN Earnings Code 07. . . . . . . . 22 Earnings07AcctKey . . . . . . 9 SYN Earnings 07 Account Key . . . .ACCOUNT 23 EarningsCode08. . . . . . . . 2 SNN Earnings Code 08. . . . . . . . 24 Earnings08AcctKey . . . . . . 9 SYN Earnings 08 Account Key . . . .ACCOUNT 25 EarningsCode09. . . . . . . . 2 SNN Earnings Code 09. . . . . . . . 26 Earnings09AcctKey . . . . . . 9 SYN Earnings 09 Account Key . . . .ACCOUNT 27 EarningsCode10. . . . . . . . 2 SNN Earnings Code 10. . . . . . . . 28 Earnings10AcctKey . . . . . . 9 SYN Earnings 10 Account Key . . . .ACCOUNT 29 AccrueWageExpense . . . . . . 1 SYN Accrue Wage Expense Yes/No. . .YESNO DfltVal:N Valid:Y,N 30 AccrueTaxExpense. . . . . . . 1 SYN Accrue Tax Expense Yes/No . . .YESNO DfltVal:N Valid:Y,N 31 AccrueTaxAccruals . . . . . . 1 SYN Accrue Tax Accruals Yes/No. . .YESNO DfltVal:N Valid:Y,N 32 AccrualAcctKey. . . . . . . . 9 SYN Accrual Account Key . . . . . .ACCOUNT 33 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 34 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . . Read Only:Y 35 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER Read Only:Y Mask:0000000000 36 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 37 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . . Read Only:Y 38 UserUpdatedKey. . . . . . . . 10 SNN User Updated Key. . . . . . . .USER Read Only:Y Mask:0000000000