Table 73. Siebel SAP Account ASI Fields
Name
|
XML Tag
|
Data Type
|
Length
|
Req.
|
Notes
|
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
|
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
N
|
|
Currency Code
|
CurrencyCode
|
DTYPE_TEXT
|
15
|
N
|
|
Customer Account Group
|
CustomerAccountGroup
|
DTYPE_TEXT
|
30
|
N
|
|
DUNS Number
|
DUNSNumber
|
DTYPE_TEXT
|
15
|
N
|
|
Description
|
Description
|
DTYPE_TEXT
|
255
|
N
|
|
Disable DataCleansing
|
DisableDataCleansing
|
DTYPE_TEXT
|
|
N
|
|
Division
|
Division
|
DTYPE_TEXT
|
30
|
N
|
|
Domestic Ultimate DUNS
|
DomesticUltimateDUNS
|
DTYPE_TEXT
|
15
|
N
|
|
EAI Sync Date
|
EAISyncDate
|
DTYPE_TEXT
|
|
N
|
|
EAI Sync Error Text
|
EAISyncErrorText
|
DTYPE_TEXT
|
2,000
|
N
|
|
EAI Sync Status Code
|
EAISyncStatusCode
|
DTYPE_TEXT
|
30
|
N
|
|
Expertise
|
Expertise
|
DTYPE_TEXT
|
30
|
N
|
|
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
|
|
Internal Org Flag
|
InternalOrgFlag
|
DTYPE_TEXT
|
|
N
|
|
Language Code
|
LanguageCode
|
DTYPE_ID
|
|
N
|
|
Location
|
Location
|
DTYPE_TEXT
|
50
|
N
|
|
Main Fax Number
|
MainFaxNumber
|
DTYPE_TEXT
|
|
N
|
|
Main Phone Number
|
MainPhoneNumber
|
DTYPE_TEXT
|
|
N
|
|
Name
|
Name
|
DTYPE_TEXT
|
100
|
N
|
|
PO Approved Flag
|
POApprovedFlag
|
DTYPE_TEXT
|
|
N
|
|
PO Auto Approval Currency Code
|
POAutoApprovalCurrencyCode
|
DTYPE_TEXT
|
20
|
N
|
|
PO Auto Approval Date
|
POAutoApprovalDate
|
DTYPE_DATETIME
|
|
N
|
|
PO Auto Approval Limit
|
POAutoApprovalLimit
|
DTYPE_TEXT
|
|
N
|
|
Parent Account Division
|
ParentAccountDivision
|
DTYPE_TEXT
|
30
|
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
|
|
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
|
PrimaryFulfillInvLocIntegrationId
|
DTYPE_ID
|
|
N
|
|
Primary Fulfillment InvLoc ID
|
PrimaryFulfillmentInvLocID
|
DTYPE_TEXT
|
|
N
|
|
Primary Fulfillment Inventory Location
|
PrimaryFulfillmentInventoryLocation
|
DTYPE_TEXT
|
|
N
|
|
Primary Industry Id
|
PrimaryIndustryId
|
DTYPE_ID
|
|
N
|
|
Primary Organization
|
PrimaryOrganization
|
DTYPE_TEXT
|
100
|
N
|
|
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
|
|
Start Date
|
StartDate
|
DTYPE_DATETIME
|
|
N
|
|
Strategies
|
Strategies
|
DTYPE_TEXT
|
500
|
N
|
|
Strategy
|
Strategy
|
DTYPE_TEXT
|
2,000
|
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
|
|
operation
|
operation
|
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
|
|
City
|
City
|
DTYPE_TEXT
|
50
|
N
|
|
Country
|
Country
|
DTYPE_TEXT
|
50
|
N
|
|
County
|
County
|
DTYPE_TEXT
|
50
|
N
|
|
Disable DataCleansing
|
DisableDataCleansing
|
DTYPE_TEXT
|
|
N
|
|
Email Address
|
EmailAddress
|
DTYPE_TEXT
|
50
|
N
|
|
Fax Number
|
FaxNumber
|
DTYPE_TEXT
|
|
N
|
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
N
|
|
Phone Number
|
PhoneNumber
|
DTYPE_TEXT
|
|
N
|
|
Postal Code
|
PostalCode
|
DTYPE_TEXT
|
30
|
N
|
|
Province
|
Province
|
DTYPE_TEXT
|
50
|
N
|
|
State
|
State
|
DTYPE_TEXT
|
10
|
N
|
|
Street Address
|
StreetAddress
|
DTYPE_TEXT
|
200
|
N
|
|
Street Address 2
|
StreetAddress2
|
DTYPE_TEXT
|
100
|
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
|
|
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 Credit Control Area
|
Block Credit Flag
|
BlockCreditFlag
|
DTYPE_TEXT
|
|
N
|
|
Credit Control Area Code
|
CreditControlAreaCode
|
DTYPE_TEXT
|
30
|
N
|
|
Related Partner Function Bill To
|
Bill To Partner Function
|
BillToPartnerFunction
|
DTYPE_TEXT
|
100
|
N
|
|
CSN
|
CSN
|
DTYPE_TEXT
|
30
|
N
|
|
Id
|
Id
|
DTYPE_TEXT
|
30
|
N
|
|
Integration Id
|
IntegrationId
|
DTYPE_TEXT
|
30
|
N
|
|
Location
|
Location
|
DTYPE_TEXT
|
50
|
N
|
|
Related Partner Function Payer
|
CSN
|
CSN
|
DTYPE_TEXT
|
30
|
N
|
|
Id
|
Id
|
DTYPE_TEXT
|
30
|
N
|
|
Integration Id
|
IntegrationId
|
DTYPE_TEXT
|
30
|
N
|
|
Location
|
Location
|
DTYPE_TEXT
|
50
|
N
|
|
Payer Partner Function
|
PayerPartnerFunction
|
DTYPE_TEXT
|
100
|
N
|
|
Related Partner Function Ship To
|
CSN
|
CSN
|
DTYPE_TEXT
|
30
|
N
|
|
Id
|
Id
|
DTYPE_TEXT
|
30
|
N
|
|
Integration Id
|
IntegrationId
|
DTYPE_TEXT
|
30
|
N
|
|
Location
|
Location
|
DTYPE_TEXT
|
50
|
N
|
|
Ship To Partner Function
|
ShipToPartnerFunction
|
DTYPE_TEXT
|
100
|
N
|
|
Related Partner Function Sold To
|
CSN
|
CSN
|
DTYPE_TEXT
|
30
|
N
|
|
Id
|
Id
|
DTYPE_TEXT
|
30
|
N
|
|
Integration Id
|
IntegrationId
|
DTYPE_TEXT
|
30
|
N
|
|
Location
|
Location
|
DTYPE_TEXT
|
50
|
N
|
|
Sold To Partner Function
|
SoldToPartnerFunction
|
DTYPE_TEXT
|
100
|
N
|
|
Related Sales Area
|
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_ID
|
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
|
|
Price List Type
|
PriceListType
|
DTYPE_ID
|
|
N
|
|
Primary Bill To Account Id
|
PrimaryBillToAccountId
|
DTYPE_ID
|
|
N
|
|
Primary Fulfillment InvLoc ID
|
PrimaryFulfillmentInvLocID
|
DTYPE_ID
|
|
N
|
|
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
|
|