FND Design Data [Home] [Help]

View: IGI_AR_PAYMENT_SCHEDULES_V

Product: IGI - Public Sector Financials International
Description: Holds payment term schedules for the selected invoice
Implementation/DBA Data: ViewAPPS.IGI_AR_PAYMENT_SCHEDULES_V
View Text

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

Columns

Name
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
DAYS_PAST_DUE
BILLING_NUMBER
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE