[Home] [Help] [Dependency Information]
Object Name: | AX_SLE_LINES_ARCH# |
---|---|
Object Type: | VIEW |
Owner: | AX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOURNAL_SEQUENCE_ID | NUMBER | (15) | Yes | |
SLE_HEADER_ID | NUMBER | Yes | ||
SLE_LINE_NUM | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
GL_POSTED_FLAG | VARCHAR2 | (1) | Yes | |
GL_POSTED_DATE | DATE | |||
CODE_COMBINATION_ID | NUMBER | Yes | ||
ACCOUNTED_CR | NUMBER | |||
ACCOUNTED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
ENTERED_DR | NUMBER | |||
THIRD_PARTY_ID | NUMBER | |||
SUB_ID | NUMBER | |||
COMMENT_LINE | VARCHAR2 | (2000) | ||
REFERENCE_1 | VARCHAR2 | (240) | ||
REFERENCE_2 | VARCHAR2 | (240) | ||
REFERENCE_3 | VARCHAR2 | (240) | ||
REFERENCE_4 | VARCHAR2 | (240) | ||
REFERENCE_5 | VARCHAR2 | (240) | ||
REFERENCE_6 | VARCHAR2 | (240) | ||
REFERENCE_7 | VARCHAR2 | (240) | ||
REFERENCE_8 | VARCHAR2 | (240) | ||
REFERENCE_9 | VARCHAR2 | (240) | ||
REFERENCE_10 | VARCHAR2 | (240) | ||
REFERENCE_11 | VARCHAR2 | (240) | ||
REFERENCE_12 | VARCHAR2 | (240) | ||
REFERENCE_13 | VARCHAR2 | (240) | ||
REFERENCE_14 | VARCHAR2 | (240) | ||
REFERENCE_15 | VARCHAR2 | (240) | ||
REFERENCE_16 | VARCHAR2 | (240) | ||
REFERENCE_17 | VARCHAR2 | (240) | ||
REFERENCE_18 | VARCHAR2 | (240) | ||
REFERENCE_19 | VARCHAR2 | (240) | ||
REFERENCE_20 | VARCHAR2 | (240) | ||
REFERENCE_21 | VARCHAR2 | (240) | ||
REFERENCE_22 | VARCHAR2 | (240) | ||
REFERENCE_23 | VARCHAR2 | (240) | ||
REFERENCE_24 | VARCHAR2 | (240) | ||
REFERENCE_25 | VARCHAR2 | (240) | ||
REFERENCE_26 | VARCHAR2 | (240) | ||
REFERENCE_27 | VARCHAR2 | (240) | ||
REFERENCE_28 | VARCHAR2 | (240) | ||
REFERENCE_29 | VARCHAR2 | (240) | ||
REFERENCE_30 | VARCHAR2 | (240) | ||
REFERENCE_31 | VARCHAR2 | (240) | ||
REFERENCE_32 | VARCHAR2 | (240) | ||
REFERENCE_33 | VARCHAR2 | (240) | ||
REFERENCE_34 | VARCHAR2 | (240) | ||
REFERENCE_35 | VARCHAR2 | (240) | ||
REFERENCE_36 | VARCHAR2 | (240) | ||
REFERENCE_37 | VARCHAR2 | (240) | ||
REFERENCE_38 | VARCHAR2 | (240) | ||
REFERENCE_39 | VARCHAR2 | (240) | ||
REFERENCE_40 | VARCHAR2 | (240) | ||
REFERENCE_41 | VARCHAR2 | (240) | ||
REFERENCE_42 | VARCHAR2 | (240) | ||
REFERENCE_43 | VARCHAR2 | (240) | ||
REFERENCE_44 | VARCHAR2 | (240) | ||
REFERENCE_45 | VARCHAR2 | (240) | ||
REFERENCE_46 | VARCHAR2 | (240) | ||
REFERENCE_47 | VARCHAR2 | (240) | ||
REFERENCE_48 | VARCHAR2 | (240) | ||
REFERENCE_49 | VARCHAR2 | (240) | ||
REFERENCE_50 | VARCHAR2 | (240) | ||
REFERENCE_51 | VARCHAR2 | (240) | ||
REFERENCE_52 | VARCHAR2 | (240) | ||
REFERENCE_53 | VARCHAR2 | (240) | ||
REFERENCE_54 | VARCHAR2 | (240) | ||
REFERENCE_55 | VARCHAR2 | (240) | ||
REFERENCE_56 | VARCHAR2 | (240) | ||
REFERENCE_57 | VARCHAR2 | (240) | ||
REFERENCE_58 | VARCHAR2 | (240) | ||
REFERENCE_59 | VARCHAR2 | (240) | ||
REFERENCE_60 | VARCHAR2 | (240) | ||
ORG_ID | NUMBER | (15) | ||
BALANCE_FLAG | VARCHAR2 | (1) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
REFERENCE_NUM1 | NUMBER | |||
REFERENCE_NUM2 | NUMBER | |||
REFERENCE_NUM3 | NUMBER | |||
REFERENCE_NUM4 | NUMBER | |||
REFERENCE_NUM5 | NUMBER | |||
REFERENCE_NUM6 | NUMBER | |||
REFERENCE_NUM7 | NUMBER | |||
REFERENCE_NUM8 | NUMBER | |||
REFERENCE_NUM9 | NUMBER | |||
REFERENCE_NUM10 | NUMBER | |||
REFERENCE_DATE1 | DATE | |||
REFERENCE_DATE2 | DATE | |||
REFERENCE_DATE3 | DATE | |||
REFERENCE_DATE4 | DATE | |||
REFERENCE_DATE5 | DATE | |||
REFERENCE_DATE6 | DATE | |||
REFERENCE_DATE7 | DATE | |||
REFERENCE_DATE8 | DATE | |||
REFERENCE_DATE9 | DATE | |||
REFERENCE_DATE10 | DATE | |||
SOURCE_ID | NUMBER | (15) | ||
SOURCE_TABLE | VARCHAR2 | (30) | ||
APPLIED_FROM_DOC_ENTITY | VARCHAR2 | (30) | ||
APPLIED_FROM_DOC_ID | NUMBER | (15) | ||
APPLIED_TO_DOC_ENTITY | VARCHAR2 | (30) | ||
APPLIED_TO_DOC_ID | NUMBER | (15) | ||
TAX_CODE_ID | NUMBER | (15) | ||
LOCATION_SEGMENT_ID | NUMBER | (15) | ||
TAX_LINK_ID | NUMBER | (15) | ||
TAXABLE_ENTERED_DR | NUMBER | |||
TAXABLE_ENTERED_CR | NUMBER | |||
TAXABLE_ACCOUNTED_DR | NUMBER | |||
TAXABLE_ACCOUNTED_CR | NUMBER | |||
STAT_AMOUNT | NUMBER | |||
LINE_TYPE | VARCHAR2 | (30) | ||
GL_SL_LINK_ID | NUMBER | (15) | ||
GL_TRANSFER_LINE_NUM | NUMBER | |||
APPLICATION_ID | NUMBER | Yes | ||
SET_OF_BOOKS_ID | NUMBER | Yes |
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_ARCH#;
|
|
|