The Open Interface Tables

This appendix covers the following topics:

Oracle Install Base Open Interface Tables

This appendix consists of the following topics:

Main Columns of the CSI_INTERFACE_SOURCES Table

Name Datatype Size Mandatory Comments
SOURCE_SYSTEM_ID NUMBER   Yes Source System ID of the external or internal system.
SOURCE_SYSTEM_NAME VARCHAR2 30 Yes Source System Name of the external or internal system.
SOURCE_DESCRIPTION VARCHAR2 240   Source System Description of the external or internal system
SOURCE_LANG VARCHAR2 30   Primary Language of the external or internal system.
LAST_UPDATE_DATE DATE   Y Standard WHO column
LAST_UPDATE_BY NUMBER 15 Y Standard WHO column
CREATION_DATE DATE   Y Standard WHO column
CREATED_BY NUMBER 15 Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER 15   Standard WHO column

Main Columns of the CSI_INSTANCE_INTERFACE Table

Name Datatype Size Mandatory Comments
INST_INTERFACE_ID NUMBER   Yes Instance Interface ID
SOURCE_SYSTEM_NAME VARCHAR2 30 Yes Source System Name from CSI_INTERFACE_SOURCES
PARALLEL_WORKER_ID NUMBER     Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only.
REPLACE_FLAG VARCHAR2 1   Flag which indicates if the item instance is replaced
TRANSACTION_IDENTIFIER VARCHAR2 30   CSI Transaction identifier
SOURCE_TRANSACTION_DATE DATE   Yes Transaction Date that this Instance will be processed with the Open Interface.
SOURCE_TRANSACTION_TYPE VARCHAR2 30   CSI Source transaction type
INSTANCE_ID NUMBER     Unique ID that identifies an item unit instance
INSTANCE_NUMBER VARCHAR2 30   Functional User Key for Item Instance
INSTANCE_DESCRIPTION VARCHAR2 240   Description of the item instance
EXTERNAL_REFERENCE VARCHAR2 30   External reference given to item instance
PROCESS_STATUS VARCHAR2 1 Yes Process Status for Instance. Value Values are 'R' Ready, 'E' Error, 'P' Processed
BATCH_NAME VARCHAR2 30   Open interface batch name
ERROR_TEXT VARCHAR2 2000   Error text for any errors that are encountered while processing each row of data.
INVENTORY_ITEM_ID NUMBER     Inventory Item Id for the instance you are interfacing
INV_CONCATENATED_SEGMENTS VARCHAR2 250   Concatenated Segment for the instance you are interfacing
INVENTORY_REVISION VARCHAR2 30   Inventory Revision for items that are revision controlled in Inventory
INV_VLD_ORGANIZATION_ID NUMBER     Validation Organization ID that is used for Validating the Inventory Attributes
INV_VLD_ORGANIZATION_NAME VARCHAR2 250   Validation Organization Name that is used for Validating the Inventory Attributes
SERIAL_NUMBER VARCHAR2 30   Serial Number for this Item Instance
MFG_SERIAL_NUMBER_FLAG VARCHAR2 1   Manufacturer Serial Number Flag for this Instance. Valid values are Yes 'Y' or No 'N'. If this is set to Yes Install Base will validate the serial number against inventory otherwise it will not.
LOT_NUMBER VARCHAR2 30   The Lot Number for the lot where this item will exist
QUANTITY NUMBER     Instance Quantity
UNIT_OF_MEASURE_CODE VARCHAR2 3   Unit of Measure Code that will be used for this Instance (i.e. 'EA')
UNIT_OF_MEASURE VARCHAR2 30   Unit of Measure that will be used for this Instance (i.e. 'Each')
ACCOUNTING_CLASS_CODE VARCHAR2 30   Accounting Class Code
INSTANCE_CONDITION_ID NUMBER     Instance Condition ID
INSTANCE_CONDITION VARCHAR2 30   Instance Condition Name
INSTANCE_STATUS_ID NUMBER     Instance Status ID
INSTANCE_STATUS VARCHAR2 30   Instance Status Name
CUSTOMER_VIEW_FLAG VARCHAR2 1   Flag that indicates if this is as per a customer definition
MERCHANT_VIEW_FLAG VARCHAR2 1   Flag that indicates if this is as per a merchant definition
SELLABLE_FLAG VARCHAR2 1   Flag that indicates if this instance is sellable
SYSTEM_ID NUMBER     System ID
SYSTEM_NUMBER VARCHAR2 30   System Number
INSTANCE_START_DATE DATE     Active Start Date for this Instance
INSTANCE_END_DATE DATE     Active End Date for this Instance
INSTANCE_TYPE_CODE VARCHAR2 30   Instance Type Code
LOCATION_TYPE_CODE VARCHAR2 30   Location Type Code
LOCATION_ID NUMBER     Location ID
INV_ORGANIZATION_ID NUMBER     Inventory Organization ID
INV_ORGANIZATION_CODE VARCHAR2 30   Inventory Organization Code
INV_ORGANIZATION_NAME VARCHAR2 250   Inventory Organization Name
INV_SUBINVENTORY_NAME VARCHAR2 250   Inventory Subinventory Name
INV_LOCATOR_NUMBER VARCHAR2 30   Inventory Locator Number
INV_LOCATOR_ID NUMBER     Inventory Locator ID
PROJECT_ID NUMBER     Project ID
PROJECT_NUMBER VARCHAR2 30   Project Number
TASK_ID NUMBER     Task ID
TASK_NUMBER VARCHAR2 30   Task Number
IN_TRANSIT_ORDER_LINE_ID NUMBER     In Transit Order Line ID
IN_TRANSIT_ORDER_LINE_NUMBER VARCHAR2 30   In Transit Order Line Number
WIP_JOB_ID NUMBER     WIP Job ID
WIP_JOB_NAME VARCHAR2 250   WIP Job Name
PO_ORDER_LINE_ID NUMBER     Purchase Order Line ID
PO_ORDER_LINE_NUMBER VARCHAR2 30   Purchase Order Line Number
OE_ORDER_LINE_ID NUMBER     Order Line ID
OE_ORDER_LINE_NUMBER VARCHAR2 30   Order Line Number
OE_RMA_LINE_ID NUMBER     RMA Line Id
OE_RMA_LINE_NUMBER VARCHAR2 30   RMA Line Number
PO_PO_LINE_ID NUMBER     Purchase Order Line ID
PO_PO_LINE_NUMBER VARCHAR2 30   Purchase Order Line Number
OE_PO_NUMBER VARCHAR2 50   Order Entry PO Number
OE_AGREEMENT_ID NUMBER     Order Entry Agreement ID
INSTALL_LOCATION_TYPE_CODE VARCHAR2 30   Install Location Type Code
INSTALL_LOCATION_ID NUMBER     Install Location ID
INSTALL_DATE DATE     Install Date
RETURN_BY_DATE DATE     Return By Date
ACTUAL_RETURN_DATE DATE     Actual Return Date
CONFIG_INST_HDR_ID NUMBER     Configured item instance header id
CONFIG_INST_REV_NUM NUMBER     Configured item instance revision number
CONFIG_INST_ITEM_ID NUMBER     Configured item instance component item id
CONFIG_VALID_STATUS VARCHAR2 30   Configured item instance status
INSTANCE_OU_ID NUMBER     Instance Organization Unit ID
OPERATING_UNIT_NAME VARCHAR2 250   Operating Unit Name
OPERATING_UNIT NUMBER     Operating Unit Code
OU_RELATION_TYPE VARCHAR2 30   Operating Unit Relationship Type
OU_START_DATE DATE     Operating Unit Active Start Date
OU_END_DATE DATE     Operating Unit Active End Date
INSTANCE_CONTEXT VARCHAR2 30   Instance Flexfield Context
LAST_UPDATE_DATE DATE   Y Standard WHO column
LAST_UPDATE_BY NUMBER 15 Y Standard WHO column
CREATION_DATE DATE   Y Standard WHO column
CREATED_BY NUMBER 15 Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER 15   Standard WHO column

Main Columns of the CSI_I_PARTY_INTERFACE Table

Name Datatype Size Mandatory Comments
IP_INTERFACE_ID NUMBER   Yes Instance Party Interface ID
INST_INTERFACE_ID NUMBER   Yes Instance Interface ID that will be used to link the rows in this table to its parent in CSI_INSTANCE_INTERFACE
PARALLEL_WORKER_ID NUMBER     Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only.
ERROR_TEXT VARCHAR2 2000   Error text for any errors that are encountered while processing each row of data.
PARTY_ID NUMBER     Party ID
PARTY_NUMBER VARCHAR2 30   Party Number
INSTANCE_PARTY_ID NUMBER     Instance Party ID
PARTY_NAME VARCHAR2 250   Party Name
PARTY_SOURCE_TABLE VARCHAR2 30   Party Source Table
PARTY_RELATIONSHIP_TYPE_CODE VARCHAR2 30   Party Relationship Type Code
PARTY_START_DATE DATE     Party Active Start Date
PARTY_END_DATE DATE     Party Active End Date
CONTACT_FLAG VARCHAR2 1   Primary Contact Flag
CONTACT_IP_ID NUMBER     Self Join Key to the Same Table (INSTANCE_PARTY_ID)
CONTACT_PARTY_NUMBER VARCHAR2 30   Instance Party Contact Number
CONTACT_PARTY_NAME VARCHAR2 250   Instance Party Contact Name
CONTACT_PARTY_ID NUMBER     Instance Party Contact ID
CONTACT_PARTY_REL_TYPE VARCHAR2 30   Instance Party Contact Relationship Type
PARTY_CONTEXT VARCHAR2 30   Party Flexfield Context
IP_ACCOUNT1_ID NUMBER     Instance Party Account Identifier
PARTY_ACCOUNT1_NUMBER VARCHAR2 30   Party Account Number
PARTY_ACCOUNT1_ID NUMBER     Party Account ID
ACCT1_RELATIONSHIP_TYPE_CODE VARCHAR2 30   Party Account Relationship Type Code
PARTY_ACCT1_START_DATE DATE     Party Active Start Date
PARTY_ACCT1_END_DATE DATE     Party Active End Date
BILL_TO_ADDRESS1 NUMBER     Bill to Address
SHIP_TO_ADDRESS1 NUMBER     Ship to Address
ACCOUNT1_CONTEXT VARCHAR2 30   Party Account Flexfield Context
IP_ACCOUNT2_ID NUMBER     Instance Party Account Identifier
PARTY_ACCOUNT2_NUMBER VARCHAR2 30   Party Account Number
PARTY_ACCOUNT2_ID NUMBER     Party Account ID
ACCT2_RELATIONSHIP_TYPE_CODE VARCHAR2 30   Party Account Relationship Type Code
PARTY_ACCT2_START_DATE DATE     Party Account Active Start Date
PARTY_ACCT2_END_DATE DATE     Party Account Active End Date
BILL_TO_ADDRESS2 NUMBER     Bill to Address
SHIP_TO_ADDRESS2 NUMBER     Ship to Address
ACCOUNT2_CONTEXT VARCHAR2 30   Party Account Flexfield Context
IP_ACCOUNT3_ID NUMBER     Instance Party Account Identifier
PARTY_ACCOUNT3_NUMBER VARCHAR2 30   Party Account Number
PARTY_ACCOUNT3_ID NUMBER     Party Account ID
ACCT3_RELATIONSHIP_TYPE_CODE VARCHAR2 30   Party Account Relationship Type Code
PARTY_ACCT3_START_DATE DATE     Party Account Active Start Date
PARTY_ACCT3_END_DATE DATE     Party Account Active End Date
BILL_TO_ADDRESS3 NUMBER     Bill to Address
SHIP_TO_ADDRESS3 NUMBER     Ship to Address
ACCOUNT3_CONTEXT VARCHAR2 30   Party Account Flexfield Context
LAST_UPDATE_DATE DATE   Y Standard WHO column
LAST_UPDATE_BY NUMBER 15 Y Standard WHO column
CREATION_DATE DATE   Y Standard WHO column
CREATED_BY NUMBER 15 Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER 15   Standard WHO column

Main Columns of the CSI_II_RELATION_INTERFACE Table

Name Datatype Size Mandatory Comments
REL_INTERFACE_ID NUMBER   Yes Relationship Interface ID
PARALLEL_WORKER_ID NUMBER     Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only.
SUBJECT_INTERFACE_ID NUMBER     Subject Interface ID
OBJECT_INTERFACE_ID NUMBER     Object Interface ID
RELATIONSHIP_TYPE_CODE VARCHAR2 30   Relationship Type Code of this Instance to Instance Relationship (i.e. CONNECTEDTO)
RELATIONSHIP_START_DATE DATE     Active Start Date for the Instance to Instance Relationship.
RELATIONSHIP_END_DATE DATE     Active End Date for the Instance to Instance Relationship.
POSITION_REFERENCE VARCHAR2 30   Position Reference of the Relationship
DISPLAY_ORDER NUMBER     Order in which the UI will display the relationships
MANDATORY_FLAG VARCHAR2 1   Mandatory relationship indicator
RELATIONSHIP_DIRECTION VARCHAR2 30   Relationship direction
ERROR_TEXT VARCHAR2 2000   Error text for any errors that are encountered while processing each row of data.
CONTEXT VARCHAR2 30   Standard Oracle DFF context field
LAST_UPDATE_DATE DATE   Y Standard WHO column
LAST_UPDATE_BY NUMBER 15 Y Standard WHO column
CREATION_DATE DATE   Y Standard WHO column
CREATED_BY NUMBER 15 Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER 15   Standard WHO column

Main Columns of the CSI_IEA_VALUE_INTERFACE Table

Name Datatype Size Mandatory Comments
IEAV_INTERFACE_ID NUMBER   Yes Extended Attribute Interface ID
INST_INTERFACE_ID NUMBER   Yes Instance Interface ID that will be used to link the rows in this table to its parent in CSI_INSTANCE_INTERFACE
PARALLEL_WORKER_ID NUMBER     Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only.
ERROR_TEXT VARCHAR2 2000   Error text for any errors that are encountered while processing each row of data.
ATTRIBUTE_ID NUMBER     Extended Attribute ID
INV_CONCATENATED_SEGMENTS VARCHAR2 250   Concatenated Segment for the instance you are interfacing
INVENTORY_ITEM_ID NUMBER     Inventory Item Id for the instance you are interfacing
MASTER_ORGANIZATION_ID NUMBER     Master Organization Id for the instance you are interfacing
MASTER_ORGANIZATION_NAME VARCHAR2 250   Master Organization Name for the instance you are interfacing
ITEM_CATEGORY_CONC_SEG VARCHAR2 250   Instance Item Category for the Extended Attribute
ITEM_CATEGORY_ID NUMBER     Instance Item Category ID for the Extended Attribute
ATTRIBUTE_CODE VARCHAR2 30   Attribute Code which this Extended Attribute is defined
ATTRIBUTE_NAME VARCHAR2 50   Attribute Name which this Extended Attribute is defined
ATTRIBUTE_LEVEL VARCHAR2 15   Attribute Level which this Extended Attribute is defined
ATTRIBUTE_CATEGORY VARCHAR2 30   Attribute Category which this Extended Attribute is defined
ATTRIBUTE_VALUE VARCHAR2 240   Attribute Value which this Extended Attribute is defined
ATTRIBUTE_VALUE_ID NUMBER     Attribute Value ID which this Extended Attribute is defined
IEAV_START_DATE DATE     Active Start Date for Interfaced Instance
IEAV_END_DATE DATE     Active End Date for Interfaced Instance
LAST_UPDATE_DATE DATE   Y Standard WHO column
LAST_UPDATE_BY NUMBER 15 Y Standard WHO column
CREATION_DATE DATE   Y Standard WHO column
CREATED_BY NUMBER 15 Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER 15   Standard WHO column

Main Columns of the CSI_ASSET_INTERFACE Table

Name Datatype Size Mandatory Comments
IA_INTERFACE_ID NUMBER   Yes Asset Interface ID
INST_INTERFACE_ID NUMBER   Yes Instance Interface ID that will be used to link the rows in this table to its parent in CSI_INSTANCE_INTERFACE
PARALLEL_WORKER_ID NUMBER     Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only.
ERROR_TEXT VARCHAR2 2000   Error text for any errors that are encountered while processing each row of data.
INSTANCE_ASSET_ID NUMBER   Yes Instance Asset Identifier
FA_ASSET_ID NUMBER     Asset Identifier from Fixed Assets System
FA_BOOK_TYPE_CODE VARCHAR2 15   Book Type Code from Fixed Assets
FA_LOCATION_ID NUMBER   Yes Location Identifier from Fixed Assets
ASSET_QUANTITY NUMBER     Asset Quantity
UPDATE_STATUS VARCHAR2 30   Update Status
ACTIVE_START_DATE DATE     Activation Start Date
ACTIVE_END_DATE DATE     Activation End Date
LAST_UPDATE_DATE DATE   Y Standard WHO column
LAST_UPDATE_BY NUMBER 15 Y Standard WHO column
CREATION_DATE DATE   Y Standard WHO column
CREATED_BY NUMBER 15 Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER 15   Standard WHO column

Main Columns of the CSI_CTR_READINGS_INTERFACE Table

Name Datatype Size Mandatory Comments
COUNTER_INTERFACE_ID NUMBER   Y Counter interface identifier
PARALLEL_WORKER_ID NUMBER     Parallel worker id
BATCH_NAME VARCHAR2 30   Batch name
SOURCE_SYSTEM_NAME VARCHAR2 30   Source system name
SOURCE_TRANSACTION_DATE DATE     Source transaction date
PROCESS_STATUS VARCHAR2 1   Processing status
ERROR_TEXT VARCHAR2 240   Error messages
COUNTER_VALUE_ID NUMBER   Y Counter reading identifier
COUNTER_ID NUMBER   Y Counter identifier
VALUE_TIMESTAMP DATE   Y Value timestamp
COUNTER_READING NUMBER   Y Counter reading
RESET_MODE VARCHAR2 30   Reset mode
RESET_REASON VARCHAR2 255   Reset reason description
ADJUSTMENT_TYPE VARCHAR2 30   Adjustment type
ADJUSTMENT_READING NUMBER     Adjustment reading
OBJECT_VERSION_NUMBER NUMBER   Y Object version number
ATTRIBUTE_CATEGORY VARCHAR2 30   Standard DFF Column
COMMENTS VARCHAR2 2000   Counter comments
LIFE_TO_DATE_READING NUMBER   Y Life to date reading
SOURCE_TRANSACTION_TYPE_ID NUMBER     Transaction type code where the reading was generated
SOURCE_TRANSACTION_ID NUMBER     Transaction identifier
SOURCE_CODE VARCHAR2 30   Source Code
SOURCE_LINE_ID NUMBER     Source Line Identifier
COUNTER_NAME VARCHAR2 30   Counter Name
READING_CHANGE NUMBER     Reading Change Identifier
NET_READING NUMBER   Y Net reading
DISABLED_FLAG VARCHAR2 1   Flag indicating if the counter reading is disabled
AUTOMATIC_ROLLOVER_FLAG VARCHAR2 1   Automatic Rollover Flag
INCLUDE_TARGET_RESETS VARCHAR2 1   Target Reset Flag
RESET_NET_READING NUMBER   Y Reset Net Reading
RESET_COUNTER_READING NUMBER   Y Reset Counter Reading
RESET_LIFE_TO_DATE_READING NUMBER   Y Reset Life To Date Reading
LAST_UPDATE_DATE DATE   Y Standard WHO column
LAST_UPDATE_BY NUMBER 15 Y Standard WHO column
CREATION_DATE DATE   Y Standard WHO column
CREATED_BY NUMBER 15 Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER 15   Standard WHO column

Main Columns of the CSI_CTR_READ_PROP_INTERFACE Table

Name Datatype Size Mandatory Comments
COUNTER_INTERFACE_ID NUMBER   Y Counter interface identifier
PARALLEL_WORKER_ID NUMBER     Parallel worker identifier
ERROR_TEXT VARCHAR2 240   Error messages
COUNTER_PROP_VALUE_ID NUMBER   Y Counter property value identifier
COUNTER_VALUE_ID NUMBER   Y Counter reading identifier
COUNTER_PROPERTY_ID NUMBER   Y Counter property identifier
PROPERTY_VALUE VARCHAR2 240 Y Property value
VALUE_TIMESTAMP DATE   Y Value timestamp
SEQ_NO NUMBER   Y Sequence number
OBJECT_VERSION_NUMBER NUMBER   Y Object version number
LAST_UPDATE_DATE DATE   Y Standard WHO column
LAST_UPDATE_BY NUMBER 15 Y Standard WHO column
CREATION_DATE DATE   Y Standard WHO column
CREATED_BY NUMBER 15 Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER 15   Standard WHO column
ATTRIBUTE_CATEGORY VARCHAR2 30   Standard DFF Column