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: AX.AX_SLE_LINES

Object Details

Object Name:	AX_SLE_LINES
Object Type:	TABLE
Owner:	AX
FND Design Data:	AX.AX_SLE_LINES
Subobject Name:
Status:	VALID

This table stores subledger accounting entry lines. An accounting entry line is either a
debit or a credit. Accounting entry lines are grouped together by an accounting entry header.
The combination of the header and its lines comprises an accounting entry. All lines
grouped under a header are balanced, meaning that the total debits equals the total credits for
the functional currency. Each row is one accounting entry line.
The BALANCE_FLAG is set to 'Y' when the row has contributed to a balance;
it is either NULL or N otherwise.
Only lines with the account code combination with the control account qualifier set can have the BALANCE_FLAG set to 'Y'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: AX_SLE_LINES_PK

SET_OF_BOOKS_ID
JOURNAL_SEQUENCE_ID
SLE_HEADER_ID
SLE_LINE_NUM

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_SLE_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID JOURNAL_SEQUENCE_ID SLE_HEADER_ID SLE_LINE_NUM
AX_SLE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BALANCE_FLAG JOURNAL_SEQUENCE_ID SLE_HEADER_ID
AX_SLE_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THIRD_PARTY_ID SUB_ID
AX_SLE_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOURNAL_SEQUENCE_ID SLE_HEADER_ID GL_POSTED_FLAG
AX_SLE_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE_10 REFERENCE_9
AX_SLE_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
AX_SLE_LINES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOURNAL_SEQUENCE_ID SLE_HEADER_ID GL_TRANSFER_LINE_NUM
AX_SLE_LINES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TABLE SOURCE_ID
AX_SLE_LINES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID REFERENCE_22 REFERENCE_14 JOURNAL_SEQUENCE_ID SLE_HEADER_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AX_SLE_LINES		AX_SLE_HEADERS	AX_SLE_LINES SET_OF_BOOKS_ID AX_SLE_LINES JOURNAL_SEQUENCE_ID AX_SLE_LINES SLE_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
JOURNAL_SEQUENCE_ID	NUMBER	(15)	Yes	Journal sequence identifier
SLE_HEADER_ID	NUMBER		Yes	Value of the journal sequence
SLE_LINE_NUM	NUMBER		Yes	Entry line number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Extended Who column
PROGRAM_APPLICATION_ID	NUMBER			Extended Who column
PROGRAM_ID	NUMBER			Extended Who column
PROGRAM_UPDATE_DATE	DATE			Extended Who column
GL_POSTED_FLAG	VARCHAR2	(1)	Yes	Line transferred to GL flag
GL_POSTED_DATE	DATE			Date line transferred to GL
CODE_COMBINATION_ID	NUMBER		Yes	Code combination identifier
ACCOUNTED_CR	NUMBER			Credit in functional currency
ACCOUNTED_DR	NUMBER			Debit in functional currency
ENTERED_CR	NUMBER			Credit in transaction currency
ENTERED_DR	NUMBER			Debit in transaction currency
THIRD_PARTY_ID	NUMBER			Third party identifier
SUB_ID	NUMBER			Third party suborganization identifier
COMMENT_LINE	VARCHAR2	(2000)		Comment
REFERENCE_1	VARCHAR2	(240)		Character reference column
REFERENCE_2	VARCHAR2	(240)		Character reference column
REFERENCE_3	VARCHAR2	(240)		Character reference column
REFERENCE_4	VARCHAR2	(240)		Character reference column
REFERENCE_5	VARCHAR2	(240)		Character reference column
REFERENCE_6	VARCHAR2	(240)		Character reference column
REFERENCE_7	VARCHAR2	(240)		Character reference column
REFERENCE_8	VARCHAR2	(240)		Character reference column
REFERENCE_9	VARCHAR2	(240)		Reference column (reserved for Global Accounting Engine use)
REFERENCE_10	VARCHAR2	(240)		Reference column (reserved for Global Accounting Engine use)
REFERENCE_11	VARCHAR2	(240)		Character reference column
REFERENCE_12	VARCHAR2	(240)		Character reference column
REFERENCE_13	VARCHAR2	(240)		Character reference column
REFERENCE_14	VARCHAR2	(240)		Character reference column
REFERENCE_15	VARCHAR2	(240)		Character reference column
REFERENCE_16	VARCHAR2	(240)		Character reference column
REFERENCE_17	VARCHAR2	(240)		Used to contain the conversion date for cross-currency (now no longer used)
REFERENCE_18	VARCHAR2	(240)		Used to contain the conversion rate for cross-currency (now no longer used)
REFERENCE_19	VARCHAR2	(240)		Used to contain the conversion type for cross-currency (now no longer used)
REFERENCE_20	VARCHAR2	(240)		Used to contain the currency code for cross-currency transaction (now no longer used)
REFERENCE_21	VARCHAR2	(240)		Character reference column
REFERENCE_22	VARCHAR2	(240)		Character reference column
REFERENCE_23	VARCHAR2	(240)		Character reference column
REFERENCE_24	VARCHAR2	(240)		Character reference column
REFERENCE_25	VARCHAR2	(240)		Character reference column
REFERENCE_26	VARCHAR2	(240)		Character reference column
REFERENCE_27	VARCHAR2	(240)		Character reference column
REFERENCE_28	VARCHAR2	(240)		Character reference column
REFERENCE_29	VARCHAR2	(240)		Character reference column
REFERENCE_30	VARCHAR2	(240)		Character reference column
REFERENCE_31	VARCHAR2	(240)		Character reference column
REFERENCE_32	VARCHAR2	(240)		Character reference column
REFERENCE_33	VARCHAR2	(240)		Character reference column
REFERENCE_34	VARCHAR2	(240)		Character reference column
REFERENCE_35	VARCHAR2	(240)		Character reference column
REFERENCE_36	VARCHAR2	(240)		Character reference column
REFERENCE_37	VARCHAR2	(240)		Character reference column
REFERENCE_38	VARCHAR2	(240)		Character reference column
REFERENCE_39	VARCHAR2	(240)		Character reference column
REFERENCE_40	VARCHAR2	(240)		Character reference column
REFERENCE_41	VARCHAR2	(240)		Character reference column
REFERENCE_42	VARCHAR2	(240)		Character reference column
REFERENCE_43	VARCHAR2	(240)		Character reference column
REFERENCE_44	VARCHAR2	(240)		Character reference column
REFERENCE_45	VARCHAR2	(240)		Character reference column
REFERENCE_46	VARCHAR2	(240)		Character reference column
REFERENCE_47	VARCHAR2	(240)		Character reference column
REFERENCE_48	VARCHAR2	(240)		Character reference column
REFERENCE_49	VARCHAR2	(240)		Character reference column
REFERENCE_50	VARCHAR2	(240)		Character reference column
REFERENCE_51	VARCHAR2	(240)		Character reference column
REFERENCE_52	VARCHAR2	(240)		Character reference column
REFERENCE_53	VARCHAR2	(240)		Character reference column
REFERENCE_54	VARCHAR2	(240)		Character reference column
REFERENCE_55	VARCHAR2	(240)		Character reference column
REFERENCE_56	VARCHAR2	(240)		Character reference column
REFERENCE_57	VARCHAR2	(240)		Character reference column
REFERENCE_58	VARCHAR2	(240)		Character reference column
REFERENCE_59	VARCHAR2	(240)		Character reference column
REFERENCE_60	VARCHAR2	(240)		Character reference column
ORG_ID	NUMBER	(15)		Organization identifier
BALANCE_FLAG	VARCHAR2	(1)		Line contributed to balance calculation
CURRENCY_CODE	VARCHAR2	(15)		Currency code of an entered currency of a cross-currency transaction
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Exchange rate type for foreign currency accounting entry line
CURRENCY_CONVERSION_DATE	DATE			Date currency exchange rate is effective.
CURRENCY_CONVERSION_RATE	NUMBER			Currency exchange rate used to convert a foreign currency amount to a functional currency amount
REFERENCE_NUM1	NUMBER			Numeric reference column
REFERENCE_NUM2	NUMBER			Numeric reference column
REFERENCE_NUM3	NUMBER			Numeric reference column
REFERENCE_NUM4	NUMBER			Numeric reference column
REFERENCE_NUM5	NUMBER			Numeric reference column
REFERENCE_NUM6	NUMBER			Numeric reference column
REFERENCE_NUM7	NUMBER			Numeric reference column
REFERENCE_NUM8	NUMBER			Numeric reference column
REFERENCE_NUM9	NUMBER			Numeric reference column
REFERENCE_NUM10	NUMBER			Numeric reference column
REFERENCE_DATE1	DATE			Date reference column
REFERENCE_DATE2	DATE			Date reference column
REFERENCE_DATE3	DATE			Date reference column
REFERENCE_DATE4	DATE			Date reference column
REFERENCE_DATE5	DATE			Date reference column
REFERENCE_DATE6	DATE			Date reference column
REFERENCE_DATE7	DATE			Date reference column
REFERENCE_DATE8	DATE			Date reference column
REFERENCE_DATE9	DATE			Date reference column
REFERENCE_DATE10	DATE			Date reference column
SOURCE_ID	NUMBER	(15)		Foreign key to the transaction originating the accounting entry line
SOURCE_TABLE	VARCHAR2	(30)		Source table of the transaction that created this accounting entry line (for future use)
APPLIED_FROM_DOC_ENTITY	VARCHAR2	(30)		For future use
APPLIED_FROM_DOC_ID	NUMBER	(15)		For future use
APPLIED_TO_DOC_ENTITY	VARCHAR2	(30)		For future use
APPLIED_TO_DOC_ID	NUMBER	(15)		For future use
TAX_CODE_ID	NUMBER	(15)		Tax code identifier, along with the application identifier and set of books identifier, uniquely identifies a tax code in AP or AR
LOCATION_SEGMENT_ID	NUMBER	(15)		Foreign key to AR_LOCATION_VALUES to determine location based tax for AR (for future use)
TAX_LINK_ID	NUMBER	(15)		Link tax line with the associated accounting line (for future use)
TAXABLE_ENTERED_DR	NUMBER			Debit taxable amount in entered currency
TAXABLE_ENTERED_CR	NUMBER			Credit taxable amount in entered currency
TAXABLE_ACCOUNTED_DR	NUMBER			Debit taxable amount in functional currency
TAXABLE_ACCOUNTED_CR	NUMBER			Credit taxable amount in functional currency
STAT_AMOUNT	NUMBER			Statistical amount
LINE_TYPE	VARCHAR2	(30)		The type of account the accounting line is posted for (for future use)
GL_SL_LINK_ID	NUMBER	(15)		Identifier used for maintaining audit trail upon transfer of the accounting entry line to GL (for future use)
GL_TRANSFER_LINE_NUM	NUMBER			GL Transfer Line num
APPLICATION_ID	NUMBER		Yes	Application identifier
SET_OF_BOOKS_ID	NUMBER		Yes	Set of books identifier

Query Text

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


SELECT JOURNAL_SEQUENCE_ID
,      SLE_HEADER_ID
,      SLE_LINE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GL_POSTED_FLAG
,      GL_POSTED_DATE
,      CODE_COMBINATION_ID
,      ACCOUNTED_CR
,      ACCOUNTED_DR
,      ENTERED_CR
,      ENTERED_DR
,      THIRD_PARTY_ID
,      SUB_ID
,      COMMENT_LINE
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
,      REFERENCE_6
,      REFERENCE_7
,      REFERENCE_8
,      REFERENCE_9
,      REFERENCE_10
,      REFERENCE_11
,      REFERENCE_12
,      REFERENCE_13
,      REFERENCE_14
,      REFERENCE_15
,      REFERENCE_16
,      REFERENCE_17
,      REFERENCE_18
,      REFERENCE_19
,      REFERENCE_20
,      REFERENCE_21
,      REFERENCE_22
,      REFERENCE_23
,      REFERENCE_24
,      REFERENCE_25
,      REFERENCE_26
,      REFERENCE_27
,      REFERENCE_28
,      REFERENCE_29
,      REFERENCE_30
,      REFERENCE_31
,      REFERENCE_32
,      REFERENCE_33
,      REFERENCE_34
,      REFERENCE_35
,      REFERENCE_36
,      REFERENCE_37
,      REFERENCE_38
,      REFERENCE_39
,      REFERENCE_40
,      REFERENCE_41
,      REFERENCE_42
,      REFERENCE_43
,      REFERENCE_44
,      REFERENCE_45
,      REFERENCE_46
,      REFERENCE_47
,      REFERENCE_48
,      REFERENCE_49
,      REFERENCE_50
,      REFERENCE_51
,      REFERENCE_52
,      REFERENCE_53
,      REFERENCE_54
,      REFERENCE_55
,      REFERENCE_56
,      REFERENCE_57
,      REFERENCE_58
,      REFERENCE_59
,      REFERENCE_60
,      ORG_ID
,      BALANCE_FLAG
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      REFERENCE_NUM1
,      REFERENCE_NUM2
,      REFERENCE_NUM3
,      REFERENCE_NUM4
,      REFERENCE_NUM5
,      REFERENCE_NUM6
,      REFERENCE_NUM7
,      REFERENCE_NUM8
,      REFERENCE_NUM9
,      REFERENCE_NUM10
,      REFERENCE_DATE1
,      REFERENCE_DATE2
,      REFERENCE_DATE3
,      REFERENCE_DATE4
,      REFERENCE_DATE5
,      REFERENCE_DATE6
,      REFERENCE_DATE7
,      REFERENCE_DATE8
,      REFERENCE_DATE9
,      REFERENCE_DATE10
,      SOURCE_ID
,      SOURCE_TABLE
,      APPLIED_FROM_DOC_ENTITY
,      APPLIED_FROM_DOC_ID
,      APPLIED_TO_DOC_ENTITY
,      APPLIED_TO_DOC_ID
,      TAX_CODE_ID
,      LOCATION_SEGMENT_ID
,      TAX_LINK_ID
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      STAT_AMOUNT
,      LINE_TYPE
,      GL_SL_LINK_ID
,      GL_TRANSFER_LINE_NUM
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
FROM AX.AX_SLE_LINES;

Dependencies

[top of page]

AX.AX_SLE_LINES does not reference any database object

AX.AX_SLE_LINES is referenced by following:

APPS: AX_SLE_LINES