Deposit Reports > Deposit Reports - Numerical Order

Availability

For Format 1, this report must be set up to run weekly on the same day of the week that accounts cycle (DMSCYC). All accounts included in this file must cycle on the same night. It must also be set up to run at monthend.

For Format 2, this report must be set up for Friday and monthend regardless of the cycle code. This format can also process daily if required.

Purpose

The purpose of this program is to create a downloadable file for accounts with a weekly statement cycle (DMSCYC). This file contains cycle records of all history items that appear on a statement. If a cycle goes over a monthend, it will be split into two files. One file will generate at monthend and will contain history from the beginning of the cycle through the end of the month. The second file will generate on the last day of the cycle and will contain history from the first of the month through the last day of the cycle. A user-defined hold code must be set up and put on all accounts that need to be included in the file. A report is generated that contains a dump of the records in the file.

Two formats are available with this report. Format 1 does not include headers between each account. Format 2 includes headers and trailer totals, plus a few additional fields. Your institution will need to make sure your customers can handle the layout before you request this setup.

	Note: Items that are posted the next day will appear on the file according to the “as of” date, not the date of transaction.

GOLDPoint Systems Only: Format 1: This report must be set up to run each week on the last day of the cycle. For example, if the accounts all cycle on Friday, then the When to Run field should be RFRIB. A monthend run must also be set up. The user-defined hold code, found on the accounts to be included in the file, needs to be entered in the first four digits of the Misc Parm field of each setup and must be set up to pull cycle-to-date history. JCL needs to be added to the afterhours and monthend job to put the file into the Data Staging Area. For reruns, the beginning and ending pull date can be entered in the Misc Parm field after the hold code in ccyymmdd format.

Format 2: This report must be set up to run each week on Friday. The when to run field should be RFRIB. A monthend run must also be set up. The user-defined hold code, found on the accounts to be included in the file, needs to be entered in the first four digits of the Misc Parm field of each setup and must be set up to pull cycle-to-date history. JCL needs to be added to the afterhours and monthend job to put the file into the Data Staging Area. For reruns, the beginning and ending pull date can be entered in the Misc Parm field after the hold code in ccyymmdd format. The DZ record should not be used in the setup for this format. This format has been customized to provide all of office nine if the second Misc Parm field is set.

File Layout

The following is the file layout for Format 1 of this record:

WSFREC:	DS:	OCL96:	POSITION:	DESCRIPTION:
WSFRECTP	DS	CL1	1	Record Type “D”
WSFACTO	DS	CL3	3	Office Number
WSFSPCER	DS	CL1	4	Spacer
WSFACTA	DS	CL9	5	Account Number
WSFDESC	DS	CL22	14	History Description
WSFFIL1	DS	CL4	36	Filler
WSFSER#	DS	CL6	40	Check# or Deposit#
WSFTRAM	DS	CL11	46	Tran Amount
WSFTCOD	DS	CL4	57	Tran Code
WSFTRND	DS	CL8	61	Tran Date
WSFCTRL#	DS	CL15	69	Control Number (Will be Blank)
WSFTRNST	DS	CL1	84	Tran Status ‘P’
WSFFIL2	DS	CL1	85	Filler
WSFRNDT	DS	CL8	86	Run Date
WSFRTRN	DS	CL1	94	Carriage Return
WSFFEED	DS	CL1	95	Line Feed

The following is the file layout for Format 2 of this record:

HEADER:	LENGTH:	DESCRIPTION:
Header	2	“01" = Header
Account#	10	OOAAAAAAAD (O-Office A-Account D-Check Digit)
Filler	2	Zeros
Date	8	CCYYMMDD
Filler	72	Zeros
BASIC RECORD:
Basic Record	2	“02" = Basic Record
D = Deposit, W = Withdrawal	1	Tran-Type
A = Ach, B= Book TRF,	1
C = Inclearing, D = Deposit by
Check, I = Interest, W = Wire
Deposit Slip Number or Check#	10	Zero Fill, Right Justify
Description	30
Transaction Amount	11
Transaction Date	8
Statement Date	8
Filler	23	Blanks
TRAILER:
Trailer	1	“99" = Trailer
Trailer # of data records	5	# of Data Records
Total Amounts of Data Records	15	Record Amount
Beginning Balance	11
Ending Balance	11
Filler	50	Zeros

CODE	DESCRIPTION
A = ACH	Torc 305 or 605
B = Book TRF	“TRNS”, “XFER”, “XFR” as first characters in the history description
C = Inclearing	Torc 306, 406, or 606
D = Deposit by check	1120 with a check in number
I = Interest	1710 or 1730
W = Wire	Torc 374 or the word “WIRE” anywhere in the description

Deposit Slip Number	From History description, first 6 digits
Check Number	Check number from history item

Statement Date	Date file is produced

Weekly Statement File PC Download (FPSDR135)

Weekly Statement File PC Download (FPSDR135)