[Home] [Help] [Dependency Information]
Object Name: | IBY_PAYMENT_REASONS_TL |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_PAYMENT_REASONS_TL |
Subobject Name: | |
Status: | VALID |
IBY_PAYMENT_REASONS stores payment reasons that are used as lookup values for payee records or documents payable, that is, invoices. This table is similar to FND_LOOKUPS, but with a new column for territory identification. Products that use data in this table can code their LOVs to be sensitive to the country context so that only values relevant for the country will appear. This table corresponds to the Payment Reason Codes page.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_PAYMENT_REASONS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PAYMENT_REASON_CODE
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_REASON_CODE | VARCHAR2 | (30) | Yes | User entered primary key |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language code of the record's current language |
MEANING | VARCHAR2 | (80) | Lookup meaning of payment reasons | |
DESCRIPTION | VARCHAR2 | (240) | Lookup description of payment reason | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_REASON_CODE
, LANGUAGE
, SOURCE_LANG
, MEANING
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IBY.IBY_PAYMENT_REASONS_TL;
IBY.IBY_PAYMENT_REASONS_TL does not reference any database object
IBY.IBY_PAYMENT_REASONS_TL is referenced by following:
|
|
|