Enhancement Summary – Release 11.4

Introduction

In Release 11.4, Qbyte Financial has added additional User-Defined Fields for AFEs and Cost Centres, increasing the number of User-Defined Fields to 30.

In prior Qbyte Financial versions, AFEs and Cost Centres had 20 User-Defined Fields.

Database

The following columns were added to the COST_CENTRES and AUDIT_COST_CENTRES tables:

• CC_UDF_21_CODE

• CC_UDF_22_CODE

• CC_UDF_23_CODE

• CC_UDF_24_CODE

• CC_UDF_25_CODE

• CC_UDF_26_CODE 

• CC_UDF_27_CODE

• CC_UDF_28_CODE 

• CC_UDF_29_CODE

• CC_UDF_30_CODE

The following columns were added to the AUTHORIZATIONS_FOR_EXPENDITURE, AUDIT_AFES, AFE_ACCRUAL_PARAMETERS, and AUDIT_AFE_ACCRUAL_PARAMETER tables:

• AFE_UDF_21_CODE

• AFE_UDF_22_CODE

• AFE_UDF_23_CODE

• AFE_UDF_24_CODE

• AFE_UDF_25_CODE

• AFE_UDF_26_CODE

• AFE_UDF_27_CODE

• AFE_UDF_28_CODE

• AFE_UDF_29_CODE

• AFE_UDF_30_CODE

Column CODE in table UDF_CODES was increased to VARCHAR(50 BYTE).

Screen

Cost Centres (MRSS011)

The User-Defined tab on the Maintain Cost Centres screen displays 30 UDF fields, each code and description pair on their own line inside a scrolling area and a vertical scroll bar displayed on the right side of the screen. The prompt text for each UDF field can be up to 20 characters in length. The field UDF Codes can display up to 50 characters.

Open

AFE (CMRS014)

The User-Defined tab on the Maintain AFE screen displays 30 UDF fields and 3 Reporting UDF Fields, each code and description pair on their own line inside a scrolling area and a vertical scroll bar displayed on the right side of the screen. The prompt text for each UDF field can be up to 20 characters in length. The field UDF Codes can display up to 50 characters.

Open

Business Associates (ACTS010)

The User-Defined Information popup screen on the Maintain Business Associates screen displays 30 UDF fields, each code and description pair on their own line inside a scrolling area and a vertical scroll bar displayed on the right side of the screen. The prompt text for each UDF field can be up to 20 characters in length. The field UDF Codes can display up to 50 characters.

Open

Capital Accrual Parameters (CMRS090)

The User-Defined Info tab on the Maintain Capital Accrual Parameters screen displays 30 UDF fields and 3 Reporting UDF Fields, each code and description pair on their own line inside a scrolling area and a vertical scroll bar displayed on the right side of the screen. The prompt text for each UDF field can be up to 20 characters in length. The field UDF Codes can display up to 50 characters.

Open

AFE Spreadsheet Upload (CONU001)

New UDF Cells (UDF 21 to UDF 30) were added to CONU001.

Cost Centre Spreadsheet Upload (CONU005)

New UDF Cells (UDF 21 to UDF 30) were added to CONU005.

Configuration

User-Defined Fields can be customized by navigating to System Admin > Codes > UDF Types

Cost Centres:

Open

AFES:

Open

API Changes

The COST_CENTRE_USER_EXIT package has been modified to add the new UDF code fields. These fields will be added as parameters defaulted to NULL where they are required in parameter lists, and will be positioned at the end of any parameter list they are added in order to ensure existing code calling these API procedures will not be impacted.