Deposit Report (ARR007)
  • Dark
    Light
  • PDF

Deposit Report (ARR007)

  • Dark
    Light
  • PDF

Article summary

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 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.

 

Your browser does not support PDF.click here to download

 

Business Roles

The following business roles have access to this report:

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


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.