class res_users(Base):
"""Клиенты"""
__tablename__ = 'res_users'
id = Column(Integer, primary_key=True)
active = Column(Boolean)
login = Column(String(64))
password = Column(String)
company_id = Column(Integer, FKey('res_company.id'), index=True)
partner_id = Column(Integer, FKey('res_partner.id'), index=True)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
create_date = Column(DateTime)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
menu_id = Column(Integer)
login_date = Column(Date)
signature = Column(Text)
action_id = Column(Integer)
alias_id = Column(Integer, nullable=False)
share = Column(Boolean)
password_crypt = Column(String)
display_groups_suggestions = Column(Boolean)
default_section_id = Column(Integer)
facsimile = Column(Binary)
display_employees_suggestions = Column(Boolean)
google_calendar_token_validity = Column(DateTime)
google_calendar_rtoken = Column(String)
google_calendar_last_sync_date = Column(DateTime)
google_calendar_token = Column(String)
google_calendar_cal_id = Column(String)
karma = Column(Integer)
class RbLaboratoryTest(Base):
__tablename__ = 'rbLaboratory_Test'
id = Column(Integer, primary_key=True)
master_id = Column(Integer, FKey('rbLaboratory_Test.id'), index=True)
test_id = Column(Integer, FKey('rbTest.id'), index=True)
book = Column(String(64), index=True)
code = Column(String(64), index=True)
class RbHospitalBedProfileService(Base):
__tablename__ = 'rbHospitalBedProfile_Service'
id = Column(Integer, primary_key=True)
rbHospitalBedProfile_id = Column(Integer,
FKey('rbHospitalBedProfile.id'),
index=True)
rbService_id = Column(Integer, FKey('rbService.id'), index=True)
class crm_case_section(Base):
"""Отделы продаж"""
__tablename__ = 'crm_case_section'
id = Column(Integer, primary_key=True)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
create_date = Column(DateTime)
write_date = Column(DateTime)
working_hours = Column(Numeric)
alias_id = Column(Integer, nullable=False)
code = Column(String(8))
active = Column(Boolean)
change_responsible = Column(Boolean)
user_id = Column(Integer, FKey('res_company.id'),
index=True) # Team Leader
name = Column(String(64))
note = Column(Text)
parent_id = Column(Integer, FKey('crm_case_section.id'), index=True)
complete_name = Column(String(256))
reply_to = Column(String(64))
resource_calendar_id = Column(Integer)
color = Column(Integer)
message_last_post = Column(DateTime)
use_leads = Column(Boolean)
use_opportunities = Column(Boolean)
use_quotations = Column(Boolean)
invoiced_target = Column(Integer)
invoiced_forecast = Column(Integer)
default_stage_id = Column(Integer, FKey('crm_case_stage.id'), index=True)
track_act = Column(Boolean)
class sale_order_line(Base):
"""Позиция заказа продаж"""
__tablename__ = 'sale_order_line'
id = Column(Integer, primary_key=True)
address_allotment_id = Column(Integer)
client_product_name = Column(String)
company_id = Column(Integer, FKey('res_company.id'), index=True)
company = relationship('res_company',
foreign_keys='sale_order_line.company_id')
contract_production_time = Column(Integer)
contract_shipment_date = Column(Date)
create_date = Column(DateTime)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
delay = Column(Float)
discount = Column(Numeric)
invoiced = Column(Boolean)
name = Column(Text)
order_id = Column(Integer, FKey('sale_order.id'), index=True)
order = relationship('sale_order', foreign_keys='sale_order_line.order_id')
order_partner_id = Column(Integer)
price_unit = Column(Numeric)
product_id = Column(Integer)
product_packaging = Column(Integer)
product_uom = Column(Integer)
product_uom_qty = Column(Numeric)
product_uos = Column(Integer)
product_uos_qty = Column(Numeric)
requisition_required = Column(Boolean)
route_id = Column(Integer)
salesman_id = Column(Integer)
sequence = Column(Integer)
state = Column(String)
th_weight = Column(Numeric)
class sale_order(Base):
"""Заказ продаж"""
__tablename__ = 'sale_order'
id = Column(Integer, primary_key=True)
create_date = Column(DateTime)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
amount_tax = Column(Numeric)
amount_total = Column(Numeric)
amount_untaxed = Column(Numeric)
campaign_id = Column(Integer) # New in 10
client_order_ref = Column(String)
# close_order_date = Column(Date)
# cm_recured_date = Column(Date)
company_id = Column(Integer, FKey('res_company.id'), index=True)
company = relationship('res_company', foreign_keys='sale_order.company_id')
# contract_production_time = Column(Integer)
# contract_shipment_date = Column(Date)
# date_confirm = Column(Date)
confirmation_date = Column(Date)
date_order = Column(DateTime, nullable=False)
entity_for_proc = Column(Integer,
FKey('sintez_legal_entity.id'),
index=True)
legal_entity = relationship('sintez_legal_entity',
foreign_keys='sale_order.entity_for_proc')
fiscal_position_id = Column(Integer)
incoterm = Column(Integer)
invoice_status = Column(String)
matching_scheme_date = Column(Date)
medium_id = Column(Integer) # New in 10
message_last_post = Column(DateTime)
name = Column(String, index=True, nullable=False)
note = Column(Text)
opportunity_id = Column(Integer) # New in 10
# order_policy = Column(String)
# order_procurement_confirmed = Column(Boolean)
origin = Column(String)
partner_id = Column(Integer, nullable=False)
partner_invoice_id = Column(Integer, nullable=False)
partner_shipping_id = Column(Integer, nullable=False)
payment_term_id = Column(Integer)
picking_policy = Column(String, nullable=False)
# prepayments_date = Column(Date)
pricelist_id = Column(Integer, nullable=False)
procurement_group_id = Column(Integer)
project_id = Column(Integer)
required_shipment_date = Column(Date)
shipment_date = Column(Date)
shipped = Column(Boolean)
so_lines = relationship("sale_order_line")
source_id = Column(Integer)
state = Column(String)
team_id = Column(Integer)
user_id = Column(Integer, FKey('res_users.id'), index=True)
user = relationship('res_users', foreign_keys='sale_order.user_id')
validity_date = Column(Date)
warehouse_id = Column(Integer, nullable=False)
class RbJobType(Base):
__tablename__ = 'rbJobType'
id = Column(Integer, primary_key=True)
group_id = Column(Integer, FKey('rbJobType.id'), index=True)
code = Column(String(64), index=True)
regionalCode = Column(String(64), index=True)
name = Column(String(128), index=True)
laboratory_id = Column(Integer, FKey('rbLaboratory.id'), index=True)
isInstant = Column(SmallInteger, default='0')
class sarrz_legal_entity(Base):
"""Компания для выставления счетов"""
__tablename__ = 'sarrz_legal_entity'
id = Column(Integer, primary_key=True)
create_date = Column(DateTime)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
name = Column(String)
class RbPlanningHospitalActivitis(Base):
__tablename__ = 'rbPlanningHospitalActivitis'
id = Column(Integer, primary_key=True)
year = Column(Integer, default='0')
month = Column(Integer, default='0')
orgStructure_id = Column(Integer, FKey('OrgStructure.id'), index=True)
profile_id = Column(Integer, FKey('rbHospitalBedProfile.id'), index=True)
plan = Column(Integer, default='0')
bedDays = Column(Integer, default='0')
class product_template(Base):
"""Шаблон продука"""
__tablename__ = 'product_template'
id = Column(Integer, primary_key=True)
active = Column(Boolean)
categ_id = Column(Integer, nullable=False)
color = Column(Integer)
company_id = Column(Integer, FKey('res_company.id'), index=True)
company = relationship('res_company',
foreign_keys='product_template.company_id')
copy_needed = Column(Boolean)
copy_of_id = Column(Integer)
create_date = Column(DateTime)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
description = Column(Text)
description_purchase = Column(Text)
description_sale = Column(Text)
hr_expense_ok = Column(Boolean)
image = Column(Binary)
image_medium = Column(Binary)
image_small = Column(Binary)
list_price = Column(Numeric)
loc_case = Column(String)
loc_rack = Column(String)
loc_row = Column(String)
mes_type = Column(String)
message_last_post = Column(String)
name = Column(String, nullable=False)
produce_delay = Column(Float)
product_manager = Column(Integer)
purchase_ok = Column(Boolean)
purchase_requisition = Column(Boolean)
rental = Column(Boolean)
sale_delay = Column(Float)
sale_ok = Column(Boolean)
state = Column(String)
track_all = Column(Boolean)
track_incoming = Column(Boolean)
track_outgoing = Column(Boolean)
track_production = Column(Boolean)
type = Column(String)
uom_id = Column(Integer)
uom_po_id = Column(Integer)
uos_coeff = Column(Numeric)
uos_id = Column(Integer)
volume = Column(Float)
warranty = Column(Float)
weight = Column(Numeric)
weight_net = Column(Numeric)
class product_product(Base):
"""Шаблон продука"""
__tablename__ = 'product_product'
id = Column(Integer, primary_key=True)
active = Column(Boolean)
barcode = Column(String)
create_date = Column(DateTime)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
default_code = Column(String)
message_last_post = Column(DateTime)
product_tmpl_id = Column(Integer)
volume = Column(Float)
weight = Column(Numeric)
class product_template(Base):
"""Шаблон продука"""
__tablename__ = 'product_template'
id = Column(Integer, primary_key=True)
id_ = Column(Integer, index=True)
active = Column(Boolean)
can_be_expensed = Column(Boolean) # New
categ_id = Column(Integer, nullable=False)
color = Column(Integer)
company_id = Column(Integer, FKey('res_company.id'), index=True)
company = relationship('res_company',
foreign_keys='product_template.company_id')
create_date = Column(DateTime)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
default_code = Column(String) # New
description = Column(Text)
description_picking = Column(Text)
description_purchase = Column(Text)
description_sale = Column(Text)
expense_policy = Column(String) # New
invoice_policy = Column(String) # New
list_price = Column(Numeric)
location_id = Column(Integer)
message_last_post = Column(String)
name = Column(String, nullable=False)
produce_delay = Column(Float)
purchase_line_warn = Column(String) # New
purchase_line_warn_msg = Column(Text) # New
purchase_method = Column(String)
purchase_ok = Column(Boolean)
purchase_requisition = Column(String)
rental = Column(Boolean)
sale_delay = Column(Float)
sale_line_warn = Column(String) # New
sale_line_warn_msg = Column(Text) # New
sale_ok = Column(Boolean)
sequence = Column(Integer) # New
track_service = Column(String) # New
tracking = Column(String) # New
type = Column(String)
uom_id = Column(Integer)
uom_po_id = Column(Integer)
volume = Column(Float)
warehouse_id = Column(Integer) # New
warranty = Column(Float)
weight = Column(Numeric)
class sale_order_line(Base):
"""Позиция заказа продаж"""
__tablename__ = 'sale_order_line'
id = Column(Integer, primary_key=True)
# address_allotment_id = Column(Integer)
# client_product_name = Column(String)
company_id = Column(Integer, FKey('res_company.id'), index=True)
company = relationship('res_company',
foreign_keys='sale_order_line.company_id')
# contract_production_time = Column(Integer)
# contract_shipment_date = Column(Date)
create_date = Column(DateTime)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
# delay = Column(Float)
currency_id = Column(Integer) # New in 10
customer_lead = Column(Float, nullable=False) # New in 10
discount = Column(Numeric)
# invoiced = Column(Boolean)
invoice_status = Column(String) # New in 10
layout_category_id = Column(Integer) # New in 10
layout_category_sequence = Column(Integer) # New in 10
name = Column(Text, nullable=False)
order_id = Column(Integer, FKey('sale_order.id'), index=True)
order = relationship('sale_order', foreign_keys='sale_order_line.order_id')
order_partner_id = Column(Integer)
price_reduce = Column(Numeric)
price_reduce_taxexcl = Column(Numeric)
price_reduce_taxinc = Column(Numeric)
price_subtotal = Column(Numeric)
price_tax = Column(Numeric)
price_total = Column(Numeric)
price_unit = Column(Numeric, nullable=False)
product_id = Column(Integer, nullable=False)
product_packaging = Column(Integer)
product_uom = Column(Integer)
product_uom_qty = Column(Numeric)
# product_uos = Column(Integer)
# product_uos_qty = Column(Numeric)
# requisition_required = Column(Boolean)
qty_delivered = Column(Numeric)
qty_invoiced = Column(Numeric)
qty_to_invoice = Column(Numeric)
route_id = Column(Integer)
salesman_id = Column(Integer)
sequence = Column(Integer)
state = Column(String)
class RbPayRefuseType(Base):
__tablename__ = 'rbPayRefuseType'
id = Column(Integer, primary_key=True)
code = Column(String(8), index=True)
name = Column(String(128), index=True)
finance_id = Column(Integer, FKey('rbFinance.id'), index=True)
rerun = Column(SmallInteger)
class RbNomenclature(Base):
__tablename__ = 'rbNomenclature'
id = Column(Integer, primary_key=True)
group_id = Column(Integer, FKey('rbNomenclature.id'), index=True)
code = Column(String(64), index=True)
regionalCode = Column(String(64), index=True)
name = Column(String(128), index=True)
class RbActionSheduleItem(Base):
__tablename__ = 'rbActionShedule_Item'
id = Column(Integer, primary_key=True)
master_id = Column(Integer, FKey('rbActionShedule.id'), index=True)
idx = Column(Integer)
offset = Column(SmallInteger)
time = Column(Time)
class crm_stage(Base):
"""Стадия предложения"""
__tablename__ = 'crm_stage'
id = Column(Integer, primary_key=True)
create_date = Column(DateTime)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
fold = Column(Boolean)
legend_priority = Column(Text)
name = Column(String, nullable=False)
on_change = Column(Boolean)
probability = Column(Float)
requirements = Column(Text)
sequence = Column(Integer)
team_id = Column(Integer)
class RbTissueType(Base):
__tablename__ = 'rbTissueType'
id = Column(Integer, primary_key=True)
code = Column(String(64), index=True)
name = Column(String(128))
group_id = Column(Integer, FKey('rbTissueType.id'), index=True)
sex = Column(SmallInteger, default='0')
class RbThesaurus(Base):
__tablename__ = 'rbThesaurus'
id = Column(Integer, primary_key=True)
code = Column(String(30), index=True)
name = Column(String(255))
group_id = Column(Integer, FKey('rbThesaurus.id'), index=True)
template = Column(String(255))
class RbTempInvalidRegime(Base):
__tablename__ = 'rbTempInvalidRegime'
id = Column(Integer, primary_key=True)
code = Column(String(8), index=True)
name = Column(String(64), index=True)
type = Column(SmallInteger, default='0')
doctype_id = Column(Integer, FKey('rbTempInvalidDocument.id'), index=True)
class RbServiceProfile(Base):
__tablename__ = 'rbService_Profile'
id = Column(Integer, primary_key=True)
idx = Column(Integer, default='0')
master_id = Column(Integer, FKey('rbService.id'), index=True)
speciality_id = Column(Integer, FKey('rbSpeciality.id'), index=True)
sex = Column(SmallInteger)
age = Column(String(9))
age_bu = Column(SmallInteger)
age_bc = Column(SmallInteger)
age_eu = Column(SmallInteger)
age_ec = Column(SmallInteger)
mkbRegExp = Column(String(64))
medicalAidProfile_id = Column(Integer,
FKey('rbMedicalAidProfile.id'),
index=True)
class crm_case_stage(Base):
"""Статусы Предложений"""
__tablename__ = 'crm_case_stage'
id = Column(Integer, primary_key=True)
create_date = Column(DateTime)
create_uid = Column(Integer, FKey('res_users.id'), index=True)
write_date = Column(DateTime)
write_uid = Column(Integer, FKey('res_users.id'), index=True)
case_default = Column(Boolean)
requirements = Column(Text)
name = Column(String, nullable=False)
probability = Column(Float)
sequence = Column(Integer)
on_change = Column(Boolean)
fold = Column(Boolean)
state = Column(String)
type = Column(String, nullable=False)
class RbAPTableField(Base):
__tablename__ = 'rbAPTableField'
id = Column(Integer, primary_key=True)
idx = Column(Integer)
master_id = Column(Integer, FKey('rbAPTable.id'), index=True)
name = Column(String(256))
fieldName = Column(String(256))
referenceTable = Column(String(256))
class RbBlankActions(Base):
__tablename__ = 'rbBlankActions'
id = Column(Integer, primary_key=True)
code = Column(String(16), index=True)
name = Column(String(64), index=True)
doctype_id = Column(Integer, FKey('ActionType.id'), index=True)
checkingSerial = Column(SmallInteger)
checkingNumber = Column(SmallInteger)
checkingAmount = Column(SmallInteger)
class RbBlankTempInvalids(Base):
__tablename__ = 'rbBlankTempInvalids'
id = Column(Integer, primary_key=True)
code = Column(String(16), index=True)
name = Column(String(64), index=True)
doctype_id = Column(Integer, FKey('rbTempInvalidDocument.id'), index=True)
checkingSerial = Column(SmallInteger)
checkingNumber = Column(SmallInteger)
checkingAmount = Column(SmallInteger)
class RbTestTubeType(Base):
__tablename__ = 'rbTestTubeType'
id = Column(Integer, primary_key=True)
code = Column(String(64), index=True)
name = Column(String(128), index=True)
volume = Column(Float)
unit_id = Column(Integer, FKey('rbUnit.id'), index=True)
covCol = Column(String(64))
image = Column(Binary)
color = Column(String(8))
class RbResult(Base):
__tablename__ = 'rbResult'
id = Column(Integer, primary_key=True)
code = Column(String(8), index=True)
name = Column(String(64), index=True)
eventPurpose_id = Column(Integer,
FKey('rbEventTypePurpose.id'),
index=True)
continued = Column(SmallInteger)
regionalCode = Column(String(8))
class res_country_state(Base):
"""Страны"""
__tablename__ = 'res_country_state'
id = Column(Integer, primary_key=True)
code = Column(String(3))
country_id = Column(Integer, FKey('res_country.id'), index=True)
create_date = Column(DateTime)
create_uid = Column(Integer)
write_date = Column(DateTime)
write_uid = Column(Integer)
name = Column(String)
class RbDocumentType(Base):
__tablename__ = 'rbDocumentType'
id = Column(Integer, primary_key=True)
code = Column(String(8), index=True)
name = Column(String(64), index=True)
regionalCode = Column(String(16))
group_id = Column(Integer, FKey('rbDocumentTypeGroup.id'), index=True)
serial_format = Column(Integer)
number_format = Column(Integer)
federalCode = Column(String(8))
socCode = Column(String(8), index=True)
TFOMSCode = Column(Integer)
class RbOperationType(Base):
__tablename__ = 'rbOperationType'
id = Column(Integer, primary_key=True)
cd_r = Column(Integer)
cd_subr = Column(Integer)
code = Column(String(10), index=True)
ktso = Column(Integer)
name = Column(String(100), index=True)
operationClass_id = Column(Integer,
FKey('rbOperationClass.id'),
index=True)
TFOMSCode = Column(String(20))