eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IBE_AR_PAYMENT_SCHEDULES_V

Product:	IBE - iStore
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CT.ROWID ROW_ID
, PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, CT.TRX_NUMBER TRX_NUMBER
, CT.TRX_DATE TRX_DATE
, CT.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, AL_CLASS.MEANING AL_CLASS_MEANING
, CT.PURCHASE_ORDER CT_PURCHASE_ORDER
, CT.WAYBILL_NUMBER WAYBILL_NUMBER
, SUM(DECODE(PS.AMOUNT_DUE_REMAINING
, 0
, NULL
, TRUNC(SYSDATE) - PS.DUE_DATE)) DAYS_PAST_DUE
, MIN(PS.DUE_DATE) DUE_DATE
, PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PS.AMOUNT_LINE_ITEMS_ORIGINAL AMOUNT_LINE_ITEMS_ORIGINAL
, PS.TAX_ORIGINAL TAX_ORIGINAL
, PS.FREIGHT_ORIGINAL FREIGHT_ORIGINAL
, PS.AMOUNT_ADJUSTED AMOUNT_ADJUSTED
, PS.AMOUNT_APPLIED AMOUNT_APPLIED
, PS.AMOUNT_CREDITED AMOUNT_CREDITED
, PS.DISCOUNT_TAKEN_EARNED DISCOUNT_TAKEN_EARNED
, CT.SHIP_VIA SHIP_VIA
, PS.CUSTOMER_ID CUSTOMER_ID
, PS.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, PS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PS.CASH_RECEIPT_ID CASH_RECEIPT_ID
, PS.CLASS CLASS
, PS.STATUS STATUS
, PS.RECEIPT_CONFIRMED_FLAG RECEIPT_CONFIRMED_FLAG
FROM AR_PAYMENT_SCHEDULES PS
, RA_CUSTOMER_TRX CT
, AR_LOOKUPS AL_CLASS
WHERE PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND PS.CLASS = AL_CLASS.LOOKUP_CODE
AND AL_CLASS.LOOKUP_TYPE = 'INV/CM' GROUP BY CT.ROWID
, PS.PAYMENT_SCHEDULE_ID
, CT.TRX_NUMBER
, CT.TRX_DATE
, CT.INVOICE_CURRENCY_CODE
, PS.CUSTOMER_ID
, PS.CUSTOMER_SITE_USE_ID
, PS.CUSTOMER_TRX_ID
, PS.CASH_RECEIPT_ID
, PS.CLASS
, PS.STATUS
, PS.RECEIPT_CONFIRMED_FLAG
, AL_CLASS.MEANING
, CT.PURCHASE_ORDER
, CT.WAYBILL_NUMBER
, PS.AMOUNT_DUE_REMAINING
, PS.DUE_DATE
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.AMOUNT_LINE_ITEMS_ORIGINAL
, PS.TAX_ORIGINAL
, PS.FREIGHT_ORIGINAL
, PS.AMOUNT_ADJUSTED
, PS.AMOUNT_APPLIED
, PS.AMOUNT_CREDITED
, PS.DISCOUNT_TAKEN_EARNED
, CT.SHIP_VIA

Columns

Name
ROW_ID
PAYMENT_SCHEDULE_ID
TRX_NUMBER
TRX_DATE
INVOICE_CURRENCY_CODE
AL_CALSS_MEANING
CT_PURCHASE_ORDER
WAYBILL_NUMBER
DAYS_PAST_DUE
DUE_DATE
AMOUNT_DUE_ORIGINAL
AMOUNT_DUE_REMAINING
AMOUNT_LINE_ITEMS_ORIGINAL
TAX_ORIGINAL
FREIGHT_ORIGINAL
AMOUNT_ADJUSTED
AMOUNT_APPLIED
AMOUNT_CREDITED
DISCOUNT_TAKEN_EARNED
SHIP_VIA
CUSTOMER_ID
CUSTOMER_SITE_USE_ID
CUSTOMER_TRX_ID
CASH_RECEIPT_ID
CLASS
STATUS
RECEIPT_CONFIRMED_FLAG