Instance
Records the Item Instance Details of an IB instance
Table: CSI_ITEM_INSTANCES
Transaction
Install Base Transaction Log
Table: CSI_TRANSACTIONS
Csi_transactions
Transaction_id
Transaction_type_id
Csi_txn_types
Transaction_type_id
Csi_item_instances_h
Instance_history_id
Instance_id
Transaction_id
Csi_item_instances
Instance_id
Inventory_item_id
Serial_number
Instance_status_id
Location_id
Instance Relationship
Defines the instance to instance relationships
Table: CSI_II_RELATIONSHIPS
Csi_item_instances
Instance_id
Csi_ii_relationships
Relationship_id
Subject_id
Relationship_type_code
Object_id
Csi_ii_relation_types
Relationship_type_code
Csi_ii_relationships_h
Relationship_history_id
Relationship_id
Transaction_Id
Csi_transactions
Transaction_id
Instance Party relationship
Defines the relationship between Instance and party
Table: CSI_II_PARTIES
Instance Party accounts
Defines the Instance to account (party account) association
Table: CSI_IP_ACCOUNTS
Csi_item_instances
Instance_id
Csi_ip_accounts_h
Ip_account_history_id
Ip_account_id
Transaction_id
Csi_ip_accounts
Ip_account_id
Instance_party_id
Party_account_id
Csi_i_parties
Instance_party_id
Relationship_type_code
Instance_id
Party_id
Csi_transactions
Transaction_id
Csi_i_parties_h
Instance_party_history_id
Instance_party_id
Transaction_id
API's
CSI_ITEM_INSTANCE_PUB
Create Item Instance
Update Item Instance
Expire Item Instance
Get Item Instance
Get Item Instance Details
Copy Item Instance
CSI_II_RELATIONSHIPS_PUB
Create Relationship
Update Relationship
Expire Relationship
CSI_SYSTEMS_PUB
Create System
Update System
Expire System
Get System
HI Mahammad,
ReplyDeleteNice article. We are trying to provide linkages for existing instances and populating CSI_II_RELATIONSHIPS_INTERFACE table only for that purpose. How do you update an existing relation in the CSI_II_RELATIONSHIPS table through the API ?
Thanks
Sutirtha
sinhasutirtha@yahoo.com