eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: JL.JL_BR_COMPANY_INFOS#

Source

View Text - Preformatted


select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ACCOUNTING_BALANCING_SEGMENT ACCOUNTING_BALANCING_SEGMENT, NAME NAME, REGISTER_TYPE REGISTER_TYPE, REGISTER_NUMBER REGISTER_NUMBER, REGISTER_DIGIT REGISTER_DIGIT, ACCOUNTANT_NAME ACCOUNTANT_NAME, ACCOUNTANT_NUMBER ACCOUNTANT_NUMBER, ADDRESS_LINE_1 ADDRESS_LINE_1, CITY CITY, STATE STATE, COUNTRY COUNTRY, ZIP ZIP, 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, REGISTER_SUBSIDIARY REGISTER_SUBSIDIARY, ADDRESS_LINE_2 ADDRESS_LINE_2, ADDRESS_LINE_3 ADDRESS_LINE_3, STATE_INSCRIPTION STATE_INSCRIPTION, MUNICIPAL_INSCRIPTION MUNICIPAL_INSCRIPTION, DIRECTOR_REGISTER_NUMBER DIRECTOR_REGISTER_NUMBER, DIRECTOR_REGISTER_DIGIT DIRECTOR_REGISTER_DIGIT, ESTABLISHMENT_TYPE ESTABLISHMENT_TYPE, DAILY_INSCRIPTION_NUMBER DAILY_INSCRIPTION_NUMBER, DAILY_INSCRIPTION_DATE DAILY_INSCRIPTION_DATE, DAILY_ENTITY DAILY_ENTITY, DAILY_LOCATION DAILY_LOCATION, DAILY_START_BOOK_NUMBER DAILY_START_BOOK_NUMBER, DAILY_LAST_BOOK_NUMBER DAILY_LAST_BOOK_NUMBER, LEDGER_INSCRIPTION_NUMBER LEDGER_INSCRIPTION_NUMBER, LEDGER_INSCRIPTION_DATE LEDGER_INSCRIPTION_DATE, LEDGER_ENTITY LEDGER_ENTITY, LEDGER_LOCATION LEDGER_LOCATION, LEDGER_START_BOOK_NUMBER LEDGER_START_BOOK_NUMBER, LEDGER_LAST_BOOK_NUMBER LEDGER_LAST_BOOK_NUMBER, INACTIVE_DATE INACTIVE_DATE from "JL"."JL_BR_COMPANY_INFOS"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ACCOUNTING_BALANCING_SEGMENT ACCOUNTING_BALANCING_SEGMENT
, NAME NAME
, REGISTER_TYPE REGISTER_TYPE
, REGISTER_NUMBER REGISTER_NUMBER
, REGISTER_DIGIT REGISTER_DIGIT
, ACCOUNTANT_NAME ACCOUNTANT_NAME
, ACCOUNTANT_NUMBER ACCOUNTANT_NUMBER
, ADDRESS_LINE_1 ADDRESS_LINE_1
, CITY CITY
, STATE STATE
, COUNTRY COUNTRY
, ZIP ZIP
, 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
, REGISTER_SUBSIDIARY REGISTER_SUBSIDIARY
, ADDRESS_LINE_2 ADDRESS_LINE_2
, ADDRESS_LINE_3 ADDRESS_LINE_3
, STATE_INSCRIPTION STATE_INSCRIPTION
, MUNICIPAL_INSCRIPTION MUNICIPAL_INSCRIPTION
, DIRECTOR_REGISTER_NUMBER DIRECTOR_REGISTER_NUMBER
, DIRECTOR_REGISTER_DIGIT DIRECTOR_REGISTER_DIGIT
, ESTABLISHMENT_TYPE ESTABLISHMENT_TYPE
, DAILY_INSCRIPTION_NUMBER DAILY_INSCRIPTION_NUMBER
, DAILY_INSCRIPTION_DATE DAILY_INSCRIPTION_DATE
, DAILY_ENTITY DAILY_ENTITY
, DAILY_LOCATION DAILY_LOCATION
, DAILY_START_BOOK_NUMBER DAILY_START_BOOK_NUMBER
, DAILY_LAST_BOOK_NUMBER DAILY_LAST_BOOK_NUMBER
, LEDGER_INSCRIPTION_NUMBER LEDGER_INSCRIPTION_NUMBER
, LEDGER_INSCRIPTION_DATE LEDGER_INSCRIPTION_DATE
, LEDGER_ENTITY LEDGER_ENTITY
, LEDGER_LOCATION LEDGER_LOCATION
, LEDGER_START_BOOK_NUMBER LEDGER_START_BOOK_NUMBER
, LEDGER_LAST_BOOK_NUMBER LEDGER_LAST_BOOK_NUMBER
, INACTIVE_DATE INACTIVE_DATE
FROM "JL"."JL_BR_COMPANY_INFOS"