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

TABLE: JA.JAI_FBT_SETUP_LINES

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


This table is storing the FBT setup line information, such as FBT type code, natural account and taxable basis. The combination of legal_entity_id and fbt_year in the table is corresponding to one in JAI_FBT_SETUP_HEADERS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_FBT_SETUP_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEGAL_ENTITY_ID
ColumnFBT_YEAR
ColumnNATURAL_ACCOUNT_VALUE
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Yes Legal Entity Identifier
FBT_YEAR NUMBER (9) Yes FBT Year
FRINGE_BENEFIT_TYPE_CODE VARCHAR2 (30) Yes Fringe Benefit Type code
NATURAL_ACCOUNT_VALUE VARCHAR2 (25)
Natural Account Value for this kind of Fringe Benefit Type code
TAXABLE_BASIS NUMBER

Taxable basis for this kind of Fringe Benefit Type code
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
,      FRINGE_BENEFIT_TYPE_CODE
,      NATURAL_ACCOUNT_VALUE
,      TAXABLE_BASIS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM JA.JAI_FBT_SETUP_LINES;

Dependencies

[top of page]

JA.JAI_FBT_SETUP_LINES does not reference any database object

JA.JAI_FBT_SETUP_LINES is referenced by following:

SchemaAPPS
SynonymJAI_FBT_SETUP_LINES