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.

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

TABLE: JL.JL_BR_GL_LEGAL_REP

Object Details

Object Name:	JL_BR_GL_LEGAL_REP
Object Type:	TABLE
Owner:	JL
FND Design Data:	JL.JL_BR_GL_LEGAL_REP
Subobject Name:
Status:	VALID

JL_BR_GL_LEGAL_REP stores information after General Ledger and Subledger reports are printed with the Definitive parameter of the reports set to 'Y'. The DEFINITIVE column is 'Y' for printing the Brazilian Opening and Closing Pages report and 'N' for not printing it. The flag DAILY_LEDGER_FLAG is 'D' for printing the Brazilian General Ledger Daily Book Report, 'L' for printing the General Ledger Book Report, 'P' for printing the Brazilian Payables Supplier Auxiliary Daily Report, 'Q' for printing the Brazilian Payables Supplier Auxiliary Ledger Report, 'R' for printing the Brazilian Receivables Customer Auxiliary Daily Report or 'S' for printing the Brazilian Receivables Customer Auxiliary Ledger Report.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_BR_GL_LEGAL_REP_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	CONCURRENT_REQUEST_ID BOOK_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
CONCURRENT_REQUEST_ID	NUMBER	(15)	Yes	Concurrent request identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
ACCOUNTING_BALANCING_SEGMENT	VARCHAR2	(25)	Yes	Accounting Balancing segment
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PRINTED_START_DATE	DATE		Yes	Printed start date
PRINTED_END_DATE	DATE		Yes	Printed end date
PRINTED_START_PERIOD	VARCHAR2	(15)	Yes	Printed initial period
PRINTED_END_PERIOD	VARCHAR2	(15)	Yes	Printed end period
BOOK_NUMBER	NUMBER	(6)	Yes	Daily or Ledger book number
DEFINITIVE	VARCHAR2	(1)		Flag to indicates if the Opening/Closing Pages is to be printed or not
MAX_NUMBER_PAGES	NUMBER	(6)		Maximum number of pages
DAILY_LEDGER_FLAG	VARCHAR2	(1)		Flag that indicates if it is to be printed for Daily or Ledger Books
REGISTER_NUMBER	VARCHAR2	(9)		Company Register number
REGISTER_SUBSIDIARY	VARCHAR2	(4)		Subsidiary Register
REGISTER_DIGIT	VARCHAR2	(2)		Company Register Digit
NAME	VARCHAR2	(80)		Company name
ADDRESS_LINE_1	VARCHAR2	(40)		Company address line 1
ADDRESS_LINE_2	VARCHAR2	(40)		Company address line 2
ADDRESS_LINE_3	VARCHAR2	(40)		Company address line 3
ACCOUNTANT_NAME	VARCHAR2	(30)		Accountant name
ACCOUNTANT_NUMBER	VARCHAR2	(15)		Accountant registration number
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)		Inscription entity for Daily Book
DAILY_LOCATION	VARCHAR2	(60)		Entity location for Daily Book
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)		Inscription entity for Ledger Book
LEDGER_LOCATION	VARCHAR2	(60)		Entity location for Ledger Book
DIRECTOR_REGISTER_NUMBER	VARCHAR2	(9)		Director identification number
DIRECTOR_REGISTER_DIGIT	VARCHAR2	(2)		Director identification digit
TRIAL_BALANCE_NUMBER_PAGES	NUMBER	(6)		Number of pages in trial balance
DAILY_NUMBER_PAGES	NUMBER	(6)		Number of pages in Daily Book
SEGMENT_LOW	VARCHAR2	(100)		Lower accounting flexfield
SEGMENT_HIGH	VARCHAR2	(100)		Higher accounting flexfield
CITY	VARCHAR2	(25)		City

Query Text

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


SELECT CONCURRENT_REQUEST_ID
,      SET_OF_BOOKS_ID
,      ACCOUNTING_BALANCING_SEGMENT
,      APPLICATION_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      PRINTED_START_DATE
,      PRINTED_END_DATE
,      PRINTED_START_PERIOD
,      PRINTED_END_PERIOD
,      BOOK_NUMBER
,      DEFINITIVE
,      MAX_NUMBER_PAGES
,      DAILY_LEDGER_FLAG
,      REGISTER_NUMBER
,      REGISTER_SUBSIDIARY
,      REGISTER_DIGIT
,      NAME
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      ACCOUNTANT_NAME
,      ACCOUNTANT_NUMBER
,      DAILY_INSCRIPTION_NUMBER
,      DAILY_INSCRIPTION_DATE
,      DAILY_ENTITY
,      DAILY_LOCATION
,      LEDGER_INSCRIPTION_NUMBER
,      LEDGER_INSCRIPTION_DATE
,      LEDGER_ENTITY
,      LEDGER_LOCATION
,      DIRECTOR_REGISTER_NUMBER
,      DIRECTOR_REGISTER_DIGIT
,      TRIAL_BALANCE_NUMBER_PAGES
,      DAILY_NUMBER_PAGES
,      SEGMENT_LOW
,      SEGMENT_HIGH
,      CITY
FROM JL.JL_BR_GL_LEGAL_REP;

Dependencies

[top of page]

JL.JL_BR_GL_LEGAL_REP does not reference any database object

JL.JL_BR_GL_LEGAL_REP is referenced by following:

APPS: JL_BR_GL_LEGAL_REP