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

TABLE: IEX.IEX_DUNNING_PLANS_TL

Object Details
Object Name: IEX_DUNNING_PLANS_TL
Object Type: TABLE
Owner: IEX
FND Design Data: TableIEX.IEX_DUNNING_PLANS_TL
Subobject Name:
Status: VALID


Collections dunning plan translated table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DUNNING_PLAN_ID NUMBER (10) Yes Primary Key
NAME VARCHAR2 (240)
Name assigned to the dunning plan
DESCRIPTION VARCHAR2 (240)
Description assigned to the dunning plan
LANGUAGE VARCHAR2 (240)
Language code
SOURCE_LANG VARCHAR2 (240)
The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard who column - date when this row was updated.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
GRACE_DAYS VARCHAR2 (1)
Indicates whether to use grace days when determining when dunning letters are sent
DUN_DISPUTED_ITEMS VARCHAR2 (1)
Indicates whether to include disputed invoices in this dunning letter set
INCLUDE_UNUSED_PAYMENTS_FLAG VARCHAR2 (1)
Indicates whether to include unapplied and on-account payments in all dunning letters in a dunning letter set
DUNNING_TYPE VARCHAR2 (30)
Possible values are DAYS_OVERDUE if dunning is based on days that items are past due, or STAGED_DUNNING if dunning is based on dunning levels.
INCLUDE_CURRENT VARCHAR2 (1)
Indicates whether invoices, debit memos, and chargebacks that are not yet delinquent are included in a dunning letter
Query Text

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


SELECT DUNNING_PLAN_ID
,      NAME
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      GRACE_DAYS
,      DUN_DISPUTED_ITEMS
,      INCLUDE_UNUSED_PAYMENTS_FLAG
,      DUNNING_TYPE
,      INCLUDE_CURRENT
FROM IEX.IEX_DUNNING_PLANS_TL;

Dependencies

[top of page]

IEX.IEX_DUNNING_PLANS_TL does not reference any database object

IEX.IEX_DUNNING_PLANS_TL is referenced by following:

SchemaIEX
ViewIEX_DUNNING_PLANS_TL#