7Siebel Communications, Media, and Energy ASIs
Siebel Communications, Media, and Energy ASIs
This chapter provides a list of the prebuilt Siebel Communications, Media, and Energy ASIs that are provided with Siebel applications. You can use these ASIs to receive, send, or request data from other applications.
This chapter includes the following topics:
About Prebuilt Communications, Media, and Energy ASIs
The following table lists all the Communications, Media, and Energy ASIs and integration objects that Oracle provides. Each ASI is based on an integration object and can be used to integrate data for all the fields of that integration object.
Product Area |
ASI, Integration Object | Description |
---|---|---|
Order Management |
Siebel Order |
For details, see Siebel Order. |
Customer Life Cycle Management |
Siebel Account |
For details, see Siebel Account. |
Customer Life Cycle Management |
Siebel Contact |
ASI to facilitate the inbound and outbound transfer of contact data from the Siebel application. For details, see Siebel Contact. |
Customer Life Cycle Management |
Siebel CUT Address MSAG Service |
For details, see Siebel CUT Address MSAG Service. |
Billing Management |
Siebel Invoice |
For details, see Siebel Invoice. |
Billing Management |
Siebel Invoice Adjustment |
For details, see Siebel Invoice Adjustment. |
Billing Management |
CUT Payment Interface Integration Object |
For details, see CUT Payment Interface. |
Billing Management |
CUT Account Balance Interface - Request Integration Object |
For details, see CUT Account Balance Interface - Request. |
Billing Management |
CUT Account Balance Interface - Response Integration Object |
For details, see CUT Account Balance Interface - Response. |
Billing Management |
Siebel Meter Reading |
ASI to facilitate the inbound and outbound transfer of meter reading data from the Siebel application. For details, see Siebel Meter Reading. |
Billing Management |
Siebel Meter Usage Data |
ASI to facilitate the inbound and outbound transfer of meter usage data from the Siebel application. For details, see Siebel Meter Usage Data. |
Billing Management |
Siebel Payment |
For details, see Siebel Payment. |
Product and Pricing Administration |
Siebel Simple Product |
For details, see Siebel Simple Product. |
Product and Pricing Administration |
Siebel Price List |
ASI to enable the synchronization and update of a price list and the price list items. For details, see Siebel Price List. |
Product and Pricing Administration |
Siebel Asset |
ASI that associates a customer with a unique product. For details, see Siebel Assets. |
Trouble Ticketing Management |
Siebel Trouble Ticket |
ASI that results in the use of a trouble ticket in the Siebel application when an external application detects an outage or network fault. For details, see Siebel Trouble Ticket. |
Order Management
Order Management uses a single ASI, Siebel Order, to enable the submission and processing of orders and the update of order line items.
Siebel Order
The Siebel Order ASI enables customers to capture and validate orders so that they can successfully submit the orders to a fulfillment system.
The following image describes the Siebel Order ASI structure.

The following table lists the integration components and XML tags of this ASI.
Integration Component | XML Tag | User Keys |
---|---|---|
Attributes |
Attributes |
|
Line Items |
LineItems |
|
Orders |
Orders |
|
Payments |
Payments |
|
Promised Schedule Lines |
PromisedScheduleLines |
|
Related Organization |
RelatedOrganization |
|
Related Sales Rep |
RelatedSalesRep |
|
Related Shipment |
RelatedShipment |
|
Requested Schedule Lines |
RequestedScheduleLines |
|
Shipment Lines |
ShipmentItem |
|
Attributes Fields in Siebel Order ASI
The following table lists the Attributes fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Action Code |
ActionCode |
DTYPE_TEXT |
30 |
No |
Attribute Id |
AttributeId |
DTYPE_ID |
NA |
No |
Data Type |
DataType |
DTYPE_TEXT |
30 |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Hidden |
Hidden |
DTYPE_TEXT |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
LOV Type |
ListOfValueType |
DTYPE_TEXT |
30 |
No |
Name |
Name |
DTYPE_TEXT |
75 |
No |
Object Id |
ObjectId |
DTYPE_ID |
NA |
No |
Read Only |
ReadOnly |
DTYPE_TEXT |
NA |
No |
Required |
Required |
DTYPE_TEXT |
NA |
No |
Sequence |
Sequence |
DTYPE_NUMBER |
NA |
No |
Validation |
Validation |
DTYPE_TEXT |
250 |
No |
Value |
Value |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Line Items Fields in Siebel Order ASI
The following table lists the Line Items fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Action Code |
ActionCode |
DTYPE_TEXT |
30 |
No |
Asset Id |
AssetId |
DTYPE_ID |
NA |
No |
Asset Integration Id |
AssetIntegrationId |
DTYPE_TEXT |
30 |
No |
Asset Internal Integration Id |
AssetInternalIntegrationId |
DTYPE_TEXT |
30 |
No |
Asset Number |
AssetNumber |
DTYPE_TEXT |
NA |
No |
Available Date |
AvailableDate |
DTYPE_TEXT |
NA |
No |
Available Quantity |
AvailableQuantity |
DTYPE_NUMBER |
NA |
No |
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Base Price |
BasePrice |
DTYPE_TEXT |
NA |
No |
Billable Flag |
BillableFlag |
DTYPE_TEXT |
NA |
No |
Billing Account |
BillingAccount |
DTYPE_TEXT |
NA |
No |
Billing Account Id |
BillingAccountId |
DTYPE_ID |
NA |
No |
Billing Profile Id |
BillingProfileId |
DTYPE_TEXT |
NA |
No |
Cancelled Quantity |
CancelledQuantity |
DTYPE_NUMBER |
NA |
No |
Covered Product Unit Price |
CoveredProductUnitPrice |
DTYPE_TEXT |
NA |
No |
Delivery Status |
DeliveryStatus |
DTYPE_TEXT |
30 |
No |
Description |
Description |
DTYPE_TEXT |
NA |
No |
Destination Inventory Location |
DestinationInventoryLocation |
DTYPE_TEXT |
100 |
No |
Destination Inventory Location Id |
DestinationInventoryLocationId |
DTYPE_ID |
NA |
No |
Destination Inventory Location Integration Id |
DestinationInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Discount Amount |
DiscountAmount |
DTYPE_TEXT |
NA |
No |
Freight Amount |
FreightAmount |
DTYPE_TEXT |
NA |
No |
Hold Flag |
HoldFlag |
DTYPE_TEXT |
NA |
No |
Hold Reason |
HoldReason |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Integration Status |
IntegrationStatus |
DTYPE_TEXT |
30 |
No |
Integration Status As Of Date |
IntegrationStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Invoiced Quantity |
InvoicedQuantity |
DTYPE_NUMBER |
NA |
No |
Item Price |
ItemPrice |
DTYPE_TEXT |
NA |
No |
Line Integration Id |
LineIntegrationId |
DTYPE_TEXT |
30 |
No |
Line Number |
LineNumber |
DTYPE_NUMBER |
NA |
No |
Loaner Flag |
LoanerFlag |
DTYPE_TEXT |
NA |
No |
Net Price |
NetPrice |
DTYPE_TEXT |
NA |
No |
Note |
Note |
DTYPE_TEXT |
1,500 |
No |
Order Header Id |
OrderHeaderId |
DTYPE_ID |
NA |
No |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Package Name (Inbound) |
PackageNameInbound |
DTYPE_TEXT |
50 |
No |
Package Name (Outbound) |
PackageNameOutbound |
DTYPE_TEXT |
NA |
No |
Parent Order Item Id |
ParentOrderItemId |
DTYPE_ID |
NA |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
50 |
No |
Partial Ship |
PartialShip |
DTYPE_TEXT |
NA |
No |
Product |
Product |
DTYPE_TEXT |
100 |
No |
Product Global Identifier |
ProductGlobalIdentifier |
DTYPE_TEXT |
50 |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Product Primary Organization Id |
ProductPrimaryOrganizationId |
DTYPE_TEXT |
NA |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
NA |
No |
Requested Quantity |
RequestedQuantity |
DTYPE_NUMBER |
NA |
No |
Return To Account DUNS Number |
ReturnToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Return To Account Id |
ReturnToAccountId |
DTYPE_ID |
NA |
No |
Return To Account Integration Id |
ReturnToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Account Name |
ReturnToAccountName |
DTYPE_TEXT |
100 |
No |
Return To Account Site |
ReturnToAccountSite |
DTYPE_TEXT |
50 |
No |
Return To Address Id |
ReturnToAddressId |
DTYPE_ID |
NA |
No |
Return To Address Integration Id |
ReturnToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Contact Id |
ReturnToContactId |
DTYPE_ID |
NA |
No |
Return To Contact Integration Id |
ReturnToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To First Name |
ReturnToFirstName |
DTYPE_TEXT |
50 |
No |
Return To Last Name |
ReturnToLastName |
DTYPE_TEXT |
50 |
No |
Root Order Item Id |
RootOrderItemId |
DTYPE_ID |
NA |
No |
Sales Unit of Measure |
SalesUnitofMeasure |
DTYPE_TEXT |
30 |
No |
Service Account |
ServiceAccount |
DTYPE_TEXT |
NA |
No |
Service Account Id |
ServiceAccountId |
DTYPE_TEXT |
30 |
No |
Service Account Type |
ServiceAccountType |
DTYPE_TEXT |
NA |
No |
Service Id |
ServiceId |
DTYPE_TEXT |
NA |
No |
Service Instance Flag |
ServiceInstanceFlag |
DTYPE_TEXT |
NA |
No |
Service Point |
ServicePoint |
DTYPE_TEXT |
NA |
No |
Service Profile Id |
ServiceProfileId |
DTYPE_TEXT |
NA |
No |
Service Type |
ServiceType |
DTYPE_TEXT |
30 |
No |
Ship Date |
ShipDate |
DTYPE_DATETIME |
NA |
No |
Ship Instruction |
ShipInstruction |
DTYPE_TEXT |
250 |
No |
Ship Quantity |
ShipQuantity |
DTYPE_NUMBER |
NA |
No |
Ship To Account |
ShipToAccount |
DTYPE_TEXT |
100 |
No |
Ship To Account DUNS Number |
ShipToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Ship To Account Id |
ShipToAccountId |
DTYPE_ID |
NA |
No |
Ship To Account Integration Id |
ShipToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Account Site |
ShipToAccountSite |
DTYPE_TEXT |
50 |
No |
Ship To Address |
ShipToAddress |
DTYPE_TEXT |
50 |
No |
Ship To Address 2 |
ShipToAddress2 |
DTYPE_TEXT |
50 |
No |
Ship To Address Id |
ShipToAddressId |
DTYPE_ID |
NA |
No |
Ship To City |
ShipToCity |
DTYPE_TEXT |
30 |
No |
Ship To Contact - First Name |
ShipToContact-FirstName |
DTYPE_TEXT |
50 |
No |
Ship To Contact - Last Name |
ShipToContact-LastName |
DTYPE_TEXT |
50 |
No |
Ship To Contact Id |
ShipToContactId |
DTYPE_ID |
NA |
No |
Ship To Contact Integration Id |
ShipToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Country |
ShipToCountry |
DTYPE_TEXT |
15 |
No |
Ship To State |
ShipToState |
DTYPE_TEXT |
15 |
No |
Ship To Zip |
ShipToZip |
DTYPE_TEXT |
15 |
No |
Ship to Address Integration Id |
ShiptoAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Shipping Carrier |
ShippingCarrier |
DTYPE_TEXT |
30 |
No |
Shipping Charges |
ShippingCharges |
DTYPE_TEXT |
NA |
No |
Shipping Method |
ShippingMethod |
DTYPE_TEXT |
30 |
No |
Shipping Terms |
ShippingTerms |
DTYPE_TEXT |
30 |
No |
Single Source |
SingleSource |
DTYPE_TEXT |
NA |
No |
Smart Part Number |
SmartPartNumber |
DTYPE_TEXT |
250 |
No |
Source Inventory Loc Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Start Price |
StartPrice |
DTYPE_TEXT |
NA |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Status As Of Date |
StatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Tax Amount |
TaxAmount |
DTYPE_TEXT |
NA |
No |
Unit of Measure |
UnitofMeasure |
DTYPE_TEXT |
30 |
No |
Volume |
Volume |
DTYPE_NUMBER |
NA |
No |
Volume Unit of Measure |
VolumeUnitofMeasure |
DTYPE_TEXT |
30 |
No |
Weight |
Weight |
DTYPE_NUMBER |
NA |
No |
Weight Unit of Measure |
WeightUnitofMeasure |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Orders Fields in Siebel Order ASI
The following table lists the Orders fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account |
Account |
DTYPE_TEXT |
100 |
No |
Account DUNS Number |
AccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Account Site |
AccountSite |
DTYPE_TEXT |
100 |
No |
Active |
Active |
DTYPE_TEXT |
NA |
No |
Approved |
Approved |
DTYPE_TEXT |
NA |
No |
Approved By |
ApprovedBy |
DTYPE_TEXT |
NA |
No |
Approved By Date |
ApprovedByDate |
DTYPE_TEXT |
NA |
No |
Available Date |
AvailableDate |
DTYPE_TEXT |
NA |
No |
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Bill To - First Name |
BillTo-FirstName |
DTYPE_TEXT |
50 |
No |
Bill To - Last Name |
BillTo-LastName |
DTYPE_TEXT |
50 |
No |
Bill To Account |
BillToAccount |
DTYPE_TEXT |
100 |
No |
Bill To Account DUNS Number |
BillToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Bill To Account Id |
BillToAccountId |
DTYPE_ID |
NA |
No |
Bill To Account Integration Id |
BillToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Bill To Account Site |
BillToAccountSite |
DTYPE_TEXT |
50 |
No |
Bill To Address |
BillToAddress |
DTYPE_TEXT |
50 |
No |
Bill To Address 2 |
BillToAddress2 |
DTYPE_TEXT |
50 |
No |
Bill To Address Id |
BillToAddressId |
DTYPE_ID |
NA |
No |
Bill To Address Integration Id |
BillToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Bill To City |
BillToCity |
DTYPE_TEXT |
30 |
No |
Bill To Contact Id |
BillToContactId |
DTYPE_ID |
NA |
No |
Bill To Contact Integration Id |
BillToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Bill To Country |
BillToCountry |
DTYPE_TEXT |
15 |
No |
Bill To State |
BillToState |
DTYPE_TEXT |
30 |
No |
Bill To Zip |
BillToZip |
DTYPE_TEXT |
15 |
No |
Billable Flag |
BillableFlag |
DTYPE_TEXT |
NA |
No |
Billing Block |
BillingBlock |
DTYPE_TEXT |
30 |
No |
Campaign Id |
CampaignId |
DTYPE_ID |
NA |
No |
Campaign Integration Id |
CampaignIntegrationId |
DTYPE_TEXT |
30 |
No |
Campaign Name |
CampaignName |
DTYPE_TEXT |
100 |
No |
Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Carrier Priority |
CarrierPriority |
DTYPE_TEXT |
30 |
No |
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
No |
Contact Id |
ContactId |
DTYPE_ID |
NA |
No |
Contact Integration Id |
ContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
No |
Contract Id |
ContractId |
DTYPE_ID |
NA |
No |
Contract Integration Id |
ContractIntegrationId |
DTYPE_TEXT |
30 |
No |
Contract Name |
ContractName |
DTYPE_TEXT |
50 |
No |
Credit Status |
CreditStatus |
DTYPE_TEXT |
NA |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
Delivery Status |
DeliveryStatus |
DTYPE_TEXT |
30 |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Destination Inventory Id |
DestinationInventoryLocationId |
DTYPE_ID |
NA |
No |
Destination Inventory Location |
DestinationInventoryLocation |
DTYPE_TEXT |
100 |
No |
Destination Inventory Location Integration Id |
DestinationInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Discount Amount |
DiscountAmount |
DTYPE_TEXT |
NA |
No |
Entitlement Id |
EntitlementId |
DTYPE_ID |
NA |
No |
Entitlement Name |
EntitlementName |
DTYPE_TEXT |
50 |
No |
External Order Number |
ExternalOrderNumber |
DTYPE_TEXT |
NA |
No |
Hold Flag |
HoldFlag |
DTYPE_TEXT |
NA |
No |
Hold Reason |
HoldReason |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Integration Message |
IntegrationMessage |
DTYPE_TEXT |
2,000 |
No |
Integration Status |
IntegrationStatus |
DTYPE_TEXT |
30 |
No |
Integration Status As Of Date |
IntegrationStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Opportunity Id |
OpportunityId |
DTYPE_ID |
NA |
No |
Opportunity Integration Id |
OpportunityIntegrationId |
DTYPE_TEXT |
30 |
No |
Opportunity Name |
OpportunityName |
DTYPE_TEXT |
100 |
No |
Order Date |
OrderDate |
DTYPE_TEXT |
NA |
No |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Order Priority |
OrderPriority |
DTYPE_TEXT |
30 |
No |
Order Type |
OrderType |
DTYPE_TEXT |
30 |
No |
Order Type Id |
OrderTypeId |
DTYPE_ID |
NA |
No |
Organization DUNS Number |
OrganizationDUNSNumber |
DTYPE_TEXT |
9 |
No |
Parent Order Id |
ParentOrderId |
DTYPE_ID |
NA |
No |
Partial Ship |
PartialShip |
DTYPE_TEXT |
NA |
No |
Pay To Account |
PayToAccount |
DTYPE_TEXT |
100 |
No |
Pay To Account DUNS Number |
PayToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Pay To Account Id |
PayToAccountId |
DTYPE_ID |
NA |
No |
Pay To Account Integration Id |
PayToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Pay To Account Site |
PayToAccountSite |
DTYPE_TEXT |
50 |
No |
Pay To Address Id |
PayToAddressId |
DTYPE_ID |
NA |
No |
Pay To Address Integration Id |
PayToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Pay To Contact First Name |
PayToContactFirstName |
DTYPE_TEXT |
50 |
No |
Pay To Contact Id |
PayToContactId |
DTYPE_ID |
NA |
No |
Pay To Contact Integration Id |
PayToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Pay To Contact Last Name |
PayToContactLastName |
DTYPE_TEXT |
50 |
No |
Payment Term |
PaymentTerm |
DTYPE_TEXT |
50 |
No |
Payment Term Id |
PaymentTermId |
DTYPE_ID |
NA |
No |
Payment Term Integration Id |
PaymentTermIntegrationId |
DTYPE_TEXT |
30 |
No |
Price List |
PriceList |
DTYPE_TEXT |
50 |
No |
Price List Id |
PriceListId |
DTYPE_ID |
NA |
No |
Price List Integration Id |
PriceListIntegrationId |
DTYPE_TEXT |
30 |
No |
Pricing Date |
PricingDate |
DTYPE_TEXT |
NA |
No |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
Primary Organization Id |
PrimaryOrganizationId |
DTYPE_ID |
NA |
No |
Project Id |
ProjectId |
DTYPE_ID |
NA |
No |
Project Integration Id |
ProjectIntegrationId |
DTYPE_TEXT |
30 |
No |
Project Name |
ProjectName |
DTYPE_TEXT |
100 |
No |
Promotion Id |
PromotionId |
DTYPE_ID |
NA |
No |
Purchase Order Number |
PurchaseOrderNumber |
DTYPE_TEXT |
50 |
No |
Quote Id |
QuoteId |
DTYPE_ID |
NA |
No |
Quote Integration Id |
QuoteIntegrationId |
DTYPE_TEXT |
30 |
No |
Quote Number |
QuoteNumber |
DTYPE_TEXT |
30 |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
NA |
No |
Return Reason |
ReturnReason |
DTYPE_TEXT |
30 |
No |
Return To Account |
ReturnToAccount |
DTYPE_TEXT |
100 |
No |
Return To Account DUNS Number |
ReturnToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Return To Account Id |
ReturnToAccountId |
DTYPE_ID |
NA |
No |
Return To Account Integration Id |
ReturnToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Account Site |
ReturnToAccountSite |
DTYPE_TEXT |
50 |
No |
Return To Address Id |
ReturnToAddressId |
DTYPE_ID |
NA |
No |
Return To Address Integration Id |
ReturnToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Contact First Name |
ReturnToContactFirstName |
DTYPE_TEXT |
50 |
No |
Return To Contact Id |
ReturnToContactId |
DTYPE_ID |
NA |
No |
Return To Contact Integration Id |
ReturnToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Contact Last Name |
ReturnToContactLastName |
DTYPE_TEXT |
50 |
No |
Revision |
Revision |
DTYPE_NUMBER |
NA |
No |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
NA |
No |
Service Request Number |
ServiceRequestNumber |
DTYPE_TEXT |
NA |
No |
Ship Complete |
ShipComplete |
DTYPE_TEXT |
NA |
No |
Ship Instructions |
ShipInstructions |
DTYPE_TEXT |
250 |
No |
Ship To - First Name |
ShipTo-FirstName |
DTYPE_TEXT |
50 |
No |
Ship To - Last Name |
ShipTo-LastName |
DTYPE_TEXT |
50 |
No |
Ship To Account |
ShipToAccount |
DTYPE_TEXT |
100 |
No |
Ship To Account DUNS Number |
ShipToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Ship To Account Id |
ShipToAccountId |
DTYPE_ID |
NA |
No |
Ship To Account Integration Id |
ShipToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Account Site |
ShipToAccountSite |
DTYPE_TEXT |
50 |
No |
Ship To Address |
ShipToAddress |
DTYPE_TEXT |
50 |
No |
Ship To Address 2 |
ShipToAddress2 |
DTYPE_TEXT |
50 |
No |
Ship To Address Id |
ShipToAddressId |
DTYPE_ID |
NA |
No |
Ship To Address Integration Id |
ShipToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To City |
ShipToCity |
DTYPE_TEXT |
30 |
No |
Ship To Contact Id |
ShipToContactId |
DTYPE_ID |
NA |
No |
Ship To Contact Integration Id |
ShipToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Country |
ShipToCountry |
DTYPE_TEXT |
15 |
No |
Ship To State |
ShipToState |
DTYPE_TEXT |
30 |
No |
Ship To Zip |
ShipToZip |
DTYPE_TEXT |
15 |
No |
Shipping Charges |
ShippingCharges |
DTYPE_TEXT |
NA |
No |
Shipping Method |
ShippingMethod |
DTYPE_TEXT |
30 |
No |
Shipping Terms |
ShippingTerms |
DTYPE_TEXT |
30 |
No |
Shipping Terms Info |
FreightTermsInfo |
DTYPE_TEXT |
100 |
No |
Source Inventory Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Source Inventory Loc Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Status As Of Date |
StatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Submit Date |
SubmitDate |
DTYPE_TEXT |
NA |
No |
Tax Amount |
TaxAmount |
DTYPE_TEXT |
NA |
No |
Tax Exempt |
TaxExempt |
DTYPE_TEXT |
NA |
No |
Tax Exempt Code |
TaxExemptCode |
DTYPE_TEXT |
80 |
No |
Tax Exempt Id |
TaxExemptId |
DTYPE_TEXT |
30 |
No |
Tax Rate |
TaxRate |
DTYPE_NUMBER |
NA |
No |
Total Volume |
TotalVolume |
DTYPE_NUMBER |
NA |
No |
Total Volume UoM |
TotalVolumeUoM |
DTYPE_TEXT |
30 |
No |
Total Weight |
TotalWeight |
DTYPE_NUMBER |
NA |
No |
Total Weight UoM |
TotalWeightUoM |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Promised Schedule Lines Fields in Siebel Order ASI
The following table lists the Promised Schedule Lines fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Line Item Action Number |
LineItemActionNumber |
DTYPE_TEXT |
NA |
No |
Order Item Id |
OrderItemId |
DTYPE_ID |
NA |
No |
Order Item Integration Id |
OrderItemIntegrationId |
DTYPE_TEXT |
30 |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
50 |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Promised Date |
PromisedDate |
DTYPE_TEXT |
NA |
No |
Promised Quantity |
PromisedQuantity |
DTYPE_NUMBER |
NA |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Requested Schedule Lines Fields in Siebel Order ASI
The following table lists the Requested Schedule Lines fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Line Number |
LineNumber |
DTYPE_NUMBER |
NA |
No |
Order Item Id |
OrderItemId |
DTYPE_ID |
NA |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
NA |
No |
Requested Quantity |
RequestedQuantity |
DTYPE_NUMBER |
NA |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Payments Fields in Siebel Order ASI
The following table lists the Payments fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Number |
AccountNumber |
DTYPE_TEXT |
50 |
No |
Authorization Code |
AuthorizationCode |
DTYPE_TEXT |
40 |
No |
Bill To Address Id |
BillToAddressId |
DTYPE_ID |
NA |
No |
Bill To Address Integration Id |
BillToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Card Holder |
CardHolder |
DTYPE_TEXT |
50 |
No |
Credit Card Expiration Month |
CreditCardExpirationMonth |
DTYPE_TEXT |
30 |
No |
Credit Card Expiration Year |
CreditCardExpirationYear |
DTYPE_TEXT |
30 |
No |
Credit Check Message |
CreditCheckMessage |
DTYPE_TEXT |
250 |
No |
Credit Check Status |
CreditCheckStatus |
DTYPE_TEXT |
30 |
No |
Credit Check Status As Of Date |
CreditCheckStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Encryption Key |
EncryptionKey |
DTYPE_TEXT |
30 |
No |
Encryption Key Reference |
EncryptionKeyReference |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Issuing Bank Customer Id |
IssuingBankCustomerId |
DTYPE_TEXT |
30 |
No |
Issuing Bank Name |
IssuingBankName |
DTYPE_TEXT |
30 |
No |
Issuing Bank Phone Number |
IssuingBankPhoneNumber |
DTYPE_TEXT |
40 |
No |
Merchant Id |
MerchantId |
DTYPE_TEXT |
30 |
No |
Payment # |
Payment |
DTYPE_TEXT |
30 |
No |
Payment Account Id |
PaymentAccountId |
DTYPE_ID |
NA |
No |
Payment Account Integration Id |
PaymentAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Payment Account Name |
PaymentAccountName |
DTYPE_TEXT |
100 |
No |
Payment Account Site |
PaymentAccountSite |
DTYPE_TEXT |
50 |
No |
Payment Method |
PaymentMethod |
DTYPE_TEXT |
30 |
No |
Payment Status |
PaymentStatus |
DTYPE_TEXT |
30 |
No |
Payment Status As Of Date |
PaymentStatusAsOfDate |
DTYPE_DATETIME |
NA |
No |
Payment Type |
PaymentType |
DTYPE_TEXT |
30 |
No |
Transaction Amount |
TransactionAmount |
DTYPE_TEXT |
NA |
No |
Transaction Id |
TransactionId |
DTYPE_TEXT |
NA |
No |
Transaction Time |
TransactionTime |
DTYPE_TEXT |
NA |
No |
Verification Number |
VerificationNumber |
DTYPE_TEXT |
10 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Related Organization Fields in Siebel Order ASI
The following table lists the Related Organization fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
NA |
No |
Related Sales Rep Fields in Siebel Order ASI
The following table lists the Related Sales Rep fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Login |
Login |
DTYPE_TEXT |
50 |
No |
Position |
Position |
DTYPE_TEXT |
50 |
No |
Related Shipment Fields in Siebel Order ASI
The following table lists the Related Shipments fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Destination Inventory Location Id |
DestinationInventoryLocationId |
DTYPE_ID |
15 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Shipment Number |
ShipmentNumber |
DTYPE_TEXT |
30 |
No |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
15 |
No |
Waybill Number |
WaybillNumber |
DTYPE_TEXT |
50 |
No |
Shipment Lines Fields in Siebel Order ASI
The following table lists the Shipment Lines fields and their attributes in Siebel Order ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Confirmed Qty |
ConfirmedQty |
DTPYE_NUMBER |
NA |
No |
Delivery Date |
DeliveryDate |
DTYPE_DATETIME |
NA |
No |
Delivery Qty |
DeliveryQty |
DTPYE_NUMBER |
NA |
No |
Id |
Id |
DTYPE_ID |
NA |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
NA |
No |
Order Line Id |
OrderLineId |
DTYPE_ID |
NA |
No |
Shipment Date |
ShipmentDate |
DTYPE_DATETIME |
NA |
No |
Shipment Line Number |
ShipmentLineNumber |
DTYPE_TEXT |
NA |
No |
Shipment Qty |
ShipmentQty |
DTPYE_NUMBER |
NA |
No |
Customer Lifecycle Management
The Siebel Account ASI supports the Customer Lifecycle Management process. This process enables the user to create and validate accounts and to perform other account-related tasks, such as credit approval.
Siebel Account
The Siebel Account ASI is used for business processes related to customer information management. This ASI facilitates inbound and outbound data synchronization between Siebel applications and external systems.
The following image describes the Siebel Account ASI structure.

The following table lists the integration components and XML tags of this ASI.
Integration Component | XML Tag | User Keys |
---|---|---|
Account |
Account |
|
Business Address |
BusinessAddress |
|
Com Financial Profile |
FinancialProfile |
|
Com Invoice Profile |
BillingProfile |
|
Credit Profile |
CreditProfile |
|
Related Contact |
RelatedContact |
|
Related Industry |
RelatedIndustry |
|
Related Organization |
RelatedOrganization |
|
Related Sales Rep |
RelatedSalesRep |
|
Account Fields in Siebel Account ASI
The following table lists the Account fields and their attributes in the Siebel Account ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
30 |
No |
Account Status |
AccountStatus |
DTYPE_TEXT |
24 |
No |
Alias |
Alias |
DTYPE_TEXT |
50 |
No |
Assignment Area Code |
AssignmentAreaCode |
DTYPE_TEXT |
5 |
No |
Assignment Country Code |
AssignmentCountryCode |
DTYPE_TEXT |
5 |
No |
Competitor Flag |
CompetitorFlag |
DTYPE_TEXT |
NA |
No |
Credit Auto Approval Limit |
CreditAutoApprovalLimit |
DTYPE_NUMBER |
NA |
No |
Credit Status Date |
CreditStatusDate |
DTYPE_TEXT |
NA |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Domestic Ultimate DUNS |
DomesticUltimateDUNS |
DTYPE_TEXT |
15 |
No |
Expertise |
Expertise |
DTYPE_TEXT |
30 |
No |
Global Ultimate DUNS |
GlobalUltimateDUNS |
DTYPE_TEXT |
15 |
No |
Home Page |
HomePage |
DTYPE_TEXT |
100 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Language Code |
LanguageCode |
DTYPE_ID |
15 |
No |
Location |
Location |
DTYPE_TEXT |
50 |
No |
Main Fax Number |
MainFaxNumber |
DTYPE_TEXT |
NA |
No |
Main Phone Number |
MainPhoneNumber |
DTYPE_TEXT |
NA |
No |
Master Account Id |
MasterAccountId |
DTYPE_ID |
NA |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Number of Employees |
NumberofEmployees |
DTYPE_NUMBER |
NA |
No |
PO Approved Flag |
POApprovedFlag |
DTYPE_TEXT |
NA |
No |
PO Auto Approval Currency Code |
POAutoApprovalCurrencyCode |
DTYPE_TEXT |
20 |
No |
PO Auto Approval Date |
POAutoApprovalDate |
DTYPE_DATETIME |
NA |
No |
PO Auto Approval Limit |
POAutoApprovalLimit |
DTYPE_TEXT |
NA |
No |
Parent Account Id |
ParentAccountId |
DTYPE_ID |
NA |
No |
Parent Account Integration Id |
ParentAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Parent Account Location |
ParentAccountLocation |
DTYPE_TEXT |
50 |
No |
Parent Account Name |
ParentAccountName |
DTYPE_TEXT |
100 |
No |
Parent HQ DUNS |
ParentHQDUNS |
DTYPE_TEXT |
15 |
No |
Partner Flag |
PartnerFlag |
DTYPE_TEXT |
NA |
No |
Price List |
PriceList |
DTYPE_TEXT |
NA |
No |
Price List Id |
PriceListId |
DTYPE_ID |
NA |
No |
Price List Integration Id |
PriceListIntegrationId |
DTYPE_TEXT |
30 |
No |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
Skip Credit Check |
SkipCreditCheck |
DTYPE_TEXT |
NA |
No |
Type |
Type |
DTYPE_TEXT |
255 |
No |
VAT registration number |
VATregistrationnumber |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Business Address Fields in Siebel Account ASI
The following table describes Business Address fields and their attributes in Siebel Account ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Address Id |
AddressId |
DTYPE_ID |
30 |
No |
Address Integration Id |
AddressIntegrationId |
DTYPE_TEXT |
30 |
No |
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
County |
County |
DTYPE_TEXT |
50 |
No |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
Province |
Province |
DTYPE_TEXT |
50 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
Street Address 2 |
StreetAddress2 |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Com Financial Profile Fields in Siebel Account ASI
This table describes the Com Financial Profile fields and their attributes in the Siebel Account ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Account Type |
AccountType |
DTYPE_TEXT |
30 |
No |
Annual Income |
AnnualIncome |
DTYPE_TEXT |
NA |
No |
Bank Account Name |
BankAccountName |
DTYPE_TEXT |
100 |
No |
Bank Account Number |
BankAccountNumber |
DTYPE_TEXT |
50 |
No |
Bank Branch |
BankBranch |
DTYPE_TEXT |
100 |
No |
Bank Name |
BankName |
DTYPE_TEXT |
100 |
No |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
No |
Contact Id |
ContactId |
DTYPE_ID |
NA |
No |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
No |
Corporate Number |
CorporateNumber |
DTYPE_TEXT |
30 |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Credit Agency |
CreditAgency |
DTYPE_TEXT |
30 |
No |
Credit Card Expire Date |
CreditCardExpireDate |
DTYPE_DATETIME |
NA |
No |
Credit Card Number |
CreditCardNumber |
DTYPE_TEXT |
30 |
No |
Credit Card Type |
CreditCardType |
DTYPE_TEXT |
30 |
No |
Credit Score |
CreditScore2 |
DTYPE_NUMBER |
NA |
No |
Credit Update Date |
CreditUpdateDate |
DTYPE_DATETIME |
NA |
No |
Credit Updated By |
CreditUpdatedBy |
DTYPE_ID |
NA |
No |
Currency Code |
CurrencyCode2 |
DTYPE_TEXT |
20 |
No |
Current Address Id |
CurrentAddressId |
DTYPE_ID |
NA |
No |
Current City |
CurrentCity |
DTYPE_TEXT |
50 |
No |
Current Country |
CurrentCountry |
DTYPE_TEXT |
30 |
No |
Current Hire Date |
CurrentHireDate |
DTYPE_DATETIME |
NA |
No |
Current Postal Code |
CurrentPostalCode |
DTYPE_TEXT |
30 |
No |
Current State |
CurrentState |
DTYPE_TEXT |
10 |
No |
Current Street Address |
CurrentStreetAddress |
DTYPE_TEXT |
200 |
No |
D B Identifier |
DBIdentifier |
DTYPE_TEXT |
30 |
No |
Employer Id |
EmployerId |
DTYPE_ID |
NA |
No |
Employer Name |
EmployerName |
DTYPE_TEXT |
100 |
No |
Exchange Date |
ExchangeDate |
DTYPE_DATETIME |
NA |
No |
Former Address Id |
FormerAddressId |
DTYPE_ID |
NA |
No |
Former City |
FormerCity |
DTYPE_TEXT |
50 |
No |
Former Country |
FormerCountry |
DTYPE_TEXT |
30 |
No |
Former Postal Code |
FormerPostalCode |
DTYPE_TEXT |
30 |
No |
Former State |
FormerState |
DTYPE_TEXT |
10 |
No |
Former Street Address |
FormerStreetAddress |
DTYPE_TEXT |
200 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Id Type |
IdType |
DTYPE_TEXT |
30 |
No |
Identifier |
Identifier |
DTYPE_TEXT |
30 |
No |
Legal Name |
LegalName |
DTYPE_TEXT |
100 |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Own or Rent |
OwnorRent |
DTYPE_TEXT |
30 |
No |
Previous Employer Id |
PreviousEmployerId |
DTYPE_ID |
NA |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Tax Id |
TaxId2 |
DTYPE_TEXT |
30 |
No |
Tax Profile Cd |
TaxProfileCd |
DTYPE_TEXT |
30 |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Com Invoice Profile Fields in Siebel Account ASI
The following table lists the Com Invoice Profile fields and their attributes in Siebel Account ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Address Id |
AddressId2 |
DTYPE_ID |
NA |
No |
Bank Account Name |
BankAccountName2 |
DTYPE_TEXT |
NA |
No |
Bank Account Number |
BankAccountNumber2 |
DTYPE_TEXT |
NA |
No |
Bank Account Type |
BankAccountType |
DTYPE_TEXT |
30 |
No |
Bank Authorization Flag |
BankAuthorizationflag |
DTYPE_TEXT |
NA |
No |
Bank Branch |
BankBranch2 |
DTYPE_TEXT |
NA |
No |
Bank Language Code |
BankLanguageCode |
DTYPE_TEXT |
5 |
No |
Bank Language Id |
BankLanguageId |
DTYPE_TEXT |
5 |
No |
Bank Name |
BankName2 |
DTYPE_TEXT |
NA |
No |
Bill Average |
BillAverage |
DTYPE_TEXT |
NA |
No |
Bill Cycle |
BillCycle |
DTYPE_NUMBER |
NA |
No |
Bill Cycle Day |
BillCycleDay |
DTYPE_NUMBER |
NA |
No |
Bill Frequency |
BillFrequency |
DTYPE_TEXT |
NA |
No |
Bill Sequence |
BillSequence |
DTYPE_NUMBER |
NA |
No |
Bill Source |
BillSource |
DTYPE_TEXT |
30 |
No |
Bill Type |
BillType |
DTYPE_TEXT |
NA |
No |
Bill Vendor Id |
BillVendorId |
DTYPE_ID |
NA |
No |
Budget Billing Flag |
BudgetBillingFlag |
DTYPE_TEXT |
NA |
No |
CPNI Date |
CPNIDate |
DTYPE_DATETIME |
NA |
No |
CPNI Flag |
CPNIFlag |
DTYPE_TEXT |
NA |
No |
Collections Flag |
CollectionsFlag |
DTYPE_TEXT |
NA |
No |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
No |
Contact Id |
ContactId |
DTYPE_ID |
NA |
No |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Credit Card Block Flag |
CreditCardBlockFlag |
DTYPE_TEXT |
NA |
No |
Credit Card Block Reason |
CreditCardBlockReason |
DTYPE_TEXT |
30 |
No |
Credit Card Category |
CreditCardCategory |
DTYPE_TEXT |
30 |
No |
Credit Card Expiration Date |
CreditCardExpirationDate |
DTYPE_DATETIME |
NA |
No |
Credit Card Name |
CreditCardName |
DTYPE_TEXT |
NA |
No |
Credit Card Number |
CreditCardNumber2 |
DTYPE_TEXT |
NA |
No |
Credit Card Type |
CreditCardType2 |
DTYPE_TEXT |
NA |
No |
Currency Type |
CurrencyType |
DTYPE_TEXT |
20 |
No |
Days To Cash |
DaysToCash |
DTYPE_NUMBER |
NA |
No |
Email Bill To |
EmailBillTo |
DTYPE_TEXT |
100 |
No |
External Billing Account Number |
ExternalBillingAccountNumber |
DTYPE_TEXT |
30 |
No |
Extra Copies |
ExtraCopies |
DTYPE_NUMBER |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Interest at Invoice Flag |
InterestatInvoiceFlag |
DTYPE_TEXT |
NA |
No |
Last Bill Amount |
LastBillAmount |
DTYPE_TEXT |
NA |
No |
Last Bill Date |
LastBillDate |
DTYPE_DATETIME |
NA |
No |
Media Type |
MediaType |
DTYPE_TEXT |
30 |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
No Pay Form Flag |
NoPayFormFlag |
DTYPE_TEXT |
NA |
No |
Number of Manual Invoices |
NumberofManualInvoices |
DTYPE_NUMBER |
NA |
No |
Payment Method |
PaymentMethod |
DTYPE_TEXT |
30 |
No |
Reason for Manual Outsource |
ReasonforManualOutsource |
DTYPE_TEXT |
30 |
No |
Repeat Debtor Flag |
RepeatDebtorFlag |
DTYPE_TEXT |
NA |
No |
Row Id |
RowId |
DTYPE_ID |
NA |
No |
Standing Order Flag |
StandingOrderFlag |
DTYPE_TEXT |
NA |
No |
Statement Flag |
StatementFlag |
DTYPE_TEXT |
NA |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
Yearly Advance Payment Flag |
YearlyAdvancePaymentFlag |
DTYPE_TEXT |
NA |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Credit Profile Fields in Siebel Account ASI
The following table list the Credit Profile fields and their attributes in Siebel Account ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Credit Area |
CreditArea |
DTYPE_TEXT |
30 |
No |
Credit Available |
CreditAvailable |
DTYPE_NUMBER |
NA |
No |
Credit Currency Code |
CreditCurrencyCode |
DTYPE_TEXT |
20 |
No |
Credit Limit |
CreditLimit |
DTYPE_NUMBER |
NA |
No |
Credit Profile Id |
CreditProfileId |
DTYPE_ID |
30 |
No |
Credit Profile Integration Id |
CreditProfileIntegrationId |
DTYPE_TEXT |
30 |
No |
Credit Reporting Group |
CreditReportingGroup |
DTYPE_TEXT |
50 |
No |
Credit Status Code |
CreditStatusCode |
DTYPE_TEXT |
30 |
No |
Credit Status Message |
CreditStatusMessage |
DTYPE_TEXT |
250 |
No |
Credit Used |
CreditUsed |
DTYPE_NUMBER |
NA |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Risk Category Code |
RiskCategoryCode |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Related Industry Fields in Siebel Account ASI
The following table lists the Related Industry fields and their attributes in Siebel Account ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Industry |
Industry |
DTYPE_TEXT |
50 |
No |
Industry Id |
IndustryId |
DTYPE_ID |
30 |
No |
Industry Integration Id |
IndustryIntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
SIC Code |
SICCode |
DTYPE_TEXT |
30 |
No |
Related Sales Rep Fields in Siebel Account ASI
The following table lists the Related Sales Rep fields and their attributes in the Siebel Account ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Division |
Division |
DTYPE_TEXT |
255 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Login |
Login |
DTYPE_TEXT |
50 |
No |
Position |
Position |
DTYPE_TEXT |
50 |
No |
Position Id |
PositionId |
DTYPE_ID |
30 |
No |
Position Integration Id |
PositionIntegrationId |
DTYPE_TEXT |
30 |
No |
Related Contact Fields in Siebel Account ASI
The following table describes the Related Contact fields and their attributes in Siebel Account ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Assistant Phone # |
AssistantPhone |
DTYPE_TEXT |
NA |
No |
Cellular Phone # |
CellularPhone |
DTYPE_TEXT |
NA |
No |
Contact Id |
ContactId |
DTYPE_ID |
30 |
No |
Contact Integration Id |
ContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
Fax Phone # |
FaxPhone |
DTYPE_TEXT |
NA |
No |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
No |
Last Name |
LastName |
DTYPE_TEXT |
50 |
No |
M/F |
MF |
DTYPE_TEXT |
255 |
No |
M/M |
MM |
DTYPE_TEXT |
15 |
No |
Person UId |
PersonUId |
DTYPE_TEXT |
100 |
No |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
Work Phone # |
WorkPhone |
DTYPE_TEXT |
NA |
No |
Related Organization Fields in Siebel Account ASI
The following table lists the Related Organization fields and their attributes in Siebel Account ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
NA |
No |
Organization Integration Id |
OrganizationIntegrationId |
DTYPE_TEXT |
30 |
No |
Billing Management
One ASI and four integration objects are associated with eight Billing Management Business Integration Processes: Siebel Invoice ASI, CUT Payment Interface Integration Object, and a request and response set for CUT Account Balance Interface Integration Object.
Siebel Invoice
The Siebel Invoice ASI is used by multiple Business Integration Processes, including Sync Invoice Header, Query Invoice Details, and Request Duplicate Invoice. The ASI has four types of fields associated with it, a different subset of which is used by each calling Business Integration Process to access information in an external billing system.
The following image describes the Siebel Invoice ASI structure.

The following table lists the integration components and XML tags of this ASI.
Integration Component | XML Tag | User Keys |
---|---|---|
CME Invoice Details |
CmeInvoiceDetails |
No user keys. |
CME Invoice Duplicate Request |
CmeInvoiceDuplicateRequest |
No user keys. |
Invoice |
Invoice |
|
Invoice Line Items |
InvoiceLineItems |
|
Invoice Fields in Siebel Invoice ASI
The following table lists the Invoice fields and their attributes in Siebel Invoice ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Account Location |
AccountLocation |
DTYPE_TEXT |
30 |
No |
Account Name |
AccountName |
DTYPE_TEXT |
50 |
No |
Account Organization Name |
AccountOrganizationName |
DTYPE_TEXT |
100 |
No |
Activity Id |
ActivityId |
DTYPE_ID |
NA |
No |
Activity User Defined Unique Id |
ActivityUserDefinedUniqueId |
DTYPE_TEXT |
30 |
No |
Amount Paid |
AmountPaid |
DTYPE_TEXT |
NA |
No |
Balance Forward |
BalanceForward |
DTYPE_TEXT |
NA |
No |
Bill To Person Id |
BillToPersonId |
DTYPE_TEXT |
30 |
No |
Billing End Date |
BillingEndDate |
DTYPE_TEXT |
NA |
No |
Billing Start Date |
BillingStartDate |
DTYPE_TEXT |
NA |
No |
Contract Id |
ContractId |
DTYPE_ID |
NA |
No |
Contract Integration Id |
ContractIntegrationId |
DTYPE_TEXT |
30 |
No |
Contract Name |
ContractName |
DTYPE_TEXT |
50 |
No |
Contract Organization Name |
ContractOrganizationName |
DTYPE_TEXT |
100 |
No |
Contract Revision Number |
ContractRevisionNumber |
DTYPE_NUMBER |
NA |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
Delinquent Flag |
DelinquentFlag |
DTYPE_TEXT |
NA |
No |
Document Date |
DocumentDate |
DTYPE_TEXT |
NA |
No |
Document Description |
DocumentDescription |
DTYPE_TEXT |
250 |
No |
Document Number |
DocumentNumber |
DTYPE_TEXT |
50 |
No |
Document Period Id |
DocumentPeriodId |
DTYPE_ID |
NA |
No |
Document Period Name |
DocumentPeriodName |
DTYPE_TEXT |
50 |
No |
Document Period Organization Name |
DocumentPeriodOrganizationName |
DTYPE_TEXT |
100 |
No |
Document Revision Number |
DocumentRevisionNumber |
DTYPE_NUMBER |
NA |
No |
Document Status |
DocumentStatus |
DTYPE_TEXT |
30 |
No |
Document Sub Type |
DocumentSubType |
DTYPE_TEXT |
30 |
No |
Document Type |
DocumentType |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Order Id |
OrderId |
DTYPE_ID |
NA |
No |
Order Integration Id |
OrderIntegrationId |
DTYPE_TEXT |
30 |
No |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Order Organization Name |
OrderOrganizationName |
DTYPE_TEXT |
100 |
No |
Order Type |
OrderType |
DTYPE_TEXT |
50 |
No |
Payment Term |
PaymentTerm |
DTYPE_TEXT |
50 |
No |
Payment Term Due Date |
PaymentTermDueDate |
DTYPE_DATETIME |
NA |
No |
Payment Term Id |
PaymentTermId |
DTYPE_ID |
NA |
No |
Payment Term Net Days |
PaymentTermNetDays |
DTYPE_NUMBER |
NA |
No |
Project Id |
ProjectId |
DTYPE_ID |
NA |
No |
Project Integration Id |
ProjectIntegrationId |
DTYPE_TEXT |
30 |
No |
Project Number |
ProjectNumber |
DTYPE_TEXT |
30 |
No |
Project Organization Name |
ProjectOrganizationName |
DTYPE_TEXT |
100 |
No |
STORED Adjustment Amount |
STOREDAdjustmentAmount |
DTYPE_TEXT |
NA |
No |
STORED Discount Amount |
STOREDDiscountAmount |
DTYPE_TEXT |
NA |
No |
STORED Gross Amount |
STOREDGrossAmount |
DTYPE_TEXT |
NA |
No |
STORED Surcharge Amount |
STOREDSurchargeAmount |
DTYPE_TEXT |
NA |
No |
STORED Tax Amount |
STOREDTaxAmount |
DTYPE_TEXT |
NA |
No |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
NA |
No |
Service Request Number |
ServiceRequestNumber |
DTYPE_TEXT |
64 |
No |
Service Request Organization Name |
ServiceRequestOrganizationName |
DTYPE_TEXT |
100 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Total Amount |
TotalAmount |
DTYPE_TEXT |
NA |
No |
Type Code |
TypeCode |
DTYPE_TEXT |
NA |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Invoice Line Items Fields in Siebel Invoice ASI
The following table lists Invoice Line Items fields and their attributes in Siebel Invoice ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Activity Id |
ActivityId |
DTYPE_ID |
NA |
No |
Activity User Defined Unique Id |
ActivityUserDefinedUniqueId |
DTYPE_TEXT |
30 |
No |
Contract Id |
ContractId |
DTYPE_ID |
NA |
No |
Contract Integration Id |
ContractIntegrationId |
DTYPE_TEXT |
30 |
No |
Contract Line Id |
ContractLineId |
DTYPE_ID |
NA |
No |
Contract Name |
ContractName |
DTYPE_TEXT |
50 |
No |
Contract Organization Name |
ContractOrganizationName |
DTYPE_TEXT |
100 |
No |
Contract Revision Number |
ContractRevisionNumber |
DTYPE_NUMBER |
NA |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
Description |
Description |
DTYPE_TEXT |
250 |
No |
Discount Amount |
DiscountAmount |
DTYPE_TEXT |
NA |
No |
Gross Amount |
GrossAmount |
DTYPE_TEXT |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Line Number |
LineNumber |
DTYPE_NUMBER |
NA |
No |
Line Quantity |
LineQuantity |
DTYPE_NUMBER |
NA |
No |
Line Type |
LineType |
DTYPE_TEXT |
30 |
No |
Order Id |
OrderId |
DTYPE_ID |
NA |
No |
Order Integration Id |
OrderIntegrationId |
DTYPE_TEXT |
30 |
No |
Order Item Id |
OrderItemId |
DTYPE_ID |
NA |
No |
Order Item Integration Id |
OrderItemIntegrationId |
DTYPE_TEXT |
30 |
No |
Order Line Number |
OrderLineNumber |
DTYPE_NUMBER |
NA |
No |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Order Organization Name |
OrderOrganizationName |
DTYPE_TEXT |
100 |
No |
Order Type |
OrderType |
DTYPE_TEXT |
50 |
No |
Person Id |
PersonId |
DTYPE_ID |
NA |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Product Organization Name |
ProductOrganizationName |
DTYPE_TEXT |
100 |
No |
Product Vendor Organization Name |
ProductVendorOrganizationName |
DTYPE_TEXT |
100 |
No |
Project Id |
ProjectId |
DTYPE_ID |
NA |
No |
Project Integration Id |
ProjectIntegrationId |
DTYPE_TEXT |
30 |
No |
Project Item Id |
ProjectItemId |
DTYPE_ID |
NA |
No |
Project Item Number |
ProjectItemNumber |
DTYPE_TEXT |
30 |
No |
Project Number |
ProjectNumber |
DTYPE_TEXT |
30 |
No |
Project Organization Name |
ProjectOrganizationName |
DTYPE_TEXT |
100 |
No |
Project Resource Id |
ProjectResourceId |
DTYPE_ID |
NA |
No |
Project Resource Number |
ProjectResourceNumber |
DTYPE_TEXT |
30 |
No |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
NA |
No |
Service Request Number |
ServiceRequestNumber |
DTYPE_TEXT |
64 |
No |
Service Request Organization Name |
ServiceRequestOrganizationName |
DTYPE_TEXT |
100 |
No |
Surcharge Amount |
SurchargeAmount |
DTYPE_TEXT |
NA |
No |
Tax Amount |
TaxAmount |
DTYPE_TEXT |
NA |
No |
Unit of Measure |
UnitofMeasure |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
CME Invoice Details Fields in Siebel Invoice ASI
The following table lists the CME Invoice Details fields and their attributes in Siebel Invoice ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Amount |
Amount2 |
DTYPE_TEXT |
NA |
No |
Call Type |
CallType |
DTYPE_TEXT |
NA |
No |
Currency |
Currency |
DTYPE_TEXT |
NA |
No |
Date/Time |
DateTime |
DTYPE_TEXT |
NA |
No |
Duration |
Duration |
DTYPE_TEXT |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Invoice Header Id |
InvoiceHeaderId |
DTYPE_TEXT |
NA |
No |
Line Number |
LineNumber |
DTYPE_TEXT |
NA |
No |
Location |
Location |
DTYPE_TEXT |
NA |
No |
Number Called |
NumberCalled |
DTYPE_TEXT |
NA |
No |
Originating Number |
OriginatingNumber |
DTYPE_TEXT |
NA |
No |
Period |
Period |
DTYPE_TEXT |
NA |
No |
Rate |
Rate |
DTYPE_TEXT |
NA |
No |
Segment |
Segment |
DTYPE_TEXT |
NA |
No |
Service |
Service |
DTYPE_TEXT |
NA |
No |
Vid |
Vid |
DTYPE_ID |
NA |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
CME Invoice Duplicate Request Fields in Siebel Invoice ASI
The following table lists the CME Invoice Duplicate Request fields and their attributes in Siebel Invoice ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Copies |
Copies |
DTYPE_NUMBER |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Siebel Invoice Adjustment
The Siebel Invoice Adjustment ASI is used to modify invoices.
The following image describes the structure of the Siebel Invoice Adjustment ASI.

The following table lists the integration components of this ASI.
Integration Component | XML Tag | User Keys |
---|---|---|
FS Invoice Adjustment |
Adjustment |
|
FS Invoice Adjustment Items |
AdjustmentItem |
|
The following table lists the FS Invoice Adjustment fields and their attributes in Siebel Invoice Adjustment ASI.
Siebel FS Invoice Adjustment Fields in Siebel Invoice Adjustment ASI
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Account Name |
AccountName |
DTYPE_TEXT |
100 |
No |
Adjustment ID |
AdjustmentID |
DTYPE_ID |
NA |
No |
Alert Id |
AlertId |
DTYPE_ID |
NA |
No |
Approved Amt |
ApprovedAmt |
DTYPE_TEXT |
NA |
No |
Approved Currency |
ApprovedCurrency |
DTYPE_TEXT |
20 |
No |
Approved Date |
ApprovedDate |
DTYPE_TEXT |
NA |
No |
Approved Exchange Date |
ApprovedExchangeDate |
DTYPE_DATETIME |
NA |
No |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Created By Login |
CreatedByLogin |
DTYPE_TEXT |
50 |
No |
Customer Decision |
CustomerDecision |
DTYPE_TEXT |
30 |
No |
Customer Decision Date |
CustomerDecisionDate |
DTYPE_DATETIME |
NA |
No |
Decision Description |
DecisionDescription |
DTYPE_TEXT |
250 |
No |
Description |
Description |
DTYPE_TEXT |
250 |
No |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Invoice ID |
InvoiceID |
DTYPE_ID |
NA |
No |
Invoice Line Item ID |
InvoiceLineItemID |
DTYPE_ID |
NA |
No |
Invoice Number |
InvoiceNumber |
DTYPE_TEXT |
50 |
No |
Invoice Number No Constrain |
InvoiceNumberNoConstrain |
DTYPE_TEXT |
50 |
No |
Item Line Number |
ItemLineNumber |
DTYPE_NUMBER |
NA |
No |
Last Name |
LastName |
DTYPE_TEXT |
50 |
No |
Line Number |
LineNumber |
DTYPE_NUMBER |
NA |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Reason For Request |
ReasonForRequest |
DTYPE_TEXT |
30 |
No |
Request Amt |
RequestAmt |
DTYPE_TEXT |
NA |
No |
Request Currency |
RequestCurrency |
DTYPE_TEXT |
20 |
No |
Request Date |
RequestDate |
DTYPE_TEXT |
NA |
No |
Request Exchange Date |
RequestExchangeDate |
DTYPE_DATETIME |
NA |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
FS Invoice Adjustment Items Fields in Siebel Invoice Adjustment ASI
The following table lists FS Invoice Adjustment Items fields and their attributes in Siebel Invoice Adjustment ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Approved Amt |
ApprovedAmt |
DTYPE_TEXT |
NA |
No |
Approved Currency Code |
ApprovedCurrencyCode |
DTYPE_TEXT |
20 |
No |
Approved Description |
ApprovedDescription |
DTYPE_TEXT |
250 |
No |
Approved Exchange Date |
ApprovedExchangeDate |
DTYPE_DATETIME |
NA |
No |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Description |
Description |
DTYPE_TEXT |
250 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Invoice Adj ID |
InvoiceAdjID |
DTYPE_ID |
NA |
No |
Invoice Item ID |
InvoiceItemID |
DTYPE_ID |
NA |
No |
Item Adjustment ID |
ItemAdjustmentID |
DTYPE_ID |
NA |
No |
Line Number |
LineNumber |
DTYPE_NUMBER |
NA |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Original Amount |
OriginalAmount |
DTYPE_TEXT |
NA |
No |
Request Amt |
RequestAmt |
DTYPE_TEXT |
NA |
No |
Request Currency |
RequestCurrency |
DTYPE_TEXT |
20 |
No |
Request Date |
RequestDate |
DTYPE_TEXT |
NA |
No |
Request Exchange Date |
RequestExchangeDate |
DTYPE_DATETIME |
NA |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
CUT Payment Interface
The CUT Payment Interface ASI integration object is used by both the CME Sync Payment and CME Update Payment Status Business Integration Processes to share information with external systems about payments made through the Siebel application.
The following image describes the CUT Payment Interface integration object structure.

The following table lists the integration components and XML tags.
Integration Component | XML Tag | User Keys |
---|---|---|
Action |
ListOfCutPaymentInterface |
|
SIA Payment |
SiaPayment |
|
SIA Payment Invoices |
SiaPaymentInvoices |
|
SIA Payment Fields in the CUT Payment Interface ASI
The following table lists the SIA Payment fields and their attributes in the CUT Payment Interface ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Alert Id |
AlertId |
DTYPE_ID |
NA |
No |
Bank Account Number |
BankAccountNumber |
DTYPE_TEXT |
50 |
No |
Bank Location |
BankLocation |
DTYPE_TEXT |
100 |
No |
Bank Name |
BankName |
DTYPE_TEXT |
100 |
No |
Cheque Number |
ChequeNumber |
DTYPE_TEXT |
30 |
No |
Cheque Status |
ChequeStatus |
DTYPE_TEXT |
30 |
No |
Comments |
Comments |
DTYPE_TEXT |
255 |
No |
Credit Card Expiration Date |
CreditCardExpirationDate |
DTYPE_DATETIME |
NA |
No |
Credit Card Holder Name |
CreditCardHolderName |
DTYPE_TEXT |
50 |
No |
Credit Card Number |
CreditCardNumber |
DTYPE_TEXT |
50 |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
Desired Payment Date |
DesiredPaymentDate |
DTYPE_DATETIME |
NA |
No |
Exchange Date |
ExchangeDate |
DTYPE_DATETIME |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Invoice Amount |
InvoiceAmount |
DTYPE_TEXT |
NA |
No |
Invoice Num |
InvoiceNum |
DTYPE_ID |
NA |
No |
Payment Amount |
PaymentAmount |
DTYPE_TEXT |
NA |
No |
Payment Date |
PaymentDate |
DTYPE_DATETIME |
NA |
No |
Payment Method |
PaymentMethod |
DTYPE_TEXT |
30 |
No |
Payment Number |
PaymentNumber |
DTYPE_TEXT |
30 |
No |
Payment Type |
PaymentType |
DTYPE_TEXT |
30 |
No |
Received Date |
ReceivedDate |
DTYPE_TEXT |
NA |
No |
Reference Location |
ReferenceLocation |
DTYPE_TEXT |
100 |
No |
Reference Number |
ReferenceNumber |
DTYPE_TEXT |
30 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
Updated By |
UpdatedBy |
DTYPE_TEXT |
50 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
SIA Payment Invoices Fields in the CUT Payment Interface ASI
The following table lists SIA Payment Invoices fields and their attributes in the CUT Payment Interface ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Invoice Date |
InvoiceDate |
DTYPE_TEXT |
NA |
No |
Invoice Id |
InvoiceId |
DTYPE_ID |
NA |
No |
Payment Amount Applied |
PaymentAmountApplied |
DTYPE_TEXT |
NA |
No |
Payment Id |
PaymentId |
DTYPE_ID |
NA |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Action Fields in the CUT Payment Interface ASI
The following table lists Action fields and their attributes in the CUT Payment Interface ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Description |
Description |
DTYPE_TEXT |
100 |
No |
Primary Owner Id |
PrimaryOwnerId |
DTYPE_ID |
NA |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
CUT Account Balance Interface - Request
The CME Query Account Balance Business Integration Process uses the CUT Account Balance Interface - Request ASI integration object to query the external application with an account number for balance and dunning information.
The following image describes the CUT Account Balance Interface - Request ASI integration object structure.

The following table lists the integration components and XML tags.
Integration Component | XML Tag | User Keys |
---|---|---|
Com Invoice Profile |
ComInvoiceProfile |
No user keys. |
Com Invoice Profile Fields in CUT Account Balance Interface - Request ASI
The following table lists Com Invoice Profile fields and their attributes in the CUT Account Balance Interface - Request ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
Not applicable |
No |
External Billing Account Number |
ExternalBillingAccountNumber |
DTYPE_TEXT |
30 |
No |
CUT Account Balance Interface - Response
The CME Query Account Balance Business Integration Process uses the CUT Account Balance Interface - Response ASI integration object to receive balance and dunning information related to an account.
The following image describes the CUT Account Balance Interface - Response Integration Object structure.

The following table lists the integration components and XML tags.
Integration Component | XML Tag | User Keys |
---|---|---|
CUT Account Balance |
CutAccountBalance |
No user keys. |
CUT Account Balance Fields in CUT Account Balance Interface - Response ASI
The following table lists the CUT Account Balance fields and their attributes in the CUT Account Balance Interface - Response ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
30 Days Due |
DaysDue30 |
DTYPE_TEXT |
NA |
No |
60 Days Due |
DaysDue60 |
DTYPE_TEXT |
NA |
No |
90 Days Due |
DaysDue90 |
DTYPE_TEXT |
NA |
No |
Balance |
Balance |
DTYPE_TEXT |
NA |
No |
Currency |
Currency |
DTYPE_TEXT |
NA |
No |
Current Balance |
CurrentBalance |
DTYPE_TEXT |
NA |
No |
Due Date |
DueDate |
DTYPE_TEXT |
NA |
No |
External Account # |
ExternalAccountNum |
DTYPE_TEXT |
NA |
No |
Pending Credits |
PendingCredits |
DTYPE_TEXT |
NA |
No |
Pending Debits |
PendingDebits |
DTYPE_TEXT |
NA |
No |
Unbilled Usage |
UnbilledUsage |
DTYPE_TEXT |
NA |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Siebel Meter Reading
The CME Update Meter Usage Business Integration Process uses the Siebel Meter Reading ASI to update the external application with meter reading data for billing information.
The following image describes the Siebel Meter Reading ASI structure.

The following table lists the integration components and XML tags of this ASI.
Integration Component | XML Tag | User Keys |
---|---|---|
FS Asset Reading |
FsAssetReading |
|
FS Asset Reading Fields in Siebel Meter Reading ASI
The following table lists the FS Asset Reading Fields and their attributes in Siebel Meter Reading ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Asset Id |
AssetId |
DTYPE_ID |
NA |
No |
Asset Number |
AssetNumber |
DTYPE_TEXT |
100 |
No |
Asset Serial Number |
AssetSerialNumber |
DTYPE_TEXT |
100 |
No |
Complete Flag |
CompleteFlag |
DTYPE_TEXT |
NA |
No |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Employee |
Employee |
DTYPE_TEXT |
50 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Measurement Method Code |
MeasurementMethodCode |
DTYPE_TEXT |
30 |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Reading |
Reading |
DTYPE_NUMBER |
NA |
No |
Service Point Number |
ServicePointNumber |
DTYPE_ID |
NA |
No |
Timestamp |
Timestamp |
DTYPE_TEXT |
NA |
No |
Units |
Units |
DTYPE_TEXT |
30 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Siebel Meter Usage Data
The CME Query Meter Usage Business Integration Process uses the Siebel Meter Usage Data ASI to query the external application with meter usage data for billing information.
The following image describes the Siebel Meter Usage Data ASI structure.

The following table lists the integration components and XML tags of this ASI.
Integration Component | XML Tag | User Keys |
---|---|---|
SIS OM Asset Mgmt - Asset - Complex Header Billing |
Asset |
|
UT Usage Detail |
UtUsageDetail |
|
SIS OM Asset Mgmt - Asset - Complex Header Billing Fields in Siebel Meter Usage Data ASI
The following table lists the SIS OM Asset Mgmt - Asset - Complex Header Billing fields and their attributes in Siebel Meter Usage Data ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Billing Account Id |
BillingAccountId |
DTYPE_ID |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Service Point Id |
ServicePointId |
DTYPE_ID |
NA |
No |
Service Point Serial Number |
ServicePointSerialNumber |
DTYPE_TEXT |
100 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
UT Usage Detail Fields in Siebel Meter Usage Data ASI
The following table lists UT Usage Detail fields and their attributes in Siebel Meter Usage Data ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Asset Id |
AssetId |
DTYPE_ID |
NA |
No |
Billed Demand |
BilledDemand |
DTYPE_NUMBER |
NA |
No |
Billing Account |
BillingAccount |
DTYPE_TEXT |
100 |
No |
Billing Account Id |
BillingAccountId |
DTYPE_ID |
NA |
No |
Billing Account Number |
BillingAccountNumber |
DTYPE_TEXT |
30 |
No |
Billing Days |
BillingDays |
DTYPE_NUMBER |
NA |
No |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Data Source |
DataSource |
DTYPE_TEXT |
30 |
No |
Degree Days |
DegreeDays |
DTYPE_NUMBER |
NA |
No |
Demand UOM |
DemandUOM |
DTYPE_TEXT |
30 |
No |
End Date |
EndDate |
DTYPE_DATETIME |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Intermediate Usage |
IntermediateUsage |
DTYPE_NUMBER |
NA |
No |
Load Factor |
LoadFactor |
DTYPE_NUMBER |
NA |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Off Peak Demand |
OffPeakDemand |
DTYPE_NUMBER |
NA |
No |
Off Peak Usage |
OffPeakUsage |
DTYPE_NUMBER |
NA |
No |
On Peak Demand |
OnPeakDemand |
DTYPE_NUMBER |
NA |
No |
On Peak Usage |
OnPeakUsage |
DTYPE_NUMBER |
NA |
No |
Period |
Period |
DTYPE_TEXT |
50 |
No |
Period Id |
PeriodId |
DTYPE_ID |
NA |
No |
Power Factor |
PowerFactor |
DTYPE_NUMBER |
NA |
No |
Rate Code |
RateCode |
DTYPE_TEXT |
30 |
No |
Rate Exception |
RateException |
DTYPE_TEXT |
30 |
No |
Read Code |
ReadCode |
DTYPE_TEXT |
30 |
No |
Start Date |
StartDate |
DTYPE_DATETIME |
NA |
No |
Supplier |
Supplier |
DTYPE_TEXT |
100 |
No |
Supplier Id |
SupplierId |
DTYPE_ID |
NA |
No |
Total Usage |
TotalUsage |
DTYPE_NUMBER |
NA |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
Usage UOM |
UsageUOM |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Siebel Payment
The Siebel Payment ASI is used to query payment information from the external systems.
The following image describes the structure of the Siebel Payment ASI.

The following table lists the integration components of this ASI.
Integration Component | XML Tag | User Keys |
---|---|---|
Action |
Action |
|
SIA Payment |
SiaPayment |
|
SIA Payment Invoices |
SiaPaymentInvoices |
|
Action Fields in Siebel Payment ASI
The following table lists Action fields and their attributes in Siebel Payment ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
NA |
N |
Description |
Description |
DTYPE_TEXT |
100 |
N |
Primary Owner Id |
PrimaryOwnerId |
DTYPE_ID |
NA |
N |
Type |
Type |
DTYPE_TEXT |
30 |
N |
SIA Payment Fields in Siebel Payment ASI
The following table lists SIA Payment fields and their attributes in Siebel Payment ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
NA |
N |
Alert Id |
AlertId |
DTYPE_ID |
NA |
N |
Bank Account Number |
BankAccountNumber |
DTYPE_TEXT |
50 |
N |
Bank Location |
BankLocation |
DTYPE_TEXT |
100 |
N |
Bank Name |
BankName |
DTYPE_TEXT |
100 |
N |
Cheque Number |
ChequeNumber |
DTYPE_TEXT |
30 |
N |
Cheque Status |
ChequeStatus |
DTYPE_TEXT |
30 |
N |
Comments |
Comments |
DTYPE_TEXT |
255 |
N |
Credit Card Expiration Date |
CreditCardExpirationDate |
DTYPE_DATETIME |
NA |
N |
Credit Card Holder Name |
CreditCardHolderName |
DTYPE_TEXT |
50 |
N |
Credit Card Number |
CreditCardNumber |
DTYPE_TEXT |
50 |
N |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
N |
Desired Payment Date |
DesiredPaymentDate |
DTYPE_DATETIME |
NA |
N |
Exchange Date |
ExchangeDate |
DTYPE_DATETIME |
NA |
N |
Id |
Id |
DTYPE_ID |
30 |
N |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
N |
Invoice Amount |
InvoiceAmount |
DTYPE_TEXT |
NA |
N |
Invoice Num |
InvoiceNum |
DTYPE_ID |
NA |
N |
Payment Amount |
PaymentAmount |
DTYPE_TEXT |
NA |
N |
Payment Date |
PaymentDate |
DTYPE_DATETIME |
NA |
N |
Payment Method |
PaymentMethod |
DTYPE_TEXT |
30 |
N |
Payment Number |
PaymentNumber |
DTYPE_TEXT |
30 |
N |
Payment Type |
PaymentType |
DTYPE_TEXT |
30 |
N |
Received Date |
ReceivedDate |
DTYPE_TEXT |
NA |
N |
Reference Location |
ReferenceLocation |
DTYPE_TEXT |
100 |
N |
Reference Number |
ReferenceNumber |
DTYPE_TEXT |
30 |
N |
Status |
Status |
DTYPE_TEXT |
30 |
N |
Updated |
Updated |
DTYPE_DATETIME |
30 |
N |
Updated By |
UpdatedBy |
DTYPE_TEXT |
50 |
N |
operation |
operation |
DTYPE_TEXT |
30 |
N |
SIA Payment Invoices Fields in Siebel Payment ASI
The following table lists SIA Payment Invoices fields and their attributes in Siebel Payment ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
N |
Id |
Id |
DTYPE_ID |
30 |
N |
Invoice Date |
InvoiceDate |
DTYPE_TEXT |
NA |
N |
Invoice Id |
InvoiceId |
DTYPE_ID |
NA |
N |
Payment Amount Applied |
PaymentAmountApplied |
DTYPE_TEXT |
NA |
N |
Payment Id |
PaymentId |
DTYPE_ID |
NA |
N |
operation |
operation |
DTYPE_TEXT |
30 |
N |
Siebel Simple Product
Oracle’s Siebel Simple Product ASI is used in the CME Create Product Business Integration Process and the CME Update Product Business Integration Process to create and synchronize Siebel simple products.
The following image describes the Siebel Simple Product ASI structure.

The following table lists the integration components and XML tags of this ASI.
Integration Component | XML Tag | User Keys |
---|---|---|
Internal Product |
InternalProduct |
|
FS Inventory Options |
InventoryOptions |
|
Internal Product_Equivalent Product |
RelatedEquivalentProduct |
|
FS Inventory Location |
RelatedInventoryLocation |
|
Internal Product_Organization |
RelatedOrganization |
|
Internal Product_Related Product |
RelatedProduct |
|
Internal Product_Admin Product Line |
RelatedProductLine |
|
Sales Tool by Product |
RelatedSalesToolByProduct |
|
FS Warranty |
RelatedWarranty |
|
Internal Product Fields in Siebel Simple Product ASI
The following table lists Internal Product fields and their attributes in Siebel Simple Product ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Allocate Below Safety Flag |
AllocateBelowSafetyFlag |
DTYPE_TEXT |
30 |
No |
Auto Allocate Flag |
AutoAllocateFlag |
DTYPE_TEXT |
30 |
No |
Auto Substitute Flag |
AutoSubstituteFlag |
DTYPE_TEXT |
30 |
No |
Class Id |
ClassId |
DTYPE_ID |
NA |
No |
Class Integration Id |
ClassIntegrationId |
DTYPE_TEXT |
30 |
No |
Class Name |
ClassName |
DTYPE_TEXT |
75 |
No |
Class Type |
ClassType |
DTYPE_TEXT |
30 |
No |
Compensable |
CompensableFlag |
DTYPE_TEXT |
NA |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Division Code |
DivisionCode |
DTYPE_TEXT |
30 |
No |
Effective End Date |
EffectiveEndDate |
DTYPE_DATETIME |
NA |
No |
Effective Start Date |
EffectiveStartDate |
DTYPE_DATETIME |
NA |
No |
Field Replacable |
FieldReplacable |
DTYPE_TEXT |
NA |
No |
Global Assembly Level Code |
GlobalAssemblyLevelCode |
DTYPE_TEXT |
50 |
No |
Global Product Classification Code |
GlobalProductClassificationCode |
DTYPE_TEXT |
50 |
No |
Global Product Identifier |
GlobalProductIdentifier |
DTYPE_TEXT |
50 |
No |
Global Product Lifecycle Status Code |
GlobalProductLifecycleStatusCode |
DTYPE_TEXT |
50 |
No |
Global Supply Chain Code |
GlobalSupplyChainCode |
DTYPE_TEXT |
50 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Image Name |
ImageName |
DTYPE_TEXT |
100 |
No |
Image Primary Organization Name |
ImagePrimaryOrganizationName |
DTYPE_TEXT |
100 |
No |
Image File Name |
ImageFileName |
DTYPE_TEXT |
200 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsAdminMode |
IsAdminMode |
DTYPE_TEXT |
NA |
No |
Item Size |
ItemSize |
DTYPE_NUMBER |
NA |
No |
Lead Time |
LeadTime |
DTYPE_TEXT |
30 |
No |
MTBF |
MTBF |
DTYPE_NUMBER |
NA |
No |
MTTR |
MTTR |
DTYPE_NUMBER |
NA |
No |
Maximum Quantity |
MaximumQuantity |
DTYPE_NUMBER |
NA |
No |
Minimum Quantity |
MinimumQuantity |
DTYPE_NUMBER |
NA |
No |
Orderable |
Orderable |
DTYPE_TEXT |
NA |
No |
Parent Internal Product Id (Joined) |
ParentInternalProductId |
DTYPE_ID |
NA |
No |
Parent Internal Product Integration Id |
ParentInternalProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Parent Internal Product Name |
ParentInternalProductName |
DTYPE_TEXT |
100 |
No |
Parent Internal Product Primary Organization |
ParentInternalProductPrimaryOrganization |
DTYPE_TEXT |
100 |
No |
Parent Internal Product Vendor |
ParentInternalProductVendor |
DTYPE_TEXT |
100 |
No |
Parent Internal Product Vendor Location |
ParentInternalProductVendorLocation |
DTYPE_TEXT |
50 |
No |
Parent Internal Product Vendor Organization |
ParentInternalProductVendorOrganization |
DTYPE_TEXT |
100 |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
50 |
No |
Price Type |
PriceType |
DTYPE_TEXT |
NA |
No |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
50 |
No |
Primary Vendor |
PrimaryVendor |
DTYPE_TEXT |
100 |
No |
Product Image Id |
ProductImageId |
DTYPE_ID |
NA |
No |
Product Image Integration Id |
ProductImageIntegrationId |
DTYPE_TEXT |
30 |
No |
Product Level |
ProductLevel |
DTYPE_NUMBER |
NA |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Product Type |
ProductType |
DTYPE_TEXT |
30 |
No |
Return if Defective |
ReturnifDefective |
DTYPE_TEXT |
NA |
No |
Revision |
Version |
DTYPE_TEXT |
30 |
No |
Sales Product |
SalesProduct |
DTYPE_TEXT |
NA |
No |
Serialized |
Serialized |
DTYPE_TEXT |
NA |
No |
Service Product |
ServiceProduct |
DTYPE_TEXT |
30 |
No |
Service Type |
ServiceType |
DTYPE_TEXT |
NA |
No |
Ship Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Shipping Via |
ShippingVia |
DTYPE_TEXT |
30 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Targeted Country |
TargetedCountry |
DTYPE_TEXT |
250 |
No |
Targeted Industry |
TargetedIndustry |
DTYPE_TEXT |
250 |
No |
Targeted Max Age |
TargetedMaxAge |
DTYPE_NUMBER |
NA |
No |
Targeted Min Age |
TargetedMinAge |
DTYPE_NUMBER |
NA |
No |
Targeted Postal Code |
TargetedPostalCode |
DTYPE_TEXT |
250 |
No |
Tool Flag |
ToolFlag |
DTYPE_TEXT |
NA |
No |
Unit of Measure |
UnitofMeasure |
DTYPE_TEXT |
30 |
No |
Units In Inventory |
UnitsInInventory |
DTYPE_NUMBER |
NA |
No |
Units In Inventory As Of |
UnitsInInventoryAsOf |
DTYPE_TEXT |
NA |
No |
Vendor Id |
VendorId |
DTYPE_ID |
NA |
No |
Vendor Integration Id |
VendorIntegrationId |
DTYPE_TEXT |
30 |
No |
Vendor Part Number |
VendorPartNumber |
DTYPE_TEXT |
50 |
No |
Vendor Primary Organization |
VendorPrimaryOrganization |
DTYPE_TEXT |
100 |
No |
Vendor Site |
VendorSite |
DTYPE_TEXT |
50 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
FS Inventory Options Fields in Siebel Simple Product ASI
The following table lists FS Inventory Options fields and their attributes in Siebel Simple Product ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Allocate Below Safety Flag |
AllocateBelowSafetyFlag |
DTYPE_TEXT |
30 |
No |
Auto AllocateFlag |
AutoAllocateFlag |
DTYPE_TEXT |
30 |
No |
Auto Substitute Flag |
AutoSubstituteFlag |
DTYPE_TEXT |
30 |
No |
Class ABC |
ClassABC |
DTYPE_TEXT |
30 |
No |
Class XYZ |
ClassXYZ |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Inventory Type |
InventoryType |
DTYPE_TEXT |
30 |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Internal Product_Equivalent Product Fields in Siebel Simple Product ASI
The following table describes Internal Product_Equivalent Product fields and their attributes in Siebel Simple Product ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Equivalent Product |
EquivalentProduct |
DTYPE_TEXT |
100 |
No |
Equivalent Product Primary Organization |
EquivalentProductPrimaryOrganization |
DTYPE_TEXT |
50 |
No |
Equivalent Product Vendor |
EquivalentProductVendor |
DTYPE_TEXT |
100 |
No |
Equivalent Product Vendor Location |
EquivalentProductVendorLocation |
DTYPE_TEXT |
50 |
No |
Equivalent Product Vendor Organization |
EquivalentProductVendorOrganization |
DTYPE_TEXT |
100 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
FS Inventory Location Fields in Siebel Simple Product ASI
The following table lists FS Inventory Location fields and attributes in Siebel Simple Product ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Inventory Name |
InventoryName |
DTYPE_TEXT |
100 |
No |
Primary Organization Name |
PrimaryOrganizationName |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Internal Product_Organization Fields in Siebel Simple Product ASI
The following table lists Internal Product_Organization fields and their attributes in Siebel Simple Product ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Internal Product_Related Product Fields in Siebel Simple Product ASI
The following table lists Internal Product_Related Product fields and attributes in Siebel Simple Product ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Vendor |
Vendor |
DTYPE_TEXT |
100 |
No |
Vendor Location |
VendorLocation |
DTYPE_TEXT |
50 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Internal Product_Admin Product Line Fields in Siebel Simple Product ASI
The following table lists Internal Product_Admin Product Line fields and their attributes in Siebel Simple Product ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Product Line |
ProductLine |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Sales Tool by Product Fields in Siebel Simple Product ASI
The following table lists Sales Tool by Product fields and their attributes in Siebel Simple Product ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
LitFileName |
LitFileName |
DTYPE_TEXT |
220 |
No |
Name |
Name |
DTYPE_TEXT |
50 |
No |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
50 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
FS Warranty Fields in Siebel Simple Product ASI
The following table lists FS Warranty fields and their attributes in Siebel Simple Product ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Warranty Name |
WarrantyName |
DTYPE_TEXT |
100 |
No |
Warranty Provider Name |
WarrantyProviderName |
DTYPE_TEXT |
100 |
No |
Warranty Provider Primary Organization |
WarrantyProviderPrimaryOrganization |
DTYPE_TEXT |
100 |
No |
Warranty Provider Site |
WarrantyProviderSite |
DTYPE_TEXT |
50 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Trouble Ticketing Management
Trouble Ticketing Management uses a single ASI, Trouble Ticket, to enable the submission and processing of trouble tickets and the update of trouble ticket line items.
Siebel Trouble Ticket
The Oracle’s Siebel Trouble Ticket ASI enables the use of a trouble ticket in the Siebel application to create, request, and update the external application with trouble ticket data when the external application has detected an outage or network fault.
The following image describes the Siebel Trouble Ticket ASI structure.

The following table lists the integration components and XML tags of this ASI.
Integration Component | XML Tag | User Keys |
---|---|---|
Related Service Request_Service Elements |
RelatedServiceRequest_ServiceElements |
|
Related Service Request |
RelatedServiceRequest |
|
Service Request_Service Elements |
ServiceRequest_ServiceElements |
|
Service Request |
ServiceRequest |
|
Related Service Request_Service Elements Fields in Siebel Trouble Ticket ASI
The following table lists the Related Service Request_Service Elements fields and their attributes in Siebel Trouble Ticket ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Service Element Id |
ServiceElementId |
DTYPE_ID |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Related Service Request Fields in Siebel Trouble Ticket ASI
The following table lists Related Service Request fields and their attributes in Siebel Trouble Ticket ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Abstract |
Abstract |
DTYPE_TEXT |
100 |
No |
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Area |
Area |
DTYPE_TEXT |
30 |
No |
Closed Date |
ClosedDate |
DTYPE_TEXT |
NA |
No |
Commit Time |
CommitTime |
DTYPE_TEXT |
NA |
No |
Contact Id |
ContactId |
DTYPE_ID |
NA |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Customer Ref Number |
CustomerRefNumber |
DTYPE_TEXT |
64 |
No |
Description |
Description |
DTYPE_TEXT |
2000 |
No |
Entitlement Id |
EntitlementId |
DTYPE_ID |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Owned By Id |
OwnedById |
DTYPE_ID |
NA |
No |
Priority |
Priority |
DTYPE_TEXT |
30 |
No |
Service Point Asset Id |
ServicePointAssetId |
DTYPE_TEXT |
15 |
No |
Severity |
Severity |
DTYPE_TEXT |
30 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
Yes |
Sub-Area |
Sub-Area |
DTYPE_TEXT |
30 |
No |
Sub-Status |
Sub-Status |
DTYPE_TEXT |
30 |
Yes |
TT Source |
TTSource |
DTYPE_TEXT |
30 |
No |
Ticket Type |
TicketType |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Service Request Fields in Siebel Trouble Ticket ASI
The following table lists Service Request fields and their attributes in Siebel Trouble Ticket ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Abstract |
Abstract |
DTYPE_TEXT |
100 |
No |
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Area |
Area |
DTYPE_TEXT |
30 |
No |
Closed Date |
ClosedDate |
DTYPE_TEXT |
NA |
No |
Commit Time |
CommitTime |
DTYPE_TEXT |
NA |
No |
Contact Id |
ContactId |
DTYPE_ID |
NA |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Customer Ref Number |
CustomerRefNumber |
DTYPE_TEXT |
64 |
No |
Description |
Description |
DTYPE_TEXT |
2000 |
No |
Entitlement Id |
EntitlementId |
DTYPE_ID |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Opened Date |
OpenedDate |
DTYPE_TEXT |
NA |
Yes |
Owned By Id |
OwnedById |
DTYPE_ID |
NA |
No |
Priority |
Priority |
DTYPE_TEXT |
30 |
No |
Service Point Asset Id |
ServicePointAssetId |
DTYPE_TEXT |
15 |
No |
Severity |
Severity |
DTYPE_TEXT |
30 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
Yes |
Sub-Area |
Sub-Area |
DTYPE_TEXT |
30 |
No |
Sub-Status |
Sub-Status |
DTYPE_TEXT |
30 |
No |
TT Source |
TTSource |
DTYPE_TEXT |
30 |
No |
Ticket Type |
TicketType |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Service Request_Service Elements Fields in Siebel Trouble Ticket ASI
The following table lists Service Request_Service Elements fields and their attributes in Siebel Trouble Ticket ASI.
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Service Element Id |
ServiceElementId |
DTYPE_ID |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |