Product: | IGS - Student System |
---|---|
Description: | Form View used to display the lockbox receipt records that had validation errors detected during the import process from the interface table. |
Implementation/DBA Data: |
![]() |
SELECT LBERR.ROWID
, LBERR.LOCKBOX_RECEIPT_ERROR_ID
, LBERR.LOCKBOX_INTERFACE_ID
, LBERR.ITEM_NUMBER
, LBERR.LOCKBOX_NAME
, LBERR.RECEIPT_AMT
, LBERR.BATCH_NAME
, LBERR.PARTY_NUMBER
, LBERR.PAYER_NAME
, LBERR.CHECK_CD
, LBERR.DEPOSIT_DATE
, LBERR.CREDIT_TYPE_CD
, LBERR.FEE_CAL_INSTANCE_CD
, LBERR.CHARGE_CD1
, LBERR.CHARGE_CD2
, LBERR.CHARGE_CD3
, LBERR.CHARGE_CD4
, LBERR.CHARGE_CD5
, LBERR.CHARGE_CD6
, LBERR.CHARGE_CD7
, LBERR.CHARGE_CD8
, LBERR.APPLIED_AMT1
, LBERR.APPLIED_AMT2
, LBERR.APPLIED_AMT3
, LBERR.APPLIED_AMT4
, LBERR.APPLIED_AMT5
, LBERR.APPLIED_AMT6
, LBERR.APPLIED_AMT7
, LBERR.APPLIED_AMT8
, LBERR.ADM_APPLICATION_ID
, LBERR.ATTRIBUTE_CATEGORY
, LBERR.ATTRIBUTE1
, LBERR.ATTRIBUTE2
, LBERR.ATTRIBUTE3
, LBERR.ATTRIBUTE4
, LBERR.ATTRIBUTE5
, LBERR.ATTRIBUTE6
, LBERR.ATTRIBUTE7
, LBERR.ATTRIBUTE8
, LBERR.ATTRIBUTE9
, LBERR.ATTRIBUTE10
, LBERR.ATTRIBUTE11
, LBERR.ATTRIBUTE12
, LBERR.ATTRIBUTE13
, LBERR.ATTRIBUTE14
, LBERR.ATTRIBUTE15
, LBERR.ATTRIBUTE16
, LBERR.ATTRIBUTE17
, LBERR.ATTRIBUTE18
, LBERR.ATTRIBUTE19
, LBERR.ATTRIBUTE20
, LBERR.CREATED_BY
, LBERR.CREATION_DATE
, LBERR.LAST_UPDATE_DATE
, LBERR.LAST_UPDATED_BY
, LBERR.LAST_UPDATE_LOGIN
, LBERR.REQUEST_ID
, LBERR.PROGRAM_ID
, LBERR.PROGRAM_APPLICATION_ID
, LBERR.PROGRAM_UPDATE_DATE
FROM IGS_FI_LB_RECT_ERRS LBERR