Laserfiche WebLink
2 <br /> <br />ALL ENTRIES COMPANY/BATCH HEADER RECORD <br />Field <br /># Position Size MCSJ Value Used – <br />Payroll <br />MCSJ Value Used – <br />Vendor <br />MCSJ Value Used – <br />Tax/Utility Field Name <br />1 01-01 1 ‘5’ ‘5’ ‘5’ Record Type Code <br />2 02-04 3 ‘200’ ‘200’ ‘200’ Service Class Code <br />3 05-20 16 <br />2.7: City Name from <br />System <br />Parameter(substring if <br />> 16 chars) <br />City Name from <br />System <br />Parameter(substring if <br />> 16 chars) <br />City Name from <br />System <br />Parameter(substring if <br />> 16 chars) <br />Company Name <br />4 21-40 20 sp20 sp20 sp20 Company <br />Discretionary Data <br />5 41-50 10 <br />Payroll Parameter <br />dir_dep_co_id_prefix + <br />tax_id <br />Checking Account <br />dd_co_id_prefix + <br />tax_id <br />Utility Parameter or <br />Tax Parameter <br />dw_co_id_prefix + <br />Parmtr tax_id <br />Company <br />Identification <br />6 51-53 3 ‘PPD’ ‘PPD’ ‘PPD’ Standard Entry Class <br />Code <br />7 54-63 10 ‘PAYROLL’ + sp3 ‘TAX ‘+ Sp7 OR <br />‘UTILITY’+ sp3 <br />Company Entry <br />Description <br />8 64-69 6 User entered Effective <br />Date (YYMMDD) <br /> Payment date entered Company Descriptive <br />Date <br />9 70-75 6 User entered Effective <br />Date (YYMMDD) <br /> Payment date entered Effective Entry Date <br />10 76-78 3 sp3 sp3 sp3 Settlement Date <br />(Julian) <br />11 79-79 1 ‘1’ ‘1’ ‘1’ Originator Status <br />Code <br />12 80-87 8 <br />p dir_dep_origin_dfi. <br />substring(0,8) <br /> <br />Checking Account <br />dd_origin_dfi. <br />substring(0,8) <br /> <br />Tax Parameter or <br />Utility Parameter <br />dw_origin_dfi. <br />substring(0,8) <br />Originating DFI <br />Identification <br />13 88-94 7 ‘0000001’ ‘0000001’ ‘0000001’ Batch Number <br /> <br />ENTRY DETAIL RECORD <br />Field <br /># Position Size MCSJ Value Used – <br />Payroll <br />MCSJ Value Used – <br />Vendor <br />MCSJ Value Used – <br />Tax/Utility Field Name <br />1 01-01 1 ‘6’ ‘6’ ‘6’ Record Type Code <br />2 02-03 2 <br />If Prempddf Prenote: <br /> ‘S’avings: use ‘33’ <br /> (Prenotification of <br />credit to Savings) <br /> ‘C’hecking: use ‘23’ <br /> (Prenotification of <br />credit to Checking) <br /> <br />If NOT Premddf <br />prenote: <br /> ‘S’avings: use ‘32’ <br /> (Credit to Savings) <br /> ‘C’hecking: use ‘22’ <br /> (Credit to Checking) <br />If Chkmast <br />dd_prenote = Y <br />Savings:33 <br />Checking:23 <br /> <br />Not a Prenote: <br />Savings:32 <br />Checking:22 <br />If Txmast or Utmast <br />dw_prenote = Y <br />Savings:38 <br />Checking:28 <br /> <br />Not a Prenote: <br />Savings:37 <br />Checking:27 Transaction Code <br />3 04-11 8 Prempddf bank_dfi <br />(first 8 characters) <br />Chkmast <br />Dd_Bank_Dfi <br />(first 8 characters) <br />Utmast or Txmast <br />dw_bank_dfi(8) Receiving DFI ABA <br />4 12-12 1 Prempddf bank_dfi <br />(last character) <br />Chkmast <br />Dd_Bank_Dfi <br />(last 8 character) <br />Utmast or Txmast <br />dw_bank_dfi (last <br />character) <br />Check Digit <br />5 13-29 17 Prempddf acct num Chkmast <br />Dd_Account_Num <br />Utmast or Txmast <br />dw_acct_num <br />Bank Account <br />Number