[Home] [Help] [Dependency Information]
Object Name: | TX_TEXT_TBL_TL |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.TX_TEXT_TBL_TL |
Subobject Name: | |
Status: | VALID |
This table contains text for the Tax Application. This text can contain additional comments or notes for a record in any Tax table. The text lines are grouped together by Paragraph, sub-paragraph and language. The line number uniquely identifies each line of text and orders the text correctly. A line number of -1 stores reference information for the succeeding text.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
TX_TEXT_TBL_TL_PK | NORMAL | UNIQUE | APPS_TS_SEED |
TEXT_CODE
LANG_CODE PARAGRAPH_CODE SUB_PARACODE LINE_NO LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEXT_CODE | NUMBER | (10) | Yes | Surrogate key for the record. ID which joins any rows of text in this table to the Text Table for this Module |
LANG_CODE | VARCHAR2 | (4) | Yes | Obsolete column - no longer used. |
PARAGRAPH_CODE | VARCHAR2 | (4) | Yes | Defined in sy_para_cds. |
SUB_PARACODE | NUMBER | (5) | Yes | Defined in sy_para_cds. |
LINE_NO | NUMBER | (5) | Yes | Line number which allows multiple lines of descripitive text for underlying record. -1 = line is used to recreate key of underlying record; 1 <= descriptive text. |
TEXT | VARCHAR2 | (70) | Descriptive text. | |
LANGUAGE | VARCHAR2 | (4) | Yes | The value stored in this column represents the language in which the data will be displayed. |
SOURCE_LANG | VARCHAR2 | (4) | Yes | 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. |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT TEXT_CODE
, LANG_CODE
, PARAGRAPH_CODE
, SUB_PARACODE
, LINE_NO
, TEXT
, LANGUAGE
, SOURCE_LANG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
FROM GML.TX_TEXT_TBL_TL;
GML.TX_TEXT_TBL_TL does not reference any database object
GML.TX_TEXT_TBL_TL is referenced by following:
|
|
|