Populating User-Defined Fields

PeopleSoft delivers customizable user fields in PS_PENDING_ITEM that are exclusively for your use. If the implementation uses any of the fields in this table, make sure that the interface populates them:

Amount Fields Date Fields Character Fields

USER_AMT1

USER_DT1

USER1

USER_AMT2

USER_DT2

USER2

USER_AMT3

USER_DT3

USER3

USER_AMT4

USER_DT4

USER4

USER_AMT5

 

USER5

USER_AMT6

 

USER6

USER_AMT7

 

USER7

USER_AMT8

 

USER8

   

USER9

   

USER10

Types of User-Defined Fields

This tables describes the types of user-defined fields:

Type Description

Amounts

The USER_AMT fields have a cumulative effect on PS_ITEM. When the Receivables Update process finds a value in any of the user amount fields on PS_PENDING_ITEM, it places that value in the same field on the corresponding PS_ITEM_ACTIVITY row. It also updates the corresponding user amount field arithmetically on PS_ITEM.

Dates

The system places all USER_DT fields on the corresponding ITEM_ACTIVITY record. However, USER_DT1 and USER_DT2 update PS_ITEM only if the value on PS_ITEM is NULL. USER_DT3 and USER_DT4 update PS_ITEM whenever the value on PS_PENDING_ITEM is not NULL.

Characters

The USER1 through USER10 fields overlay an existing value if the PS_PENDING_ITEM value is not cleared, regardless of the update entry field. Only fields with values are moved. If USER1 is not cleared on the item, its value can remain and a pending item can affect USER2, leaving intact the value of USER1.