Table 116. Auto Policy Interface ASI Fields
Name
|
XML Tag
|
Data Type
|
Length
|
Req.
|
Notes
|
FINS AG Agent_Business Address
|
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
City
|
City
|
DTYPE_TEXT
|
50
|
|
|
Country
|
Country
|
DTYPE_TEXT
|
50
|
|
COUNTRY LOV.
|
Postal Code
|
PostalCode
|
DTYPE_TEXT
|
30
|
|
|
State
|
State
|
DTYPE_TEXT
|
10
|
|
STATE_ABBREV LOV.
|
Street Address
|
StreetAddress
|
DTYPE_TEXT
|
200
|
|
|
Street Address 2
|
StreetAddress2
|
DTYPE_TEXT
|
100
|
|
|
Address Name
|
AddressName
|
DTYPE_TEXT
|
100
|
|
|
Integration Id
|
IntegrationId
|
DTYPE_TEXT
|
30
|
Y
|
User key field.
|
FINS AG Agent_Business Address
|
|
Active Status
|
ActiveStatus
|
DTYPE_TEXT
|
30
|
|
|
Agent Number
|
AgentNumber
|
DTYPE_TEXT
|
30
|
|
|
Alias
|
Alias
|
DTYPE_TEXT
|
50
|
|
|
Alternate Phone #
|
AlternatePhone
|
DTYPE_TEXT
|
30
|
|
|
Assignment Excluded
|
AssignmentExcluded
|
DTYPE_TEXT
|
15
|
|
|
Assistant
|
Assistant
|
DTYPE_TEXT
|
50
|
|
|
Assistant Phone #
|
AssistantPhone
|
DTYPE_TEXT
|
30
|
|
|
Birth Date
|
BirthDate
|
DTYPE_DATETIME
|
50
|
|
|
Branch Id
|
BranchId
|
DTYPE_ID
|
30
|
|
|
Call
|
Call
|
DTYPE_TEXT
|
30
|
|
|
Cellular Phone #
|
CellularPhone
|
DTYPE_TEXT
|
30
|
|
|
Citizenship
|
Citizenship
|
DTYPE_TEXT
|
30
|
|
FIN_CON_CITIZENSHIP LOV.
|
Comment
|
Comment2
|
DTYPE_TEXT
|
255
|
|
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
30
|
|
|
Contracted Since
|
ContractedSince
|
DTYPE_DATETIME
|
30
|
|
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
|
|
Created By Name
|
CreatedByName2
|
DTYPE_TEXT
|
64
|
|
|
Customer Number
|
CustomerNumber
|
DTYPE_ID
|
30
|
|
|
DeDup Key Modification Date
|
DeDupKeyModificationDate
|
DTYPE_TEXT
|
7
|
|
|
DeDup Last Match Date
|
DeDupLastMatchDate
|
DTYPE_TEXT
|
7
|
|
|
DeDup Token
|
DeDupToken
|
DTYPE_TEXT
|
100
|
|
|
Disable DataCleansing
|
DisableDataCleansing
|
DTYPE_TEXT
|
1
|
|
|
Email Address
|
EmailAddress
|
DTYPE_TEXT
|
50
|
|
|
Email Address 2
|
EmailAddress2
|
DTYPE_TEXT
|
50
|
|
|
Email SR Updates Flag
|
EmailSRUpdatesFlag
|
DTYPE_TEXT
|
1
|
|
|
Email Usage
|
EmailUsage
|
DTYPE_TEXT
|
30
|
|
FIN_EMAIL_USAGE LOV.
|
Email Usage 2
|
EmailUsage2
|
DTYPE_TEXT
|
30
|
|
FIN_EMAIL_USAGE LOV.
|
Employee Id
|
EmployeeId
|
DTYPE_ID
|
30
|
|
|
Fax Phone #
|
FaxPhone
|
DTYPE_TEXT
|
50
|
|
|
First Name
|
FirstName
|
DTYPE_TEXT
|
50
|
|
|
Home Phone #
|
HomePhone
|
DTYPE_TEXT
|
50
|
|
|
Id
|
Id
|
DTUPE_ID
|
30
|
Y
|
I. User Key Field.
|
Income
|
Income
|
DTYPE_TEXT
|
30
|
|
|
Income Currency Code
|
IncomeCurrencyCode
|
DTYPE_TEXT
|
20
|
|
|
Income Exchange Date
|
IncomeExchangeDate
|
DTYPE_DATETIME
|
7
|
|
|
Integration Id
|
IntegrationId
|
DTYPE_TEXT
|
30
|
|
|
Invite To Seminars
|
InviteToSeminars
|
DTYPE_TEXT
|
15
|
|
|
Is Agent
|
IsAgent
|
DTYPE_TEXT
|
1
|
|
|
Job Title
|
JobTitle
|
DTYPE_TEXT
|
75
|
|
|
Language Id
|
LanguageId
|
DTYPE_ID
|
30
|
|
|
Last Clnse Date
|
LastClnseDate
|
DTYPE_TEXT
|
7
|
|
|
Last Name
|
LastName
|
DTYPE_TEXT
|
50
|
|
|
Login Name
|
LoginName
|
DTYPE_TEXT
|
50
|
|
|
Login Password
|
LoginPassword
|
DTYPE_TEXT
|
30
|
|
|
M/F
|
MF
|
DTYPE_TEXT
|
30
|
|
SEX_MF LOV.
|
M/M
|
MM
|
DTYPE_TEXT
|
15
|
|
MR_MS LOV.
|
Mail Stop
|
MailStop
|
DTYPE_TEXT
|
30
|
|
|
Manager First Name
|
ManagerFirstName
|
DTYPE_TEXT
|
50
|
|
|
Manager Id
|
ManagerId
|
DTYPE_ID
|
30
|
|
|
Manager Last Name
|
ManagerLastName
|
DTYPE_TEXT
|
50
|
|
|
Manager Tenure
|
ManagerTenure
|
DTYPE_TEXT
|
20
|
|
|
Marital Status
|
MaritalStatus
|
DTYPE_TEXT
|
30
|
|
MARITAL_STATUS.
|
Member Flg
|
MemberFlg
|
DTYPE_TEXT
|
1
|
|
|
Middle Name
|
MiddleName
|
DTYPE_TEXT
|
50
|
|
|
Mother Maiden Name
|
MotherMaidenName
|
DTYPE_TEXT
|
50
|
|
|
Owned By
|
OwnedBy
|
DTYPE_TEXT
|
50
|
|
|
Owned By Id
|
OwnedById
|
DTYPE_ID
|
30
|
|
|
Partnership Contact Flag
|
PartnershipContactFlag
|
DTYPE_TEXT
|
1
|
|
|
Partnership Key Contact Flag
|
PartnershipKeyContactFlag
|
DTYPE_TEXT
|
1
|
|
|
Party Name
|
PartyName
|
DTYPE_TEXT
|
30
|
|
|
Party Type Code
|
PartyTypeCode
|
DTYPE_TEXT
|
30
|
|
|
Party UId
|
PartyUId
|
DTYPE_TEXT
|
30
|
|
|
Persistency Ratio
|
PersistencyRatio
|
DTYPE_NUMBER
|
15
|
|
|
Person UId
|
PersonUId
|
DTYPE_TEXT
|
100
|
|
|
Personal Contact
|
PersonalContact
|
DTYPE_TEXT
|
100
|
|
|
Personal Win
|
PersonalWin
|
DTYPE_TEXT
|
250
|
|
|
Preferred Communications
|
PreferredCommunications
|
DTYPE_TEXT
|
30
|
|
|
Primary Address Id
|
PrimaryAddressId
|
DTYPE_ID
|
30
|
|
|
Primary Agency Id
|
PrimaryAgencyId
|
DTYPE_ID
|
30
|
|
|
Primary Asset Id
|
PrimaryAssetId
|
DTYPE_ID
|
30
|
|
|
Primary Assignment Denorm Flag
|
PrimaryAssignmentDenormFlag
|
DTYPE_TEXT
|
1
|
|
|
Primary Assignment Manual Flag
|
PrimaryAssignmentManualFlag
|
DTYPE_TEXT
|
1
|
|
|
Primary Assignment System Flag
|
PrimaryAssignmentSystemFlag
|
DTYPE_TEXT
|
1
|
|
|
Primary Category Id
|
PrimaryCategoryId
|
DTYPE_TEXT
|
30
|
|
|
Primary Group/Household Id
|
PrimaryGroupHouseholdId
|
DTYPE_ID
|
30
|
|
|
Primary Held Position Id
|
PrimaryHeldPositionId
|
DTYPE_ID
|
30
|
|
|
Primary Note Id
|
PrimaryNoteId
|
DTYPE_ID
|
30
|
|
|
Primary Opportunity Id
|
PrimaryOpportunityId
|
DTYPE_ID
|
30
|
|
|
Primary Organization
|
PrimaryOrganization
|
DTYPE_TEXT
|
50
|
|
|
Primary Organization Id
|
PrimaryOrganizationId
|
DTYPE_ID
|
30
|
|
|
Primary Personal Address Id
|
PrimaryPersonalAddressId
|
DTYPE_ID
|
30
|
|
|
Primary Personal Payment Profile Id
|
PrimaryPersonalPaymentProfileId
|
DTYPE_ID
|
30
|
|
|
Primary Position Id
|
PrimaryPositionId
|
DTYPE_ID
|
30
|
|
|
Primary Product Line Id
|
PrimaryProductLineId
|
DTYPE_ID
|
30
|
|
|
Provider Flag
|
ProviderFlag
|
DTYPE_TEXT
|
1
|
|
|
Region Id
|
RegionId
|
DTYPE_ID
|
30
|
|
|
Registration Source App Name
|
RegistrationSourceAppName
|
DTYPE_TEXT
|
30
|
|
|
Short Name
|
ShortName
|
DTYPE_TEXT
|
50
|
|
|
Social Security Number
|
SocialSecurityNumber
|
DTYPE_TEXT
|
11
|
|
|
Source Id
|
SourceId
|
DTYPE_ID
|
30
|
|
|
Start Date
|
StartDate
|
DTYPE_DATETIME
|
7
|
|
|
Suffix
|
Suffix
|
DTYPE_TEXT
|
15
|
|
|
Time Zone
|
TimeZone
|
DTYPE_TEXT
|
30
|
|
TIMEZONE LOV.
|
Time Zone Id
|
TimeZoneId
|
DTYPE_ID
|
30
|
|
|
Time Zone Name
|
TimeZoneName
|
DTYPE_TEXT
|
100
|
|
|
Updated
|
Updated
|
DTYPE_DATETIME
|
30
|
|
|
User Type
|
UserType
|
DTYPE_TEXT
|
30
|
|
CONTACT_USER_TYPE LOV.
|
Work Phone #
|
WorkPhone
|
DTYPE_TEXT
|
50
|
|
|
Work Phone Extension
|
WorkPhoneExtension
|
DTYPE_TEXT
|
10
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
INS Driver
|
|
# Jobs Last 5 Years
|
JobsLast5Years
|
DTYPE_NUMBER
|
|
|
|
# Years Driving
|
YearsDriving
|
DTYPE_TEXT
|
50
|
|
INS_YEARS_DRIVING_EXP LOV Unbounded.
|
# Years Employed
|
YearsEmployed
|
DTYPE_NUMBER
|
15
|
|
|
Account Id
|
AccountId
|
DTYPE_ID
|
30
|
|
|
Affinity Group
|
AffinityGroup
|
DTYPE_TEXT
|
30
|
|
FINS_AFFIN_BOAT_COURSE_MLOV LOV.
|
Age
|
Age
|
DTYPE_NUMBER
|
15
|
|
|
Asset Con Id
|
AssetConId
|
DTYPE_ID
|
30
|
|
|
Asset Id
|
AssetId
|
DTYPE_ID
|
30
|
|
|
Birth Date
|
BirthDate
|
DTYPE_DATETIME
|
50
|
|
|
Cellular Phone Number
|
CellularPhoneNumber
|
DTYPE_TEXT
|
50
|
|
|
Comment
|
Comment2
|
DTYPE_TEXT
|
255
|
|
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
30
|
|
|
Course Date
|
CourseDate
|
DTYPE_DATETIME
|
50
|
|
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
|
|
Created By Name
|
CreatedByName2
|
DTYPE_TEXT
|
50
|
|
|
Criminal Conviction
|
CriminalConviction
|
DTYPE_TEXT
|
50
|
|
|
Description
|
Description
|
DTYPE_TEXT
|
255
|
|
|
Discount Name
|
DiscountName
|
DTYPE_TEXT
|
50
|
|
|
Driver Code
|
DriverCode
|
DTYPE_TEXT
|
30
|
|
INS_DRIVER_TYPE LOV.
|
Driver Id
|
DriverId
|
DTYPE_ID
|
30
|
|
|
Driver Status
|
DriverStatus
|
DTYPE_TEXT
|
30
|
|
CONTACT_STATUS LOV.
|
Driver Type
|
DriverType
|
DTYPE_TEXT
|
30
|
|
|
Drug or Alcohol Offense
|
DrugorAlcoholOffense
|
DTYPE_TEXT
|
1
|
|
|
Education Level
|
EducationLevel
|
DTYPE_TEXT
|
30
|
|
FINS_CLM_IN_ACC_EDU_MLOV LOV (Unbounded).
|
Employers Name
|
EmployersName
|
DTYPE_TEXT
|
30
|
|
|
Fax Phone Number
|
FaxPhoneNumber
|
DTYPE_TEXT
|
50
|
|
|
First Insurance Date
|
FirstInsuranceDate
|
DTYPE_DATETIME
|
7
|
|
|
First Name
|
FirstName
|
DTYPE_TEXT
|
50
|
|
|
GPA
|
GPA
|
DTYPE_NUMBER
|
15
|
|
|
Gender
|
Gender
|
DTYPE_TEXT
|
1
|
|
SEX_MF LOV.
|
Home Phone Number
|
HomePhoneNumber
|
DTYPE_TEXT
|
15
|
|
|
Honor Student
|
HonorStudent
|
DTYPE_TEXT
|
1
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
Y
|
I, User key field.
|
Impairment Description
|
ImpairmentDescription
|
DTYPE_TEXT
|
100
|
|
|
In Household
|
InHousehold
|
DTYPE_TEXT
|
1
|
|
|
Income
|
Income
|
DTYPE_TEXT
|
30
|
|
|
Income Currency Code
|
IncomeCurrencyCode
|
DTYPE_TEXT
|
30
|
|
|
Income Exchange Date
|
IncomeExchangeDate
|
DTYPE_DATETIME
|
7
|
|
|
Judgement
|
Judgement
|
DTYPE_TEXT
|
50
|
|
|
Judgement Description
|
JudgementDescription
|
DTYPE_TEXT
|
250
|
|
|
Last Name
|
LastName
|
DTYPE_TEXT
|
50
|
|
|
Latest Rating Date
|
LatestRatingDate
|
DTYPE_DATETIME
|
7
|
|
|
License Suspension
|
LicenseSuspension
|
DTYPE_TEXT
|
1
|
|
|
M/M
|
MM
|
DTYPE_TEXT
|
15
|
|
MR_MS LOV.
|
Marital Status
|
MaritalStatus
|
DTYPE_TEXT
|
30
|
|
MARITAL_STATUS LOV.
|
Middle Name
|
MiddleName
|
DTYPE_TEXT
|
50
|
|
|
Mod Id
|
ModId
|
DTYPE_ID
|
30
|
|
|
Motorcycle Years
|
MotorcycleYears
|
DTYPE_NUMBER
|
15
|
|
|
Named Insured
|
NamedInsured
|
DTYPE_TEXT
|
100
|
|
|
Named Insured Code
|
NamedInsuredCode
|
DTYPE_TEXT
|
30
|
|
INS_NAMED_INSURED_STATUS LOV.
|
Occupation
|
Occupation
|
DTYPE_TEXT
|
50
|
|
FINS_DRVOCC_DWLOCC_MLOV LOV.
|
Organization Id
|
OrganizationId
|
DTYPE_ID
|
30
|
|
|
Owned By
|
OwnedBy
|
DTYPE_TEXT
|
50
|
|
|
Owned By Id
|
OwnedById
|
DTYPE_ID
|
30
|
|
|
Owner Code
|
OwnerCode
|
DTYPE_TEXT
|
30
|
|
|
Party Name
|
PartyName
|
DTYPE_TEXT
|
30
|
|
|
Party Type Code
|
PartyTypeCode
|
DTYPE_TEXT
|
30
|
|
|
Party UId
|
PartyUId
|
DTYPE_TEXT
|
30
|
|
|
Person UId
|
PersonUId
|
DTYPE_TEXT
|
100
|
|
|
Personal City
|
PersonalCity
|
DTYPE_TEXT
|
50
|
|
|
Personal Contact
|
PersonalContact
|
DTYPE_TEXT
|
100
|
|
|
Personal Postal Code
|
PersonalPostalCode
|
DTYPE_TEXT
|
30
|
|
|
Personal State
|
PersonalState
|
DTYPE_TEXT
|
10
|
|
|
Personal Street Address
|
PersonalStreetAddress
|
DTYPE_TEXT
|
200
|
|
|
Place of Birth
|
PlaceofBirth
|
DTYPE_TEXT
|
50
|
|
|
Primary Group/Household Id
|
PrimaryGroupHouseholdId
|
DTYPE_ID
|
30
|
|
|
Primary Personal Address Id
|
PrimaryPersonalAddressId
|
DTYPE_ID
|
30
|
|
|
Primary Position Id
|
PrimaryPositionId
|
DTYPE_ID
|
30
|
|
|
Prior Year # Claims
|
PriorYearClaims
|
DTYPE_NUMBER
|
15
|
|
|
Relationship to Named Insured
|
RelationshiptoNamedInsured
|
DTYPE_TEXT
|
30
|
|
INS_DRIVER_RELATIONSHIP LOV.
|
SDIP Points
|
SDIPPoints
|
DTYPE_TEXT
|
50
|
|
INS_SDIP_POINTS LOV.
|
Social Security Number
|
SocialSecurityNumber
|
DTYPE_TEXT
|
11
|
|
|
Suffix
|
Suffix
|
DTYPE_TEXT
|
15
|
|
FINS_SUFFIX_MLOV LOV.
|
Suspension Date
|
SuspensionDate
|
DTYPE_DATETIME
|
7
|
|
|
Updated
|
Updated
|
DTYPE_DATETIME
|
30
|
|
|
Work Phone Number
|
WorkPhoneNumber
|
DTYPE_TEXT
|
50
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
INS Driver Coverage for ACORD
|
|
Asset Id
|
AssetId
|
DTYPE_ID
|
30
|
|
|
Code
|
Code
|
DTYPE_TEXT
|
30
|
|
INS_DRIVER_COVERAGE_TYPE LOV.
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
30
|
|
|
Coverage Number
|
CoverageNumber
|
DTYPE_TEXT
|
50
|
|
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
|
|
Currency Code
|
CurrencyCode
|
DTYPE_TEXT
|
30
|
|
|
Driver Id
|
DriverId
|
DTYPE_ID
|
30
|
|
|
Exchange Date
|
ExchangeDate
|
DTYPE_DATETIME
|
7
|
|
|
First Name
|
FirstName
|
DTYPE_TEXT
|
50
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
Y
|
I, User Key Field.
|
Last Name
|
LastName
|
DTYPE_TEXT
|
50
|
|
|
Limit
|
Limit
|
DTYPE_TEXT
|
30
|
|
INS_DRIVER_COVERAGE_LIMIT LOV.
|
M/M
|
MM
|
DTYPE_TEXT
|
15
|
|
|
Middle Name
|
MiddleName2
|
DTYPE_TEXT
|
15
|
|
|
Mod Id
|
ModId
|
DTYPE_ID
|
30
|
|
|
Premium
|
Premium
|
DTYPE_TEXT
|
20
|
|
|
Suffix
|
Suffix
|
DTYPE_TEXT
|
15
|
|
|
Type
|
Type
|
DTYPE_TEXT
|
30
|
|
|
Updated
|
Updated
|
DTYPE_DATETIME
|
30
|
|
|
Week
|
Week
|
DTYPE_NUMBER
|
15
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
INS Driver License
|
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
30
|
|
|
Contact Id
|
ContactId
|
DTYPE_ID
|
30
|
|
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
|
|
Expiration Date
|
ExpirationDate2
|
DTYPE_DATETIME
|
7
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
Y
|
I, User Key Field.
|
Issue Date
|
IssueDate
|
DTYPE_DATETIME
|
7
|
|
|
License Number
|
LicenseNumber
|
DTYPE_TEXT
|
30
|
|
|
Mod Id
|
ModId
|
DTYPE_ID
|
30
|
|
|
Primary Restriction Id
|
PrimaryRestrictionId
|
DTYPE_ID
|
30
|
|
|
State
|
State
|
DTYPE_TEXT
|
10
|
|
STATE_ABBREV LOV.
|
Status
|
Status
|
DTYPE_TEXT
|
30
|
|
INS_DRIVER_LICENSE_STATUS LOV.
|
Updated
|
Updated
|
DTYPE_DATETIME
|
30
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
INS Driver_Personal Address
|
|
Address Name
|
AddressName
|
DTYPE_TEXT
|
100
|
|
|
INS Personal City
|
INSPersonalCity
|
DTYPE_TEXT
|
50
|
|
|
INS Personal Country
|
INSPersonalCountry
|
DTYPE_TEXT
|
50
|
|
COUNTRY LOV.
|
INS Personal Postal Code
|
INSPersonalPostalCode
|
DTYPE_TEXT
|
30
|
|
|
INS Personal State
|
INSPersonalState
|
DTYPE_TEXT
|
10
|
|
STATE_ABBREV LOV.
|
INS Personal Street Address
|
INSPersonalStreetAddress
|
DTYPE_TEXT
|
200
|
|
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
INS Pay Plan
|
|
Account Id
|
AccountId
|
DTYPE_ID
|
30
|
|
|
Account Name
|
AccountName
|
DTYPE_TEXT
|
100
|
|
|
Account Number
|
AccountNumber
|
DTYPE_TEXT
|
30
|
|
|
Account Type
|
AccountType
|
DTYPE_TEXT
|
30
|
|
INS_EFT_ACCOUNT_TYPE LOV.
|
Acnt Billing Address Id
|
AcntBillingAddressId
|
DTYPE_ID
|
30
|
|
|
Amount
|
Amount
|
DTYPE_TEXT
|
20
|
|
|
Asset Id
|
AssetId
|
DTYPE_ID
|
30
|
|
|
Begin Date
|
BeginDate
|
DTYPE_DATETIME
|
7
|
|
|
Bill To Other Flag
|
BillToOtherFlag
|
DTYPE_TEXT
|
1
|
|
|
Billing Address Id
|
BillingAddressId
|
DTYPE_ID
|
30
|
|
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
30
|
|
|
Contact Account Id
|
ContactAccountId
|
DTYPE_ID
|
30
|
|
|
Contact Id
|
ContactId
|
DTYPE_ID
|
30
|
|
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
|
|
Credit Card City
|
CreditCardCity
|
DTYPE_TEXT
|
50
|
|
|
Credit Card Country
|
CreditCardCountry
|
DTYPE_TEXT
|
30
|
|
LOV (COUNTRY LOV).
|
Credit Card Number
|
CreditCardNumber
|
DTYPE_TEXT
|
20
|
|
|
Credit Card Postal Code
|
CreditCardPostalCode
|
DTYPE_TEXT
|
30
|
|
|
Credit Card State
|
CreditCardState
|
DTYPE_TEXT
|
10
|
|
LOV (STAE_ABBREV LOV).
|
Credit Card Street Address
|
CreditCardStreetAddress
|
DTYPE_TEXT
|
200
|
|
|
Currency Code
|
CurrencyCode2
|
DTYPE_TEXT
|
15
|
|
|
Deduction Day
|
DeductionDay
|
DTYPE_TEXT
|
10
|
|
|
Deduction Notice
|
DeductionNotice
|
DTYPE_TEXT
|
30
|
|
BOOLEAN_VALUE LOV.
|
Department Number
|
DepartmentNumber
|
DTYPE_TEXT
|
30
|
|
|
Due Date
|
DueDate
|
DTYPE_DATETIME
|
7
|
|
|
End Date
|
EndDate
|
DTYPE_DATETIME
|
7
|
|
|
Exchange Date
|
ExchangeDate
|
DTYPE_DATETIME
|
7
|
|
|
Expiration Date
|
ExpirationDate2
|
DTYPE_DATETIME
|
7
|
|
|
Fees
|
Fees
|
DTYPE_TEXT
|
20
|
|
|
Financial Institution Name
|
FinancialInstitutionName
|
DTYPE_TEXT
|
100
|
|
|
First Name
|
FirstName
|
DTYPE_TEXT
|
50
|
|
|
Frequency
|
Frequency
|
DTYPE_TEXT
|
30
|
|
INS_PAYMENT_FREQUENCY LOV.
|
Id
|
Id
|
DTYPE_ID
|
30
|
Y
|
I, User Key Field.
|
Last Name
|
LastName
|
DTYPE_TEXT
|
50
|
|
|
Last Name Copy Accnt Addr
|
LastNameCopyAccntAddr
|
DTYPE_TEXT
|
50
|
|
|
Member Number
|
MemberNumber
|
DTYPE_TEXT
|
30
|
|
|
Method
|
Method
|
DTYPE_TEXT
|
30
|
|
FINS_PAY_METD_PQ_UMB_LIM_MLOV LOV.
|
Middle Name
|
MiddleName2
|
DTYPE_TEXT
|
15
|
|
|
Mod Id
|
ModId
|
DTYPE_ID
|
30
|
|
|
Paid Receipt Required
|
PaidReceiptRequired
|
DTYPE_TEXT
|
1
|
|
|
Plan Number
|
PlanNumber
|
DTYPE_TEXT
|
30
|
|
|
Policy Category
|
PolicyCategory
|
DTYPE_TEXT
|
30
|
|
|
Routing Number
|
RoutingNumber
|
DTYPE_TEXT
|
30
|
|
|
Selection
|
Selection
|
DTYPE_TEXT
|
50
|
|
INS_PAYMENT_SELECTION LOV.
|
Substitution Fee Requested
|
SubstitutionFeeRequested
|
DTYPE_TEXT
|
1
|
|
|
Updated
|
Updated
|
DTYPE_DATETIME
|
30
|
|
|
Was Fee Sent to Mtg
|
WasFeeSenttoMtg
|
DTYPE_TEXT
|
1
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
INS Personal Address
|
|
Address Name
|
AddressName
|
DTYPE_TEXT
|
100
|
|
|
Bill Account Id
|
BillAccountId
|
DTYPE_ID
|
30
|
|
|
City
|
City
|
DTYPE_TEXT
|
50
|
|
|
Comment
|
Comment2
|
DTYPE_TEXT
|
255
|
|
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
30
|
|
|
Country
|
Country
|
DTYPE_TEXT
|
50
|
|
COUNTRY LOV.
|
County
|
County
|
DTYPE_TEXT
|
50
|
|
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
Y
|
I, User Key Field.
|
Mail Type Code
|
MailTypeCode
|
DTYPE_TEXT
|
30
|
|
ADDR_MAIL_TYPE_CD LOV.
|
Mod Id
|
ModId
|
DTYPE_ID
|
30
|
|
|
Person Id
|
PersonId
|
DTYPE_ID
|
30
|
|
|
Postal Code
|
PostalCode
|
DTYPE_TEXT
|
30
|
|
|
State
|
State
|
DTYPE_TEXT
|
10
|
|
STATE_ABBREV LOV.
|
Street Address
|
StreetAddress
|
DTYPE_TEXT
|
250
|
|
|
Updated
|
Updated
|
DTYPE_DATETIME
|
30
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
INS Policy
|
|
Address Id
|
AddressId
|
DTYPE_ID
|
30
|
|
|
Approval Code
|
ApprovalCode
|
DTYPE_TEXT
|
30
|
|
|
Archived
|
Archived
|
DTYPE_TEXT
|
1
|
|
|
Billing Account Id
|
BillingAccountId
|
DTYPE_ID
|
30
|
|
|
Billing Address Id
|
BillingAddressId
|
DTYPE_ID
|
30
|
|
|
Billing Due Date
|
BillingDueDate
|
DTYPE_DATETIME
|
7
|
|
|
Billing Status
|
BillingStatus
|
DTYPE_TEXT
|
30
|
|
INS_BILLING_STATUS LOV.
|
CFL Additional Residences
|
CFLAdditionalResidences
|
DTYPE_TEXT
|
30
|
|
|
CFL City
|
CFLCity
|
DTYPE_TEXT
|
50
|
|
|
CFL Country
|
CFLCountry
|
DTYPE_TEXT
|
50
|
|
COUNTRY LOV.
|
CFL Farm Acreage
|
CFLFarmAcreage
|
DTYPE_TEXT
|
30
|
|
|
CFL Farm Income
|
CFLFarmIncome
|
DTYPE_TEXT
|
20
|
|
|
CFL Postal Code
|
CFLPostalCode
|
DTYPE_TEXT
|
50
|
|
|
CFL Premium
|
CFLPremium
|
DTYPE_TEXT
|
20
|
|
|
CFL State
|
CFLState
|
DTYPE_TEXT
|
30
|
|
STATE_ABBREV LOV.
|
CFL Street Address
|
CFLStreetAddress
|
DTYPE_TEXT
|
255
|
|
|
CFL WC Currency Code
|
CFLWCCurrencyCode
|
DTYPE_TEXT
|
50
|
|
|
CFL WC Exchange Date
|
CFLWCExchangeDate
|
DTYPE_DATETIME
|
7
|
|
|
Cancelled Code
|
CancelledCode
|
DTYPE_TEXT
|
30
|
|
|
Category
|
Category
|
DTYPE_TEXT
|
30
|
|
|
City
|
City
|
DTYPE_TEXT
|
50
|
|
|
Comment
|
Comment
|
DTYPE_TEXT
|
250
|
|
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
30
|
|
|
Contact Id
|
ContactId
|
DTYPE_ID
|
30
|
|
|
Contact Relationship To Named Insured
|
ContactRelationshipToNamedInsured
|
DTYPE_TEXT
|
30
|
|
|
Country
|
Country
|
DTYPE_TEXT
|
50
|
|
COUNTRY LOV.
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
|
|
Created By First Name
|
CreatedByFirstName
|
DTYPE_TEXT
|
50
|
|
|
Created By Last Name
|
CreatedByLastName
|
DTYPE_TEXT
|
50
|
|
|
Created By Middle Name
|
CreatedByMiddleName
|
DTYPE_TEXT
|
15
|
|
|
Created By Name
|
CreatedByName
|
DTYPE_TEXT
|
100
|
|
|
Dec Name
|
DecName
|
DTYPE_TEXT
|
100
|
|
|
Description
|
Description
|
DTYPE_TEXT
|
255
|
|
|
Effective Date
|
EffectiveDate
|
DTYPE_TEXT
|
7
|
|
|
Expiration Date
|
ExpirationDate
|
DTYPE_TEXT
|
7
|
|
|
Extension Code
|
ExtensionCode
|
DTYPE_TEXT
|
30
|
|
|
FICO Score
|
FICOScore
|
DTYPE_NUMBER
|
30
|
|
|
Home Phone #
|
HomePhone
|
DTYPE_TEXT
|
50
|
|
|
IBS Reason Code
|
IBSReasonCode
|
DTYPE_TEXT
|
30
|
|
|
IBS Score
|
IBSScore
|
DTYPE_NUMBER
|
20
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
Y
|
Id, User Key Field.
|
Inception Date
|
InceptionDate
|
DTYPE_TEXT
|
7
|
|
|
Insurance Cancelled
|
InsuranceCancelled
|
DTYPE_TEXT
|
1
|
|
|
Insurance Refused
|
InsuranceRefused
|
DTYPE_TEXT
|
1
|
|
|
Line of Business
|
LineofBusiness
|
DTYPE_TEXT
|
30
|
|
INS_LINE_OF_BUSINESS LOV.
|
Master Quote Flg
|
MasterQuoteFlg
|
DTYPE_TEXT
|
1
|
|
|
Messages Referral Name
|
MessagesReferralName
|
DTYPE_TEXT
|
50
|
|
|
Mod Id
|
ModId
|
DTYPE_ID
|
30
|
|
|
Office Number
|
OfficeNumber
|
DTYPE_NUMBER
|
30
|
|
|
Organization
|
Organization
|
DTYPE_TEXT
|
50
|
|
|
Organization Id
|
OrganizationId
|
DTYPE_ID
|
30
|
|
|
Own or Rent
|
OwnorRent
|
DTYPE_TEXT
|
30
|
|
INS_OWN_OR_RENT LOV (Unbounded).
|
Parent Policy Id
|
ParentPolicyId
|
DTYPE_ID
|
30
|
|
|
Pending Cancel
|
PendingCancel
|
DTYPE_TEXT
|
1
|
|
|
Policy Cancellation Date
|
PolicyCancellationDate
|
DTYPE_TEXT
|
7
|
|
|
Policy Change Date
|
PolicyChangeDate
|
DTYPE_TEXT
|
7
|
|
|
Policy Number
|
PolicyNumber
|
DTYPE_TEXT
|
100
|
Y
|
|
Policy Pay Method
|
PolicyPayMethod
|
DTYPE_TEXT
|
50
|
|
FINS_PAY_METD_PQ_UMB_LIM_MLOV LOV.
|
Postal Code
|
PostalCode
|
DTYPE_TEXT
|
30
|
|
|
Previous Expiration Date
|
PreviousExpirationDate
|
DTYPE_DATETIME
|
7
|
|
|
Previous Insurer
|
PreviousInsurer
|
DTYPE_TEXT
|
100
|
|
INS_PREVIOUS_INSURER LOV (Unbounded).
|
Previous Insurer Years
|
PreviousInsurerYears
|
DTYPE_TEXT
|
30
|
|
FINS_PREV_INSUR_YRS LOV.
|
Previous Policy Number
|
PreviousPolicyNumber
|
DTYPE_TEXT
|
100
|
|
|
Primary Assignment Manual Flag
|
PrimaryAssignmentManualFlag
|
DTYPE_TEXT
|
1
|
|
|
Primary Assignment System Flag
|
PrimaryAssignmentSystemFlag
|
DTYPE_TEXT
|
1
|
|
|
Primary Discount Id
|
PrimaryDiscountId
|
DTYPE_ID
|
30
|
|
|
Primary First Name
|
PrimaryFirstName
|
DTYPE_TEXT
|
50
|
|
|
Primary Household Id
|
PrimaryHouseholdId
|
DTYPE_ID
|
30
|
|
|
Primary Last Name
|
PrimaryLastName
|
DTYPE_TEXT
|
50
|
|
|
Primary Middle Name
|
PrimaryMiddleName
|
DTYPE_TEXT
|
15
|
|
|
Primary Position Id
|
PrimaryPositionId
|
DTYPE_ID
|
30
|
|
|
Producer Code
|
ProducerCode
|
DTYPE_TEXT
|
30
|
|
|
Product Id
|
ProductId
|
DTYPE_ID
|
30
|
|
|
Profit
|
Profit
|
DTYPE_TEXT
|
30
|
|
|
Proof of Insurance
|
ProofofInsurance
|
DTYPE_TEXT
|
1
|
|
|
Rate Plan
|
RatePlan
|
DTYPE_TEXT
|
30
|
|
INS_RATE_PLAN LOV.
|
Rate State
|
RateState
|
DTYPE_TEXT
|
10
|
|
STATE_ABBREV LOV.
|
Reason Code
|
ReasonCode
|
DTYPE_TEXT
|
30
|
|
|
Referral Name
|
ReferralName
|
DTYPE_TEXT
|
100
|
|
|
Refused Code
|
RefusedCode
|
DTYPE_TEXT
|
30
|
|
|
Region
|
Region
|
DTYPE_TEXT
|
50
|
|
INS_REGION LOV.
|
Residence Currency Code
|
ResidenceCurrencyCode
|
DTYPE_TEXT
|
20
|
|
|
Residence Exchange Date
|
ResidenceExchangeDate
|
DTYPE_DATETIME
|
7
|
|
|
Resident Type
|
ResidentType
|
DTYPE_TEXT
|
30
|
|
INS_RESIDENCE_TYPE LOV.
|
Resident Value
|
ResidentValue
|
DTYPE_TEXT
|
30
|
|
|
Resident of Community
|
ResidentofCommunity
|
DTYPE_NUMBER
|
20
|
|
|
Revenue
|
Revenue
|
DTYPE_TEXT
|
30
|
|
|
Revision Number
|
RevisionNumber
|
DTYPE_TEXT
|
30
|
|
|
Source Policy Id
|
SourcePolicyId
|
DTYPE_ID
|
30
|
|
|
Source Policy Number
|
SourcePolicyNumber
|
DTYPE_TEXT
|
100
|
|
|
Source Policy Revision
|
SourcePolicyRevision
|
DTYPE_TEXT
|
30
|
|
|
State
|
State
|
DTYPE_TEXT
|
50
|
|
STATE_ABBREV LOV.
|
Status
|
Status
|
DTYPE_TEXT
|
30
|
|
IMPL_PHASE LOV.
|
Street Address
|
StreetAddress
|
DTYPE_TEXT
|
250
|
|
|
Sub Status
|
SubStatus
|
DTYPE_TEXT
|
30
|
|
INS_POLICY_SUB_STATUS LOV.
|
Total Premium
|
TotalPremium
|
DTYPE_TEXT
|
30
|
|
|
Total Premium Currency Code
|
TotalPremiumCurrencyCode
|
DTYPE_TEXT
|
20
|
|
|
Total Premium Exchange Date
|
TotalPremiumExchangeDate
|
DTYPE_DATETIME
|
7
|
|
|
Total Tax
|
TotalTax
|
DTYPE_NUMBER
|
30
|
|
|
Type
|
Type
|
DTYPE_TEXT
|
30
|
|
FINS_ASS_LIAB_ALL_LIF_PLC_MLOV LOV.
|
Under Age
|
UnderAge
|
DTYPE_TEXT
|
15
|
|
|
Updated
|
Updated
|
DTYPE_DATETIME
|
30
|
|
|
Version
|
Version
|
DTYPE_TEXT
|
30
|
|
|
Warranty End Date
|
WarrantyEndDate
|
DTYPE_DATETIME
|
7
|
|
|
Warranty Start Date
|
WarrantyStartDate
|
DTYPE_DATETIME
|
7
|
|
|
Warranty Type
|
WarrantyType
|
DTYPE_TEXT
|
30
|
|
|
Work Phone #
|
WorkPhone
|
DTYPE_TEXT
|
50
|
|
|
Worker Comp Occupation
|
WorkerCompOccupation
|
DTYPE_TEXT
|
30
|
|
FINS_DRVOCC_DWLOCC_MLOV LOV.
|
Worker Comp Premium
|
WorkerCompPremium
|
DTYPE_TEXT
|
30
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
INS Vehicle
|
|
Additional Rate Symbol
|
AdditionalRateSymbol
|
DTYPE_TEXT
|
30
|
|
|
Agent Inspected
|
AgentInspected
|
DTYPE_TEXT
|
1
|
|
|
Annual Mileage
|
AnnualMileage
|
DTYPE_NUMBER
|
20
|
|
|
Anti Theft Devices
|
AntiTheftDevices
|
DTYPE_TEXT
|
30
|
|
FINS_THEFT_MHCND_PRTCT_MLOV LOV.
|
Anti-Lock Brakes
|
Anti-LockBrakes
|
DTYPE_TEXT
|
30
|
|
|
Asset Id
|
AssetId
|
DTYPE_ID
|
30
|
|
|
Business Use Description
|
BusinessUseDescription
|
DTYPE_TEXT
|
100
|
|
FINS_THEFT_MHCND_PRTCT_MLOV LOV.
|
Capacity
|
Capacity
|
DTYPE_TEXT
|
20
|
|
|
Carpool
|
Carpool
|
DTYPE_TEXT
|
1
|
|
|
Collision Rate Symbol
|
CollisionRateSymbol
|
DTYPE_TEXT
|
30
|
|
FINS_COMP_RATE_MLOV LOV.
|
Comp Rate Symbol
|
CompRateSymbol
|
DTYPE_TEXT
|
30
|
|
FINS_COLL_RATE_DED_MLOV LOV.
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
30
|
|
|
Cost New
|
CostNew
|
DTYPE_TEXT
|
30
|
|
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
|
|
Currency Code
|
CurrencyCode
|
DTYPE_TEXT
|
30
|
|
|
Customized Flg
|
CustomizedFlg
|
DTYPE_TEXT
|
1
|
|
|
Days Per Week
|
DaysPerWeek
|
DTYPE_NUMBER
|
20
|
|
INS_DAYS_PER_WEEK LOV.
|
Description
|
Description2
|
DTYPE_TEXT
|
250
|
|
|
Driver Id
|
DriverId
|
DTYPE_ID
|
30
|
|
|
Energy Efficiency
|
EnergyEfficiency
|
DTYPE_TEXT
|
20
|
|
|
Engine Capacity
|
EngineCapacity
|
DTYPE_TEXT
|
20
|
|
|
Euro Type Key
|
EuroTypeKey
|
DTYPE_TEXT
|
50
|
|
|
Exchange Date
|
ExchangeDate
|
DTYPE_DATETIME
|
7
|
|
|
First Admission Date
|
FirstAdmissionDate
|
DTYPE_DATETIME
|
7
|
|
|
Garaging Address Id
|
GaragingAddressId
|
DTYPE_ID
|
30
|
|
|
Hire Or Delivery Use
|
HireOrDeliveryUse
|
DTYPE_TEXT
|
1
|
|
FINS_DWELLING_MLOV LOV.
|
Horsepower
|
Horsepower
|
DTYPE_TEXT
|
30
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
Y
|
Id, User Key Field.
|
Inspection Code
|
InspectionCode
|
DTYPE_TEXT
|
30
|
|
FINS_DWELL_BOAT_VEHICLE_MLOV LOV.
|
Inspection Date
|
InspectionDate
|
DTYPE_DATETIME
|
7
|
|
|
Length
|
Length
|
DTYPE_NUMBER
|
30
|
|
|
License Plate Number
|
LicensePlateNumber
|
DTYPE_TEXT
|
15
|
|
|
Line Number
|
LineNumber
|
DTYPE_NUMBER
|
30
|
|
|
Make
|
Make2
|
DTYPE_TEXT
|
30
|
|
INS_VEHICLE_MAKE LOV Unbounded.
|
Miles One Way
|
MilesOneWay
|
DTYPE_NUMBER
|
20
|
|
|
Mod Id
|
ModId
|
DTYPE_ID
|
30
|
|
|
Model
|
Model2
|
DTYPE_TEXT
|
30
|
|
|
Performance Code
|
PerformanceCode
|
DTYPE_TEXT
|
50
|
|
|
Primary Discount Id
|
PrimaryDiscountId
|
DTYPE_ID
|
30
|
|
|
Primary Named Insured Id
|
PrimaryNamedInsuredId
|
DTYPE_ID
|
30
|
|
|
Primary Rate Factor
|
PrimaryRateFactor
|
DTYPE_TEXT
|
30
|
|
|
Purchase Price
|
PurchasePrice
|
DTYPE_TEXT
|
20
|
|
|
RV Usage
|
RVUsage
|
DTYPE_TEXT
|
30
|
|
FINS_RV_FIRE_MHS_DWC_FLB_MLOV LOV.
|
Rate Plan
|
RatePlan
|
DTYPE_TEXT
|
30
|
|
|
Rate State
|
RateState
|
DTYPE_TEXT
|
10
|
|
|
Rated Driver Contact Id
|
RatedDriverContactId
|
DTYPE_ID
|
30
|
|
|
Rated Driver First Name
|
RatedDriverFirstName
|
DTYPE_TEXT
|
50
|
|
|
Rated Driver Last Name
|
RatedDriverLastName
|
DTYPE_TEXT
|
50
|
|
|
Rated Driver Middle Name
|
RatedDriverMiddleName
|
DTYPE_TEXT
|
15
|
|
|
Recreation Vehicle Type
|
RecreationVehicleType
|
DTYPE_TEXT
|
30
|
|
FINS_BRZ_HEAT_FLR_SIDE_RV_MLOV LOV.
|
SDIP Points
|
SDIPPoints
|
DTYPE_TEXT
|
50
|
|
|
Safety Device
|
SafetyDevice
|
DTYPE_TEXT
|
30
|
|
FINS_SCRN_FUEL_MHCP_SAFE_MLOV LOV.
|
Secondary Rate Factor
|
SecondaryRateFactor
|
DTYPE_TEXT
|
30
|
|
|
Stated Amount
|
StatedAmount
|
DTYPE_TEXT
|
20
|
|
|
Style
|
Style2
|
DTYPE_TEXT
|
30
|
|
FINS_STYLE_MLOV LOV.
|
Tax Code
|
TaxCode
|
DTYPE_NUMBER
|
30
|
|
FINS_NUMBATH_TAX_MLOV LOV.
|
Territory
|
Territory
|
DTYPE_NUMBER
|
30
|
|
FINS_NUMBATH_TERR_MLOV LOV.
|
Titled To
|
TitledTo
|
DTYPE_TEXT
|
30
|
|
|
Total Premium
|
TotalPremium
|
DTYPE_TEXT
|
|
|
|
Type
|
Type2
|
DTYPE_TEXT
|
30
|
|
INS_BOAT_TYPE_MLOV LOV.
|
Updated
|
Updated
|
DTYPE_DATETIME
|
30
|
|
|
Use Code
|
UseCode
|
DTYPE_TEXT
|
30
|
|
FINS_FLOBST_MHCND_VEHUSE_MLOV LOV.
|
VIN
|
VIN
|
DTYPE_TEXT
|
15
|
|
|
YD As Adult Flag
|
YDAsAdultFlag
|
DTYPE_TEXT
|
1
|
|
|
Year
|
Year
|
DTYPE_NUMBER
|
20
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|
INS Vehicle Coverage
|
|
Asset Id
|
AssetId
|
DTYPE_ID
|
30
|
|
|
Bonus Rate
|
BonusRate
|
DTYPE_NUMBER
|
30
|
|
|
Code
|
Code
|
DTYPE_TEXT
|
30
|
|
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
30
|
|
|
Coverage Number
|
CoverageNumber
|
DTYPE_TEXT
|
50
|
|
|
Created
|
Created
|
DTYPE_DATETIME
|
30
|
|
|
Currency Code
|
CurrencyCode
|
DTYPE_TEXT
|
30
|
|
|
Euro Description
|
EuroDescription
|
DTYPE_TEXT
|
50
|
|
|
Euro No Claim Code
|
EuroNoClaimCode
|
DTYPE_TEXT
|
40
|
|
|
Euro Rating Code
|
EuroRatingCode
|
DTYPE_TEXT
|
40
|
|
|
Exchange Date
|
ExchangeDate
|
DTYPE_DATETIME
|
7
|
|
|
Id
|
Id
|
DTYPE_ID
|
30
|
Y
|
Id, User Key Field.
|
Limit
|
Limit2
|
DTYPE_TEXT
|
30
|
|
|
Mod Id
|
ModId
|
DTYPE_ID
|
30
|
|
|
Premium
|
Premium
|
DTYPE_TEXT
|
20
|
|
|
Rate State
|
RateState
|
DTYPE_TEXT
|
10
|
|
|
Sequence Number
|
SequenceNumber
|
DTYPE_NUMBER
|
15
|
|
|
Tax Amount
|
TaxAmount
|
DTYPE_TEXT
|
20
|
|
|
Tax Rate
|
TaxRate
|
DTYPE_NUMBER
|
20
|
|
|
Type
|
Type
|
DTYPE_TEXT
|
30
|
|
|
Updated
|
Updated
|
DTYPE_DATETIME
|
30
|
|
|
Vehicle Id
|
VehicleId
|
DTYPE_ID
|
30
|
|
|
Vehicle Make
|
VehicleMake2
|
DTYPE_TEXT
|
30
|
|
|
Vehicle Model
|
VehicleModel2
|
DTYPE_TEXT
|
30
|
|
|
Vehicle Type
|
VehicleType
|
DTYPE_TEXT
|
30
|
|
|
Vehicle Year
|
VehicleYear
|
DTYPE_NUMBER
|
15
|
|
|
operation
|
operation
|
DTYPE_TEXT
|
30
|
|
|
searchspec
|
searchspec
|
DTYPE_TEXT
|
250
|
|
|