VIEW: ZX.ZX_REP_ACTG_EXT_T#

Source

View Text - Preformatted

select ACTG_EXT_LINE_ID ACTG_EXT_LINE_ID, DETAIL_TAX_LINE_ID DETAIL_TAX_LINE_ID, ACTG_EVENT_TYPE_CODE ACTG_EVENT_TYPE_CODE, ACTG_EVENT_TYPE_MNG ACTG_EVENT_TYPE_MNG, ACTG_EVENT_NUMBER ACTG_EVENT_NUMBER, ACTG_EVENT_STATUS_FLAG ACTG_EVENT_STATUS_FLAG, ACTG_EVENT_STATUS_MNG ACTG_EVENT_STATUS_MNG, ACTG_CATEGORY_CODE ACTG_CATEGORY_CODE, ACTG_CATEGORY_MNG ACTG_CATEGORY_MNG, ACCOUNTING_DATE ACCOUNTING_DATE, GL_TRANSFER_FLAG GL_TRANSFER_FLAG, GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID, ACTG_HEADER_DESCRIPTION ACTG_HEADER_DESCRIPTION, ACTG_LINE_NUM ACTG_LINE_NUM, ACTG_LINE_TYPE_CODE ACTG_LINE_TYPE_CODE, ACTG_LINE_TYPE_MNG ACTG_LINE_TYPE_MNG, ACTG_LINE_DESCRIPTION ACTG_LINE_DESCRIPTION, ACTG_STAT_AMT ACTG_STAT_AMT, ACTG_ERROR_CODE ACTG_ERROR_CODE, GL_TRANSFER_CODE GL_TRANSFER_CODE, ACTG_DOC_SEQUENCE_ID ACTG_DOC_SEQUENCE_ID, ACTG_DOC_SEQUENCE_NAME ACTG_DOC_SEQUENCE_NAME, ACTG_DOC_SEQUENCE_VALUE ACTG_DOC_SEQUENCE_VALUE, ACTG_PARTY_ID ACTG_PARTY_ID, ACTG_PARTY_SITE_ID ACTG_PARTY_SITE_ID, ACTG_PARTY_TYPE ACTG_PARTY_TYPE, ACTG_EVENT_ID ACTG_EVENT_ID, ACTG_HEADER_ID ACTG_HEADER_ID, ACTG_SOURCE_ID ACTG_SOURCE_ID, ACTG_SOURCE_TABLE ACTG_SOURCE_TABLE, ACTG_LINE_CCID ACTG_LINE_CCID, ACCOUNT_FLEXFIELD ACCOUNT_FLEXFIELD, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, PERIOD_NAME PERIOD_NAME, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE, TRX_ARAP_BALANCING_SEGMENT TRX_ARAP_BALANCING_SEGMENT, TRX_ARAP_NATURAL_ACCOUNT TRX_ARAP_NATURAL_ACCOUNT, TRX_TAXABLE_BALANCING_SEGMENT TRX_TAXABLE_BALANCING_SEGMENT, TRX_TAXABLE_NATURAL_ACCOUNT TRX_TAXABLE_NATURAL_ACCOUNT, TRX_TAX_BALANCING_SEGMENT TRX_TAX_BALANCING_SEGMENT, TRX_TAX_NATURAL_ACCOUNT TRX_TAX_NATURAL_ACCOUNT, TRX_CONTROL_ACCOUNT_FLEXFIELD TRX_CONTROL_ACCOUNT_FLEXFIELD, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, TRX_TAXABLE_ACCOUNT TRX_TAXABLE_ACCOUNT, TRX_TAXABLE_ACCOUNT_DESC TRX_TAXABLE_ACCOUNT_DESC, TRX_TAXABLE_BALSEG_DESC TRX_TAXABLE_BALSEG_DESC, TRX_TAXABLE_NATACCT_SEG_DESC TRX_TAXABLE_NATACCT_SEG_DESC from "ZX"."ZX_REP_ACTG_EXT_T"

View Text - HTML Formatted

SELECT ACTG_EXT_LINE_ID ACTG_EXT_LINE_ID
, DETAIL_TAX_LINE_ID DETAIL_TAX_LINE_ID
, ACTG_EVENT_TYPE_CODE ACTG_EVENT_TYPE_CODE
, ACTG_EVENT_TYPE_MNG ACTG_EVENT_TYPE_MNG
, ACTG_EVENT_NUMBER ACTG_EVENT_NUMBER
, ACTG_EVENT_STATUS_FLAG ACTG_EVENT_STATUS_FLAG
, ACTG_EVENT_STATUS_MNG ACTG_EVENT_STATUS_MNG
, ACTG_CATEGORY_CODE ACTG_CATEGORY_CODE
, ACTG_CATEGORY_MNG ACTG_CATEGORY_MNG
, ACCOUNTING_DATE ACCOUNTING_DATE
, GL_TRANSFER_FLAG GL_TRANSFER_FLAG
, GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID
, ACTG_HEADER_DESCRIPTION ACTG_HEADER_DESCRIPTION
, ACTG_LINE_NUM ACTG_LINE_NUM
, ACTG_LINE_TYPE_CODE ACTG_LINE_TYPE_CODE
, ACTG_LINE_TYPE_MNG ACTG_LINE_TYPE_MNG
, ACTG_LINE_DESCRIPTION ACTG_LINE_DESCRIPTION
, ACTG_STAT_AMT ACTG_STAT_AMT
, ACTG_ERROR_CODE ACTG_ERROR_CODE
, GL_TRANSFER_CODE GL_TRANSFER_CODE
, ACTG_DOC_SEQUENCE_ID ACTG_DOC_SEQUENCE_ID
, ACTG_DOC_SEQUENCE_NAME ACTG_DOC_SEQUENCE_NAME
, ACTG_DOC_SEQUENCE_VALUE ACTG_DOC_SEQUENCE_VALUE
, ACTG_PARTY_ID ACTG_PARTY_ID
, ACTG_PARTY_SITE_ID ACTG_PARTY_SITE_ID
, ACTG_PARTY_TYPE ACTG_PARTY_TYPE
, ACTG_EVENT_ID ACTG_EVENT_ID
, ACTG_HEADER_ID ACTG_HEADER_ID
, ACTG_SOURCE_ID ACTG_SOURCE_ID
, ACTG_SOURCE_TABLE ACTG_SOURCE_TABLE
, ACTG_LINE_CCID ACTG_LINE_CCID
, ACCOUNT_FLEXFIELD ACCOUNT_FLEXFIELD
, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION
, PERIOD_NAME PERIOD_NAME
, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, TRX_ARAP_BALANCING_SEGMENT TRX_ARAP_BALANCING_SEGMENT
, TRX_ARAP_NATURAL_ACCOUNT TRX_ARAP_NATURAL_ACCOUNT
, TRX_TAXABLE_BALANCING_SEGMENT TRX_TAXABLE_BALANCING_SEGMENT
, TRX_TAXABLE_NATURAL_ACCOUNT TRX_TAXABLE_NATURAL_ACCOUNT
, TRX_TAX_BALANCING_SEGMENT TRX_TAX_BALANCING_SEGMENT
, TRX_TAX_NATURAL_ACCOUNT TRX_TAX_NATURAL_ACCOUNT
, TRX_CONTROL_ACCOUNT_FLEXFIELD TRX_CONTROL_ACCOUNT_FLEXFIELD
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, TRX_TAXABLE_ACCOUNT TRX_TAXABLE_ACCOUNT
, TRX_TAXABLE_ACCOUNT_DESC TRX_TAXABLE_ACCOUNT_DESC
, TRX_TAXABLE_BALSEG_DESC TRX_TAXABLE_BALSEG_DESC
, TRX_TAXABLE_NATACCT_SEG_DESC TRX_TAXABLE_NATACCT_SEG_DESC
FROM "ZX"."ZX_REP_ACTG_EXT_T"