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_LOCKBOX_INTS

Object Details

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

This entity acts as an interface table used to store inbound lockbox receipts. A loader process would populate the records in this table.
An interface table for the import of lockbox payments
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Lockbox Payments
Category: BUSINESS_ENTITY IGS_PARTY_CREDIT

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_LOCKBOX_INTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCKBOX_INTERFACE_ID
IGS_FI_LOCKBOX_INTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECORD_STATUS LOCKBOX_NAME
IGS_FI_LOCKBOX_INTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECORD_STATUS BATCH_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
LOCKBOX_INTERFACE_ID	NUMBER		Yes	The Unique Lockbox Interface Identifier that would be populated by the loader process.
RECORD_IDENTIFIER_CD	VARCHAR2	(2)	Yes	The Identifier of the particular record in the Lockbox Interface Table.
RECORD_STATUS	VARCHAR2	(10)	Yes	The Status of the particular Interface table record.
DEPOSIT_DATE	DATE			The Bank Supplied Lockbox Deposit Date.
TRANSMISSION_RECORD_COUNT	NUMBER	(15)		The number of records in the imported Bank Transmission.
TRANSMISSION_AMT	NUMBER			The total amount in the imported Bank Transmission.
LOCKBOX_NAME	VARCHAR2	(30)		The Lockbox Name associated with the record.
LOCKBOX_BATCH_COUNT	NUMBER	(15)		The total number of Lockbox Batches.
LOCKBOX_RECORD_COUNT	NUMBER	(15)		The total number of receipt records in the Lockbox.
LOCKBOX_AMT	NUMBER			The total currency amount in the Lockbox.
BATCH_NAME	VARCHAR2	(30)		The Lockbox batch name.
BATCH_AMT	NUMBER			The total currency amount in the Batch.
BATCH_RECORD_COUNT	NUMBER	(15)		The total number of receipt records in the Batch.
ITEM_NUMBER	NUMBER	(15)		The Item Number of the receipt or of the overflow record.
RECEIPT_AMT	NUMBER			The receipt amount.
CHECK_CD	VARCHAR2	(30)		The check number supplied by the bank for the receipt record.
PARTY_NUMBER	VARCHAR2	(30)		The party number supplied by the bank with which the receipt record is associated.
PAYER_NAME	VARCHAR2	(450)		The payer name provided by the bank with which the receipt record is associated.
CHARGE_CD1	VARCHAR2	(60)		The Charge Number for Targeted Application.
CHARGE_CD2	VARCHAR2	(60)		The Charge Number for Targeted Application.
CHARGE_CD3	VARCHAR2	(60)		The Charge Number for Targeted Application.
CHARGE_CD4	VARCHAR2	(60)		The Charge Number for Targeted Application.
CHARGE_CD5	VARCHAR2	(60)		The Charge Number for Targeted Application.
CHARGE_CD6	VARCHAR2	(60)		The Charge Number for Targeted Application.
CHARGE_CD7	VARCHAR2	(60)		The Charge Number for Targeted Application.
CHARGE_CD8	VARCHAR2	(60)		The Charge Number for Targeted Application.
APPLIED_AMT1	NUMBER			The Amount to be applied for Targeted Application.
APPLIED_AMT2	NUMBER			The Amount to be applied for Targeted Application.
APPLIED_AMT3	NUMBER			The Amount to be applied for Targeted Application.
APPLIED_AMT4	NUMBER			The Amount to be applied for Targeted Application.
APPLIED_AMT5	NUMBER			The Amount to be applied for Targeted Application.
APPLIED_AMT6	NUMBER			The Amount to be applied for Targeted Application.
APPLIED_AMT7	NUMBER			The Amount to be applied for Targeted Application.
APPLIED_AMT8	NUMBER			The Amount to be applied for Targeted Application.
CREDIT_TYPE_CD	VARCHAR2	(30)		The bank supplied code for Credit Type of the receipt record.
FEE_CAL_INSTANCE_CD	VARCHAR2	(30)		The bank supplied code for Fee Calendar Instance of the receipt record.
ADM_APPLICATION_ID	NUMBER	(15)		The Unique Admission Application identifier provided by the bank in case the inbound lockbox receipt is for an Enrollment Deposit.
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.
REQUEST_ID	NUMBER	(15)		Standard Concurrent Program column.
PROGRAM_ID	NUMBER	(15)		Standard Concurrent Program column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent Program column.
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent Program column.

Query Text

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


SELECT LOCKBOX_INTERFACE_ID
,      RECORD_IDENTIFIER_CD
,      RECORD_STATUS
,      DEPOSIT_DATE
,      TRANSMISSION_RECORD_COUNT
,      TRANSMISSION_AMT
,      LOCKBOX_NAME
,      LOCKBOX_BATCH_COUNT
,      LOCKBOX_RECORD_COUNT
,      LOCKBOX_AMT
,      BATCH_NAME
,      BATCH_AMT
,      BATCH_RECORD_COUNT
,      ITEM_NUMBER
,      RECEIPT_AMT
,      CHECK_CD
,      PARTY_NUMBER
,      PAYER_NAME
,      CHARGE_CD1
,      CHARGE_CD2
,      CHARGE_CD3
,      CHARGE_CD4
,      CHARGE_CD5
,      CHARGE_CD6
,      CHARGE_CD7
,      CHARGE_CD8
,      APPLIED_AMT1
,      APPLIED_AMT2
,      APPLIED_AMT3
,      APPLIED_AMT4
,      APPLIED_AMT5
,      APPLIED_AMT6
,      APPLIED_AMT7
,      APPLIED_AMT8
,      CREDIT_TYPE_CD
,      FEE_CAL_INSTANCE_CD
,      ADM_APPLICATION_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
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_FI_LOCKBOX_INTS;

Dependencies

[top of page]

IGS.IGS_FI_LOCKBOX_INTS does not reference any database object

IGS.IGS_FI_LOCKBOX_INTS is referenced by following:

APPS: IGS_FI_LOCKBOX_INTS