October 2017 Updated for patch PRCA*4.5*318 This patch removed a lock from the option RCDPE EDI NATIONAL REPORTS. Added locks to several options under the RCDPE NR EXTRACT MENU. Added routines associated with the “Auto Decrease Report”, “Daily Activity Report”, and a new report “Auto Posted Receipt Report”. Added new DBIA #6747. Added description for “Unapplied EFT Deposit Report” (that was removed previously by accident) and the new report referenced above. Tony Barraza Robert Kagels September 2017 Updated for patch, PRCA*4.5*327: This patch features functionality that sends two new mail messages to the 'TCSP' mail group when a batch run is completed and when a corrupt debt occurs. See pages: , , , Darryle Jones April Sessler July 2017 Updated for patch PRCA*4.5*325: This patch converts all scripts for handling Treasury Cross Service Project (TCSP) exceptions between Vista and Treasury to user option with improved controls. These scripts were provided to sites by the TCSP developers to handle mismatched Vista debtor/bills with the Treasury status for the same debtor/bills. See pages: , , Darryle Jones/Rishan Chandarana April Sessler
Billing Document Inquiry [PRCA FMS BILL INQ] This option is used to view the status of a detail bill sent to FMS Regenerate Prior Month OBR [PRCA FMS OBR MANUAL TRANS] This option recreates and sends the Outstanding Bill Reconciliation report to the local user’s group. Transaction Inquiry [PRCA FMS TRANS INQ] This option is used display the FMS status for an A/R transaction. Unprocessed Document List [PRCA FMS UNPROCESSED LIST] This option will print a list of FMS documents that have been updated three or more days ago. FMS Cash Receipt Reconciliation (132 column) [PRCA FMS DOC/RECPT COMPAR] This report is to print all receipts for a deposit, and gives total for each fund under the deposit within a particular status. FMS Regeneration Menu [PRCA FMS REGENERATION] This option is the top-level menu for regenerating FMS documents to Austin. Billing Document Regeneration [PRCA FMS BD REGEN] This option regenerates a FMS document rejected in Austin. Edit FMS Accounting Elements [PRCA FMS ACCT EDIT] This option is used to edit the accounting line information on FMS billing documents. Modified Billing Document Regeneration [PRCA FMS MBD REGEN] This option regenerates a modified billing document that rejected in Austin National Data Base Document Regeneration [PRCA FMS NDB REGEN] This option is used to regenerate FMS national data base documents. Overpayment (OP) Document Regeneration [PRCAT FMS OP REGEN] This option will allow a user to retransmit a "rejected" OP document. It will only allow the retransmission of an OP document that has actually been refunded in the AR package and has been rejected by FMS. Regenerate FMS Cash Receipt Document [PRCA FMS CASH RECEIPT] This option is to re-create and re-transmit the Cash Receipt Documents. Remove invalid SUB BOC [PRCA FMS SBOC] This option is used to remove an INVALID SUB BOC from a rejected FMS document.
430.3^B This cross-reference is used for sorting and file look-up by the AR Transaction Type. 430.3^C This cross-reference is used for look-up and sorting transaction types by Abbreviation. 430.3^AC^MUMPS This cross-reference is used for look-up by Status Number. 430.4^B This cross-reference is used for sorting and file look-up by the AR Bill Number. 430.4^C^MUMPS This cross-reference is used for sorting and file look-up by AR bill number (without the station number prefix.). 430.5^B This cross-reference is used for sorting and file look-up by AR Parameter. 430.5^C This cross-reference is used for file look-up and sorting by the AR Parameter Type field. 430.5^AC This cross-reference is used for look-up by the Number of Letters field. 430.6^B This cross-reference is used for sorting and file look-up by AR Debt List. 430.6^C This cross-reference is used for look-up and sorting by the Full Name field. 430.6^D This cross-reference is used for look-up and sorting by the AR Debt List Type field. 430.7^B This cross-reference is used for sorting and file look-up by AR Debt Collector Data Month/Year of report. 430.71^B This cross-reference is used for look-up by the AR Bill Number. 430.7^AC This cross-reference is used to sort the bills for printing the ARDC Report. 430.8^B This cross-reference is used for look-up and sorting by Identifier.
4 User ID 6A VAR User identification 5 Line No 3A VAR 001-999 6 ERR Code 1 5A VAR First error code 7 ERR Message 1 30A VAR First error message 8 ERR Code 2 5A VAR Second error code 9 ERR Message 2 30A VAR Second error message 10 ERR Code 3 5A VAR 11 ERR Message 3 30A VAR 12 ERR Code 4 5A VAR 13 ERR Message 4 30A VAR 14 ERR Code 5 5A VAR 15 ERR Message 5 30A VAR 16 ERR Code 6 5A VAR 17 ERR Message 6 30A VAR 18 ERR Code 7 5A VAR 19 ERR Message 7 30A VAR 20 ERR Code 8 5A VAR 21 ERR Message 8 30A VAR 22 ERR Code 9 5A VAR 23 ERR Message 9 30A VAR 24 ERR Code 10 5A VAR 25 ERR Message 10 30A VAR RECONCILIATION DOCUMENT CONTROL SEGMENT # Field Name Value Value Status Description 1 Segment ID CTL HC Segment Identifier 2 Source System FMS HC Source system identification 3 Destination System ARS HC Destination system identification 4 Submitting Station 3A VAR IFCAP Station 5 Transaction Class OBR HC Outstanding Bill Reconciliation Statement 6 Transaction Code Null HC 7 Sec1 Code Null HC 8 Batch Number Null HC 9 Transaction Number 11A VAR Station(3) + Fiscal Year(1) + K + Sequential(5) + 0 10 Transaction Date 8N VAR Calendar date document created (YYYYMMDD) 11 Transaction Time 6N VAR Time document created (HHMMSS) 12 Sequence Number 3N VAR Transaction part Sequence Number of Sequence Total 13 Sequence Total 3N VAR Total number of transaction parts 14 Version 3A VAR IFCAP-FMS Interface Version