[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | TX_TAXA_MST |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.TX_TAXA_MST
|
| Subobject Name: | |
| Status: | VALID |
This table contains the definition of a Tax Authority. Tax rates for the tax authority are maintained in the table TX_TAXA_DTLl. Tax authorities are jurisdictions which collect tax and to which tax payments are sent. The tax reporting class can be optionally assigned to Tax Authorities to group them for reporting purposes. Tax Authorities can be made "inactive".
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| TX_TAXA_MST_PK | NORMAL | UNIQUE |
APPS_TS_SEED
|
 TAXAUTH_ID
|
| TX_TAXA_MST_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
TAXAUTH_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TAXAUTH_ID | NUMBER | (10) | Yes | Surrogate key. |
| TAXAUTH_DESC | VARCHAR2 | (70) | Description of the tax authority | |
| ADDR_ID | NUMBER | (10) | In sy_addr_mst if >0. | |
| ACTIVE_IND | NUMBER | (5) | Yes | 0=inactive tax authority; 1=default, active tax authority. |
| TAXRPT_CLASS | VARCHAR2 | (8) | In tx_txrp_cls. | |
| TAXAUTH_CODE | VARCHAR2 | (32) | Yes | Unique identifier of tax authority. |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| IN_USE | NUMBER | (10) | Not currently used | |
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT TAXAUTH_ID
, TAXAUTH_DESC
, ADDR_ID
, ACTIVE_IND
, TAXRPT_CLASS
, TAXAUTH_CODE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, IN_USE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE_CATEGORY
, DELETE_MARK
, TEXT_CODE
FROM GML.TX_TAXA_MST;
GML.TX_TAXA_MST does not reference any database object
GML.TX_TAXA_MST is referenced by following:
GML
TX_TAXA_MST#
|
|
|
|