IEX Tables (80)

IEX - Collections — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
`IEX_AG_DN_XREF`	43	Cross reference between aging/dunning/Fulfillment
`IEX_APP_PREFERENCES_B`	17	Collection Preferences Table
`IEX_APP_PREFERENCES_TL`	11	Translation Table for IEX_APP_PREFERENCES_B
`IEX_ASSIGNMENTS`	17	New Assignments Table for Temporary Resource handling
`IEX_BALI_FILTERS`	40	This entity holds information on the additional filters created on any bali spread tables. It will hold the column name , column value and t
`IEX_BANKRUPTCIES`	75	This entity keeps information on Bankrupt cases. Bankruptcy information such the category, the jurisdiction, date initiated, court proceedi
`IEX_CASES_ALL_B`	42	Details of the Case
`IEX_CASES_TL`	11	Translation Table for table IEX_CASES
`IEX_CASE_CONTACTS`	34	Holds information about the contacts defined for party playing a specific role in the collection process of a case.
`IEX_CASE_DEFINITIONS`	33	Hold information about the criteria which is used to identify a case.For example , a case (if it is contract) is uniquely identified by the
`IEX_CASE_OBJECTS`	35	Hold information about the elements of a case. Example . It will hold object_code 'CONTRACTS' and
`IEX_CGI_SWITCHES`	32	Metadata for query string switches
`IEX_CHANGED_ACCOUNTS_ALL`	15	This table stores accounts that have new collectors assigned.
`IEX_CHECKLIST_ITEMS_B`	18	Store Checklist items for administration
`IEX_CHECKLIST_ITEMS_TL`	11	Translation table of IEX_CHECKLIST_ITEMS_B
`IEX_COSTS`	43	Maintains the actual and budgeted costs for a case or delinquency
`IEX_CUST_STATUS_RULES`	18	Stores rules on how to display Customer Status.
`IEX_CU_STS_RL_LINES`	17	Stores details on Customer Status Rules.
`IEX_DELINQUENCIES_ALL`	42	Holds transaction data about customer delinquencies.
`IEX_DEL_ASSETS`	19	Cross reference for all assets assigned to a delinquency.
`IEX_DEL_BUFFERS`	22
`IEX_DEL_PAY_XREF`	11	This table stores what delinquencies were paid by an A/R payment.
`IEX_DEL_STATUSES`	17	delinquency score/ status configuration
`IEX_DEL_THIRD_PARTIES`	20	Cross reference for all third parties assigned to a delinquency.
`IEX_DISPUTES`	31	Holds data about all disputes processed through collections UI.
`IEX_DLN_UWQ_SUMMARY`	116	Summary table for universal work queue collections nodes
`IEX_DUNNINGS`	59	Holds data on all dunning transactions sent by the system.
`IEX_DUNNING_PLANS_B`	23	Collections dunning base table
`IEX_DUNNING_PLANS_TL`	15	Collections dunning plan translated table
`IEX_DUNNING_PROFILES`	29	OBSOLETED - Profile to save dunning info
`IEX_DUNNING_TRANSACTIONS`	12	Collections dunning transaction table
`IEX_EXCLUSION_HIST_B`	32	Stores contracts that are excluded from delinquency reports
`IEX_EXCLUSION_HIST_TL`	11	Translation table for IEX_EXCLUSION_HIST_B
`IEX_EXT_AGNCY_B`	30	Stores External Agency Details
`IEX_EXT_AGNCY_TL`	10	Translation table for IEX_EXT_AGNCY_B
`IEX_LITIGATIONS`	47	Details for Litigation
`IEX_METRIC_RATINGS`	13	Rating range details for metric component types
`IEX_METRIC_SUMMARIES_ALL`	11	Store metric summary batch information
`IEX_OBJECT_FILTERS`	18
`IEX_OPEN_INT_HST`	41
`IEX_PAYMENTS`	34	Holds data on all payments received by the system.
`IEX_PAY_OKL_XREF`	16	Table stores all OKL consolidated invoices or contracts paid in IEX
`IEX_PAY_RECEIPT_XREF`	11	Stores information on what receipts were generated by what payments.
`IEX_PRD_APPL_XREF`	17	This table stores promise application information.
`IEX_PRD_OKL_XREF`	16	This table stores cross reference information between promises and Consolidated invoices.
`IEX_PRD_RECEIPT_XREF`	11	Stores information on what promises are paid by what receipts.
`IEX_PROMISE_DETAILS`	52	Holds detail information about each promise to pay.
`IEX_QUERY_STRINGS`	31
`IEX_QUERY_TEMP_XREF`	9	cross reference table for xdo tempalte and collections sql query
`IEX_QUESTIONNAIRE_ITEMS`	38	Setup table for questionnaire administration
`IEX_REPOSSESSIONS`	51	Details for Repossession
`IEX_REPOS_OBJECTS`	35	Stores information of assets that are undergoing repossession.
`IEX_SCORES`	26	Stores all the score definitions.
`IEX_SCORE_COMPONENTS`	16	Stores details about what items make a score.
`IEX_SCORE_COMP_DET`	15	Stores range and value details for components
`IEX_SCORE_COMP_PARAMS`	18	Stores Parameters to Score components.
`IEX_SCORE_COMP_TYPES_B`	16	Stores configuration data on score components.
`IEX_SCORE_COMP_TYPES_TL`	14	Stores configuration data on score components.
`IEX_SCORE_HISTORIES`	20	Stores historical data about collection scores.
`IEX_STRATEGIES`	32
`IEX_STRATEGY_TEMPLATES_B`	26
`IEX_STRATEGY_TEMPLATES_TL`	11
`IEX_STRATEGY_TEMPLATE_GROUPS`	29
`IEX_STRATEGY_TYPES`	8	OBSOLETED. Obsoleted
`IEX_STRATEGY_USER_ITEMS`	31	Custom work item templates added to a particular strategy IEX_STRATEGY
`IEX_STRATEGY_WORK_ITEMS`	39	Each work item associated with strategy IEX_STRATEGIES
`IEX_STRATEGY_WORK_SKILLS`	14	Skill set associateds with each work item Template defined in IEX_STRY_TEMP_WORK_ITEMS_B
`IEX_STRATEGY_WORK_TEMP_XREF`	17
`IEX_STRY_TEMP_WORK_ITEMS_B`	54
`IEX_STRY_TEMP_WORK_ITEMS_TL`	12
`IEX_STRY_WORK_TYPES`	1	OBSOLETED. Obsoleted
`IEX_SWITCH_DATA`	35	Metadata for all data on a CGI switch
`IEX_WEB_ASSISTS`	29	Stores all available web directory assitance sites.
`IEX_WEB_SEARCHES`	32	All available web searches
`IEX_WRITEOFFS`	63	This entity holds information on writeoffs.
`IEX_WRITEOFF_CONTRACTS`	19
`IEX_WRITEOFF_INVOICES`	20
`IEX_WRITEOFF_OBJECTS`	41	This entity holds information on writeoff objects..Writeoff Could occur at 3 different levels. This is again OKL specific. Contracts with a
`IEX_XML_QUERIES`	16	This table holds the query for xml publisher template.
`IEX_XML_REQUEST_HISTORIES`	41	xdo requested history for Collections