[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: |
APPS.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 |