-
Print
-
DarkLight
-
PDF
Deposit Report (ARR007)
-
Print
-
DarkLight
-
PDF
Report Description
The purpose of this query is to provide detailed information for all agency deposits that have been entered in Florida PALM whether through an interface, Spreadsheet Upload, or manual entry. Agency and DFS employees will use this query to inquire on all deposit statuses. This report is used to account for deposit transactions reconciled/unreconciled within Florida PALM, including additional addenda information provided by the bank for returned items. The Deposit Report will display all deposit transactions that exist in Florida PALM including the status. Query has ability for varied date(s).
Additional fields for Financial Segment: New ChartFields, Supplier ID, Asset ID Reference, AR Item, and Customer.
Report Navigation: MainMenu>Reporting Tools>Query>Query Viewer
Query Name: FLP_Deposit_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 |
Deposit BU | Required; Business Unit prompt with security. Prompt should have βAllβ or β%β option to select. If selected, the report should extract data from all the business units that the user has access to. |
From Date and To Date | Required; Deposit Accounting Date |
Deposit ID | Optional; No edit |
Agency Deposit Number | Optional; No edit |
Bank Code | Optional; Bank Code prompt |
Bank Account # | Optional; Bank Account # prompt |
Deposit Type | Optional; Deposit Type prompt |
Payment ID | Optional; No edit |
Reconciliation Status | Default/All, Reconciled, Unreconciled, Edit |
Deposit 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 |
Grant | Optional; Grant prompt |
OA1 | Optional; OA1 prompt |
OA2 | Optional; OA2 prompt |
Project | Optional; Project prompt |
Customer ID | Optional; Customer ID prompt |
Item ID | Optional; Item ID prompt |
Supplier ID | Optional; Supplier ID prompt |
Asset ID Reference | Optional; Asset ID prompt |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
Deposit Unit | DEPOSIT_CONTROL.DEPOSIT_BU |
Deposit Accounting Date | DEPOSIT_CONTROL.ACCOUNTING_DT |
Deposit ID | DEPOSIT_CONTROL.DEPOSIT_ID |
Agency Deposit Number | FLP_DEP_NUM_TBL.FLP_AGEN_DEP_NO |
Deposit Type | DEPOSIT_CONTROL.DEPOSIT_TYPE |
Deposit Type Description | 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 Amt | DEPOSIT_CONTROL.CONTROL_AMT |
Control Count | DEPOSIT_CONTROL.CONTROL_CNT |
Reconciliation Status | PAYMENT.RECON_STATUS (Translate Value) |
Reconciliation Date | PAYMENT. RECONCILE_DT |
Statement ID | PAYMENT.RECON_CYCLE_NBR |
Received Date | DEPOSIT_CONTROL. RECEIVED_DT |
Entered Date | DEPOSIT_CONTROL. ENTRY_DT |
User ID | DEPOSIT_CONTROL.OPRID |
Assigned To | DEPOSIT_CONTROL.ASSN_OPRID |
Approval Status | FLP_DRJRNL_TBL.APPROVAL_STATUS |
Payment ID | PAYMENT.PAYMENT_ID |
Payment Amount | PAYMENT.PAYMENT_AMT |
Journal Directly | PAYMENT.MISC_PAYMENT |
Payment Status | PAYMENT.PAYMENT_STATUS (Translate Value) |
GL Distribution Status | PAY_MISC_DST.GL_DISTRIB_STATUS ITEM_DST. GL_DISTRIB_STATUS |
Payment Sequence | PAYMENT.PAYMENT_SEQ_NUM |
Payment Predictor | PAYMENT.PP_SW |
Customer ID | PAYMENT_ID_CUST.CUST_ID |
Item ID | PAYMENT_ID_ITEM.ITEM |
Item Line | PAYMENT_ID_ITEM.ITEM_LINE |
Budget Period | PAY_MISC_DST.BUDGET_DT ITEM_DST. BUDGET_DT |
GL Business Unit | PAY_MISC_DST.BUSINESS_UNIT_GL ITEM_DST. BUSINESS_UNIT_GL |
Organization | PAY_MISC_DST.DEPTID ITEM_DST. DEPTID |
Account | PAY_MISC_DST.ACCOUNT ITEM_DST. ACCOUNT |
Fund | PAY_MISC_DST.FUND_CODE ITEM_DST.FUND_CODE |
Budget Entity | PAY_MISC_DST.BUDGET_REF ITEM_DST.BUDGET_REF |
Category | PAY_MISC_DST.PRODUCT ITEM_DST.PRODUCT |
State Program | PAY_MISC_DST.CHARTFIELD2 ITEM_DST.CHARTFIELD2 |
Grant | PAY_MISC_DST.PROGRAM_CODE ITEM_DST. PROGRAM_CODE |
Contract | PAY_MISC_DST.CHARTFIELD1 ITEM_DST. CHARTFIELD1 |
OA1 | PAY_MISC_DST.CLASS_FLD ITEM_DST.CLASS_FLD |
OA2 | PAY_MISC_DST.CHARTFIELD3 ITEM_DST. CHARTFIELD3 |
PC Business Unit | PAY_MISC_DST.BUSINESS_UNIT_PC ITEM_DST.BUSINESS_UNIT_PC |
Project | PAY_MISC_DST.PROJECT_ID ITEM_DST.PROJECT_ID |
Activity | PAY_MISC_DST.ACTIVITY_ID ITEM_DST.ACTIVITY_ID |
PC Source Type | PAY_MISC_DST.RESOURCE_TYPE ITEM_DST.RESOURCE_TYPE |
PC Category | PAY_MISC_DST.RESOURCE_CATEGORY ITEM_DST. RESOURCE_CATEGORY |
PC Subcategory | PAY_MISC_DST.RESOURCE_SUB_CAT ITEM_DST. RESOURCE_SUB_CAT |
Distribution Amount | PAY_MISC_DST.FOREIGN_AMOUNT ITEM_DST. FOREIGN_AMOUNT |
Budget Status | PAY_MISC_DST.BUDGET_LINE_STATUS (Translate Value) |
Asset ID Reference | CUSTOM_TABLE.ASSET_ID ITEM.DOCUMENT |
Supplier ID | CUSTOM_TABLE.SUPPLIER_ID ITEM.BILL_OF_LADING |
Verified Date | CUSTOM_TABLE.VERIFIED_DT |
Verified By | CUSTOM_TABLE.VERIFIED_BY |
ChartField Combo Edit Status | PAY_MISC_DST.CF_EDIT_STATUS (Translate Value) |
Line Description | PAY_MISC_DST.LINE_DESCR ITEM_DST.LINE_DESCR |
Journal ID | PAY_MISC_DST.JOURNAL_ID ITEM_DST.JOURNAL_ID |
Journal Date | PAY_MISC_DST.JOURNAL_DATE ITEM_DST. JOURNAL_DATE |
Created On | PAY_MISC_DST.ENTERED_DTTM ITEM_DST. ENTERED_DTTM |
Created By | PAY_MISC_DST.OPRID ITEM_DST. OPRID |
Last Modified On | PAY_MISC_DST.LAST_UPDATE_DTTM ITEM_DST. LAST_UPDATE_DTTM |
Modified By | PAY_MISC_DST.OPRID_LAST_UPDT ITEM_DST. OPRID_LAST_UPDT |
Immediate Origin | FLP_ACH_NOC_HDR.FLP_BOA_IMMED_ORG |
Company Name | FLP_ACH_NOC_HDR.FLP_BOA_COMP_NAME |
Company ID | FLP_ACH_NOC_HDR.FLP_BOA_COMPANY_ID |
Service Class Code | FLP_ACH_NOC_HDR.FLP_SERV_CLS_CD |
Company Discretionary Data | FLP_ACH_NOC_HDR.FLP_CMP_DISCR_DATE |
Company Entry Description | FLP_ACH_NOC_HDR.FLP_BOA_CO_ENT_DES |
SEC Code | FLP_ACH_NOC_HDR.FLP_BOA_STD_CLS_CD |
SEC Description | BANK_ACT_TYPE.DESCR |
Effective Entry Date | FLP_ACH_NOC_HDR.FLP_EFF_ENTRY_DT |
Originating DFI Identification | FLP_ACH_NOC_HDR.FLP_ORIG_DFI_ID |
Trace Number | FLP_ACH_NOC_LN.FLP_BOA_TRACE_NBR |
ACH Transaction Code | FLP_ACH_NOC_LN.FLP_ACH_NOC_TR_CD |
Description | STMT_CODE_TBL.DESC50 |
Receiving DFI Identification | FLP_ACH_NOC_LN.FLP_BOA_RCV_DFI_ID |
Receiving DFI Check Digit | FLP_ACH_NOC_LN.FLP_BOA_CHK_DIGIT |
DFI Account Number | FLP_ACH_NOC_LN.FLP_BOA_DFI_ACTNBR |
Individual Identification Number | FLP_ACH_NOC_LN.FLP_ACH_NOC_IND_ID |
Receiving Name | FLP_ACH_NOC_LN.FLP_BOA_RECV_NAME |
Discretionary Data | FLP_ACH_NOC_LN.FLP_BOA_DISCR_DATE |
Return Reason Code | FLP_ACH_NOC_LN.FLP_RET_REASON_CD |
Return Description | TR_MAP_ITEMS.MAPPING_OUTPUT |
Original Entry Trace Number | FLP_ACH_NOC_LN.FLP_ORG_ENT_TR_NUM |
Original Receiving DFI ID | FLP_ACH_NOC_LN.FLP_ORIG_DFI_ID |
Date of Death | FLP_ACH_NOC_LN. DT_OF_DEATH |
Maker Name | FLP_AR_RCHK_LN.FLP_DEPOSITED_BY |
Maker Routing Number | FLP_AR_RCHK_LN.FLP_ITEM_BANK_ID |
Maker Account Number | FLP_AR_RCHK_LN.FLP_ITEM_ACC_NUM |
Check Date | FLP_AR_RCHK_LN.FLP_ECHK_AUTH_DATE |
Item ID | FLP_AR_RCHK_LN.FLP_ITEM_ID |
Bank Deposit ID | FLP_AR_RCHK_LN.FLP_BANK_DEP_ID |
Item Return Date | FLP_AR_RCHK_LN.FLP_DEPOSIT_DATE |
Location Number | FLP_AR_RCHK_LN.FLP_LOCATION_NUM |
Total Images Delivered | FLP_AR_RCHK_LN.FLP_TOT_IMGVW_DELV |
Return Reason | FLP_AR_RCHK_LN.FLP_RETURN_REASON |
Disposition | FLP_AR_RCHK_LN.FLP_DISPOSITION |
Image File Name Front | FLP_AR_RCHK_LN.FLP_IMG1_REF_KEY |
Image File Name Rear | FLP_AR_RCHK_LN. FLP_IMG2_REF_KEY |
Redeposit count | FLP_AR_RCHK_LN.FLP_REDEP_COUNT |
Version History
Date | Revision Description |
12/01/2023 | Original Version |