[Home] [Help]
View: AR_TA_VRH_DEDU_V
Product: | AR - Receivables |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RH.BATCH_NAME
, RH.CHECK_NUMBER
, RH.HISTORY_LINE_ID
, RH.PARENT_HISTORY_LINE_ID
, RH.NEW_TRX_TYPE
, RH.PROMOTION_NUMBER
, RH.ADJUSTMENT_ID
, CT.TRX_NUMBER TRX_NUMBER
, PS.AMOUNT_DUE_ORIGINAL ORIGINAL_AMOUNT
, PS.AMOUNT_DUE_REMAINING BALANCE_DUE
, PS.STATUS
, RH.APPLICATION_STATUS
FROM AR_TA_REMIT_HIST RH
, AR_PAYMENT_SCHEDULES PS
, RA_CUSTOMER_TRX CT
WHERE RH.NEW_TRX_ID = CT.CUSTOMER_TRX_ID
AND RH.NEW_TRX_ID = PS.CUSTOMER_TRX_ID
AND RH.CREATED_FROM = 'CASH_ENGINE'
AND RH.RECORD_TYPE=7
Columns
Name |
BATCH_NAME |
CHECK_NUMBER |
HISTORY_LINE_ID |
PARENT_HISTORY_LINE_ID |
NEW_TRX_TYPE |
PROMOTION_NUMBER |
ADJUSTMENT_ID |
TRX_NUMBER |
ORIGINAL_AMOUNT |
BALANCE_DUE |
STATUS |
APPLICATION_STATUS |