DOR Agency Deposit Report (ARR070)
- 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
DOR Agency Deposit Report (ARR070)
- Updated on 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
This report was implemented in CMS Wave and will be updated in Financials Wave. The information in this article is the planned design for Financials Wave.
The purpose of this report is to provide detailed information for all agency deposit transactions that have been entered in Florida PALM by the Department of Revenue (DOR). This report is used to review the detailed deposit and accounting data entered by DOR on behalf of the agencies.
Agency use of this report is to obtain the accounting information that DOR entered on their behalf and analyze the accounting data for reclassification purposes if needed.
Additional fields for Financial Segment: New ChartFields, Supplier ID, Asset ID Reference, AR Item, and Customer.
Report Navigation: Main Menu>Reporting Tools>Query>Query Viewer>FLP_DOR_AGEN_REPORT
Query Name: FLP_DOR_AGEN_DEP_REPORT
See the sample layout report below.
Business Roles
The following business roles have access to this report:
- Agency AR Deposit Processor
- Agency AR Deposit Spreadsheet Upload Processor
- Agency AR Deposit Approver
- Agency AR Deposit Reporter
- DFS CM Bank Reconciliation Processor
- DFS Same Day Deposit Approver
- DFS AR Deposit Processor
Business Process Models
This report can be found in the following business processes:
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
GL Business Unit | Required; Business Unit prompt with security. Prompt should have 'All' or '%' option to select. If '%' is selected, the report should extract data from all the business units that the User has access to. |
From Date and To Date | Required; Distribution Accounting Date |
Agency Deposit Number | Optional; No edit |
Deposit ID | Optional; No edit |
Deposit Type | Optional; Deposit Type prompt |
Payment ID | Optional; No edit |
Reconciliation Status | Status: Reconciled, Unreconciled; Edit |
Control Total Amount | Optional; No Edit |
Payment Amount | Optional; No Edit |
Distribution Amount | Optional; No Edit |
Organization | Optional; Organization prompt |
Account | Optional; Account prompt |
Fund Code | Optional; Fund Code prompt |
Budget Entity | Optional; Budget Entity prompt |
Category | Optional; Category prompt |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
GL Business Unit | PAY_MISC_DST.BUSINESS_UNIT_GL |
Organization | PAY_MISC_DST.DEPTID |
Account | PAY_MISC_DST.ACCOUNT |
Fund | PAY_MISC_DST.FUND_CODE |
Budget Entity | PAY_MISC_DST.BUDGET_REF |
Category | PAY_MISC_DST.PRODUCT |
State Program | PAY_MISC_DST.CHARTFIELD2 |
Grant | PAY_MISC_DST.PROGRAM_CODE |
Contract | PAY_MISC_DST.CHARTFIELD1 |
OA1 | PAY_MISC_DST.CLASS_FLD |
OA2 | PAY_MISC_DST.CHARTFIELD3 |
PC Business Unit | PAY_MISC_DST.BUSINESS_UNIT_PC |
Project | PAY_MISC_DST.PROJECT_ID |
Activity | PAY_MISC_DST.ACTIVITY_ID |
PC Source Type | PAY_MISC_DST.RESOURCE_TYPE |
PC Category | PAY_MISC_DST.RESOURCE_CATEGORY |
PC Subcategory | PAY_MISC_DST.RESOURCE_SUB_CAT |
Distribution Amount | PAY_MISC_DST.FOREIGN_AMOUNT |
Budget Date | PAY_MISC_DST.BUDGET_DT |
Budget Status | PAY_MISC_DST.BUDGET_LINE_STATUS (Translate Value) |
Asset ID Reference | CUSTOM_TABLE.ASSET_ID |
Supplier ID | CUSTOM_TABLE.SUPPLIER_ID |
Customer ID | PAYMENT_ID_CUST.CUST_ID |
Verified Date | CUSTOM_TABLE.VERIFIED_DT |
Verified By | CUSTOM_TABLE.VERIFIED_BY |
Accounting Date | PAY_MISC_DST.ACCOUNTING_DT |
Approval Status | FLP_DIJRNL_TBL.APPROVAL_STATUS (Translate Value) |
Combo Edit Status | PAY_MISC_DST.CF_EDIT_STATUS (Translate Value) |
Budget Status | PAY_MISC_DST.BUDGET_LINE_STATUS (Translate Value) |
GL Distribution Status | PAY_MISC_DST.GL_DISTRIB_STATUS (Translate Value) |
Line Description | PAY_MISC_DST.LINE_DESCR |
Journal ID | PAY_MISC_DST.JOURNAL_ID |
Journal Date | PAY_MISC_DST.JOURNAL_DATE |
Created On | PAY_MISC_DST.ENTERED_DTTM |
Created By | PAY_MISC_DST.OPRID |
Last Modified On | PAY_MISC_DST.LAST_UPDATE_DTTM |
Modified By | PAY_MISC_DST.OPRID_LAST_UPDT |
Deposit BU | DEPOSIT_CONTROL.DEPOSIT_BU |
Agency Deposit Number | FLP_DEP_NUM_TBL.FLP_AGEN_DEP_NO |
Deposit ID | DEPOSIT_CONTROL.DEPOSIT_ID |
Deposit Type | DEPOST_TYPE_TBL.DESCR |
Bank Code | DEPOSIT_CONTROL.BANK_CD |
Bank Account Key | DEPOSIT_CONTROL.BANK_ACCT_KEY |
Bank Account # | DEPOSIT_CONTROL.BANK_ACCOUNT_NUM |
Control Total Amount | DEPOSIT_CONTROL.CONTROL_AMT |
Control Count | DEPOSIT_CONTROL.CONTROL_CNT |
Deposit Accounting Date | DEPOSIT_CONTROL.ACCOUNTING_DT |
Received Date | DEPOSIT_CONTROL.RECEIVED_DT |
Entered Date | DEPOSIT_CONTROL.ENTERED_DT |
Reconciliation Status | PAYMENT.RECON_STATUS (Translate Value) |
Reconciliation Date | PAYMENT.RECONCILE_DT |
Statement ID | PAYMENT.RECON_CYCLE_NBR |
User ID | DEPOSIT_CONTROL.OPRID |
Assigned To | DEPOSIT_CONTROL.ASSN_OPRID |
Payment ID | PAYMENT.PAYMENT_ID |
Payment Amount | PAYMENT.PAYMENT_AMT |
Payment Status | PAYMENT.PAYMENT_STATUS (Translate Value) |
Version History
Date | Revision Description |
12/01/2023 | Original Version |
Was this article helpful?
