class Credit(TableRG): index = 55413 client = Field("SP55414", join=Clients.id) doc = Field("SP55415", join=TableJournal.doc) price = Field("SP55416") invoice = Field("SP55427") diff = Field("SP55439")
class LeftsMotion(TableRA): """ Регистр остатки(движение) """ index = 55503 stock = Field("SP55613", join=Stocks.id) item = Field("SP55504", join=Items.id) count = Field("SP55506")
class TableConstant(Table): prefix = "1SCONST" name = "Const" obj = Field("OBJID") field = Field("id") date = Field("date") value = Field("value")
class Lefts(TableRG): """ Регистр остатки """ index = 55503 stock = Field("SP55613", join=Stocks.id) item = Field("SP55504", join=Items.id) count = Field("SP55506")
class TableBlob(Table): """ Хранит длинные строки(неорганиченной длины) """ prefix: str = "BLOB" name: str = "Blob" field_id = Field("FIELDID") obj_id = Field("OBJID") block_no = Field("BLOCKNO") block = Field("BLOCK") index_main = Field("fieldid+objid+STR(blockno,4)")
class TableJournal(Table): prefix: str = "1SJOURN" name: str = "Journal" doc = Field("IDDOC") docref = Field("IDDOCREF") date = Field("DATE") number = Field("DOCNO") closed = Field("CLOSED") ismark = Field("ISMARK")
class Clients(TableSC): """ Контрагенты """ index = 133 manager = Field("SP55407", join=Manager.id)
class TableRA(Table): prefix = "RA" file: str = None doc = Field("IDDOC", join=TableJournal.doc) lineno = Field("LINENO")
class TableDT(Table): prefix = "DT" doc = Field("IDDOC") line = Field("LINENO")
class TableDH(Table): prefix = "DH" doc = Field("IDDOC", join=TableJournal.doc)
class TableSC(Table): prefix = "SC" id = Field("ID") code = Field("CODE") description = Field("DESCR")