VIEW: JL.JL_BR_SPED_PARTIC_CODES#

Source

View Text - Preformatted

select LEDGER_ID LEDGER_ID, PARTICIPANT_CODE PARTICIPANT_CODE, PARTICIPANT_NAME PARTICIPANT_NAME, PARTICIPANT_TYPE PARTICIPANT_TYPE, ENABLED_FLAG ENABLED_FLAG, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID, SEGMENT_TYPE SEGMENT_TYPE, FLEX_VALUE FLEX_VALUE, COUNTRY_CODE COUNTRY_CODE, STATE_CODE STATE_CODE, REGISTER_TYPE REGISTER_TYPE, REGISTER_NUMBER REGISTER_NUMBER, REGISTER_SUBSIDIARY REGISTER_SUBSIDIARY, REGISTER_DIGIT REGISTER_DIGIT, NIT NIT, STATE_INSCRIPTION STATE_INSCRIPTION, STATE_INSCRIPTION_SUBSTITUTE STATE_INSCRIPTION_SUBSTITUTE, IBGE_CITY_CODE IBGE_CITY_CODE, SUFRAMA_INSCRIPTION_NUMBER SUFRAMA_INSCRIPTION_NUMBER, MUNICIPAL_INSCRIPTION MUNICIPAL_INSCRIPTION, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "JL"."JL_BR_SPED_PARTIC_CODES"

View Text - HTML Formatted

SELECT LEDGER_ID LEDGER_ID
, PARTICIPANT_CODE PARTICIPANT_CODE
, PARTICIPANT_NAME PARTICIPANT_NAME
, PARTICIPANT_TYPE PARTICIPANT_TYPE
, ENABLED_FLAG ENABLED_FLAG
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, SEGMENT_TYPE SEGMENT_TYPE
, FLEX_VALUE FLEX_VALUE
, COUNTRY_CODE COUNTRY_CODE
, STATE_CODE STATE_CODE
, REGISTER_TYPE REGISTER_TYPE
, REGISTER_NUMBER REGISTER_NUMBER
, REGISTER_SUBSIDIARY REGISTER_SUBSIDIARY
, REGISTER_DIGIT REGISTER_DIGIT
, NIT NIT
, STATE_INSCRIPTION STATE_INSCRIPTION
, STATE_INSCRIPTION_SUBSTITUTE STATE_INSCRIPTION_SUBSTITUTE
, IBGE_CITY_CODE IBGE_CITY_CODE
, SUFRAMA_INSCRIPTION_NUMBER SUFRAMA_INSCRIPTION_NUMBER
, MUNICIPAL_INSCRIPTION MUNICIPAL_INSCRIPTION
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "JL"."JL_BR_SPED_PARTIC_CODES"