AR Data Report (ARR025)
- 26 Jun 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
AR Data Report (ARR025)
- Updated on 26 Jun 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 provides AR item data present in Florida PALM based on the run control parameters provided. Pending items are created to record a receivable with a customer through online entry or using an interface. Once the pending item is posted to the customer’s account, it is then an item in Florida PALM. This report will provide all the key data elements and statuses associated with an item for agencies to analyze and use in their day-to-day business.
Report Navigation: Reporting Tools > Query > Query Viewer
Query Name: FLP_ARR025_AR_DATA_REPORT
Click below to view the sample report layout.
Business Roles
The following business roles have access to this report:
- Agency AR Deposit Reporter
- Agency AR Item Reporter
- Agency AR Item Processor
- DFS AR Audit Approver
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 |
|---|---|
Business Unit | Required |
Accounting From Date | Required |
| Accounting To Date | Required |
Group BU | |
Group ID | Optional |
Approval Status | Optional |
Posted Flag | |
Customer ID | Optional |
Item Status | Optional |
Item ID | Optional |
Item Amount | Optional |
Entry Type | Optional |
Bank Code | Optional |
Bank Account | Optional |
Organization | Optional |
Account | Optional |
Fund | Optional |
Category | Optional |
Budget Entity | |
State Program | Optional |
Grant | Optional |
OA1 | Optional |
OA2 | Optional |
Project | Optional |
Supplier ID | Optional |
Asset ID | Optional |
Foreign Amount | Optional |
Report Layout
The layout of the report is listed below.
| Data Field | Florida PALM RECORD.FIELD Mapping |
|---|---|
Group BU | GROUP_CONTROL.GROUP_BU |
Group ID | GROUP_CONTROL.GROUP_ID |
User ID | GROUP_CONTROL.OPRID |
Group Type | GROUP_CONTROL.GROUP_TYPE |
Balance Status | GROUP_CONTROL.BAL_STATUS |
Edit Status | GROUP_CONTROL.EDIT_STATUS |
Post Action | GROUP_CONTROL.POST_ACTION |
Approval Status | TBD |
Post Status | GROUP_CONTROL.POST_STATUS |
Accounting Entries Balanced | GROUP_CONTROL.DST_BAL_STATUS |
Entry Date | GROUP_CONTROL.ENTRY_DT |
Received Date | GROUP_CONTROL.RECEIVED_DT |
Posted Flag | PENDING_ITEM.POSTED_FLAG |
Error Code | PENDING_ITEM.AR_ERROR_CODE |
Last User to Update | PENDING_ITEM.OPRID_LAST_UPDT |
Item ID | PENDING_ITEM.ITEM |
Customer ID | PENDING_ITEM.CUST_ID |
Item Line | PENDING_ITEM.ITEM_LINE |
Balance Amount | PENDING_ITEM.BAL_AMT |
Pending Item Dispute Flag | PENDING_ITEM.DISPUTE_STATUS |
Business Unit | ITEM.BUSINESS_UNIT |
Customer ID | ITEM.CUST_ID |
Item ID | ITEM.ITEM |
Item Line | ITEM.ITEM_LINE |
Item Status | ITEM.ITEM_STATUS |
Entry Type | ITEM.ENTRY_TYPE |
Balance Amount | ITEM.BAL_AMT |
Accounting Date | ITEM.ACCOUNTING_DT |
Posted Date | ITEM.POST_DT |
Asset ID Reference | ITEM. SUBROG_CASE_NUM |
AR Distribution Code | ITEM.DST_ID_AR |
Item Sequence | ITEM.ITEM_SEQ_NUM |
Supplier ID | ITEM.BILL_OF_LADING |
Days Late | Current day – ITEM.DUE_DT |
Item Dispute Flag | ITEM.DISPUTE_STATUS |
Entered Date/Time | ITEM.ENTERED_DTTM |
User ID | ITEM.OPRID |
Last Updated Date/Time | ITEM.LAST_UPDATE_DTTM |
Last User to Update | ITEM.OPRID_LAST_UPDT |
Item Line | ITEM_ACTIVITY.ITEM_LINE |
Item Sequence | ITEM_ACTIVITY.ITEM_SEQ_NUM |
Entry Type | ITEM_ACTIVITY.ENTRY_TYPE |
Entry Amount | ITEM_ACTIVITY.ENTRY_AMT |
Accounting Date | ITEM_ACTIVITY.ACCOUNTING_DT |
Posted Date | ITEM_ACTIVITY.POST_DT |
Deposit Business Unit | ITEM_ACTIVITY.DEPOSIT_BU |
Deposit ID | ITEM_ACTIVITY.DEPOSIT_ID |
Agency Deposit Number | FLP_DEP_NUM_TBL.AGEN_DEP_NO |
Payment Sequence | ITEM_ACTIVITY.PAYMENT_SEQ_NUM |
Group BU | ITEM_ACTIVITY.GROUP_BU |
Group ID | ITEM_ACTIVITY.GROUP_ID |
Group Sequence | ITEM_ACTIVITY.GROUP_SEQ_NUM |
Payment Amount | ITEM_ACTIVITY.PAYMENT_AMT |
Origin | ITEM_ACTIVITY.ORIGIN_ID |
Payment ID | ITEM_ACTIVITY.PAYMENT_ID |
Group Type | ITEM_ACTIVITY.GROUP_TYPE |
Bank Code | ITEM_ACTIVITY.BANK_CD |
Bank Account Key | ITEM_ACTIVITY.BANK_ACCT_KEY |
Item Line | ITEM_DST.ITEM_LINE |
Item Sequence | ITEM_DST.ITEM_SEQ_NUM |
Distribution Sequence | ITEM_DST.DST_SEQ_NUM |
Budget Date | ITEM_DST.BUDGET_DT |
GL Business Unit | ITEM_DST.BUSINESS_UNIT_GL |
Organization | ITEM_DST.DEPTID |
Account | ITEM_DST.ACCOUNT |
Fund | ITEM_DST.FUND_CODE |
Budget Entity | ITEM_DST.BUDGET_REF |
Category | ITEM_DST.PRODUCT |
State Program | ITEM_DST.CHARTFIELD2 |
Grant | ITEM_DST.PROGRAM_CODE |
Contract | ITEM_DST.CHARTFIELD1 |
OA1 | ITEM_DST.CLASS_FLD |
OA2 | ITEM_DST.CHARTFIELD3 |
PC Business Unit | ITEM_DST.BUSINESS_UNIT_PC |
Project | ITEM_DST.PROJECT_ID |
Activity | ITEM_DST.ACTIVITY_ID |
PC Source Type | ITEM_DST.RESOURCE_TYPE |
PC Category | ITEM_DST.RESOURCE_CATEGORY |
PC Subcategory | ITEM_DST.RESOURCE_SUB_CAT |
Line Description | ITEM_DST.LINE_DESCR |
Foreign Amount | ITEM_DST.FOREIGN_AMOUNT |
Accounting Date | ITEM_DST.ACCOUNTING_DT |
Journal ID | ITEM_DST.JOURNAL_ID |
Journal Date | ITEM_DST.JOURNAL_DATE |
Budget Status | AR_CC_TRAN_HDR.BUDGET_HDR_STATUS |
GL Distribution Status | ITEM_DST.GL_DISTRIB_STATUS |
Application Journal ID | ITEM_DST.APPL_JRNL_ID |
System Defined | ITEM_DST.SYSTEM_DEFINED |
Fiscal Year | ITEM_DST.FISCAL_YEAR |
User Amount 1 | ITEM.USER_AMT1 |
User Amount 2 | ITEM.USER_AMT2 |
User Amount 3 | ITEM.USER_AMT3 |
User Amount 4 | ITEM.USER_AMT4 |
User Amount 5 | ITEM.USER_AMT5 |
User Amount 6 | ITEM.USER_AMT6 |
User Amount 7 | ITEM.USER_AMT7 |
User Amount 8 | ITEM.USER_AMT8 |
User Date 1 | ITEM.USER_DT1 |
User Date 2 | ITEM.USER_DT2 |
User Date 3 | ITEM.USER_DT3 |
User Date 4 | ITEM.USER_DT4 |
User 1 | ITEM.USER1 |
User 2 | ITEM.USER2 |
User 3 | ITEM.USER3 |
User 4 | ITEM.USER4 |
User 5 | ITEM.USER5 |
User 6 | ITEM.USER6 |
User 7 | ITEM.USER7 |
User 8 | ITEM.USER8 |
User 9 | ITEM.USER9 |
User 10 | ITEM.USER10 |
Version History
Date | Revision Description |
|---|---|
02/06/2024 | Original Version |
Was this article helpful?
