VIEW: JE.JE_IT_TRX_LINES_ALL#

Source

View Text - Preformatted

select REQUEST_ID#1 REQUEST_ID, VAT_REPORTING_ENTITY_ID VAT_REPORTING_ENTITY_ID, ORG_ID ORG_ID, APPLICATION_ID APPLICATION_ID, PARTY_ID PARTY_ID, PARTY_NAME PARTY_NAME, VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM, TAX_PAYER_ID TAX_PAYER_ID, COUNTRY COUNTRY, TRX_ID TRX_ID, TRX_NUM TRX_NUM, TRX_DATE TRX_DATE, TRX_GL_DATE TRX_GL_DATE, TRX_TYPE TRX_TYPE, PAYMENT_METHOD PAYMENT_METHOD, TRX_ACCOUNTING_STATUS TRX_ACCOUNTING_STATUS, TRX_LINE_ID TRX_LINE_ID, TRX_LINE_NUM TRX_LINE_NUM, TRX_LINE_TYPE TRX_LINE_TYPE, ASSESSABLE_AMT ASSESSABLE_AMT, VAT_AMT VAT_AMT, PAYMENT_MODE PAYMENT_MODE, BELOW_THRESHOLD_FLAG BELOW_THRESHOLD_FLAG, REPORT_EXCLUSION_FLAG REPORT_EXCLUSION_FLAG, CONTRACT_IDENTIFICATION CONTRACT_IDENTIFICATION, ADJ_INV_FLAG ADJ_INV_FLAG, ORIG_TRX_ID ORIG_TRX_ID, RECORD_TYPE RECORD_TYPE, PARTY_TYPE PARTY_TYPE, INDV_PARTY_LAST_NAME#1 INDV_PARTY_LAST_NAME, INDV_PARTY_FIRST_NAME#1 INDV_PARTY_FIRST_NAME, INDV_PARTY_DOB INDV_PARTY_DOB, INDV_PARTY_CITY#1 INDV_PARTY_CITY, INDV_PARTY_PROVINCE INDV_PARTY_PROVINCE, COMPANY_CITY#1 COMPANY_CITY, COMPANY_ADDRESS#1 COMPANY_ADDRESS, INCONST_CM_DM_APPL_FLAG INCONST_CM_DM_APPL_FLAG, ORIG_TRX_MISSING_FLAG ORIG_TRX_MISSING_FLAG, PAYMENT_MODE_ERR_FLAG PAYMENT_MODE_ERR_FLAG, PARTIAL_ADJ_INV_FLAG PARTIAL_ADJ_INV_FLAG, IS_ABOVE_THRESHOLD IS_ABOVE_THRESHOLD, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY from "JE"."JE_IT_TRX_LINES_ALL"

View Text - HTML Formatted

SELECT REQUEST_ID#1 REQUEST_ID
, VAT_REPORTING_ENTITY_ID VAT_REPORTING_ENTITY_ID
, ORG_ID ORG_ID
, APPLICATION_ID APPLICATION_ID
, PARTY_ID PARTY_ID
, PARTY_NAME PARTY_NAME
, VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM
, TAX_PAYER_ID TAX_PAYER_ID
, COUNTRY COUNTRY
, TRX_ID TRX_ID
, TRX_NUM TRX_NUM
, TRX_DATE TRX_DATE
, TRX_GL_DATE TRX_GL_DATE
, TRX_TYPE TRX_TYPE
, PAYMENT_METHOD PAYMENT_METHOD
, TRX_ACCOUNTING_STATUS TRX_ACCOUNTING_STATUS
, TRX_LINE_ID TRX_LINE_ID
, TRX_LINE_NUM TRX_LINE_NUM
, TRX_LINE_TYPE TRX_LINE_TYPE
, ASSESSABLE_AMT ASSESSABLE_AMT
, VAT_AMT VAT_AMT
, PAYMENT_MODE PAYMENT_MODE
, BELOW_THRESHOLD_FLAG BELOW_THRESHOLD_FLAG
, REPORT_EXCLUSION_FLAG REPORT_EXCLUSION_FLAG
, CONTRACT_IDENTIFICATION CONTRACT_IDENTIFICATION
, ADJ_INV_FLAG ADJ_INV_FLAG
, ORIG_TRX_ID ORIG_TRX_ID
, RECORD_TYPE RECORD_TYPE
, PARTY_TYPE PARTY_TYPE
, INDV_PARTY_LAST_NAME#1 INDV_PARTY_LAST_NAME
, INDV_PARTY_FIRST_NAME#1 INDV_PARTY_FIRST_NAME
, INDV_PARTY_DOB INDV_PARTY_DOB
, INDV_PARTY_CITY#1 INDV_PARTY_CITY
, INDV_PARTY_PROVINCE INDV_PARTY_PROVINCE
, COMPANY_CITY#1 COMPANY_CITY
, COMPANY_ADDRESS#1 COMPANY_ADDRESS
, INCONST_CM_DM_APPL_FLAG INCONST_CM_DM_APPL_FLAG
, ORIG_TRX_MISSING_FLAG ORIG_TRX_MISSING_FLAG
, PAYMENT_MODE_ERR_FLAG PAYMENT_MODE_ERR_FLAG
, PARTIAL_ADJ_INV_FLAG PARTIAL_ADJ_INV_FLAG
, IS_ABOVE_THRESHOLD IS_ABOVE_THRESHOLD
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
FROM "JE"."JE_IT_TRX_LINES_ALL"