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_REPOSITORY

Object Details

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

This table is used to store all the transactions that attract Fringe Benefit Tax

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_FBT_REPOSITORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FBT_TRANSACTION_ID
JAI_FBT_REPOSITORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEGAL_ENTITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FBT_TRANSACTION_ID	NUMBER	(15)	Yes	Fringe Benefit Transaction Identifier
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal Entity Identifier
PERIOD_START_DATE	DATE			Period start date
PERIOD_END_DATE	DATE			Period end date
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice Distribution Identifier
INVOICE_DATE	DATE			Invoice Date
INVOICE_CURRENCY_CODE	VARCHAR2	(15)		Invoice Currency
DISTRIBUTION_AMT	NUMBER			Distribution amount
DIST_CODE_COMBINATION_ID	NUMBER	(15)		Invoice Distribution code combination Identifier
DIST_NATURAL_ACCOUNT_VALUE	NUMBER	(25)		Invoice Distribution Natural Account
FRINGE_BENEFIT_TYPE_CODE	VARCHAR2	(30)	Yes	Fringe Benefit Type
FBT_CURRENCY	VARCHAR2	(15)		Fringe Benefit Currency
TAXABLE_BASIS	NUMBER			Taxable Basis
FBT_TAXABLE_AMOUNT	NUMBER			Fringe Benefit taxable amount
FBT_TAX_AMOUNT	NUMBER			Fringe Benefit Tax amount
FBT_SURCHARGE_AMOUNT	NUMBER			Fringe Benefit Surcharge amount
FBT_EDU_CESS_AMOUNT	NUMBER			Fringe Benefit Education Cess Amount
FBT_SH_CESS_AMOUNT	NUMBER			Fringe Benefit Secondary and higher Education Tax
MANUAL_FLAG	VARCHAR2	(1)		Set to Y if the transaction is manually created otherwise NULL
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
SETTLEMENT_ID	NUMBER	(15)		Obsolete for R12 New change
SOURCE	VARCHAR2	(30)		Set to 'Payables' if the transaction is gained from AP; Set to 'Others' if the transaction is gained from GL
JE_HEADER_ID	NUMBER	(15)		Journal Header Identifier.The information get from Gl_je_headers.je_header_id
BATCH_NAME	VARCHAR2	(100)		Journal Batch Name.The information get from Gl_je_batche. name
JE_SOURCE	VARCHAR2	(25)		Journal Source Name.The information get from Gl_je_headers.je_source
JE_NAME	VARCHAR2	(100)		Journal Name.The information get from Gl_je_headers.name/ ap_invoices_all.invoice_num
PERIOD_NAME	VARCHAR2	(15)		Journal Period Name. The information get from Gl_je_headers.period_name
JE_LINE_NUM	NUMBER	(15)		Invoice Line Number and Journal Line Number.The information get from Gl_je_lines.je_line_num/ ap_invoice_lines_all. invoice_line_number
DIST_BALANCE_ACCOUNT_VALUE	VARCHAR2	(25)		Invoice Distribution and Journal lines Balance Account
CONVERSION_RATE	NUMBER			Conversion rate
CONVERTED_AMOUNT	NUMBER			Converted amount
CONVERSION_TYPE	VARCHAR2	(30)		Conversion type
CONVERSION_DATE	DATE			Conversion date
MODIFIED_FLAG	NUMBER	(1)		Flag of manual modified trans from processing "1" stands for manual modified."0" stands for no modification
REFERENCE	VARCHAR2	(240)		Entered manually by user

Query Text

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


SELECT FBT_TRANSACTION_ID
,      LEGAL_ENTITY_ID
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_DATE
,      INVOICE_CURRENCY_CODE
,      DISTRIBUTION_AMT
,      DIST_CODE_COMBINATION_ID
,      DIST_NATURAL_ACCOUNT_VALUE
,      FRINGE_BENEFIT_TYPE_CODE
,      FBT_CURRENCY
,      TAXABLE_BASIS
,      FBT_TAXABLE_AMOUNT
,      FBT_TAX_AMOUNT
,      FBT_SURCHARGE_AMOUNT
,      FBT_EDU_CESS_AMOUNT
,      FBT_SH_CESS_AMOUNT
,      MANUAL_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SETTLEMENT_ID
,      SOURCE
,      JE_HEADER_ID
,      BATCH_NAME
,      JE_SOURCE
,      JE_NAME
,      PERIOD_NAME
,      JE_LINE_NUM
,      DIST_BALANCE_ACCOUNT_VALUE
,      CONVERSION_RATE
,      CONVERTED_AMOUNT
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      MODIFIED_FLAG
,      REFERENCE
FROM JA.JAI_FBT_REPOSITORY;

Dependencies

[top of page]

JA.JAI_FBT_REPOSITORY does not reference any database object

JA.JAI_FBT_REPOSITORY is referenced by following:

JA: JAI_FBT_REPOSITORY#