[Home] [Help]
| Product: | IGI - Public Sector Financials International |
|---|---|
| Description: | Holds payment term schedules for the selected invoice |
| Implementation/DBA Data: |
APPS.IGI_AR_PAYMENT_SCHEDULES_V
|
SELECT ROW_ID
, TRX_NUMBER
, TERMS_SEQUENCE_NUMBER
, INVOICE_CURRENCY_CODE
, CUSTOMER_TRX_ID
, AL_CLASS_MEANING
, DUE_DATE
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, AL_STATUS_MEANING
, AMOUNT_IN_DISPUTE
, DISPUTE_DATE
, ROUND(DAYS_PAST_DUE) DAYS_PAST_DUE
, BILLING_NUMBER
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM AR_PAYMENT_SCHEDULES_V