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

TABLE: GML.TX_TXRE_CDS

Object Details
Object Name: TX_TXRE_CDS
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.TX_TXRE_CDS
Subobject Name:
Status: VALID


This table contains Tax Exemption Reason Codes and descriptions. The reason codes are assigned when Exemption Certificate information is entered for a customer. The reason code identifies the reason for the Exemption Certificate (for example, government agencies and schools are usually tax exempt in the United States).


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
TX_TXRE_CDS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnEXEMPT_REASCODE
Columns
Name Datatype Length Mandatory Comments
EXEMPT_REASCODE VARCHAR2 (4) Yes Exemption reason code.
EXEMPT_DESC VARCHAR2 (70) Yes User entered tax description
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
Query Text

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


SELECT EXEMPT_REASCODE
,      EXEMPT_DESC
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
FROM GML.TX_TXRE_CDS;

Dependencies

[top of page]

GML.TX_TXRE_CDS does not reference any database object

GML.TX_TXRE_CDS is referenced by following:

SchemaGML
ViewTX_TXRE_CDS#