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: AP.AP_AE_LINES_ALL

Object Details

Object Name:	AP_AE_LINES_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_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
AP_AE_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AE_LINE_ID
AP_AE_LINES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	AE_HEADER_ID AE_LINE_NUMBER
AP_AE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
AP_AE_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TABLE SOURCE_ID
AP_AE_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_SL_LINK_ID
AP_AE_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THIRD_PARTY_ID THIRD_PARTY_SUB_ID
AP_AE_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AE_LINE_TYPE_CODE
AP_AE_LINES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNT_OVERLAY_SOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AE_LINE_ID	NUMBER	(15)	Yes	Accounting entry line identifier
AE_HEADER_ID	NUMBER	(15)	Yes	Accounting entry header identifier
AE_LINE_NUMBER	NUMBER	(15)		Sequential number for accounting entry line within accounting entry header. E.g. 1, 2, 3
AE_LINE_TYPE_CODE	VARCHAR2	(30)	Yes	Accounting entry line type. E.g. Liability, Charge, etc
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Accounting flexfield identifier for account associated with accounting entry line. For those lines whose account is invalid, or could not be built, the value will be -1
CURRENCY_CODE	VARCHAR2	(15)	Yes	Entered currency for the transaction data associated with the accounting entry line
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Exchange rate type for foreign currency accounting entry line
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
SOURCE_TABLE	VARCHAR2	(30)	Yes	Table where transaction document associated with accounting entry line resides. Possible values are: AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, AP_CHECKS, AP_INVOICE_PAYMENTS
SOURCE_ID	NUMBER	(15)	Yes	Primary key for document originating the current accounting entry line. Depending on the value for source_table it will contain either invoice_id, invoice_distribution_id, check_id or invoice_payment_id
ACCOUNT_OVERLAY_SOURCE_ID	NUMBER	(15)		Invoice distribution identifier used for flexbuilding the accounting entry line account when automatic offsets is on
GL_SL_LINK_ID	NUMBER	(15)		Identifier used for maintaining audit trail upon transfer of the accounting entry line to GL
DESCRIPTION	VARCHAR2	(240)		Accounting entry line description
ACCOUNTING_ERROR_CODE	VARCHAR2	(30)		Accounting entry line level error code that was encountered during the Payables Accounting Process
GL_TRANSFER_ERROR_CODE	VARCHAR2	(30)		Accounting entry line level error code that was encountered during the Payables Transfer to GL Process
THIRD_PARTY_ID	NUMBER	(15)		Supplier identifier
THIRD_PARTY_SUB_ID	NUMBER	(15)		Supplier site identifier
STAT_AMOUNT	NUMBER			Amount for measuring statistical quantities, copied over from associated invoice distribution
SUBLEDGER_DOC_SEQUENCE_ID	NUMBER	(15)		Document sequence identifier from transaction data associated with accounting entry line
SUBLEDGER_DOC_SEQUENCE_VALUE	NUMBER	(15)		Document sequence value from transaction data associated with accounting entry line
ORG_ID	NUMBER	(15)		Organization identifier
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Transaction code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables). Copied over from associated invoice distribution
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)		Not currently used
APPLIED_FROM_TRX_HDR_ID	NUMBER	(15)		Not currently used
APPLIED_TO_TRX_HDR_TABLE	VARCHAR2	(30)		Not currently used
APPLIED_TO_TRX_HDR_ID	NUMBER	(15)		Not currently used
TAX_CODE_ID	NUMBER	(15)		No longer used
TAXABLE_ENTERED_DR	NUMBER			Debit taxable amount in transaction currency, associated with tax invoice distributions
TAXABLE_ENTERED_CR	NUMBER			Credit taxable amount in transaction currency, associated with tax invoice distributions
TAXABLE_ACCOUNTED_DR	NUMBER			Debit taxable amount in functional currency, associated with tax invoice distributions
TAXABLE_ACCOUNTED_CR	NUMBER			Credit taxable amount in functional currency, associated with tax invoice distributions
TAX_LINK_ID	NUMBER	(15)		No longer used

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 AP.AP_AE_LINES_ALL;

Dependencies

[top of page]

AP.AP_AE_LINES_ALL does not reference any database object

AP.AP_AE_LINES_ALL is referenced by following:

AP: AP_AE_LINES_ALL#