JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ApplicantApplications

Return a list of: ApplicantApplications

Columns

Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
AgeCode String
ApplicantId Int
ApplicationColorColorCode String
ApplicationColorColorName String
ApplicationStatus String
ApplicationsExtensionsExtensionAggregate String
ApplicationsApplicantApplicationKeyApplicantId [KEY] Int
ApplicationsApplicantApplicationKeySequenceId [KEY] Int
ApplicationsColorColorCode String
ApplicationsColorColorName String
ApplicationsCompanyCode String
ApplicationsDateApplied Datetime
ApplicationsDeleteOnUpdate Bool
ApplicationsDepartmentId String
ApplicationsDivisionId String
ApplicationsIsReplyLetterSent Bool
ApplicationsIsWillRelocate Bool
ApplicationsLastModifiedBy String
ApplicationsLastModifiedDate Datetime
ApplicationsLocation String
ApplicationsPositionId String
ApplicationsReferenceInformationSource String
ApplicationsReferenceInformationSourceDescription String
ApplicationsRejectionInfomationComment String
ApplicationsRejectionInfomationReason String
ApplicationsRequisitionId String
ApplicationsStatus String
CompanyCode String
DateApplied Datetime
DepartmentId String
DivisionId String
Ethnicity String
FirstName String
Gender String
HRRequisistionId String
InterviewsAggregate String
IsDisabled Bool
IsDisabledVeteran Bool
IsOtherVeteran Bool
IsReplyLetterSent Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
LastName String
Location String
MiddleName String
PositionId String
PreviousEmployersAggregate String
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesAggregate String
RejectionInformationComment String
RejectionInformationReason String
SchoolsAggregate String
SequenceId Int
SkillsAggregate String
TaxIdentifier String
TestsAggregate 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462