Application Services Interface Reference > Predefined Application Service Interfaces >

Siebel Inventory Location


The Siebel Inventory Location ASI is a part of the Manage Service Inventory business process. This ASI facilitates the inbound data synchronization of inventory locations between the Siebel application and an external back-office system. It is used to synchronize inventory balances, inventory transactions, and product information across systems.

This ASI also synchronizes any sublevel relationships for an inventory location (as recorded in the S_INVLOC_REL table). It is assumed that all the inventory locations exist before the Inventory relationships are imported.

Figure 22 describes the Siebel Inventory Location ASI structure and Table 35 lists the field definitions.

Figure 22.  Siebel Inventory Location ASI

Click for full size image

Table 34 lists the integration components and user keys of the Siebel Inventory Location ASI.

Table 34.  Siebel Inventory Location Integration Components
Integration Component
XML Tag
User Keys
Inventory Level
InventoryLevel
  1. Name
  2. Availability, Status
Inventory Location
InventoryLocation
  1. Id
  2. Integration Id
  3. Name
Inventory Product
InventoryProduct
  1. Id
  2. Product Id
  3. Product Name
Inventory Relationship
InventoryRelationship
  1. Id
  2. Location Name, Order Priority, Relationship Type Code
  3. Location ID, Order Priority, Relationship Type

Table 35 lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.

Table 35.  Siebel Inventory Location ASI Fields
Name
XML Tag
Data Type
Length
Req.
Notes
Inventory Level
Availability
Availability
DTYPE_TEXT
30
N
 
Id
Id
DTYPE_ID
30
N
 
Name
Name
DTYPE_TEXT
100
N
 
Product Inventory Category ID
ProductInventoryCategoryID
DTYPE_ID
 
N
 
Product Inventory Location ID
ProductInventoryLocationID
DTYPE_ID
 
N
 
Quantity
Quantity
DTYPE_NUMBER
 
N
 
Status
Status
DTYPE_TEXT
30
N
 
operation
operation
DTYPE_TEXT
30
N
 
searchspec
searchspec
DTYPE_TEXT
250
N
 
Inventory Location
Bill Address ID
BillAddressID
DTYPE_ID
 
N
 
External Organization
ExternalOrganization
DTYPE_TEXT
100
N
 
External Organization ID
ExternalOrganizationID
DTYPE_ID
 
N
 
Id
Id
DTYPE_ID
30
N
 
Integration Id
IntegrationId
DTYPE_TEXT
30
N
 
Inventory Name
InventoryName
DTYPE_TEXT
100
N
 
Inventory Type
InventoryType
DTYPE_TEXT
30
N
 
Inventory Type ID
InventoryTypeID
DTYPE_ID
 
N
 
Location Description
LocationDescription
DTYPE_TEXT
250
N
 
Receive Address ID
ReceiveAddressID
DTYPE_ID
 
N
 
Ship Address ID
ShipAddressID
DTYPE_ID
 
N
 
operation
operation
DTYPE_TEXT
30
N
 
searchspec
searchspec
DTYPE_TEXT
250
N
 
Inventory Product
Id
Id
DTYPE_ID
30
N
 
Inventory Location ID
InventoryLocationID
DTYPE_ID
 
N
 
Product Description
ProductDescription
DTYPE_TEXT
255
N
 
Product ID
ProductID
DTYPE_ID
 
N
 
Product Name
ProductName
DTYPE_TEXT
100
N
 
Serialized
Serialized
DTYPE_TEXT
 
N
 
Unit of Measure
UnitofMeasure
DTYPE_TEXT
30
N
 
operation
operation
DTYPE_TEXT
30
N
 
searchspec
searchspec
DTYPE_TEXT
250
N
 
Inventory Relationship
Id
Id
DTYPE_ID
30
N
 
Location ID
LocationID
DTYPE_ID
 
N
 
Location Name
LocationName
DTYPE_TEXT
100
N
 
Order Priority
OrderPriority
DTYPE_TEXT
30
N
 
Relationship Type Code
RelationshipTypeCode
DTYPE_TEXT
30
N
 
operation
operation
DTYPE_TEXT
30
N
 
searchspec
searchspec
DTYPE_TEXT
250
N
 


 Application Services Interface Reference 
 Published: 15 May 2003