Table 11. Siebel Account ASI Fields
|
|
|
|
|
|
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 |
|
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 |
