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

TABLE: IGS.IGS_FI_LB_RECT_ERRS

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


This entity would be used to store the lockbox receipt records that had validation errors detected during the import process from the interface table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_LB_RECT_ERRS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCKBOX_RECEIPT_ERROR_ID
IGS_FI_LB_RECT_ERRS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCKBOX_NAME
Columns
Name Datatype Length Mandatory Comments
LOCKBOX_RECEIPT_ERROR_ID NUMBER
Yes The Unique sequence generated identifier for the erroneous receipt record.
LOCKBOX_INTERFACE_ID NUMBER
Yes The Unique Lockbox Interface Identifier.
ITEM_NUMBER NUMBER (15) Yes The Item Number of the receipt record.
LOCKBOX_NAME VARCHAR2 (30) Yes The Lockbox Name associated with the record.
RECEIPT_AMT NUMBER
Yes The Receipt Amount.
BATCH_NAME VARCHAR2 (30)
The Lockbox batch name.
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.
CHECK_CD VARCHAR2 (30)
The check number supplied by the bank for the receipt record.
DEPOSIT_DATE DATE

The Bank Supplied Lockbox Deposit Date.
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.
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.
ADM_APPLICATION_ID NUMBER (15)
The Unique Admission Application identifier provided by the bank in case the inbound lockbox receipt is for a 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_RECEIPT_ERROR_ID
,      LOCKBOX_INTERFACE_ID
,      ITEM_NUMBER
,      LOCKBOX_NAME
,      RECEIPT_AMT
,      BATCH_NAME
,      PARTY_NUMBER
,      PAYER_NAME
,      CHECK_CD
,      DEPOSIT_DATE
,      CREDIT_TYPE_CD
,      FEE_CAL_INSTANCE_CD
,      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
,      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_LB_RECT_ERRS;

Dependencies

[top of page]

IGS.IGS_FI_LB_RECT_ERRS does not reference any database object

IGS.IGS_FI_LB_RECT_ERRS is referenced by following:

SchemaAPPS
SynonymIGS_FI_LB_RECT_ERRS