ODBC Driver for Google Ads

Build 23.0.8839

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.

使用できる値は次のとおりです。BACKGROUND_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'
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.
LocalServicesVerificationArtifactInsuranceVerificationArtifactInsuranceDocumentReadonlyDocumentUrl String ATTRIBUTE URL to access an already uploaded Local Services document.
LocalServicesVerificationArtifactInsuranceVerificationArtifactRejectionReason String ATTRIBUTE Output only. Insurance document's rejection reason.

使用できる値は次のとおりです。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

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.

使用できる値は次のとおりです。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.

使用できる値は次のとおりです。CANCELLED, FAILED, NO_SUBMISSION, PASSED, PENDING, UNKNOWN, UNSPECIFIED

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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 23.0.8839