Search Results lockbox_name




Overview
Explore in AI Chat

Overview

The IGS_FI_LB_REC_TYPES table is a configuration table within the Oracle E-Business Suite Student System (IGS) module. Its primary role is to define and manage the mapping between bank-supplied record identifiers found in lockbox transmission files and the internal record type codes used by the application. This mapping is critical for the automated processing of electronic payments, as it enables the system to correctly interpret and route different data rows (e.g., header, detail, trailer records) from a bank's standardized file format. The table ensures that payment data from various banking institutions, each potentially using different identifier codes, can be accurately parsed and posted to the correct student financial accounts.

Key Information Stored

The table's structure is defined by a composite primary key and a unique key, emphasizing the criticality of its configuration data. The most important columns include LOCKBOX_NAME, which identifies the specific lockbox configuration from the IGS_FI_LOCKBOXES table. The RECORD_IDENTIFIER_CD stores the actual character or code as it appears in the bank's transmission file. The RECORD_TYPE_CODE is the internal application code that the system uses to classify that row of data (e.g., signifying a payment detail line versus a batch header). The relationship between these columns allows the system to translate external bank codes into a consistent internal processing logic.

Common Use Cases and Queries

The primary use case is during the execution of the Lockbox Processing concurrent program. When a bank file is ingested, the program queries this table to build a translation map. For instance, to validate or review the configuration for a specific lockbox, a query such as SELECT record_identifier_cd, record_type_code FROM igs_fi_lb_rec_types WHERE lockbox_name = 'US_EAST_BANK'; would be typical. Administrators may also query this table to troubleshoot parsing errors by verifying that the identifiers in an incoming file match a configured record type. Reporting on lockbox setups often involves joining this table to IGS_FI_LOCKBOXES to present a complete view of the bank interface configuration.

Related Objects

This table has a direct and essential relationship with the IGS_FI_LOCKBOXES table, which defines the master lockbox parameters. The documented foreign key constraint ensures referential integrity: the LOCKBOX_NAME in IGS_FI_LB_REC_TYPES must exist in IGS_FI_LOCKBOXES. This table is a child of IGS_FI_LOCKBOXES. The processing logic for lockbox files, likely housed within packages or concurrent programs in the IGS Financials domain, will heavily reference this mapping table. It serves as a key configuration point between the external bank data (via IGS_FI_LOCKBOXES) and the internal payment application engine.

  • Table: IGS_FI_LB_REC_TYPES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LB_REC_TYPES,  object_name:IGS_FI_LB_REC_TYPES,  status:VALID,  product: IGS - Student System ,  description: Table for mapping bank supplied record type identifiers for each data row in the bank transmission files. ,  implementation_dba_data: IGS.IGS_FI_LB_REC_TYPES , 

  • Table: IGS_FI_LB_CR_TYPES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LB_CR_TYPES,  object_name:IGS_FI_LB_CR_TYPES,  status:VALID,  product: IGS - Student System ,  description: Table to store the mapping of bank-supplied codes to pre-defined Credit Types in the context of a Lockbox. ,  implementation_dba_data: IGS.IGS_FI_LB_CR_TYPES , 

  • Table: IGS_FI_LB_FCIS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LB_FCIS,  object_name:IGS_FI_LB_FCIS,  status:VALID,  product: IGS - Student System ,  description: Table for mapping bank codes with the fee calendar instance as defined in the system for a lockbox in context. ,  implementation_dba_data: IGS.IGS_FI_LB_FCIS , 

  • View: IGS_FI_LB_REC_TYPES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_LB_REC_TYPES_V,  object_name:IGS_FI_LB_REC_TYPES_V,  status:VALID,  product: IGS - Student System ,  description: Form View used for showing the mapping of bank supplied record type identifiers in the context of a lockbox. ,  implementation_dba_data: APPS.IGS_FI_LB_REC_TYPES_V , 

  • Table: IGS_FI_LOCKBOXES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LOCKBOXES,  object_name:IGS_FI_LOCKBOXES,  status:VALID,  product: IGS - Student System ,  description: Table for storing the attributes of a user defined Lockbox Name. ,  implementation_dba_data: IGS.IGS_FI_LOCKBOXES , 

  • View: IGS_FI_LB_CR_TYPES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_LB_CR_TYPES_V,  object_name:IGS_FI_LB_CR_TYPES_V,  status:VALID,  product: IGS - Student System ,  description: Form view used to show the mapping of bank-supplied codes with pre-defined Credit Types in the context of a Lockbox. ,  implementation_dba_data: APPS.IGS_FI_LB_CR_TYPES_V , 

  • View: IGS_FI_LB_FCIS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_LB_FCIS_V,  object_name:IGS_FI_LB_FCIS_V,  status:VALID,  product: IGS - Student System ,  description: Form View used to show the mapping of bank codes with the fee calendar instances in the context of a Lockbox. ,  implementation_dba_data: APPS.IGS_FI_LB_FCIS_V , 

  • View: IGS_FI_LOCKBOXES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_LOCKBOXES_V,  object_name:IGS_FI_LOCKBOXES_V,  status:VALID,  product: IGS - Student System ,  description: Form View used for Lockbox Setup. ,  implementation_dba_data: APPS.IGS_FI_LOCKBOXES_V , 

  • View: IGS_FI_LB_RECT_ERRS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_LB_RECT_ERRS_V,  object_name:IGS_FI_LB_RECT_ERRS_V,  status:VALID,  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: APPS.IGS_FI_LB_RECT_ERRS_V ,