eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JA.JAI_FBT_SETTLEMENT

Object Details

Object Name:	JAI_FBT_SETTLEMENT
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_FBT_SETTLEMENT
Subobject Name:
Status:	VALID

This table is used to store the quarterly settlements for Fringe Benefit Tax

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_FBT_SETTLEMENT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SETTLEMENT_ID
JAI_FBT_SETTLEMENT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEGAL_ENTITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal Entity Identifier
PERIOD_START_DATE	DATE		Yes	Period Start Date
PERIOD_END_DATE	DATE		Yes	Period End Date
CONSOLIDATED_AMOUNT	NUMBER			Consolidated Amount
PROJECTED_AMOUNT	NUMBER			Projected Amount
SETTLEMENT_DATE	DATE			Settlement Date
INV_SUPPLIER_ID	NUMBER	(15)		Invoice Supplier Identifier
INV_SUPPLIER_SITE_ID	NUMBER	(15)		Invoice Supplier site
INV_OU_ID	NUMBER	(15)		Invoice Operating Unit Identifier
IT_CHALLAN	VARCHAR2	(50)		IT Challan number
RETURN_GENERATE_FLAG	VARCHAR2	(1)		Return Generated Flag. Possible values are 'Y','N'
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
DEPOSIT_DATE	DATE			Date on which Fringe Benefit Tax is deposited in the bank
BANK_NAME	VARCHAR2	(50)		Name of the bank in which Fringe Benefit Tax is deposited
BRANCH_NAME	VARCHAR2	(50)		Name of the Branch in which Fringe Benefit Tax is deposited
SETTLEMENT_ID	NUMBER	(15)	Yes	Settlement Identifier

Query Text

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


SELECT LEGAL_ENTITY_ID
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      CONSOLIDATED_AMOUNT
,      PROJECTED_AMOUNT
,      SETTLEMENT_DATE
,      INV_SUPPLIER_ID
,      INV_SUPPLIER_SITE_ID
,      INV_OU_ID
,      IT_CHALLAN
,      RETURN_GENERATE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DEPOSIT_DATE
,      BANK_NAME
,      BRANCH_NAME
,      SETTLEMENT_ID
FROM JA.JAI_FBT_SETTLEMENT;

Dependencies

[top of page]

JA.JAI_FBT_SETTLEMENT does not reference any database object

JA.JAI_FBT_SETTLEMENT is referenced by following:

JA: JAI_FBT_SETTLEMENT#