DBA Data[Home] [Help] [Dependency Information]

TABLE: JL.JL_BR_COMPANY_INFOS

Object Details
Object Name: JL_BR_COMPANY_INFOS
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_BR_COMPANY_INFOS
Subobject Name:
Status: VALID


JL_BR_COMPANY_INFOS contains company information for Brazilian General Ledger Reports.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_BR_COMPANY_INFOS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnACCOUNTING_BALANCING_SEGMENT
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books ID
ACCOUNTING_BALANCING_SEGMENT VARCHAR2 (25) Yes Acct. Balancing Segment
NAME VARCHAR2 (80) Yes Company's Name
REGISTER_TYPE NUMBER (2) Yes Company's Register Type
REGISTER_NUMBER VARCHAR2 (9) Yes Company's Register Number
REGISTER_DIGIT VARCHAR2 (2) Yes Company's Register Digit
ACCOUNTANT_NAME VARCHAR2 (30) Yes Accountant Name
ACCOUNTANT_NUMBER VARCHAR2 (15) Yes Accountant Registration Number
ADDRESS_LINE_1 VARCHAR2 (40) Yes Company's Address
CITY VARCHAR2 (25) Yes City
STATE VARCHAR2 (25) Yes State
COUNTRY VARCHAR2 (25) Yes Country
ZIP VARCHAR2 (20) Yes Zip Code
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
REGISTER_SUBSIDIARY VARCHAR2 (4)
Subsidiary's Register
ADDRESS_LINE_2 VARCHAR2 (40)
Company's Address
ADDRESS_LINE_3 VARCHAR2 (40)
Company's Address
STATE_INSCRIPTION VARCHAR2 (30)
Inscription Number at Government Entity
MUNICIPAL_INSCRIPTION VARCHAR2 (15)
Inscription Number at Municipal Entity
DIRECTOR_REGISTER_NUMBER VARCHAR2 (9)
Director Identification Number
DIRECTOR_REGISTER_DIGIT VARCHAR2 (2)
Director Identification Digit Number
ESTABLISHMENT_TYPE VARCHAR2 (3)
Type of Company Establishment
DAILY_INSCRIPTION_NUMBER NUMBER (12)
Inscription Number at Commerce Registration for Daily Book
DAILY_INSCRIPTION_DATE DATE

Inscription Bookkeeping Date for Daily Book
DAILY_ENTITY VARCHAR2 (120)
Responsible Entity for Daily Book
DAILY_LOCATION VARCHAR2 (60)
Entity Location for Daily Book
DAILY_START_BOOK_NUMBER NUMBER (6)
Daily Start Book Number
DAILY_LAST_BOOK_NUMBER NUMBER (6)
Daily Last Book Number
LEDGER_INSCRIPTION_NUMBER NUMBER (12)
Inscription Number at Commerce Registration for Ledger Book
LEDGER_INSCRIPTION_DATE DATE

Inscription Bookkeeping Date for Ledger Book
LEDGER_ENTITY VARCHAR2 (120)
Responsible Entity for Ledger Book
LEDGER_LOCATION VARCHAR2 (60)
Entity Location for Ledger Book
LEDGER_START_BOOK_NUMBER NUMBER (6)
Ledger Start Book Number
LEDGER_LAST_BOOK_NUMBER NUMBER (6)
Ledger Last Book Number
INACTIVE_DATE DATE

Inactive Date
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SET_OF_BOOKS_ID
,      ACCOUNTING_BALANCING_SEGMENT
,      NAME
,      REGISTER_TYPE
,      REGISTER_NUMBER
,      REGISTER_DIGIT
,      ACCOUNTANT_NAME
,      ACCOUNTANT_NUMBER
,      ADDRESS_LINE_1
,      CITY
,      STATE
,      COUNTRY
,      ZIP
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REGISTER_SUBSIDIARY
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      STATE_INSCRIPTION
,      MUNICIPAL_INSCRIPTION
,      DIRECTOR_REGISTER_NUMBER
,      DIRECTOR_REGISTER_DIGIT
,      ESTABLISHMENT_TYPE
,      DAILY_INSCRIPTION_NUMBER
,      DAILY_INSCRIPTION_DATE
,      DAILY_ENTITY
,      DAILY_LOCATION
,      DAILY_START_BOOK_NUMBER
,      DAILY_LAST_BOOK_NUMBER
,      LEDGER_INSCRIPTION_NUMBER
,      LEDGER_INSCRIPTION_DATE
,      LEDGER_ENTITY
,      LEDGER_LOCATION
,      LEDGER_START_BOOK_NUMBER
,      LEDGER_LAST_BOOK_NUMBER
,      INACTIVE_DATE
FROM JL.JL_BR_COMPANY_INFOS;

Dependencies

[top of page]

JL.JL_BR_COMPANY_INFOS does not reference any database object

JL.JL_BR_COMPANY_INFOS is referenced by following:

SchemaJL
ViewJL_BR_COMPANY_INFOS#