FN 4 ACH Screens

MPSC WIC MIS System FN 4 ACH Screens

MPSC WIC MIS System

Detailed Functional Design Document

FN 4 ACH Screens

Revision Date: April 27, 2017

Maintained by:

Products and company names mentioned herein may be the trademarks or registered trademarks of their respective owners. Unmentioned brands or company names are also respected with their own registered trademarks. Some content may be a direct translation from their Web sites.

Document Revisions

Revision Date / Updated By / Requested By / Description of Revision
12/7/2012 / Ciber Team / MPSC / Amendment 7 Updates
2/2/2016 / Ciber Team / MP User Group / Release 5.3 Updates
4/27/17 / CDP Team / MP User Group / Cover page, header, and footer mods for new M&E contractor

Table of Contents

1 File Viewer 4

2 Draw Transactions 12

3 Draws 16

April 27, 2017 Table of Contents Page 3 of 20

MPSC WIC MIS System FN 4 ACH Screens

1  File Viewer

This screen allows a user to display the Automated Clearing House Origination Reject (ACH OR) file contents received from the EBT Bank. Each file also displays a listing of the vendor’s Auto Reconciliation Files (ARF), the contents of which were processed to enable the creation of the original ACH file that was produced by the EBT Host and the EBT Bank processed.

> Finance > ACH > File Viewer

Control / Description /
ACH File Name / This is the record selector for selecting ACH file records. It contains the ACH file names. The drop-down and spin control allow selection of ACH file records.
Type / Record Selector
Contents / File names
DB Column / ACHOR.FileNm
ACH OR Create Date / This is the create date from the T1 record of the ACH OR file provided by the EBT Bank.
Type / Text Box
Required / No
Length / NA
Validation / Mask of ‘mm/dd/yyyy’
Display Only / Yes / Calculated / No
DB Column / ACHOR.ACHORCreateDtTime
ACH OR Create Time / This is the create time from the T1 record of the ACH OR file provided by the EBT Bank.
Type / Text Box
Required / No
Length / NA
Validation / Mask of ‘hh:mm:ss PM’
Display Only / Yes / Calculated / No
DB Column / ACHOR.ACHORCreateDtTime
ARF XREF Create Date / This is the create date from the header record of the ACH ARF XREF file provided by the EBT Host.
Type / Text Box
Required / No
Length / NA
Validation / Mask of ‘mm/dd/yyyy’
Display Only / Yes / Calculated / No
DB Column / ACHOR.ARFXREFCreateDtTime
ARF XREF Create Time / This is the create time from the header record of the ACH ARF XREF file provided by the EBT Host.
Type / Text Box
Required / No
Length / NA
Validation / Mask of ‘hh:mm:ss PM’
Display Only / Yes / Calculated / No
DB Column / ACHOR.ARFXREFCreateDtTime
ACH OR Effective Entry Date / This is the effective entry date from the ACH OR T5 record.
Type / Text Box
Required / No
Length / NA
Validation / Mask of ‘mm/dd/yyyy’
Display Only / Yes / Calculated / No
DB Column / ACHOR.ACHOREffectiveEntryDt
ACH Effective Entry Date / This is the effective entry date from the original ACH file as produced by the EBT Host.
Type / Text Box
Required / No
Length / NA
Validation / Mask of ‘mm/dd/yyyy’
Display Only / Yes / Calculated / No
DB Column / ACHOR.ACHEffectiveEntryDt
Credit Amount / This is the total file credit amount from the ACH OR T9 record.
Type / Text Box
Required / No
Length / NA
Validation / Mask of $Z,ZZ9.99
Display Only / Yes / Calculated / No
DB Column / ACHOR.CreditAmt
Record Count / This is the record count from the ACH OR T9 record.
Type / Text Box
Required / NA
Length / NA
Validation / Mask of Z,ZZ9
Display Only / Yes / Calculated / No
DB Column / ACHOR.RecordCount
File ID Modifier / This is the File ID modifier from the ACH OR T1 record.
Type / Text Box
Required / NA
Length / NA
Validation / NA
Display Only / Yes / Calculated / No
DB Column / ACHOR.FileIDModifier
Type 1 Reject Code / If present, this is the reject code from the ACH OR Type 1 Record.
Type / Text Box
Required / NA
Length / NA
Validation / Format as ‘9999 xxxx’ – Display length of 20
Display Only / Yes / Calculated / No
DB Column / ACHOR.Type1RejectCd + “ “ + Value from Code ID ‘ACH Reject’
Type 5 Reject Code / If present, this is the reject code from the ACH OR Type 5 Record.
Type / Text Box
Required / NA
Length / NA
Validation / Format as ‘9999 xxxx’ – Display length of 20
Display Only / Yes / Calculated / No
DB Column / ACHOR.Type5RejectCd + “ “ + Value from Code ID ‘ACH Reject’
Details / The data grid is used to view the entry level details. This data is contained in the ACH Entry detail (Type 6) records.
Type / Data Grid
Vendor / This is the vendor from the ACH OR T6 record.
Type / Text Box
Required / NA
Length / Display length of 25
Validation / Format as ‘9999 xxxx’
Display Only / Yes / Calculated / No
DB Column / ACHDetail.VEND_ID
Vendor.FFVendorID + “ “ +
Vendor.StoreName
Txn / This is the transaction code from the ACH OR T6 record.
Type / Text Box
Required / NA
Length / NA
Validation / Mask of 99.
Display Only / Yes / Calculated / No
DB Column / ACHDetail.TransactionCd
Amount / This is the amount from the ACH OR T6 record.
Type / Text Box
Required / NA
Length / Display length of 10
Validation / Mask of $Z,ZZ9.99
Display Only / Yes / Calculated / No
DB Column / ACHDetail.Amount
Route # / This is the receiving Depository financial institution (DFI) routing number (R/T) number and the R/T number check digit from the ACH OR T6 record.
Type / Text Box
Required / NA
Length / NA
Validation / NA
Display Only / Yes / Calculated / No
DB Column / ACHDetail.RecRouteNumber
Account # / This is the receiving DFI account number from the ACH OR T6 record.
Type / Text Box
Required / NA
Length / NA
Validation / Display length of 10
Display Only / Yes / Calculated / No
DB Column / ACHDetail.RecAcctNumber
Trace # / If found, this is the trace number (sequence portion) from the ACH OR T6 record.
Type / Text Box
Required / NA
Length / Format as Z9
Validation / NA
Display Only / Yes / Calculated / No
DB Column / ACHDetail.TraceNr
Reject Code / If found, this is the reject code from the ACH OR Type 6 record.
Type / Text Box
Required / NA
Length / Display length of 30+ (to end of grid border)
Validation / Format as ‘9999 xxxx’
Display Only / Yes / Calculated / No
DB Column / ACHDetail.RejectCd + “ “ + Value from Code ID ‘ACH Reject’
Auto Recon Files (ARF) / The data grid is used to view the Auto Reconciliation Files (ARF) that were processed to create the contents of the ACH files.
Type / Data Grid
Vendor / This is the vendor related to the ARF file.
Type / Text Box
Required / NA
Length / NA
Validation / Format as ‘9999 xxxx’
Display Only / Yes / Calculated / No
DB Column / ARF.ACHOR_ID to ARF.Vend_ID
Vendor.FFVendorID + “ “ +
Vendor.StoreName
ARF File Name / This is the ARF file name.
Type / Text Box
Required / NA
Length / Display length of 12
Validation / NA
Display Only / Yes / Calculated / No
DB Column / ARF.ACHOR_ID to ARF.FileNm
Amount / This is the settlement amount from the ARF file.
Type / Text Box
Required / NA
Length / Display length of 10
Validation / Mask of $Z,ZZ9.99
Display Only / Yes / Calculated / No
DB Column / ARF.ACHOR_ID to ARF.SettleAmt
Create Date / This is the create date from the ARF file.
Type / Text Box
Required / No
Length / NA
Validation / Mask of ‘mm/dd/yyyy’
Display Only / Yes / Calculated / No
DB Column / ARF.ACHOR_ID to ARF.FileCreateDtTime
Create Time / This is the create time from the ARF file.
Type / Text Box
Required / No
Length / NA
Validation / Mask of ‘hh:mm:ss PM’
Display Only / Yes / Calculated / No
DB Column / ARF.ACHOR_ID to ARF.FileCreateDtTime
Business Rules /
1.  Records available for display are limited to the number of past days defined in the system parameter Finance.PastDaysACHHistory. Records are available if ACH OR Effective Entry Date is within the number of parameter days from the current date.
2.  Sort the record selector contents in descending order. The file naming standard places the most recent files at the top of the list.
3.  When hovering over the Reject Code field in the grid, display the Code Long Description from the code table. The CodeType is ACH Reject.
4.  When hovering over each reject code field, display the full text.
5.  Sort the Detail grid by Vendor ID.
6.  Sort the Auto Recon File (ARF) grid by Vendor ID and ARF File Name. The file naming standard places the most recent files of a vendor at the top of the list.
7.  Display ARF XREF Create Date and Create Time “As Is”. This is the date and time that the file was created by the EBT Host whose offset is unknown.
8.  Display ACH OR Create Date and Create Time “As Is”. This is the date and time that the file was created by the EBT Bank whose offset is unknown.

2  Draw Transactions

This screen allows a user to enter deposit and manual adjustment transactions as part of the overall draw process related to paying vendor ACH claims (ACH file basis).

> Finance Management > ACH > Draw Transactions

Control / Description /
Apply Date / This is the record selector for the ACH draw transaction records containing the date that the transaction record was applied to the draw process. This date allows the user to display the fiscal year to which the transaction applies. The drop-down and spin control allow selection of draw transaction records.
Type / Record Selector (Date)
Contents / Dates
DB Column / ACHDrawTransaction.ApplyDt
New / The New command button is used to create an ACH draw transaction record.
Type / Command Button
Hot Key / Alt + N
Edit / The Edit command button is used to update an ACH draw transaction record.
Type / Command Button
Hot Key / Alt + T
Delete / The Delete command button is used to delete an ACH draw transaction record.
Type / Command Button
Hot Key / Alt + D
Transaction Type / This is the type of draw transaction.
Type / List Box
Required / Yes
DB Column / ACHDrawTransation.TypeCd
Code ID / Draw Type
This code element is non-editable.
The installed values are:
Line of Credit Deposit
Rebate Deposit
Manual Adjustment
Amount / This is the amount of the transaction.
Type / Text Box
Required / Yes
Length / Decimal 12.2
Validation / Mask of ($Z,ZZ9.99)
Display Only / No / Calculated / No
DB Column / ACHDrawTransaction.Amount
Rebate From Date / For a Rebate Deposit, this date identifies the month covered by the rebate check (This date is usually about three months earlier than the current date).
Type / Date Picker
Required / Conditional based on Transaction Type (See BRs 6 and 7.)
Display Only / No / Calculated / No
DB Column / ACHDrawTransaction.RebateFromDt
Manual Adjustment Reason / This is the reason for the manual adjustment.
Type / Text Box
Required / Conditional based on Transaction Type (see BR)
Length / 100
Validation / None
Display Only / No / Calculated / No
DB Column / ACHDrawTransaction.ManAdjReason
Comment / This is for any comment regarding this transaction.
Type / Text Box
Required / No
Length / 100
Validation / None
Display Only / No / Calculated / No
DB Column / ACHDrawTransaction.Comment
<Last Modified By User and Date> / In the lower right-hand corner, the user and the date of the last update of the ACH draw record are displayed.
Type / Text Box
Required / No
Length / NA
Validation / Mask of ‘firstname lastname mm/dd/yyyy’
Display Only / Yes / Calculated / No
DB Column / ACHDrawTransaction.ModifyStfpID
ACHDrawTransaction.ModifyDt
Business Rules /
1.  Records available for display are limited to the number of past days defined in the system parameter Finance.PastDaysACHHistory. Records are available if Apply Date is within the number of parameter days from the current date.
2.  Sort the record selector contents in descending order (most recent first).
3.  Display an error message if the Amount entered is zero.
4.  Display an error message if the Transaction Type is Line of Credit Deposit or Rebate Deposit and the Amount is less than zero.
5.  Display an error message if the Transaction Type is Rebate Deposit and the Rebate From Date is not entered. This date is used to designate which month was covered by the rebate. This date is usually three months from the current date. (There is no edit applied to this date.)
6.  If Transaction Type of Line of Credit Deposit or Manual Adjustment is selected, clear out and disable the Rebate From Date.
7.  If Transaction Type is Line of Credit Deposit clear out and disable the Rebate From Date and Manual Adjustment Reason.
8.  If Transaction Type is Rebate Deposit clear out and disable the Manual Adjustment Reason.
9.  If Transaction Type is Manual Adjustment clear out and disable the Rebate From Date.
10. Display an error message if the Transaction Type is Manual Adjustment and the Manual Adjustment Reason is not entered.
11. If Transaction Type of Line of Credit Deposit or Rebate Deposit is selected, clear and disable the Manual Adjustment Reason.

3  Draws

This screen allows a user to manage the draws related to each ACH file. The screen shows the calculated balances for all ACH, Line of Credit and Rebate Amounts.