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")