ODBC Driver for Google Ads

Build 24.0.9060

LocalServicesVerificationArtifact

A local services verification resource.

Columns

Name Type Behavior Description
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
LocalServicesVerificationArtifactArtifactType String ATTRIBUTE Output only. The type of the verification artifact.

The allowed values are BACKGROUND_CHECK, BUSINESS_REGISTRATION_CHECK, INSURANCE, LICENSE, UNKNOWN, UNSPECIFIED.

LocalServicesVerificationArtifactBackgroundCheckVerificationArtifactCaseUrl String ATTRIBUTE Output only. URL to access background case.
LocalServicesVerificationArtifactBackgroundCheckVerificationArtifactFinalAdjudicationDateTime Datetime ATTRIBUTE Output only. The timestamp when this background check case result was adjudicated. The format is 'YYYY-MM-DD HH:MM:SS' in the Google Ads account's timezone. Examples: '2018-03-05 09:15:00' or '2018-02-01 14:34:30'
LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactCheckId String ATTRIBUTE Output only. The id of the check, such as vat_tax_id, representing 'VAT Tax ID' requirement.
LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactRegistrationDocumentDocumentReadonlyDocumentUrl String ATTRIBUTE URL to access an already uploaded Local Services document.
LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactRegistrationNumberNumber String ATTRIBUTE Output only. Government-issued number for the business.
LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactRegistrationType String ATTRIBUTE Output only. The type of business registration check (number, document).

The allowed values are DOCUMENT, NUMBER, UNKNOWN, UNSPECIFIED.

LocalServicesVerificationArtifactBusinessRegistrationCheckVerificationArtifactRejectionReason String ATTRIBUTE Output only. Registration document rejection reason.

The allowed values are BUSINESS_DETAILS_MISMATCH, BUSINESS_NAME_MISMATCH, DOCUMENT_EXPIRED, DOCUMENT_INVALID, DOCUMENT_TYPE_MISMATCH, DOCUMENT_UNVERIFIABLE, ID_NOT_FOUND, OTHER, POOR_DOCUMENT_IMAGE_QUALITY, UNKNOWN, UNSPECIFIED.

LocalServicesVerificationArtifactCreationDateTime Datetime ATTRIBUTE Output only. The timestamp when this verification artifact was created. The format is 'YYYY-MM-DD HH:MM:SS' in the Google Ads account's timezone. Examples: '2018-03-05 09:15:00' or '2018-02-01 14:34:30'
LocalServicesVerificationArtifactId Long ATTRIBUTE Output only. The ID of the verification artifact.
LocalServicesVerificationArtifactInsuranceVerificationArtifactAmountMicros Long ATTRIBUTE Output only. Insurance amount. This is measured in 'micros' of the currency mentioned in the insurance document.
LocalServicesVerificationArtifactInsuranceVerificationArtifactExpirationDateTime Datetime ATTRIBUTE Output only. The timestamp when this insurance expires. The format is 'YYYY-MM-DD HH:MM:SS' in the Google Ads account's timezone. Examples: '2018-03-05 09:15:00' or '2018-02-01 14:34:30'
LocalServicesVerificationArtifactInsuranceVerificationArtifactInsuranceDocumentReadonlyDocumentUrl String ATTRIBUTE URL to access an already uploaded Local Services document.
LocalServicesVerificationArtifactInsuranceVerificationArtifactRejectionReason String ATTRIBUTE Output only. Insurance document's rejection reason.

The allowed values are BUSINESS_NAME_MISMATCH, CATEGORY_MISMATCH, EDITABLE_FORMAT, EXPIRED, INSURANCE_AMOUNT_INSUFFICIENT, MISSING_EXPIRATION_DATE, NON_FINAL, NO_COMMERCIAL_GENERAL_LIABILITY, NO_POLICY_NUMBER, NO_SIGNATURE, OTHER, POOR_QUALITY, POTENTIALLY_EDITED, UNKNOWN, UNSPECIFIED, WRONG_DOCUMENT_TYPE.

LocalServicesVerificationArtifactLicenseVerificationArtifactExpirationDateTime Datetime ATTRIBUTE Output only. The timestamp when this license expires. The format is 'YYYY-MM-DD HH:MM:SS' in the Google Ads account's timezone. Examples: '2018-03-05 09:15:00' or '2018-02-01 14:34:30'
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseDocumentReadonlyDocumentUrl String ATTRIBUTE URL to access an already uploaded Local Services document.
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseNumber String ATTRIBUTE Output only. License number.
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseType String ATTRIBUTE Output only. License type / name.
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseeFirstName String ATTRIBUTE Output only. First name of the licensee.
LocalServicesVerificationArtifactLicenseVerificationArtifactLicenseeLastName String ATTRIBUTE Output only. Last name of the licensee.
LocalServicesVerificationArtifactLicenseVerificationArtifactRejectionReason String ATTRIBUTE Output only. License rejection reason.

The allowed values are BUSINESS_NAME_MISMATCH, EXPIRED, OTHER, POOR_QUALITY, UNAUTHORIZED, UNKNOWN, UNSPECIFIED, UNVERIFIABLE, WRONG_DOCUMENT_OR_ID.

LocalServicesVerificationArtifactResourceName String ATTRIBUTE Immutable. The resource name of the Local Services Verification. Local Services Verification resource names have the form: customers/{customer_id}/localServicesVerificationArtifacts/{verification_artifact_id}
LocalServicesVerificationArtifactStatus String ATTRIBUTE Output only. The status of the verification artifact.

The allowed values are CANCELLED, FAILED, NO_SUBMISSION, PASSED, PENDING, UNKNOWN, UNSPECIFIED.

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
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

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