ADO.NET Provider for Microsoft Dynamics GP

Build 24.0.9060

EmployeeAddresses

Return a list of: EmployeeAddresses

Columns

Name Type Description
ExtensionsExtensionAggregate String
AddressesExtensionsExtensionAggregate String
AddressesCity String
AddressesLine1 String
AddressesLine2 String
AddressesLine3 String
AddressesPostalCode String
AddressesState String
AddressesCountryRegion String
AddressesFaxCountryCode String
AddressesFaxExtension String
AddressesFax String
AddressesPhone1CountryCode String
AddressesPhone1Extension String
AddressesPhone1 String
AddressesPhone2CountryCode String
AddressesPhone2Extension String
AddressesPhone2 String
AddressesPhone3CountryCode String
AddressesPhone3Extension String
AddressesPhone3 String
AddressesCountryRegionCodeId String
AddressesCounty String
AddressesDeleteOnUpdate Bool
AddressesInternetAddressesAdditionalInformation String
AddressesInternetAddressesEmailBccAddress String
AddressesInternetAddressesEmailCcAddress String
AddressesInternetAddressesEmailToAddress String
AddressesInternetAddressesInternetField1 String
AddressesInternetAddressesInternetField2 String
AddressesInternetAddressesInternetField3 String
AddressesInternetAddressesInternetField4 String
AddressesInternetAddressesInternetField5 String
AddressesInternetAddressesInternetField6 String
AddressesInternetAddressesInternetField7 String
AddressesInternetAddressesInternetField8 String
AddressesInternetAddressesMessengerAddress String
AddressesKeyEmployeeId [KEY] String
AddressesId [KEY] String
BenefitExpiration Datetime
BenefitStartDate Datetime
BirthDate Datetime
ClassId String
CompanyAddressId String
DayOfBirth Int
DefaultAddressKeyEmployeeId String
DefaultAddressId String
DefaultCashAccountFromType String
DepartmentId String
DivisionId String
DoesCalculateMinimumWageBalance Bool
EmployeeInactivatedDate Datetime
EmployeeId String
EmploymentStartDate Datetime
EmploymentType String
Ethnicity String
FederalClass String
GLAccountId String
GLAccountKeyIsEncrypted Bool
GenderCode String
HRStatus String
I9RenewDate Datetime
IsActive Bool
IsDisabled Bool
IsDisabledVeteran Bool
IsI9Verified Bool
IsOtherVeteran Bool
IsSmoker Bool
IsUnionEmployee Bool
IsUnitedStatesCitizen Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
LastWorkedDate Datetime
MaritalStatus String
MilitaryDischargeDate Datetime
MinimumNetPayCurrency String
MinimumNetPay Decimal
ModifiedBy String
ModifiedDate Datetime
MonthOfBirth String
NameAlternate String
NameFamily String
NameGiven String
NameMiddle String
NamePreferred String
NameSuffix String
PositionId String
PrimaryPayCodeId String
RateClass String
ReasonEmployeeInactivated String
ReviewLastDate Datetime
ReviewNextDate Datetime
SUTAStateId String
SickTimeAccrualAmount Decimal
SickTimeAccrualMethod String
SickTimeDoesAutomaticallyAccrue Bool
SickTimeHoursAvailable Decimal
SickTimeHoursPerYear Int
SickTimeWarnWhenHoursAvailableFallsBelowZero Bool
SpouseName String
SpouseTaxIdentifier String
Status String
SupervisorId String
TaxIdentifier String
UnionId String
UserDefined1 String
UserDefined2 String
VacationAccrualAmount Decimal
VacationAccrualMethod String
VacationDoesAutomaticallyAccrue Bool
VacationHoursAvailable Decimal
VacationHoursPerYear Int
VacationWarnWhenHoursAvailableFallsBelowZero Bool
WorkHoursPerYear Int
WorkersCompensationId String

Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060