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. |