DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_FI_LOCKBOXES

Object Details
Object Name: IGS_FI_LOCKBOXES
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_FI_LOCKBOXES
Subobject Name:
Status: VALID


Table for storing the attributes of a user defined Lockbox Name.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_LOCKBOXES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCKBOX_NAME
Columns
Name Datatype Length Mandatory Comments
LOCKBOX_NAME VARCHAR2 (30) Yes The Lockbox Name associated with the record.
LOCKBOX_DESC VARCHAR2 (240) Yes User defined description for the Lockbox.
CLOSED_FLAG VARCHAR2 (1) Yes Closed Indicator for deactivating the Lockbox.
GL_DATE_SOURCE_CODE VARCHAR2 (30) Yes Indicates GL Date Source associated to the lockbox.
DEFAULT_CREDIT_TYPE_ID NUMBER (15)
Default Credit Type Identifier associated to the defined Lockbox.
BANK_ACCOUNT_ID NUMBER (15)
No longer used
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield.
CREATED_BY NUMBER (15) Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
Query Text

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


SELECT LOCKBOX_NAME
,      LOCKBOX_DESC
,      CLOSED_FLAG
,      GL_DATE_SOURCE_CODE
,      DEFAULT_CREDIT_TYPE_ID
,      BANK_ACCOUNT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_LOCKBOXES;

Dependencies

[top of page]

IGS.IGS_FI_LOCKBOXES does not reference any database object

IGS.IGS_FI_LOCKBOXES is referenced by following:

SchemaAPPS
SynonymIGS_FI_LOCKBOXES