=== Database Fields Test ===
Checking GBVAT_Register table fields...
GBVAT_Register table columns:
  - AddressProofPicture
  - AddressProofPicture2
  - Attachment
  - Auditor_ID
  - AuditorName
  - AuditStatus
  - AunnualGMV
  - BankAccountName
  - BankAccountNumber
  - BankAddress
  - BankCurrency
  - BankIBAN
  - BankName
  - Base_ShopInfoID
  - BICSWIFT
  - BoundZipCompanyPostCode
  - BusinessCode
  - BusinessCRFile
  - BusinessLicenseCode
  - BusinessLicensePicture
  - BusinessNNC1File
  - BusinessPlatform
  - CertificateEmploymentPicture
  - CNVATNumber
  - Company_ID
  - CompanyAddressCityEn
  - CompanyAddressLine1En
  - CompanyAddressLine2En
  - CompanyAddressProvinceEn
  - CompanyCode
  - CompanyFullName
  - CompanyIncorporationCountry
  - CompanyName
  - CompanyName_En
  - CompanySignatureDate
  - ConstitutionFile
  - ContactEmail
  - ContactPerson
  - ContactPhone
  - ContactPhone2
  - ContactWeChat
  - Creation_Id
  - CreationDate
  - CreationName
  - CustomContractFile
  - CustomerID
  - Enabled
  - EORINumber
  - FBAAccountPicture
  - FBABusinessInformationPicture
  - FBACommunicationPicture
  - FBAKeyMetricsPicture
  - FBAOrderDetailPicture
  - FBAPicture
  - FBASellerAccountPicture
  - FBASellerID
  - FBASellerIDPicture
  - FBAShipmentSignedPicture
  - FBAShipmentSummaryPicture
  - FBAShippingQueuePicture
  - FBAShopPicture
  - FBASwitchPicture
  - FBAWarehousePicture
  - HasNoOtherEORIOfEU
  - ID
  - IDAddress_En
  - LegalDateBirth
  - LegalEmail
  - LegalEntityFullName_En
  - LegalEntityName
  - LegalFirstName
  - LegalIDNumberAddress
  - LegalIDNumberAddress_EN
  - LegalIdNumberBackPicture
  - LegalIdNumberFrontPicture
  - LegalLastName
  - LegalPersonAddressCityEn
  - LegalPersonAddressLine1En
  - LegalPersonAddressLine2En
  - LegalPersonAddressPostCodeEn
  - LegalPersonAddressProvinceEn
  - LegalPersonCountry
  - LegalPersonFullNamePinYin
  - LegalPersonGender
  - LegalPersonIDCardType
  - LegalPersonIdEndDate
  - LegalPersonIdNumber
  - LegalPersonIdStartDate
  - LegalPersonRoomNumber
  - LegalPersonRoomNumberSuffix
  - LegalSign
  - LegalTelephone
  - LocalTaxNumber
  - LogisticsContractFile
  - Modification_Id
  - ModificationDate
  - ModificationName
  - Nationality
  - NeedRequestEORI
  - OtherCountryVATCertificateFile
  - PinYin
  - PinYinShort
  - ProductsRange
  - ProjectID
  - ProjectName
  - PurchaseContractFile
  - PurchaseInvoiceFile
  - QuestionFile
  - RegisteredAddress
  - RegisteredAddress_En
  - RegisteredDate
  - RegisterEmail
  - RegisterEmailPassword
  - ResidenceBookletPicture
  - ResidentialAddress
  - RoomNumber
  - RoomNumberSuffix
  - ServiceRemark
  - Shop_ID
  - Shop_link
  - ShopName
  - SortCode
  - TaxEmail
  - UKBankAccountDescription
  - VATCertificateFile
  - VATNumber
  - VATStartDate
  - Website
  - WhetherLowRate
  - Workflow_ID

Looking for GMV-related fields...
  Found: AunnualGMV

Checking Base_Customer_Company table fields...
Base_Customer_Company table columns (first 20):
  - Auditor_ID
  - AuditorName
  - AuditStatus
  - Base_ShopInfoID
  - BusinessConstitutionFile
  - BusinessCRFile
  - BusinessLicensePic
  - BusinessNNC1File
  - BusinessOperationEndDate
  - BusinessOperationStartDate
  - BusinessScope
  - CityEngName
  - Code
  - Company_ID
  - CompanyAddressLine1En
  - CompanyAddressLine2En
  - CompanyAddressPostcode
  - CompanyAddressProvinceEn
  - CompanyCode
  - CompanyFullName

Testing simple queries...
✓ GBVAT_Register query successful
Available fields in result:
  - ProductsRange
  - VATNumber
  - LegalTelephone
  - LegalEmail
  - Website
  - LegalEntityName
  - ResidentialAddress
  - LegalDateBirth
  - VATStartDate
  - AunnualGMV
  - RegisterEmail
  - RegisterEmailPassword
  - WhetherLowRate
  - ID
  - Enabled
  - CreationDate
  - Creation_Id
  - CreationName
  - ModificationDate
  - Modification_Id
  - ModificationName
  - SortCode
  - CompanyCode
  - Company_ID
  - CompanyFullName
  - CompanyName
  - PinYin
  - PinYinShort
  - Auditor_ID
  - AuditorName
  - AuditStatus
  - Base_ShopInfoID
  - ShopName
  - Workflow_ID
  - BusinessLicensePicture
  - LegalIdNumberBackPicture
  - AddressProofPicture
  - ResidenceBookletPicture
  - CertificateEmploymentPicture
  - CompanyName_En
  - LegalEntityFullName_En
  - ProjectID
  - ProjectName
  - CustomerID
  - BusinessLicenseCode
  - Shop_ID
  - Shop_link
  - Attachment
  - LegalFirstName
  - LegalLastName
  - LegalSign
  - EORINumber
  - LocalTaxNumber
  - LegalIdNumberFrontPicture
  - CNVATNumber
  - FBAPicture
  - AddressProofPicture2
  - UKBankAccountDescription
  - OtherCountryVATCertificateFile
  - PurchaseInvoiceFile
  - PurchaseContractFile
  - LogisticsContractFile
  - CustomContractFile
  - QuestionFile
  - FBASwitchPicture
  - FBAAccountPicture
  - FBAShipmentSummaryPicture
  - FBASellerID
  - FBAWarehousePicture
  - FBABusinessInformationPicture
  - FBAShopPicture
  - FBAShipmentSignedPicture
  - FBAShippingQueuePicture
  - FBASellerAccountPicture
  - FBACommunicationPicture
  - FBAOrderDetailPicture
  - FBAKeyMetricsPicture
  - FBASellerIDPicture
  - LegalIDNumberAddress
  - LegalIDNumberAddress_EN
  - BusinessCRFile
  - BusinessNNC1File
  - ContactPhone
  - ContactPhone2
  - ContactEmail
  - ConstitutionFile
  - VATCertificateFile
  - ContactPerson
  - ContactWeChat
  - CompanyIncorporationCountry
  - BusinessCode
  - RegisteredAddress
  - RegisteredAddress_En
  - RegisteredDate
  - BankName
  - BankAccountName
  - BankAccountNumber
  - BankIBAN
  - BICSWIFT
  - BankAddress
  - BankCurrency
  - TaxEmail
  - LegalPersonFullNamePinYin
  - CompanyAddressLine1En
  - CompanyAddressLine2En
  - CompanyAddressProvinceEn
  - CompanyAddressCityEn
  - BoundZipCompanyPostCode
  - RoomNumber
  - RoomNumberSuffix
  - IDAddress_En
  - LegalPersonAddressLine1En
  - LegalPersonAddressLine2En
  - LegalPersonAddressCityEn
  - LegalPersonAddressProvinceEn
  - LegalPersonAddressPostCodeEn
  - LegalPersonCountry
  - LegalPersonRoomNumber
  - LegalPersonRoomNumberSuffix
  - LegalPersonGender
  - LegalPersonIDCardType
  - Nationality
  - CompanySignatureDate
  - LegalPersonIdNumber
  - LegalPersonIdStartDate
  - LegalPersonIdEndDate
  - ServiceRemark
  - BusinessPlatform
  - NeedRequestEORI
  - HasNoOtherEORIOfEU

Field test completed!