SELECT COMPANY_ID, CGROUP_ID, BANK_ID, USER_ID,
COUNTRY_ID, COMPANY_SHORT, COMPANY_NAME1, COMPANY_NAME2,
COMPANY_STREET, COMPANY_PLZ, COMPANY_CITY, COMPANY_TEL,
COMPANY_FAX, COMPANY_MOBIL, COMPANY_EMAIL, COMPANY_EMAILRG,
COMPANY_EMAILSUPPORT, COMPANY_EMAILKB, COMPANY_WWW, COMPANY_PRIVADR,
COMPANY_HRB, COMPANY_HRBAMT, COMPANY_GEWSCHEIN, COMPANY_GEWAMT, COMPANY_PERSONR,
COMPANY_PERSOAMT, COMPANY_USTID, COMPANY_ANZFIL, COMPANY_VERBAND, COMPANY_ISAKTIV,
COMPANY_isINSO, COMPANY_isBIG, COMPANY_OWNER, COMPANY_OWNER_BIRTH, COMPANY_GF,
COMPANY_GF_BIRTH, RESELLER_ID, COMPANY_GF_EMAIL, COMPANY_WHENNEW, COMPANY_LASTCONTACT,
COMPANY_BWNR, COMPANY_IBAN, COMPANY_BIC, COMPANY_MANDATSNR, COMPANY_MANDATSDATE, COMPANY_ACCOUNT,
COMPANY_ACCNAME, COMPANY_BLZ, COMPANY_DoUmsStat, COMPANY_StatEmailAdr, COMPANY_StatEmailAdr2, COMPANY_StatEmailAdr3,
COMPANY_SL_MANAGE, COMPANY_SL_SEND_ONEFIL, COMPANY_SL_SEND_ALLFIL, COMPANY_SL_SEND, COMPANY_SL_MAILADR, COMPANY_SL_MAIL,
COMPANY_GS_TEXT, COMPANY_LS_TEXT, COMPANY_SUMTERM, COMPANY_PAYPROVI, COMPANY_ISPROBLEM,
COMPANY_ZGbestaetigt, COMPANY_MEMO, CreditorID, Creditor_BusinessAccountChek, ContractProved,
YaerEstablished, changeDate, RECHTSFORM_ID, ERWERBSART_ID
FROM dbo.COMPANY