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: PN.PN_AE_LINES_ALL

Object Details

Object Name:	PN_AE_LINES_ALL
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_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 the transaction currency and in the 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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_AE_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AE_LINE_ID
PN_AE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
PN_AE_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TABLE SOURCE_ID
PN_AE_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_SL_LINK_ID
PN_AE_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AE_LINE_TYPE_CODE
PN_AE_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AE_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AE_LINE_ID	NUMBER	(15)	Yes	Uniquely identifies the accounting lines.
AE_HEADER_ID	NUMBER	(15)	Yes	Accounting header ID.
AE_LINE_NUMBER	NUMBER	(15)		Sequential number for the accounting line within the accounting entry.
AE_LINE_TYPE_CODE	VARCHAR2	(30)	Yes	Account class of the accounting line.
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Code combination for the account.
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code.
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type.
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date.
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate.
ENTERED_DR	NUMBER			The debit amount in the denomination currency.
ENTERED_CR	NUMBER			The credit amount in the denomination currency.
ACCOUNTED_DR	NUMBER			The debit amount in the accounting currency.
ACCOUNTED_CR	NUMBER			The credit amount in the accounting currency.
SOURCE_TABLE	VARCHAR2	(30)	Yes	Table name of the source the accounting line is linked (for example,PN_PAYMENT_ITEMS).
SOURCE_ID	NUMBER	(15)	Yes	The ID of the source document PAYMENT_ITEM_ID.
ACCOUNT_OVERLAY_SOURCE_ID	NUMBER	(15)		Column required for XLA.
GL_SL_LINK_ID	NUMBER	(15)		Used for maintaining audit trail upon transfer to GL.
DESCRIPTION	VARCHAR2	(240)		Accounting entry line description.
ACCOUNTING_ERROR_CODE	VARCHAR2	(30)		Accounting errors.
GL_TRANSFER_ERROR_CODE	VARCHAR2	(30)		GL transfer errors.
THIRD_PARTY_ID	NUMBER	(15)		Vendor/customer ID.
THIRD_PARTY_SUB_ID	NUMBER	(15)		Vendor/customer site ID.
STAT_AMOUNT	NUMBER			Column required for XLA.
SUBLEDGER_DOC_SEQUENCE_ID	NUMBER	(15)		Column required for XLA.
SUBLEDGER_DOC_SEQUENCE_VALUE	NUMBER	(15)		Column required for XLA.
ORG_ID	NUMBER	(15)		Organization identifier
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Column required for XLA.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
REFERENCE1	VARCHAR2	(240)		Journal Import reference column.
REFERENCE2	VARCHAR2	(240)		Journal Import reference column.
REFERENCE3	VARCHAR2	(240)		Journal Import reference column.
REFERENCE4	VARCHAR2	(240)		Journal Import reference column.
REFERENCE5	VARCHAR2	(240)		Journal Import reference column.
REFERENCE6	VARCHAR2	(240)		Journal Import reference column.
REFERENCE7	VARCHAR2	(240)		Journal Import reference column.
REFERENCE8	VARCHAR2	(240)		Journal Import reference column.
REFERENCE9	VARCHAR2	(240)		Journal Import reference column.
REFERENCE10	VARCHAR2	(240)		Journal Import reference column.
APPLIED_FROM_TRX_HDR_TABLE	VARCHAR2	(30)		Column required for XLA.
APPLIED_FROM_TRX_HDR_ID	NUMBER	(15)		Column required for XLA.
APPLIED_TO_TRX_HDR_TABLE	VARCHAR2	(30)		Column required for XLA.
APPLIED_TO_TRX_HDR_ID	NUMBER	(15)		Column required for XLA.
TAX_CODE_ID	NUMBER	(15)		Column required for XLA.
TAXABLE_ENTERED_DR	NUMBER			Column required for XLA.
TAXABLE_ENTERED_CR	NUMBER			Column required for XLA.
TAXABLE_ACCOUNTED_DR	NUMBER			Column required for XLA.
TAXABLE_ACCOUNTED_CR	NUMBER			Column required for XLA.
TAX_LINK_ID	NUMBER	(15)		Column required for XLA.

Query Text

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


SELECT AE_LINE_ID
,      AE_HEADER_ID
,      AE_LINE_NUMBER
,      AE_LINE_TYPE_CODE
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      SOURCE_TABLE
,      SOURCE_ID
,      ACCOUNT_OVERLAY_SOURCE_ID
,      GL_SL_LINK_ID
,      DESCRIPTION
,      ACCOUNTING_ERROR_CODE
,      GL_TRANSFER_ERROR_CODE
,      THIRD_PARTY_ID
,      THIRD_PARTY_SUB_ID
,      STAT_AMOUNT
,      SUBLEDGER_DOC_SEQUENCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
,      ORG_ID
,      CREATION_DATE
,      USSGL_TRANSACTION_CODE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      APPLIED_FROM_TRX_HDR_TABLE
,      APPLIED_FROM_TRX_HDR_ID
,      APPLIED_TO_TRX_HDR_TABLE
,      APPLIED_TO_TRX_HDR_ID
,      TAX_CODE_ID
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      TAX_LINK_ID
FROM PN.PN_AE_LINES_ALL;

Dependencies

[top of page]

PN.PN_AE_LINES_ALL does not reference any database object

PN.PN_AE_LINES_ALL is referenced by following:

PN: PN_AE_LINES_ALL#