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:

Note: Required is abbreviated as Req. and Not Applicable is abbreviated as NA in the following tables.

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.

Table Prebuilt Communications, Media, and Energy ASIs and Integration Objects

ASI, Integration Object	Description
Order Management
Siebel Order	For details, see Siebel Order.
Customer Life Cycle Management
Siebel Account	For details, see Siebel Account.
Siebel Contact	ASI to facilitate the inbound and outbound transfer of contact data from the Siebel application. For details, see Siebel Contact.
Siebel CUT Address MSAG Service	For details, see Siebel CUT Address MSAG Service.
Billing Management
Siebel Invoice	For details, see Siebel Invoice.
Siebel Invoice Adjustment	For details, see Siebel Invoice Adjustment.
CUT Payment Interface Integration Object	For details, see CUT Payment Interface Integration Object.
CUT Account Balance Interface - Request Integration Object	For details, see CUT Account Balance Interface - Request Integration Object.
CUT Account Balance Interface - Response Integration Object	For details, see CUT Account Balance Interface - Response Integration Object.
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.
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.
Siebel Payment	For details, see Siebel Payment.
Product and Pricing Administration
Siebel Simple Product	For details, see Siebel Simple Product.
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.
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.

Table Siebel Order ASI Integration Components

Integration Component	XML Tag	User Keys
Attributes	Attributes	Id Integration Id Name, Object Id
Line Items	LineItems	Id Integration Id Line Number
Orders	Orders	Id Integration Id Order Number, Revision, Primary Organization, Order Type Order Number, Revision, Organization DUNS Number, Order Type
Payments	Payments	Id Integration Id Payment #, Payment Type
Promised Schedule Lines	PromisedScheduleLines	Id Integration Id Line Item Action Number
Related Organization	RelatedOrganization	Id Integration Id Organization
Related Sales Rep	RelatedSalesRep	Id Integration Id Position Login
Related Shipment	RelatedShipment	Id Integration Id Shipment Number
Requested Schedule Lines	RequestedScheduleLines	Id Integration Id Line Number
Shipment Lines	ShipmentItem	Id Integration Id Shipment Line Number

The following table lists the fields and their attributes.

Table Siebel Order ASI Fields

Name	XML Tag	Data Type	Length	Req.
Orders
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
Line Items
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		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
Attributes
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
Promised Schedule Lines
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
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
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
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
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
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
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.

Table Siebel Account ASI Integration Components

Integration Component	XML Tag	User Keys
Account	Account	Account Id Integration Id Location, Name, Primary Organization
Business Address	BusinessAddress	Address Id Address Integration Id
Com Financial Profile	FinancialProfile	Id Name
Com Invoice Profile	BillingProfile	Id, Name Name
Credit Profile	CreditProfile	Credit Profile Id Credit Profile Integration Id Credit Area
Related Contact	RelatedContact	Person UId, Primary Organization Contact Id Contact Integration Id
Related Industry	RelatedIndustry	Industry Id Industry Integration Id Industry SIC Code
Related Organization	RelatedOrganization	Organization Id Organization Integration Id Organization
Related Sales Rep	RelatedSalesRep	Position Id Position Integration Id Division, Position Login

The following table lists the Siebel Account fields and their attributes.

Table Siebel Account ASI Fields

Name	XML Tag	Data Type	Length	Req.
Account
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	Not applicable	No
Credit Auto Approval Limit	CreditAutoApprovalLimit	DTYPE_NUMBER	Not applicable	No
Credit Status Date	CreditStatusDate	DTYPE_TEXT	Not applicable	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	Not applicable	No
Main Phone Number	MainPhoneNumber	DTYPE_TEXT	Not applicable	No
Master Account Id	MasterAccountId	DTYPE_ID	Not applicable	No
Name	Name	DTYPE_TEXT	100	No
Number of Employees	NumberofEmployees	DTYPE_NUMBER	Not applicable	No
PO Approved Flag	POApprovedFlag	DTYPE_TEXT	Not applicable	No
PO Auto Approval Currency Code	POAutoApprovalCurrencyCode	DTYPE_TEXT	20	No
PO Auto Approval Date	POAutoApprovalDate	DTYPE_DATETIME	Not applicable	No
PO Auto Approval Limit	POAutoApprovalLimit	DTYPE_TEXT	Not applicable	No
Parent Account Id	ParentAccountId	DTYPE_ID	Not applicable	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	Not applicable	No
Price List	PriceList	DTYPE_TEXT	Not applicable	No
Price List Id	PriceListId	DTYPE_ID	Not applicable	No
Price List Integration Id	PriceListIntegrationId	DTYPE_TEXT	30	No
Primary Organization	PrimaryOrganization	DTYPE_TEXT	100	No
Skip Credit Check	SkipCreditCheck	DTYPE_TEXT	Not applicable	No
Type	Type	DTYPE_TEXT	255	No
VAT registration number	VATregistrationnumber	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No
Business Address
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
Account Id	AccountId	DTYPE_ID	Not applicable	No
Account Type	AccountType	DTYPE_TEXT	30	No
Annual Income	AnnualIncome	DTYPE_TEXT	Not applicable	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	Not applicable	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	Not applicable	No
Credit Card Number	CreditCardNumber	DTYPE_TEXT	30	No
Credit Card Type	CreditCardType	DTYPE_TEXT	30	No
Credit Score	CreditScore2	DTYPE_NUMBER	Not applicable	No
Credit Update Date	CreditUpdateDate	DTYPE_DATETIME	Not applicable	No
Credit Updated By	CreditUpdatedBy	DTYPE_ID	Not applicable	No
Currency Code	CurrencyCode2	DTYPE_TEXT	20	No
Current Address Id	CurrentAddressId	DTYPE_ID	Not applicable	No
Current City	CurrentCity	DTYPE_TEXT	50	No
Current Country	CurrentCountry	DTYPE_TEXT	30	No
Current Hire Date	CurrentHireDate	DTYPE_DATETIME	Not applicable	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	Not applicable	No
Employer Name	EmployerName	DTYPE_TEXT	100	No
Exchange Date	ExchangeDate	DTYPE_DATETIME	Not applicable	No
Former Address Id	FormerAddressId	DTYPE_ID	Not applicable	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	Not applicable	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
Account Id	AccountId	DTYPE_ID	Not applicable	No
Address Id	AddressId2	DTYPE_ID	Not applicable	No
Bank Account Name	BankAccountName2	DTYPE_TEXT	Not applicable	No
Bank Account Number	BankAccountNumber2	DTYPE_TEXT	Not applicable	No
Bank Account Type	BankAccountType	DTYPE_TEXT	30	No
Bank Authorization Flag	BankAuthorizationflag	DTYPE_TEXT	Not applicable	No
Bank Branch	BankBranch2	DTYPE_TEXT	Not applicable	No
Bank Language Code	BankLanguageCode	DTYPE_TEXT	5	No
Bank Language Id	BankLanguageId	DTYPE_TEXT	5	No
Bank Name	BankName2	DTYPE_TEXT	Not applicable	No
Bill Average	BillAverage	DTYPE_TEXT	Not applicable	No
Bill Cycle	BillCycle	DTYPE_NUMBER	Not applicable	No
Bill Cycle Day	BillCycleDay	DTYPE_NUMBER	Not applicable	No
Bill Frequency	BillFrequency	DTYPE_TEXT	Not applicable	No
Bill Sequence	BillSequence	DTYPE_NUMBER	Not applicable	No
Bill Source	BillSource	DTYPE_TEXT	30	No
Bill Type	BillType	DTYPE_TEXT	Not applicable	No
Bill Vendor Id	BillVendorId	DTYPE_ID	Not applicable	No
Budget Billing Flag	BudgetBillingFlag	DTYPE_TEXT	Not applicable	No
CPNI Date	CPNIDate	DTYPE_DATETIME	Not applicable	No
CPNI Flag	CPNIFlag	DTYPE_TEXT	Not applicable	No
Collections Flag	CollectionsFlag	DTYPE_TEXT	Not applicable	No
Conflict Id	ConflictId	DTYPE_ID	30	No
Contact First Name	ContactFirstName	DTYPE_TEXT	50	No
Contact Id	ContactId	DTYPE_ID	Not applicable	No
Contact Last Name	ContactLastName	DTYPE_TEXT	50	No
Created	Created	DTYPE_DATETIME	30	No
Credit Card Block Flag	CreditCardBlockFlag	DTYPE_TEXT	Not applicable	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	Not applicable	No
Credit Card Name	CreditCardName	DTYPE_TEXT	Not applicable	No
Credit Card Number	CreditCardNumber2	DTYPE_TEXT	Not applicable	No
Credit Card Type	CreditCardType2	DTYPE_TEXT	Not applicable	No
Currency Type	CurrencyType	DTYPE_TEXT	20	No
Days To Cash	DaysToCash	DTYPE_NUMBER	Not applicable	No
Email Bill To	EmailBillTo	DTYPE_TEXT	100	No
External Billing Account Number	ExternalBillingAccountNumber	DTYPE_TEXT	30	No
Extra Copies	ExtraCopies	DTYPE_NUMBER	Not applicable	No
Id	Id	DTYPE_ID	30	No
Interest at Invoice Flag	InterestatInvoiceFlag	DTYPE_TEXT	Not applicable	No
Last Bill Amount	LastBillAmount	DTYPE_TEXT	Not applicable	No
Last Bill Date	LastBillDate	DTYPE_DATETIME	Not applicable	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	Not applicable	No
Number of Manual Invoices	NumberofManualInvoices	DTYPE_NUMBER	Not applicable	No
Payment Method	PaymentMethod	DTYPE_TEXT	30	No
Reason for Manual Outsource	ReasonforManualOutsource	DTYPE_TEXT	30	No
Repeat Debtor Flag	RepeatDebtorFlag	DTYPE_TEXT	Not applicable	No
Row Id	RowId	DTYPE_ID	Not applicable	No
Standing Order Flag	StandingOrderFlag	DTYPE_TEXT	Not applicable	No
Statement Flag	StatementFlag	DTYPE_TEXT	Not applicable	No
Status	Status	DTYPE_TEXT	30	No
Updated	Updated	DTYPE_DATETIME	30	No
Yearly Advance Payment Flag	YearlyAdvancePaymentFlag	DTYPE_TEXT	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
searchspec	searchspec	DTYPE_TEXT	250	No
Credit Profile
Credit Area	CreditArea	DTYPE_TEXT	30	No
Credit Available	CreditAvailable	DTYPE_NUMBER	Not applicable	No
Credit Currency Code	CreditCurrencyCode	DTYPE_TEXT	20	No
Credit Limit	CreditLimit	DTYPE_NUMBER		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	Not applicable	No
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Risk Category Code	RiskCategoryCode	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No
Related Industry
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
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
Assistant Phone #	AssistantPhone	DTYPE_TEXT	Not applicable	No
Cellular Phone #	CellularPhone	DTYPE_TEXT	Not applicable	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		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		No
Related Organization
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Organization	Organization	DTYPE_TEXT	50	No
Organization Id	OrganizationId	DTYPE_ID	Not applicable	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.

Table Siebel Invoice Integration Components

Integration Component	XML Tag	User Keys
CME Invoice Details	CmeInvoiceDetails	No user keys.
CME Invoice Duplicate Request	CmeInvoiceDuplicateRequest	No user keys.
Invoice	Invoice	Id Document Number, Document Type
Invoice Line Items	InvoiceLineItems	Id Integration Id Line Number

The following lists the fields and their attributes.

Table Siebel Invoice ASI Fields

Name	XML Tag	Data Type	Length	Req.
Invoice
Account Id	AccountId	DTYPE_ID	Not applicable	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	Not applicable	No
Activity User Defined Unique Id	ActivityUserDefinedUniqueId	DTYPE_TEXT	30	No
Amount Paid	AmountPaid	DTYPE_TEXT	Not applicable	No
Balance Forward	BalanceForward	DTYPE_TEXT	Not applicable	No
Bill To Person Id	BillToPersonId	DTYPE_TEXT	30	No
Billing End Date	BillingEndDate	DTYPE_TEXT	Not applicable	No
Billing Start Date	BillingStartDate	DTYPE_TEXT	Not applicable	No
Contract Id	ContractId	DTYPE_ID	Not applicable	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	Not applicable	No
Currency Code	CurrencyCode	DTYPE_TEXT	20	No
Delinquent Flag	DelinquentFlag	DTYPE_TEXT	Not applicable	No
Document Date	DocumentDate	DTYPE_TEXT	Not applicable	No
Document Description	DocumentDescription	DTYPE_TEXT	250	No
Document Number	DocumentNumber	DTYPE_TEXT	50	No
Document Period Id	DocumentPeriodId	DTYPE_ID	Not applicable	No
Document Period Name	DocumentPeriodName	DTYPE_TEXT	50	No
Document Period Organization Name	DocumentPeriodOrganizationName	DTYPE_TEXT	100	No
Document Revision Number	DocumentRevisionNumber	DTYPE_NUMBER	Not applicable	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		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	Not applicable	No
Payment Term Id	PaymentTermId	DTYPE_ID	Not applicable	No
Payment Term Net Days	PaymentTermNetDays	DTYPE_NUMBER	Not applicable	No
Project Id	ProjectId	DTYPE_ID	Not applicable	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	Not applicable	No
STORED Discount Amount	STOREDDiscountAmount	DTYPE_TEXT	Not applicable	No
STORED Gross Amount	STOREDGrossAmount	DTYPE_TEXT	Not applicable	No
STORED Surcharge Amount	STOREDSurchargeAmount	DTYPE_TEXT	Not applicable	No
STORED Tax Amount	STOREDTaxAmount	DTYPE_TEXT	Not applicable	No
Service Request Id	ServiceRequestId	DTYPE_ID	Not applicable	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	Not applicable	No
Type Code	TypeCode	DTYPE_TEXT	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
Invoice Line Items
Activity Id	ActivityId	DTYPE_ID	Not applicable	No
Activity User Defined Unique Id	ActivityUserDefinedUniqueId	DTYPE_TEXT	30	No
Contract Id	ContractId	DTYPE_ID	Not applicable	No
Contract Integration Id	ContractIntegrationId	DTYPE_TEXT	30	No
Contract Line Id	ContractLineId	DTYPE_ID	Not applicable	No
Contract Name	ContractName	DTYPE_TEXT	50	No
Contract Organization Name	ContractOrganizationName	DTYPE_TEXT	100	No
Contract Revision Number	ContractRevisionNumber	DTYPE_NUMBER	Not applicable	No
Currency Code	CurrencyCode	DTYPE_TEXT	20	No
Description	Description	DTYPE_TEXT	250	No
Discount Amount	DiscountAmount	DTYPE_TEXT	Not applicable	No
Gross Amount	GrossAmount	DTYPE_TEXT	Not applicable	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Line Number	LineNumber	DTYPE_NUMBER	Not applicable	No
Line Quantity	LineQuantity	DTYPE_NUMBER	Not applicable	No
Line Type	LineType	DTYPE_TEXT	30	No
Order Id	OrderId	DTYPE_ID	Not applicable	No
Order Integration Id	OrderIntegrationId	DTYPE_TEXT	30	No
Order Item Id	OrderItemId	DTYPE_ID	Not applicable	No
Order Item Integration Id	OrderItemIntegrationId	DTYPE_TEXT	30	No
Order Line Number	OrderLineNumber	DTYPE_NUMBER	Not applicable	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	Not applicable	No
Product Id	ProductId	DTYPE_ID	Not applicable	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	Not applicable	No
Project Integration Id	ProjectIntegrationId	DTYPE_TEXT	30	No
Project Item Id	ProjectItemId	DTYPE_ID	Not applicable	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	Not applicable	No
Project Resource Number	ProjectResourceNumber	DTYPE_TEXT	30	No
Service Request Id	ServiceRequestId	DTYPE_ID	Not applicable	No
Service Request Number	ServiceRequestNumber	DTYPE_TEXT	64	No
Service Request Organization Name	ServiceRequestOrganizationName	DTYPE_TEXT	100	No
Surcharge Amount	SurchargeAmount	DTYPE_TEXT	Not applicable	No
Tax Amount	TaxAmount	DTYPE_TEXT	Not applicable	No
Unit of Measure	UnitofMeasure	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No
CME Invoice Details
Amount	Amount2	DTYPE_TEXT	Not applicable	No
Call Type	CallType	DTYPE_TEXT	Not applicable	No
Currency	Currency	DTYPE_TEXT	Not applicable	No
Date/Time	DateTime	DTYPE_TEXT	Not applicable	No
Duration	Duration	DTYPE_TEXT	Not applicable	No
Id	Id	DTYPE_ID	30	No
Invoice Header Id	InvoiceHeaderId	DTYPE_TEXT	Not applicable	No
Line Number	LineNumber	DTYPE_TEXT	Not applicable	No
Location	Location	DTYPE_TEXT	Not applicable	No
Number Called	NumberCalled	DTYPE_TEXT	Not applicable	No
Originating Number	OriginatingNumber	DTYPE_TEXT	Not applicable	No
Period	Period	DTYPE_TEXT	Not applicable	No
Rate	Rate	DTYPE_TEXT	Not applicable	No
Segment	Segment	DTYPE_TEXT	Not applicable	No
Service	Service	DTYPE_TEXT	Not applicable	No
Vid	Vid	DTYPE_ID	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
CME Invoice Duplicate Request
Copies	Copies	DTYPE_NUMBER	Not applicable	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.

Table Siebel Invoice Adjustment Components

Integration Component	XML Tag	User Keys
FS Invoice Adjustment	Adjustment	Adjustment ID Integration Id
FS Invoice Adjustment Items	AdjustmentItem	Item Adjustment ID Integration Id

The following table lists the fields and their attributes.

Table Siebel Invoice Adjustment ASI Fields

Name	XML Tag	Data Type	Length	Req.
FS Invoice Adjustment
Account Id	AccountId	DTYPE_ID	Not applicable	No
Account Name	AccountName	DTYPE_TEXT	100	No
Adjustment ID	AdjustmentID	DTYPE_ID	Not applicable	No
Alert Id	AlertId	DTYPE_ID	Not applicable	No
Approved Amt	ApprovedAmt	DTYPE_TEXT	Not applicable	No
Approved Currency	ApprovedCurrency	DTYPE_TEXT	20	No
Approved Date	ApprovedDate	DTYPE_TEXT	Not applicable	No
Approved Exchange Date	ApprovedExchangeDate	DTYPE_DATETIME	Not applicable	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	Not applicable	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	Not applicable	No
Invoice Line Item ID	InvoiceLineItemID	DTYPE_ID	Not applicable	No
Invoice Number	InvoiceNumber	DTYPE_TEXT	50	No
Invoice Number No Constrain	InvoiceNumberNoConstrain	DTYPE_TEXT	50	No
Item Line Number	ItemLineNumber	DTYPE_NUMBER	Not applicable	No
Last Name	LastName	DTYPE_TEXT	50	No
Line Number	LineNumber	DTYPE_NUMBER	Not applicable	No
Mod Id	ModId	DTYPE_ID	30	No
Reason For Request	ReasonForRequest	DTYPE_TEXT	30	No
Request Amt	RequestAmt	DTYPE_TEXT	Not applicable	No
Request Currency	RequestCurrency	DTYPE_TEXT	20	No
Request Date	RequestDate	DTYPE_TEXT	Not applicable	No
Request Exchange Date	RequestExchangeDate	DTYPE_DATETIME	Not applicable	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
Approved Amt	ApprovedAmt	DTYPE_TEXT	Not applicable	No
Approved Currency Code	ApprovedCurrencyCode	DTYPE_TEXT	20	No
Approved Description	ApprovedDescription	DTYPE_TEXT	250	No
Approved Exchange Date	ApprovedExchangeDate	DTYPE_DATETIME	Not applicable	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	Not applicable	No
Invoice Item ID	InvoiceItemID	DTYPE_ID	Not applicable	No
Item Adjustment ID	ItemAdjustmentID	DTYPE_ID	Not applicable	No
Line Number	LineNumber	DTYPE_NUMBER	Not applicable	No
Mod Id	ModId	DTYPE_ID	30	No
Original Amount	OriginalAmount	DTYPE_TEXT	Not applicable	No
Request Amt	RequestAmt	DTYPE_TEXT	Not applicable	No
Request Currency	RequestCurrency	DTYPE_TEXT	20	No
Request Date	RequestDate	DTYPE_TEXT	Not applicable	No
Request Exchange Date	RequestExchangeDate	DTYPE_DATETIME	Not applicable	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 Integration Object

The CUT Payment Interface 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.

Table CUT Payment Interface ASI Integration Components

Integration Component	XML Tag	User Keys
Action	ListOfCutPaymentInterface	Description
SIA Payment	SiaPayment	Id
SIA Payment Invoices	SiaPaymentInvoices	Invoice Id

The following table lists the fields and their attributes.

Table CUT Payment Interface Integration Object Fields

Name	XML Tag	Data Type	Length	Req.
SIA Payment
Account Id	AccountId	DTYPE_ID	Not applicable	No
Alert Id	AlertId	DTYPE_ID	Not applicable	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	Not applicable	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	Not applicable	No
Exchange Date	ExchangeDate	DTYPE_DATETIME	Not applicable	No
Id	Id	DTYPE_ID	30	No
Invoice Amount	InvoiceAmount	DTYPE_TEXT	Not applicable	No
Invoice Num	InvoiceNum	DTYPE_ID	Not applicable	No
Payment Amount	PaymentAmount	DTYPE_TEXT	Not applicable	No
Payment Date	PaymentDate	DTYPE_DATETIME	Not applicable	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	Not applicable	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
Currency Code	CurrencyCode	DTYPE_TEXT	20	No
Id	Id	DTYPE_ID	30	No
Invoice Date	InvoiceDate	DTYPE_TEXT	Not applicable	No
Invoice Id	InvoiceId	DTYPE_ID	Not applicable	No
Payment Amount Applied	PaymentAmountApplied	DTYPE_TEXT	Not applicable	No
Payment Id	PaymentId	DTYPE_ID	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
Action
Account Id	AccountId	DTYPE_ID	Not applicable	No
Description	Description	DTYPE_TEXT	100	No
Primary Owner Id	PrimaryOwnerId	DTYPE_ID	Not applicable	No
Type	Type	DTYPE_TEXT	30	No

CUT Account Balance Interface - Request Integration Object

The CME Query Account Balance Business Integration Process uses the CUT Account Balance Interface - Request 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 Integration Object structure.

The following table lists the integration components and XML tags.

Table CUT Account Balance Request Integration Object Integration Components

Integration Component	XML Tag	User Keys
Com Invoice Profile	ComInvoiceProfile	No user keys.

The following table lists the fields and their attributes.

Table CUT Account Balance Interface - Request Integration Object Fields

Name	XML Tag	Data Type	Length	Req.
Com Invoice Profile
Account Id	AccountId	DTYPE_ID	Not applicable	No
External Billing Account Number	ExternalBillingAccountNumber	DTYPE_TEXT	30	No

CUT Account Balance Interface - Response Integration Object

The CME Query Account Balance Business Integration Process uses the CUT Account Balance Interface - Response 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.

Table CUT Account Balance Interface - Response Integration Object Integration Components

Integration Component	XML Tag	User Keys
CUT Account Balance	CutAccountBalance	No user keys.

The following table lists the fields and their attributes.

Table CUT Account Balance Interface - Response Integration Object Fields

Name	XML Tag	Data Type	Length	Req.
CUT Account Balance
30 Days Due	DaysDue30	DTYPE_TEXT	Not applicable	No
60 Days Due	DaysDue60	DTYPE_TEXT	Not applicable	No
90 Days Due	DaysDue90	DTYPE_TEXT	Not applicable	No
Balance	Balance	DTYPE_TEXT	Not applicable	No
Currency	Currency	DTYPE_TEXT	Not applicable	No
Current Balance	CurrentBalance	DTYPE_TEXT	Not applicable	No
Due Date	DueDate	DTYPE_TEXT	Not applicable	No
External Account #	ExternalAccountNum	DTYPE_TEXT	Not applicable	No
Pending Credits	PendingCredits	DTYPE_TEXT	Not applicable	No
Pending Debits	PendingDebits	DTYPE_TEXT	Not applicable	No
Unbilled Usage	UnbilledUsage	DTYPE_TEXT	Not applicable	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.

Table Siebel Meter Reading ASI Integration Components

Integration Component	XML Tag	User Keys
FS Asset Reading	FsAssetReading	Id

The following table lists the fields and their attributes.

Table Siebel Meter Reading ASI Fields

Name	XML Tag	Data Type	Length	Req.
FS Asset Reading
Account Id	AccountId	DTYPE_ID	Not applicable	No
Asset Id	AssetId	DTYPE_ID	Not applicable	No
Asset Number	AssetNumber	DTYPE_TEXT	100	No
Asset Serial Number	AssetSerialNumber	DTYPE_TEXT	100	No
Complete Flag	CompleteFlag	DTYPE_TEXT	Not applicable	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	Not applicable	No
Reading	Reading	DTYPE_NUMBER	Not applicable	No
Service Point Number	ServicePointNumber	DTYPE_ID	Not applicable	No
Timestamp	Timestamp	DTYPE_TEXT	Not applicable	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.

Table Siebel Meter Usage Data ASI Integration Components

Integration Component	XML Tag	User Keys
SIS OM Asset Mgmt - Asset - Complex Header Billing	Asset	Id Asset Number
UT Usage Detail	UtUsageDetail	Period Id

The following table lists the fields and their attributes.

Table Siebel Meter Usage Data ASI Fields

Name	XML Tag	Data Type	Length	Req.
SIS OM Asset Mgmt - Asset - Complex Header Billing
Billing Account Id	BillingAccountId	DTYPE_ID	Not applicable	No
Id	Id	DTYPE_ID	30	No
Product Id	ProductId	DTYPE_ID	Not applicable	No
Service Point Id	ServicePointId	DTYPE_ID	Not applicable	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
Asset Id	AssetId	DTYPE_ID	Not applicable	No
Billed Demand	BilledDemand	DTYPE_NUMBER	Not applicable	No
Billing Account	BillingAccount	DTYPE_TEXT	100	No
Billing Account Id	BillingAccountId	DTYPE_ID	Not applicable	No
Billing Account Number	BillingAccountNumber	DTYPE_TEXT	30	No
Billing Days	BillingDays	DTYPE_NUMBER	Not applicable	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	Not applicable	No
Demand UOM	DemandUOM	DTYPE_TEXT	30	No
End Date	EndDate	DTYPE_DATETIME	Not applicable	No
Id	Id	DTYPE_ID	30	No
Intermediate Usage	IntermediateUsage	DTYPE_NUMBER	Not applicable	No
Load Factor	LoadFactor	DTYPE_NUMBER	Not applicable	No
Mod Id	ModId	DTYPE_ID	30	No
Off Peak Demand	OffPeakDemand	DTYPE_NUMBER	Not applicable	No
Off Peak Usage	OffPeakUsage	DTYPE_NUMBER	Not applicable	No
On Peak Demand	OnPeakDemand	DTYPE_NUMBER	Not applicable	No
On Peak Usage	OnPeakUsage	DTYPE_NUMBER	Not applicable	No
Period	Period	DTYPE_TEXT	50	No
Period Id	PeriodId	DTYPE_ID	Not applicable	No
Power Factor	PowerFactor	DTYPE_NUMBER	Not applicable	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	Not applicable	No
Supplier	Supplier	DTYPE_TEXT	100	No
Supplier Id	SupplierId	DTYPE_ID	Not applicable	No
Total Usage	TotalUsage	DTYPE_NUMBER	Not applicable	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.

Table Siebel Payment Integration Component

Integration Component	XML Tag	User Keys
Action	Action	Description
SIA Payment	SiaPayment	Id Integration Id
SIA Payment Invoices	SiaPaymentInvoices	Invoice Id

The following table lists the fields and their attributes.

Table Siebel Payment ASI Fields

Name	XML Tag	Data Type	Length	Req.
Action
Account Id	AccountId	DTYPE_ID	Not applicable	N
Description	Description	DTYPE_TEXT	100	N
Primary Owner Id	PrimaryOwnerId	DTYPE_ID	Not applicable	N
Type	Type	DTYPE_TEXT	30	N
SIA Payment
Account Id	AccountId	DTYPE_ID	Not applicable	N
Alert Id	AlertId	DTYPE_ID	Not applicable	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	Not applicable	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	Not applicable	N
Exchange Date	ExchangeDate	DTYPE_DATETIME	Not applicable	N
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
Invoice Amount	InvoiceAmount	DTYPE_TEXT	Not applicable	N
Invoice Num	InvoiceNum	DTYPE_ID	Not applicable	N
Payment Amount	PaymentAmount	DTYPE_TEXT	Not applicable	N
Payment Date	PaymentDate	DTYPE_DATETIME	Not applicable	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	Not applicable	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
Currency Code	CurrencyCode	DTYPE_TEXT	20	N
Id	Id	DTYPE_ID	30	N
Invoice Date	InvoiceDate	DTYPE_TEXT	Not applicable	N
Invoice Id	InvoiceId	DTYPE_ID	Not applicable	N
Payment Amount Applied	PaymentAmountApplied	DTYPE_TEXT	Not applicable	N
Payment Id	PaymentId	DTYPE_ID	Not applicable	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.

Table Siebel Simple Product Components

Integration Component	XML Tag	User Keys
Internal Product	InternalProduct	Id Integration Id, Product Name Integration Id, Primary Organization, Primary Vendor, Product Name, Vendor Primary Organization, Vendor Site Primary Organization, Primary Vendor, Product Name, Vendor Primary Organization, Vendor Site
FS Inventory Options	InventoryOptions	Id Integration Id Inventory Type, Product Name
Internal Product_Equivalent Product	RelatedEquivalentProduct	Id Integration Id Equivalent Product, Equivalent Product Primary Organization, Equivalent Product Vendor, Equivalent Product Vendor Location, Equivalent Product Vendor Organization
FS Inventory Location	RelatedInventoryLocation	Id Integration Id Inventory Name, Primary Organization
Internal Product_Organization	RelatedOrganization	Id Integration Id Organization
Internal Product_Related Product	RelatedProduct	Id Integration Id Organization, Product Name, Vendor, Vendor Location
Internal Product_Admin Product Line	RelatedProductLine	Id Integration Id Product Line
Sales Tool by Product	RelatedSalesToolByProduct	Id Integration Id Name, Primary Organization
FS Warranty	RelatedWarranty	Id Integration Id Warranty Name, Warranty Provider Name, Warranty Provider Primary Organization, Warranty Provider Site

The following table lists the fields and their attributes.

Table Siebel Simple Product ASI Fields

Name	XML Tag	Data Type	Length	Req.
Internal Product
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
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
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
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
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
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
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
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
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.

Table Siebel Trouble Ticket ASI Integration Components

Integration Component	XML Tag	User Keys
Related Service Request_ Service Elements	RelatedServiceRequest_ServiceElements	Service Element Id
Related Service Request	RelatedServiceRequest	Integration Id Id
Service Request_Service Elements	ServiceRequest_ServiceElements	Service Element Id
Service Request	ServiceRequest	Id Integration Id

The following table lists the fields and their attributes.

Table Siebel Trouble Ticket ASI Fields

Name	XML Tag	Data Type	Length	Req.
Related Service Request_Service Elements
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
Abstract	Abstract	DTYPE_TEXT	100	No
Account Id	AccountId	DTYPE_ID	Not applicable	No
Area	Area	DTYPE_TEXT	30	No
Closed Date	ClosedDate	DTYPE_TEXT	Not applicable	No
Commit Time	CommitTime	DTYPE_TEXT	Not applicable	No
Contact Id	ContactId	DTYPE_ID	Not applicable	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	Not applicable	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Owned By Id	OwnedById	DTYPE_ID	Not applicable	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
Abstract	Abstract	DTYPE_TEXT	100	No
Account Id	AccountId	DTYPE_ID	Not applicable	No
Area	Area	DTYPE_TEXT	30	No
Closed Date	ClosedDate	DTYPE_TEXT	Not applicable	No
Commit Time	CommitTime	DTYPE_TEXT	Not applicable	No
Contact Id	ContactId	DTYPE_ID	Not applicable	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	Not applicable	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Opened Date	OpenedDate	DTYPE_TEXT	Not applicable	Yes
Owned By Id	OwnedById	DTYPE_ID	Not applicable	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
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