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: GCS.GCS_WRITEBACK_HEADERS

Object Details

Object Name:	GCS_WRITEBACK_HEADERS
Object Type:	TABLE
Owner:	GCS
FND Design Data:	GCS.GCS_WRITEBACK_HEADERS
Subobject Name:
Status:	VALID

GCS_WRITEBACK_HEADERS stores the header information for writeback from Consoldiation to General Ledger

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GCS_WRTBK_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WRITEBACK_ID
GCS_WRTBK_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTRY_ID MOST_RECENT_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
WRITEBACK_ID	NUMBER	(15)	Yes	Writeback Entry Identifier
ENTRY_ID	NUMBER	(15)	Yes	Consolidation Entry Identifier
LEDGER_ID	NUMBER		Yes	Target Ledger Id
PERIOD_NAME	VARCHAR2	(30)	Yes	Target Period Name
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
GL_CATEGORY	VARCHAR2	(30)	Yes	Target Category Code
ACCOUNTING_DATE	DATE		Yes	Accounting Date
MOST_RECENT_FLAG	VARCHAR2	(1)	Yes	Most Recent Record Flag
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Identifier
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CONVERSION_TYPE	VARCHAR2	(30)		Currency Conversion Type
CONVERSION_RATE	NUMBER			Currency Conversion Rate
REQUEST_ID	NUMBER	(15)		Request Identifier
STATUS_CODE	VARCHAR2	(30)		Status Code

Query Text

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


SELECT WRITEBACK_ID
,      ENTRY_ID
,      LEDGER_ID
,      PERIOD_NAME
,      CURRENCY_CODE
,      GL_CATEGORY
,      ACCOUNTING_DATE
,      MOST_RECENT_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      CONVERSION_TYPE
,      CONVERSION_RATE
,      REQUEST_ID
,      STATUS_CODE
FROM GCS.GCS_WRITEBACK_HEADERS;

Dependencies

[top of page]

GCS.GCS_WRITEBACK_HEADERS does not reference any database object

GCS.GCS_WRITEBACK_HEADERS is referenced by following:

APPS: GCS_WRITEBACK_HEADERS