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: IGS.IGS_FI_CR_TYPES_ALL

Object Details

Object Name:	IGS_FI_CR_TYPES_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_FI_CR_TYPES_ALL
Subobject Name:
Status:	VALID

Stores information about the 'credit type' of a credit transaction. The credit type provides the debit and credit account information to a credit transaction along with some other information like credit class etc.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_CR_TYPES_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CREDIT_TYPE_ID
IGS_FI_CR_TYPES_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CREDIT_TYPE_NAME EFFECTIVE_START_DATE ORG_ID
IGS_FI_CR_TYPES_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBACCOUNT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CREDIT_TYPE_ID	NUMBER	(15)	Yes	Sequence generated Credit Type ID - Primary Key
CREDIT_TYPE_NAME	VARCHAR2	(60)	Yes	Name of the Credit Type
DESCRIPTION	VARCHAR2	(240)		Description
CREDIT_CLASS	VARCHAR2	(40)	Yes	Lookup Code - System Level - Payment etc.
DR_ACCOUNT_CD	VARCHAR2	(40)		Debit Account String
CR_ACCOUNT_CD	VARCHAR2	(40)		Credit Account String
DR_GL_CCID	NUMBER	(15)		Debit Account Flexfield CCID
CR_GL_CCID	NUMBER	(15)		Credit Account Flexfield CCID
EFFECTIVE_START_DATE	DATE		Yes	Effective Start Date
EFFECTIVE_END_DATE	DATE			Effective End Date
REFUND_ALLOWED	VARCHAR2	(1)		Refund Allowable Flag
ORG_ID	NUMBER	(15)		Multi Org Operating Unit
SUBACCOUNT_ID	NUMBER	(15)		OBSOLETE. Sub Account that this credit type belongs to
PAYMENT_PRIORITY	NUMBER			Payment Priority - Future use in FAM
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard DFF Column
ATTRIBUTE1	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE2	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE3	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE4	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE5	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE6	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE7	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE8	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE9	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE10	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE11	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE12	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE13	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE14	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE15	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE16	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE17	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE18	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE19	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE20	VARCHAR2	(150)		Standard DFF Column
TITLE4_TYPE_IND	VARCHAR2	(1)	Yes	Denotes if the Credit type is of Title IV type.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
PAYMENT_CREDIT_TYPE_ID	NUMBER	(15)		Payment Credit Type Identifier.
FORFEITURE_GL_CCID	NUMBER	(38)		Forfeiture GL Flexfield Account.
FORFEITURE_ACCOUNT_CD	VARCHAR2	(40)		Forfeiture Account Code String.
APPL_HIERARCHY_ID	NUMBER	(15)		Application Hierarchy Identifier

Query Text

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


SELECT CREDIT_TYPE_ID
,      CREDIT_TYPE_NAME
,      DESCRIPTION
,      CREDIT_CLASS
,      DR_ACCOUNT_CD
,      CR_ACCOUNT_CD
,      DR_GL_CCID
,      CR_GL_CCID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      REFUND_ALLOWED
,      ORG_ID
,      SUBACCOUNT_ID
,      PAYMENT_PRIORITY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      TITLE4_TYPE_IND
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      PAYMENT_CREDIT_TYPE_ID
,      FORFEITURE_GL_CCID
,      FORFEITURE_ACCOUNT_CD
,      APPL_HIERARCHY_ID
FROM IGS.IGS_FI_CR_TYPES_ALL;

Dependencies

[top of page]

IGS.IGS_FI_CR_TYPES_ALL does not reference any database object

IGS.IGS_FI_CR_TYPES_ALL is referenced by following:

APPS: IGS_FI_CR_TYPES_ALL