[Home] [Help] [Dependency Information]
Object Name: | JL_BR_AR_TX_EXC_FSC_ALL |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_BR_AR_TX_EXC_FSC_ALL |
Subobject Name: | |
Status: | VALID |
This table stores all the exceptions by Fiscal classifications and is the table on which the Latin Exceptions window is based. Each row is an association of tax category and shipment locations with a fiscal classification code, for which either a tax code or a base rate modifier is assigned, and is valid between START_DATE_ACTIVE and END_DATE_ACTIVE. (Optionally, both tax code and base rate modifier could be assigned for a given combination.)
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_BR_AR_TX_EXC_FSC_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
SHIP_FROM_CODE
SHIP_TO_SEGMENT_ID FISCAL_CLASSIFICATION_CODE TAX_CATEGORY_ID END_DATE_ACTIVE |
JL_BR_AR_TX_EXC_FSC_U2 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | EXC_FSC_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_FROM_CODE | VARCHAR2 | (25) | Yes | State ship-from |
SHIP_TO_SEGMENT_ID | NUMBER | (15) | Yes | State ship-to |
FISCAL_CLASSIFICATION_CODE | VARCHAR2 | (25) | Yes | Fiscal classification code |
TAX_CATEGORY_ID | NUMBER | (15) | Yes | Tax category identifier |
END_DATE_ACTIVE | DATE | Yes | Inactive date | |
EXC_FSC_ID | NUMBER | (15) | Yes | Identifier used for legal messages |
START_DATE_ACTIVE | DATE | Effective date | ||
TAX_CODE | VARCHAR2 | (50) | Tax code defining the rate | |
BASE_RATE | NUMBER | Percentage to increase or reduce base amount | ||
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 SHIP_FROM_CODE
, SHIP_TO_SEGMENT_ID
, FISCAL_CLASSIFICATION_CODE
, TAX_CATEGORY_ID
, END_DATE_ACTIVE
, EXC_FSC_ID
, START_DATE_ACTIVE
, TAX_CODE
, BASE_RATE
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM JL.JL_BR_AR_TX_EXC_FSC_ALL;
JL.JL_BR_AR_TX_EXC_FSC_ALL does not reference any database object
JL.JL_BR_AR_TX_EXC_FSC_ALL is referenced by following:
|
|
|