SELECT+Id,IsDeleted,MasterRecordId,Name,Type,RecordTypeId,ParentId,BillingStreet,BillingCity,BillingState,BillingPostalCode,BillingCountry,ShippingStreet,ShippingCity,ShippingState,ShippingPostalCode,ShippingCountry,Phone,Website,Industry,NumberOfEmployees,Description,Site,CurrencyIsoCode,OwnerId,CreatedDate,CreatedById,LastModifiedDate,LastModifiedById,SystemModstamp,LastActivityDate,fferpcore__ExemptionCertificate__c,fferpcore__IsBillingAddressValidated__c,fferpcore__IsShippingAddressValidated__c,fferpcore__MaterializedBillingAddressValidated__c,fferpcore__MaterializedShippingAddressValidated__c,fferpcore__OutputVatCode__c,fferpcore__SalesTaxStatus__c,fferpcore__TaxCode1__c,fferpcore__TaxCode2__c,fferpcore__TaxCode3__c,fferpcore__TaxCountryCode__c,fferpcore__ValidatedBillingCity__c,fferpcore__ValidatedBillingCountry__c,fferpcore__ValidatedBillingPostalCode__c,fferpcore__ValidatedBillingState__c,fferpcore__ValidatedBillingStreet__c,fferpcore__ValidatedShippingCity__c,fferpcore__ValidatedShippingCountry__c,fferpcore__ValidatedShippingPostalCode__c,fferpcore__ValidatedShippingState__c,fferpcore__ValidatedShippingStreet__c,fferpcore__VatRegistrationNumber__c,fferpcore__VatStatus__c,c2g__CODAAccountTradingCurrency__c,c2g__CODAAccountsPayableControl__c,c2g__CODAAccountsReceivableControl__c,c2g__CODAAllowDeleteInUse__c,c2g__CODABankAccountName__c,c2g__CODABankAccountNumber__c,c2g__CODABankAccountReference__c,c2g__CODABankCity__c,c2g__CODABankCountry__c,c2g__CODABankFax__c,c2g__CODABankIBANNumber__c,c2g__CODABankName__c,c2g__CODABankPhone__c,c2g__CODABankSWIFTNumber__c,c2g__CODABankSortCode__c,c2g__CODABankStateProvince__c,c2g__CODABankStreet__c,c2g__CODABankZipPostalCode__c,c2g__CODABaseDate1__c,c2g__CODABaseDate2__c,c2g__CODABaseDate3__c,c2g__CODABaseDate4__c,c2g__CODABillingAddressIsValid__c,c2g__CODABillingMethod__c,c2g__CODACreditAgency__c,c2g__CODACreditLimitEnabled__c,c2g__CODACreditLimitReviewed__c,c2g__CODACreditLimit__c,c2g__CODACreditManager__c,c2g__CODACreditRatingReviewed__c,c2g__CODACreditRating__c,c2g__CODACreditReference__c,c2g__CODACreditStatus__c,c2g__CODADaysOffset1__c,c2g__CODADaysOffset2__c,c2g__CODADaysOffset3__c,c2g__CODADaysOffset4__c,c2g__CODADefaultExpenseAccount__c,c2g__CODADescription1__c,c2g__CODADescription2__c,c2g__CODADescription3__c,c2g__CODADescription4__c,c2g__CODADimension1__c,c2g__CODADimension2__c,c2g__CODADimension3__c,c2g__CODADimension4__c,c2g__CODADiscount1__c,c2g__CODADiscount2__c,c2g__CODADiscount3__c,c2g__CODADiscount4__c,c2g__CODAECCountryCode__c,c2g__CODAEntityUseCode__c,c2g__CODAExemptionCertificate__c,c2g__CODAExternalId__c,c2g__CODAFederallyReportable1099__c,c2g__CODAFinanceContact__c,c2g__CODAIncomeTaxType__c,c2g__CODAInputVATCode__c,c2g__CODAIntercompanyAccount__c,c2g__CODAInvoiceEmail__c,c2g__CODAMergeId__c,c2g__CODAOutputVATCode__c,c2g__CODAPaymentMethod__c,c2g__CODAReportingCode__c,c2g__CODASalesTaxStatus__c,c2g__CODAShippingAddressIsValid__c,c2g__CODATaxCalculationMethod__c,c2g__CODATaxCode1__c,c2g__CODATaxCode2__c,c2g__CODATaxCode3__c,c2g__CODATaxpayerIdentificationNumber__c,c2g__CODAUnitOfWork__c,c2g__CODAVATRegistrationNumber__c,c2g__CODAVATStatus__c,c2g__CODAValidatedBillingCity__c,c2g__CODAValidatedBillingCountry__c,c2g__CODAValidatedBillingPostCode__c,c2g__CODAValidatedBillingState__c,c2g__CODAValidatedBillingStreet__c,c2g__CODAValidatedShippingCity__c,c2g__CODAValidatedShippingCountry__c,c2g__CODAValidatedShippingPostCode__c,c2g__CODAValidatedShippingState__c,c2g__CODAValidatedShippingStreet__c,c2g__CollectionsOnHoldReason__c,c2g__CollectionsOnHold__c,SCMC__Active__c,SCMC__Auto_Quote__c,SCMC__Bill_to_E_mail__c,SCMC__CAGE_Code__c,SCMC__Capability_Listing__c,SCMC__Certifications__c,SCMC__Corp_City__c,SCMC__Corp_Country__c,SCMC__Corp_Line1__c,SCMC__Corp_Line2__c,SCMC__Corp_PostalCode__c,SCMC__Corp_State_Province__c,SCMC__Credit_Card_Expiration_Date__c,SCMC__Credit_Card_Number__c,SCMC__Credit_Card_Type__c,SCMC__Credit_Card_Validation_Code__c,SCMC__Currency__c,SCMC__CustomerPriority__c,SCMC__Customer_Site_Id__c,SCMC__Customer_Type__c,SCMC__Customer__c,SCMC__DUNS_Number__c,SCMC__Default_Address__c,SCMC__Default_Payment_Type__c,SCMC__Discount_off_Standard__c,SCMC__E_Mail__c,SCMC__FOB__c,SCMC__Freight__c,SCMC__Invoice_Format__c,SCMC__Language__c,SCMC__No_Response__c,SCMC__NumberofLocations__c,SCMC__Packslip_Format__c,SCMC__Payment_Terms_Name__c,SCMC__Payment_Terms__c,SCMC__Preferred_Communication__c,SCMC__Price_Type__c,SCMC__Provide_Advanced_Ship_Notice__c,SCMC__Provide_Electronic_Invoice__c,SCMC__Reason_for_Temporary_Hold__c,SCMC__Sales_Rep__c,SCMC__Sales_Responsibility__c,SCMC__Ship_Via__c,SCMC__Shipping_Account__c,SCMC__Small_Business_Designations__c,SCMC__Standard_Order_Detail__c,SCMC__Tax_Exemption_Group__c,SCMC__Temporary_Hold__c,SCMC__Terms__c,SCMC__Warehouse__c,ffbc__BillingAccount__c,SCMFFA__Company_Name__c,RecordType.Name+FROM+Account+WHERE+Name='SHOP'+AND+RecordType.Name+=+'Property'