DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.APFV_AP_PAYMENT_TERMS

Object Details
Object Name: APFV_AP_PAYMENT_TERMS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.APFV_AP_PAYMENT_TERMS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Shows information about payment terms you negotiated with your supplier. Terms can be associated with a supplier, supplier site, and an invoice.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYMENT_TERM_ID NUMBER (15) Yes Term unique identifier.
PAYMENT_TERM_NAME VARCHAR2 (50) Yes Name of payment terms.
DUE_CUTOFF_DAY NUMBER

Used for proxima terms only, day of a month after which Oracle Payables schedules payment using a day after the current month.
START_EFFECTIVE_DATE DATE

Date from which payment term is valid.
END_EFFECTIVE_DATE DATE

Date to which payment term is invalid.
RANK NUMBER (15)
Unique rank to rate invoice payment terms against purchase order payment terms in accordance with Prompt Payment Act.
DESCRIPTION VARCHAR2 (240)
Descriptione of payment terms.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAYMENT_TERM_ID
,      PAYMENT_TERM_NAME
,      DUE_CUTOFF_DAY
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      RANK
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.APFV_AP_PAYMENT_TERMS;

Dependencies

[top of page]

APPS.APFV_AP_PAYMENT_TERMS references the following:

SchemaAPPS
SynonymAP_TERMS

APPS.APFV_AP_PAYMENT_TERMS is not referenced by any database object