6Predefined Application Service Interfaces
Predefined Application Service Interfaces
This chapter provides a list of the prebuilt ASIs that are provided with Siebel applications. You can use these ASIs to receive, send, or request data from other applications.
An ASI consists of a business service, which implements various methods and integration objects, and holds whatever data is present in run time. An integration object can consist of multiple integration components, each with multiple fields. All these fields are active by default and are used by the ASI. You can deactivate unnecessary fields. For more information, see Deactivating ASI Components and Fields.
Each ASI is based on an integration object and can be used to integrate data for all fields of that integration object.
This chapter includes the following topics:
About Prebuilt ASIs
The following table lists the prebuilt ASIs provided by Oracle.
Table Prebuilt Application Services Interfaces
ASI | Description |
---|---|
Siebel Account |
ASI to facilitate the inbound and outbound transfer of account data from the Siebel application. For details, see Siebel Account. |
Siebel Action |
ASI to facilitate the inbound and outbound transfer of activity data from the Siebel application. For details, see Siebel Action. |
Siebel Business Address |
ASI to facilitate the inbound and outbound transfer of business address data from the Siebel application. For details, see Siebel Business Address. |
Siebel Personal Address |
ASI to facilitate the inbound and outbound transfer of personal address data from the Siebel application. For details, see Siebel Personal Address |
Siebel Asset |
ASI that associates a customer with a unique product. For details, see Siebel Assets. |
Siebel Contact |
ASI to facilitate the inbound and outbound transfer of contact data from the Siebel application. For details, see Siebel Contact. |
Siebel Cost List |
ASI to enable the synchronization and update of a cost list and the cost list items. For details, see Siebel Cost List. |
Siebel Employee |
ASI to facilitate the inbound and outbound transfer of employee data from the Siebel application. For details, see Siebel Employee. |
Siebel Financial Account |
ASI to facilitate the inbound and outbound financial account data synchronization between the Siebel application and the UCM system. For details, see Siebel Financial Account. |
Siebel Forecast |
ASI to facilitate the outbound data synchronization between the Siebel application and an external back-office system. For details, see Siebel Forecast. |
Siebel Invoice |
ASI to facilitate the inbound and outbound transfer of invoice data from the Siebel application. For details, see Siebel Invoice. |
External Opportunity Create/External Opportunity Query/External Opportunity Update |
ASI to facilitate the inbound and outbound transfer of opportunity data from the Siebel application. For details, see External Opportunity Create/External Opportunity Query/External Opportunity Update. |
Siebel Order |
ASI to facilitate the inbound and outbound transfer of order data from the Siebel application. For details, see Siebel Order. |
Siebel Position |
ASI to facilitate the inbound and outbound transfer of position data from the Siebel application. For details, see Siebel Position. |
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 ATP Response/External ATP Check |
ASI to facilitate request of availability-to-promise data. For details, see Siebel ATP Response/External ATP Check. |
External Credit Check |
ASI to facilitate the request for a credit check from an external system. For details, see External Credit Check. |
Siebel SIA Service Request |
ASI to create an SIA service request within the Siebel application. For details, see Siebel SIA Service Request. |
Siebel Service Request |
ASI to synchronize service requests in the Siebel application with an external target application. For details, see Siebel Service Request. |
Siebel Simple Product |
ASI to facilitate the inbound and outbound transfer of simple product data from the Siebel application. For details, see Siebel Simple Product. |
Siebel Account
Use this ASI for customer information management-related business processes. This ASI facilitates inbound and outbound account data synchronization between a Siebel application and any external system. The following image describes the Siebel Account ASI structure.

The following table lists the user keys of the Siebel Account ASI.
Table Siebel Account Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Account |
Account |
|
Business Address |
BusinessAddress |
|
Credit Profile |
CreditProfile |
|
Related Bill To Account |
RelatedBillToAccount |
|
Related Contact |
RelatedContact |
|
Related Credit Profile |
RelatedCreditProfile |
|
Related Industry |
RelatedIndustry |
|
Related Organization |
RelatedOrganization |
|
Related Payer Account |
RelatedPayerAccount |
|
Related Sales Organization |
RelatedSalesOrganization |
|
Related Sales Rep |
RelatedSalesRep |
|
Related Ship To Account |
RelatedShipToAccount |
|
Related Sold To Account |
RelatedSoldToAccount |
|
The following table lists the fields and attributes of this ASI.
Table Siebel Account ASI Fields
Name | XML Tag | Data Type | Length | Req. | Notes |
---|---|---|---|---|---|
Account |
|||||
Account Id |
AccountId |
DTYPE_ID |
30 |
No |
None |
Account Organization Integration Id |
AccountOrganizationIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Account Status |
AccountStatus |
DTYPE_TEXT |
24 |
No |
None |
Alias |
Alias |
DTYPE_TEXT |
50 |
No |
None |
Assignment Area Code |
AssignmentAreaCode |
DTYPE_TEXT |
5 |
No |
None |
Assignment Country Code |
AssignmentCountryCode |
DTYPE_TEXT |
5 |
No |
None |
Back Office Order Query End Dt |
BackOfficeOrderQueryEndDt |
DTYPE_DATETIME |
NA |
No |
None |
Back Office Order Query Start Dt |
BackOfficeOrderQueryStartDt |
DTYPE_DATETIME |
NA |
No |
None |
Back Office Sales Area Division Code |
BackOfficeSalesAreaDivisionCode |
DTYPE_TEXT |
30 |
No |
None |
CSN |
CSN |
DTYPE_TEXT |
30 |
No |
None |
Competitor Flag |
CompetitorFlag |
DTYPE_BOOL |
NA |
No |
None |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
None |
Credit Auto Approval Limit |
CreditAutoApprovalLimit |
DTYPE_CURRENCY |
NA |
No |
None |
Credit Status Date |
CreditStatusDate |
DTYPE_UTCDAYETIME |
7 |
No |
None |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
No |
Used for picking a related entity. |
Customer Account Group |
CustomerAccountGroup |
DTYPE_TEXT |
30 |
No |
None |
Description |
Description |
DTYPE_TEXT |
255 |
No |
None |
Disable Data Cleansing |
DisableDataCleansing |
DTYPE_TEXT |
NA |
No |
None |
Division |
Division |
DTYPE_TEXT |
30 |
No |
None |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
None |
Domestic Ultimate DUNS |
DomesticUltimateDUNS |
DTYPE_TEXT |
15 |
No |
None |
EAI Sync Date |
EAISyncDate |
DTYPE_TEXT |
NA |
No |
None |
EAI Sync Error Text |
EAISyncErrorText |
DTYPE_TEXT |
2000 |
No |
None |
EAI Sync Status Code |
EAISyncStatusCode |
DTYPE_TEXT |
30 |
No |
None |
Expertise |
Expertise |
DTYPE_TEXT |
30 |
No |
Bound by ACCOUNT_EXPERTISE LOV. |
Freight Terms |
FreightTerms |
DTYPE_TEXT |
30 |
No |
None |
Freight Terms Info |
FreightTermsInfo |
DTYPE_TEXT |
100 |
No |
None |
Global Ultimate DUNS |
GlobalUltimateDUNS |
DTYPE_TEXT |
15 |
No |
None |
Home Page |
HomePage |
DTYPE_TEXT |
100 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field. |
Internal Org Flag |
InternalOrgFlag |
DTYPE_TEXT |
NA |
No |
None |
Language Code |
LanguageCode |
DTYPE_ID |
NA |
No |
None |
Location |
Location |
DTYPE_TEXT |
50 |
No |
None |
Main Fax Number |
MainFaxNumber |
DTYPE_PHONE |
NA |
No |
None |
Main Phone Number |
MainPhoneNumber |
DTYPE_PHONE |
NA |
No |
None |
Name |
Name |
DTYPE_TEXT |
100 |
No |
User key field. |
Number of Employees |
NumberofEmployees |
DTYPE_NUMBER |
NA |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
PO Approved Flag |
POApprovedFlag |
DTYPE_TEXT |
NA |
No |
None |
PO Auto Approval Currency Code |
POAutoApprovalCurrencyCode |
DTYPE_TEXT |
20 |
No |
Used for picking a related entity. |
PO Auto Approval Date |
POAutoApprovalDate |
DTYPE_DATETIME |
NA |
No |
None |
PO Auto Approval Limit |
POAutoApprovalLimit |
DTYPE_TEXT |
NA |
No |
None |
Parent Account Division |
ParentAccountDivision |
DTYPE_TEXT |
NA |
No |
None |
Parent Account Id |
ParentAccountId |
DTYPE_ID |
NA |
No |
None |
Parent Account Integration Id |
ParentAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Parent Account Location |
ParentAccountLocation |
DTYPE_TEXT |
50 |
No |
None |
Parent Account Location Level |
ParentAccountLocationLevel |
DTYPE_TEXT |
30 |
No |
None |
Parent Account Name |
ParentAccountName |
DTYPE_TEXT |
100 |
No |
None |
Parent Account Region |
ParentAccountRegion |
DTYPE_TEXT |
30 |
No |
None |
Parent HQ DUNS |
ParentHQDUNS |
DTYPE_TEXT |
15 |
No |
None |
Partner Flag |
PartnerFlag |
DTYPE_TEXT |
1 |
No |
None |
Partners |
Partners |
DTYPE_TEXT |
100 |
No |
None |
Party Name |
PartyName |
DTYPE_TEXT |
30 |
No |
None |
Party Type Code |
PartyTypeCode |
DTYPE_TEXT |
30 |
No |
None |
Party UId |
PartyUId |
DTYPE_TEXT |
30 |
No |
None |
Price List |
PriceList |
DTYPE_TEXT |
NA |
No |
None |
Price List End Date |
PriceListEndDate |
DTYPE_TEXT |
NA |
No |
None |
Price List Id |
PriceListId |
DTYPE_ID |
NA |
No |
None |
Price List Integration Id |
PriceListIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Price List Start Date |
PriceListStartDate |
DTYPE_TEXT |
NA |
No |
None |
Primary Account City |
PrimaryAccountCity |
DTYPE_TEXT |
50 |
No |
None |
Primary Account Country |
PrimaryAccountCountry |
DTYPE_TEXT |
30 |
No |
None |
Primary Account Postal Code |
PrimaryAccountPostalCode |
DTYPE_TEXT |
30 |
No |
None |
Primary Account State |
PrimaryAccountState |
DTYPE_TEXT |
10 |
No |
None |
Primary Account Street Address |
PrimaryAccountStreetAddress |
DTYPE_TEXT |
200 |
No |
None |
Primary Address Id |
PrimaryAddressId |
DTYPE_ID |
NA |
No |
None |
Primary Assignment Denorm Flag |
PrimaryAssignmentDenormFlag |
DTYPE_TEXT |
NA |
No |
None |
Primary Assignment Manual Flag |
PrimaryAssignmentManualFlag |
DTYPE_TEXT |
NA |
No |
None |
Primary Assignment System Flag |
PrimaryAssignmentSystemFlag |
DTYPE_TEXT |
NA |
No |
None |
Primary Assignment Type |
PrimaryAssignmentType |
DTYPE_TEXT |
30 |
No |
None |
Primary Bill To Address Id |
PrimaryBillToAddressId |
DTYPE_ID |
NA |
No |
None |
Primary Bill To City |
PrimaryBillToCity |
DTYPE_TEXT |
50 |
No |
None |
Primary Bill To Country |
PrimaryBillToCountry |
DTYPE_TEXT |
30 |
No |
None |
Primary Bill To First Name |
PrimaryBillToFirstName |
DTYPE_TEXT |
50 |
No |
None |
Primary Bill To Job Title |
PrimaryBillToJobTitle |
DTYPE_TEXT |
75 |
No |
None |
Primary Bill To Last Name |
PrimaryBillToLastName |
DTYPE_TEXT |
50 |
No |
None |
Primary Bill To Person Id |
PrimaryBillToPersonId |
DTYPE_ID |
NA |
No |
None |
Primary Bill To Postal Code |
PrimaryBillToPostalCode |
DTYPE_TEXT |
30 |
No |
None |
Primary Bill To State |
PrimaryBillToState |
DTYPE_TEXT |
10 |
No |
None |
Primary Bill To Street Address |
PrimaryBillToStreetAddress |
DTYPE_TEXT |
200 |
No |
None |
Primary Fulfill InvLoc Integration Id |
PrimaryFulfillInvLoc IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Primary Fulfillment InvLoc Id |
PrimaryFulfillmentInvLocId |
DTYPE_TEXT |
NA |
No |
None |
Primary Fulfillment Inventory Location |
PrimaryFulfillment InventoryLocation |
DTYPE_TEXT |
NA |
No |
None |
Primary Industry Id |
PrimaryIndustryId |
DTYPE_ID |
NA |
No |
None |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
User key field. |
Primary Organization Id |
PrimaryOrganizationId |
DTYPE_ID |
NA |
No |
None |
Primary Payer Account |
PrimaryPayerAccount |
DTYPE_TEXT |
100 |
No |
None |
Primary Payer Account Id |
PrimaryPayerAccountId |
DTYPE_ID |
NA |
No |
None |
Primary Position Id |
PrimaryPositionId |
DTYPE_ID |
NA |
No |
None |
Primary Service Agreement Id |
PrimaryServiceAgreementId |
DTYPE_ID |
NA |
No |
None |
Primary Ship To Address Id |
PrimaryShipToAddressId |
DTYPE_ID |
NA |
No |
None |
Primary Ship To City |
PrimaryShipToCity |
DTYPE_TEXT |
50 |
No |
None |
Primary Ship To Country |
PrimaryShipToCountry |
DTYPE_TEXT |
30 |
No |
None |
Primary Ship To First Name |
PrimaryShipToFirstName |
DTYPE_TEXT |
50 |
No |
None |
Primary Ship To Job Title |
PrimaryShipToJobTitle |
DTYPE_TEXT |
75 |
No |
None |
Primary Ship To Last Name |
PrimaryShipToLastName |
DTYPE_TEXT |
50 |
No |
None |
Primary Ship To Person Id |
PrimaryShipToPersonId |
DTYPE_ID |
NA |
No |
None |
Primary Ship To Postal Code |
PrimaryShipToPostalCode |
DTYPE_TEXT |
30 |
No |
None |
Primary Ship To State |
PrimaryShipToState |
DTYPE_TEXT |
10 |
No |
None |
Primary Ship To Street Address |
PrimaryShipToStreetAddress |
DTYPE_TEXT |
200 |
No |
None |
Primary Territory Id |
PrimaryTerritoryId |
DTYPE_ID |
NA |
No |
None |
Primary Type Id |
PrimaryTypeId |
DTYPE_ID |
NA |
No |
None |
Region |
Region |
DTYPE_TEXT |
30 |
No |
None |
Relationship Type |
RelationshipType |
DTYPE_TEXT |
30 |
No |
None |
Revenue Growth |
RevenueGrowth |
DTYPE_NUMBER |
NA |
No |
None |
Skip Credit Check |
SkipCreditCheck |
DTYPE_TEXT |
NA |
No |
None |
Start Date |
StartDate |
DTYPE_DATETIME |
NA |
No |
None |
Strategies |
Strategies |
DTYPE_TEXT |
500 |
No |
None |
Strategy |
Strategy |
DTYPE_TEXT |
2000 |
No |
None |
Success Factors |
SuccessFactors |
DTYPE_TEXT |
500 |
No |
None |
Territory Item Type |
TerritoryItemType |
DTYPE_TEXT |
30 |
No |
None |
Type |
Type |
DTYPE_TEXT |
255 |
No |
None |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
None |
VAT registration number |
VATregistrationnumber |
DTYPE_TEXT |
30 |
No |
None |
Business Address |
|||||
Address Active Status |
AddressActiveStatus |
DTYPE_TEXT |
NA |
No |
None |
Address Id |
AddressId |
DTYPE_ID |
30 |
No |
None |
Address Integration Id |
AddressIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Address Name |
AddressName |
DTYPE_TEXT |
100 |
No |
None |
Bill Address Flag |
BillAddressFlag |
DTYPE_TEXT |
NA |
No |
None |
City |
City |
DTYPE_TEXT |
50 |
No |
None |
Country |
Country |
DTYPE_TEXT |
50 |
No |
None |
County |
County |
DTYPE_TEXT |
50 |
No |
None |
Disable Data Cleansing |
DisableDataCleansing |
DTYPE_TEXT |
NA |
No |
None |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
None |
Fax Number |
FaxNumber |
DTYPE_TEXT |
NA |
No |
None |
Main Address Flag |
MainAddressFlag |
DTYPE_TEXT |
NA |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
Phone Number |
PhoneNumber |
DTYPE_TEXT |
NA |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
None |
Province |
Province |
DTYPE_TEXT |
50 |
No |
None |
Ship Address Flag |
ShipAddressFlag |
NA |
NA |
No |
None |
State |
State |
DTYPE_TEXT |
10 |
No |
None |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
None |
Street Address 2 |
Street Address2 |
DTYPE_TEXT |
100 |
No |
None |
Credit Profile |
|||||
Credit Area |
CreditArea |
DTYPE_TEXT |
30 |
No |
None |
Credit Available |
CreditAvailable |
DTYPE_NUMBER |
NA |
No |
None |
Credit Currency Code |
CreditCurrencyCode |
DTYPE_TEXT |
20 |
No |
None |
Credit Limit |
CreditLimit |
DTYPE_NUMBER |
NA |
No |
None |
Credit Profile Id |
CreditProfileId |
DTYPE_ID |
30 |
No |
None |
Credit Profile Integration Id |
CreditProfileIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Credit Reporting Group |
CreditReportingGroup |
DTYPE_TEXT |
50 |
No |
None |
Credit Status Code |
CreditStatusCode |
DTYPE_TEXT |
30 |
No |
None |
Credit Status Message |
CreditStatusMessage |
DTYPE_TEXT |
NA |
No |
None |
Credit Used |
CreditUsed |
DTYPE_NUMBER |
NA |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
Risk Category Code |
RiskCategoryCode |
DTYPE_TEXT |
30 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
Related Contact |
|||||
Alternate Phone # |
AlternatePhone |
DTYPE_TEXT |
NA |
No |
None |
Assistant Phone # |
AssistantPhone |
DTYPE_TEXT |
NA |
No |
None |
Cellular Phone # |
CellularPhone |
DTYPE_TEXT |
NA |
No |
None |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
None |
Contact Id |
ContactId |
DTYPE_ID |
30 |
No |
None |
Contact Integration Id |
ContactIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
None |
Employee Number |
EmployeeNumber |
DTYPE_TEXT |
30 |
No |
None |
Fax Phone # |
FaxPhone |
DTYPE_TEXT |
NA |
No |
None |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
None |
Home Phone # |
HomePhone |
DTYPE_TEXT |
NA |
No |
None |
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
No |
None |
Last Name |
LastName |
DTYPE_TEXT |
50 |
No |
None |
M/F |
MF |
DTYPE_TEXT |
255 |
No |
None |
M/M |
MM |
DTYPE_TEXT |
15 |
No |
None |
Middle Name |
MiddleName |
DTYPE_TEXT |
50 |
No |
None |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
None |
Person UId |
PersonUId |
DTYPE_TEXT |
100 |
No |
None |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
None |
Work Phone # |
WorkPhone |
DTYPE_TEXT |
NA |
No |
None |
Work Phone Extension |
WorkPhoneExtension |
DTYPE_TEXT | 10 |
No |
None |
Related Industry |
|||||
Industry |
Industry |
DTYPE_TEXT |
50 |
No |
None |
Industry Id |
IndustryId |
30 |
No |
None |
|
Industry Integration Id |
IndustryIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
SIC Code |
SICCode |
DTYPE_TEXT |
30 |
No |
None |
Related Organization |
|||||
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
None |
Organization Id |
OrganizationId |
DTYPE_ID |
15 |
No |
None |
Organization Integration Id |
OrganizationIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Related Sales Rep |
|||||
Division |
Division |
DTYPE_TEXT |
255 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
Login |
Login |
DTYPE_TEXT |
50 |
No |
None |
Position |
Position |
DTYPE_TEXT |
50 |
No |
None |
Position Id |
PositionId |
DTYPE_ID |
30 |
No |
None |
Position Integration Id |
PositionIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Related Sales Organization |
|||||
Account Status |
AccountStatus |
DTYPE_TEXT |
30 |
No |
None |
Back Office Distribution Channel |
BackOfficeDistributionChannel |
DTYPE_TEXT |
30 |
No |
None |
Back Office Sales Area Division Code |
BackOfficeSalesAreaDivisionCode |
DTYPE_TEXT |
30 |
No |
None |
Back Office Sales Organization |
BackOfficeSalesOrganization |
DTYPE_TEXT |
30 |
No |
None |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
None |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
None |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
None |
Freight Terms |
FreightTerms |
DTYPE_TEXT |
30 |
No |
None |
Freight Terms Info |
FreightTermsInfo |
DTYPE_TEXT |
100 |
No |
None |
Id |
Id |
DTYPE_TEXT |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Language Code |
LanguageCode |
DTYPE_ID |
NA |
No |
None |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
None |
Organization |
Organization |
DTYPE_TEXT |
100 |
No |
None |
Organization Id |
OrganizationId |
DTYPE_ID |
NA |
No |
None |
Parent Account Id |
ParentAccountId |
DTYPE_ID |
NA |
No |
None |
Party Id |
PartyId |
DTYPE_ID |
NA |
No |
None |
Payment Terms |
PaymentTerms |
DTYPE_ID |
NA |
No |
None |
Payment Terms Integration Id |
PaymentTermsIntegrationId |
DTYPE_TEXT |
NA |
No |
None |
Payment Terms Name |
PaymentTermsName |
DTYPE_TEXT |
NA |
No |
None |
Price List Type |
PriceListType |
DTYPE_ID |
NA |
No |
None |
Primary Bill To Account Id |
PrimaryBillToAccountId |
DTYPE_ID |
NA |
No |
None |
Primary Fulfillment InvLoc |
PrimaryFulfillmentInvLoc |
DTYPE_TEXT |
NA |
No |
None |
Primary Fulfillment InvLoc ID |
PrimaryFulfillmentInvLocID |
DTYPE_ID |
NA |
No |
None |
Primary Fulfillment InvLoc Integration Id |
PrimaryFulfillmentInvLocIntegrationId |
DTYPE_TEXT |
NA |
No |
None |
Primary Payer Account Id |
PrimaryPayerAccountId |
DTYPE_ID |
NA |
No |
None |
Primary Ship To Account Id |
PrimaryShipToAccountId |
DTYPE_ID |
NA |
No |
None |
Shipping Conditions |
ShippingConditions |
DTYPE_TEXT |
30 |
No |
None |
Type |
Type |
DTYPE_TEXT |
30 |
No |
None |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
None |
Related Bill To Account |
|||||
Bill To Account |
BillToAccount |
DTYPE_TEXT |
100 |
No |
None |
CSN |
CSN |
DTYPE_TEXT |
30 |
No |
None |
Id |
Id |
DTYPE_TEXT |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
Location |
Location |
DTYPE_TEXT |
50 |
No |
None |
Related Payer Account |
|||||
CSN |
CSN |
DTYPE_TEXT |
30 |
No |
None |
Id |
Id |
DTYPE_TEXT |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
Location |
Location |
DTYPE_TEXT |
50 |
No |
None |
Payer Account |
PayerAccount |
DTYPE_TEXT |
100 |
No |
None |
Related Ship To Account |
|||||
CSN |
CSN |
DTYPE_TEXT |
30 |
No |
None |
Id |
Id |
DTYPE_TEXT |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
Location |
Location |
DTYPE_TEXT |
50 |
No |
None |
Ship To Account |
ShipToAccount |
DTYPE_TEXT |
100 |
No |
None |
Related Sold To Account |
|||||
CSN |
CSN |
DTYPE_TEXT |
30 |
No |
None |
Id |
Id |
DTYPE_TEXT |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
Location |
Location |
DTYPE_TEXT |
50 |
No |
None |
Sold To Account |
SoldToAccount |
DTYPE_TEXT |
100 |
No |
None |
Related Credit Profile |
|||||
Block Credit Flag |
BlockCreditFlag |
DTYPE_TEXT |
NA |
No |
None |
Credit Control Area Code |
CreditControlAreaCode |
DTYPE_TEXT |
30 |
No |
None |
Siebel Action
The Siebel Action ASI is based on the Siebel Action Business Component. It is an ASI for business processes related to Activity management (for example, a Calendar event such as an appointment). This ASI facilitates inbound and outbound activity data synchronization between Siebel 6.3 applications and Siebel 7.5 applications.
The following image describes the Siebel Action ASI structure.

The following table lists the integration components and user keys of the Siebel Action ASI.
Table Siebel Action Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Action |
Action |
|
Action_Contact |
Action_Contact |
|
Activity Prospects |
ActivityProspects |
|
Contact(All) |
ContactAll |
|
Employee (MM) |
EmployeeMm |
|
Expense Item |
ExpenseItem |
|
FS Activity Parts Movement |
FsactivityPartsMovement |
|
FS Activity Skill |
FsActivitySkill |
|
FS Activity Skill Item |
FsActivitySkillItem |
|
FS Activity Step |
FsActivityStep |
|
FS Instruction |
FsInstruction |
|
Internal Product |
InternalProduct |
|
Messaging |
Messaging |
|
Time Sheet Daily Hours |
TimeSheetDailyHours |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table Siebel Action ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Action |
||||
Account Id |
AccountId |
DTYPE_ID |
Not applicable |
No |
Activity SR Id |
ActivitySRId |
DTYPE_ID |
Not applicable |
No |
Activity UID |
ActivityUID |
DTYPE_TEXT |
30 |
No |
Alarm |
Alarm |
DTYPE_TEXT |
Not applicable |
No |
Appt Alarm Time Min |
ApptAlarmTimeMin |
DTYPE_NUMBER |
Not applicable |
No |
Asset Id |
AssetId |
DTYPE_ID |
Not applicable |
No |
Assignment Excluded |
AssignmentExcluded |
DTYPE_TEXT |
Not applicable |
No |
Associated Cost |
AssociatedCost |
DTYPE_TEXT |
Not applicable |
No |
Audience |
Audience |
DTYPE_TEXT |
30 |
No |
Billable Flag |
BillableFlag |
DTYPE_TEXT |
Not applicable |
No |
Call Id |
CallId |
DTYPE_TEXT |
30 |
No |
Class |
Class |
DTYPE_TEXT |
30 |
No |
Comment |
Comment |
DTYPE_TEXT |
1,500 |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
Not applicable |
No |
Description |
Description |
DTYPE_TEXT |
100 |
No |
Display |
Display |
DTYPE_TEXT |
30 |
No |
Done |
Done |
DTYPE_DATETIME |
Not applicable |
No |
Due |
Due |
DTYPE_TEXT |
Not applicable |
No |
Est Work Time Remaining |
EstWorkTimeRemaining |
DTYPE_NUMBER |
Not applicable |
No |
Exchange Date |
ExchangeDate |
DTYPE_DATETIME |
Not applicable |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Meeting Location |
MeetingLocation |
DTYPE_TEXT |
100 |
No |
No Sooner Than Date |
NoSoonerThanDate |
DTYPE_DATETIME |
Not applicable |
No |
Opportunity Id |
OpportunityId |
DTYPE_ID |
Not applicable |
No |
Percent Complete |
PercentComplete |
DTYPE_NUMBER |
Not applicable |
No |
Planned |
Planned |
DTYPE_DATETIME |
Not applicable |
No |
Planned Completion |
PlannedCompletion |
DTYPE_DATETIME |
Not applicable |
No |
Previous Activity Id |
PreviousActivityId |
DTYPE_ID |
Not applicable |
No |
Price List Id |
PriceListId |
DTYPE_ID |
Not applicable |
No |
Primary Owner Id |
PrimaryOwnerId |
DTYPE_ID |
Not applicable |
No |
Priority |
Priority |
DTYPE_TEXT |
30 |
No |
Private |
Private |
DTYPE_TEXT |
Not applicable |
No |
Rate List Id |
RateListId |
DTYPE_ID |
Not applicable |
No |
Repeating Expires |
RepeatingExpires |
DTYPE_DATETIME |
Not applicable |
No |
Repeating Type |
RepeatingType |
DTYPE_TEXT |
30 |
No |
Resolution Code |
ResolutionCode |
DTYPE_TEXT |
30 |
No |
Started |
Started |
DTYPE_DATETIME |
Not applicable |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Status Report Flag |
StatusReportFlag |
DTYPE_TEXT |
Not applicable |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Action_Contact |
||||
Contact Id |
Contact Id |
DTYPE_ID |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Activity_Prospects |
||||
Prospective Contact UID |
ProspectiveContactUID |
DTYPE_TEXT |
100 |
No |
Contact |
||||
Party UId |
PartyUId |
DTYPE_TEXT |
30 |
No |
Employee (MM) |
||||
Party UId |
PartyUId |
DTYPE_TEXT |
30 |
No |
Expense Item |
||||
Account Id |
AccountId |
DTYPE_ID |
Not applicable |
No |
Amount |
Amount |
DTYPE_TEXT |
Not applicable |
No |
Billable Flag |
BillableFlag |
DTYPE_TEXT |
Not applicable |
No |
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
Description |
Desc |
DTYPE_TEXT |
250 |
No |
End Date |
EndDate |
DTYPE_DATETIME |
Not applicable |
No |
Establishment |
Establishment |
DTYPE_TEXT |
50 |
No |
Exchange Date |
ExchangeDate |
DTYPE_DATETIME |
Not applicable |
No |
Exchange Rate |
ExchangeRate |
DTYPE_NUMBER |
Not applicable |
No |
Expense Item Number |
ExpenseItemNumber |
DTYPE_ID |
Not applicable |
No |
Expense Item Type |
ExpenseItemTypeName |
DTYPE_TEXT |
50 |
No |
Internal Comments |
InternalComments |
DTYPE_TEXT |
250 |
No |
Item Room Amount |
ItemRoomAmount |
DTYPE_TEXT |
Not applicable |
No |
Item Room Other Tax Amount |
ItemRoomOtherTaxAmount |
DTYPE_TEXT |
Not applicable |
No |
Item Room Tax Amount |
ItemRoomTaxAmount |
DTYPE_TEXT |
Not applicable |
No |
Mileage Distance |
MileageDistance |
DTYPE_NUMBER |
Not applicable |
No |
Mileage Rate |
MileageRate |
DTYPE_TEXT |
Not applicable |
No |
Mileage Route |
MileageRoute |
DTYPE_TEXT |
100 |
No |
Opty Id |
OptyId |
DTYPE_ID |
Not applicable |
No |
Owner Id |
OwnerId |
DTYPE_ID |
Not applicable |
No |
Payment Type |
PaymentType |
DTYPE_TEXT |
30 |
No |
Project Billing Class |
ProjectBillingClass |
DTYPE_TEXT |
30 |
No |
Reimbursable Flag |
ReimbursablFlag |
DTYPE_TEXT |
Not applicable |
No |
Start Date |
StartDate |
DTYPE_DATETIME |
Not applicable |
No |
FS Activity Parts Movement |
||||
Asset Id |
AssetId |
DTYPE_ID |
Not applicable |
No |
Billable Flag |
BillableFlag |
DTYPE_TEXT |
Not applicable |
No |
Commit Txn Flag |
CommitTxnFlag |
DTYPE_TEXT |
Not applicable |
No |
Destination |
Destination |
DTYPE_TEXT |
30 |
No |
Movement Date |
MovementDate |
DTYPE_DATETIME |
Not applicable |
No |
Order Id |
OrderId |
DTYPE_ID |
Not applicable |
No |
Order Item Id |
OrderItemId |
DTYPE_ID |
Not applicable |
No |
PartMvtNum |
PartMvtNum |
DTYPE_ID |
Not applicable |
No |
Product Id |
ProductId |
DTYPE_ID |
Not applicable |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Source |
Source |
DTYPE_TEXT |
30 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Trunk Invloc Id |
TrunkInvlocId |
DTYPE_ID |
Not applicable |
No |
Used Quantity |
UsedQuantity |
DTYPE_NUMBER |
Not applicable |
No |
FS Activity Skill |
||||
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Item Type Name |
ItemTypeName |
DTYPE_TEXT |
75 |
No |
Name |
Name |
DTYPE_TEXT |
50 |
No |
FS Activity Skill Item |
||||
Expertise Code |
ExpertiseCode |
DTYPE_TEXT |
30 |
No |
Low Char 1 |
LowChar1 |
DTYPE_TEXT |
50 |
No |
Low Char 2 |
LowChar2 |
DTYPE_TEXT |
50 |
No |
Low Number 1 |
LowNumber1 |
DTYPE_NUMBER |
Not applicable |
No |
Product Id |
ProdId |
DTYPE_TEXT |
Not applicable |
No |
FS Activity Step |
||||
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
End Date |
EndDate |
DTYPE_DATETIME |
Not applicable |
No |
Performed |
Performed |
DTYPE_TEXT |
Not applicable |
No |
Performed by |
Performedby |
DTYPE_ID |
Not applicable |
No |
SeqNum |
SeqNum |
DTYPE_NUMBER |
Not applicable |
No |
Start Date |
StartDate |
DTYPE_DATETIME |
Not applicable |
No |
Step Type Id |
StepTypeId |
DTYPE_ID |
Not applicable |
No |
FS Instruction |
||||
Instruction |
Instruction |
DTYPE_NOTE |
Not applicable |
No |
Instruction Type |
InstructionType |
DTYPE_TEXT |
30 |
No |
Messaging |
||||
Account Id |
AccountId |
DTYPE_ID |
Not applicable |
No |
Alert Type CD |
AlertTypeCD |
DTYPE_TEXT |
30 |
No |
Comments |
Comments |
DTYPE_TEXT |
2000 |
No |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
No |
Creation Time |
CreationTime |
DTYPE_TEXT |
Not applicable |
No |
Message Number |
MessageNumber |
DTYPE_TEXT |
30 |
No |
Message Status CD |
MessageStatusCD |
DTYPE_TEXT |
30 |
No |
Message Text |
Message Text |
DTYPE_TEXT |
2000 |
No |
Opportunity Id |
OpportunityId |
DTYPE_ID |
Not applicable |
No |
Priority |
Priority |
DTYPE_TEXT |
30 |
No |
Private Flag |
PrivateFlag |
DTYPE_TEXT |
Not applicable |
No |
Recipient Id |
Recipient Id |
DTYPE_ID |
Not applicable |
No |
Sender Id |
SenderId |
DTYPE_ID |
Not applicable |
No |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
Not applicable |
No |
Time Sheet Daily Hours |
||||
Billable Flag |
BillableFlag |
DTYPE_TEXT |
Not applicable |
No |
Billing Class |
BillingClass |
DTYPE_TEXT |
Not applicable |
No |
Billing Rate Type |
BillingRateType |
DTYPE_TEXT |
Not applicable |
No |
Created |
Created |
DTYPE_DATETIME |
Not applicable |
No |
End Time |
EndTime |
DTYPE_DATETIME |
Not applicable |
No |
External Comments |
ExternalComments |
DTYPE_TEXT |
Not applicable |
No |
Id |
Id |
DTYPE_ID |
Not applicable |
No |
Internal Comments |
InternalComments |
DTYPE_TEXT |
Not applicable |
No |
Item Date |
ItemDate |
DTYPE_DATETIME |
Not applicable |
No |
Oppty Id |
OpptyId |
DTYPE_ID |
Not applicable |
No |
Owner Id |
OwnerId |
DTYPE_ID |
Not applicable |
No |
Project Id |
ProjectId |
DTYPE_ID |
Not applicable |
No |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
Not applicable |
No |
Start Time |
StartTime |
DTYPE_DATETIME |
Not applicable |
No |
Time Sheet Item Num |
TimeSheetItemNum |
DTYPE_TEXT |
Not applicable |
No |
Siebel Business Address
Siebel Business Address is part of the Customer Order Lifecycle business process. The Customer Address is a business address associated with a specific customer. This ASI facilitates inbound and outbound address data synchronization between Siebel applications and external systems.
The following image describes the Siebel Business Address ASI structure.

The following table lists the integration components and user keys of this ASI.
Table Siebel Business Address Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Address |
Address |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table Siebel Business Address ASI Fields
Name | XML Tag | Data Type | Length | Required |
---|---|---|---|---|
Address |
||||
Address Line 1 |
AddressLine1 |
DTYPE_TEXT |
200 |
No |
Address Line 2 |
AddressLine2 |
DTYPE_TEXT |
200 |
No |
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
Id |
Id |
DTYPE_TEXT |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
50 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Siebel Personal Address
Siebel Personal Address is part of the Customer Order Lifecycle business process. The Customer Address is a personal address associated with a specific customer. This ASI facilitates inbound and outbound address data synchronization between Siebel applications and external systems.
The following image describes the Siebel Personal Address ASI structure.

The following table lists the integration components and user keys of the Siebel Personal Address ASI.
Table Siebel Personal Address Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Address |
Address |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table Siebel Personal Address ASI Fields
Name | XML Tag | Data Type | Length | Required |
---|---|---|---|---|
Address |
||||
Address Line 1 |
AddressLine1 |
DTYPE_TEXT |
200 |
No |
Address Line 2 |
AddressLine2 |
DTYPE_TEXT |
200 |
No |
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
Id |
Id |
DTYPE_TEXT |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
50 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Siebel Assets
Siebel Asset is part of the Customer Order Lifecycle business process. The Customer Asset is a serialized product or service that a customer has purchased from a company. When a customer creates an order, the seller removes the product from the finished goods inventory, and upon shipment, the item becomes a customer asset with a unique serial number. The asset is only associated with that specific customer.
The following image describes the Siebel Asset ASI structure.

The following table lists the integration components and user keys of this ASI.
Table Siebel Asset Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Asset Mgmt - Asset |
Asset |
|
Asset Mgmt - Asset - Header |
AssetHeader |
|
Asset Mgmt - Asset XA |
AssetXA |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table Siebel Asset ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Asset Mgmt - Asset XA |
||||
Data Type |
DataType |
DTYPE_TEXT |
30 |
No |
Description |
AttributeDescription |
DTYPE_TEXT |
250 |
No |
Display Name |
DisplayName |
DTYPE_TEXT |
100 |
No |
Id |
Id |
DTYPE_ID |
15 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Name |
AttributeName |
DTYPE_TEXT |
75 |
No |
Required |
Required |
DTYPE_TEXT |
1 |
No |
Unit of Measure |
UnitofMeasure |
DTYPE_TEXT |
30 |
No |
Value |
AttributeValue |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Asset Mgmt - Asset - Header |
||||
Asset Currency Code |
AssetCurrencyCode |
DTYPE_TEXT |
20 |
No |
Asset Description |
AssetDescription |
DTYPE_TEXT |
250 |
No |
Asset Number |
AssetNumber |
DTYPE_TEXT |
100 |
No |
Comments |
Comments |
DTYPE_TEXT |
255 |
No |
Id |
Id |
DTYPE_ID |
15 |
No |
Install Date |
InstallDate |
DTYPE_DATETIME |
Not applicable | No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Inventory Location Id |
InventoryLocationId |
DTYPE_ID |
15 |
No |
Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
15 |
No |
Original Cost |
OriginalCost |
DTYPE_NUMBER |
NA |
No |
Original Order Id |
OriginalOrderId |
DTYPE_ID |
15 |
No |
Owner Account Id |
OwnerAccountId |
DTYPE_ID |
15 |
No |
Parent Asset Id |
ParentAssetId |
DTYPE_ID |
15 |
No |
Primary Contact Id |
PrimaryContactId |
DTYPE_ID |
15 |
No |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
Purchase Date |
PurchaseDate |
DTYPE_DATETIME |
Not applicable | No |
Quantity |
Quantity |
DTYPE_NUMBER |
Not applicable | No |
Root Asset Id |
RootAssetId |
DTYPE_ID |
15 |
No |
Serial Number |
SerialNumber |
DTYPE_TEXT |
100 |
No |
Serialized Flag |
ProductSerializedFlag |
DTYPE_TEXT |
1 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Version |
Version |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Asset Mgmt - Asset |
||||
Asset Currency Code |
AssetCurrencyCode |
DTYPE_TEXT |
20 |
No |
Asset Description |
AssetDescription |
DTYPE_TEXT |
250 |
No |
Asset Number |
AssetNumber |
DTYPE_TEXT |
100 |
No |
Comments |
Comments |
DTYPE_TEXT |
255 |
No |
Customizable Flag |
CustomizableFlag |
DTYPE_TEXT |
1 |
No |
Extended Quantity |
ExtendedQuantity |
DTYPE_NUMBER |
Not applicable | No |
Id |
Id |
DTYPE_ID |
15 |
No |
Install Date |
InstallDate |
DTYPE_DATETIME |
Not applicable | No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Inventory Location Id |
InventoryLocationId |
DTYPE_ID |
15 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Operating Status |
OperatingStatus |
DTYPE_TEXT |
30 |
No |
Order Integration Id |
OrderIntegrationId |
DTYPE_TEXT |
30 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
15 |
No |
Original Cost |
OriginalCost |
DTYPE_NUMBER |
Not applicable | No |
Original Order Id |
OriginalOrderId |
DTYPE_ID |
15 |
No |
Owner |
Owner |
DTYPE_ID |
15 |
No |
Owner Account Id |
OwnerAccountId |
DTYPE_ID |
15 |
No |
Parent Asset Id |
ParentAssetId |
DTYPE_ID |
15 |
No |
Price List Id |
PriceListId |
DTYPE_ID |
15 |
No |
Primary Contact Id |
PrimaryContactId |
DTYPE_ID |
15 |
No |
Prod Item Id |
ProdItemId |
DTYPE_ID |
15 |
No |
Product Description |
ProductDescription |
DTYPE_TEXT |
255 |
No |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Product Serialized Flag |
ProductSerializedFlag |
DTYPE_TEXT |
1 |
No |
Purchase Date |
PurchaseDate |
DTYPE_DATETIME |
Not applicable | No |
Quantity |
Quantity |
DTYPE_NUMBER |
Not applicable | No |
Root Asset Id |
RootAssetId |
DTYPE_ID |
15 |
No |
Root Product Id |
RootProductId |
DTYPE_ID |
15 |
No |
Serial Number |
SerialNumber |
DTYPE_TEXT |
100 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Version |
Version |
DTYPE_TEXT |
30 |
No |
Siebel Contact
The Siebel Contact ASI is an ASI for customer information management-related business processes. This ASI facilitates inbound and outbound contact data synchronization between a Siebel application and any external system. The following image describes the Siebel Contact ASI structure.

The following table lists the integration component and user keys of this ASI.
Table Siebel Contact Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Contact |
Contact |
|
Related Account |
RelatedAccount |
|
Personal Address |
PersonalAddress |
|
Communication Address |
CommunicationAddress |
|
Alternate Phone |
AlternatePhone |
|
Related Households |
RelatedHouseholds |
|
Related Organization |
RelatedOrganization |
|
Related Sales Rep |
RelatedSalesRep |
|
The following table lists the fields and their attributes.
Table Siebel Contact ASI Fields
Name | XML Tag | Data Type | Length | Req. | Note |
---|---|---|---|---|---|
Contact |
|||||
Alias |
Alias |
DTYPE_TEXT |
50 |
No |
None |
Assistant |
Assistant |
DTYPE_TEXT |
50 |
No |
None |
Birth Date |
BirthDate |
DTYPE_DATETIME |
7 |
No |
None |
Cellular Phone # |
CellularPhone |
DTYPE_TEXT |
NA |
No |
None |
Comment |
Comment |
DTYPE_TEXT |
255 |
No |
None |
Disable Data Cleansing |
DisableDataCleansing |
DTYPE_TEXT |
NA |
No |
None |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
None |
Fax Phone # |
FaxPhone |
DTYPE_TEXT |
NA |
No |
None |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
None |
Gender |
Gender |
DTYPE_TEXT |
255 |
No |
None |
Home Phone # |
HomePhone |
DTYPE_TEXT |
NA |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Income |
Income |
DTYPE_TEXT |
NA |
No |
None |
Income Currency Code |
IncomeCurrencyCode |
DTYPE_TEXT |
20 |
No |
None |
Income Exchange Date |
IncomeExchangeDate |
DTYPE_DATETIME |
NA |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field |
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
No |
None |
Last Name |
LastName |
DTYPE_TEXT |
50 |
No |
None |
Manager First Name |
ManagerFirstName |
DTYPE_TEXT |
50 |
No |
None |
Manager Id |
ManagerId |
DTYPE_ID |
15 |
No |
None |
Manager Integration Id |
ManagerIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Manager Last Name |
ManagerLastName |
DTYPE_TEXT |
50 |
No |
None |
Manager Middle Name |
ManagerMiddleName |
DTYPE_TEXT |
50 |
No |
None |
Manager Primary Organization |
ManagerPrimaryOrganization |
DTYPE_TEXT |
100 |
No |
None |
Manager UId |
ManagerUId |
DTYPE_TEXT |
100 |
No |
None |
Middle Name |
MiddleName |
DTYPE_TEXT |
50 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
Person UId |
PersonUId |
DTYPE_TEXT |
100 |
No |
None |
Personal Title |
PersonalTitle |
DTYPE_TEXT |
15 |
No |
None |
Preferred Communications |
PreferredCommunications |
DTYPE_TEXT |
30 |
No |
None |
Preferred Language Code |
PreferredLanguageCode |
DTYPE_TEXT |
3 |
No |
None |
Primary Address Id |
PrimaryAddressId |
DTYPE_ID |
NA |
No |
None |
Social Security Number |
SocialSecurityNumber |
DTYPE_TEXT |
NA |
No |
None |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Bound by CONTACT_STATUS LOV |
Suppress All Calls |
SuppressAllCalls |
DTYPE_TEXT |
1 |
No |
None |
Suppress All Emails |
SuppressAllEmails |
DTYPE_TEXT |
1 |
No |
None |
Suppress All Faxes |
SuppressAllFaxes |
DTYPE_TEXT |
NA |
No |
None |
Suppress All Mailings |
SuppressAllMailings |
DTYPE_TEXT |
1 |
No |
None |
Time Zone Id |
TimeZoneId |
DTYPE_ID |
NA |
No |
None |
Time Zone Name |
TimeZoneName |
DTYPE_TEXT |
100 |
No |
None |
Work Phone # |
WorkPhone |
DTYPE_TEXT |
NA |
No |
None |
Work Phone Extension |
WorkPhoneExtension |
DTYPE_TEXT |
10 |
No |
None |
Personal Address |
|||||
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
Personal City |
PersonalCity |
DTYPE_TEXT |
50 |
No |
None |
Personal Country |
PersonalCountry |
DTYPE_TEXT |
50 |
No |
None |
Personal Postal Code |
PersonalPostalCode |
DTYPE_TEXT |
30 |
No |
None |
Personal State |
PersonalState |
DTYPE_TEXT |
10 |
No |
None |
Personal Street Address |
PersonalStreetAddress |
DTYPE_TEXT |
200 |
No |
None |
Personal Street Address 2 |
PersonalStreetAddress2 |
DTYPE_TEXT |
100 |
No |
None |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
None |
Communication Address |
|||||
Alternate Email Address |
AlternateEmailAddress |
DTYPE_TEXT |
100 |
No |
None |
Communication Address Medium Type |
CommunicationAddressMediumType |
DTYPE_TEXT |
30 |
No |
None |
Communication Address Name |
CommunicationAddressName |
DTYPE_TEXT |
50 |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
None |
Alternate Phone |
|||||
Alternate Phone # |
AlternatePhone |
DTYPE_TEXT |
100 |
No |
None |
Alternate Phone Medium Type |
AlternatePhoneMediumType |
DTYPE_TEXT |
30 |
No |
None |
Alternate Phone Name |
AlternatePhoneName |
DTYPE_TEXT |
50 |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
None |
Related Account |
|||||
Account |
Account |
DTYPE_TEXT |
100 |
No |
None |
Account Location |
AccountLocation |
DTYPE_TEXT |
50 |
No |
None |
Account Organization |
AccountOrganization |
DTYPE_TEXT |
100 |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
None |
Related Households |
|||||
HouseHold Name |
HouseHoldName |
DTYPE_TEXT |
50 |
No |
None |
Household Number |
HouseholdNumber |
DTYPE_TEXT |
100 |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
None |
Related Organization |
|||||
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
None |
Related Sales Rep |
|||||
Division |
Division |
DTYPE_TEXT |
255 |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
None |
Login |
Login |
DTYPE_TEXT |
50 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
Position |
Position |
DTYPE_TEXT |
50 |
No |
None |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
None |
Siebel CUT Address MSAG Service
The Siebel CUT Address MSAG Service ASI is an ASI for address validation business processes. This ASI facilitates inbound and outbound address data synchronization between a Siebel application and any external system. The following image describes the Siebel CUT Address MSAG Service ASI structure.

The following table lists the integration component and user keys of this ASI.
Table Siebel CUT Address MSAG Service Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
CUT MSAG Profile |
CutMsagProfile |
|
The following table lists the fields and their attributes.
Table Siebel CUT Address MSAG Service ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
CUT MSAG Profile |
||||
Address Id |
AddressId |
DTYPE_ID |
No |
|
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Internal Validation Flag |
InternalValidationFlag |
DTYPE_TEXT |
Not applicable | No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Profile Type |
ProfileType |
DTYPE_TEXT |
30 |
No |
SA Access Instruction |
SAAccessInstruction |
DTYPE_TEXT |
255 |
No |
SA City |
SACity |
DTYPE_TEXT |
50 |
No |
SA Country |
SACountry |
DTYPE_TEXT |
50 |
No |
SA County |
SACounty |
DTYPE_TEXT |
50 |
No |
SA Descriptive Location |
SADescriptiveLocation |
DTYPE_TEXT |
30 |
No |
SA Directional |
SADirectional |
DTYPE_TEXT |
10 |
No |
SA Driving Instructions |
SADrivingInstruction |
DTYPE_NOTE |
Not applicable | No |
SA House Number |
SAHouseNumber |
DTYPE_TEXT |
8 |
No |
SA House Prefix |
SAHousePrefix |
DTYPE_TEXT |
5 |
No |
SA House Suffix |
SAHouseSuffix |
DTYPE_TEXT |
5 |
No |
SA Location Designator 1 |
SALocationDesignator1 |
DTYPE_TEXT |
50 |
No |
SA Location Designator 2 |
SALocationDesignator2 |
DTYPE_TEXT |
50 |
No |
SA Location Designator 3 |
SALocationDesignator3 |
DTYPE_TEXT |
50 |
No |
SA Location Value 1 |
SALocationValue1 |
DTYPE_TEXT |
50 |
No |
SA Location Value 2 |
SALocationValue2 |
DTYPE_TEXT |
50 |
No |
SA Location Value 3 |
SALocationValue3 |
DTYPE_TEXT |
50 |
No |
SA State |
SAState |
DTYPE_TEXT |
10 |
No |
SA Street Name |
SAStreetName |
DTYPE_TEXT |
50 |
No |
SA Street Suffix |
SAStreetSuffix |
DTYPE_TEXT |
4 |
No |
SA Thoroughfare |
SAThoroughfare |
DTYPE_TEXT |
20 |
No |
SA Zipcode |
SAZipcode |
DTYPE_TEXT |
30 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Siebel Cost List
Standard product costs that exist in external systems are created in the Siebel application based on the costs existing in the external manufacturing and accounting systems. The initial cost types include standard costs, base costs, and the variable costs for a given product.
This inbound ASI enables the synchronization and update of a cost list and the cost list items. The following image describes the Siebel Cost List ASI structure.

The following table lists the integration components and user keys of this ASI.
Table Siebel Cost List Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Cost List |
CostList |
|
Cost List Item |
CostListItem |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table Siebel Cost List ASI Fields
Name | XML Tag | Data Type | Length | Req. | Note |
---|---|---|---|---|---|
Cost List |
|||||
Cost Method |
CostMethod |
DTYPE_TEXT |
30 |
No |
None |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
None |
Description |
Description |
DTYPE_TEXT |
255 |
No |
None |
End Date |
EndDate |
DTYPE_TEXT |
NA |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
Used for picking a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Name |
Name |
DTYPE_TEXT |
50 |
No |
User key field. |
Start Date |
StartDate |
DTYPE_TEXT |
NA |
No |
None |
Type |
Type |
DTYPE_TEXT |
30 |
No |
User key field. |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
None |
Cost List Item |
|||||
Average Cost |
AverageCost |
DTYPE_TEXT |
NA |
No |
None |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
None |
Description |
Description |
DTYPE_TEXT |
255 |
No |
None |
End Date |
EndDate |
DTYPE_TEXT |
NA |
No |
None |
Ext OT Pct Increase |
ExtOTPctIncrease |
DTYPE_NUMBER |
NA |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
|
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field. |
Last Cost |
LastCost |
DTYPE_TEXT |
NA |
No |
None |
Next Cost |
NextCost |
DTYPE_TEXT |
NA |
No |
None |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
|
Standard Cost |
StandardCost |
DTYPE_TEXT |
NA |
No |
None |
Start Date |
StartDate |
DTYPE_TEXT |
NA |
No |
None |
Std OT Pct Increase |
StdOTPctIncrease |
DTYPE_NUMBER |
NA |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
None |
Siebel Employee
The Siebel Employee ASI is an ASI for employee-related business processes. The Employee Integration Object enables inbound and outbound data integration between Siebel applications and third-party applications that process employee data. This can include employee core data, job-related data, responsibilities, position, or resume data. The integration business services are included to perform the basic Create, Update, Delete, and Query functions on Employee objects in the Siebel application. The following image shows the Siebel Employee ASI structure.

The following table lists the Siebel Employee integration components.
Table Siebel Employee Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
CMS Certifications Qualifications |
CmsCertificationsQualifications |
|
CMS Education |
CmsEducation |
|
CMS Employee Competency Administration |
CmsEmployeeCompetencyAdministration |
|
CMS Honors Awards |
CmsHonorsAwards |
|
CMS Memberships |
CmsMemberships |
|
CMS Past Work Experience |
CmsPastWorkExperience |
|
Employee |
Employee |
|
Employee_Employee Organization |
EmployeeEmployeeOrganization |
|
Employee_Personal Address |
EmployeePersonalAddress |
|
Employee_Position |
EmployeePosition |
|
Employee_Subcontractor |
EmployeeSubcontractor |
|
Employee_Responsibility |
EmployeeResponsibility |
|
Personal Address |
PersonalAddress |
|
Related Employee Organization |
RelatedEmployeeOrganization |
|
Related Position |
RelatedPosition |
|
Related Position Business Address |
RelatedPositionBusinessAddress |
|
Related Responsibility |
RelatedResponsibility |
|
Related Subcontractor |
RelatedSubcontractor |
|
The following table lists the fields and their attributes.
Table Siebel Employee ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
CMS Certifications Qualifications |
||||
Certification |
Certification |
DTYPE_TEXT |
30 |
No |
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Date of Certification |
DateofCertification |
DTYPE_TEXT |
Not applicable |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Institution |
Institution |
DTYPE_TEXT |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
CMS Education |
||||
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Country |
Country |
DTYPE_TEXT |
30 |
No |
Degree |
Degree |
DTYPE_TEXT |
30 |
No |
Education |
Education |
DTYPE_TEXT |
30 |
No |
Grade |
Grade |
DTYPE_TEXT |
30 |
No |
Graduation Date |
GraduationDate |
DTYPE_TEXT |
Not applicable |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Institution |
Institution |
DTYPE_TEXT |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Major |
Major |
DTYPE_TEXT |
30 |
No |
Number of Years |
NumberofYears |
DTYPE_NUMBER |
Not applicable |
No |
Scale |
Scale |
DTYPE_TEXT |
30 |
No |
Type of Education |
TypeofEducation |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
CMS Employee Competency Administration |
||||
Competency Id |
CompetencyId |
DTYPE_ID |
Not applicable |
No |
Skill Name |
SkillName |
DTYPE_TEXT |
50 |
No |
Current Skill Level |
CurrentSkillLevel |
DTYPE_TEXT |
100 |
No |
Current Skill Level Id |
CurrentSkillLevelId |
DTYPE_ID |
Not applicable |
No |
Current Skill Level Value |
CurrentSkillLevelValue |
DTYPE_NUMBER |
Not applicable |
No |
Date of Accomplishment |
DateOfAccomplishment |
DTYPE_DATETIME |
Not applicable |
No |
Employee Id |
EmployeeId |
DTYPE_ID |
Not applicable |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Required Skill Level Value |
RequiredSkillLevelValue |
DTYPE_NUMBER |
Not applicable |
No |
Required Skill Level Id |
RequiredSkillLevel Id |
DTYPE_ID |
Not applicable |
No |
Parent Skill |
ParentSkill |
DTYPE_TEXT |
50 |
No |
Rating Scale Id |
RatingScaleId |
DTYPE_ID |
Not applicable |
No |
Required Skill Level |
Required Skill Level |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Skill Gap |
SkillGap |
DTYPE_NUMBER |
Not applicable |
No |
Skill Description |
SkillDescription |
DTYPE_TEXT |
250 |
No |
Root Category Id |
RootCategoryId |
DTYPE_ID |
Not applicable |
No |
Root Category |
RootCategory |
DTYPE_TEXT |
50 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Manager Comments |
ManagerComments |
DTYPE_TEXT |
2000 |
No |
Employee Comments |
EmployeeComments |
DTYPE_TEXT |
2000 |
No |
Delete Record Flag |
DeleteRecordFlag |
DTYPE_TEXT |
Not applicable |
No |
Criticality |
Criticality |
DTYPE_TEXT |
30 |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Category Id |
CategoryId |
DTYPE_ID |
Not applicable |
No |
Assessment Type |
AssessmentType |
DTYPE_TEXT |
30 |
No |
Approved By Id |
ApprovedById |
DTYPE_ID |
Not applicable |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
CMS Honors Awards |
||||
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Honor Award |
HonorAward |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Institution |
Institution |
DTYPE_TEXT |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Received Date |
ReceivedDate |
DTYPE_TEXT |
Not applicable |
No |
Relevance to Company |
RelevancetoCompany |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
CMS Memberships |
||||
Active Status |
ActiveStatus |
DTYPE_TEXT |
Not applicable |
No |
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
End Date |
EndDate |
DTYPE_TEXT |
Not applicable |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Institution |
Institution |
DTYPE_TEXT |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Membership |
Membership |
DTYPE_TEXT |
30 |
No |
Relevance to Company |
RelevancetoCompany |
DTYPE_TEXT |
30 |
No |
Start Date |
StartDate |
DTYPE_TEXT |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
CMS Past Work Experience |
||||
Business Title |
BusinessTitle |
DTYPE_TEXT |
50 |
No |
Business Unit |
BusinessUnit |
DTYPE_TEXT |
30 |
No |
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Company Name |
CompanyName |
DTYPE_TEXT |
30 |
No |
End Date |
EndDate |
DTYPE_TEXT |
Not applicable |
No |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Industry |
Industry |
DTYPE_ID |
Not applicable |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Last Name |
LastName |
DTYPE_TEXT |
50 |
No |
Position |
Position |
DTYPE_TEXT |
50 |
No |
Start Date |
StartDate |
DTYPE_TEXT |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Employee |
||||
Alias |
Alias |
DTYPE_TEXT |
50 |
No |
Availability Status |
AvailabilityStatus |
DTYPE_TEXT |
30 |
No |
Availability Status Until |
AvailabilityStatusUntil |
DTYPE_TEXT |
Not applicable |
No |
Bonus Target % |
BonusTarget |
DTYPE_NUMBER |
Not applicable |
No |
Building Number |
BuildingNumber |
DTYPE_TEXT |
30 |
No |
CP Region |
CPRegion |
DTYPE_TEXT |
50 |
No |
CP Region Id |
CPRegionId |
DTYPE_ID |
Not applicable |
No |
CP Region Integration Id |
CPRegionIntegrationId |
DTYPE_TEXT |
30 |
No |
Cell Phone # |
CellPhone |
DTYPE_TEXT |
Not applicable |
No |
Cost Currency Code |
CostCurrencyCode |
DTYPE_TEXT |
30 |
No |
Cost Per Hour |
CostPerHour |
DTYPE_TEXT |
Not applicable |
No |
Cubicle Number |
CubicleNumber |
DTYPE_TEXT |
20 |
No |
EMail Addr |
EMailAddr |
DTYPE_TEXT |
50 |
No |
Emergency Notification |
EmergencyNotification |
DTYPE_TEXT |
30 |
No |
Emp # |
Emp |
DTYPE_TEXT |
30 |
No |
Employee Flag |
EmployeeFlag |
DTYPE_TEXT |
Not applicable |
No |
Employee Type Code |
EmployeeTypeCode |
DTYPE_TEXT |
30 |
No |
Employment Status |
EmploymentStatus |
DTYPE_TEXT |
30 |
No |
End Shift to |
EndShiftto |
DTYPE_TEXT |
30 |
No |
Fax # |
Fax |
DTYPE_TEXT |
Not applicable |
No |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
Hire Date |
HireDate |
DTYPE_DATETIME |
Not applicable |
No |
Home Phone # |
HomePhone |
DTYPE_TEXT |
Not applicable |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Job Code Id |
JobCodeId |
DTYPE_ID |
Not applicable |
No |
Job Code Integration Id |
JobCodeIntegrationId |
DTYPE_TEXT |
30 |
No |
Job Code Name |
JobCodeName |
DTYPE_TEXT |
30 |
No |
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
No |
Last Name |
LastName |
DTYPE_TEXT |
50 |
No |
Last Promotion Date |
LastPromotionDate |
DTYPE_DATETIME |
Not applicable |
No |
License Plate Number |
LicensePlateNumber |
DTYPE_TEXT |
50 |
No |
Login Domain |
LoginDomain |
DTYPE_TEXT |
50 |
No |
Login Name |
LoginName |
DTYPE_TEXT |
50 |
No |
M/F |
MF |
DTYPE_TEXT |
1 |
No |
Maiden Name |
MaidenName |
DTYPE_TEXT |
50 |
No |
Middle Name |
MiddleName |
DTYPE_TEXT |
50 |
No |
Next Annual Review Date |
NextAnnualReviewDate |
DTYPE_DATETIME |
Not applicable |
No |
Next Availability Status |
NextAvailabilityStatus |
DTYPE_TEXT |
30 |
No |
Nick Name |
NickName |
DTYPE_TEXT |
50 |
No |
Overtime Code |
OvertimeCode |
DTYPE_TEXT |
30 |
No |
Pager PIN |
PagerPIN |
DTYPE_TEXT |
10 |
No |
Pager Phone # |
PagerPhone |
DTYPE_TEXT |
Not applicable |
No |
Pager Type |
PagerType |
DTYPE_TEXT |
30 |
No |
Personal Title |
PersonalTitle |
DTYPE_TEXT |
15 |
No |
Phone # |
Phone |
DTYPE_TEXT |
Not applicable |
No |
Preferred Communications |
PreferredCommunications |
DTYPE_TEXT |
30 |
No |
Private |
Private |
DTYPE_TEXT |
Not applicable |
No |
Readiness |
Readiness |
DTYPE_TEXT |
30 |
No |
Seniority Date |
SeniorityDate |
DTYPE_TEXT |
Not applicable |
No |
Share Address Flag |
ShareAddressFlag |
DTYPE_TEXT |
Not applicable |
No |
Share Home Phone Flag |
ShareHomePhoneFlag |
DTYPE_TEXT |
Not applicable |
No |
Shift Id |
ShiftId |
DTYPE_ID |
Not applicable |
No |
Shift Integration Id |
ShiftIntegrationId |
DTYPE_TEXT |
30 |
No |
Shift Name |
ShiftName |
DTYPE_TEXT |
100 |
No |
Standard Notification |
StandardNotification |
DTYPE_TEXT |
30 |
No |
Start Shift From |
StartShiftFrom |
DTYPE_TEXT |
30 |
No |
Subcontractor Flag |
SubcontractorFlag |
DTYPE_TEXT |
Not applicable |
No |
Termination Date |
TerminationDate |
DTYPE_DATETIME |
Not applicable |
No |
Time Zone Id |
TimeZoneId |
DTYPE_ID |
Not applicable |
No |
Time Zone Name |
TimeZoneName |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Employee_Employee Organization |
||||
Employee Organization |
EmployeeOrganization |
DTYPE_TEXT |
50 |
No |
Employee Organization Id |
EmployeeOrganizationId |
DTYPE_ID |
30 |
No |
Employee Organization Integration Id |
EmployeeOrganizationIntegraitionId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMvg |
DTYPE_TEXT |
1 |
No |
Employee_Personal Address |
||||
IsPrimaryMVG |
IsPrimaryMvg |
DTYPE_TEXT |
1 |
No |
Personal Address Id |
PersonalAddressId |
DTYPE_ID |
30 |
No |
Personal Address Integration Id |
PersonalAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Personal City |
PersonalCity |
DTYPE_TEXT |
50 |
No |
Personal Country |
PersonalCountry |
DTYPE_TEXT |
50 |
No |
Personal County |
PersonalCounty |
DTYPE_TEXT |
50 |
No |
Personal Postal Code |
PersonalPostalCode |
DTYPE_TEXT |
30 |
No |
Personal Province |
PersonalProvince |
DTYPE_TEXT |
50 |
No |
Personal State |
PersonalState |
DTYPE_TEXT |
10 |
No |
Personal Street Address |
PersonalStreetAddress |
DTYPE_TEXT |
200 |
No |
Personal Street Address 2 |
PersonalStreetAddress2 |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Employee_Position |
||||
Division |
Division |
DTYPE_TEXT |
255 |
No |
Division Id |
DivisionId |
DTYPE_ID |
Not applicable |
No |
Division Integration Id |
DivisionIntegrationId |
DTYPE_TEXT |
30 |
No |
Employee End Date |
EmployeeEndDate |
DTYPE_DATETIME |
NA |
No |
Employee Start Date |
EmployeeStartDate |
DTYPE_DATETIME |
Not applicable |
No |
IsPrimaryMVG |
IsPrimaryMvg |
DTYPE_TEXT |
1 |
No |
Position |
Position |
DTYPE_TEXT |
50 |
No |
Position Id |
PositionId |
DTYPE_ID |
30 |
No |
Position Integration Id |
PositionIntegrationId |
DTYPE_TEXT |
30 |
No |
Employee_Responsibility |
||||
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Responsibility |
Responsibility |
DTYPE_TEXT |
50 |
No |
Responsibility Id |
ResponsibilityId |
DTYPE_ID |
30 |
No |
Responsibility Integration Id |
ResponsibilityIntegrationId |
DTYPE_TEXT |
30 |
No |
Employee_Subcontractor |
||||
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Subcontractor Account Id |
SubcontractorAccountId |
DTYPE_ID |
30 |
No |
Subcontractor Integration Id |
SubcontractorIntegrationId |
DTYPE_TEXT |
30 |
No |
Subcontractor Name |
Subcontractor Name |
DTYPE_TEXT |
100 |
No |
Personal Address |
||||
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Personal Address Id |
PersonalAddressId |
DTYPE_ID |
30 |
No |
Personal Address Integration Id |
PersonalAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Personal City |
PersonalCity |
DTYPE_TEXT |
50 |
No |
Personal Country |
PersonalCountry |
DTYPE_TEXT |
50 |
No |
Personal County |
PersonalCounty |
DTYPE_TEXT |
50 |
No |
Personal Postal Code |
PersonalPostalCode |
DTYPE_TEXT |
30 |
No |
Personal Province |
PersonalProvince |
DTYPE_TEXT |
50 |
No |
Personal State |
PersonalState |
DTYPE_TEXT |
10 |
No |
Personal Street Address |
PersonalStreetAddress |
DTYPE_TEXT |
200 |
No |
Personal Street Address 2 |
PersonalStreetAddress2 |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Related Employee Organization |
||||
Employee Organization |
EmployeeOrganization |
DTYPE_TEXT |
50 |
No |
Employee Organization Id |
EmployeeOrganizationId |
DTYPE_ID |
30 |
No |
Employee Organization Integration Id |
EmployeeOrganizationIntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Related Position |
||||
Division |
Division |
DTYPE_TEXT |
255 |
No |
Division Id |
DivisionId |
DTYPE_ID |
Not applicable |
No |
Division Integration Id |
DivisionIntegrationId |
DTYPE_TEXT |
30 |
No |
Employee End Date |
EmployeeEndDate |
DTYPE_DATETIME |
Not applicable |
No |
Employee Start Date |
EmployeeStartDate |
DTYPE_DATETIME |
Not applicable |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Position |
Position |
DTYPE_TEXT |
50 |
No |
Position Id |
PositionId |
DTYPE_ID |
30 |
No |
Position Integration Id |
PositionIntegrationId |
DTYPE_TEXT |
30 |
No |
Related Position Business Address |
||||
Address Id |
AddressId |
DTYPE_ID |
30 |
No |
Address Integration Id |
AddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Address Name |
AddressName |
DTYPE_TEXT |
100 |
No |
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
Related Responsibility |
||||
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Responsibility |
Responsibility |
DTYPE_TEXT |
50 |
No |
Responsibility Id |
ResponsibilityId |
DTYPE_ID |
30 |
No |
Responsibility Integration Id |
ResponsibilityIntegrationId |
DTYPE_TEXT |
30 |
No |
Related Subcontractor |
||||
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Subcontractor Account Id |
SubcontractorAccountId |
DTYPE_ID |
30 |
No |
Subcontractor Integration Id |
SubcontractorIntegrationId |
DTYPE_TEXT |
30 |
No |
Subcontractor Name |
SubcontractorName |
DTYPE_TEXT |
100 |
No |
Siebel Financial Account
The Siebel Financial Account ASI is an ASI for privacy data management-related business processes. This ASI facilitates inbound and outbound financial account data synchronization between a Siebel application and a UCM system. The following image describes the Siebel Financial Account ASI structure.

The following table lists the integration components and user keys of the Siebel Financial Account ASI.
Table Siebel Financial Account Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
FINCORP Account |
FincorpAccount |
|
Contact |
Contact |
|
FINCORP Account Contact |
FincorpAccountContact |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table Siebel Financial Account ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
FINCORPAccount |
||||
ABA Number |
ABANumber |
DTYPE_TEXT |
50 |
No |
Account Alias |
AccountAlias |
DTYPE_TEXT |
100 |
No |
Account Branch ABA |
AccountBranchABA |
DTYPE_TEXT |
50 |
No |
Account Branch Id |
AccountBranchId |
DTYPE_ID |
Not applicable |
No |
Account Branch Name |
AccountBranchName |
DTYPE_TEXT |
100 |
No |
Account Branch Number |
AccountBranchNumber |
DTYPE_TEXT |
30 |
No |
Account Holder |
AccountHolder |
DTYPE_TEXT |
Not applicable |
No |
Account Name |
AccountName |
DTYPE_TEXT |
100 |
No |
Account Number |
AccountNumber |
DTYPE_TEXT |
100 |
Yes |
Account Row Id |
AccountRowId |
DTYPE_ID |
Not applicable |
No |
Account Status |
AccountStatus |
DTYPE_TEXT |
30 |
No |
Account Type |
AccountType |
DTYPE_TEXT |
30 |
No |
Acct Gen - Account Id |
AcctGen-AccountId |
DTYPE_ID |
Not applicable |
No |
Acct Gen - Average Balance |
AcctGen-AverageBalance |
DTYPE_CURRENCY |
Not applicable |
No |
Acct Gen - Branch Id |
AcctGen-BranchId |
DTYPE_ID |
Not applicable |
No |
Acct Gen - Organization Address Id |
AcctGen-OrganizationAddressId |
DTYPE_ID |
Not applicable |
No |
Acct Gen - Pers Addr - City |
AcctGen-PersAddr-City |
DTYPE_TEXT |
50 |
No |
Acct Gen - Pers Addr - Country |
AcctGen-PersAddr-Country |
DTYPE_TEXT |
30 |
No |
Acct Gen - Pers Addr - Id |
AcctGen-PersAddr-Id |
DTYPE_ID |
Not applicable |
No |
Acct Gen - Pers Addr - State |
AcctGen-PersAddr-State |
DTYPE_TEXT |
10 |
No |
Acct Gen - Pers Addr - Street |
AcctGen-PersAddr-Street |
DTYPE_TEXT |
200 |
No |
Acct Gen - Pers Addr - Zip Code |
AcctGen-PersAddr-ZipCode |
DTYPE_TEXT |
30 |
No |
Acct Gen - Primary Contact Id |
AcctGen-PrimaryContactId |
DTYPE_ID |
Not applicable |
No |
Acct Gen - Product Line Id |
AcctGen-ProductLineId |
DTYPE_ID |
Not applicable |
No |
Available Balance |
AvailableBalance |
DTYPE_CURRENCY |
Not applicable |
No |
Balance |
Balance |
DTYPE_CURRENCY |
Not applicable |
No |
Bank Number |
BankNumber |
DTYPE_TEXT |
50 |
No |
Billing Option |
BillingOption |
DTYPE_TEXT |
30 |
No |
Branch |
Branch |
DTYPE_TEXT |
50 |
No |
Branch Number |
BranchNumber |
DTYPE_TEXT |
50 |
No |
CA Next Statement Date |
CANextStatementDate |
DTYPE_DATE |
Not applicable |
No |
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Commitment Amount |
CommitmentAmount |
DTYPE_CURRENCY |
Not applicable |
No |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Contact Address Id |
ContactAddressId |
DTYPE_ID |
Not applicable |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Currency |
Currency |
DTYPE_TEXT |
20 |
No |
Current Balance |
CurrentBalance |
DTYPE_CURRENCY |
Not applicable |
No |
Customer Number |
CustomerNumber |
DTYPE_TEXT |
50 |
No |
Customer Type |
CustomerType |
DTYPE_TEXT |
30 |
No |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Last Name |
LastName |
DTYPE_TEXT |
50 |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
Not applicable |
No |
Parent ABA Number |
ParentABANumber |
DTYPE_TEXT |
50 |
No |
Parent Account Branch ABA |
ParentAccountBranchABA |
DTYPE_TEXT |
50 |
No |
Parent Account Branch Id |
ParentAccountBranchId |
DTYPE_ID |
Not applicable |
No |
Parent Account Id |
ParentAccountId |
DTYPE_ID |
Not applicable |
No |
Parent Account Number |
ParentAccountNumber |
DTYPE_TEXT |
100 |
No |
Parent Asset ID |
ParentAssetID |
DTYPE_ID |
Not applicable |
No |
Parent Asset Number |
ParentAssetNumber |
DTYPE_TEXT |
100 |
No |
Parent Bank |
ParentBank |
DTYPE_TEXT |
50 |
No |
Payment Type |
PaymentType |
DTYPE_TEXT |
30 |
No |
Previous Balance |
PreviousBalance |
DTYPE_CURRENCY |
Not applicable |
No |
Primary Account Id |
PrimaryAccountId |
DTYPE_ID |
Not applicable |
No |
Primary Employee Id |
PrimaryEmployeeId |
DTYPE_ID |
Not applicable |
No |
Primary Org Id |
PrimaryOrgId |
DTYPE_ID |
Not applicable |
No |
Primary Organization Name |
PrimaryOrganizationName |
DTYPE_TEXT |
100 |
No |
Primary Position Id |
PrimaryPositionId |
DTYPE_ID |
Not applicable |
No |
Product Id |
ProductId |
DTYPE_ID |
Not applicable |
Yes |
Start Date |
StartDate |
DTYPE_DATE |
Not applicable |
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 |
Contact |
||||
Account Id |
AccountId |
DTYPE_ID |
Not applicable |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Assistant |
Assistant |
DTYPE_TEXT |
50 |
No |
Assistant Email Address |
AssistantEmailAddress |
DTYPE_TEXT |
100 |
No |
Assistant Phone # |
AssistantPhone |
DTYPE_PHONE |
Not applicable |
No |
Cellular Phone # |
CellularPhone |
DTYPE_PHONE |
Not applicable |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Employee Number |
EmployeeNumber |
DTYPE_TEXT |
30 |
No |
Fax Phone # |
FaxPhone |
DTYPE_PHONE |
Not applicable |
No |
First Name |
FirstName |
DTYPE_TEXT |
50 |
Yes |
Home Phone # |
HomePhone |
DTYPE_PHONE |
Not applicable |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
No |
Last Name |
LastName |
DTYPE_TEXT |
50 |
Yes |
Login Name |
LoginName |
DTYPE_TEXT |
50 |
No |
M/F |
MF |
DTYPE_TEXT |
30 |
No |
M/M |
MM |
DTYPE_TEXT |
15 |
No |
Market Cap Pref |
MarketCapPref |
DTYPE_TEXT |
30 |
No |
Middle Name |
MiddleName |
DTYPE_TEXT |
50 |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Party Type Code |
PartyTypeCode |
DTYPE_TEXT |
30 |
Yes |
Party UId |
PartyUId |
DTYPE_TEXT |
100 |
Yes |
Person UId |
PersonUId |
DTYPE_TEXT |
100 |
Yes |
Personal Contact |
PersonalContact |
DTYPE_BOOL |
Not applicable |
No |
Preferred Communication Method |
PreferredCommunicationMethod |
DTYPE_TEXT |
20 |
No |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
50 |
No |
Privacy Code |
PrivacyCode |
DTYPE_TEXT |
30 |
Yes |
SSN |
SSN |
DTYPE_TEXT |
11 |
No |
Short Name |
ShortName |
DTYPE_TEXT |
50 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
Updated By Name |
UpdatedByName |
DTYPE_TEXT |
50 |
No |
User Type |
UserType |
DTYPE_TEXT |
30 |
No |
Work Phone # |
WorkPhone |
DTYPE_PHONE |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
FINCORPAccountContact |
||||
Account |
Account |
DTYPE_TEXT |
100 |
No |
Account Id |
AccountId |
DTYPE_ID |
Not applicable |
No |
Asset Id |
AssetId |
DTYPE_ID |
Not applicable |
No |
Cellular Phone Number |
CellularPhoneNumber |
DTYPE_PHONE |
Not applicable |
No |
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
No |
Contact Id |
ContactId |
DTYPE_ID |
Not applicable |
No |
Created |
Created |
DTYPE_DATETIME |
30 |
No |
Currency |
Currency2 |
DTYPE_TEXT |
Not applicable |
No |
Email Address |
EmailAddress3 |
DTYPE_TEXT |
100 |
No |
Fax Number |
FaxNumber |
DTYPE_PHONE |
Not applicable |
No |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
Home Phone Number |
HomePhoneNumber |
DTYPE_PHONE |
Not applicable |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
No |
Last Name |
LastName |
DTYPE_TEXT |
50 |
Yes |
Middle Initial |
MiddleInitial |
DTYPE_TEXT |
50 |
No |
Mod Id |
ModId |
DTYPE_ID |
30 |
No |
Mother's Maiden Name |
MothersMaidenName |
DTYPE_TEXT |
50 |
No |
Mr./Ms. |
Mr.Ms. |
DTYPE_ID |
Not applicable |
No |
Primary Personal Address Id |
PrimaryPersonalAddressId |
DTYPE_ID |
Not applicable |
No |
Short Name |
ShortName |
DTYPE_TEXT |
50 |
No |
Social Security Number |
SocialSecurityNumber2 |
DTYPE_TEXT |
11 |
No |
Title |
Title |
DTYPE_TEXT |
75 |
No |
Updated |
Updated |
DTYPE_DATETIME |
30 |
No |
Work Phone # |
WorkPhone |
DTYPE_PHONE |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Siebel Forecast
The Siebel Forecast ASI consists of internal and external integration objects and a business service. This ASI facilitates the outbound data synchronization between the Siebel application and an external back-office system. This ASI is used by the Export Forecast business process, which queries the Siebel application for data on a given forecast and returns the data to a back-office system.
The following image describes the Siebel Forecast ASI structure.

The following table lists the integration components and user keys of the Siebel Forecast ASI.
Table Siebel Forecast Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Forecast |
Forecast |
|
Forecast Item Detail Flat |
ForecastItemDetailFlat |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table Siebel Forecast ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Forecast |
||||
Archive Timestamp |
ArchiveTimestamp |
DTYPE_TEXT |
Not applicable |
No |
Created By Login |
CreatedByLogin |
DTYPE_TEXT |
50 |
No |
Forecast Base Period Type |
ForecastBasePeriodType |
DTYPE_TEXT |
30 |
No |
Forecast Date |
ForecastDate |
DTYPE_TEXT |
Not applicable |
No |
Forecast End Date |
ForecastEndDate |
DTYPE_TEXT |
Not applicable |
No |
Forecast Id |
ForecastId |
DTYPE_ID |
15 |
No |
Forecast Name |
ForecastSeriesName |
DTYPE_TEXT |
20 |
No |
Forecast Number |
ForecastNumber |
DTYPE_TEXT |
30 |
No |
Forecast Start Date |
ForecastStartDate |
DTYPE_TEXT |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Owner Organization Id |
OwnerOrganizationId |
DTYPE_ID |
15 |
No |
Owner Position Id |
OwnerPositionId |
DTYPE_ID |
15 |
No |
Forecast Item Detail Flat |
||||
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
Amount Revenue |
Revenue |
DTYPE_TEXT |
Not applicable |
No |
Best Case |
BestCase |
DTYPE_TEXT |
Not applicable |
No |
Commit Flag |
CommitFlag |
DTYPE_TEXT |
1 |
No |
Cost |
Cost |
DTYPE_TEXT |
Not applicable |
No |
Currency |
CurrencyCode |
DTYPE_TEXT |
Not applicable |
No |
Detail Date |
DetailDate |
DTYPE_TEXT |
Not applicable |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Forecast Id |
ForecastId |
DTYPE_ID |
15 |
No |
Forecast Item Id |
ForecastItemId |
DTYPE_ID |
15 |
No |
Id |
Id |
DTYPE_ID |
15 |
No |
Link Type |
LinkType |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Opportunity Id |
OpportunityId |
DTYPE_ID |
15 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
15 |
No |
Owner Forecast Id |
OwnerForecastId |
DTYPE_ID |
15 |
No |
Primary Product Line Id |
ProductLineId |
DTYPE_ID |
15 |
No |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
Product Price |
ProductPrice |
DTYPE_TEXT |
Not applicable |
No |
Product Quantity |
ProductQuantity |
DTYPE_TEXT |
Not applicable |
No |
Sales Rep Id |
SalesRepPositionId |
DTYPE_ID |
15 |
No |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
15 |
No |
Unit of Measure |
UnitOfMeasure |
DTYPE_TEXT |
30 |
No |
Worst Case |
WorstCase |
DTYPE_TEXT |
No |
Siebel Invoice
The Siebel Invoice ASI enables the implementation of replication of invoices from back-office accounting systems to the Siebel application, which allows sales professionals, call center agents, partners, as well as the customer, to access invoice information in the Siebel application for related inquiries. A typical process involves the creation of the invoice in the back-end system after the fulfillment of an order, which is then followed by the replication of this invoice (as well as all of its updates) in the front-end systems. The Siebel Invoice ASI enables the creation, update, deletion and queries of invoice information for inbound and outbound directions in Siebel applications.
The following image describes the structure of the Siebel Invoice ASI.

The following table lists the integration components of this ASI.
Table Siebel Invoice Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
FS Invoice (primary) |
Invoice |
|
FS Invoice Line Items |
FSInvoiceLineItems |
|
The Siebel Invoice ASI uses the same user keys as the FS Invoice integration component. You can use the fields for the integration, which means that values for each of these fields may be written to an XML file for transport. The following table lists the fields and their attributes.
Table Siebel Invoice ASI Fields
Name | XML Tag | Data Type | Length | Req. | Note |
---|---|---|---|---|---|
FS Invoice |
|||||
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
|
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
|
Account Location |
AccountLocation |
DTYPE_TEXT |
30 |
No |
Used for picking from Picklist Account. |
Account Name |
AccountName |
DTYPE_TEXT |
50 |
No |
Used for picking from Picklist Account. |
Account Organization Name |
AccountOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Picklist Account. |
Activity Id |
ActivityId |
DTYPE_ID |
15 |
No |
Used for picking from FS Activity Pick List. |
Activity User Defined Unique Id |
ActivityUserDefinedUniqueId |
DTYPE_TEXT |
30 |
No |
Used for picking from FS Activity Pick List. |
Amount Paid |
AmountPaid |
DTYPE_CURRENCY |
22 |
No |
None |
Balance Forward |
BalanceForward |
DTYPE_CURRENCY |
22 |
No |
None |
Contract Id |
ContractId |
DTYPE_ID |
15 |
No |
Used for picking from Service Agreement. |
Contract Integration Id |
ContractIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking from Service Agreement. |
Contract Name |
ContractName |
DTYPE_TEXT |
50 |
No |
Used for picking from Service Agreement. |
Contract Organization Name |
ContractOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Service Agreement. |
Contract Revision Number |
ContractRevisionNumber |
DTYPE_NUMBER |
22 |
No |
Used for picking from Service Agreement. |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
Yes |
Used for picking from Picklist Currency. |
Delinquent Flag |
DelinquentFlag |
DTYPE_BOOL |
1 |
No |
None |
Document Date |
DocumentDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Document Description |
DocumentDescription |
DTYPE_TEXT |
250 |
No |
None |
Document Number |
DocumentNumber |
DTYPE_TEXT |
50 |
Yes |
User key field for Invoice. |
Document Period Id |
DocumentPeriodId |
DTYPE_ID |
15 |
No |
Used for picking from Picklist Period. |
Document Period Name |
DocumentPeriodName |
DTYPE_TEXT |
50 |
No |
Used for picking from Picklist Period. |
Document Period Organization Name |
DocumentPeriodOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Picklist Period. |
Document Revision Number |
DocumentRevisionNumber |
DTYPE_NUMBER |
15 |
No |
None |
Document Status |
DocumentStatus |
DTYPE_TEXT |
30 |
No |
Bound by FS_INVOICE_TYPE LOV. |
Document Sub Type |
DocumentSubType |
DTYPE_TEXT |
30 |
No |
Bound by FS_INVOICE_CODE LOV. |
Document Type |
DocumentType |
DTYPE_TEXT |
30 |
No |
|
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Order Id |
OrderId |
DTYPE_ID |
15 |
No |
Used for picking from Order Entry Picklist. |
Order Integration Id |
OrderIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking from Order Entry Picklist. |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Used for picking from Order Entry Picklist. |
Order Organization Name |
OrderOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Order Entry Picklist. |
Order Type |
OrderType |
DTYPE_TEXT |
50 |
No |
Used for picking from Order Entry Picklist. |
Payment Term |
PaymentTerm |
DTYPE_TEXT |
50 |
No |
Used for picking from Picklist Payment Term. |
Payment Term Id |
PaymentTermId |
DTYPE_ID |
15 |
No |
Used for picking from Picklist Payment Term. |
Project Id |
ProjectId |
DTYPE_ID |
15 |
No |
Used for picking from Picklist Project. |
Project Integration Id |
ProjectIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking from Picklist Project. |
Project Number |
ProjectNumber |
DTYPE_TEXT |
30 |
No |
Used for picking from Picklist Project. |
Project Organization Name |
ProjectOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Picklist Project. |
STORED Adjustment Amount |
STOREDAdjustmentAmount |
DTYPE_CURRENCY |
22 |
No |
None |
STORED Discount Amount |
STOREDDiscountAmount |
DTYPE_CURRENCY |
22 |
No |
None |
STORED Gross Amount |
STOREDGrossAmount |
DTYPE_CURRENCY |
22 |
No |
None |
STORED Surcharge Amount |
STOREDSurchargeAmount |
DTYPE_CURRENCY |
22 |
No |
None |
STORED Tax Amount |
STOREDTaxAmount |
DTYPE_CURRENCY |
22 |
No |
None |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
15 |
No |
Used for picking from Service Request Picklist. |
Service Request Number |
ServiceRequestNumber |
DTYPE_TEXT |
64 |
No |
Used for picking from Service Request Picklist. |
Service Request Organization Name |
ServiceRequestOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Service Request Picklist. |
FS Invoice Line Items |
|||||
Activity Id |
ActivityId |
DTYPE_ID |
15 |
No |
Used for picking from FS Activity Picklist. |
Activity User Defined Unique Id |
ActivityUserDefinedUniqueId |
DTYPE_TEXT |
30 |
No |
Used for picking from FS Activity Picklist. |
Contract Id |
ContractId |
DTYPE_ID |
15 |
No |
Used for picking from FS PickList Agreement Item - All. |
Contract Integration Id |
ContractIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking from FS PickList Agreement Item - All. |
Contract Line Id |
ContractLineId |
DTYPE_ID |
15 |
No |
Used for picking from FS PickList Agreement Item - All. |
Contract Name |
ContractName |
DTYPE_TEXT |
50 |
No |
Used for picking from FS PickList Agreement Item - All. |
Contract Organization Name |
ContractOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from FS PickList Agreement Item - All. |
Contract Revision Number |
ContractRevisionNumber |
DTYPE_NUMBER |
22 |
No |
Used for picking from FS PickList Agreement Item - All. |
CurrencyCode |
CurrencyCode |
DTYPE_TEXT |
20 |
Yes |
Used for picking from Picklist Currency. |
Description |
Description |
DTYPE_TEXT |
250 |
No |
None |
Discount Amount |
DiscountAmount |
DTYPE_CURRENCY |
22 |
No |
None |
Gross Amount |
GrossAmount |
DTYPE_CURRENCY |
22 |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
User key field for Line Item. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field for Line Item. |
Line Number |
LineNumber |
DTYPE_NUMBER |
22 |
Yes |
User key field for Line Item. |
Line Quantity |
LineQuantity |
DTYPE_NUMBER |
22 |
Yes |
None |
Line Type |
LineType |
DTYPE_TEXT |
30 |
No |
Used for picking from FS Invoice Line Item Type Picklist. |
Order Id |
OrderId |
DTYPE_ID |
15 |
No |
Used for picking from Order Entry Picklist. |
Order Integration Id |
OrderIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking from Order Entry Picklist. |
Order Item Id |
OrderItemId |
DTYPE_ID |
15 |
No |
Used for picking from Order Entry - Line Item Picklist. |
Order Item Integration Id |
OrderItemIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking from Order Entry - Line Item Picklist. |
Order Line Number |
OrderLineNumber |
DTYPE_NUMBER |
22 |
No |
Used for picking from Order Entry - Line Item Picklist. |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Used for picking from Order Entry - Line Item Picklist. |
Order Organization Name |
OrderOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Order Entry - Line Item Picklist. |
Order Type |
OrderType |
DTYPE_TEXT |
50 |
No |
Used for picking from Order Entry - Line Item Picklist. |
Person Id |
PersonId |
DTYPE_ID |
15 |
No |
Used for picking from PS PickList Project Resource. |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
Used for picking from Order Entry - Product PickList. |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking from Order Entry - Product PickList. |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Used for picking from Order Entry - Product PickList. |
Product Organization Name |
ProductOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Order Entry - Product PickList. |
Product Vendor Organization Name |
ProductVendorOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Order Entry - Product PickList. |
Project Id |
ProjectId |
DTYPE_ID |
15 |
No |
Used for picking from Picklist Project. |
Project Integration Id |
ProjectIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking from Picklist Project. |
Project Item Id |
ProjectItemId |
DTYPE_ID |
15 |
No |
Used for picking from Project Item PickList. |
Project Item Number |
ProjectItemNumber |
DTYPE_TEXT |
30 |
No |
Used for picking from Project Item PickList. |
Project Number |
ProjectNumber |
DTYPE_TEXT |
30 |
No |
Used for picking from Picklist Project. |
Project Organization Name |
ProjectOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Picklist Project. |
Project Resource Id |
ProjectResourceId |
DTYPE_ID |
15 |
No |
Used for picking from PS PickList Project Resource. |
Project Resource Number |
ProjectResourceNumber |
DTYPE_TEXT |
30 |
No |
Used for picking from PS PickList Project Resource. |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
15 |
No |
Used for picking from Service Request Picklist. |
Service Request Number |
ServiceRequestNumber |
DTYPE_TEXT |
64 |
No |
Used for picking from Service Request Picklist. |
Service Request Organization Name |
ServiceRequestOrganizationName |
DTYPE_TEXT |
100 |
No |
Used for picking from Service Request Picklist. |
Surcharge Amount |
SurchargeAmount |
DTYPE_CURRENCY |
22 |
No |
None |
Tax Amount |
TaxAmount |
DTYPE_CURRENCY |
22 |
No |
None |
Unit of Measure |
UnitofMeasure |
DTYPE_TEXT |
30 |
Yes |
Bound by UNIT_OF_MEASURE LOV. |
External Opportunity Create/External Opportunity Query/External Opportunity Update
The External Opportunity Create/External Opportunity Query/External Opportunity Update ASI facilitates the inbound and outbound transfer of opportunity data and associated child-level data such as contacts, notes, revenues, and activities. It is based on the Opportunity business object and supports the create, update, and query functions. The Opportunity Sharing ASIs are as follows:
The following image describes the structure of the External Opportunity Create/External Opportunity Query/External Opportunity Update ASI.

ANI Opportunity Message (PRM ANI)
The ANI Opportunity Message (PRM ANI) ASI is the main interface for the Opportunity Sharing ASI, which encapsulates these ASIs (Opportunity, Opportunity Account, ANI Message Header, Destination Channel Partner, and Source Organization) and the associated data contained in the ASIs.
The following table lists the primary integration components of ANI Opportunity Message (PRM ANI).
Table ANI Opportunity Message (PRM ANI) Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Account |
Account |
No user keys. |
Account_Business Address |
Account_BusinessAddress |
|
Action |
Action |
|
Channel Partner |
ChannelPartner |
|
Channel Partner Business Address |
ChannelPartnerAddress |
|
Contact |
Contact |
|
Contact_Account |
Contact_Account |
|
Contact_Account_Business Address |
Contact_Account_BusinessAddress |
|
Contact_Personal Address |
Contact_PersonalAddress |
|
Message Details |
MessageDetails |
No user keys. |
Opportunity |
Opportunity |
|
Opportunity Note |
OpportunityNote |
|
Opportunity_Business Address |
OpportunityBusinessAddress |
|
Organization |
Organization |
|
Organization Business Address |
OrganizationAddress |
|
Revenue |
Revenue |
|
Transfer Details |
TransferDetails |
No user keys. |
The following table lists the fields and their attributes.
Table ANI Opportunity Message (PRM ANI) ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Account |
||||
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
No |
Customer Account Group |
CustomerAccountGroup |
DTYPE_TEXT |
30 |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Group Type Code |
GroupTypeCode |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Location |
Location |
DTYPE_TEXT |
50 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Party Type Code |
PartyTypeCode |
DTYPE_TEXT |
30 |
No |
Account_Business Address |
||||
Address Name |
AddressName |
DTYPE_TEXT |
100 |
No |
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Phone Number |
PhoneNumber |
DTYPE_TEXT |
40 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
Street Address 2 |
StreetAddress2 |
DTYPE_TEXT |
100 |
No |
Action |
||||
Comment |
Comment |
DTYPE_TEXT |
1,500 |
No |
Description |
Description |
DTYPE_TEXT |
100 |
No |
Done |
Done |
DTYPE_TEXT |
50 |
No |
Due |
Due |
DTYPE_TEXT |
50 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Planned |
Planned |
DTYPE_TEXT |
50 |
No |
Planned Completion |
PlannedCompletion |
DTYPE_TEXT |
50 |
No |
Priority |
Priority |
DTYPE_TEXT |
30 |
No |
Started |
Started |
DTYPE_TEXT |
50 |
No |
Status |
Status |
DTYPE_TEXT |
50 |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
Channel Partner |
||||
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Location |
Location |
DTYPE_TEXT |
50 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Channel Partner Business Address |
||||
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
Address Name |
AddressName |
DTYPE_TEXT |
100 |
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 |
Phone Number |
PhoneNumber |
DTYPE_TEXT |
40 |
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 |
Contact |
||||
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Cellular Phone # |
CellularPhone |
DTYPE_TEXT |
40 |
No |
Comment |
Comment |
DTYPE_TEXT |
255 |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
Fax Phone # |
FaxPhone |
DTYPE_TEXT |
40 |
No |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
Home Phone # |
HomePhone |
DTYPE_TEXT |
40 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
No |
Last Name |
LastName |
DTYPE_TEXT |
50 |
No |
M/M |
MM |
DTYPE_TEXT |
15 |
No |
Middle Name |
MiddleName |
DTYPE_TEXT |
50 |
No |
Primary Account Name |
PrimaryAccountName |
DTYPE_TEXT |
100 |
No |
Work Phone # |
WorkPhone |
DTYPE_TEXT |
40 |
No |
Contact_Account |
||||
Account |
Name |
DTYPE_TEXT |
100 |
No |
Account Location |
Location |
DTYPE_TEXT |
50 |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
No |
Customer Account Group |
CustomerAccountGroup |
DTYPE_TEXT |
30 |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Group Type Code |
GroupTypeCode |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Party Type Code |
PartyTypeCode |
DTYPE_TEXT |
30 |
No |
Contact_Account_Business Address |
||||
Address Name |
AddressName |
DTYPE_TEXT |
100 |
No |
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Phone Number |
PhoneNumber |
DTYPE_TEXT |
40 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
Street Address 2 |
StreetAddress2 |
DTYPE_TEXT |
100 |
No |
Contact_Personal Address |
||||
Address Name |
AddressName |
DTYPE_TEXT |
100 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Personal City |
PersonalCity |
DTYPE_TEXT |
50 |
No |
Personal Country |
PersonalCountry |
DTYPE_TEXT |
50 |
No |
Personal Postal Code |
PersonalPostalCode |
DTYPE_TEXT |
30 |
No |
Personal State |
PersonalState |
DTYPE_TEXT |
10 |
No |
Personal Street Address |
PersonalStreetAddress |
DTYPE_TEXT |
200 |
No |
Personal Street Address 2 |
PersonalStreetAddress2 |
DTYPE_TEXT |
100 |
No |
Message Details |
||||
External Id |
ExternalId |
DTYPE_TEXT |
250 |
No |
External Id Description |
ExternalIdDescription |
DTYPE_TEXT |
50 |
No |
Internal Id |
InternalId |
DTYPE_TEXT |
250 |
No |
Internal Id Description |
InternalIdDescription |
DTYPE_TEXT |
50 |
No |
Message Generation Time Stamp |
MessageGenerationTimeStamp |
DTYPE_DATETIME |
50 |
No |
Method |
Method |
DTYPE_TEXT |
50 |
No |
Redirection URL |
RedirectionURL |
DTYPE_TEXT |
50 |
No |
Opportunity |
||||
Account |
AccountName |
DTYPE_TEXT |
100 |
No |
Account Id |
AccountId |
DTYPE_TEXT |
30 |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Account Location |
AccountLocation |
DTYPE_TEXT |
50 |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Parent Opportunity Name |
ParentOpportunityName |
DTYPE_TEXT |
100 |
No |
Primary Revenue Amount |
PrimaryRevenueAmount |
DTYPE_TEXT |
22 |
No |
Primary Revenue Class |
PrimaryRevenueClass |
DTYPE_TEXT |
30 |
No |
Primary Revenue Close Date |
PrimaryRevenueCloseDate |
DTYPE_DATETIME |
50 |
No |
Primary Revenue Type |
PrimaryRevenueType |
DTYPE_TEXT |
30 |
No |
Primary Revenue Win Probability |
PrimaryRevenueWinProbability |
DTYPE_NUMBER |
22 |
No |
Sales Method |
SalesMethod |
DTYPE_TEXT |
30 |
No |
Sales Stage |
SalesStage |
DTYPE_TEXT |
30 |
No |
Opportunity Note |
||||
Id |
Id |
DTYPE_ID |
30 |
No |
Note |
Note |
DTYPE_NOTE |
1,000 |
No |
Note Type |
NoteType |
DTYPE_TEXT |
30 |
No |
Opportunity Name |
OpportunityName |
DTYPE_TEXT |
100 |
No |
Opportunity_Business Address |
||||
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Stree Address Line 2 |
StreetAddressLine2 |
DTYPE_TEXT |
100 |
No |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
Organization |
||||
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Id |
Id |
DTYPE_ID |
15 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Organization Business Address |
||||
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
Integration Id |
Integration Id |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
Street Address 2 |
StreetAddress2 |
DTYPE_TEXT |
100 |
No |
Revenue |
||||
Account |
Account |
DTYPE_TEXT |
100 |
No |
Account Location |
AccountLocation |
DTYPE_TEXT |
50 |
No |
Committed |
Committed |
DTYPE_TEXT |
1 |
No |
Currency Code |
CurrencyCode4 |
DTYPE_TEXT |
20 |
No |
Date |
Date |
DTYPE_DATETIME |
50 |
No |
Description |
Description |
DTYPE_TEXT |
100 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
50 |
No |
Price |
Price |
DTYPE_TEXT |
22 |
No |
Product |
Product |
DTYPE_TEXT |
50 |
No |
Quantity |
Quantity |
DTYPE_NUMBER |
22 |
No |
Revenue |
Revenue |
DTYPE_TEXT |
22 |
No |
Revenue Class |
RevenueClass |
DTYPE_TEXT |
30 |
No |
Revenue Item Number |
RevenueItemNumber |
DTYPE_TEXT |
30 |
No |
Revenue Type |
RevenueType |
DTYPE_TEXT |
30 |
No |
Summary |
Summary |
DTYPE_TEXT |
1 |
No |
Win Probability |
WinProbability |
DTYPE_NUMBER |
22 |
No |
Transfer Details |
||||
Transfer Date |
TransferDate |
DTYPE_DATETIME |
50 |
No |
Transfer Recipient |
TransferRecipient |
DTYPE_TEXT |
20 |
No |
Transfer Status |
TransferStatus |
DTYPE_TEXT |
50 |
No |
Transfer Status Message |
TransferStatusMessage |
DTYPE_TEXT |
200 |
No |
ANI Message Header (PRM ANI)
The ANI Message Header ASI (PRM ANI) encapsulates information related to the exchange of the Opportunity Sharing message, such as whether the creation or update of the opportunity was successful.
The following table lists the primary integration components of ANI Message Header (PRM ANI).
Table ANI Message Header (PRM ANI) Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Message Details |
MessageDetails |
No user keys. |
Transfer Details |
TransferDetails |
No user keys. |
The following table lists the fields and their attributes.
Table ANI Message Header (PRM ANI) ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Message Details |
||||
External Id |
ExternalId |
DTYPE_TEXT |
Not applicable |
No |
External Id Description |
ExternalIdDescription |
DTYPE_TEXT |
Not applicable |
No |
Internal Id |
InternalId |
DTYPE_TEXT |
Not applicable |
No |
Internal Id Description |
InternalIdDescription |
DTYPE_TEXT |
Not applicable |
No |
Message Generation Time Stamp |
MessageGenerationTimeStamp |
DTYPE_DATETIME |
Not applicable |
No |
Method |
Method |
DTYPE_TEXT |
Not applicable |
No |
Redirection URL |
RedirectionURL |
DTYPE_TEXT |
Not applicable |
No |
Transfer Details |
||||
Transfer Date |
TransferDate |
DTYPE_DATETIME |
Not applicable |
No |
Transfer Recipient |
TransferRecipient |
DTYPE_TEXT |
Not applicable |
No |
Transfer Status |
TransferStatus |
DTYPE_TEXT |
Not applicable |
No |
Transfer Status Message |
TransferStatusMessage |
DTYPE_TEXT |
Not applicable |
No |
Opportunity (PRM ANI)
The Opportunity (PRM ANI) ASI encapsulates all the data that is directly related to the Opportunity object. This data includes fields such as Opportunity Name, Status, and so on.
The following table lists the primary integration components of Opportunity (PRM ANI).
Table Opportunity (PRM ANI) Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Action |
Action |
|
Contact |
Contact |
|
Contact_Account |
Contact_Account |
|
Contact_Account_Business Address |
Contact_Account_BusinessAddress |
|
Contact_Personal Address |
Contact_PersonalAddress |
|
Opportunity |
Opportunity |
|
Opportunity Note |
OpportunityNote |
|
Opportunity_Business Address |
OpportunityBusinessAddress |
|
Revenue |
Revenue |
|
The following table lists the fields and their attributes.
Table Opportunity (PRM ANI) ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Action |
||||
Comment |
Comment |
DTYPE_TEXT |
1,500 |
No |
Description |
Description |
DTYPE_TEXT |
100 |
No |
Done |
Done |
DTYPE_TEXT |
50 |
No |
Due |
Due |
DTYPE_TEXT |
50 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Planned |
Planned |
DTYPE_TEXT |
50 |
No |
Planned Completion |
PlannedCompletion |
DTYPE_TEXT |
50 |
No |
Priority |
Priority |
DTYPE_TEXT |
30 |
No |
Started |
Started |
DTYPE_TEXT |
50 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
Contact |
||||
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Cellular Phone # |
CellularPhone |
DTYPE_TEXT |
40 |
No |
Comment |
Comment |
DTYPE_TEXT |
255 |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
Fax Phone # |
FaxPhone |
DTYPE_TEXT |
40 |
No |
First Name |
FirstName |
DTYPE_TEXT |
50 |
No |
Home Phone # |
HomePhone |
DTYPE_TEXT |
40 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Job Title |
JobTitle |
DTYPE_TEXT |
75 |
No |
Last Name |
LastName |
DTYPE_TEXT |
50 |
No |
M/M |
MM |
DTYPE_TEXT |
15 |
No |
Middle Name |
MiddleName |
DTYPE_TEXT |
50 |
No |
Primary Account Name |
PrimaryAccountName |
DTYPE_TEXT |
100 |
No |
Work Phone # |
WorkPhone |
DTYPE_TEXT |
40 |
No |
Contact_Account |
||||
Account |
Name |
DTYPE_TEXT |
100 |
No |
Account Location |
Location |
DTYPE_TEXT |
50 |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
No |
Customer Account Group |
CustomerAccountGroup |
DTYPE_TEXT |
30 |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Group Type Code |
GroupTypeCode |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Party Type Code |
PartyTypeCode |
DTYPE_TEXT |
30 |
No |
Contact_Account_Business Address |
||||
Address Name |
AddressName |
DTYPE_TEXT |
100 |
No |
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Phone Number |
PhoneNumber |
DTYPE_TEXT |
40 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
Street Address 2 |
StreetAddress2 |
DTYPE_TEXT |
100 |
No |
Contact_Personal Address |
||||
Address Name |
AddressName |
DTYPE_TEXT |
100 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Personal City |
PersonalCity |
DTYPE_TEXT |
50 |
No |
Personal Country |
PersonalCountry |
DTYPE_TEXT |
50 |
No |
Personal Postal Code |
PersonalPostalCode |
DTYPE_TEXT |
30 |
No |
Personal State |
PersonalState |
DTYPE_TEXT |
10 |
No |
Personal Street Address |
PersonalStreetAddress |
DTYPE_TEXT |
200 |
No |
Personal Street Address 2 |
PersonalStreetAddress2 |
DTYPE_TEXT |
100 |
No |
Opportunity |
||||
Account |
AccountName |
DTYPE_TEXT |
100 |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Account Location |
AccountLocation |
DTYPE_TEXT |
50 |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Parent Opportunity Name |
ParentOpportunityName |
DTYPE_TEXT |
100 |
No |
Primary Revenue Amount |
PrimaryRevenueAmount |
DTYPE_TEXT |
22 |
No |
Primary Revenue Class |
PrimaryRevenueClass |
DTYPE_TEXT |
30 |
No |
Primary Revenue Close Date |
PrimaryRevenueCloseDate |
DTYPE_DATETIME |
50 |
No |
Primary Revenue Type |
PrimaryRevenueType |
DTYPE_TEXT |
30 |
No |
Primary Revenue Win Probability |
PrimaryRevenueWinProbability |
DTYPE_NUMBER |
22 |
No |
Sales Method |
SalesMethod |
DTYPE_TEXT |
30 |
No |
Sales Stage |
SalesStage |
DTYPE_TEXT |
30 |
No |
Opportunity Note |
||||
Id |
Id |
DTYPE_ID |
30 |
No |
Note |
Note |
DTYPE_NOTE |
1,000 |
No |
Note Type |
NoteType |
DTYPE_TEXT |
30 |
No |
Opportunity Name |
OpportunityName |
DTYPE_TEXT |
100 |
No |
Opportunity_Business Address |
||||
Address Name |
AddressName |
DTYPE_TEXT |
50 |
No |
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Stree Address Line 2 |
StreeAddressLine2 |
DTYPE_TEXT |
100 |
No |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
Revenue |
||||
Account |
Account |
DTYPE_TEXT |
100 |
No |
Account Location |
AccountLocation |
DTYPE_TEXT |
50 |
No |
Committed |
Committed |
DTYPE_TEXT |
1 |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
Date |
Date |
DTYPE_DATETIME |
50 |
No |
Description |
Description |
DTYPE_TEXT |
100 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
50 |
No |
Price |
Price |
DTYPE_TEXT |
22 |
No |
Product |
Product |
DTYPE_TEXT |
50 |
No |
Quantity |
Quantity |
DTYPE_NUMBER |
22 |
No |
Revenue |
Revenue |
DTYPE_TEXT |
22 |
No |
Revenue Class |
RevenueClass |
DTYPE_TEXT |
30 |
No |
Revenue Item Number |
RevenueItemNumber |
DTYPE_TEXT |
30 |
No |
Revenue Type |
RevenueType |
DTYPE_TEXT |
30 |
No |
Summary |
Summary |
DTYPE_TEXT |
1 |
No |
Win Probability |
WinProbability |
DTYPE_NUMBER |
22 |
No |
Destination Channel Partner (PRM ANI)
The Destination Channel Partner (PRM ANI) ASI encapsulates information related to the partner company with which the opportunity is being shared. Examples of this information include Partner DUNS Number and Company Name.
The following table lists the primary integration components of Destination Channel Partner (PRM ANI).
Table Destination Channel Partner (PRM ANI) Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Channel Partner |
ChannelPartner |
|
Channel Partner Business Address |
ChannelPartnerAddress |
|
The following table lists the fields and their attributes.
Table Destination Channel Partner (PRM ANI) ASI Fields
Name | XML Tag | Data Type | Length | Required |
---|---|---|---|---|
Channel Partner |
||||
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Location |
Location |
DTYPE_TEXT |
50 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Channel Partner Business Address |
||||
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
Address Name |
AddressName |
DTYPE_TEXT |
100 |
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 |
Phone Number |
PhoneNumber |
DTYPE_TEXT |
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 |
Source Organization (PRM ANI)
The Source Organization (PRM ANI) ASI encapsulates information related to the source company that is initiating the create or update opportunity message. Examples of this information include Partner DUNS Number, Company Name, and so on.
The following table lists the primary integration components of Source Organization (PRM ANI).
Table Source Organization (PRM ANI) Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Organization |
Organization |
|
Organization Business Address |
OrganizationAddress |
|
The following table lists the fields and their attributes.
Table Source Organization (PRM ANI) ASI Fields
Name | XML Tag | Data Type | Length | Required |
---|---|---|---|---|
Organization |
||||
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Id |
Id |
DTYPE_ID |
15 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Organization Business Address |
||||
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
Address Name |
AddressName |
DTYPE_TEXT |
100 |
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 |
Phone Number |
PhoneNumber |
DTYPE_TEXT |
Not applicable |
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 |
Opportunity Account (PRM ANI)
The Opportunity Account (PRM ANI) ASI encapsulates account-related information for all the opportunity accounts identified in the opportunity message.
The following table lists the primary integration components of Opportunity Account (PRM ANI).
Table Opportunity Account (PRM ANI) Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Account |
Account |
|
Account Business Address |
Account_BusinessAddress |
|
The following table lists the fields and their attributes.
Table Opportunity Account (PRM ANI) ASI Fields
Name | XML Tag | Data Type | Length | Required |
---|---|---|---|---|
Account |
||||
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
No |
Customer Account Group |
CustomerAccountGroup |
DTYPE_TEXT |
30 |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Group Type Code |
GroupTypeCode |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Location |
Location |
DTYPE_TEXT |
50 |
No |
Name |
Name |
DTYPE_TEXT |
100 |
No |
Party Type Code |
PartyTypeCode |
DTYPE_TEXT |
30 |
No |
Account Business Address |
||||
Address Name |
AddressName |
DTYPE_TEXT |
100 |
No |
City |
City |
DTYPE_TEXT |
50 |
No |
Country |
Country |
DTYPE_TEXT |
50 |
No |
Email Address |
EmailAddress |
DTYPE_TEXT |
50 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Phone Number |
PhoneNumber |
DTYPE_TEXT |
40 |
No |
Postal Code |
PostalCode |
DTYPE_TEXT |
30 |
No |
State |
State |
DTYPE_TEXT |
10 |
No |
Street Address |
StreetAddress |
DTYPE_TEXT |
200 |
No |
Street Address 2 |
StreetAddress2 |
DTYPE_TEXT |
100 |
No |
Siebel Order
The Siebel Order ASI allows customers to accurately capture and validate orders in order to submit them to a fulfillment system. The following image describes the structure of the Siebel Order ASI.

The following table lists the integration components of this ASI.
Table Siebel Order Integration Components
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 Item |
ShipmentItem |
|
The Siebel Order ASI uses the same user keys as the Orders integration component. You can use the component fields for the integration, which means that values for each of these fields can be written to an XML file for transport. The following table lists the fields and their attributes.
Table Siebel Order ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
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 |
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 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 Id |
BillingAccountId |
DTYPE_ID |
NA |
No |
Cancelled Quantity |
CancelledQuantity |
DTYPE_NUMBER |
NA |
No |
Carrier Priority |
CarrierPriority |
DTYPE_TEXT |
30 |
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 |
Extended Quantity |
ExtendedQuantity |
DTYPE_NUMBER |
NA |
No |
Freight Amount |
FreightAmount |
DTYPE_TEXT |
NA |
No |
Has Children |
HasChildren |
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 |
IsComplexProduct |
IsComplexProduct |
DTYPE_TEXT |
NA |
No |
Item Price |
ItemPrice |
DTYPE_TEXT |
NA |
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 |
Parent Order Item Number |
ParentOrderItemNumber |
DTYPE_NUMBER |
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 Port Id |
ProductPortId |
DTYPE_ID |
15 |
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 |
Rollup Item Price |
RollupItemPrice |
DTYPE_TEXT |
NA |
No |
Root Order Item Id |
RootOrderItemId |
DTYPE_ID |
NA |
No |
Sales Unit of Measure |
SalesUnitofMeasure |
DTYPE_TEXT |
30 |
No |
Ship Complete |
ShipComplete |
DTYPE_TEXT |
NA |
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 Price |
UnitPrice |
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 |
||||
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 |
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 |
30 |
No |
Transaction Time |
TransactionTime |
DTYPE_TEXT |
30 |
No |
Verification Number |
VerificationNumber |
DTYPE_TEXT |
10 |
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 |
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 |
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 |
Related Shipment |
||||
Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Destination Inventory Location Id |
DestinationInventoryId |
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 |
SourceInventoryId |
DTYPE_ID |
15 |
No |
Waybill Number |
WaybillNumber |
DTYPE_TEXT |
50 |
No |
operation |
operation |
DTYPE_TEXT |
NA |
No |
Shipment Item |
||||
Confirmed Qty |
ConfirmedQty |
DTYPE_NUMBER |
NA |
No |
Delivery Date |
DeliveryDate |
DTYPE_DATETIME |
NA |
No |
Delivery Qty |
DeliveryQty |
DTYPE_NUMBER |
NA |
No |
Id |
Id |
DTYPE_ID |
NA |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
NA |
No |
Order Line Id |
OrderLineId |
DTYPE_ID |
NA |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Shipment Date |
ShipmentDate |
DTYPE_DATETIME |
NA |
No |
Shipment Line Number |
ShipmentLineNumber |
DTYPE_TEXT |
NA |
No |
Shipment Qty |
ShipmentQty |
DTYPE_NUMBER |
NA |
No |
operation |
operation |
DTYPE_TEXT |
NA |
No |
Siebel Position
The Siebel Position ASI is based on the Position Interface integration object, which is based on the Position integration component and the Position business component. The following image describes the Siebel Position ASI structure.

The following table lists the integration components and user keys of this ASI.
Table Siebel Position Integration Components
Integration Component | Business Component | XML Tag | User Keys |
---|---|---|---|
Position |
Position |
Position |
|
The Siebel Position ASI uses the same user keys as the Position Interface integration component and has 19 fields. You can use these fields for the integration, which means that values for each of these fields may be written to an XML file for transport. The following table lists the fields and their attributes.
Table Siebel Position ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Billing Product |
BillingProduct |
DTYPE_TEXT |
100 |
No |
Billing Product Id |
BillingProductId |
DTYPE_ID |
Not applicable |
No |
Billing Product Integration Id |
BillingProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Compensatable |
Compensatable |
DTYPE_TEXT |
Not applicable |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Division |
Division |
DTYPE_TEXT |
255 |
Yes |
Division Id |
DivisionId |
DTYPE_ID |
Not applicable |
Yes |
Division Integration Id |
DivisionIntegrationId |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Name |
Name |
DTYPE_TEXT |
50 |
Yes |
Organization |
Organization |
DTYPE_TEXT |
255 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
Not applicable |
No |
Organization Integration Id |
OrganizationIntegrationId |
DTYPE_TEXT |
30 |
No |
Parent Position Id |
ParentPositionId |
DTYPE_ID |
Not applicable |
No |
Parent Position Integration Id |
ParentPositionIntegrationId |
DTYPE_TEXT |
30 |
No |
Parent Position Name |
ParentPositionName |
DTYPE_TEXT |
50 |
No |
Position Type |
PositionType |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Siebel Price List
A price list is a set of standard prices for products and services. Price lists contain the prices a buyer first sees, before any pricing adjustments have occurred. A product must be assigned a price in a given price list in order to appear in a catalog and to become visible to customers.
A product’s price, as defined in the price list, is commonly used as a starting price for other prices generated by the Siebel Pricer application.
This inbound ASI enables the synchronization and update of a price list and the price list items. The following image describes the Siebel Price List ASI structure.

The following table lists the integration components and user keys of this ASI.
Table Siebel Price List Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Price List |
PriceList |
|
Price List Item |
PriceListItem |
|
Price List_Organization |
PriceList_Organization |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length.
Table Siebel Price List ASI Fields
Name | XML Tag | Data Type | Length | Req. | Note |
---|---|---|---|---|---|
Price List |
|||||
Currency Code |
CurrencyCode |
DTYPE_TEXT |
15 |
No |
None |
Description |
Description |
DTYPE_TEXT |
255 |
No |
None |
End Date |
EndDate |
DTYPE_TEXT |
No |
None |
|
Freight Terms |
FreightTerms |
DTYPE_TEXT |
30 |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
Used for picking a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Name |
Name |
DTYPE_TEXT |
50 |
No |
None |
Payment Term |
PaymentTerm |
DTYPE_TEXT |
50 |
No |
None |
Payment Term Id |
PaymentTermId |
DTYPE_ID |
No |
Used for picking a related entity. |
|
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
50 |
No |
None |
Primary Organization Id |
PrimaryOrganizationId |
DTYPE_ID |
No |
Used for picking a related entity. |
|
Shipping Method |
ShippingMethod |
DTYPE_TEXT |
30 |
No |
None |
Start Date |
StartDate |
DTYPE_TEXT |
No |
None |
|
Type |
Type |
DTYPE_TEXT |
30 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
Price List Item |
|||||
End Date |
EndDate |
DTYPE_TEXT |
No |
None |
|
Id |
Id |
DTYPE_ID |
30 |
No |
Used for picking a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
List Price Type Code |
ListPriceTypeCode |
DTYPE_TEXT |
30 |
No |
None |
Original List Price |
OriginalListPrice |
DTYPE_TEXT |
No |
None |
|
Price List Id |
PriceListId |
DTYPE_ID |
No |
Used for picking a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. |
|
Product Id |
ProductId |
DTYPE_ID |
No |
Used for picking a related entity. |
|
Promotional Price |
PromotionalPrice |
DTYPE_TEXT |
No |
None |
|
Start Date |
StartDate |
DTYPE_TEXT |
No |
None |
|
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
Price List_Organization |
|||||
Division Id |
DivisionId |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
operation |
operation |
DTYPE_TEXT |
30 |
No |
None |
Siebel Quote/External Quote
The Siebel Quote/External Quote ASI is an ASI for quote and order management-related business processes. This ASI facilitates the transfer of quote data between the Siebel application and any external system. The following image shows the Siebel Quote/External Quote ASI structure.

The following table lists the integration components and user keys for this ASI.
Table Siebel Quote/External Quote Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Quote |
Quote |
|
Attributes |
Attribute |
|
Line Items |
LineItems |
|
Promised Schedule Lines |
PromisedScheduleLines |
|
Related Order |
RelatedOrder |
|
Related Organization |
RelatedOrganization |
|
Related Service Agreement |
RelatedServiceAgreement |
|
Requested Schedule Lines |
RequestedScheduleLines |
|
The following table lists the fields and their attributes for this ASI.
Table Siebel Quote/External Quote ASI Fields
Name | XML Tag | Data Type | Length | Req. | Note |
---|---|---|---|---|---|
Quote |
|||||
Account |
Account |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. |
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
None |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Account Site |
AccountSite |
DTYPE_TEXT |
50 |
No |
Used for picking a related entity. |
Active |
Active |
DTYPE_BOOL |
1 |
No |
None |
Available Date |
AvailableDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
None |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Bill To Account |
BillToAccount |
DTYPE_TEXT |
100 |
No |
None |
Bill To Account Id |
BillToAccountId |
DTYPE_ID |
15 |
No |
None |
Bill To Account Integration Id |
BillToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Bill To Account Site |
BillToAccountSite |
DTYPE_TEXT |
50 |
No |
None |
Bill To Address Id |
BillToAddressId |
DTYPE_ID |
15 |
No |
None |
Bill To Address Integration Id |
BillToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Bill To Contact Last Name |
BillToContactLastName |
DTYPE_TEXT |
50 |
No |
None |
Bill To Contact First Name |
BillToContactFirstName |
DTYPE_TEXT |
50 |
No |
None |
Bill To Contact Id |
BillToContactId |
DTYPE_ID |
15 |
No |
Used for picking a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. |
Bill To Contact Integration Id |
BillToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Bound by FS_CARRIER LOV. |
Carrier Priority |
CarrierPriority |
DTYPE_TEXT |
30 |
No |
Bound by CARRIER_PRIORITY LOV. |
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
No |
None |
Contact Id |
ContactId |
DTYPE_ID |
15 |
No |
None |
Contact Integration Id |
ContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
No |
Used for picking a related entity. |
Credit Card Expiration Month |
CreditCardExpirationMonth |
DTYPE_TEXT |
30 |
No |
Bound by MONTH_NUMBER LOV. |
Credit Card Expiration Year |
CreditCardExpirationYear |
DTYPE_TEXT |
30 |
No |
Bound by YEAR LOV. |
Credit Card Holder |
CreditCardHolder |
DTYPE_TEXT |
50 |
No |
None |
Credit Card Name |
CreditCardName |
DTYPE_TEXT |
50 |
No |
Used for picking a related entity. |
Credit Card Number |
CreditCardNumber |
DTYPE_TEXT |
50 |
No |
Used for picking a related entity. |
Credit Status |
CreditStatus |
DTYPE_TEXT |
30 |
No |
Bound by ACCT_CRDT_STAT_TYPE LOV. |
Credit Status As Of Date |
CreditStatusAsOfDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Credit Status Message |
CreditStatusMessage |
DTYPE_TEXT |
250 |
No |
None |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
Yes |
Used for picking a related entity. |
Description |
Description |
DTYPE_TEXT |
255 |
No |
None |
Discount Amount |
DiscountAmount |
DTYPE_CURRENCY |
22, 7 |
No |
None |
Due Date |
DueDate |
DTYPE_DATE |
7 |
No |
None |
Effective Date |
EffectiveDate |
DTYPE_DATE |
7 |
No |
None |
Expiration Date |
ExpirationDate |
DTYPE_DATE |
7 |
No |
None |
Id |
Id |
DTYPE_ID |
15 |
No |
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. User key field for Quote. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field for Quote. |
Integration Message |
IntegrationMessage |
DTYPE_TEXT |
2,000 |
No |
None |
Integration Status |
IntegrationStatus |
DTYPE_TEXT |
30 |
No |
Bound by EAI_ORDER_SYNC_STATUS LOV. |
Integration Status As Of Date |
IntegrationStatusAsOfDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Name |
Name |
DTYPE_TEXT |
50 |
Yes |
None |
Opportunity Id |
OpportunityId |
DTYPE_ID |
15 |
No |
None |
Opportunity Integration Id |
OpportunityIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Opportunity Name |
OpportunityName |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. |
Payment Method |
PaymentMethod |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Payment Term |
PaymentTerm |
DTYPE_TEXT |
50 |
No |
Used for picking a related entity. |
Payment Term Id |
PaymentTermId |
DTYPE_ID |
15 |
No |
None |
Payment Term Integration Id |
PaymentTermIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Price List |
PriceList |
DTYPE_TEXT |
50 |
No |
Used for picking a related entity. |
Price List Id |
PriceListId |
DTYPE_ID |
15 |
No |
Used for picking a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. |
Price List Integration Id |
PriceListIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
User key field for Quote. |
Quote Number |
QuoteNumber |
DTYPE_TEXT |
30 |
No |
User key field for Quote. |
Quote Type |
QuoteType |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Requested Date |
RequestedDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Revision |
Revision |
DTYPE_INTEGER |
22, 7 |
No |
User key field for Quote. |
Ship Complete |
ShipComplete |
DTYPE_BOOL |
1 |
No |
None |
Ship To Account |
ShipToAccount |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. |
Ship To Account Id |
ShipToAccountId |
DTYPE_ID |
15 |
No |
None |
Ship To Account Integration Id |
ShipToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Ship To Account Site |
ShipToAccountSite |
DTYPE_TEXT |
50 |
No |
None |
Ship To Address Id |
ShipToAddressId |
DTYPE_ID |
15 |
No |
Used for picking a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. |
Ship To Address Integration Id |
ShipToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Ship To Contact First Name |
ShipToContactFirstName |
DTYPE_TEXT |
50 |
No |
None |
Ship To Contact Id |
ShipToContactId |
DTYPE_ID |
15 |
No |
Used for picking a related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. |
Ship To Contact Integration Id |
ShipToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Ship To Contact Last Name |
ShipToContactLastName |
DTYPE_TEXT |
50 |
No |
None |
Shipping Charges |
ShippingCharges |
DTYPE_CURRENCY |
22, 7 |
No |
None |
Shipping Info |
ShippingInfo |
DTYPE_TEXT |
250 |
No |
None |
Shipping Terms |
ShippingTerms |
DTYPE_TEXT |
30 |
No |
Bound by FREIGHT_TERMS LOV. |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
15 |
No |
None |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Status |
Status |
DTYPE_TEXT |
30 |
Yes |
Bound by FS_ORDER_STATUS LOV. |
Status As Of Date |
StatusAsOfDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Tax Amount |
TaxAmount |
DTYPE_CURRENCY |
22, 7 |
No |
None |
Tax Exempt |
TaxExempt |
DTYPE_BOOL |
1 |
No |
None |
Tax Exemption Code |
TaxExemptionCode |
DTYPE_TEXT |
80 |
No |
Bound by GLOBAL_TAX_EXEMPTION LOV. |
Tax Exemption Id |
TaxExemptionId |
DTYPE_TEXT |
30 |
No |
None |
Tax Rate |
TaxRate |
DTYPE_NUMBER |
22, 7 |
No |
None |
Operation |
Operation |
DTYPE_TEXT |
30 |
No |
System field. |
Attributes |
|||||
Action Code |
ActionCode |
DTYPE_TEXT |
30 |
No |
None |
Attribute Id |
AttributeId |
DTYPE_ID |
15 |
No |
None |
Data Type |
DataType |
DTYPE_TEXT |
30 |
No |
Bound by XA_ATTR_DTYPE LOV. |
Description |
Description |
DTYPE_TEXT |
250 |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. User key field for Attributes. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field for Attributes. |
List Of Value Type |
ListOfValueType |
DTYPE_TEXT |
30 |
No |
Bound by LOV._TYPE LOV. |
Name |
Name |
DTYPE_TEXT |
75 |
No |
User key field for Attributes. |
Value |
Value |
DTYPE_TEXT |
100 |
No |
Bound by Type. |
Operation |
Operation |
DTYPE_TEXT |
30 |
No |
System field. |
Line Items |
|||||
Action Code |
ActionCode |
DTYPE_TEXT |
30 |
No |
Bound by DELTA_ACTION_CODE LOV. |
Available Date |
AvailableDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Available Quantity |
AvailableQuantity |
DTYPE_NUMBER |
22, 7 |
No |
None |
Base Price |
BasePrice |
DTYPE_CURRENCY |
22, 7 |
No |
None |
Discount Amount |
DiscountAmount |
DTYPE_CURRENCY |
22, 7 |
No |
None |
Extended Quantity |
ExtendedQuantity |
DTYPE_NUMBER |
22, 7 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field for Line Items. |
Line Item Id |
LineItemId |
DTYPE_ID |
15 |
No |
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. User key field for Line Items. |
Line Number |
LineNumber |
DTYPE_NUMBER |
22, 7 |
Yes |
User key field for Line Items. |
Line Number 2 |
LineNumber2 |
DTYPE_NUMBER |
22, 7 |
No |
User key field for Line Items. |
Note |
Note |
DTYPE_TEXT |
1500 |
No |
None |
Package Name External |
PackageNameExternal |
DTYPE_TEXT |
100 |
No |
None |
Package Name Siebel |
PackageNameSiebel |
DTYPE_TEXT |
50 |
No |
None |
Parent Quote Item Id |
ParentQuoteItemId |
DTYPE_ID |
15 |
No |
User key field for Line Items. |
Product |
Product |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
None |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Requested Date |
RequestedDate |
DTYPE_DATE |
7 |
No |
None |
Requested Quantity |
RequestedQuantity |
DTYPE_NUMBER |
22, 7 |
Yes |
The default is 1. |
Root Quote Item Id |
RootQuoteItemId |
DTYPE_ID |
15 |
No |
User key field for Line Items. |
Ship To Account |
ShipToAccount |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. |
Ship To Account Id |
ShipToAccountId |
DTYPE_ID |
15 |
No |
None |
Ship To Account Site |
ShipToAccountSite |
DTYPE_TEXT |
50 |
No |
None |
Ship To Address Id |
ShipToAddressId |
DTYPE_ID |
15 |
No |
None |
Ship To Address Integration Id |
ShipToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Ship to Account Integration Id |
ShiptoAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Shipping Charges |
ShippingCharges |
DTYPE_CURRENCY |
22, 7 |
No |
None |
Single Source |
SingleSource |
DTYPE_BOOL |
1 |
No |
None |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
15 |
No |
None |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Start Price |
StartPrice |
DTYPE_CURRENCY |
22, 7 |
No |
None |
Tax Amount |
TaxAmount |
DTYPE_CURRENCY |
22, 7 |
No |
None |
Unit of Measure |
UnitofMeasure |
DTYPE_TEXT |
30 |
No |
None |
Operation |
Operation |
DTYPE_TEXT |
30 |
No |
System field. |
Promised Schedule Lines |
|||||
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
None |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Id |
Id |
DTYPE_ID |
30 |
No |
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. User key field for Promised Schedule Lines. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field for Promised Schedule Lines. |
Line Number |
LineNumber |
DTYPE_NUMBER |
22, 7 |
No |
User key field for Promised Schedule Lines. |
Promised Date |
PromisedDate |
DTYPE_DATE |
7 |
No |
None |
Promised Quantity |
PromisedQuantity |
DTYPE_NUMBER |
22, 7 |
No |
None |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
15 |
No |
None |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Operation |
Operation |
DTYPE_TEXT |
30 |
No |
System field. |
Related Order |
|||||
Id |
Id |
DTYPE_ID |
30 |
No |
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
|
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
Yes |
User key field for Related Order. |
Order Type |
OrderType |
DTYPE_TEXT |
30 |
Yes |
Used for picking a related entity. |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
User key field for Related Order. |
Revision |
Revision |
DTYPE_INTEGER |
22, 7 |
No |
User key field for Related Order. |
Operation |
Operation |
DTYPE_TEXT |
30 |
No |
System field. |
Related Organization |
|||||
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field for Related Organization. |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
This field determines whether this child record is the primary one. The value is determined in run time. |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
User key field for Related Organization. |
Organization Id |
OrganizationId |
DTYPE_ID |
15 |
No |
User key field for Related Organization. |
Related Service Agreement |
|||||
Account |
Account |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. User key field for Related Service Agreement. |
Id |
Id |
DTYPE_ID |
30 |
No |
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. User key field for Related Service Agreement. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field for Related Service Agreement. |
Name |
Name |
DTYPE_TEXT |
50 |
Yes |
User key field for Related Service Agreement. |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
User key field for Related Service Agreement. |
Revision |
Revision |
DTYPE_NUMBER |
22, 7 |
Yes |
User key field for Related Service Agreement. |
Operation |
Operation |
DTYPE_TEXT |
30 |
No |
System field. |
Requested Schedule Lines |
|||||
Id |
Id |
DTYPE_ID |
30 |
No |
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated. User key field for Requested Schedule Lines. |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
User key field for Requested Schedule Lines. |
Line Number |
LineNumber |
DTYPE_NUMBER |
22, 7 |
Yes |
User key field for Requested Schedule Lines. |
Requested Date |
RequestedDate |
DTYPE_UTCDATETIME |
7 |
No |
None |
Requested Quantity |
RequestedQuantity |
DTYPE_NUMBER |
22, 7 |
No |
None |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Used for picking a related entity. |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
15 |
No |
None |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Operation |
Operation |
DTYPE_TEXT |
30 |
No |
System field. |
Siebel ATP Response/External ATP Check
The Siebel ATP Response/External ATP Check ASI enables a customer to check for a quantity of goods that is available for delivery in the desired time frame, and for the price of these goods in the external system. Siebel ATP Response/External ATP Check uses two ASIs for request and response, which use the same components and field definitions. The following image describes the structure of this ASI.

The following table lists the XML tags and user keys for this ASI.
Table Siebel ATP Response/External ATP Check Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
ATP Header |
ATPHeader |
|
ATP Line Items |
ATPLineItems |
|
Attributes |
Attributes |
|
Payments |
Payments |
|
Promised Schedule Line |
PromisedScheduleLine |
|
The following table lists the fields and definitions of the Siebel ATP Response/External ATP Check ASI. Fields without a length specified do not have a maximum length associated with them.
Table Siebel ATP Response/External ATP Check ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
ATPHeader |
||||
Account |
Account |
DTYPE_TEXT |
Not applicable |
No |
Account Id |
AccountId |
DTYPE_TEXT |
Not applicable |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Available Date |
AvailableDate |
DTYPE_TEXT |
Not applicable |
No |
Available Message |
AvailableMessage |
DTYPE_TEXT |
Not applicable |
No |
Available Status |
AvailableStatus |
DTYPE_TEXT |
Not applicable |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
Not applicable |
No |
Carrier |
Carrier |
DTYPE_TEXT |
Not applicable |
No |
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
Not applicable |
No |
Contact Id |
ContactId |
DTYPE_TEXT |
Not applicable |
No |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
Not applicable |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
Not applicable |
No |
Document Type Id |
DocumentTypeId |
DTYPE_TEXT |
Not applicable |
No |
Header Number |
HeaderNumber |
DTYPE_TEXT |
Not applicable |
No |
Id |
HeaderRowId |
DTYPE_TEXT |
Not applicable |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Name |
Name |
DTYPE_TEXT |
Not applicable |
No |
Order Date |
OrderDate |
DTYPE_TEXT |
Not applicable |
No |
Order Priority |
OrderPriority |
DTYPE_TEXT |
Not applicable |
No |
Organization |
Organization |
DTYPE_TEXT |
Not applicable |
No |
Organization DUNS Number |
OrganizationDUNSNumber |
DTYPE_TEXT |
Not applicable |
No |
Organization Id |
OrganizationId |
DTYPE_TEXT |
Not applicable |
No |
Organization Integration Id |
OrganizationIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
Not applicable |
No |
Revision |
Revision |
DTYPE_NUMBER |
Not applicable |
No |
Ship Complete Flag |
ShipCompleteFlag |
DTYPE_TEXT |
Not applicable |
No |
Ship To Account |
ShipToAccount |
DTYPE_TEXT |
Not applicable |
No |
Ship To Account Id |
ShipToAccountId |
DTYPE_TEXT |
Not applicable |
No |
Ship To Account Integration Id |
ShipToAccountIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Ship To Address |
ShipToAddress |
DTYPE_TEXT |
Not applicable |
No |
Ship To Address Id |
ShipToAddressId |
DTYPE_TEXT |
Not applicable |
No |
Ship To Address Integration Id |
ShipToAddressIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Ship To City |
ShipToCity |
DTYPE_TEXT |
Not applicable |
No |
Ship To Country |
ShipToCountry |
DTYPE_TEXT |
Not applicable |
No |
Ship To First Name |
ShipToFirstName |
DTYPE_TEXT |
Not applicable |
No |
Ship To Last Name |
ShipToLastName |
DTYPE_TEXT |
Not applicable |
No |
Ship To Site |
ShipToSite |
DTYPE_TEXT |
Not applicable |
No |
Ship To State |
ShipToState |
DTYPE_TEXT |
Not applicable |
No |
Ship To Zip |
ShipToZip |
DTYPE_TEXT |
Not applicable |
No |
Shipping Method |
ShippingMethod |
DTYPE_TEXT |
Not applicable |
No |
Shipping Terms |
ShippingTerms |
DTYPE_TEXT |
Not applicable |
No |
Shipping Terms Info |
ShippingTermsInfo |
DTYPE_TEXT |
Not applicable |
No |
Single Delivery |
SingleDelivery |
DTYPE_TEXT |
Not applicable |
No |
Source Inventory Loc Id |
SourceInventoryLocId |
DTYPE_TEXT |
Not applicable |
No |
Source Inventory Loc Integration Id |
SourceInventoryLocIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
Not applicable |
No |
Time To Reserve |
TimeToReserve |
DTYPE_TEXT |
Not applicable |
No |
Time To Reserve UOM |
TimeToReserveUOM |
DTYPE_TEXT |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
ATPLineItems |
||||
ATP Message Line |
ATPMessageLine |
DTYPE_TEXT |
Not applicable |
No |
Available Date |
AvailableDate |
DTYPE_TEXT |
Not applicable |
No |
Available Quantity |
AvailableQuantity |
DTYPE_TEXT |
Not applicable |
No |
Available Status |
AvailableStatus |
DTYPE_TEXT |
Not applicable |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
Not applicable |
No |
Carrier |
Carrier |
DTYPE_TEXT |
Not applicable |
No |
Extended Quantity |
ExtendedQuantity |
DTYPE_TEXT |
Not applicable |
No |
Id |
RowId |
DTYPE_TEXT |
Not applicable |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Item Price |
ItemPrice |
DTYPE_TEXT |
Not applicable |
No |
Line Number |
LineNumber |
DTYPE_TEXT |
Not applicable |
No |
Minimum Lot Size |
MinimumLotSize |
DTYPE_TEXT |
Not applicable |
No |
Net Price |
NetPrice |
DTYPE_TEXT |
Not applicable |
No |
Package |
Package |
DTYPE_TEXT |
Not applicable |
No |
Parent Row Id |
ParentRowId |
DTYPE_TEXT |
Not applicable |
No |
Parent Row Line Number |
ParentRowLineNumber |
DTYPE_TEXT |
Not applicable |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
Not applicable |
No |
Product Global Identifier |
ProductGlobalIdentifier |
DTYPE_TEXT |
Not applicable |
No |
Product Id |
ProductId |
DTYPE_TEXT |
Not applicable |
No |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Product Status Code |
ProductStatusCode |
DTYPE_TEXT |
Not applicable |
No |
Product Unit Of Measure |
ProductUnitOfMeasure |
DTYPE_TEXT |
Not applicable |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
Not applicable |
No |
Requested Quantity |
RequestedQuantity |
DTYPE_TEXT |
Not applicable |
No |
Rollup Item Price |
RollupItemPrice |
DTYPE_TEXT |
Not applicable |
No |
Sales Unit Of Measure |
SalesUnitOfMeasure |
DTYPE_TEXT |
Not applicable |
No |
Ship Complete Flag |
ShipCompleteFlag |
DTYPE_TEXT |
Not applicable |
No |
Ship To Account Id |
ShipToAccountId |
DTYPE_TEXT |
Not applicable |
No |
Ship To Account Integration Id |
ShipToAccountIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Ship To Address |
ShipToAddress |
DTYPE_TEXT |
Not applicable |
No |
Ship To Address Id |
ShipToAddressId |
DTYPE_TEXT |
Not applicable |
No |
Ship To Address Integration Id |
ShipToAddressIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Ship To City |
ShipToCity |
DTYPE_TEXT |
Not applicable |
No |
Ship To Contact First Name |
ShipToContactFirstName |
DTYPE_TEXT |
Not applicable |
No |
Ship To Contact Last Name |
ShipToContactLastName |
DTYPE_TEXT |
Not applicable |
No |
Ship To Country |
ShipToCountry |
DTYPE_TEXT |
Not applicable |
No |
Ship To State |
ShipToState |
DTYPE_TEXT |
Not applicable |
No |
Ship To Zip |
ShipToZip |
DTYPE_TEXT |
Not applicable |
No |
Shipping Method |
ShippingMethod |
DTYPE_TEXT |
Not applicable |
No |
Shipping Terms |
ShippingTerms |
DTYPE_TEXT |
Not applicable |
No |
Single Delivery |
SingleDelivery |
DTYPE_TEXT |
Not applicable |
No |
Smart Part Number |
SmartPartNumber |
DTYPE_TEXT |
Not applicable |
No |
Source Inventory Loc Id |
SourceInventoryLocId |
DTYPE_TEXT |
Not applicable |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
Not applicable |
No |
Source Inventory Location Integration Id |
SourceInventoryLocIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Start Price |
StartPrice |
DTYPE_TEXT |
Not applicable |
No |
Time To Reserve |
TimeToReserve |
DTYPE_TEXT |
Not applicable |
No |
Time To Reserve UOM |
TimeToReserveUOM |
DTYPE_TEXT |
Not applicable |
No |
Unit Of Measure |
UnitOfMeasure |
DTYPE_TEXT |
Not applicable |
No |
Unit Price |
UnitPrice |
DTYPE_TEXT |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Attributes |
||||
Description |
AttributeDescription |
DTYPE_TEXT |
Not applicable |
No |
Id |
AttributeId |
DTYPE_ID |
Not applicable |
No |
Name |
AttributeName |
DTYPE_TEXT |
Not applicable |
No |
Value |
AttributeValue |
DTYPE_TEXT |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Payments |
||||
Credit Check Message |
CreditCheckMessage |
DTYPE_TEXT |
Not applicable |
No |
Credit Check Status |
CreditCheckStatus |
DTYPE_TEXT |
Not applicable |
No |
Credit Check Status As Of Date |
CreditCheckStatusAsOfDate |
DTYPE_TEXT |
Not applicable |
No |
Id |
Id |
DTYPE_TEXT |
Not applicable |
No |
Payment Method |
PaymentMethod |
DTYPE_TEXT |
Not applicable |
No |
Transaction Amount |
TransactionAmount |
DTYPE_TEXT |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
Not applicable |
No |
PromisedScheduleLine |
||||
Available Date |
AvailableDate |
DTYPE_TEXT |
Not applicable |
No |
Available Quantity |
AvailableQuantity |
DTYPE_TEXT |
Not applicable |
No |
Available Status |
AvailableStatus |
DTYPE_TEXT |
Not applicable |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
Not applicable |
No |
Id |
Id |
DTYPE_TEXT |
Not applicable |
No |
Line Number |
LineNumber |
DTYPE_TEXT |
Not applicable |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
Not applicable |
No |
Product Id |
ProductId |
DTYPE_TEXT |
Not applicable |
No |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Source Inventory Loc Id |
SourceInventoryLocId |
DTYPE_TEXT |
Not applicable |
No |
Source Inventory Loc Integration Id |
SourceInventoryLocIntegrationId |
DTYPE_TEXT |
Not applicable |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
Not applicable |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
External Credit Check
The External Credit Check ASI is an ASI for quote and order management-related business processes. This ASI enables the Siebel application to request a credit check from a back-office or credit management system. There are two ASIs for External Credit Check—one for requests and one for responses.
Credit Check Request
The Credit Check Request ASI is an outbound call that triggers the back-office credit limit check business service in an order, and populates the credit status check result in the Siebel application. The Siebel application issues a warning; if a customer does have a sufficient credit limit, the status shown indicates failure.
The following image describes the structure of this ASI.

The following table lists the integration component of this ASI.
Table Credit Check Request Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Line Items |
LineItems |
No user keys |
Request Credit Check |
RequestCreditCheck |
No user keys |
The following table lists the fields and definitions. Fields without a length specified do not have a maximum length associated with them.
Table Credit Check Request ASI Fields
Name | XML Tag | Data Type | Length | Req. | Note |
---|---|---|---|---|---|
Request Credit Check |
|||||
Amount |
Amount |
DTYPE_NUMBER |
No |
None |
|
Bill To Account Id |
BillToAccountId |
DTYPE_ID |
15 |
No |
None |
Bill To Account Integration Id |
BillToAccountIntegrationId |
DTYPE_ID |
30 |
No |
None |
Bill To Account Location |
BillToAccountLocation |
DTYPE_TEXT |
50 |
No |
None |
Bill To Account Name |
BillToAccountName |
DTYPE_TEXT |
100 |
No |
None |
Bill To Address Id |
BillToAddressId |
DTYPE_ID |
15 |
No |
None |
Bill To Alias |
BillToAlias |
DTYPE_TEXT |
50 |
No |
None |
Bill To City |
BillToCity |
DTYPE_TEXT |
50 |
No |
None |
Bill To Country |
BillToCountry |
DTYPE_TEXT |
50 |
No |
None |
Bill To County |
BillToCounty |
DTYPE_TEXT |
50 |
No |
None |
Bill To DUNS Number |
BillToDUNSNumber |
DTYPE_TEXT |
15 |
No |
None |
Bill To Postal Code |
BillToPostalCode |
DTYPE_TEXT |
30 |
No |
None |
Bill To Primary Organization Id |
BillToPrimaryOrganizationId |
DTYPE_ID |
15 |
No |
None |
Bill To Primary Organization Name |
BillToPrimaryOrganizationName |
DTYPE_TEXT |
100 |
No |
None |
Bill To Province |
BillToProvince |
DTYPE_TEXT |
50 |
No |
None |
Bill To State |
BillToState |
DTYPE_TEXT |
10 |
No |
None |
Bill To Street Address |
BillToStreetAddress |
DTYPE_TEXT |
200 |
No |
None |
Bill To Street Address 2 |
BillToStreetAddress2 |
DTYPE_TEXT |
100 |
No |
None |
Bill To VAT Registration Number |
BillToVATRegistrationNumber |
DTYPE_TEXT |
30 |
No |
None |
Currency |
Currency |
DTYPE_TEXT |
20 |
No |
None |
Document Id |
DocumentId |
DTYPE_TEXT |
30 |
Yes |
None |
Document Integration Id |
DocumentIntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Document Type |
DocumentType |
DTYPE_TEXT |
10 |
Yes |
Contains either Quote or Order value. |
Order Type Id |
OrderTypeId |
DTYPE_ID |
15 |
No |
Applicable only if Document Type is Order. |
Line Items |
|||||
Extended Quantity |
ExtendedQuantity |
DTYPE_NUMBER |
22 |
No |
None |
Id |
Id |
DTYPE_ID |
15 |
No |
None |
Item Price |
ItemPrice |
DTYPE_NUMBER |
22 |
No |
None |
Line Number |
LineNumber |
DTYPE_NUMBER |
22 |
No |
None |
Net Price |
NetPrice |
DTYPE_NUMBER |
22 |
No |
None |
Parent Order Item Number |
ParentOrderItemNumber |
DTYPE_NUMBER |
22 |
No |
None |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
None |
Quantity Requested |
QuantityRequested |
DTYPE_NUMBER |
22 |
No |
None |
Rollup Item Price |
RollupItemPrice |
DTYPE_NUMBER |
22 |
No |
None |
Start Price |
StartPrice |
DTYPE_NUMBER |
22 |
No |
None |
Unit Price |
UnitPrice |
DTYPE_NUMBER |
22 |
No |
None |
Credit Check Response
The following table lists the integration component of this ASI.
Table Credit Check Response Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Request Credit Check Response |
RequestCreditCheckResponse |
No user keys |
The following table lists the fields and attributes of this ASI.
Table Credit Check Response ASI Fields
Name | XML Tag | Data Type | Length | Req. |
---|---|---|---|---|
Request Credit Check Response |
||||
Bill To Account Id |
BillToAccountId |
DTYPE_ID |
15 |
No |
Bill To Account Integration Id |
BillToAccountIntegrationId |
DTYPE_ID |
30 |
No |
Bill To Account Location |
BillToAccountLocation |
DTYPE_TEXT |
50 |
No |
Bill To Account Name |
BillToAccountName |
DTYPE_TEXT |
100 |
No |
Bill To Primary Organization Id |
BillToPrimaryOrganizationId |
DTYPE_ID |
15 |
No |
Bill To Primary Organization Name |
BillToPrimaryOrganizationName |
DTYPE_TEXT |
100 |
No |
Credit Status As Of |
CreditStatusAsOf |
DTYPE_DATETIME |
Not applicable |
No |
Credit Status Code |
CreditStatusCode |
DTYPE_TEXT |
30 |
No |
Credit Status Message |
CreditStatusMessage |
DTYPE_TEXT |
250 |
No |
Document Id |
DocumentId |
DTYPE_ID |
15 |
Yes |
Document Integration Id |
DocumentIntegrationId |
DTYPE_TEXT |
15 |
No |
Document Type |
DocumentType |
DTYPE_TEXT |
10 |
Yes |
Error Status |
ErrorStatus |
DTYPE_TEXT |
30 |
Yes |
Error Text |
ErrorText |
DTYPE_TEXT |
250 |
No |
External Shipment Tracking
The External Shipment Tracking ASI enables a customer to check the location and status of an order after it leaves the seller.
There are two ASIs for External Shipment Tracking—one for requests and one for responses.
Shipment Tracking Interface Request
The Shipment Tracking Interface Request uses the Shipment Information Business Component. The following table lists the components of this ASI.
Table Shipment Tracking Interface Request Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Shipment Information |
ShipmentInformation |
No user keys |
The following table lists the fields and their attributes.
Table Shipment Tracking Interface Request ASI Fields
Name | XML Tag | Data Type | Length | Req. | Note |
---|---|---|---|---|---|
Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Used for picking a related entity. |
Country Code |
CountryCode |
DTYPE_TEXT |
10 |
No |
None |
Language |
Language |
DTYPE_TEXT |
10 |
No |
None |
Package Tracking Number |
PackageTrackingNumber |
DTYPE_TEXT |
40 |
C |
Package tracking number (required if Shipment Identification Number or Shipment Reference Number is not provided). |
Request Action |
RequestAction |
DTYPE_TEXT |
20 |
Yes |
None |
Request Option |
RequestOption |
DTYPE_TEXT |
20 |
No |
None |
Shipment Identification Number |
ShipmentIdentificationNumber |
DTYPE_TEXT |
50 |
C |
Shipment tracking number (required if Package Tracking Number or Shipment Reference Number is not provided). |
Shipment Reference Number |
ShipmentReferenceNumber |
DTYPE_TEXT |
30 |
C |
Shipment Reference number is defined by the seller (required if Package Tracking Number or Shipment Identification Number is not provided). |
Shipper Number |
ShipperNumber |
DTYPE_TEXT |
60 |
C |
Required if Shipment Reference Number is provided. |
Shipment Tracking Interface Response
The following image describes the structure for Shipment Tracking Interface Response.

The following table lists all the integration components of this ASI.
Table Shipment Tracking Interface Response ASI Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Shipment Information |
ShipmentInformation |
No user keys |
Package Information |
PackageInformation |
No user keys |
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table Shipment Tracking Interface Response ASI Fields
Name | XML Tag | Data Type | Length | Req. | Notes |
---|---|---|---|---|---|
Shipment Information |
|||||
Response Code |
ResponseCode |
DTYPE_TEXT |
10 |
Yes |
None |
Response Message |
ResponseMessage |
DTYPE_TEXT |
100 |
Yes |
None |
Shipment Identification Number |
ShipmentIdentificationNumber |
DTYPE_TEXT |
50 |
C |
Tracking number at the shipment level (logical construct). Conditionally required if Shipment Reference Number not provided. |
Shipment Pickup Date |
ShipmentPickupDate |
DTYPE_UTCDATETIME |
10 |
No |
None |
Shipment Reference Number |
ShipmentReferenceNumber |
DTYPE_TEXT |
30 |
C |
Conditionally required if Shipment Identification Number not provided. |
Shipment Scheduled Delivery Date |
ShipmentScheduledDeliveryDate |
DTYPE_UTCDATETIME |
10 |
No |
None |
Shipment Service Description |
ShipmentServiceDescription |
DTYPE_TEXT |
100 |
No |
None |
Shipment Ship To Address Line 1 |
ShipmentShipToAddressLine1 |
DTYPE_TEXT |
200 |
No |
None |
Shipment Ship To Address Line 2 |
ShipmentShipToAddressLine2 |
DTYPE_TEXT |
100 |
No |
None |
Shipment Ship To City |
ShipmentShipToCity |
DTYPE_TEXT |
50 |
No |
None |
Shipment Ship To Country |
ShipmentShipToCountry |
DTYPE_TEXT |
30 |
No |
None |
Shipment Ship To Postal Code |
ShipmentShipToPostalCode |
DTYPE_TEXT |
30 |
No |
None |
Shipment Ship To State |
ShipmentShipToState |
DTYPE_TEXT |
10 |
No |
None |
Shipper Number |
ShipperNumber |
DTYPE_TEXT |
60 |
Y |
None |
Package Information |
|||||
Comments |
Comments |
DTYPE_TEXT |
100 |
No |
None |
Package Activity Date |
PackageActivityDate |
DTYPE_DATE |
20 |
No |
None |
Package Activity Location City |
PackageActivityLocationCity |
DTYPE_TEXT |
20 |
No |
None |
Package Activity Location Country |
PackageActivityLocationCountry |
DTYPE_TEXT |
20 |
No |
None |
Package Activity Location Description |
PackageActivityLocationDescription |
DTYPE_TEXT |
20 |
No |
None |
Package Activity Location Signed For By Name |
PackageActivityLocationSignedForByName |
DTYPE_TEXT |
20 |
No |
None |
Package Activity Status Description |
PackageActivityStatusDescription |
DTYPE_TEXT |
20 |
No |
None |
Package Activity Time |
PackageActivityTime |
DTYPE_TIME |
20 |
No |
None |
Package Tracking Number |
PackageTrackingNumber |
DTYPE_TEXT |
20 |
Yes |
None |
Response Code |
ResponseCode |
DTYPE_TEXT |
10 |
No |
None |
Response Message |
ResponseMessage |
DTYPE_TEXT |
100 |
No |
None |
Siebel SIA Service Request
This ASI enables an application to create an SIA service request within the Siebel application. The following image describes the Siebel SIA Service Request ASI structure.

The following table lists the integration components of this ASI.
Table Siebel SIA Service Request Integration Components
Name | XML Tag | User Keys |
---|---|---|
Action |
Action |
|
Related Account External Product |
AccountExternalProduct |
|
SR External Product |
SRExternalProduct |
|
Service Request |
ServiceRequest |
|
The following table lists the integration components and field attributes.
Table Siebel SIA Service Request ASI Fields
Name | XML Tag | Data Type | Length | Required |
---|---|---|---|---|
Action |
||||
Abstract |
Abstract |
DTYPE_TEXT |
100 |
No |
Activity SR Id |
ActivitySRId |
DTYPE_ID |
15 |
No |
Activity UID |
ActivityUID |
DTYPE_TEXT |
30 |
No |
Asset Id |
AssetId |
DTYPE_ID |
15 |
No |
Asset Number |
AssetNumber |
DTYPE_TEXT |
100 |
No |
Audience |
Audience |
DTYPE_TEXT |
30 |
No |
Comment |
Comment |
DTYPE_TEXT |
1,500 |
No |
Description |
Description |
DTYPE_TEXT |
100 |
No |
Done |
Done |
DTYPE_TEXT |
30 |
No |
Duration Hours |
DurationHours |
DTYPE_NUMBER |
22 |
No |
Duration Minutes |
DurationMinutes |
DTYPE_NUMBER |
22 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Planned |
Planned |
DTYPE_TEXT |
30 |
No |
Planned Completion |
PlannedCompletion |
DTYPE_TEXT |
30 |
No |
Primary Owner Id |
PrimaryOwnerId |
DTYPE_ID |
15 |
No |
Resolution Code |
ResolutionCode |
DTYPE_TEXT |
30 |
No |
Started |
Started |
DTYPE_TEXT |
30 |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
Related Account External Product |
||||
AEP Account Id |
AEPAccountId |
DTYPE_ID |
30 |
No |
AEP Product Id |
AEPProductId |
DTYPE_ID |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Version |
Version |
DTYPE_TEXT |
30 |
No |
SR External Product |
||||
Name |
Name |
DTYPE_TEXT |
100 |
No |
Version |
Version |
DTYPE_TEXT |
30 |
No |
Service Request |
||||
Abstract |
Abstract |
DTYPE_TEXT |
100 |
No |
Account |
Account |
DTYPE_TEXT |
100 |
No |
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
Account Location |
AccountLocation |
DTYPE_TEXT |
50 |
No |
Agreement Id |
AgreementId |
DTYPE_ID |
15 |
No |
Asset Id |
AssetId |
DTYPE_ID |
15 |
No |
Closed Date |
ClosedDate |
DTYPE_TEXT |
30 |
No |
Commit Time |
CommitTime |
DTYPE_TEXT |
30 |
No |
Contact Business Phone |
ContactBusinessPhone |
DTYPE_TEXT |
30 |
No |
Contact Created |
ContactCreated |
DTYPE_TEXT |
30 |
No |
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
No |
Contact Id |
ContactId |
DTYPE_ID |
15 |
No |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
No |
Customer Ref Number |
CustomerRefNumber |
DTYPE_TEXT |
64 |
No |
Description |
Description |
DTYPE_TEXT |
2,000 |
No |
Entitlement Id |
EntitlementId |
DTYPE_ID |
15 |
No |
Entitlement Name |
EntitlementName |
DTYPE_TEXT |
50 |
No |
Group Id |
GroupId |
DTYPE_ID |
15 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Owned By Id |
OwnedById |
DTYPE_ID |
15 |
No |
Owner |
Owner |
DTYPE_TEXT |
50 |
No |
Primary Organization Id |
PrimaryOrganizationId |
DTYPE_ID |
15 |
No |
Primary Service Agreement Id |
PrimaryServiceAgreementId |
DTYPE_ID |
15 |
No |
Priority |
Priority |
DTYPE_TEXT |
30 |
No |
Product |
Product |
DTYPE_TEXT |
100 |
No |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
SR Number |
SRNumber |
DTYPE_TEXT |
64 |
No |
SR Type |
SRType |
DTYPE_TEXT |
30 |
No |
Serial Number |
SerialNumber |
DTYPE_TEXT |
100 |
No |
Service Request Type |
ServiceRequestType |
DTYPE_TEXT |
30 |
No |
Severity |
Severity |
DTYPE_TEXT |
30 |
No |
Source |
Source |
DTYPE_TEXT |
30 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Sub-Area |
Subarea |
DTYPE_TEXT |
30 |
No |
Sub-Status |
Sub-Status |
DTYPE_TEXT |
30 |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Siebel Service Request
The Siebel Service Request ASI is part of the Manage Service Request business process. Use this ASI to synchronize service requests in the Siebel application with an external target application. This ASI facilitates both outbound and inbound data synchronization between the Siebel application and an external target application.
The following image describes the Siebel Service Request ASI structure.

The following table lists the integration components and user keys of this ASI.
Table Siebel Service Request Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Action |
Action |
|
Account External Product |
AccountExternalProduct |
|
Service Request |
ServiceRequest |
|
SR External Product |
SrExternalProduct |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
Table Siebel Service Request ASI Fields
Name | XML Tag | Data Type | Length | Required |
---|---|---|---|---|
Account External Product |
||||
AEP Account Id |
AEPAccountId |
DTYPE_ID |
30 |
No |
AEP Product Id |
AEPProductId |
DTYPE_ID |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Version |
Version |
DTYPE_TEXT |
30 |
No |
Action |
||||
Abstract |
Abstract |
DTYPE_TEXT |
100 |
No |
Activity SR Id |
ActivitySRId |
DTYPE_ID |
15 |
No |
Activity UID |
ActivityUID |
DTYPE_TEXT |
30 |
No |
Asset Id |
AssetId |
DTYPE_ID |
15 |
No |
Asset Number |
AssetNumber |
DTYPE_TEXT |
100 |
No |
Audience |
Audience |
DTYPE_TEXT |
30 |
No |
Comment |
Comment |
DTYPE_TEXT |
1,500 |
No |
Description |
Description3 |
DTYPE_TEXT |
100 |
No |
Done |
Done |
DTYPE_TEXT |
30 |
No |
Duration Hours |
DurationHours |
DTYPE_NUMBER |
22 |
No |
Duration Minutes |
DurationMinutes |
DTYPE_NUMBER |
22 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Planned |
Planned |
DTYPE_TEXT |
30 |
No |
Planned Completion |
PlannedCompletion |
DTYPE_TEXT |
30 |
No |
Primary Owner Id |
PrimaryOwnerId |
DTYPE_ID |
15 |
No |
Resolution Code |
ResolutionCode |
DTYPE_TEXT |
30 |
No |
Started |
Started |
DTYPE_TEXT |
30 |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
Service Request |
||||
Abstract |
Abstract |
DTYPE_TEXT |
100 |
No |
Account |
Account |
DTYPE_TEXT |
100 |
No |
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
Account Location |
AccountLocation |
DTYPE_TEXT |
50 |
No |
Agreement Id |
AgreementId |
DTYPE_ID |
15 |
No |
Area |
Area |
DTYPE_TEXT |
30 |
No |
Asset Id |
AssetId |
DTYPE_ID |
15 |
No |
Closed Date |
ClosedDate |
DTYPE_TEXT |
30 |
No |
Commit Time |
CommitTime |
DTYPE_TEXT |
30 |
No |
Contact Business Phone |
ContactBusinessPhone |
DTYPE_TEXT |
NA |
No |
Contact Created |
ContactCreated |
DTYPE_TEXT |
30 |
No |
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
No |
Contact Id |
ContactId |
DTYPE_ID |
15 |
No |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
No |
Customer Reference Number |
CustomerReferenceNumber |
DTYPE_TEXT |
64 |
No |
Description |
Description |
DTYPE_TEXT |
2,000 |
No |
Entitlement Id |
EntitlementId |
DTYPE_ID |
15 |
No |
Entitlement Name |
EntitlementName |
DTYPE_TEXT |
50 |
No |
Group Id |
GroupId |
DTYPE_ID |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Owned By Id |
OwnedById |
DTYPE_ID |
30 |
No |
Owner |
Owner |
DTYPE_TEXT |
50 |
No |
Primary Organization Id |
PrimaryOrganizationId |
DTYPE_ID |
15 |
No |
Primary Service Agreement Id |
PrimaryServiceAgreementId |
DTYPE_ID |
15 |
No |
Priority |
Priority |
DTYPE_TEXT |
30 |
No |
Product |
Product |
DTYPE_TEXT |
100 |
No |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
SR Number |
SRNumber |
DTYPE_TEXT |
64 |
No |
SR Type |
SRType |
DTYPE_TEXT |
30 |
No |
Serial Number |
SerialNumber |
DTYPE_TEXT |
NA |
No |
Service Request Type |
ServiceRequestType |
DTYPE_TEXT |
30 |
No |
Severity |
Severity |
DTYPE_TEXT |
30 |
No |
Source |
Source |
DTYPE_TEXT |
30 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Sub-Area |
Sub-Area |
DTYPE_TEXT |
30 |
No |
Sub-Status |
Sub-Status |
DTYPE_TEXT |
30 |
No |
Type |
Type |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
SR External Product |
||||
Name |
Name |
DTYPE_TEXT |
100 |
No |
Version |
Version |
DTYPE_TEXT |
30 |
No |
Siebel Simple Product
This ASI receives information about simple products created in third-party systems and enables users to create, update, and query a product in the Siebel application. The Siebel Simple Product ASI is intended to synchronize the Siebel application to external product masters, and does not support the receipt of information for customized products or bundles.
The following image describes the structure of the Siebel Simple Product ASI.

The following table lists the integration components and user keys for this ASI.
Table Siebel Simple Product ASI Integration Components
Integration Component | XML Tag | User Keys |
---|---|---|
Internal Product |
InternalProduct |
|
Inventory Options |
InventoryOptions |
|
Product Inventory |
ProductInventory |
|
Related Equivalent Product |
RelatedEquivalentProduct |
|
Related Inventory Location |
RelatedInventoryLocation |
|
Related Organization |
RelatedOrganization |
|
Related Product |
RelatedProduct |
|
Related Product Line |
RelatedProductLine |
|
Related Sales Tool by Product |
RelatedSalesToolByProduct |
|
Related Warranty |
RelatedWarranty |
|
The following table lists the fields and their attributes. Fields without a length specified do not have a maximum length associated with them.
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 |
ImageFileName |
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 |
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 Thumbnail Image Id |
ProductThumbnailImageId |
DTYPE_ID |
NA |
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 |
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 |
Inventory Options |
||||
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 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 |
Product Inventory |
||||
Allocate Below Safety Stock Flag |
AllocateBelowSafetyStockFlag |
DTYPE_TEXT |
30 |
No |
Auto Allocate Flag |
AutoAllocateFlag |
DTYPE_TEXT |
30 |
No |
Auto Substitute Flag |
AutoSubstituteFlag |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Inventory Location Id |
InventoryLocationId |
DTYPE_ID |
30 |
No |
Maximum Inventory Level |
MaximumInventoryLevel |
DTYPE_NUMBER |
22 |
No |
Minimum Inventory Level |
MinimumInventoryLevel |
DTYPE_NUMBER |
22 |
No |
Movement Class |
MovementClass |
DTYPE_TEXT |
30 |
No |
Product Id |
ProductId |
DTYPE_TEXT |
30 |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Safety Stock Level |
SafetyStockLevel |
DTYPE_NUMBER |
22 |
No |
Value Class |
ValueClass |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
Related 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 |
Related 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 |
Related 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 |
Sales Unit of Measure |
SalesUnitofMeasure |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
searchspec |
searchspec |
DTYPE_TEXT |
250 |
No |
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 |
Related 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 |
Related Sales Tool by Product |
||||
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Literature Type |
LiteratureType |
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 |
Related 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 |