DEPOSIT_IDKK_XCP_AR2_IDVW(SQL View) |
Index Back |
|---|---|
Deposit ID Prompt on Search VW |
| SELECT DISTINCT DEPOSIT_ID FROM PS_KK_SOURCE_HDR WHERE KK_SOURCE_TRAN = 'AR_MISCPAY' AND KK_PROCESS_STATUS IN ('E', 'X', 'W') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEPOSIT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated. |