Файл

Префикс

Поля

Имя запроса

bill.vts

BILL

FM_BILL_ID MEDECINS_NOM MEDECINS_PRENOM BILL_DATE NOM PRENOM PATRONYME KABINET N_OMON EXT_NUM PATIENTS_ID FM_DEP_ID MEDECINS1_ID MEDECINS2_ID MEDECINS3_ID MEDECINS4_ID MEDECINS5_ID CIM10_ID MOTCONSU_ID MOTCONSU_DIR_ID MOTCONSU_MAIN_ID MOTCONSU_EV_ID MEDECINS_CREATE_ID MEDECINS_MODIFY_ID DATE_MODIFY

CBill

bill.vts

BILLSERV

FM_BILLDET_ID LABEL PRICE_TO_PAY CODE CNT SERV_CODE

CBillServ

bill.vts

DEFMEDECIN

MEDECINS_ID NAME

CDefMedecin

invfact.vts

INVOICESUM

SERV_COUNT FM_INVOICE_ID TOTAL_AMOUNT MIN_BILL_DATE MAX_BILL_DATE RECORD_COUNT FM_COURS_TYPE_ID FM_ORG_ID FM_ORGPAY_ID INVOICE_DATE CODE FM_DEVISE_ID CTOTAL_AMOUNT TOTAL_AMOUNT_WOVAT TOTAL_VAT_AMOUNT TAXE_VAT_PERC

QInvoiceSum

invfact.vts

INVOICETOTALSUM

SERV_COUNT TOTAL_AMOUNT CODE FM_ORG_ID FM_ORGPAY_ID INVOICE_DATE FM_DEVISE_ID TOTAL_AMOUNT TOTAL_VAT_AMOUNT TOTAL_AMOUNT_WOVAT

QinvoiceTotalSum

invfact.vts

ORG

FM_ORG_ID LABEL ADR ACCOUNT BANK BIK ACCWITH VILLE INN OKONH OKPO FONCTION_TYPE FIO TEL KPP FAX

COrg

invmmc.vts

INFO

FM_INVOICE_ID INVOICE_DATE PATIENTS_ID NOM PRENOM PATRONYME NE_LE FM_ORG_ID LABEL ADR TEL INN ACCOUNT BANK BIK ACCWITH IND VILLE COUNTRY CODE NUM YEAR DEVISE_TYPE

CInfo

invmmc.vts

INVOICE

PATIENTS_ID POLICE NOM PRENOM PATRONYME NE_LE INVOICE_AMOUNT_SUM CIM10_ID CIM10_CODE DESCRIPTION MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

Qinvoice

invmmc.vts

SERVICES

PATIENTS_ID CIM10_ID MEDECINS_NOM MEDECINS_PRENOM KOD1 PRICE FM_BILL_ID CIM10_ID FM_SERV_ID DM_MEDS_ID FM_SERV_CODE CODE_AN LABEL CNT PERC INVOICE_AMOUNT NDS_PERC NDS BILL_DATE POLICE MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

QServices

invoice.vts

INVOICE

FM_INVOICE_ID PATIENTS_ID NE_LE POLICE NOM PRENOM PATRONYME CNT INVOICE_AMOUNT_SUM MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

Qinvoice

invomp.vts

INFO

FM_INVOICE_ID INVOICE_DATE PATIENTS_ID NOM PRENOM PATRONYME NE_LE FM_ORG_ID LABEL ADR TEL INN ACCOUNT BANK BIK ACCWITH IND VILLE COUNTRY CODE NUM YEAR DEVISE_TYPE

CInfo

invomp.vts

INVOICE

PATIENTS_ID POLICE NOM PRENOM PATRONYME NE_LE INVOICE_AMOUNT_SUM CIM10_ID CIM10_CODE DESCRIPTION MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

Qinvoice

invomp.vts

SERVICES

PATIENTS_ID CIM10_ID MEDECINS_NOM MEDECINS_PRENOM KOD1 PRICE FM_BILL_ID CIM10_ID FM_SERV_ID DM_MEDS_ID FM_SERV_CODE CODE_AN LABEL CNT PERC INVOICE_AMOUNT NDS_PERC NDS BILL_DATE POLICE MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

QServices

invorg.vts

ORG

FM_ORG_ID LABEL ADR ACCOUNT BANK BIK ACCWITH VILLE INN OKONH OKPO FONCTION_TYPE FIO TEL KPP FAX

COrg

invorg.vts

INVORG

FM_INVOCE_ID NUM FM_ORGPAY_ID FM_ORG_ID NVOICE_DATE ABBRNAME BILL_DATE INVOICE_AMOUNT NOM PRENOM PATRONYME TOTAL_AMOUNT

CInvOrg

invpat.vts

INFO

FM_INVOICE_ID INVOICE_DATE PATIENTS_ID NOM PRENOM PATRONYME NE_LE FM_ORG_ID LABEL ADR TEL INN ACCOUNT BANK BIK ACCWITH IND VILLE COUNTRY CODE NUM YEAR DEVISE_TYPE

CInfo

invpat.vts

PATPAYMENTS

FM_PAYMODE_ID LABEL TRAN_TYPE TRAN_DATE TRAN_AMOUNT WODOLG FM_ACCOUNT_TRAN_ID

CPatPayments

invpat.vts

PATSERV

FM_BILLDET_PAY_ID CNT PRICE FM_DEVISE_ID INVOICE_AMOUNT FM_DEVISE_CODE FM_TAXENSP_ID CODE LABEL NSP_P SUM_NSP_P NSP SUM_NSP ABBRNAME FM_SERV_ID DISCOUNT DISC PRICEDISC FM_DEP_LABEL CODE_1 CODE_AN2 MEDECINS1_ID NDS_PERC NSP_PERC FM_TAXE_ID NDS FM_SERV_LABEL SHORT_LABEL DESCRIPTION FM_BILL_ID BILL_DATE PATIENTS_ID

CPatServ

servcim.vts

INVOICE

FM_INVOICE_ID PATIENTS_ID POLICE NOM PRENOM PATRONYME NE_LE INVOICE_AMOUNT_SUM CIM10_ID CIM10_CODE DESCRIPTION MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

QInvCim

servcim.vts

SERVICES

PATIENTS_ID CIM10_ID MEDECINS_NOM MEDECINS_PRENOM KOD1 PRICE FM_BILL_ID CIM10_ID FM_SERV_ID DM_MEDS_ID FM_SERV_CODE CODE_AN LABEL CNT PERC INVOICE_AMOUNT NDS_PERC NDS BILL_DATE POLICE MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

QServices

servcim.vts

SUMM

INVOICE_AMOUNT_SUMSTR

CTDSum

servgrp.vts

INVOICE

FM_INVOICE_ID PATIENTS_ID NE_LE POLICE NOM PRENOM PATRONYME CNT INVOICE_AMOUNT_SUM MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

Qinvoice

servgrp.vts

SERVGRP

FM_SERV_ID FM_SERV_CODE LABEL CNT INVOICE_AMOUNT

QServGrp

services.vts

IA

PATIENTS_ID PASPORT_N NOM PRENOM PATRONYME

QinvoiceAddon

services.vts

INVOICE

FM_INVOICE_ID PATIENTS_ID NE_LE POLICE NOM PRENOM PATRONYME CNT INVOICE_AMOUNT_SUM MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

Qinvoice

services.vts

SERVICES

PATIENTS_ID CIM10_ID MEDECINS_NOM MEDECINS_PRENOM KOD1 PRICE FM_BILL_ID CIM10_ID FM_SERV_ID DM_MEDS_ID FM_SERV_CODE CODE_AN LABEL CNT PERC INVOICE_AMOUNT NDS_PERC NDS BILL_DATE POLICE MAIN_CONTR_ID EXT_CODE FM_CONTR_ID

QServices

servmed.vts

INFO

FM_INVOICE_ID INVOICE_DATE PATIENTS_ID NOM PRENOM PATRONYME NE_LE FM_ORG_ID LABEL ADR TEL INN ACCOUNT BANK BIK ACCWITH IND VILLE COUNTRY CODE NUM YEAR DEVISE_TYPE

CInfo

servmed.vts

PATSERV

FM_BILLDET_PAY_ID CNT PRICE FM_DEVISE_ID INVOICE_AMOUNT FM_DEVISE_CODE FM_TAXENSP_ID CODE LABEL NSP_P SUM_NSP_P NSP SUM_NSP ABBRNAME FM_SERV_ID DISCOUNT DISC PRICEDISC FM_DEP_LABEL CODE_1 CODE_AN2 MEDECINS1_ID NDS_PERC NSP_PERC FM_TAXE_ID NDS FM_SERV_LABEL SHORT_LABEL DESCRIPTION FM_BILL_ID BILL_DATE PATIENTS_ID

CPatServ

servmede.vts

INFO

FM_INVOICE_ID INVOICE_DATE PATIENTS_ID NOM PRENOM PATRONYME NE_LE FM_ORG_ID LABEL ADR TEL INN ACCOUNT BANK BIK ACCWITH IND VILLE COUNTRY CODE NUM YEAR DEVISE_TYPE

CInfo

servmede.vts

PATSERV

FM_BILLDET_PAY_ID CNT PRICE FM_DEVISE_ID INVOICE_AMOUNT FM_DEVISE_CODE FM_TAXENSP_ID CODE LABEL NSP_P SUM_NSP_P NSP SUM_NSP ABBRNAME FM_SERV_ID DISCOUNT DISC PRICEDISC FM_DEP_LABEL CODE_1 CODE_AN2 MEDECINS1_ID NDS_PERC NSP_PERC FM_TAXE_ID NDS FM_SERV_LABEL SHORT_LABEL DESCRIPTION FM_BILL_ID BILL_DATE PATIENTS_ID

CPatServ

servpat.vts

ACCOUNT

ACCOUNT_SUM UNPAID

QAccount

servpat.vts

BILLMED

FM_BILL_ID NOM PRENOM DATE_CONSULTATION

CBillMed

servpat.vts

BILLPREPAID

PAYMENT_TYPE PRICE_ORG

QBillPrepaid

servpat.vts

DEFMEDECIN

MEDECINS_ID NAME

CDefMedecin

servpat.vts

INVINFO

FM_BILL_ID DATE_CONSULTATION BILL_DATE PATIENTS_ID NE_LE NAME DESCRIPTION CODE

QInvInfo

servpat.vts

MIDDLE

FM_DEP_LABEL PRICE PRICE_PAT PRICE_ORG

QMiddle

servpat.vts

PATIENT

INVOICE_AMOUNT_PAT TAXE_AMOUNT TOTAL_AMOUNT TOTAL_PAYED_AMOUNT UNPAID

QPatient

servpat.vts

PAYMENTS

LABEL TRAN_DATE PAYED_AMOUNT

QPayments

servpat.vts

SERVPAT

FM_BILLDET_ID FM_DEP_LABEL CODE CNT PRICE DISCOUNT PRICE_PAT PRICE_ORG POLICE FM_ORG_CODE LABEL

QServPat

servpat.vts

SUBTOTAL

PRICE PRICE_PAT PRICE_ORG

QSubTotal

convoc.vts

PLANNING

DATE_CONS HEURE PL_SUBJ_ID DUREE PATIENTS_ID NOM PRENOM MOTIF COMMENTAIRE COLOR FONT DUREE_TEXT PATIENT_ARRIVEE

PL_GENER_ID PL_EXAM_ID PATRONYME MEDECINS_CREATOR_ID MODIFY_DATE_TIME FM_PATIENTSTYPE_ID

CREATE_DATE_TIME MEDECINS_MODIFY_ID COULEUR_MACRO CALLS_ID HL7_ACCESSION_NUMBER FORBID_AFTER_DATE

PERIOD_ALLOW_CREATE PLANNING_ID PL_PATGR_NAME PL_EXAM_NAME PL_SUBJ_NAME FULLNAME

act.vts

INFO

FM_INVOICE_ID INVOICE_DATE PATIENTS_ID NOM PRENOM PATRONYME NE_LE FM_ORG_ID LABEL ADR TEL INN ACCOUNT BANK BIK ACCWITH IND VILLE COUNTRY CODE NUM YEAR DEVISE_TYPE

CInfo

act.vts

PATSERV

FM_BILLDET_PAY_ID CNT PRICE FM_DEVISE_ID INVOICE_AMOUNT FM_DEVISE_CODE FM_TAXENSP_ID CODE LABEL NSP_P SUM_NSP_P NSP SUM_NSP ABBRNAME FM_SERV_ID DISCOUNT DISC PRICEDISC FM_DEP_LABEL CODE_1 CODE_AN2 MEDECINS1_ID NDS_PERC NSP_PERC FM_TAXE_ID NDS FM_SERV_LABEL SHORT_LABEL DESCRIPTION FM_BILL_ID BILL_DATE PATIENTS_ID

CPatServ