[Home] [Help] [Dependency Information]
Object Name: | GL_TAX_OPTIONS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_TAX_OPTIONS |
Subobject Name: | |
Status: | VALID |
GL_TAX_OPTIONS stores the tax option information defined in the Tax Options form. In a multi-org environment, this table will contain one record for each organization for which tax has been set up. In a non-multi-org environment, this table will contain one record for each ledger for which tax has been set up.
Each record contains the precision and minimum accountable unit to be used when generating tax lines, plus the calculation level, the default input and output tax codes and rounding rules, and other information.
There is a one-to-many relationship between a row in this table and rows in the GL_TAX_OPTION_ACCOUNTS table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_TAX_OPTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LEDGER_ID
ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
ORG_ID | NUMBER | (15) | Yes | Organization defining column |
TAX_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency for tax calculations |
TAX_PRECISION | NUMBER | (15) | Yes | Precision for tax calculations |
TAX_MAU | NUMBER | Minimum accountable unit for tax calculations | ||
CALCULATION_LEVEL_CODE | VARCHAR2 | (1) | Yes | Level at which the tax amount will be rounded (Line or Journal) |
ALLOW_ROUNDING_OVERRIDE_FLAG | VARCHAR2 | (1) | Yes | Determines whether you are allowed to change the rounding rule in the Manual Journal Entry form |
INPUT_ROUNDING_RULE_CODE | VARCHAR2 | (1) | Yes | Default input rounding rule |
OUTPUT_ROUNDING_RULE_CODE | VARCHAR2 | (1) | Yes | Default output rounding rule |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
INPUT_TAX_CODE | VARCHAR2 | (50) | Default input tax code | |
INPUT_AMT_INCL_TAX_FLAG | VARCHAR2 | (1) | Default value for determining whether an input amount includes tax | |
OUTPUT_TAX_CODE | VARCHAR2 | (50) | Default output tax code | |
OUTPUT_AMT_INCL_TAX_FLAG | VARCHAR2 | (1) | Default value for determining whether an output amount includes tax | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, ORG_ID
, TAX_CURRENCY_CODE
, TAX_PRECISION
, TAX_MAU
, CALCULATION_LEVEL_CODE
, ALLOW_ROUNDING_OVERRIDE_FLAG
, INPUT_ROUNDING_RULE_CODE
, OUTPUT_ROUNDING_RULE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, INPUT_TAX_CODE
, INPUT_AMT_INCL_TAX_FLAG
, OUTPUT_TAX_CODE
, OUTPUT_AMT_INCL_TAX_FLAG
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM GL.GL_TAX_OPTIONS;
GL.GL_TAX_OPTIONS does not reference any database object
GL.GL_TAX_OPTIONS is referenced by following:
|
|
|