VIEW: GL.GL_IEA_INTERFACE#

Source

View Text - Preformatted

select GROUP_ID GROUP_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, TRANSACTION_STATUS_CODE TRANSACTION_STATUS_CODE, CURRENCY_CODE CURRENCY_CODE, GL_DATE GL_DATE, SENDER_SUBSIDIARY_ID SENDER_SUBSIDIARY_ID, RECEIVER_SUBSIDIARY_ID RECEIVER_SUBSIDIARY_ID, LINE_TYPE LINE_TYPE, TRANSACTION_NUMBER TRANSACTION_NUMBER, DESCRIPTION DESCRIPTION, NOTE NOTE, SENDER_CODE_COMBINATION_ID SENDER_CODE_COMBINATION_ID, RECEIVER_CODE_COMBINATION_ID RECEIVER_CODE_COMBINATION_ID, SENDER_SEGMENT1 SENDER_SEGMENT1, SENDER_SEGMENT2 SENDER_SEGMENT2, SENDER_SEGMENT3 SENDER_SEGMENT3, SENDER_SEGMENT4 SENDER_SEGMENT4, SENDER_SEGMENT5 SENDER_SEGMENT5, SENDER_SEGMENT6 SENDER_SEGMENT6, SENDER_SEGMENT7 SENDER_SEGMENT7, SENDER_SEGMENT8 SENDER_SEGMENT8, SENDER_SEGMENT9 SENDER_SEGMENT9, SENDER_SEGMENT10 SENDER_SEGMENT10, SENDER_SEGMENT11 SENDER_SEGMENT11, SENDER_SEGMENT12 SENDER_SEGMENT12, SENDER_SEGMENT13 SENDER_SEGMENT13, SENDER_SEGMENT14 SENDER_SEGMENT14, SENDER_SEGMENT15 SENDER_SEGMENT15, SENDER_SEGMENT16 SENDER_SEGMENT16, SENDER_SEGMENT17 SENDER_SEGMENT17, SENDER_SEGMENT18 SENDER_SEGMENT18, SENDER_SEGMENT19 SENDER_SEGMENT19, SENDER_SEGMENT20 SENDER_SEGMENT20, SENDER_SEGMENT21 SENDER_SEGMENT21, SENDER_SEGMENT22 SENDER_SEGMENT22, SENDER_SEGMENT23 SENDER_SEGMENT23, SENDER_SEGMENT24 SENDER_SEGMENT24, SENDER_SEGMENT25 SENDER_SEGMENT25, SENDER_SEGMENT26 SENDER_SEGMENT26, SENDER_SEGMENT27 SENDER_SEGMENT27, SENDER_SEGMENT28 SENDER_SEGMENT28, SENDER_SEGMENT29 SENDER_SEGMENT29, SENDER_SEGMENT30 SENDER_SEGMENT30, RECEIVER_SEGMENT1 RECEIVER_SEGMENT1, RECEIVER_SEGMENT2 RECEIVER_SEGMENT2, RECEIVER_SEGMENT3 RECEIVER_SEGMENT3, RECEIVER_SEGMENT4 RECEIVER_SEGMENT4, RECEIVER_SEGMENT5 RECEIVER_SEGMENT5, RECEIVER_SEGMENT6 RECEIVER_SEGMENT6, RECEIVER_SEGMENT7 RECEIVER_SEGMENT7, RECEIVER_SEGMENT8 RECEIVER_SEGMENT8, RECEIVER_SEGMENT9 RECEIVER_SEGMENT9, RECEIVER_SEGMENT10 RECEIVER_SEGMENT10, RECEIVER_SEGMENT11 RECEIVER_SEGMENT11, RECEIVER_SEGMENT12 RECEIVER_SEGMENT12, RECEIVER_SEGMENT13 RECEIVER_SEGMENT13, RECEIVER_SEGMENT14 RECEIVER_SEGMENT14, RECEIVER_SEGMENT15 RECEIVER_SEGMENT15, RECEIVER_SEGMENT16 RECEIVER_SEGMENT16, RECEIVER_SEGMENT17 RECEIVER_SEGMENT17, RECEIVER_SEGMENT18 RECEIVER_SEGMENT18, RECEIVER_SEGMENT19 RECEIVER_SEGMENT19, RECEIVER_SEGMENT20 RECEIVER_SEGMENT20, RECEIVER_SEGMENT21 RECEIVER_SEGMENT21, RECEIVER_SEGMENT22 RECEIVER_SEGMENT22, RECEIVER_SEGMENT23 RECEIVER_SEGMENT23, RECEIVER_SEGMENT24 RECEIVER_SEGMENT24, RECEIVER_SEGMENT25 RECEIVER_SEGMENT25, RECEIVER_SEGMENT26 RECEIVER_SEGMENT26, RECEIVER_SEGMENT27 RECEIVER_SEGMENT27, RECEIVER_SEGMENT28 RECEIVER_SEGMENT28, RECEIVER_SEGMENT29 RECEIVER_SEGMENT29, RECEIVER_SEGMENT30 RECEIVER_SEGMENT30, LINE_DEBIT LINE_DEBIT, LINE_CREDIT LINE_CREDIT, LAST_MODIFIED_BY LAST_MODIFIED_BY, LAST_MODIFICATION_DATE LAST_MODIFICATION_DATE, SENDER_CHART_OF_ACCOUNTS_ID SENDER_CHART_OF_ACCOUNTS_ID, RECEIVER_CHART_OF_ACCOUNTS_ID RECEIVER_CHART_OF_ACCOUNTS_ID, REQUEST_ID REQUEST_ID, COMPLETION_STATUS_CODE COMPLETION_STATUS_CODE from "GL"."GL_IEA_INTERFACE"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TRANSACTION_STATUS_CODE TRANSACTION_STATUS_CODE
, CURRENCY_CODE CURRENCY_CODE
, GL_DATE GL_DATE
, SENDER_SUBSIDIARY_ID SENDER_SUBSIDIARY_ID
, RECEIVER_SUBSIDIARY_ID RECEIVER_SUBSIDIARY_ID
, LINE_TYPE LINE_TYPE
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, DESCRIPTION DESCRIPTION
, NOTE NOTE
, SENDER_CODE_COMBINATION_ID SENDER_CODE_COMBINATION_ID
, RECEIVER_CODE_COMBINATION_ID RECEIVER_CODE_COMBINATION_ID
, SENDER_SEGMENT1 SENDER_SEGMENT1
, SENDER_SEGMENT2 SENDER_SEGMENT2
, SENDER_SEGMENT3 SENDER_SEGMENT3
, SENDER_SEGMENT4 SENDER_SEGMENT4
, SENDER_SEGMENT5 SENDER_SEGMENT5
, SENDER_SEGMENT6 SENDER_SEGMENT6
, SENDER_SEGMENT7 SENDER_SEGMENT7
, SENDER_SEGMENT8 SENDER_SEGMENT8
, SENDER_SEGMENT9 SENDER_SEGMENT9
, SENDER_SEGMENT10 SENDER_SEGMENT10
, SENDER_SEGMENT11 SENDER_SEGMENT11
, SENDER_SEGMENT12 SENDER_SEGMENT12
, SENDER_SEGMENT13 SENDER_SEGMENT13
, SENDER_SEGMENT14 SENDER_SEGMENT14
, SENDER_SEGMENT15 SENDER_SEGMENT15
, SENDER_SEGMENT16 SENDER_SEGMENT16
, SENDER_SEGMENT17 SENDER_SEGMENT17
, SENDER_SEGMENT18 SENDER_SEGMENT18
, SENDER_SEGMENT19 SENDER_SEGMENT19
, SENDER_SEGMENT20 SENDER_SEGMENT20
, SENDER_SEGMENT21 SENDER_SEGMENT21
, SENDER_SEGMENT22 SENDER_SEGMENT22
, SENDER_SEGMENT23 SENDER_SEGMENT23
, SENDER_SEGMENT24 SENDER_SEGMENT24
, SENDER_SEGMENT25 SENDER_SEGMENT25
, SENDER_SEGMENT26 SENDER_SEGMENT26
, SENDER_SEGMENT27 SENDER_SEGMENT27
, SENDER_SEGMENT28 SENDER_SEGMENT28
, SENDER_SEGMENT29 SENDER_SEGMENT29
, SENDER_SEGMENT30 SENDER_SEGMENT30
, RECEIVER_SEGMENT1 RECEIVER_SEGMENT1
, RECEIVER_SEGMENT2 RECEIVER_SEGMENT2
, RECEIVER_SEGMENT3 RECEIVER_SEGMENT3
, RECEIVER_SEGMENT4 RECEIVER_SEGMENT4
, RECEIVER_SEGMENT5 RECEIVER_SEGMENT5
, RECEIVER_SEGMENT6 RECEIVER_SEGMENT6
, RECEIVER_SEGMENT7 RECEIVER_SEGMENT7
, RECEIVER_SEGMENT8 RECEIVER_SEGMENT8
, RECEIVER_SEGMENT9 RECEIVER_SEGMENT9
, RECEIVER_SEGMENT10 RECEIVER_SEGMENT10
, RECEIVER_SEGMENT11 RECEIVER_SEGMENT11
, RECEIVER_SEGMENT12 RECEIVER_SEGMENT12
, RECEIVER_SEGMENT13 RECEIVER_SEGMENT13
, RECEIVER_SEGMENT14 RECEIVER_SEGMENT14
, RECEIVER_SEGMENT15 RECEIVER_SEGMENT15
, RECEIVER_SEGMENT16 RECEIVER_SEGMENT16
, RECEIVER_SEGMENT17 RECEIVER_SEGMENT17
, RECEIVER_SEGMENT18 RECEIVER_SEGMENT18
, RECEIVER_SEGMENT19 RECEIVER_SEGMENT19
, RECEIVER_SEGMENT20 RECEIVER_SEGMENT20
, RECEIVER_SEGMENT21 RECEIVER_SEGMENT21
, RECEIVER_SEGMENT22 RECEIVER_SEGMENT22
, RECEIVER_SEGMENT23 RECEIVER_SEGMENT23
, RECEIVER_SEGMENT24 RECEIVER_SEGMENT24
, RECEIVER_SEGMENT25 RECEIVER_SEGMENT25
, RECEIVER_SEGMENT26 RECEIVER_SEGMENT26
, RECEIVER_SEGMENT27 RECEIVER_SEGMENT27
, RECEIVER_SEGMENT28 RECEIVER_SEGMENT28
, RECEIVER_SEGMENT29 RECEIVER_SEGMENT29
, RECEIVER_SEGMENT30 RECEIVER_SEGMENT30
, LINE_DEBIT LINE_DEBIT
, LINE_CREDIT LINE_CREDIT
, LAST_MODIFIED_BY LAST_MODIFIED_BY
, LAST_MODIFICATION_DATE LAST_MODIFICATION_DATE
, SENDER_CHART_OF_ACCOUNTS_ID SENDER_CHART_OF_ACCOUNTS_ID
, RECEIVER_CHART_OF_ACCOUNTS_ID RECEIVER_CHART_OF_ACCOUNTS_ID
, REQUEST_ID REQUEST_ID
, COMPLETION_STATUS_CODE COMPLETION_STATUS_CODE
FROM "GL"."GL_IEA_INTERFACE"