Table 53. Siebel Quote/External Quote ASI Fields
|
|
|
|
|
|
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. |
