Laserfiche WebLink
5 <br />Identification <br />11 88-94 7 ‘0000001’ ‘0000001’ ‘0000001’ Batch Number <br /> <br /> <br /> <br />ALL ENTRIES FILE CONTROL RECORD <br />Field# 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 ‘9’ ‘9’ ‘9’ Record Type Code <br />2 02-07 6 ‘000001’ ‘000001’ ‘000001’ Batch Count <br />3 08-13 6 <br />The number of <br />blocks written in this <br />file. A block is <br />composed of 10 <br />records. var: <br />wrkBlkCnt <br />Same as payroll Same as payroll <br />Block Count <br />4 14-21 8 <br />Count of detail and <br />addenda records <br />written <br />(var: writtenCount) <br />Same as payroll Same as payroll <br />Entry/Addenda <br />Count <br />5 22-31 10 <br />Sum of Payroll <br />Parameter bank_dfi <br />(from each detail <br />record) <br />and Payroll <br />Parameter <br />dir_dep_pay_dfi <br />(debit detail record) <br />-if length of sum > 10 <br />chars then use the <br />substring of the last <br />10 chars in the <br />number. <br /> Sum of <br />Utmast/Txmast <br />bank_dfi (from each <br />detail record) <br />and Tax <br />Parameter/Utility <br />Parameter <br />dw_pay_dfi (credit <br />detail record) <br />-if length of sum > 10 <br />chars then use the <br />substring of the last <br />10 chars in the <br />number. <br />Entry Hash <br />6 32-43 12 <br />If Payroll Parameter <br />dir_dep_incl_db = ‘Y’ <br />then include the <br />total of Prempddf <br />value amounts from <br />the detail records <br />(var: workTotDep) <br />else ‘000000000000’ <br />If Checking Account <br />dd_incl_db = ‘Y’ then <br />include the total of <br />Chkmast value <br />amounts from the <br />detail records <br />Total of all payments <br />Total Debit Entry <br />Dollar Amount In File <br />7 44-55 12 <br />Total of Prempddf <br />value amounts from <br />the detail records <br />(var: workTotDep) <br />Total of Chkmast <br />value amounts from <br />the detail records <br />If include credit: total <br />of all payments Total Credit Entry <br />Dollar Amount In File <br />8 56-94 39 sp39 sp39 sp39 Reserved <br /> <br />• “Nine Record”s: (string of 9’s 94 chars long). <br />o Payroll – must check “End of File 9 Record Blocking” <br />o Tax/Utility - always included for Tax and Utility <br />• The number of “nine records” written is based on a calculation. The wrkBlkCnt (int) is divided by ten and if it doesn’t <br />divide evenly, then add one (rounding up to next whole number). The number of numOfNineRecords written is the <br />(wrkBlkCnt *10) – the original wrkBlkCnt so as to fill up the remaining record spaces in the last block, i.e. making the <br />total number of records evenly divisible by 10. <br /> <br />• NOTE: Tax File: would need to prompt for Misc.Charge payment code and 6% Penalty payment code to include <br />Misc.Charges and 6% in the file. <br />