[Home] [Help] [Dependency Information]
Object Name: | JL_BR_AR_TX_GROUP_ALL |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_BR_AR_TX_GROUP_ALL |
Subobject Name: | |
Status: | VALID |
This table stores the grouping of related tax categories and is the table on which the Latin Tax Groups window is based. Each row is an association of tax category with a combination of transaction nature, contributor type and establishment type, which is valid between START_DATE_ACTIVE and END_DATE_ACTIVE.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_BR_AR_TX_GROUP_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
TRANSACTION_NATURE
CONTRIBUTOR_TYPE ESTABLISHMENT_TYPE GROUP_TAX_ID TAX_CATEGORY_ID END_DATE_ACTIVE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_TAX_ID | NUMBER | (15) | Yes | Group tax identifier |
TAX_CATEGORY_ID | NUMBER | (15) | Yes | Identifier of tax category associated with the group |
TRANSACTION_NATURE | VARCHAR2 | (25) | Yes | Transaction nature |
CONTRIBUTOR_TYPE | VARCHAR2 | (25) | Yes | Contributor type |
ESTABLISHMENT_TYPE | VARCHAR2 | (25) | Yes | Establishment type |
END_DATE_ACTIVE | DATE | Yes | Inactive date | |
START_DATE_ACTIVE | DATE | Effective date | ||
COMPOUND_PRECEDENCE | NUMBER | (4) | Precedence order to compound taxes within the group | |
MIN_AMOUNT | NUMBER | Minimum tax amount | ||
MIN_PERCENTAGE | NUMBER | Minimum tax percentage | ||
TAX_INCLUSIVE | VARCHAR2 | (1) | Tax included in amount (Y/N) | |
TRIBUTARY_SUBSTITUTION | VARCHAR2 | (1) | Eligible for tributary substitution ('Y/N') | |
USED_TO_REDUCE | VARCHAR2 | (1) | Reserved for future use | |
TAX_CATEGORY_TO_REDUCE_ID | NUMBER | (15) | Tax category identifier used to reduce the tax if Tributary Substitution is checked or else the tax category to compound the base width | |
TAX_CODE | VARCHAR2 | (50) | Default tax code defining the rate | |
CALCULATE_IN_OE | VARCHAR2 | (1) | Tax category calculated in the Sales Order Tax amount added to the sales order total amount ('Y/N') | |
ORG_ID | NUMBER | Multiorg identifier. Populated only if multiorg feature installed. | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_TAX_ID
, TAX_CATEGORY_ID
, TRANSACTION_NATURE
, CONTRIBUTOR_TYPE
, ESTABLISHMENT_TYPE
, END_DATE_ACTIVE
, START_DATE_ACTIVE
, COMPOUND_PRECEDENCE
, MIN_AMOUNT
, MIN_PERCENTAGE
, TAX_INCLUSIVE
, TRIBUTARY_SUBSTITUTION
, USED_TO_REDUCE
, TAX_CATEGORY_TO_REDUCE_ID
, TAX_CODE
, CALCULATE_IN_OE
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM JL.JL_BR_AR_TX_GROUP_ALL;
JL.JL_BR_AR_TX_GROUP_ALL does not reference any database object
JL.JL_BR_AR_TX_GROUP_ALL is referenced by following:
|
|
|