[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XLA_AE_LINES_GT |
|---|---|
| Object Type: | TABLE |
| Owner: | XLA |
| FND Design Data: |  XLA.XLA_AE_LINES_GT
|
| Subobject Name: | |
| Status: | VALID |
XLA.XLA_AE_LINES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XLA_AE_LINES_GT_U1 | NORMAL | UNIQUE |
|
 LEDGER_ID
REF_AE_HEADER_ID
TEMP_LINE_NUM
AE_HEADER_ID
HEADER_NUM
EVENT_ID
|
| XLA_AE_LINES_GT_N1 | NORMAL | NONUNIQUE |
|
SL_COA_MAPPING_ID
|
| XLA_AE_LINES_GT_N2 | NORMAL | NONUNIQUE |
|
LEDGER_ID
AE_HEADER_ID
TEMP_LINE_NUM
BALANCE_TYPE_CODE
|
| XLA_AE_LINES_GT_N3 | NORMAL | NONUNIQUE |
|
LEDGER_ID
AE_HEADER_ID
GAIN_OR_LOSS_FLAG
CALCULATE_G_L_AMTS_FLAG
|
| XLA_AE_LINES_GT_N4 | NORMAL | NONUNIQUE |
|
LEDGER_ID
AE_HEADER_ID
BALANCE_TYPE_CODE
GAIN_OR_LOSS_REF
GAIN_OR_LOSS_FLAG
EVENT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AE_HEADER_ID | NUMBER | (15) | Yes | |
| TEMP_LINE_NUM | NUMBER | (15) | Yes | |
| AE_LINE_NUM | NUMBER | (15) | ||
| LINE_HASH_NUM | NUMBER | (15) | ||
| EVENT_ID | NUMBER | (15) | ||
| REF_EVENT_ID | NUMBER | (15) | ||
| REF_AE_HEADER_ID | NUMBER | (15) | Yes | |
| REF_AE_LINE_NUM | NUMBER | (15) | ||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | (30) | ||
| EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
| LINE_DEFINITION_OWNER_CODE | VARCHAR2 | (30) | ||
| LINE_DEFINITION_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | (1) | ||
| ACCOUNTING_LINE_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_LINE_NAME | VARCHAR2 | (80) | ||
| CODE_COMBINATION_STATUS_CODE | VARCHAR2 | (30) | ||
| CODE_COMBINATION_ID | NUMBER | |||
| SL_COA_MAPPING_NAME | VARCHAR2 | (33) | ||
| DYNAMIC_INSERT_FLAG | VARCHAR2 | (1) | ||
| SWITCH_SIDE_FLAG | VARCHAR2 | (1) | ||
| SOURCE_COA_ID | NUMBER | (15) | ||
| CCID_COA_ID | NUMBER | (15) | ||
| SEGMENT1 | VARCHAR2 | (30) | ||
| SEGMENT2 | VARCHAR2 | (30) | ||
| SEGMENT3 | VARCHAR2 | (30) | ||
| SEGMENT4 | VARCHAR2 | (30) | ||
| SEGMENT5 | VARCHAR2 | (30) | ||
| SEGMENT6 | VARCHAR2 | (30) | ||
| SEGMENT7 | VARCHAR2 | (30) | ||
| SEGMENT8 | VARCHAR2 | (30) | ||
| SEGMENT9 | VARCHAR2 | (30) | ||
| SEGMENT10 | VARCHAR2 | (30) | ||
| SEGMENT11 | VARCHAR2 | (30) | ||
| SEGMENT12 | VARCHAR2 | (30) | ||
| SEGMENT13 | VARCHAR2 | (30) | ||
| SEGMENT14 | VARCHAR2 | (30) | ||
| SEGMENT15 | VARCHAR2 | (30) | ||
| SEGMENT16 | VARCHAR2 | (30) | ||
| SEGMENT17 | VARCHAR2 | (30) | ||
| SEGMENT18 | VARCHAR2 | (30) | ||
| SEGMENT19 | VARCHAR2 | (30) | ||
| SEGMENT20 | VARCHAR2 | (30) | ||
| SEGMENT21 | VARCHAR2 | (30) | ||
| SEGMENT22 | VARCHAR2 | (30) | ||
| SEGMENT23 | VARCHAR2 | (30) | ||
| SEGMENT24 | VARCHAR2 | (30) | ||
| SEGMENT25 | VARCHAR2 | (30) | ||
| SEGMENT26 | VARCHAR2 | (30) | ||
| SEGMENT27 | VARCHAR2 | (30) | ||
| SEGMENT28 | VARCHAR2 | (30) | ||
| SEGMENT29 | VARCHAR2 | (30) | ||
| SEGMENT30 | VARCHAR2 | (30) | ||
| DESCRIPTION | VARCHAR2 | (1996) | ||
| GL_TRANSFER_MODE_CODE | VARCHAR2 | (1) | ||
| MERGE_DUPLICATE_CODE | VARCHAR2 | (1) | ||
| PARTY_ID | NUMBER | (15) | ||
| PARTY_SITE_ID | NUMBER | (15) | ||
| PARTY_TYPE_CODE | VARCHAR2 | (1) | ||
| ENTERED_AMOUNT | NUMBER | |||
| LEDGER_AMOUNT | NUMBER | |||
| ENTERED_DR | NUMBER | |||
| ENTERED_CR | NUMBER | |||
| ACCOUNTED_DR | NUMBER | |||
| ACCOUNTED_CR | NUMBER | |||
| STATISTICAL_AMOUNT | NUMBER | |||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_DATE | DATE | |||
| CURRENCY_CONVERSION_RATE | NUMBER | |||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
| JGZZ_RECON_REF | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_1 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_2 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_3 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | (240) | ||
| SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | |||
| SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | |||
| SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | |||
| SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | |||
| SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | |||
| SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
| TAX_LINE_REF_ID | NUMBER | (15) | ||
| TAX_SUMMARY_LINE_REF_ID | NUMBER | (15) | ||
| TAX_REC_NREC_DIST_REF_ID | NUMBER | (15) | ||
| DEFERRED_INDICATOR | VARCHAR2 | (1) | ||
| DEFERRED_START_DATE | DATE | |||
| DEFERRED_END_DATE | DATE | |||
| DEFERRED_NO_PERIOD | NUMBER | |||
| DEFERRED_PERIOD_TYPE | VARCHAR2 | (1) | ||
| ANALYTICAL_BALANCE_FLAG | VARCHAR2 | (1) | ||
| ANC_ID_1 | VARCHAR2 | (240) | ||
| ANC_ID_2 | VARCHAR2 | (240) | ||
| ANC_ID_3 | VARCHAR2 | (240) | ||
| ANC_ID_4 | VARCHAR2 | (240) | ||
| ANC_ID_5 | VARCHAR2 | (240) | ||
| ANC_ID_6 | VARCHAR2 | (240) | ||
| ANC_ID_7 | VARCHAR2 | (240) | ||
| ANC_ID_8 | VARCHAR2 | (240) | ||
| ANC_ID_9 | VARCHAR2 | (240) | ||
| ANC_ID_10 | VARCHAR2 | (240) | ||
| ANC_ID_11 | VARCHAR2 | (240) | ||
| ANC_ID_12 | VARCHAR2 | (240) | ||
| ANC_ID_13 | VARCHAR2 | (240) | ||
| ANC_ID_14 | VARCHAR2 | (240) | ||
| ANC_ID_15 | VARCHAR2 | (240) | ||
| ANC_ID_16 | VARCHAR2 | (240) | ||
| ANC_ID_17 | VARCHAR2 | (240) | ||
| ANC_ID_18 | VARCHAR2 | (240) | ||
| ANC_ID_19 | VARCHAR2 | (240) | ||
| ANC_ID_20 | VARCHAR2 | (240) | ||
| ANC_ID_21 | VARCHAR2 | (240) | ||
| ANC_ID_22 | VARCHAR2 | (240) | ||
| ANC_ID_23 | VARCHAR2 | (240) | ||
| ANC_ID_24 | VARCHAR2 | (240) | ||
| ANC_ID_25 | VARCHAR2 | (240) | ||
| ANC_ID_26 | VARCHAR2 | (240) | ||
| ANC_ID_27 | VARCHAR2 | (240) | ||
| ANC_ID_28 | VARCHAR2 | (240) | ||
| ANC_ID_29 | VARCHAR2 | (240) | ||
| ANC_ID_30 | VARCHAR2 | (240) | ||
| ANC_ID_31 | VARCHAR2 | (240) | ||
| ANC_ID_32 | VARCHAR2 | (240) | ||
| ANC_ID_33 | VARCHAR2 | (240) | ||
| ANC_ID_34 | VARCHAR2 | (240) | ||
| ANC_ID_35 | VARCHAR2 | (240) | ||
| ANC_ID_36 | VARCHAR2 | (240) | ||
| ANC_ID_37 | VARCHAR2 | (240) | ||
| ANC_ID_38 | VARCHAR2 | (240) | ||
| ANC_ID_39 | VARCHAR2 | (240) | ||
| ANC_ID_40 | VARCHAR2 | (240) | ||
| ANC_ID_41 | VARCHAR2 | (240) | ||
| ANC_ID_42 | VARCHAR2 | (240) | ||
| ANC_ID_43 | VARCHAR2 | (240) | ||
| ANC_ID_44 | VARCHAR2 | (240) | ||
| ANC_ID_45 | VARCHAR2 | (240) | ||
| ANC_ID_46 | VARCHAR2 | (240) | ||
| ANC_ID_47 | VARCHAR2 | (240) | ||
| ANC_ID_48 | VARCHAR2 | (240) | ||
| ANC_ID_49 | VARCHAR2 | (240) | ||
| ANC_ID_50 | VARCHAR2 | (240) | ||
| ANC_ID_51 | VARCHAR2 | (240) | ||
| ANC_ID_52 | VARCHAR2 | (240) | ||
| ANC_ID_53 | VARCHAR2 | (240) | ||
| ANC_ID_54 | VARCHAR2 | (240) | ||
| ANC_ID_55 | VARCHAR2 | (240) | ||
| ANC_ID_56 | VARCHAR2 | (240) | ||
| ANC_ID_57 | VARCHAR2 | (240) | ||
| ANC_ID_58 | VARCHAR2 | (240) | ||
| ANC_ID_59 | VARCHAR2 | (240) | ||
| ANC_ID_60 | VARCHAR2 | (240) | ||
| ANC_ID_61 | VARCHAR2 | (240) | ||
| ANC_ID_62 | VARCHAR2 | (240) | ||
| ANC_ID_63 | VARCHAR2 | (240) | ||
| ANC_ID_64 | VARCHAR2 | (240) | ||
| ANC_ID_65 | VARCHAR2 | (240) | ||
| ANC_ID_66 | VARCHAR2 | (240) | ||
| ANC_ID_67 | VARCHAR2 | (240) | ||
| ANC_ID_68 | VARCHAR2 | (240) | ||
| ANC_ID_69 | VARCHAR2 | (240) | ||
| ANC_ID_70 | VARCHAR2 | (240) | ||
| ANC_ID_71 | VARCHAR2 | (240) | ||
| ANC_ID_72 | VARCHAR2 | (240) | ||
| ANC_ID_73 | VARCHAR2 | (240) | ||
| ANC_ID_74 | VARCHAR2 | (240) | ||
| ANC_ID_75 | VARCHAR2 | (240) | ||
| ANC_ID_76 | VARCHAR2 | (240) | ||
| ANC_ID_77 | VARCHAR2 | (240) | ||
| ANC_ID_78 | VARCHAR2 | (240) | ||
| ANC_ID_79 | VARCHAR2 | (240) | ||
| ANC_ID_80 | VARCHAR2 | (240) | ||
| ANC_ID_81 | VARCHAR2 | (240) | ||
| ANC_ID_82 | VARCHAR2 | (240) | ||
| ANC_ID_83 | VARCHAR2 | (240) | ||
| ANC_ID_84 | VARCHAR2 | (240) | ||
| ANC_ID_85 | VARCHAR2 | (240) | ||
| ANC_ID_86 | VARCHAR2 | (240) | ||
| ANC_ID_87 | VARCHAR2 | (240) | ||
| ANC_ID_88 | VARCHAR2 | (240) | ||
| ANC_ID_89 | VARCHAR2 | (240) | ||
| ANC_ID_90 | VARCHAR2 | (240) | ||
| ANC_ID_91 | VARCHAR2 | (240) | ||
| ANC_ID_92 | VARCHAR2 | (240) | ||
| ANC_ID_93 | VARCHAR2 | (240) | ||
| ANC_ID_94 | VARCHAR2 | (240) | ||
| ANC_ID_95 | VARCHAR2 | (240) | ||
| ANC_ID_96 | VARCHAR2 | (240) | ||
| ANC_ID_97 | VARCHAR2 | (240) | ||
| ANC_ID_98 | VARCHAR2 | (240) | ||
| ANC_ID_99 | VARCHAR2 | (240) | ||
| ANC_ID_100 | VARCHAR2 | (240) | ||
| BALANCE_TYPE_CODE | VARCHAR2 | (30) | ||
| MERGE_INDEX | NUMBER | (15) | ||
| LEDGER_ID | NUMBER | (15) | ||
| ENTITY_ID | NUMBER | (15) | ||
| REVERSE_DIST_ID_CHAR_1 | VARCHAR2 | (240) | ||
| REVERSE_DIST_ID_CHAR_2 | VARCHAR2 | (240) | ||
| REVERSE_DIST_ID_CHAR_3 | VARCHAR2 | (240) | ||
| REVERSE_DIST_ID_CHAR_4 | VARCHAR2 | (240) | ||
| REVERSE_DIST_ID_CHAR_5 | VARCHAR2 | (240) | ||
| REVERSE_DIST_ID_NUM_1 | NUMBER | (15) | ||
| REVERSE_DIST_ID_NUM_2 | NUMBER | (15) | ||
| REVERSE_DIST_ID_NUM_3 | NUMBER | (15) | ||
| REVERSE_DIST_ID_NUM_4 | NUMBER | (15) | ||
| REVERSE_DIST_ID_NUM_5 | NUMBER | (15) | ||
| REVERSE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
| EVENT_NUMBER | NUMBER | (15) | ||
| ACCOUNTING_ENTRY_STATUS_CODE | VARCHAR2 | (30) | ||
| REVERSAL_CODE | VARCHAR2 | (30) | ||
| CALCULATE_ACCTD_AMTS_FLAG | VARCHAR2 | (1) | ||
| CALCULATE_G_L_AMTS_FLAG | VARCHAR2 | (1) | ||
| GAIN_OR_LOSS_FLAG | VARCHAR2 | (1) | ||
| ROUNDING_CLASS_CODE | VARCHAR2 | (30) | ||
| DOCUMENT_ROUNDING_LEVEL | VARCHAR2 | (30) | ||
| UNROUNDED_ACCOUNTED_DR | NUMBER | |||
| UNROUNDED_ACCOUNTED_CR | NUMBER | |||
| EXTRACT_LINE_NUM | NUMBER | |||
| ALT_CODE_COMBINATION_ID | NUMBER | |||
| ALT_SEGMENT1 | VARCHAR2 | (30) | ||
| ALT_SEGMENT2 | VARCHAR2 | (30) | ||
| ALT_SEGMENT3 | VARCHAR2 | (30) | ||
| ALT_SEGMENT4 | VARCHAR2 | (30) | ||
| ALT_SEGMENT5 | VARCHAR2 | (30) | ||
| ALT_SEGMENT6 | VARCHAR2 | (30) | ||
| ALT_SEGMENT7 | VARCHAR2 | (30) | ||
| ALT_SEGMENT8 | VARCHAR2 | (30) | ||
| ALT_SEGMENT9 | VARCHAR2 | (30) | ||
| ALT_SEGMENT10 | VARCHAR2 | (30) | ||
| ALT_SEGMENT11 | VARCHAR2 | (30) | ||
| ALT_SEGMENT12 | VARCHAR2 | (30) | ||
| ALT_SEGMENT13 | VARCHAR2 | (30) | ||
| ALT_SEGMENT14 | VARCHAR2 | (30) | ||
| ALT_SEGMENT15 | VARCHAR2 | (30) | ||
| ALT_SEGMENT16 | VARCHAR2 | (30) | ||
| ALT_SEGMENT17 | VARCHAR2 | (30) | ||
| ALT_SEGMENT18 | VARCHAR2 | (30) | ||
| ALT_SEGMENT19 | VARCHAR2 | (30) | ||
| ALT_SEGMENT20 | VARCHAR2 | (30) | ||
| ALT_SEGMENT21 | VARCHAR2 | (30) | ||
| ALT_SEGMENT22 | VARCHAR2 | (30) | ||
| ALT_SEGMENT23 | VARCHAR2 | (30) | ||
| ALT_SEGMENT24 | VARCHAR2 | (30) | ||
| ALT_SEGMENT25 | VARCHAR2 | (30) | ||
| ALT_SEGMENT26 | VARCHAR2 | (30) | ||
| ALT_SEGMENT27 | VARCHAR2 | (30) | ||
| ALT_SEGMENT28 | VARCHAR2 | (30) | ||
| ALT_SEGMENT29 | VARCHAR2 | (30) | ||
| ALT_SEGMENT30 | VARCHAR2 | (30) | ||
| ALT_CCID_STATUS_CODE | VARCHAR2 | (30) | ||
| UNROUNDED_ENTERED_DR | NUMBER | |||
| UNROUNDED_ENTERED_CR | NUMBER | |||
| DOC_ROUNDING_ENTERED_AMT | NUMBER | |||
| DOC_ROUNDING_ACCTD_AMT | NUMBER | |||
| ENTERED_CURRENCY_MAU | NUMBER | |||
| BUSINESS_METHOD_CODE | VARCHAR2 | (30) | ||
| BUSINESS_CLASS_CODE | VARCHAR2 | (30) | ||
| INHERIT_DESC_FLAG | VARCHAR2 | (1) | Yes | |
| BFLOW_APPLICATION_ID | NUMBER | (15) | ||
| BFLOW_ENTITY_CODE | VARCHAR2 | (30) | ||
| BFLOW_SOURCE_ID_NUM_1 | NUMBER | (15) | ||
| BFLOW_SOURCE_ID_NUM_2 | NUMBER | (15) | ||
| BFLOW_SOURCE_ID_NUM_3 | NUMBER | (15) | ||
| BFLOW_SOURCE_ID_NUM_4 | NUMBER | (15) | ||
| BFLOW_SOURCE_ID_CHAR_1 | VARCHAR2 | (30) | ||
| BFLOW_SOURCE_ID_CHAR_2 | VARCHAR2 | (30) | ||
| BFLOW_SOURCE_ID_CHAR_3 | VARCHAR2 | (30) | ||
| BFLOW_SOURCE_ID_CHAR_4 | VARCHAR2 | (30) | ||
| BFLOW_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
| BFLOW_DIST_ID_NUM_1 | NUMBER | (15) | ||
| BFLOW_DIST_ID_NUM_2 | NUMBER | (15) | ||
| BFLOW_DIST_ID_NUM_3 | NUMBER | (15) | ||
| BFLOW_DIST_ID_NUM_4 | NUMBER | (15) | ||
| BFLOW_DIST_ID_NUM_5 | NUMBER | (15) | ||
| BFLOW_DIST_ID_CHAR_1 | VARCHAR2 | (30) | ||
| BFLOW_DIST_ID_CHAR_2 | VARCHAR2 | (30) | ||
| BFLOW_DIST_ID_CHAR_3 | VARCHAR2 | (30) | ||
| BFLOW_DIST_ID_CHAR_4 | VARCHAR2 | (30) | ||
| BFLOW_DIST_ID_CHAR_5 | VARCHAR2 | (30) | ||
| BFLOW_PRIOR_ENTRY_STATUS_CODE | VARCHAR2 | (30) | ||
| SL_COA_MAPPING_ID | NUMBER | |||
| NATURAL_SIDE_CODE | VARCHAR2 | (30) | ||
| TEMP_CURRENCY_CODE | VARCHAR2 | (15) | ||
| TEMP_REF_AE_HEADER_ID | NUMBER | (15) | ||
| REF_TEMP_LINE_NUM | NUMBER | (15) | ||
| APPLIED_TO_ENTITY_ID | NUMBER | (15) | ||
| ALLOC_TO_APPLICATION_ID | NUMBER | (15) | ||
| ALLOC_TO_ENTITY_CODE | VARCHAR2 | (30) | ||
| ALLOC_TO_SOURCE_ID_NUM_1 | NUMBER | (15) | ||
| ALLOC_TO_SOURCE_ID_NUM_2 | NUMBER | (15) | ||
| ALLOC_TO_SOURCE_ID_NUM_3 | NUMBER | (15) | ||
| ALLOC_TO_SOURCE_ID_NUM_4 | NUMBER | (15) | ||
| ALLOC_TO_SOURCE_ID_CHAR_1 | VARCHAR2 | (30) | ||
| ALLOC_TO_SOURCE_ID_CHAR_2 | VARCHAR2 | (30) | ||
| ALLOC_TO_SOURCE_ID_CHAR_3 | VARCHAR2 | (30) | ||
| ALLOC_TO_SOURCE_ID_CHAR_4 | VARCHAR2 | (30) | ||
| ALLOC_TO_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
| ALLOC_TO_DIST_ID_NUM_1 | NUMBER | (15) | ||
| ALLOC_TO_DIST_ID_NUM_2 | NUMBER | (15) | ||
| ALLOC_TO_DIST_ID_NUM_3 | NUMBER | (15) | ||
| ALLOC_TO_DIST_ID_NUM_4 | NUMBER | (15) | ||
| ALLOC_TO_DIST_ID_NUM_5 | NUMBER | (15) | ||
| ALLOC_TO_DIST_ID_CHAR_1 | VARCHAR2 | (30) | ||
| ALLOC_TO_DIST_ID_CHAR_2 | VARCHAR2 | (30) | ||
| ALLOC_TO_DIST_ID_CHAR_3 | VARCHAR2 | (30) | ||
| ALLOC_TO_DIST_ID_CHAR_4 | VARCHAR2 | (30) | ||
| ALLOC_TO_DIST_ID_CHAR_5 | VARCHAR2 | (30) | ||
| MPA_ACCRUAL_ENTRY_FLAG | VARCHAR2 | (1) | ||
| ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
| HEADER_NUM | NUMBER | (15) | ||
| ACCOUNTING_DATE | DATE | |||
| MULTIPERIOD_END_DATE | DATE | |||
| MULTIPERIOD_START_DATE | DATE | |||
| MULTIPERIOD_OPTION_FLAG | VARCHAR2 | (1) | ||
| GAIN_OR_LOSS_REF | VARCHAR2 | (30) | Used to group entry lines together when calculating gain/loss. | |
| BFLOW_APPLIED_TO_AMOUNT | NUMBER | Used in calculating the accounted amount when foreign exchange is used in business flow. | ||
| OVERRIDE_ACCTD_AMT_FLAG | VARCHAR2 | (1) | ||
| DERIVED_EXCH_RATE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT AE_HEADER_ID
, TEMP_LINE_NUM
, AE_LINE_NUM
, LINE_HASH_NUM
, EVENT_ID
, REF_EVENT_ID
, REF_AE_HEADER_ID
, REF_AE_LINE_NUM
, ACCOUNTING_CLASS_CODE
, EVENT_CLASS_CODE
, EVENT_TYPE_CODE
, LINE_DEFINITION_OWNER_CODE
, LINE_DEFINITION_CODE
, ACCOUNTING_LINE_TYPE_CODE
, ACCOUNTING_LINE_CODE
, ACCOUNTING_LINE_NAME
, CODE_COMBINATION_STATUS_CODE
, CODE_COMBINATION_ID
, SL_COA_MAPPING_NAME
, DYNAMIC_INSERT_FLAG
, SWITCH_SIDE_FLAG
, SOURCE_COA_ID
, CCID_COA_ID
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, DESCRIPTION
, GL_TRANSFER_MODE_CODE
, MERGE_DUPLICATE_CODE
, PARTY_ID
, PARTY_SITE_ID
, PARTY_TYPE_CODE
, ENTERED_AMOUNT
, LEDGER_AMOUNT
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, STATISTICAL_AMOUNT
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, USSGL_TRANSACTION_CODE
, JGZZ_RECON_REF
, SOURCE_DISTRIBUTION_ID_CHAR_1
, SOURCE_DISTRIBUTION_ID_CHAR_2
, SOURCE_DISTRIBUTION_ID_CHAR_3
, SOURCE_DISTRIBUTION_ID_CHAR_4
, SOURCE_DISTRIBUTION_ID_CHAR_5
, SOURCE_DISTRIBUTION_ID_NUM_1
, SOURCE_DISTRIBUTION_ID_NUM_2
, SOURCE_DISTRIBUTION_ID_NUM_3
, SOURCE_DISTRIBUTION_ID_NUM_4
, SOURCE_DISTRIBUTION_ID_NUM_5
, SOURCE_DISTRIBUTION_TYPE
, TAX_LINE_REF_ID
, TAX_SUMMARY_LINE_REF_ID
, TAX_REC_NREC_DIST_REF_ID
, DEFERRED_INDICATOR
, DEFERRED_START_DATE
, DEFERRED_END_DATE
, DEFERRED_NO_PERIOD
, DEFERRED_PERIOD_TYPE
, ANALYTICAL_BALANCE_FLAG
, ANC_ID_1
, ANC_ID_2
, ANC_ID_3
, ANC_ID_4
, ANC_ID_5
, ANC_ID_6
, ANC_ID_7
, ANC_ID_8
, ANC_ID_9
, ANC_ID_10
, ANC_ID_11
, ANC_ID_12
, ANC_ID_13
, ANC_ID_14
, ANC_ID_15
, ANC_ID_16
, ANC_ID_17
, ANC_ID_18
, ANC_ID_19
, ANC_ID_20
, ANC_ID_21
, ANC_ID_22
, ANC_ID_23
, ANC_ID_24
, ANC_ID_25
, ANC_ID_26
, ANC_ID_27
, ANC_ID_28
, ANC_ID_29
, ANC_ID_30
, ANC_ID_31
, ANC_ID_32
, ANC_ID_33
, ANC_ID_34
, ANC_ID_35
, ANC_ID_36
, ANC_ID_37
, ANC_ID_38
, ANC_ID_39
, ANC_ID_40
, ANC_ID_41
, ANC_ID_42
, ANC_ID_43
, ANC_ID_44
, ANC_ID_45
, ANC_ID_46
, ANC_ID_47
, ANC_ID_48
, ANC_ID_49
, ANC_ID_50
, ANC_ID_51
, ANC_ID_52
, ANC_ID_53
, ANC_ID_54
, ANC_ID_55
, ANC_ID_56
, ANC_ID_57
, ANC_ID_58
, ANC_ID_59
, ANC_ID_60
, ANC_ID_61
, ANC_ID_62
, ANC_ID_63
, ANC_ID_64
, ANC_ID_65
, ANC_ID_66
, ANC_ID_67
, ANC_ID_68
, ANC_ID_69
, ANC_ID_70
, ANC_ID_71
, ANC_ID_72
, ANC_ID_73
, ANC_ID_74
, ANC_ID_75
, ANC_ID_76
, ANC_ID_77
, ANC_ID_78
, ANC_ID_79
, ANC_ID_80
, ANC_ID_81
, ANC_ID_82
, ANC_ID_83
, ANC_ID_84
, ANC_ID_85
, ANC_ID_86
, ANC_ID_87
, ANC_ID_88
, ANC_ID_89
, ANC_ID_90
, ANC_ID_91
, ANC_ID_92
, ANC_ID_93
, ANC_ID_94
, ANC_ID_95
, ANC_ID_96
, ANC_ID_97
, ANC_ID_98
, ANC_ID_99
, ANC_ID_100
, BALANCE_TYPE_CODE
, MERGE_INDEX
, LEDGER_ID
, ENTITY_ID
, REVERSE_DIST_ID_CHAR_1
, REVERSE_DIST_ID_CHAR_2
, REVERSE_DIST_ID_CHAR_3
, REVERSE_DIST_ID_CHAR_4
, REVERSE_DIST_ID_CHAR_5
, REVERSE_DIST_ID_NUM_1
, REVERSE_DIST_ID_NUM_2
, REVERSE_DIST_ID_NUM_3
, REVERSE_DIST_ID_NUM_4
, REVERSE_DIST_ID_NUM_5
, REVERSE_DISTRIBUTION_TYPE
, EVENT_NUMBER
, ACCOUNTING_ENTRY_STATUS_CODE
, REVERSAL_CODE
, CALCULATE_ACCTD_AMTS_FLAG
, CALCULATE_G_L_AMTS_FLAG
, GAIN_OR_LOSS_FLAG
, ROUNDING_CLASS_CODE
, DOCUMENT_ROUNDING_LEVEL
, UNROUNDED_ACCOUNTED_DR
, UNROUNDED_ACCOUNTED_CR
, EXTRACT_LINE_NUM
, ALT_CODE_COMBINATION_ID
, ALT_SEGMENT1
, ALT_SEGMENT2
, ALT_SEGMENT3
, ALT_SEGMENT4
, ALT_SEGMENT5
, ALT_SEGMENT6
, ALT_SEGMENT7
, ALT_SEGMENT8
, ALT_SEGMENT9
, ALT_SEGMENT10
, ALT_SEGMENT11
, ALT_SEGMENT12
, ALT_SEGMENT13
, ALT_SEGMENT14
, ALT_SEGMENT15
, ALT_SEGMENT16
, ALT_SEGMENT17
, ALT_SEGMENT18
, ALT_SEGMENT19
, ALT_SEGMENT20
, ALT_SEGMENT21
, ALT_SEGMENT22
, ALT_SEGMENT23
, ALT_SEGMENT24
, ALT_SEGMENT25
, ALT_SEGMENT26
, ALT_SEGMENT27
, ALT_SEGMENT28
, ALT_SEGMENT29
, ALT_SEGMENT30
, ALT_CCID_STATUS_CODE
, UNROUNDED_ENTERED_DR
, UNROUNDED_ENTERED_CR
, DOC_ROUNDING_ENTERED_AMT
, DOC_ROUNDING_ACCTD_AMT
, ENTERED_CURRENCY_MAU
, BUSINESS_METHOD_CODE
, BUSINESS_CLASS_CODE
, INHERIT_DESC_FLAG
, BFLOW_APPLICATION_ID
, BFLOW_ENTITY_CODE
, BFLOW_SOURCE_ID_NUM_1
, BFLOW_SOURCE_ID_NUM_2
, BFLOW_SOURCE_ID_NUM_3
, BFLOW_SOURCE_ID_NUM_4
, BFLOW_SOURCE_ID_CHAR_1
, BFLOW_SOURCE_ID_CHAR_2
, BFLOW_SOURCE_ID_CHAR_3
, BFLOW_SOURCE_ID_CHAR_4
, BFLOW_DISTRIBUTION_TYPE
, BFLOW_DIST_ID_NUM_1
, BFLOW_DIST_ID_NUM_2
, BFLOW_DIST_ID_NUM_3
, BFLOW_DIST_ID_NUM_4
, BFLOW_DIST_ID_NUM_5
, BFLOW_DIST_ID_CHAR_1
, BFLOW_DIST_ID_CHAR_2
, BFLOW_DIST_ID_CHAR_3
, BFLOW_DIST_ID_CHAR_4
, BFLOW_DIST_ID_CHAR_5
, BFLOW_PRIOR_ENTRY_STATUS_CODE
, SL_COA_MAPPING_ID
, NATURAL_SIDE_CODE
, TEMP_CURRENCY_CODE
, TEMP_REF_AE_HEADER_ID
, REF_TEMP_LINE_NUM
, APPLIED_TO_ENTITY_ID
, ALLOC_TO_APPLICATION_ID
, ALLOC_TO_ENTITY_CODE
, ALLOC_TO_SOURCE_ID_NUM_1
, ALLOC_TO_SOURCE_ID_NUM_2
, ALLOC_TO_SOURCE_ID_NUM_3
, ALLOC_TO_SOURCE_ID_NUM_4
, ALLOC_TO_SOURCE_ID_CHAR_1
, ALLOC_TO_SOURCE_ID_CHAR_2
, ALLOC_TO_SOURCE_ID_CHAR_3
, ALLOC_TO_SOURCE_ID_CHAR_4
, ALLOC_TO_DISTRIBUTION_TYPE
, ALLOC_TO_DIST_ID_NUM_1
, ALLOC_TO_DIST_ID_NUM_2
, ALLOC_TO_DIST_ID_NUM_3
, ALLOC_TO_DIST_ID_NUM_4
, ALLOC_TO_DIST_ID_NUM_5
, ALLOC_TO_DIST_ID_CHAR_1
, ALLOC_TO_DIST_ID_CHAR_2
, ALLOC_TO_DIST_ID_CHAR_3
, ALLOC_TO_DIST_ID_CHAR_4
, ALLOC_TO_DIST_ID_CHAR_5
, MPA_ACCRUAL_ENTRY_FLAG
, ENCUMBRANCE_TYPE_ID
, HEADER_NUM
, ACCOUNTING_DATE
, MULTIPERIOD_END_DATE
, MULTIPERIOD_START_DATE
, MULTIPERIOD_OPTION_FLAG
, GAIN_OR_LOSS_REF
, BFLOW_APPLIED_TO_AMOUNT
, OVERRIDE_ACCTD_AMT_FLAG
, DERIVED_EXCH_RATE
FROM XLA.XLA_AE_LINES_GT;
XLA.XLA_AE_LINES_GT does not reference any database object
XLA.XLA_AE_LINES_GT is referenced by following:
APPS
XLA_AE_LINES_GT
|
|
|
|