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: JL.JL_CO_FA_ADJUSTMENTS

Object Details

Object Name:	JL_CO_FA_ADJUSTMENTS
Object Type:	TABLE
Owner:	JL
FND Design Data:	JL.JL_CO_FA_ADJUSTMENTS
Subobject Name:
Status:	VALID

JL_CO_FA_ADJUSTMENTS stores the accounting information used for posting transactions to General Ledger and for audit trail purposes. All the journal entries created by Oracle Assets for Colombia have entries in this table.
The structure of the table resembles FA_ADJUSTMENTS.
To allow reconciliation with General Ledger, two identifiers have been created. One, stored in JE_HEADER_REFERENCE, represents the journal entry header (note that it is not a foreign key to GL_JE_HEADERS). The other, stored in LINE_SEQUENCE, is a line number identifier (note that it may differ from GL_JE_LINES.line_num).
SOURCE_TYPE_CODE can have the following values:
INFLN ADJUST/CIP INFLN ADJUST - Revaluation transactions,
IA ADDITION/ IA CIP ADDITION - Inflation Adjustment transactions caused by addition,
IA ADJUSTMENT/ IA CIP ADJUSTMENT - Inflation Adjustment transactions caused by adjustments,
IA RECLASS/IA CIP RECLASS - Inflation Adjustment transactions caused by reclassification,
IA TRANSFER/IA CIP TRANSFER - Inflation Adjustment transactions caused by transfers,
IA RETIREMENT/IA CIP RETIREMENT - Inflation Adjustment transactions caused by retirements,
DEPRECIATION - Regular depreciation entries, and
TECH_APPR_REVAL - Technical Appraisal Revaluation transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_CO_FA_ADJUSTMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISTRIBUTION_ID BOOK_TYPE_CODE PERIOD_COUNTER_CREATED SOURCE_TYPE_CODE
JL_CO_FA_ADJUSTMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID BOOK_TYPE_CODE PERIOD_COUNTER_CREATED
JL_CO_FA_ADJUSTMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JE_HEADER_REFERENCE_ID SEQUENCE_LINE
JL_CO_FA_ADJUSTMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE PERIOD_COUNTER_CREATED
JL_CO_FA_ADJUSTMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JE_CATEGORY_NAME BOOK_TYPE_CODE PERIOD_COUNTER_CREATED

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_HEADER_ID	NUMBER	(15)		Unique identifier to the transaction adjustments
SOURCE_TYPE_CODE	VARCHAR2	(15)	Yes	Type of adjustment transaction
JE_CATEGORY_NAME	VARCHAR2	(25)	Yes	Journal entry category name
ADJUSTMENT_TYPE	VARCHAR2	(15)	Yes	Type of account this adjustment affects
DEBIT_CREDIT_FLAG	VARCHAR2	(2)	Yes	Indicates whether to debit(DB) or credit(CR) the account
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Account number to which the adjustment is posted
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Depreciation book name
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
ADJUSTMENT_AMOUNT	NUMBER		Yes	Amount of the adjustment
DISTRIBUTION_ID	NUMBER	(15)		Distribution line identification number
ANNUALIZED_ADJUSTMENT	NUMBER			Adjustment amount for a period multiplied by number of periods in fiscal year for retroactive transactions
JE_HEADER_REFERENCE_ID	NUMBER	(15)		Sequence assigned to journal entry headers once they are posted to GL. The number is unique for each journal entry and it is inserted in the column REFERENCE22 of the table GL_INTERFACE.
SEQUENCE_LINE	NUMBER	(15)		Sequence line assigned to rows inserted in the column REFERENCE22 of the table GL_INTERFACE
PERIOD_COUNTER_ADJUSTED	NUMBER	(15)	Yes	Period in which the adjustment transaction applies
PERIOD_COUNTER_CREATED	NUMBER	(15)	Yes	Period in which the adjustment was entered
ASSET_INVOICE_ID	NUMBER	(15)		Invoice, if there is an invoice associated with the adjustment
REFERENCE	VARCHAR2	(150)		Transaction Reference column
POSTING_FLAG	VARCHAR2	(1)		Flag indicating if row is Pending (NULL or Entered) or Posting (Completed) to GL
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column

Query Text

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


SELECT TRANSACTION_HEADER_ID
,      SOURCE_TYPE_CODE
,      JE_CATEGORY_NAME
,      ADJUSTMENT_TYPE
,      DEBIT_CREDIT_FLAG
,      CODE_COMBINATION_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      ADJUSTMENT_AMOUNT
,      DISTRIBUTION_ID
,      ANNUALIZED_ADJUSTMENT
,      JE_HEADER_REFERENCE_ID
,      SEQUENCE_LINE
,      PERIOD_COUNTER_ADJUSTED
,      PERIOD_COUNTER_CREATED
,      ASSET_INVOICE_ID
,      REFERENCE
,      POSTING_FLAG
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM JL.JL_CO_FA_ADJUSTMENTS;

Dependencies

[top of page]

JL.JL_CO_FA_ADJUSTMENTS does not reference any database object

JL.JL_CO_FA_ADJUSTMENTS is referenced by following:

JL: JL_CO_FA_ADJUSTMENTS#