pstemkens
commented
6 months ago From BCONLIN_BILLING_RECORD table in CPRD pull in the following fee codes:
Name Fee code
Government Agents ADJ-DPAD
Other
Electronic Payments
EFT's EFT
EDI's OLBPYMT
Direct Deposits DIRPYMT
GA DIRPYMT
CSO
Adjustment DPAD
EJV EJVPYMT
Adjustments to Unearned Revenue
Returned Items ADJ-RCHQ
Refunds
In the recent past, we create a page that compares the deposits in the Piranha reports to the BCOL billing records.
Finance has provided more details regarding what info they need.
From BConline_billing_record table, we should be able to pull in all the data to be able to reconcile the Trust acct. This view will be able to replace the mainframe reports that are sent to FIN daily, monthly.