DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_FBT_SETUP_HEADERS

Object Details
Object Name: JAI_FBT_SETUP_HEADERS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_FBT_SETUP_HEADERS
Subobject Name:
Status: VALID


The table stores the FBT setup information in header level, including Legal entity, FBT year, and tax rate of each tax type


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_FBT_SETUP_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEGAL_ENTITY_ID
ColumnFBT_YEAR
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Yes Legal Entity Identifier
FBT_YEAR NUMBER (9) Yes FBT Year
PERIOD_START_DATE DATE
Yes Period Start Date
PERIOD_END_DATE DATE
Yes Period End Date
ASSESSMENT_STATUS_CODE VARCHAR2 (30) Yes Assessment Status
BUSINESS_TYPE_CODE VARCHAR2 (30) Yes Business Type
FBT_RATE NUMBER

Fringe Benefit Tax Rate
SURCHARGE_RATE NUMBER

Surcharge Rate
EDU_CESS_RATE NUMBER

FBT Education Cess
SH_CESS_RATE NUMBER

FBT SH Cess
FBT_ACCOUNT_CCID NUMBER (15)
FBT code combination Id
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)
Standard who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LEGAL_ENTITY_ID
,      FBT_YEAR
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      ASSESSMENT_STATUS_CODE
,      BUSINESS_TYPE_CODE
,      FBT_RATE
,      SURCHARGE_RATE
,      EDU_CESS_RATE
,      SH_CESS_RATE
,      FBT_ACCOUNT_CCID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM JA.JAI_FBT_SETUP_HEADERS;

Dependencies

[top of page]

JA.JAI_FBT_SETUP_HEADERS does not reference any database object

JA.JAI_FBT_SETUP_HEADERS is referenced by following:

SchemaAPPS
SynonymJAI_FBT_SETUP_HEADERS