Agency Commitments Report (KKR018)
  • 11 Oct 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Agency Commitments Report (KKR018)

  • Dark
    Light
  • PDF

Article summary

Report Description

The Agency Commitments Report allows users with security access to run a report to reflect open Encumbrances, IU Accruals, and Carry Forward Payables for a designated time period grouped by designated ChartFields and ChartField combinations.

Report Navigation: Main Menu > Florida PALM > Reports > KK > Agency Commitments Report 

Click below to view the sample report layout.

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

Report Request Parameters


Business Unit

Required

Date From

Required

Date To

Required

Include Carry Forward Transactions

Optional

ID From

Optional

ID To

Optional

Transaction Type

Optional

Fund

Optional

Budget Entity

Optional

Category

Optional

Organization

Optional

Account

Optional

State Program

Optional

Grant

Optional

Contract

Optional

OA1

Optional

OA2

Optional

PC Business Unit

Optional

Project

Optional

Activity

Optional

PC Source Type

Optional

Report Layout

The layout of the report is listed below. 

Data Field

Florida PALM RECORD.FIELD Mapping

Transaction Type

PS_KK_SOURCE_TRAN.KK_SOURCE_TRAN

ID

  • PS_PO_HDR.PO_ID
  • PS_FLP_IU_ENBR_DTL.IU Transaction ID
  • PS_FLP_IU_TRANS_DTL.IU Transaction ID
  • PS_RECV_ENC_HDR_VW.RECEIVER_ID
  • PS_RECV_EXP_HDR_VW.RECEIVER_ID
  • PS_VOUCHER.VOUCHER_ID

Line Number

  • PS_PO_LINE_DIST_KK. LINE_NBR
  • PS_FLP_IU_ENBR_DTL.Distribution Sequence No
  • PS_FLP_IU_TRANS_DTL. Distribution Sequence No
  • PS_RECV_ENC_HDR_VW.RECV_LN_NBR
  • PS_RECV_EXP_HDR_VW.RECV_LN_NBR
  • PS_DISTRIB_LINE.DISTRIB_LINE_NUM

Date

  • PS_PO_HDR.PO_DT
  • PS_FLP_IU_ENBR_DTL.TRANS_DT
  • PS_FLP_IU_TRANS_DTL.TRANS_DT
  • PS_RECV_ENC_HDR_VW.ACCOUNTING_DT
  • PS_RECV_EXP_HDR_VW.ACCOUNTING_DT
  • PS_VOUCHER.ACCOUNTING_DT_ID

Supplier ID

  • PS_ PO_HDR.VENDOR_ID
  • PS_FLP_IU_ENBR_DTL.Sending Business Unit
  • PS_FLP_IU_TRANS_DTL.Sending Business Unit
  • PS_RECV_HDR.VENDOR_ID
  • PS_VOUCHER_.VENDOR_ID

Supplier Name

  • PS_ VENDOR.NAME1
  • PS_BUS_UNIT_TBL_FS.DESCR

Account

PS_KK_ACTIVITY_LOG.ACCOUNT

Account Description

PS_GL_ACCOUNT_TBL.DESCR

Fund

PS_KK_ACTIVITY_LOG.FUND_CODE

Budget Entity

PS_KK_ACTIVITY_LOG.BUDGET_REF

Category

PS_KK_ACTIVITY_LOG.PRODUCT

Organization

PS_KK_ACTIVITY_LOG.DEPTID

State Program

PS_KK_ACTIVITY_LOG.CHARTFIELD2

Grant

PS_KK_ACTIVITY_LOG.PROGRAM_CODE

Contract

PS_KK_ACTIVITY_LOG.CHARTFIELD1

OA1

PS_KK_ACTIVITY_LOG.CLASS_FLD

OA2

PS_KK_ACTIVITY_LOG.CHARTFIELD3

PC Business Unit

PS_KK_ACTIVITY_LOG,BUSINESS_UNIT.PC

Project

PS_KK_ACTIVITY_LOG.PROJECT_ID

Activity 

PS_KK_ACTIVITY_LOG.ACTIVITY_ID
PC Source TypePS_KK_ACTIVITY_LOG.RESOURCE_TYPE
Budget Period
PS_KK_ACTIVITY_LOG.BUDGET_PERIOD
Balance

Version History

Date

Revision Description

07/02/2024

Original Version

09/06/2024Added hyperlinks for 20.2, 20.3.1, 20.3.2, and 20.3.3.
10/11/2024New Sample Report Layout Updated 


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.