#AccWare Data Dictionary
D=DDV7120|AccWare Data Dictionary (DDCP=1251RUS)|
#
#
#===============================================================================
#==TABLE no 0      : Соединений
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=1SUSERS |Соединений                    |A          |1SUSERS    |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=USRSCNT   |Number of users     |N   |4     |0        
F=NETCHGCN  |Count of changes    |N   |10    |0        
#
#===============================================================================
#==TABLE no 1      : Системная
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=1SSYSTEM|Системная                     |A          |1SSYSTEM   |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=CURDATE   |Date of TM          |D   |8     |0        
F=CURTIME   |Time of TM          |C   |6     |0        
F=EVENTIDTA |ID Event On TA      |C   |9     |0        
F=DBSIGN    |DB Sign             |C   |3     |0        
F=DBSETUUID |UUID of DB set      |C   |36    |0        
F=SNAPSHPER |Snap Shot Period    |C   |1     |0        
F=ACCDATE   |Date of Account Tota|D   |8     |0        
F=FLAGS     |FLAGS               |N   |10    |0        
#
#===============================================================================
#==TABLE no 2      : Константы
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=1SCONST |Константы                     |A          |1SCONST    |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=OBJID     |ID obj(0-cons )     |C   |9     |0        
F=ID        |ID parameter        |C   |4     |0        
F=DATE      |Fix date            |D   |8     |0        
F=PARTNO    |no of part          |N   |3     |0        
F=VALUE     |valume              |C   |23    |0        
F=DOCID     |ID Document         |C   |9     |0        
F=TIME      |Time                |C   |6     |0        
F=ACTNO     |Action No           |N   |6     |0        
F=LINENO    |LineNo              |N   |4     |0        
F=TVALUE    |                    |C   |3     |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=IDD      |              |0     |ID,OBJID,DATE,TIME,DOCID,PARTNO                             |IDD        
I=DOC      |              |0     |DOCID,ACTNO,PARTNO                                          |DOC        
#
#===============================================================================
#==TABLE no 3      : Журналы
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=1SJOURN |Журналы                       |A          |1SJOURN    |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=IDJOURNAL |ID of Journal       |C   |4     |0        
F=IDDOC     |ID Document         |C   |9     |0        
F=IDDOCDEF  |ID Def Document     |C   |4     |0        
F=APPCODE   |Application code    |N   |3     |0        
F=DATE      |date                |D   |8     |0        
F=TIME      |Time                |C   |6     |0        
F=DNPREFIX  |Prefix Document No  |C   |18    |0        
F=DOCNO     |Document No         |C   |8     |0        
F=CLOSED    |Flag Document is Clo|N   |1     |0        
F=ISMARK    |Flag Document is Mar|C   |1     |0        
F=ACTCNT    |Action counter      |C   |6     |0        
F=VERSTAMP  |Version stamp       |C   |6     |0        
F=RF76      |Reg Action Flag     |N   |1     |0        
F=RF81      |Reg Action Flag     |N   |1     |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=IDDOC    |Id Doc        |0     |IDDOC                                                       |IDDOC      
I=ACDATETIM|Date+Time+ID  |0     |DATE,TIME,IDDOC                                             |ACDATETIME 
I=DOCNO    |Prefix+No     |0     |DNPREFIX,DOCNO(UPPER)                                       |DOCNO      
I=DOCTYPE  |Type+Date+Time|0     |IDDOCDEF,DATE,TIME,IDDOC                                    |DOCTYPE    
I=JOURNAL  |Journal+Date+T|0     |IDJOURNAL,DATE,TIME,IDDOC                                   |JOURNAL    
#
#===============================================================================
#==TABLE no 4      : Ссылки документов
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=1SCRDOC |Ссылки документов             |A          |1SCRDOC    |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=MDID      |Md ID of select     |C   |4     |0        
F=PARENTVAL |Parent Value        |C   |23    |0        
F=CHILDDATE |Child date          |D   |8     |0        
F=CHILDTIME |Child Time          |C   |6     |0        
F=CHILDID   |Child Doc ID        |C   |9     |0        
F=FLAGS     |Flags of refers     |N   |2     |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=CHILD    |Child Referenc|0     |CHILDID,MDID,PARENTVAL                                      |CHILD      
I=PARENT   |Parent Referen|0     |MDID,PARENTVAL,CHILDDATE,CHILDTIME,CHILDID                  |PARENT     
#
#===============================================================================
#==TABLE no 5      : Номеров документов
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=1SDNLOCK|Номеров документов            |A          |1SDNLOCK   |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=DNPREFIX  |Prefix object       |C   |28    |0        
F=DOCNO     |Object No           |C   |11    |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=DOCNO    |Prefix+No     |0     |DNPREFIX,DOCNO                                              |DOCNO      
#
#===============================================================================
#==TABLE no 6      : Уникальности
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=1SUIDCTL|Уникальности                  |A          |1SUIDCTL   |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=TYPEID    |Type ID             |C   |4     |0        
F=MAXID     |Max Object ID       |C   |9     |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=MAIN     |TypeID        |0     |TYPEID                                                      |MAIN       
#
#===============================================================================
#==TABLE no 7      : Длинные строки
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=1SBLOB  |Длинные строки                |A          |1SBLOB     |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=FIELDID   |Field Id            |C   |4     |0        
F=OBJID     |Obj Id              |C   |9     |0        
F=BLOCKNO   |Block Number        |N   |4     |0        
F=BLOCK     |Block               |C   |80    |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=MAIN     |              |0     |FIELDID,OBJID,BLOCKNO                                       |MAIN       
#
#===============================================================================
#==TABLE no 8      : Справочник Покупатели
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=SC119   |Справочник Покупатели         |A          |SC119      |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=ID        |ID object           |C   |9     |0        
F=CODE      |object code         |C   |11    |0        
F=DESCR     |object description  |C   |25    |0        
F=ISMARK    |Flag Object is Marke|C   |1     |0        
F=VERSTAMP  |Version stamp       |C   |6     |0        
F=SP120     |(P)Фамилия          |C   |20    |0        
F=SP121     |(P)Имя              |C   |20    |0        
F=SP122     |(P)Отчество         |C   |20    |0        
F=SP123     |(P)Пол              |C   |1     |0        
F=SP124     |(P)ДатаРождения     |D   |8     |0        
F=SP126     |(P)Параметр1        |C   |20    |0        
F=SP127     |(P)Параметр2        |C   |20    |0        
F=SP128     |(P)email            |C   |50    |0        
F=SP142     |(P)Скидка           |N   |3     |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=IDD      |of ID         |0     |ID                                                          |IDD        
I=CODE     |of CODE       |0     |CODE(UPPER)                                                 |CODE       
I=DESCR    |of DESCR      |0     |DESCR(UPPER)                                                |DESCR      
I=VI120    |VI120         |0     |SP120(UPPER=128),DESCR(UPPER)                               |VI120      
I=VI121    |VI121         |0     |SP121(UPPER=128),DESCR(UPPER)                               |VI121      
I=VI122    |VI122         |0     |SP122(UPPER=128),DESCR(UPPER)                               |VI122      
I=VI124    |VI124         |0     |SP124,DESCR(UPPER)                                          |VI124      
I=VI142    |VI142         |0     |SP142,DESCR(UPPER)                                          |VI142      
#
#===============================================================================
#==TABLE no 9      : Справочник Кассиры
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=SC137   |Справочник Кассиры            |A          |SC137      |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=ID        |ID object           |C   |9     |0        
F=CODE      |object code         |C   |2     |0        
F=DESCR     |object description  |C   |25    |0        
F=ISMARK    |Flag Object is Marke|C   |1     |0        
F=VERSTAMP  |Version stamp       |C   |6     |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=IDD      |of ID         |0     |ID                                                          |IDD        
I=CODE     |of CODE       |0     |CODE(UPPER)                                                 |CODE       
I=DESCR    |of DESCR      |0     |DESCR(UPPER)                                                |DESCR      
#
#===============================================================================
#==TABLE no 10     : Документ Чек
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=DH22    |Документ Чек                  |A          |DH22       |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=IDDOC     |ID Document's       |C   |9     |0        
F=SP28      |(P)ЧекНомер         |C   |12    |0        
F=SP29      |(P)ЧекДата          |D   |8     |0        
F=SP30      |(P)ЧекВремя         |C   |8     |0        
F=SP31      |(P)ФлВозврат        |N   |2     |0        
F=SP33      |(P)Получено         |N   |16    |2        
F=SP34      |(P)ЧекПробитККМ     |N   |2     |0        
F=SP35      |(P)ДокОсн           |C   |9     |0        
F=SP38      |(P)Процент          |N   |3     |0        
F=SP53      |(P)НомерЧекаОтгр    |C   |8     |0        
F=SP62      |(P)флПроведенПоБазеО|N   |2     |0        
F=SP63      |(P)флПроведенПоБазеП|N   |2     |0        
F=SP66      |(P)Автор            |C   |15    |0        
F=SP67      |(P)ДопИнфо          |C   |20    |0        
F=SP73      |(P)флБезнал         |N   |2     |0        
F=SP115     |(P)Опт              |N   |2     |0        
F=SP130     |(P)Покупатель       |C   |9     |0        
F=SP45      |(P)Сумма            |N   |15    |2        
F=SP93      |(P)СкидкаЗначение   |N   |11    |2        
F=SP47      |(P)Скидка           |N   |11    |2        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=ID       |of IDDOC      |0     |IDDOC                                                       |ID         
#
#===============================================================================
#==TABLE no 11     : Документ (Мн.ч.) Чек
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=DT22    |Документ (Мн.ч.) Чек          |A          |DT22       |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=IDDOC     |ID Document's       |C   |9     |0        
F=LINENO    |LineNo              |N   |4     |0        
F=SP51      |(P)КодТовара        |N   |14    |0        
F=SP41      |(P)Номенклатура     |C   |110   |0        
F=SP42      |(P)Кол              |N   |13    |0        
F=SP44      |(P)Цена             |N   |11    |2        
F=SP45      |(P)Сумма            |N   |15    |2        
F=SP92      |(P)СкидкаВид        |N   |2     |0        
F=SP93      |(P)СкидкаЗначение   |N   |11    |2        
F=SP47      |(P)Скидка           |N   |11    |2        
F=SP70      |(P)КолНаОстатке     |N   |13    |3        
F=SP152     |(P)ДШК              |C   |255   |0        
F=SP162     |(P)Маркировка       |N   |5     |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=IDLINE   |of IDDOC+LineN|0     |IDDOC,LINENO                                                |IDLINE     
#
#===============================================================================
#==TABLE no 12     : Документ Инкассация
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=DH106   |Документ Инкассация           |A          |DH106      |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=IDDOC     |ID Document's       |C   |9     |0        
F=SP101     |(P)ФлВозврат        |N   |2     |0        
F=SP102     |(P)Сумма            |N   |15    |2        
F=SP103     |(P)ДопИнфо          |C   |20    |0        
F=SP104     |(P)Автор            |C   |15    |0        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=ID       |of IDDOC      |0     |IDDOC                                                       |ID         
#
#===============================================================================
#==TABLE no 13     : Регистр Продажи
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=RG76    |Регистр Продажи               |A          |RG76       |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=PERIOD    |Period Registr      |D   |8     |0        
F=SP79      |(P)База             |C   |2     |0        
F=SP80      |(P)Товар            |C   |64    |0        
F=SP111     |(P)Код              |C   |10    |0        
F=SP112     |(P)БН               |N   |2     |0        
F=SP85      |(P)Кол              |N   |15    |3        
F=SP77      |(P)Сумма            |N   |13    |2        
F=SP78      |(P)СуммаСкидки      |N   |13    |2        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=PROP     |PERIOD+PROP   |0     |PERIOD,SP79,SP80,SP111,SP112                                |PROP       
I=VIA80    |VIA80         |0     |PERIOD,SP80                                                 |VIA80      
I=VIA111   |VIA111        |0     |PERIOD,SP111                                                |VIA111     
I=VIA112   |VIA112        |0     |PERIOD,SP112                                                |VIA112     
#
#===============================================================================
#==TABLE no 14     : Регистр (Дв.) Продажи
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=RA76    |Регистр (Дв.) Продажи         |A          |RA76       |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=IDDOC     |ID Document's       |C   |9     |0        
F=LINENO    |LineNo              |N   |4     |0        
F=ACTNO     |Action No           |N   |6     |0        
F=DEBKRED   |Flag Debet/Kredit   |N   |1     |0        
F=IDDOCDEF  |ID Def Document     |C   |4     |0        
F=DATE      |date                |D   |8     |0        
F=TIME      |Time                |C   |6     |0        
F=SP79      |(P)База             |C   |2     |0        
F=SP80      |(P)Товар            |C   |64    |0        
F=SP111     |(P)Код              |C   |10    |0        
F=SP112     |(P)БН               |N   |2     |0        
F=SP85      |(P)Кол              |N   |15    |3        
F=SP77      |(P)Сумма            |N   |13    |2        
F=SP78      |(P)СуммаСкидки      |N   |13    |2        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=IDLINE   |of IDDOC+LineN|0     |IDDOC,LINENO,ACTNO                                          |IDLINE     
I=DATETIME |Date+Time+ID+L|0     |DATE,TIME,IDDOC,LINENO,ACTNO                                |DATETIME   
I=VIA79    |VIA79         |0     |SP79,DATE,TIME,IDDOC,LINENO,ACTNO                           |VIA79      
I=VIA80    |VIA80         |0     |SP80,DATE,TIME,IDDOC,LINENO,ACTNO                           |VIA80      
I=VIA111   |VIA111        |0     |SP111,DATE,TIME,IDDOC,LINENO,ACTNO                          |VIA111     
I=VIA112   |VIA112        |0     |SP112,DATE,TIME,IDDOC,LINENO,ACTNO                          |VIA112     
#
#===============================================================================
#==TABLE no 15     : Регистр Касса
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=RG81    |Регистр Касса                 |A          |RG81       |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=PERIOD    |Period Registr      |D   |8     |0        
F=SP82      |(P)База             |C   |2     |0        
F=SP84      |(P)БН               |N   |2     |0        
F=SP83      |(P)Сумма            |N   |13    |2        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=PROP     |PERIOD+PROP   |0     |PERIOD,SP82,SP84                                            |PROP       
#
#===============================================================================
#==TABLE no 16     : Регистр (Дв.) Касса
# Name    |Descr                         |Type[A/S/U]|DBTableName|ReUsable  
T=RA81    |Регистр (Дв.) Касса           |A          |RA81       |1         
#-----Fields-------
# Name      |Descr               |Type|Length|Precision
F=IDDOC     |ID Document's       |C   |9     |0        
F=LINENO    |LineNo              |N   |4     |0        
F=ACTNO     |Action No           |N   |6     |0        
F=DEBKRED   |Flag Debet/Kredit   |N   |1     |0        
F=IDDOCDEF  |ID Def Document     |C   |4     |0        
F=DATE      |date                |D   |8     |0        
F=TIME      |Time                |C   |6     |0        
F=SP82      |(P)База             |C   |2     |0        
F=SP84      |(P)БН               |N   |2     |0        
F=SP83      |(P)Сумма            |N   |13    |2        
#----Indexes------
# Name     |Descr         |Unique|Indexed fields                                              |DBName     
I=IDLINE   |of IDDOC+LineN|0     |IDDOC,LINENO,ACTNO                                          |IDLINE     
I=DATETIME |Date+Time+ID+L|0     |DATE,TIME,IDDOC,LINENO,ACTNO                                |DATETIME   
I=VIA82    |VIA82         |0     |SP82,DATE,TIME,IDDOC,LINENO,ACTNO                           |VIA82      
