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: CZ.CZ_XFR_FIELDS

Object Details

Object Name:	CZ_XFR_FIELDS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_XFR_FIELDS
Subobject Name:
Status:	VALID

CZ_XFR_FIELDS table is used to specify transfer rules for fields transferred during the import process. It actually works primarily to specify overrides to normal rules; if a field is transferred for which no entry exists in XFR_FIELD, the default import rules are applied.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_XFR_FIELDS_PK

FIELD_ORDER
XFR_GROUP
ORDER_SEQ

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_XFR_FIELDS_PK	NORMAL	UNIQUE	APPS_TS_SEED	FIELD_ORDER XFR_GROUP ORDER_SEQ
CZ_XFR_FIELDS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	ORDER_SEQ XFR_GROUP

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_SEQ	NUMBER	(9)	Yes	Identifies the XFR_TABLES order to which this field record refers
XFR_GROUP	VARCHAR2	(20)	Yes	Identifies the import/transfer group of which this field is a member
FIELD_ORDER	NUMBER		Yes	Orders field transfers within the table transferred
SRC_FIELD	VARCHAR2	(40)		Name of the source field from the source table identified in XFR_TABLES
DST_FIELD	VARCHAR2	(40)		Name of the destination field in the destination table identified in XFR_TABLES
REQUIRED	VARCHAR2	(1)		'0'/'1' Indicates whether this field is required or not, default '0' (not required)
DEFAULTSYNTAX	VARCHAR2	(255)		UNUSED
NOUPDATE	VARCHAR2	(1)		'0'/'1' Applies to records being updated by the successive import of the same row into the database. If '1', this field is not to be updated. If '0' (default), the field will be updated with the rest of the row

Query Text

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


SELECT ORDER_SEQ
,      XFR_GROUP
,      FIELD_ORDER
,      SRC_FIELD
,      DST_FIELD
,      REQUIRED
,      DEFAULTSYNTAX
,      NOUPDATE
FROM CZ.CZ_XFR_FIELDS;

Dependencies

[top of page]

CZ.CZ_XFR_FIELDS does not reference any database object

CZ.CZ_XFR_FIELDS is referenced by following:

APPS: CZ_XFR_FIELDS