Payroll System Files |
Top Previous Next |
|
APAADV Payroll advances
PRLEMP C 10 Employee code PRLDAT D 8 Transaction date ADVPAY N 10,4 Amount advanced PAYPST L 1 Payment posted flag PAYWHY C 30 Reason for advance
APADDE Payroll Deduction Detail
PRLDED C 10 Deduction code PRLDCO C 25 Company PRLDAD C 25 Address PRLDCT C 25 City PRLDST C 2 State PRLDZC C 10 Zip code PRLDPH C 14 Phone number PRLDCN C 25 Contact name PRLDTO N 10,2 Deduction total PRLDPA N 10,2 Deduction paid PRLDLP D 8 Date of last payment PRLDDB C 5 Deduction G/L debit account PRLDCR C 5 Deduction G/L credit account
APADED Payroll Deduction File
PRLEMP C 10 Employee code PRLDED C 10 Deduction code PRLPER N 3 Payroll period PRLDAM N 10,2 Deduction amount PSTPAY L 1 Payment posted flag PRLDDB C 6 Debit PRLDCR C 6 Credit
APADTE Payroll: Date of last processing
BMODTE D 8 Begin date: last monthly EMODTE D 8 End date: last monthly BSEDTE D 8 Begin date: last semi-monthly ESEDTE D 8 End date: last semi-monthly BBIDTE D 8 Begin date: last bi-weekly EBIDTE D 8 End date: last bi-weekly BWKDTE D 8 Begin date: last weekly EWKDTE D 8 End date: last weekly PRLPER N 3 Payroll period
APAEDE Payroll Deduction File - Employee Link
PRLEMP C 10 Employee code PRLDED C 10 Deduction code PRLDPR N 10,4 Deduction percentage PRLDFA N 10,2 Deduction fixed amount PRLTOT N 10,2 Total Amount Paid PRLDCO C 25 Deduction description PRLTXP C 1 When to deduct PRLDDB C 6 Debit PRLDCR C 6 Credit
APAFTT Federal Tax Table
PRLMAR C 1 Marital status PRLPCD C 1 Period Type - week/month LOWLIM N 8,2 Lower limit UPRLIM N 12,2 Upper limit BASAMT N 8,2 Base amount EXCAMT N 8,2 Exceed amount EXCPER N 8,4 Exceed percent
APAGLD General Ledger
FEDWIT C 6 Debit Federal Witholding FECWIT C 6 Credit Federal Witholding STDWIT C 6 Debit State Witholding STCWIT C 6 Credit State Witholding LODWIT C 6 Debit Local Witholding LOCWIT C 6 Credit Local Witholding FIDEME C 6 Debit FICA employee FICEME C 6 Credit FICA employee FIDEMR C 6 Debit FICA employer FICEMR C 6 Credit FICA employer FUDEMR C 6 Debit FUTA employer FUCEMR C 6 Credit FUTA employer SDDEME C 6 Debit SDI employee SDCEME C 6 Credit SDI employee SDEEMR C 6 Debit SDI employer SDCEMR C 6 Credit SDI employer SUDEME C 6 Debit SUTA employee SUCEME C 6 Credit SUTA employee SUDEMR C 6 Debit SUTA employer SUCEMR C 6 Credit SUTA employer
APALAB Labor tickets for payroll
PRLEMP C 10 Employee code LABDAT D 8 Labor date LABUNT N 8,2 Labor units LABGRS N 10,2 Labor gross PARGRS N 10,2 Parts gross PAYEMP L 1 Payment has been processed PAYPST L 1 Payment posted flag
APAMST Payroll Master File
PRLEMP C 10 Payroll Code PRLLST C 15 Employee Last Name PRLFST C 10 Employee First Name PRLSPO C 10 Employee Spouse PRLADD C 25 Employee Address PRLCTY C 25 Employee City PRLSTE C 2 Employee State PRLZIP C 10 Employee Zipcode PRLPHO C 14 Employee Phone PRLSSI C 12 Employee Social Security Number PRLBEG D 8 Beginning Date PRLEND D 8 Ending Date PRLHRL N 6,2 Hourly pay PRLPCL N 6,2 Percentage of labor PRLPCP N 6,2 Percentage of parts PRLSAL N 10,2 Salary PRLMAR L 1 Married ? PRLDEP N 2 Number of dependents PRLLPD D 8 Last pay date PRLYTD N 10,2 Year to date PRLFTW N 10,2 Federal tax witholding PRLSTW N 10,2 State tax witholding PRLLTW N 10,2 Local tax witholding PRLFIC N 8,2 Employee FICA EMPFIC N 8,2 Employer FICA PRLMED N 8,2 Employee Medicare EMPMED N 8,2 Employer Medicare PRLFUT N 8,2 Employee FUTA EMPFUT N 8,2 Employer FUTA PRLSDI N 8,2 Employee SDI EMPSDI N 8,2 Employer SDI PRLSUT N 8,2 Employee SUTA EMPSUT N 8,2 Employer SUTA PRLOTH N 10,2 Other Employee deductions EMPOTH N 10,2 Other Employer deductions PRLFEX N 2 Federal Exemptions PRLSEX N 2 State Exemptions PRLSE2 N 2 State Exemptions field 2 PRLSE3 N 2 State Exemptions field 3 PRLLEX N 2 Local Exemptions PRLFAD N 8,2 Federal additional witholding PRLSAD N 8,2 State additional witholding PRLLAD N 8,2 Local additional witholding VACDAT D 8 Date when vacation pay is earned VACDYS N 8,2 Days/year vacation offered VACACR N 10,4 Days/year vacation accrued VACPAD N 10,4 Days/year vacation paid VACTOT N 10,2 Amount paid for vacation pay VACRAT N 10,2 Vacation rate SICDAT D 8 Date when sick pay is earned SICDYS N 8,2 Days/year sick pay offered SICACR N 8,2 Days/year sick pay accrued SICPAD N 8,2 Days/year sick pay paid SICTOT N 10,2 Amount paid for sick leave SICRAT N 10,2 Sick pay rate PRLADV N 10,2 Advances PRLNET N 10,2 Net pay PRLREV D 8 Review date PRLPER C 1 Processing period PRLPBA N 10,2 Base parts PRLLBA N 10,2 Base labor PRLTYP C 1 Employee type (Mngnent,Super,Tech,Cler.Lab) PRLUNT N 10,2 Unit pay PRLDRW N 10,2 Draw PRLDBA N 10,2 Draw base PRLDEX N 8,2 Excess rate of draw PRLIH1-4 N 8,2 Hour rate - incentive pay PRLIU1-4 N 8,2 Unit count for determining incentive pay COMENT M 10 Notes about the technician PRLORT N 4,2 Overtime rate PRLOHR N 6,2 Overtime base hours PRLDRT N 4,2 Double time rate PRLDHR N 6,2 Double time base hours PRLPPR C 1 Payroll processing period
APAPER Payroll Period File
PRLPCD C 1 Type of period (W,B,S,M) PRLBDT D 8 Beginning Date PRLEDT D 8 Ending Date PRLPER N 3 Period
APASDA Payroll State Deductions
PRLSTE C 2 State STATAB C 2 State Tax Table WESTDE N 8,2 Weekly estimated deduction BESTDE N 8,2 Bi-weekly estimated deduction MESTDE N 8,2 Monthly estimated deduction SESTDE N 8,2 Semi-monthly estimated deduction WSTDDS N 8,2 Weekly standard deduction - single BSTDDS N 8,2 Bi-weekly standard deduction - single SSTDDS N 8,2 Semi-monthly standard deduction - single MSTDDS N 8,2 Monthly standard deduction -single WSTDDM N 8,2 Weekly standard deduction - married BSTDDM N 8,2 Bi-weekly standard deduction - married SSTDDM N 8,2 Semi-monthly standard deduction - married MSTDDM N 8,2 Monthly standard deduction - married WDEPCR N 8,2 Weekly dependent credit BDEPCR N 8,2 Bi-weekly dependent credit SDEPCR N 8,2 Semi-monthly dependent credit MDEPCR N 8,2 Monthly dependent credit
APASIC Sick pay assignments
PRLEMP C 10 Employee code PRLDAT D 8 Transaction date SICDAY N 10,4 Days to be paid SICPAY N 10,2 Amount to be paid PAYPST L 1 Payment posted flag
APASTG State tax group
PRLSTE C 2 State code PRLGRC N 8,4 Percentage of gross pay PRLFED N 8,4 Percentage of federal tax PRLTAB N 1 Use tax table PRLPCN N 1 Use percentage
APASTT State tax table
PRLSTE C 2 State PRLMAR C 1 Marital status PRLPCD C 1 Payroll period LOWLIM N 8,2 Lower limit UPRLIM N 8,2 Upper limit BASAMT N 8,2 Base amount EXCAMT N 8,2 Excess amount EXCPER N 8,4 Excess percentage
APATCK Tax payment log
PAYDAT D 8 Date of payment PAYAMT N 10,2 Amount of payment PAYFED L 1 Payment applied to federal tax PAYSTA L 1 Payment applied to state tax PAYLOC L 1 Payment applied to local tax PAYFIC L 1 Payment applied to FICA PAYFUT L 1 Payment applied to FUTA PAYSDI L 1 Payment applied to SDI PAYSUT L 1 Payment applied to SUTA
APATDU Tax due log
DUEOUT D 8 Date of witholding DUEFIW N 10,2 Federal Witholding DUESIW N 10,2 State Witholding DUELIW N 10,2 Local Witholding DUEFUT N 10,2 FUTA DUESUT N 10,2 SUTA DUEFIC N 10,2 FICA DUESDI N 10,2 SDI PAYFED L 1 Paid Federal obligation PAYSTA L 1 Paid State obligation PAYLOC L 1 Paid Local obligation PAYFUT L 1 Paid FUTA obligation PAYSUT L 1 Paid SUTA obligation PAYFIC L 1 Paid FICA obli\gation PAYSDI L 1 Paid SDI obligation
APATIM Employee time clock records
PRLEMP C 10 Employee code TIMDAT D 8 Date of time card TIMBG1 C 5 Beginning time 1 TIMEN1 C 5 Ending time 1 TIMBG2 C 5 Beginning time 2 TIMEN2 C 5 Ending time 2 TIMBG3 C 5 Beginning time 3 TIMEN3 C 5 Ending time 3 TIMBG4 C 5 Beginning time 4 TIMEN4 C 5 Ending time 4 TIMBG5 C 5 Beginning time 5 TIMEN5 C 5 Ending time 5 TIMBG6 C 5 Beginning time 6 TIMEN6 C 5 Ending time 6 TIMTOT N 8 Total Time for this card PAYPST L 1 Payment posted flag
APATRN Payroll Transaction File
PRLEMP C 10 Payroll Code PRLBDT D 8 Beginning Date PRLEDT D 8 Ending Date PRLPPD D 8 Pay date PRLLAB N 8,2 Total labor income PRLUNI N 8,2 Total Units PRLHRS N 8,2 Total Hours PRLGRS N 10,2 Gross pay PRLFTW N 10,2 Federal tax witholding PRLSTW N 10,2 State tax witholding PRLLTW N 10,2 Local tax witholding PRLFIW N 8,2 Employee FICA EMPFIC N 8,2 Employer FICA PRLMED N 8,2 Employee Medicare EMPMED N 8,2 Employer Medicare PRLFUT N 8,2 Employee FUTA EMPFUT N 8,2 Employer FUTA PRLSDI N 8,2 Employee SDI EMPSDI N 8,2 Employer SDI PRLSUT N 8,2 Employee SUTA EMPSUT N 8,2 Employer SUTA PRLOTH N 10,2 Other Employee deductions EMPOTH N 10,2 Other Employer deductions PRLADV N 10,2 Advances PRLSIC N 10,2 Sick Pay PRLVAC N 10,2 Vacation Pay PRLSUP N 10,2 Supplements PRLNET N 10,2 Net pay PRLCHK C 5 Payroll check number PRLPER N 3 Payroll period COMPLE L 1 Completion flag Y/N PRLOVT N 8,2 Overtime hours total PRLDBT N 8,2 Doubletime hours total PRLPIN N 8,2 Incentive pay PRLPOV N 8,2 Overtime pay PRLPRG N 8,2 Regular pay PRLPCM N 8,2 Pay Commission PRLCOM N 8,2 Commission basis - parts PRLLUN N 8,2 Labor units PRLCLK N 8,2 Clock hours PRLLCM N 8,2 Pay for labor commission WRICHK L 1 Paycheck written flag PRLBNK C 2 Bank account for paycheck FICWAG N 10,2 F.I.C.A. wages MEDWAG N 10,2 Medicare wages
APATXD Payroll Tax Rate Defaults
TAXYER C 4 Tax year FEDWID C 15 Federal tax ID STAWID C 15 State tax ID FICAEC N 8,4 FICA Employer contribution FICAWC N 8,4 FICA Worker contribution FICALI N 8,2 FICA limit FICMEC N 8,2 FICA FICMWC N 8,2 FICA FICMLI N 10,2 FICA FUTAEC N 8,4 FUTA Employer contribution FUTALI N 8,2 FUTA limit SUTAEM N 8,4 SUTA Employer contribution SUTAWK N 8,4 SUTA Worker contribution SUTALI N 8,2 SUTA limit SDIEMP N 8,4 SDI Employer contribution SDIWOR N 8,4 SDI Worker contribution SDILIM N 8,2 SDI limit OTHTAX N 8,4 Other tax FWAWEK N 8,2 Federal witholding allowance - weekly FWABWK N 8,2 Federal witholding allowance - bi-weekly FWASMO N 8,2 Federal witholding allowance - semi-monthly FWAMON N 8,2 Federal witholding allowance - monthly STAWHD C 2 State code
APATXP Payroll tax payments
PAYFIC N 10,2 FICA paid PAYFUT N 10,2 FUTA paid PAYSUT N 10,2 SUTA paid PAYSDI N 10,2 SDI paid PAYFWD N 10,2 Federal witholding paid PAYSWD N 10,2 State witholding paid PAYLWD N 10,2 Local witholding paid CHKDAT D 8 Date of check CHKNUM C 6 Check number CHKACT C 2 Checking account number CHKPAY N 10,2 Amount of check
APAVAC Vacation pay assignments
PRLEMP C 10 Employee code PRLDAT D 8 Transaction date VACDAY N 10,4 Days to be paid VACPAY N 10,2 Amount to be paid PAYPST L 1 Payment posted flag
|