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: PSB.PSB_GL_INTERFACES

Object Details

Object Name:	PSB_GL_INTERFACES
Object Type:	TABLE
Owner:	PSB
FND Design Data:	PSB.PSB_GL_INTERFACES
Subobject Name:
Status:	VALID

Used for GL Journal Posting. This table in turn populates the GL_INTERFACE table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_GL_INTERFACES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKSHEET_ID PERIOD_NAME CODE_COMBINATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WORKSHEET_ID	NUMBER	(15)	Yes	Worksheet unique identifier. Worksheet for which this journal entry was created.
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier. Set of books this journal entry will be posted to.
ACCOUNTING_DATE	DATE		Yes	General Ledger account date for which this journal entry will be created
DATE_CREATED	DATE		Yes	Date journal entry was created
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
ACTUAL_FLAG	VARCHAR2	(1)	Yes	Actual flag indicates if it is Budget or Actual. Encumbrance in General Ledger. For lines created in Public Sector Budgeting, it will be B for Budget.
USER_JE_CATEGORY_NAME	VARCHAR2	(25)	Yes	User defined journal entry category name
USER_JE_SOURCE_NAME	VARCHAR2	(25)	Yes	User defined journal entry source name
BUDGET_VERSION_ID	NUMBER			General Ledger budget version identifier. General Ledger budget to which this journal will be posted.
CODE_COMBINATION_ID	NUMBER			General Ledger code combination identifier
BUDGET_SOURCE_TYPE	VARCHAR2	(2)		Flag to indicate if this General Ledger entry is from Budget Preparation (BP) or Budget Revision (BR)
BUDGET_VERSION_FLAG	VARCHAR2	(1)		Flag that indicates if this General Ledger entry is for a permanent budget (P) or temporary budget (T)
BALANCING_ENTRY_FLAG	VARCHAR2	(1)		Flag that indicates if this General Ledger entry is a balancing entry (Y) or not (N)
GL_BUDGET_SET_ID	NUMBER			Field to store the PSB GL Budget Set Id
ENTERED_CR	NUMBER			Credit amount
ENTERED_DR	NUMBER			Debit amount
CURRENCY_CODE	VARCHAR2	(155)	Yes	Functional currency of the Set of Books
STATUS	VARCHAR2	(50)	Yes	Open status of the period
PERIOD_NAME	VARCHAR2	(15)		Name of the General Ledger period
PERIOD_YEAR	NUMBER	(15)		The name of the General Ledger fiscal year
PERIOD_NUM	NUMBER	(15)		Number of the period in the General Ledger fiscal year
QUARTER_NUM	NUMBER	(15)		Fiscal quarter the year belongs to
REFERENCE1	VARCHAR2	(100)		General Ledger journal reference information
REFERENCE2	VARCHAR2	(100)		General Ledger journal reference information
REFERENCE3	VARCHAR2	(100)		General Ledger journal reference information
REFERENCE4	VARCHAR2	(100)		General Ledger journal reference information
REFERENCE5	VARCHAR2	(100)		General Ledger journal reference information
REFERENCE6	VARCHAR2	(100)		General Ledger journal reference information
REFERENCE7	VARCHAR2	(100)		General Ledger journal reference information
REFERENCE8	VARCHAR2	(100)		General Ledger journal reference information
REFERENCE9	VARCHAR2	(100)		General Ledger journal reference information
REFERENCE10	VARCHAR2	(240)		General Ledger journal reference information
GROUP_ID	NUMBER			Identifier to group the journal entry lines
REQUEST_ID	NUMBER			Concurrent request identifier
DESCRIPTION	VARCHAR2	(50)		Description for the journal lines
BUDGET_STAGE_ID	NUMBER	(20)		Budget stage identifier. Stage from which the worksheet data was derived.
BUDGET_YEAR_ID	NUMBER	(20)		Budget period identifier. Budget year for which this journal was created.
JE_TYPE	VARCHAR2	(1)		S for Summary or D for Detail journal
AMOUNT	NUMBER			Account line's amount which is the difference of Entered Debit and Entered Credit taking into account the account type. If coming from the worksheet, this is either the year-to-date or period amount.

Query Text

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


SELECT WORKSHEET_ID
,      SET_OF_BOOKS_ID
,      ACCOUNTING_DATE
,      DATE_CREATED
,      CREATED_BY
,      ACTUAL_FLAG
,      USER_JE_CATEGORY_NAME
,      USER_JE_SOURCE_NAME
,      BUDGET_VERSION_ID
,      CODE_COMBINATION_ID
,      BUDGET_SOURCE_TYPE
,      BUDGET_VERSION_FLAG
,      BALANCING_ENTRY_FLAG
,      GL_BUDGET_SET_ID
,      ENTERED_CR
,      ENTERED_DR
,      CURRENCY_CODE
,      STATUS
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      QUARTER_NUM
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      GROUP_ID
,      REQUEST_ID
,      DESCRIPTION
,      BUDGET_STAGE_ID
,      BUDGET_YEAR_ID
,      JE_TYPE
,      AMOUNT
FROM PSB.PSB_GL_INTERFACES;

Dependencies

[top of page]

PSB.PSB_GL_INTERFACES does not reference any database object

PSB.PSB_GL_INTERFACES is referenced by following:

APPS: PSB_GL_INTERFACES