Deposit Report (ARR007)

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

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

Date

Revision Description

12/01/2023

Original Version