[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 |