Process Checks To CDEX - REV257

This program allows you to transmit check_register data from Excalibur to the Check Stub Data Exchange (CDEX). Use the CDEX system to receive check stub data into Excalibur.

The implementation of the CDEX Transmit feature in Revenue requires some data entry. After you enter all of your data, you can successfully process checks to CDEX at any time.

1. Use the Owner Detail (REV120) program to assign a CDEX receiver company code to an owner whose check stub data you want to transmit, and to assign the owner's CDEX exchange service.

2. Use the Product Codes (REV151) program to assign CDEX codes to the Excalibur product codes.

3. Use the Component Codes (REV125) program to assign CDEX transaction codes to Excalibur components.

This program also selects check_register items and writes data into the CRSEND directory for subsequent transmission to GE, or to the PCRSEND directory for subsequent transmission to PETROLIS.COM. When you run (REV257), you can select check_register records in several ways. The following selection criteria only applies to the owners with CDEX Transmit IDs, and for one company company_master ID):

1. You can process selectively from records not yet transmitted. When you select this option, the process prompts for the check date range and owners. You can enter one owner ID, several owner IDs, or "All". All check_register records processed are updated with a CDEX_SEND_DATE.

2. You can process any record(s) already transmitted. When you select this option, the process prompts you for the check date range and owners. You can enter one owner ID, several owner IDs, or "All". You can only select the items that were previously processed. All checks are updated with a new CDEX_SEND_DATE.

3. You can transmit all records not previously processed. No other selection criteria are requested when you select this option.

(REV257) executes the following steps:

1. It sets a batch lock so that only one person at a time can run the process.

2. It prompts you for selection criteria, selects CHECK_REGISTER items, and creates a savedlist named REV257.

3. It processes the list of checks to the intermediate file, ge_cr_send. The system clears this file before it repopulates it.

4. A Uniquery report of the CHECK_REGISTER items from the savedlist prints.

5. Detail and summary reports of items in the intermediate file, ge_cr_send, print. Use these three reports to verify data written.

6. (REV258) updates the sequential file, CRSEND_MASTER (GE transmission) or PCRSEND (PETROLIS.COM transmission) with the data in the required format.

7. The process releases the batch lock.

When the process is finished, you must transmit the data to your CDEX exchange service for processing.

If any errors occur during the processing of check_register items, (REV257) displays an error message on your screen and sends the same message to the printer. The program also clears the intermediate file so that erroneous data is kept from the final transmission. You must resolve these errors and reprocess the data.

It is your responsibility to delete transmissions in the CRSEND_MASTER and PCRSEND directories when you no longer need them. The system clears the intermediate file, ge_cr_send, each time this program is run.