Check Image Load
Check Image Load (CHIMGLD) is used to track check images that are pending attachment to the appropriate Paid Check record. Records are loaded by the CHIMGLD Load job step of the Check Image Recon Chain process. Records are marked as Attached when the check image is attached to the corresponding Paid Check with Attachment (PDCHAT) record created by the Check Image Recon Chain. The process does not mark the record as Attached if no corresponding Paid Check (PDCHK) record is found to attach the check image file, and that record is considered an exception.
The Check Image Load page consists of the following fields:
|
Field Name |
Description |
|
Bank Account |
The Bank Account code associated with the check image is loaded by the batch parameter in the Check Image Recon process. Should be a valid value in the Bank table. |
|
Check |
Check number field associated with the check image. The value is updated by the Bank Index file loaded by the Check Image Recon process. |
|
Attachment Status |
A field to state the status of the check image file.
|
|
Amount |
Amount associated with the check image. The value is updated by the Bank Index file loaded by the Check Image Recon process. |
|
Load Date |
A date field of the bulk image index file record added to the table. The date is updated by the Check Image Recon process upon execution. |
|
Index File Name |
The field is updated with the Index file name provided in batch parameter of the Check Image Recon process. |
|
Image Date |
A field to state the date of the check image. The date is updated by the Check Image Recon process upon execution. |
|
Image Key |
Unique key field updated from the index file loaded by the Check Image Recon process. The field is used to derive the check image file name. The Sequence of the key in the index file from the bank is as follows: Capture.Cycle Code.Date.SequenceNumber. Sample: ELRC.C01.Y2004.MD0524.S91300.S02160 |
|
Image File Location |
A field to state the file folder location of the check image file. |
|
Check Image File Name |
A derived name of the check image file. Name is derived from image Key in the index file. Format is as follows: YYYYMMDDSSSSSSSSSSCC.tiff. Where Y: Year, M: Month, D: Date, S: Sequence Number, C: Cycle code |
Refer to CGI Advantage Accounts Payable Run Sheets Guide for information on the Check Image Recon chain process and details on the CHIMGLD table record processing.
Check Exception (CHEXCP)Check Exception (CHEXCP)
The Check Exception table is used to store records of disbursements that are not successfully matched with a bank's record during the automated Check Reconciliation process. Each record on the Check Exception (CHKEXCP) table includes a corresponding Exception Code and Exception Reason, indicating what caused the record to fail during the reconciliation process.
Conditions that cause a disbursement to be written to the exception table include:
-
Instrument Not Found in Financial System (the check information sent by the bank cannot be located in the Advantage application)
-
Bank Amount Greater than Book Amount (from system's records on the Check Reconciliation table)
-
Book Amount (from system's records on the Check Reconciliation table) Greater than Bank Amount
-
Check Cancelled in Financial System
-
Check Stale Dated, Escheated, or Voided in Financial System
-
Record Deleted from Exception Table
-
Non-Sufficient funds
-
Check Stopped in Financial System
-
Check Undeliverable in Financial System
Paid Checks (PDCHK)Paid Checks (PDCHK)
The Check Reconciliation process moves records from the Check Reconciliation table to the Paid Checks table if the Cleared Date is populated and the Status is not Disbursed/ Warranted. Records are moved to the Paid Checks table with their current Status (for example, Paid or Cancelled) on the Check Reconciliation table. All fields of this table are protected. Records can only be moved from the Paid Checks table to the Check Reconciliation table, by using the Move to CHREC action on the Paid Check Restore Mass Update page. Please refer to "Paid Check Restore" topic or the "Restore a Record on Paid Check Restore" topic for more information.
Paid Checks with Attachements (PDCHKAT)Paid Checks with Attachements (PDCHKAT)
This page replicates the Paid Check (PDCHK) page with an additional Attachment field where single or multiple check images can be manually uploaded.
Please refer to the "Paid Checks with Attachments" topic for more information.
Check Image Load (CHIMGLD)Check Image Load (CHIMGLD)
Check Image Load is used to track check images that are pending attachment to the appropriate Paid Check record.
Please refer to the "Check Image Load (CHIMGLD)" topic for more information.
Records are loaded by the CHIMGLD Load job step of the Check Image Recon Chain process. Records are marked as Attached when the check image is attached to the corresponding Paid Check with Attachment (PDCHAT) record created by the Check Image Recon Chain. The process does not mark the record as Attached if no corresponding Paid Check (PDCHK) record is found to attach the check image file, and that record is considered an exception.
The Check Image Load consist of the following fields:
|
Field Name |
Description |
|
Bank Account |
The Bank Account code associated with the check image is loaded by the batch parameter in the Check Image Recon process. Should be a valid value in the Bank table. |
|
Check |
Check number field associated with the check image. The value is updated by the Bank Index file loaded by the Check Image Recon process. |
|
Attachment Status |
A field to state the status of the check image file.
|
|
Amount |
Amount associated with the check image. The value is updated by the Bank Index file loaded by the Check Image Recon process. |
|
Load Date |
A date field of the bulk image index file record added to the table. The date is updated by the Check Image Recon process upon execution. |
|
Index File Name |
The field is updated with the Index file name provided in batch parameter of the Check Image Recon process. |
|
Image Date |
A field to state the date of the check image. The date is updated by the Check Image Recon process upon execution. |
|
Image Key |
Unique key field updated from the index file loaded by the Check Image Recon process. The field is used to derive the check image file name. The Sequence of the key in the index file from the bank is as follows: Capture.Cycle Code.Date.SequenceNumber. Sample: ELRC.C01.Y2004.MD0524.S91300.S02160 |
|
Image File Location |
A field to state the file folder location of the check image file. |
|
Check Image File Name |
A derived name of the check image file. Name is derived from image Key in the index file. Format is as follows: YYYYMMDDSSSSSSSSSSCC.tiff. Where Y: Year, M: Month, D: Date, S: Sequence Number, C: Cycle code |
Refer to CGI Advantage Accounts Payable Run Sheets Guide for information on the Check Image Recon chain process and details on the CHIMGLD table record processing.
Check Exception ReportCheck Exception Report
This report lists all records and corresponding exception codes resulting from the automated Check Reconciliation process.
For more on the Check Reconciliation process, please refer to the CGI Advantage Accounts Payable Run Sheets guide for Check Reconciliation chain jobs.
Check Exception Control Totals ReportCheck Exception Control Totals Report
This report summarizes the number of records reconciled and the exception records that were generated by the current run of the Check Reconciliation process.
For more on the Check Reconciliation process, please refer to the CGI Advantage Accounts Payable Run Sheets guide for Check Reconciliation chain jobs.
Warrant Reconciliation Transaction Exception ReportWarrant Reconciliation Transaction Exception Report
The Warrant Reconciliation Transaction Exception Report provides a list of the Warrant Reconciliation transaction records that was not submitted to Final generated by the current run of the Generate Warrant Reconciliation Transaction process.
For more on the Generate Warrant Reconciliation Transaction process, please refer to the CGI Advantage Accounts Payable Run Sheets guide for Check Reconciliation chain jobs.
