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: HR.PAY_GL_INTERFACE

Object Details

Object Name:	PAY_GL_INTERFACE
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_GL_INTERFACE
Subobject Name:
Status:	VALID

PAY_GL_INTERFACE holds data to be passed to the General Ledger

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_GL_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSIGNMENT_ACTION_ID
PAY_GL_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	RUN_PAYROLL_ACTION_ID

Columns

Name	Datatype	Length	Comments
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Foreign Key to PAY_ASSIGNMENT_ACTIONS
RUN_PAYROLL_ACTION_ID	NUMBER	(9)	Foreign Key to PAY_PAYROLL_ACTIONS
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(9)	Foreign Key to PAY_COST_ALLOCATION_KEYFLEX
CURRENCY_CODE	VARCHAR2	(15)	Currency Code of result
ENTERED_DR	NUMBER		Deduction costed values
ENTERED_CR	NUMBER		Credit costed values
ACCOUNTING_DATE	DATE		Accounting date for estimated cost reversals

Query Text

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


SELECT ASSIGNMENT_ACTION_ID
,      RUN_PAYROLL_ACTION_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      CURRENCY_CODE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTING_DATE
FROM HR.PAY_GL_INTERFACE;

Dependencies

[top of page]

HR.PAY_GL_INTERFACE does not reference any database object

HR.PAY_GL_INTERFACE is referenced by following:

APPS: PAY_GL_INTERFACE
PUBLIC: PAY_GL_INTERFACE