CSI Tables (93)

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

Table	Columns	Description
`CSI_A_LOCATIONS`	13	Asset Location and HZ Location mapping.
`CSI_CONFIGURATION_TEMP_TBL`	2
`CSI_CONTACTS_MIG_INTERFACE`	3	Customer Product Contacts data Migration Interface (temporary data).
`CSI_COUNTERS_B`	76	Holds the counter instance data
`CSI_COUNTERS_TL`	12	Holds the translated counter instance data
`CSI_COUNTER_ASSOCIATIONS`	32	Holds the counter instance associations data
`CSI_COUNTER_DERIVED_FILTERS`	35	Holds the counter filters data
`CSI_COUNTER_PROPERTIES_B`	36	Holds the counter instance properties data
`CSI_COUNTER_PROPERTIES_TL`	12	Holds the translated counter instance property data
`CSI_COUNTER_READINGS`	58	Holds the counter readings and historical readings data
`CSI_COUNTER_READINGS_TEMP`	4
`CSI_COUNTER_READING_LOCKS`	17	Holds the counter reading lock data
`CSI_COUNTER_RELATIONSHIPS`	33	Holds the counter formula and counter configuration data
`CSI_COUNTER_TEMPLATE_B`	76	Holds the counter template data
`CSI_COUNTER_TEMPLATE_TL`	12	Holds the translated counter template data
`CSI_COUNTER_USAGE_FORECAST`	12	Holds the counter usage forecasting data
`CSI_CP_MIG_INTERFACE`	2	Customer Product data Migration Inteface (temporary data).
`CSI_CTR_ESTIMATED_READINGS`	34	Holds the counter estimated readings data
`CSI_CTR_ESTIMATION_METHODS_B`	32	Holds the counter estimation data
`CSI_CTR_ESTIMATION_METHODS_TL`	12	Holds the translated counter estimation data
`CSI_CTR_ITEM_ASSOCIATIONS`	35	Holds the counter item associations data
`CSI_CTR_PROPERTY_READINGS`	28	Holds the counter readings property data
`CSI_CTR_PROPERTY_TEMPLATE_B`	35	Holds the counter template properties data
`CSI_CTR_PROPERTY_TEMPLATE_TL`	12	Holds the translated counter template properties data
`CSI_CTR_READINGS_INTERFACE`	65	Holds the counter readings interface data
`CSI_CTR_READ_PROP_INTERFACE`	32	Holds the counter reading properties interface data
`CSI_CTR_UPLOAD_INSTANCES`	12	Holds the counter data to be instantiated
`CSI_DIAGNOSTICS_TEMP`	46	Temporary table used by the data correction process.
`CSI_EXPIRE_INSTANCES_TEMP`	4	Temporary table used by the data correction process
`CSI_FA_HEADERS`	10	This table stores the Fixed Asset Header Information
`CSI_FA_TRANSACTIONS`	21	This table stores the Fixed Asset Transaction Information
`CSI_HISTORY_ARCHIVE`	473	This table holds the archived history data when the transaction history archive and purge concurrent program is run.
`CSI_IB_TXN_TYPES`	28	Installed Base Transaction Types.
`CSI_IEA_VALUES`	30	Instance Extended Attribute Values.
`CSI_IEA_VALUES_H`	50	Instance Extended Attribute Values History.
`CSI_IEA_VALUE_INTERFACE`	24	Open Interface Extended Attributes
`CSI_II_FORWARD_SYNC_TEMP`	11	Temporary table used by the data correction process
`CSI_II_RELATIONSHIPS`	33	Instance to Instance Relationships.
`CSI_II_RELATIONSHIPS_H`	54	Instance to Instance Relationships' History.
`CSI_II_RELATION_INTERFACE`	41	Open Interface Instance Relationships
`CSI_II_RELATION_TYPES`	15	Instance to Instance Relationship Types.
`CSI_INSTALL_PARAMETERS`	22	Install Base Application Installation Parameters.
`CSI_INSTANCE_INTERFACE`	245	Open Interface Instance Interface
`CSI_INSTANCE_STATUSES`	37	Instance Statuses.
`CSI_INST_DTLS_MIG_INTERFACE`	3	Installation Details data Migration Interface (temporary data).
`CSI_INTERFACE_SOURCES`	9	Open Interface Interface Source Systems
`CSI_INV_DISCREPANCY_TEMP`	21	Temporary table which holds the descrepancy between item instance records and inventory onhand balances. Used only for reporting purpuses an
`CSI_IPA_RELATION_TYPES`	17	Instance to Party and Party to Account Relationship Types.
`CSI_IP_ACCOUNTS`	36	Instance to Accounts(Party Accounts) Association.
`CSI_IP_ACCOUNTS_H`	58	Instance to Accounts (Party Accounts) association History.
`CSI_ITEM_INSTANCES`	121	Item Instance details.
`CSI_ITEM_INSTANCES_H`	212	Item Instance History.
`CSI_ITEM_INSTANCE_LOCKS`	28	Stores locks on item instances that are configuration controlled by configurator rules.
`CSI_I_ASSETS`	19	Instance Asset Association.
`CSI_I_ASSETS_H`	34	Instance Asset association History.
`CSI_I_ASSET_INTERFACE`	19	Instance Asset Interface
`CSI_I_ASSET_TXN_TEMP`	29	Temporary table to hold Asset transactions (data is temporarily stored).
`CSI_I_EXTENDED_ATTRIBS`	36	Extended Attribute Template definition.
`CSI_I_ORG_ASSIGNMENTS`	30	Instance - Organization Associations.
`CSI_I_ORG_ASSIGNMENTS_H`	52	Instance Organization Associations History.
`CSI_I_PARTIES`	35	Instance - Party Associations.
`CSI_I_PARTIES_H`	62	Instance - Party Association History.
`CSI_I_PARTY_INTERFACE`	111	Open Interface Party Information
`CSI_I_PRICING_ATTRIBS`	129	Instance Pricing Attributes.
`CSI_I_PRICING_ATTRIBS_H`	250	Instance Pricing Attributes History.
`CSI_I_VERSION_LABELS`	31	Instance Version Labels.
`CSI_I_VERSION_LABELS_H`	54	Instance Version Labels History.
`CSI_MASS_EDIT_ENTRIES_B`	19	Instance Mass Edit Transaction Entries (Base Table).
`CSI_MASS_EDIT_ENTRIES_TL`	11	Instance Mass Edit Transaction Entries (Translation Table).
`CSI_OBJECT_DICTIONARY`	29	Holds the names of the objects and the sequence of archive for archival of transaction history data.
`CSI_PARAMETERS_MIG_INTERFACE`	2	Customer Product Parameters data Migration Interface (temporary data).
`CSI_SEARCH_OKS_TEMP`	4	Temporary Table to hold Contracts Data in HTML UI
`CSI_SOURCE_IB_TYPES`	14	Source transaction types - Applicable IB Transaction Types association.
`CSI_STATUSES_MIG_INTERFACE`	2	Customer Product Statuses data Migration Interface (temporary data).
`CSI_SYSTEMS_B`	46	System Details ( Base Table)
`CSI_SYSTEMS_B_MIG_INTERFACE`	2	Systems data Migration Interface (temporary data).
`CSI_SYSTEMS_H`	82	System details History.
`CSI_SYSTEMS_TL`	12	System Details (tanslation table).
`CSI_SYSTEMS_TL_MIG_INTERFACE`	3	System Details data migration Interface table (temporary data).
`CSI_TRANSACTIONS`	47	Installed Base transaction log.
`CSI_TXN_ERRORS`	40	Installed Base transaction errors.
`CSI_TXN_TEMP`	2
`CSI_TXN_TYPES`	32	Installed Base Source Transaction List.
`CSI_TXN_TYPES_MIG_INTERFACE`	2	Transaction Type data migration Interface (temporary data).
`CSI_T_EXTEND_ATTRIBS`	33	Transaction Details : Extended attributes.
`CSI_T_II_RELATIONSHIPS`	46	Transaction Details : Instance to Instance Relationships.
`CSI_T_ORG_ASSIGNMENTS`	32	Transaction Details : Instance-Organization Associations.
`CSI_T_PARTY_ACCOUNTS`	38	Transaction Details : Instance-Accounts (Party Accounts) Associations.
`CSI_T_PARTY_DETAILS`	37	Transaction Details : Instance-Party Associations.
`CSI_T_TRANSACTION_LINES`	37	Transaction Details : Transaction Lines
`CSI_T_TXN_LINE_DETAILS`	81	Transaction Details : Transaction Line Details.
`CSI_T_TXN_SYSTEMS`	46	Transaction Details : System Details.
`CSI_XNP_MSGS_TEMP`	9	Temporary table that holds the unprocessed XNP messages during data correction process.