VIEW: AX.AX_SLE_LINES#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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