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