Table 11. Siebel Account/External Account ASI Fields
Name
|
XML Tag
|
Data Type
|
Length
|
Req.
|
Notes
|
Account
|
Account Id
|
AccountId
|
DTYPE_ID
|
15
|
|
Used for picking related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
User key for Account.
|
Account Status
|
AccountStatus
|
DTYPE_TEXT
|
24
|
|
Bound by ACCOUNT_STATUS LOV.
|
Alias
|
Alias
|
DTYPE_TEXT
|
50
|
|
|
Assignment Area Code
|
AssignmentAreaCode
|
DTYPE_TEXT
|
5
|
|
|
Assignment Country Code
|
AssignmentCountryCode
|
DTYPE_TEXT
|
5
|
|
|
Competitor Flag
|
CompetitorFlag
|
DTYPE_BOOL
|
1
|
|
|
Credit Auto Approval Limit
|
CreditAutoApprovalLimit
|
DTYPE_CURRENCY
|
22
|
|
|
Credit Status Date
|
CreditStatusDate
|
DTYPE_UTCDATETIME
|
7
|
|
|
Currency Code
|
CurrencyCode
|
DTYPE_TEXT
|
15
|
|
Used for picking related entity.
|
DUNS Number
|
DUNSNumber
|
DTYPE_TEXT
|
15
|
|
|
Domestic Ultimate DUNS
|
DomesticUltimateDUNS
|
DTYPE_TEXT
|
15
|
|
|
Expertise
|
Expertise
|
DTYPE_TEXT
|
30
|
|
Bound by ACCOUNT_EXPERTISE LOV.
|
Global Ultimate DUNS
|
GlobalUltimateDUNS
|
DTYPE_TEXT
|
15
|
|
|
Home Page
|
HomePage
|
DTYPE_TEXT
|
100
|
|
|
Integration Id
|
IntegrationId
|
DTYPE_TEXT
|
30
|
|
User key for Account.
|
Location
|
Location
|
DTYPE_TEXT
|
50
|
|
User key for Account.
|
Main Fax Number
|
MainFaxNumber
|
DTYPE_PHONE
|
40
|
|
|
Main Phone Number
|
MainPhoneNumber
|
DTYPE_PHONE
|
40
|
|
|
Name
|
Name
|
DTYPE_TEXT
|
100
|
|
User key for Account.
|
Number of Employees
|
NumberofEmployees
|
DTYPE_NUMBER
|
22
|
|
|
PO Approved Flag
|
POApprovedFlag
|
DTYPE_BOOL
|
1
|
|
|
PO Auto Approval Currency Code
|
POAutoApprovalCurrencyCode
|
DTYPE_TEXT
|
20
|
|
Used for picking related entityUsed for picking related entity.
|
PO Auto Approval Date
|
POAutoApprovalDate
|
DTYPE_DATE
|
7
|
|
|
PO Auto Approval Limit
|
POAutoApprovalLimit
|
DTYPE_CURRENCY
|
22
|
|
|
Parent Account Id
|
ParentAccountId
|
DTYPE_ID
|
15
|
|
|
Parent Account Integration Id
|
ParentAccountIntegrationId
|
DTYPE_TEXT
|
30
|
|
Used for picking related entity.
|
Parent Account Location
|
ParentAccountLocation
|
DTYPE_TEXT
|
50
|
|
|
Parent Account Name
|
ParentAccountName
|
DTYPE_TEXT
|
100
|
|
Used for picking related entity.
|
Parent HQ DUNS
|
ParentHQDUNS
|
DTYPE_TEXT
|
15
|
|
|
Partner Flag
|
PartnerFlag
|
DTYPE_BOOL
|
1
|
|
|
Price List
|
PriceList
|
DTYPE_TEXT
|
50
|
|
Used for picking related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
|
Price List Id
|
PriceListId
|
DTYPE_ID
|
15
|
|
|
Price List Integration Id
|
PriceListIntegrationId
|
DTYPE_TEXT
|
30
|
|
Used for picking related entity.
|
Primary Organization
|
PrimaryOrganization
|
DTYPE_TEXT
|
100
|
|
User key for Account.
|
Skip Credit Check
|
SkipCreditCheck
|
DTYPE_BOOL
|
1
|
|
|
Type
|
Type
|
DTYPE_TEXT
|
30
|
|
Bound by ACCOUNT_TYPE LOV.
|
VAT registration number
|
VATregistrationnumber
|
DTYPE_TEXT
|
30
|
|
|
Business Address
|
Address Id
|
AddressId
|
DTYPE_ID
|
15
|
|
This read-only field is automatically populated by Siebel application on insertion and cannot be updated.
User key field for Business Address
|
Address Integration Id
|
AddressIntegrationId
|
DTYPE_TEXT
|
30
|
|
User key field for Business Address
|
City
|
City
|
DTYPE_TEXT
|
50
|
|
|
Country
|
Country
|
DTYPE_TEXT
|
50
|
|
Bound by COUNTRY LOV.
|
County
|
County
|
DTYPE_TEXT
|
50
|
|
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
This field determine if this child record is the primary one. The value is determined in run time.
|
Postal Code
|
PostalCode
|
DTYPE_TEXT
|
30
|
|
|
Province
|
Province
|
DTYPE_TEXT
|
50
|
|
|
State
|
State
|
DTYPE_TEXT
|
10
|
|
Bound by STATE_ABBREV LOV.
|
Street Address
|
StreetAddress
|
DTYPE_TEXT
|
200
|
|
|
Street Address 2
|
Street Address2
|
DTYPE_TEXT
|
100
|
|
|
Credit Profile
|
Credit Area
|
CreditArea
|
DTYPE_TEXT
|
30
|
|
User key field for Credit Profile.
|
Credit Available
|
CreditAvailable
|
DTYPE_NUMBER
|
22
|
|
|
Credit Currency Code
|
CreditCurrencyCode
|
DTYPE_TEXT
|
20
|
|
|
Credit Limit
|
CreditLimit
|
DTYPE_NUMBER
|
22
|
|
|
Credit Profile Id
|
CreditProfileId
|
DTYPE_ID
|
15
|
|
This read-only field is automatically populated by Siebel application on insertion and cannot be updated.
User key field for Credit Profile.
|
Credit Profile Integration Id
|
CreditProfileIntegrationId
|
DTYPE_TEXT
|
30
|
|
User key field for Credit Profile.
|
Credit Status Code
|
CreditStatusCode
|
DTYPE_TEXT
|
30
|
|
Bound by ACCNT_CRDT_STAT_TYPE.
|
Credit Status Message
|
CreditStatusMessage
|
DTYPE_TEXT
|
250
|
|
|
Credit Used
|
CreditUsed
|
DTYPE_NUMBER
|
22
|
|
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
This field determine if this child record is the primary one. The value is determined in run time.
|
Risk Category Code
|
RiskCategoryCode
|
DTYPE_TEXT
|
30
|
|
Bound by RISK_CATEGORY_TYPE LOV.
|
Related Contacts
|
Contact Id
|
ContactId
|
DTYPE_ID
|
15
|
|
Used for picking a related entity.
User key field for Related Contact.
|
Contact Integration Id
|
ContactIntegrationId
|
DTYPE_TEXT
|
30
|
|
User key field for Related Contact.
|
First Name
|
FirstName
|
DTYPE_TEXT
|
50
|
|
User key field for Related Contact, along with Last Name and Middle Name.
|
Last Name
|
LastName
|
DTYPE_TEXT
|
50
|
|
User key field for Related Contact, along with First Name and Middle Name.
|
Middle Name
|
MiddleName
|
DTYPE_TEXT
|
50
|
|
User key field for Related Contact, along with First Name and Last Name.
|
Person UId
|
PersonUId
|
DTYPE_TEXT
|
100
|
|
Used for picking a related entity.
|
Primary Organization
|
PrimaryOrganization
|
DTYPE_TEXT
|
50
|
|
|
Related Industry
|
|
|
Industry
|
Industry
|
DTYPE_TEXT
|
50
|
|
|
Industry Id
|
IndustryId
|
|
|
|
This read-only field is automatically populated by Siebel application on insertion and cannot be updated.
User key field for Related Industry.
|
Industry Integration Id
|
IndustryIntegrationId
|
DTYPE_TEXT
|
30
|
|
User key field for Related Industry.
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
This field determine if this child record is the primary one. The value is determined in run time.
|
SIC Code
|
SICCode
|
DTYPE_TEXT
|
30
|
|
|
Related Organization
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
This field determine if this child record is the primary one. The value is determined in run time.
|
Organization
|
Organization
|
DTYPE_TEXT
|
50
|
|
|
Organization Id
|
OrganizationId
|
DTYPE_ID
|
15
|
|
This read-only field is automatically populated by Siebel application on insertion and cannot be updated.
User key field for Related Organization.
|
Organization Integration Id
|
OrganizationIntegrationId
|
DTYPE_TEXT
|
30
|
|
User key field for Related Organization.
|
Related Sales Rep
|
Division
|
Division
|
DTYPE_TEXT
|
255
|
|
Used for picking related entity. This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
This field determine if this child record is the primary one. The value is determined in run time.
|
Login
|
Login
|
DTYPE_TEXT
|
50
|
|
|
Position
|
Position
|
DTYPE_TEXT
|
50
|
|
|
Position Id
|
PositionId
|
DTYPE_ID
|
15
|
|
Used for picking a related entity. This read-only field is automatically populated by Siebel application on insertion and cannot be updated.
|
Position Integration Id
|
PositionIntegrationId
|
DTYPE_TEXT
|
30
|
|
|