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