[Home] [Help] [Dependency Information]
Object Name: | APFV_PAYMENT_SCHEDULES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | SQLAP.APFV_PAYMENT_SCHEDULES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Shows the Scheduled Payments for Invoices. Included in the view are the invoice amount, amount remaining, the scheduled payment and what discounts can be gotten for paying early.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_NUMBER | VARCHAR2 | (50) | Yes | Invoice number |
INVOICE_DATE | DATE | Invoice date | ||
_LA:INVOICE_TYPE | CHAR | (72) | ||
PAYMENT_NUMBER | NUMBER | (15) | Yes | |
_LA:PAYMENT_STATUS | CHAR | (91) | ||
VENDOR_NUMBER | VARCHAR2 | (30) | Yes | |
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDOR_SITE_ID | NUMBER | (15) | ||
INVOICE_CURRENCY | VARCHAR2 | (15) | Yes | |
PAYMENT_CURRENCY | VARCHAR2 | (15) | Yes | |
PAYMENT_GROUP | VARCHAR2 | (25) | ||
AMOUNT_REMAINING | NUMBER | |||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
DISCOUNT_AMOUNT_AVAILABLE | NUMBER | |||
DISCOUNT_AMOUNT_REMAINING | NUMBER | |||
DISCOUNT_DATE | DATE | |||
DUE_DATE | DATE | |||
FUTURE_PAY_DUE_DATE | DATE | |||
GROSS_AMOUNT | NUMBER | |||
HOLD_FLAG | VARCHAR2 | (1) | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
_LA:PMT_METHOD_LOOKUP_CODE | CHAR | (74) | ||
PAYMENT_PRIORITY | NUMBER | (2) | ||
SECOND_DISCOUNT_DATE | DATE | |||
SECOND_DISC_AMT_AVAILABLE | NUMBER | |||
THIRD_DISCOUNT_DATE | DATE | |||
THIRD_DISC_AMT_AVAILABLE | NUMBER | |||
_DF | CHAR | (34) | ||
_DF:GLBL | CHAR | (34) | ||
INVOICE_ID | NUMBER | (15) | Yes | |
EXTERNAL_BANK_ACCOUNT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_NUMBER
, INVOICE_DATE
, _LA:INVOICE_TYPE
, PAYMENT_NUMBER
, _LA:PAYMENT_STATUS
, VENDOR_NUMBER
, VENDOR_NAME
, VENDOR_SITE_ID
, INVOICE_CURRENCY
, PAYMENT_CURRENCY
, PAYMENT_GROUP
, AMOUNT_REMAINING
, CREATED_BY
, CREATION_DATE
, DISCOUNT_AMOUNT_AVAILABLE
, DISCOUNT_AMOUNT_REMAINING
, DISCOUNT_DATE
, DUE_DATE
, FUTURE_PAY_DUE_DATE
, GROSS_AMOUNT
, HOLD_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, _LA:PMT_METHOD_LOOKUP_CODE
, PAYMENT_PRIORITY
, SECOND_DISCOUNT_DATE
, SECOND_DISC_AMT_AVAILABLE
, THIRD_DISCOUNT_DATE
, THIRD_DISC_AMT_AVAILABLE
, _DF
, _DF:GLBL
, INVOICE_ID
, EXTERNAL_BANK_ACCOUNT_ID
FROM APPS.APFV_PAYMENT_SCHEDULES;
APPS.APFV_PAYMENT_SCHEDULES is not referenced by any database object
|
|
|