[Home] [Help] [Dependency Information]
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'.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
---|
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 |
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;
AX.AX_SLE_LINES does not reference any database object
AX.AX_SLE_LINES is referenced by following:
|
|
|