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 shows the structure of the Siebel Order ASI, which contians the following components: Related Shipment (Shipment Item child), Related Sales Rep, Related Organization, Line Items, Payments. Line Items has the following children: Attributes, Requested Schedule Lines, Promised Schedule Lines.
The following table lists the integration components of this ASI.
| Integration Component | XML Tag | User Keys |
|---|---|---|
Attributes |
Attributes |
|
Line Items |
LineItems |
|
Orders |
Orders |
|
Payments |
Payments |
|
Promised Schedule Lines |
PromisedScheduleLines |
|
Related Organization |
RelatedOrganization |
|
Related Sales Rep |
RelatedSalesRep |
|
Related Shipment |
RelatedShipment |
|
Requested Schedule Lines |
RequestedScheduleLines |
|
Shipment 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.
Attributes Fields in Siebel Order ASI
The following table lists the Attribute fields and their attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Action Code |
ActionCode |
DTYPE_TEXT |
30 |
No |
Attribute Id |
AttributeId |
DTYPE_ID |
NA |
No |
Data Type |
DataType |
DTYPE_TEXT |
30 |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Hidden |
Hidden |
DTYPE_TEXT |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
LOV Type |
ListOfValueType |
DTYPE_TEXT |
30 |
No |
Name |
Name |
DTYPE_TEXT |
75 |
No |
Object Id |
ObjectId |
DTYPE_ID |
NA |
No |
Read Only |
ReadOnly |
DTYPE_TEXT |
NA |
No |
Required |
Required |
DTYPE_TEXT |
NA |
No |
Sequence |
Sequence |
DTYPE_NUMBER |
NA |
No |
Validation |
Validation |
DTYPE_TEXT |
250 |
No |
Value |
Value |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Line Items Fields in Siebel Order ASI
The following table lists the Line Items fields and their attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Action Code |
ActionCode |
DTYPE_TEXT |
30 |
No |
Asset Id |
AssetId |
DTYPE_ID |
NA |
No |
Asset Integration Id |
AssetIntegrationId |
DTYPE_TEXT |
30 |
No |
Asset 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 Fields in Siebel Order ASI
The following table lists the Orders fields and their attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Account |
Account |
DTYPE_TEXT |
100 |
No |
Account DUNS Number |
AccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Account Site |
AccountSite |
DTYPE_TEXT |
100 |
No |
Active |
Active |
DTYPE_TEXT |
NA |
No |
Approved |
Approved |
DTYPE_TEXT |
NA |
No |
Approved By |
ApprovedBy |
DTYPE_TEXT |
NA |
No |
Approved By Date |
ApprovedByDate |
DTYPE_TEXT |
NA |
No |
Available Date |
AvailableDate |
DTYPE_TEXT |
NA |
No |
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Bill To - First Name |
BillTo-FirstName |
DTYPE_TEXT |
50 |
No |
Bill To - Last Name |
BillTo-LastName |
DTYPE_TEXT |
50 |
No |
Bill To Account |
BillToAccount |
DTYPE_TEXT |
100 |
No |
Bill To Account DUNS Number |
BillToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Bill To Account Id |
BillToAccountId |
DTYPE_ID |
NA |
No |
Bill To Account Integration Id |
BillToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Bill To Account Site |
BillToAccountSite |
DTYPE_TEXT |
50 |
No |
Bill To Address |
BillToAddress |
DTYPE_TEXT |
50 |
No |
Bill To Address 2 |
BillToAddress2 |
DTYPE_TEXT |
50 |
No |
Bill To Address Id |
BillToAddressId |
DTYPE_ID |
NA |
No |
Bill To Address Integration Id |
BillToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Bill To City |
BillToCity |
DTYPE_TEXT |
30 |
No |
Bill To Contact Id |
BillToContactId |
DTYPE_ID |
NA |
No |
Bill To Contact Integration Id |
BillToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Bill To Country |
BillToCountry |
DTYPE_TEXT |
15 |
No |
Bill To State |
BillToState |
DTYPE_TEXT |
30 |
No |
Bill To Zip |
BillToZip |
DTYPE_TEXT |
15 |
No |
Billable Flag |
BillableFlag |
DTYPE_TEXT |
NA |
No |
Billing Block |
BillingBlock |
DTYPE_TEXT |
30 |
No |
Campaign Id |
CampaignId |
DTYPE_ID |
NA |
No |
Campaign Integration Id |
CampaignIntegrationId |
DTYPE_TEXT |
30 |
No |
Campaign Name |
CampaignName |
DTYPE_TEXT |
100 |
No |
Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Carrier Priority |
CarrierPriority |
DTYPE_TEXT |
30 |
No |
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
No |
Contact Id |
ContactId |
DTYPE_ID |
NA |
No |
Contact Integration Id |
ContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
No |
Contract Id |
ContractId |
DTYPE_ID |
NA |
No |
Contract Integration Id |
ContractIntegrationId |
DTYPE_TEXT |
30 |
No |
Contract Name |
ContractName |
DTYPE_TEXT |
50 |
No |
Credit Status |
CreditStatus |
DTYPE_TEXT |
NA |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
Delivery Status |
DeliveryStatus |
DTYPE_TEXT |
30 |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Destination Inventory Id |
DestinationInventoryLocationId |
DTYPE_ID |
NA |
No |
Destination Inventory Location |
DestinationInventoryLocation |
DTYPE_TEXT |
100 |
No |
Destination Inventory Location Integration Id |
DestinationInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Discount Amount |
DiscountAmount |
DTYPE_TEXT |
NA |
No |
Entitlement Id |
EntitlementId |
DTYPE_ID |
NA |
No |
Entitlement Name |
EntitlementName |
DTYPE_TEXT |
50 |
No |
External Order Number |
ExternalOrderNumber |
DTYPE_TEXT |
NA |
No |
Hold Flag |
HoldFlag |
DTYPE_TEXT |
NA |
No |
Hold Reason |
HoldReason |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Integration Message |
IntegrationMessage |
DTYPE_TEXT |
2,000 |
No |
Integration Status |
IntegrationStatus |
DTYPE_TEXT |
30 |
No |
Integration Status As Of Date |
IntegrationStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Opportunity Id |
OpportunityId |
DTYPE_ID |
NA |
No |
Opportunity Integration Id |
OpportunityIntegrationId |
DTYPE_TEXT |
30 |
No |
Opportunity Name |
OpportunityName |
DTYPE_TEXT |
100 |
No |
Order Date |
OrderDate |
DTYPE_TEXT |
NA |
No |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Order Priority |
OrderPriority |
DTYPE_TEXT |
30 |
No |
Order Type |
OrderType |
DTYPE_TEXT |
30 |
No |
Order Type Id |
OrderTypeId |
DTYPE_ID |
NA |
No |
Organization DUNS Number |
OrganizationDUNSNumber |
DTYPE_TEXT |
9 |
No |
Parent Order Id |
ParentOrderId |
DTYPE_ID |
NA |
No |
Partial Ship |
PartialShip |
DTYPE_TEXT |
NA |
No |
Pay To Account |
PayToAccount |
DTYPE_TEXT |
100 |
No |
Pay To Account DUNS Number |
PayToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Pay To Account Id |
PayToAccountId |
DTYPE_ID |
NA |
No |
Pay To Account Integration Id |
PayToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Pay To Account Site |
PayToAccountSite |
DTYPE_TEXT |
50 |
No |
Pay To Address Id |
PayToAddressId |
DTYPE_ID |
NA |
No |
Pay To Address Integration Id |
PayToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Pay To Contact First Name |
PayToContactFirstName |
DTYPE_TEXT |
50 |
No |
Pay To Contact Id |
PayToContactId |
DTYPE_ID |
NA |
No |
Pay To Contact Integration Id |
PayToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Pay To Contact Last Name |
PayToContactLastName |
DTYPE_TEXT |
50 |
No |
Payment Term |
PaymentTerm |
DTYPE_TEXT |
50 |
No |
Payment Term Id |
PaymentTermId |
DTYPE_ID |
NA |
No |
Payment Term Integration Id |
PaymentTermIntegrationId |
DTYPE_TEXT |
30 |
No |
Price List |
PriceList |
DTYPE_TEXT |
50 |
No |
Price List Id |
PriceListId |
DTYPE_ID |
NA |
No |
Price List Integration Id |
PriceListIntegrationId |
DTYPE_TEXT |
30 |
No |
Pricing Date |
PricingDate |
DTYPE_TEXT |
NA |
No |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
Primary Organization Id |
PrimaryOrganizationId |
DTYPE_ID |
NA |
No |
Project Id |
ProjectId |
DTYPE_ID |
NA |
No |
Project Integration Id |
ProjectIntegrationId |
DTYPE_TEXT |
30 |
No |
Project Name |
ProjectName |
DTYPE_TEXT |
100 |
No |
Promotion Id |
PromotionId |
DTYPE_ID |
NA |
No |
Purchase Order Number |
PurchaseOrderNumber |
DTYPE_TEXT |
50 |
No |
Quote Id |
QuoteId |
DTYPE_ID |
NA |
No |
Quote Integration Id |
QuoteIntegrationId |
DTYPE_TEXT |
30 |
No |
Quote Number |
QuoteNumber |
DTYPE_TEXT |
30 |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
NA |
No |
Return Reason |
ReturnReason |
DTYPE_TEXT |
30 |
No |
Return To Account |
ReturnToAccount |
DTYPE_TEXT |
100 |
No |
Return To Account DUNS Number |
ReturnToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Return To Account Id |
ReturnToAccountId |
DTYPE_ID |
NA |
No |
Return To Account Integration Id |
ReturnToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Account Site |
ReturnToAccountSite |
DTYPE_TEXT |
50 |
No |
Return To Address Id |
ReturnToAddressId |
DTYPE_ID |
NA |
No |
Return To Address Integration Id |
ReturnToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Contact First Name |
ReturnToContactFirstName |
DTYPE_TEXT |
50 |
No |
Return To Contact Id |
ReturnToContactId |
DTYPE_ID |
NA |
No |
Return To Contact Integration Id |
ReturnToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Contact Last Name |
ReturnToContactLastName |
DTYPE_TEXT |
50 |
No |
Revision |
Revision |
DTYPE_NUMBER |
NA |
No |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
NA |
No |
Service Request Number |
ServiceRequestNumber |
DTYPE_TEXT |
NA |
No |
Ship Complete |
ShipComplete |
DTYPE_TEXT |
NA |
No |
Ship Instructions |
ShipInstructions |
DTYPE_TEXT |
250 |
No |
Ship To - First Name |
ShipTo-FirstName |
DTYPE_TEXT |
50 |
No |
Ship To - Last Name |
ShipTo-LastName |
DTYPE_TEXT |
50 |
No |
Ship To Account |
ShipToAccount |
DTYPE_TEXT |
100 |
No |
Ship To Account DUNS Number |
ShipToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Ship To Account Id |
ShipToAccountId |
DTYPE_ID |
NA |
No |
Ship To Account Integration Id |
ShipToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Account Site |
ShipToAccountSite |
DTYPE_TEXT |
50 |
No |
Ship To Address |
ShipToAddress |
DTYPE_TEXT |
50 |
No |
Ship To Address 2 |
ShipToAddress2 |
DTYPE_TEXT |
50 |
No |
Ship To Address Id |
ShipToAddressId |
DTYPE_ID |
NA |
No |
Ship To Address Integration Id |
ShipToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To City |
ShipToCity |
DTYPE_TEXT |
30 |
No |
Ship To Contact Id |
ShipToContactId |
DTYPE_ID |
NA |
No |
Ship To Contact Integration Id |
ShipToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Country |
ShipToCountry |
DTYPE_TEXT |
15 |
No |
Ship To State |
ShipToState |
DTYPE_TEXT |
30 |
No |
Ship To Zip |
ShipToZip |
DTYPE_TEXT |
15 |
No |
Shipping Charges |
ShippingCharges |
DTYPE_TEXT |
NA |
No |
Shipping Method |
ShippingMethod |
DTYPE_TEXT |
30 |
No |
Shipping Terms |
ShippingTerms |
DTYPE_TEXT |
30 |
No |
Shipping Terms Info |
FreightTermsInfo |
DTYPE_TEXT |
100 |
No |
Source Inventory Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Source Inventory Loc Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Status As Of Date |
StatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Submit Date |
SubmitDate |
DTYPE_TEXT |
NA |
No |
Tax Amount |
TaxAmount |
DTYPE_TEXT |
NA |
No |
Tax Exempt |
TaxExempt |
DTYPE_TEXT |
NA |
No |
Tax Exempt Code |
TaxExemptCode |
DTYPE_TEXT |
80 |
No |
Tax Exempt Id |
TaxExemptId |
DTYPE_TEXT |
30 |
No |
Tax Rate |
TaxRate |
DTYPE_NUMBER |
NA |
No |
Total Volume |
TotalVolume |
DTYPE_NUMBER |
NA |
No |
Total Volume UoM |
TotalVolumeUoM |
DTYPE_TEXT |
30 |
No |
Total Weight |
TotalWeight |
DTYPE_NUMBER |
NA |
No |
Total Weight UoM |
TotalWeightUoM |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Payments Fields in Siebel Order ASI
The following table lists the Payments fields and their attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Account Number |
AccountNumber |
DTYPE_TEXT |
50 |
No |
Authorization Code |
AuthorizationCode |
DTYPE_TEXT |
40 |
No |
Bill To Address Id |
BillToAddressId |
DTYPE_ID |
NA |
No |
Bill To Address Integration Id |
BillToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Card Holder |
CardHolder |
DTYPE_TEXT |
50 |
No |
Credit Card Expiration Month |
CreditCardExpirationMonth |
DTYPE_TEXT |
30 |
No |
Credit Card Expiration Year |
CreditCardExpirationYear |
DTYPE_TEXT |
30 |
No |
Credit Check Message |
CreditCheckMessage |
DTYPE_TEXT |
250 |
No |
Credit Check Status |
CreditCheckStatus |
DTYPE_TEXT |
30 |
No |
Credit Check Status As Of Date |
CreditCheckStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Encryption Key |
EncryptionKey |
DTYPE_TEXT |
30 |
No |
Encryption Key Reference |
EncryptionKeyReference |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Issuing Bank Customer Id |
IssuingBankCustomerId |
DTYPE_TEXT |
30 |
No |
Issuing Bank Name |
IssuingBankName |
DTYPE_TEXT |
30 |
No |
Issuing Bank Phone Number |
IssuingBankPhoneNumber |
DTYPE_TEXT |
40 |
No |
Merchant Id |
MerchantId |
DTYPE_TEXT |
30 |
No |
Payment # |
Payment |
DTYPE_TEXT |
30 |
No |
Payment Account Id |
PaymentAccountId |
DTYPE_ID |
NA |
No |
Payment Account Integration Id |
PaymentAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Payment Account Name |
PaymentAccountName |
DTYPE_TEXT |
100 |
No |
Payment Account Site |
PaymentAccountSite |
DTYPE_TEXT |
50 |
No |
Payment Method |
PaymentMethod |
DTYPE_TEXT |
30 |
No |
Payment Status |
PaymentStatus |
DTYPE_TEXT |
30 |
No |
Payment Status As Of Date |
PaymentStatusAsOfDate |
DTYPE_DATETIME |
NA |
No |
Payment Type |
PaymentType |
DTYPE_TEXT |
30 |
No |
Transaction Amount |
TransactionAmount |
DTYPE_TEXT |
NA |
No |
Transaction Id |
TransactionId |
DTYPE_TEXT |
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 Fields in Siebel Order ASI
The following table lists the Promised Schedule Lines fields and their attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Line Item Action Number |
LineItemActionNumber |
DTYPE_TEXT |
NA |
No |
Order Item Id |
OrderItemId |
DTYPE_ID |
NA |
No |
Order Item Integration Id |
OrderItemIntegrationId |
DTYPE_TEXT |
30 |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
50 |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Promised Date |
PromisedDate |
DTYPE_TEXT |
NA |
No |
Promised Quantity |
PromisedQuantity |
DTYPE_NUMBER |
NA |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Related Organization Fields in Siebel Order ASI
The following table lists the Related Organization fields and their attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
NA |
No |
Related Sales Rep Fields in Siebel Order ASI
The following table lists the Related Sales Rep fields and the attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Login |
Login |
DTYPE_TEXT |
50 |
No |
Position |
Position |
DTYPE_TEXT |
50 |
No |
Requested Schedule Lines Fields in Siebel Order ASI
The following table lists the Requested Schedule Lines fields and their attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Line Number |
LineNumber |
DTYPE_NUMBER |
NA |
No |
Order Item Id |
OrderItemId |
DTYPE_ID |
NA |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
NA |
No |
Requested Quantity |
RequestedQuantity |
DTYPE_NUMBER |
NA |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Related Shipment Fields in Siebel Order ASI
The following table lists the Related Shipment fields and their attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Destination Inventory Location Id |
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 Fields in Siebel Order ASI
The following table lists the Shipment Item field and their attributes in Siebel Order ASI.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
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 |