Skip to content
[Home] [Help]
View: IGI_STP_AP_BAL
View Text
SELECT NET.USER_ID
, NET.STP_ID
, NET.TRX_ID
, NET.TRX_NUMBER
, NET.AMOUNT
, NET.NETTING_AMOUNT
, NET.PROCESS_FLAG
, NET.CURRENCY_CODE
FROM IGI_STP_CANDIDATES NET
WHERE NET.APPLICATION = 'AP'
AND NET.PROCESS_FLAG != 'S'
Columns
| Name |
| USER_ID |
| STP_ID |
| TRX_ID |
| TRX_NUMBER |
| AMOUNT |
| NETTING_AMOUNT |
| PROCESS_FLAG |
| CURRENCY_CODE |