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

TABLE: JA.JAI_FBT_SETUP

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


This table is used to store the Setup information related with Fringe Benefit Tax


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Yes Legal Entity Identifier
ASSESSMENT_STATUS_CODE VARCHAR2 (30) Yes Stores the Assessment Status Code
BUSINESS_TYPE_CODE VARCHAR2 (30) Yes Stores the Business Type Code
FRINGE_BENEFIT_TYPE_CODE VARCHAR2 (30) Yes Fringe Benefit Type
NATURAL_ACCOUNT_VALUE NUMBER (25)
Stores the value of the Segment qualified as Natural Account
TAXABLE_BASIS NUMBER

Taxable basis
FBT_RATE NUMBER

Fringe Benefit Tax Rate
SURCHARGE_RATE NUMBER

Surcharge Rate
EDU_CESS_RATE NUMBER

Fringe Benefit Tax Education Cess
SH_CESS_RATE NUMBER

Fringe Benefit Tax Higher Education Cess
FBT_ACCOUNT_CCID NUMBER (15) Yes Fringe Benefit Tax code combination Identifier
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
,      ASSESSMENT_STATUS_CODE
,      BUSINESS_TYPE_CODE
,      FRINGE_BENEFIT_TYPE_CODE
,      NATURAL_ACCOUNT_VALUE
,      TAXABLE_BASIS
,      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;

Dependencies

[top of page]

JA.JAI_FBT_SETUP does not reference any database object

JA.JAI_FBT_SETUP is referenced by following:

SchemaJA
ViewJAI_FBT_SETUP#