DEPOSIT_IDAR_WC_EPDIDF_VW(SQL View) |
Index Back |
|---|---|
Pymt to Post - Dep ID View |
| SELECT DISTINCT a.DEPOSIT_ID FROM PS_PAYMENT a , PS_DEPOSIT_CONTROL b WHERE a.POST_DT IS NULL AND a.MISC_PAYMENT='N' AND a.DEPOSIT_BU=b.DEPOSIT_BU AND a.DEPOSIT_ID=b.DEPOSIT_ID AND a.PROCESS_INSTANCE=0 AND (a.payment_status ='A' OR (a.payment_status ='W' AND a.AMT_REM = 0 AND a.PAYMENT_AMT <> 0)) AND b.CASH_CNTRL = a.CASH_CNTRL_USE AND ( (a.CASH_CNTRL_USE = 'Y' AND a.CASH_CNTRL_DONE = 'Y') OR a.CASH_CNTRL_USE = 'N') AND b.LB_FORMAT_ERROR='N' AND b.PAY_WS_TYPE='E' |
| # | 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. |