Это старая версия документа!

---

select
    c.CONTR_ID                      ,-- ВнНомер
    c.FOLDER_ID                     ,-- Категория
    c.CONTRAG_TYPE                  ,--
    c.BARCODE                       ,-- ШК (ШтрихКод)
    c.OWN                           ,--
    c.NAME                          ,-- Имя клиента
    c.FULLNAME                      ,-- Полное имя клиента
    c.ADDRESS                       ,--
    c.ADDRESS_KLADR                 ,--
    c.TELEPHONE                     ,--
    c.INN                           ,--
    c.KPP                           ,--
    c.ACCOUNT                       ,--
    c.BANK_ID                       ,--
    c.RUK_FIO                       ,--
    c.GLBUH_FIO                     ,--
    c.KAS_FIO                       ,--
    c.OKPO                          ,--
    c.STATUS                        ,--
    c.ADDRESS_POST                  ,--
    c.ADDRESS_POST_KLADR            ,--
    c.RUK_ROLE                      ,--
    c.GLBUH_ROLE                    ,--
    c.KAS_ROLE                      ,--
    c.SALDO_TYPE                    ,--
    c.DEP_ID                        ,--
    c.OWN_ID                        ,--
    c.DEP_SRC_ID                    ,--
    c.DELAY_DAYS                    ,--
    c.MANAGER_CONTR_ID              ,--
    c.FINE                          ,--
    c.PARENT_CONTR_ID               ,--
    c.DISCOUNT                      ,--
    c.DISCOUNT_KIND                 ,--
    c.SCHEME_ID                     ,--
    c.PRICE_LIST_ID                 ,--
    c.SHOW_HISTORY_IN_KASSA         ,--
    c.SALARY_AT_HOUR                ,--
    c.IS_DISCOUNT_ACTIVE            ,--
    c.CARD_NULL_REASON              ,--
    c.LAST_DISCOUNT_BY_SCRIPT       ,--
    c.CHECKED                       ,--
    c.LOYALTY                       ,--
    c.REGION_ID                     ,--
    c.IS_ACTIVE                     ,-- Активность клиента
    c.GENDER                        ,--
    c.FIRST_DOC_DATE                ,--
    c.TELEPH_CELL                   ,--
    c.NO_ACTIVE_COMMENT             ,--
    c.DEF_FIRM_ID                   ,--
    c.HAVE_CONTRACT                 ,--
    c.DISC_OUT_USER_ID              ,--
    c.DISC_OUT_DT                   ,--
    c.DISC_OUT_SCLAD_ID             ,--
    c.EMAIL                         ,--
    c.ACTIVE_SUBSCRIPTION           ,--
    c.AGREE_TO_RECEIVE_SMS          ,--
    c.AGREE_TO_RECEIVE_ADV_SMS      ,--
    c.FIRST_ORDER_DOC_ID            ,--
    c.UNIQUE_CODE                   ,--
    c.MAN_CONTR_ID                  ,--
    c.BASIS                         ,--
    c.DATE_CREATE                   ,--
    c.LOCATION                      ,--
    c.LOCATION_ACCURACY             ,--
    c.LOCATION_TYPE                 ,--
    c.DOCS_CHANGE_NUM               ,--
    c.OLD_SUM                       ,-- Сумма заказов из предыдущей системы
    c.INVOICE_AUTO                  ,--
    c.INVOICE_AUTO_FIRST_MD         ,--
    c.INVOICE_AUTO_LAST_MD          ,--
    c.INVOICE_AUTO_DAYS             ,--
    c.LAST_DEP_ID                   ,--
    c.PERCENT_DOLG                  ,--
    c.IS_PRIVATE_PERSON             ,--
    c.IS_ALTERNATIVE_TOVAR_NAME     ,--
    c.DONT_COMB_ON_ORG              ,--
    c.CODE                          ,--
    c.CODE_INT                      ,--
    c.IS_DELETED                    ,--
    c.DOP_PRICE_LIST_ID             ,--
    c.LAST_SEND_SMS                 ,--
    c.CLIENT_ID                     ,--
    c.SOURCE                        ,--
    c.USE_SPEC_API                  ,--
    c.IDENT                         ,--
    c.BAGS_LIMIT                    ,--
    c.AGREE_TO_RECEIVE_PUSH         ,--
    c.AGREE_TO_RECEIVE_ADV_PUSH     ,--
    c.SMSKIND                       ,--
    c.PUSHKIND                      ,--
    c.CONTRACT_HIMSTAT_ID           ,--
    c.REGISTERED_FROM               ,--
    c.LAST_ORDER_DOC_ID             ,--
    c.LNG                           ,--
    c.NAME_FULL                     ,--
    c.ALLOW_ORDER_OUT_WITHOUT_PAY   ,--
    c.AEROFLOT_MILES                ,--
    c.OGRN                          ,--
    c.LAST_PHONE_CH                 ,--
    c.TEL_CONFIRM_CODE              ,--
    c.TEL_IS_CONFIRMED              ,--
    c.USE_TAKEN_INVOICING           ,--
    c.DOP_BONUS                     ,--
    c.TELEPH_CELL_MASK              ,--
    c.UPDATE_TIMESTAMP              ,--
    c.WORK_WEAR_ID                  ,--
    c.CLOTHING_SIZE                 ,--
    c.HEIGHT                        ,--
    c.SHOE_SIZE                     ,--
    c.TEL_IS_CONFIRMED_DTTM         ,--
    c.AGREE_SMS_ORDER_REPS          ,--
    c.REGION_NUM_SBIS               ,--
    c.IS_FAMILY                     ,-- Входит ли в группу
    c.LEAD_STATUS                   ,--
    c.LEAD_SOURCE_ID                ,--
    c.IS_CORRECT_INN                ,--
    c.DONT_CHECK_DS_CARD            ,--
    c.INVOICE_CALC_TYPE             ,--
    c.HOUSE                         ,--
    c.ROOM                          ,--
    c.ROOM_LEVEL                    ,--
    c.ENTRANCE                      ,--
    c.INTERCOM                       --
from contragents c;