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: OKL.OKL_AE_LINES_ALL

Object Details

Object Name:	OKL_AE_LINES_ALL
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_AE_LINES_ALL
Subobject Name:
Status:	VALID

An accounting entry line is an entity containing a proper accounting entry with debits or credits both in transaction currency as well as functional currency along with an account and other reference information pointing to the transaction data that originated the accounting entry line. An accounting entry line is grouped with other accounting entry lines for a specific accounting entry header. Any such group of accounting entry lines should result in balanced entries in the functional currency.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_AE_LINES_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AE_LINE_ID
OKL_AE_LINES_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AE_HEADER_ID
OKL_AE_LINES_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
OKL_AE_LINES_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CONVERSION_TYPE
OKL_AE_LINES_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
OKL_AE_LINES_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ID SOURCE_TABLE
OKL_AE_LINES_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CODE
OKL_AE_LINES_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE3
OKL_AE_LINES_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AE_LINE_ID	NUMBER		Yes	Accounting entry line identifier
ACCOUNT_OVERLAY_SOURCE_ID	NUMBER	(15)		Invoice distribution identifier used for flexbuilding the accounting entry line account when automatic offsets is on. Not used by OKL
SUBLEDGER_DOC_SEQUENCE_VALUE	NUMBER	(15)		Document sequence identifier from transaction data associated with accounting entry line
TAX_CODE_ID	NUMBER	(15)		Tax code identifier associated with tax invoice distributions. Not used by OKL
AE_LINE_NUMBER	NUMBER	(15)	Yes	Sequential number for accounting entry line within accounting entry header. E.g. 1, 2, 3
CODE_COMBINATION_ID	NUMBER		Yes	Key flexfield combination defining column
AE_HEADER_ID	NUMBER		Yes	Accounting entry header identifier
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Exchange rate type for foreign currency accounting entry line
AE_LINE_TYPE_CODE	VARCHAR2	(30)	Yes	Accounting entry line type. E.g. Liability, Charge, etc
SOURCE_TABLE	VARCHAR2	(90)	Yes	Table where transaction record associated with accounting entry line resides. Some of the values are OKL_TXL_CNTRCT_LNS, OKL_TXL_ASSETS_B etc. Points to FND lookup OKL_SOURCE_TABLE
SOURCE_ID	NUMBER		Yes	Primary key value for transaction originating the current accounting entry line
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
CURRENCY_CODE	VARCHAR2	(3)	Yes	Currency code
CURRENCY_CONVERSION_DATE	DATE			Date currency conversion rate is effective
CURRENCY_CONVERSION_RATE	NUMBER			Exchange rate for foreign currency accounting entry line
ENTERED_DR	NUMBER			Debit amount in transaction currency
ENTERED_CR	NUMBER			Credit amount in transaction currency
ACCOUNTED_DR	NUMBER			Debit amount in functional currency
ACCOUNTED_CR	NUMBER			Credit amount in functional currency
REFERENCE1	VARCHAR2	(720)		Journal import reference column
REFERENCE2	VARCHAR2	(720)		Journal import reference column
REFERENCE3	VARCHAR2	(720)		Journal import reference column
REFERENCE4	VARCHAR2	(720)		Journal import reference column
REFERENCE5	VARCHAR2	(720)		Journal import reference column
REFERENCE6	VARCHAR2	(720)		Journal import reference column
REFERENCE7	VARCHAR2	(720)		Journal import reference column
REFERENCE8	VARCHAR2	(720)		Journal import reference column
REFERENCE9	VARCHAR2	(720)		Journal import reference column
REFERENCE10	VARCHAR2	(720)		Journal import reference column
DESCRIPTION	VARCHAR2	(720)		User entered description
THIRD_PARTY_ID	NUMBER			Supplier identifier. Not used by OKL.
THIRD_PARTY_SUB_ID	NUMBER			Supplier site identifier. Not used by OKL.
STAT_AMOUNT	NUMBER			Amount for measuring statistical quantities, copied over from associated invoice distribution. Not used by OKL.
USSGL_TRANSACTION_CODE	VARCHAR2	(90)		Transaction code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables). Copied over from associated invoice distribution. Not used by OKL.
SUBLEDGER_DOC_SEQUENCE_ID	NUMBER			Document sequence value from transaction data associated with accounting entry line
ACCOUNTING_ERROR_CODE	VARCHAR2	(90)		Accounting entry line level error code that was encountered during the OKL Accounting Process
GL_TRANSFER_ERROR_CODE	VARCHAR2	(90)		Accounting entry line level error code that was encountered during the OKL Transfer to GL Process
GL_SL_LINK_ID	NUMBER			Identifier used for maintaining audit trail upon transfer of the accounting entry line to GL
TAXABLE_ENTERED_DR	NUMBER			Debit taxable amount in transaction currency, associated with tax invoice distributions. Not used by OKL.
TAXABLE_ENTERED_CR	NUMBER			Credit taxable amount in transaction currency, associated with tax invoice distributions. Not used by OKL.
TAXABLE_ACCOUNTED_DR	NUMBER			Debit taxable amount in functional currency, associated with tax invoice distributions. Not used by OKL.
TAXABLE_ACCOUNTED_CR	NUMBER			Credit taxable amount in functional currency, associated with tax invoice distributions. Not used by OKL.
APPLIED_FROM_TRX_HDR_TABLE	VARCHAR2	(90)		Not used
APPLIED_FROM_TRX_HDR_ID	NUMBER			Not used
APPLIED_TO_TRX_HDR_TABLE	VARCHAR2	(90)		Not used
APPLIED_TO_TRX_HDR_ID	NUMBER			Not used
TAX_LINK_ID	NUMBER			Not used
ORG_ID	NUMBER			Operating unit identifier
PROGRAM_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_UPDATE_DATE	DATE			Concurrent Manager column
REQUEST_ID	NUMBER	(15)		Concurrent Manager column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		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 AE_LINE_ID
,      ACCOUNT_OVERLAY_SOURCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
,      TAX_CODE_ID
,      AE_LINE_NUMBER
,      CODE_COMBINATION_ID
,      AE_HEADER_ID
,      CURRENCY_CONVERSION_TYPE
,      AE_LINE_TYPE_CODE
,      SOURCE_TABLE
,      SOURCE_ID
,      OBJECT_VERSION_NUMBER
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      DESCRIPTION
,      THIRD_PARTY_ID
,      THIRD_PARTY_SUB_ID
,      STAT_AMOUNT
,      USSGL_TRANSACTION_CODE
,      SUBLEDGER_DOC_SEQUENCE_ID
,      ACCOUNTING_ERROR_CODE
,      GL_TRANSFER_ERROR_CODE
,      GL_SL_LINK_ID
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      APPLIED_FROM_TRX_HDR_TABLE
,      APPLIED_FROM_TRX_HDR_ID
,      APPLIED_TO_TRX_HDR_TABLE
,      APPLIED_TO_TRX_HDR_ID
,      TAX_LINK_ID
,      ORG_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKL.OKL_AE_LINES_ALL;

Dependencies

[top of page]

OKL.OKL_AE_LINES_ALL does not reference any database object

OKL.OKL_AE_LINES_ALL is referenced by following:

APPS: OKL_AE_LINES; OKL_AE_LINES_ALL