[Home] [Help] [Dependency Information]
Object Name: | JL_ZZ_AR_TX_GROUPS_ALL |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_ZZ_AR_TX_GROUPS_ALL |
Subobject Name: | |
Status: | VALID |
This table stores, for a given tax category, the combinations of Organization, Contributor and Transaction condition values for which the tax category is applicable. This table stores condition values for determining factor tax conditions only. Each row represents a combination of condition values for which Oracle Receivables will attempt to calculate tax, if it matches the condition values of the transaction.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_ZZ_AR_TX_GROUPS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
GROUP_TAX_ID
CONTRIBUTOR_TYPE ESTABLISHMENT_TYPE TRANSACTION_NATURE TAX_CATEGORY_ID END_DATE_ACTIVE ORG_ID |
JL_ZZ_AR_TX_GROUPS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
GROUP_TAX_ID
END_DATE_ACTIVE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAX_GROUP_RECORD_ID | NUMBER | (15) | Tax group record Identifier | |
GROUP_TAX_ID | NUMBER | (15) | Yes | Tax Group ID |
TAX_CATEGORY_ID | NUMBER | (15) | Yes | Tax Category Identifier |
ESTABLISHMENT_TYPE | VARCHAR2 | (30) | Yes | Organization Type |
CONTRIBUTOR_TYPE | VARCHAR2 | (30) | Yes | Contributor Type |
TRANSACTION_NATURE | VARCHAR2 | (30) | Yes | Transaction Type |
END_DATE_ACTIVE | DATE | Yes | End Date Active | |
USE_TX_CATEG_THRESHOLDS | VARCHAR2 | (1) | Yes | Indicates thresholds (minimum taxable basis, minimum tax amounts and minimum percentage) |
LAST_UPDATE_DATE | DATE | Yes | Last update Date | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Last Updated by |
COMPOUND_PRECEDENCE | NUMBER | (4) | Compounding precedence - not used | |
MIN_AMOUNT | NUMBER | Minimum Tax amount | ||
MIN_TAXABLE_BASIS | NUMBER | Minimum taxable basis | ||
MIN_PERCENTAGE | NUMBER | Minimum Percentage | ||
TAX_INCLUSIVE | VARCHAR2 | (1) | Tax inclusive indicator- Y/N | |
TRIBUTARY_SUBSTITUTION | VARCHAR2 | (1) | Tributary substitution indicator Y/N | |
USED_TO_REDUCE | VARCHAR2 | (1) | Not used | |
TAX_CODE | VARCHAR2 | (50) | Tax code | |
START_DATE_ACTIVE | DATE | Start date Active | ||
ORG_ID | NUMBER | (15) | Organization Identifier | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Last update Login | |
CREATION_DATE | DATE | Creation Date | ||
CREATED_BY | NUMBER | (15) | Created by | |
TAX_CATEGORY_TO_REDUCE_ID | NUMBER | (15) | Tax category used to compound the tax | |
CALCULATE_IN_OE | VARCHAR2 | (1) | Indicates whether this category needs to be considered in Order Management | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
BASE_RATE | NUMBER | Base Rate Modifier |
Cut, paste (and edit) the following text to query this object:
SELECT TAX_GROUP_RECORD_ID
, GROUP_TAX_ID
, TAX_CATEGORY_ID
, ESTABLISHMENT_TYPE
, CONTRIBUTOR_TYPE
, TRANSACTION_NATURE
, END_DATE_ACTIVE
, USE_TX_CATEG_THRESHOLDS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, COMPOUND_PRECEDENCE
, MIN_AMOUNT
, MIN_TAXABLE_BASIS
, MIN_PERCENTAGE
, TAX_INCLUSIVE
, TRIBUTARY_SUBSTITUTION
, USED_TO_REDUCE
, TAX_CODE
, START_DATE_ACTIVE
, ORG_ID
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, TAX_CATEGORY_TO_REDUCE_ID
, CALCULATE_IN_OE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, BASE_RATE
FROM JL.JL_ZZ_AR_TX_GROUPS_ALL;
JL.JL_ZZ_AR_TX_GROUPS_ALL does not reference any database object
JL.JL_ZZ_AR_TX_GROUPS_ALL is referenced by following:
|
|
|