Таблица: SYL8 - «Document Issuer». Маска имени таблицы: «SYL8%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SYL8001 NCHAR SWITCH 1 0 1 DocumentType Document Type A - Invoice Issuer
B - Delivery Note Issuer
C - Receipt Issuer
1 Да
SYL8002 NCHAR STRING 4 0 4 DocumentIssuerCode Issuer Code   2 Да
SYL8003 NCHAR STRING 16 0 16 DocIssuerExternalCod External Code      
SYL8004 DATETIME DATE 0 0 8 DocIssuervalidDate Valid to Date      
SYL8005 NVARCHAR VSTRING 35 0 35 AdrLine1 Address Line 1      
SYL8006 NVARCHAR VSTRING 35 0 35 AddrLine2 Address Line 2      
SYL8007 NVARCHAR VSTRING 35 0 35 AddrLine3 Address Line 3      
SYL8008 NVARCHAR VSTRING 35 0 35 AddrLine4 Address Line 4      
SYL8009 NVARCHAR VSTRING 10 0 10 ZipCode Zip Code      
SYL8010 NCHAR STRING 2 0 2 StateCode State Code      
SYL8011 NCHAR STRING 3 0 3 GeoCode Geo Code      
SYL8012 NVARCHAR VSTRING 20 0 20 TelephNumb Telephone Number      
SYL8013 NVARCHAR VSTRING 20 0 20 FaxNumb Fax Number      
SYL8014 DATETIME DATE 0 0 8 LastDocIssueDate Last Document Issue Date      
SYL8015 NCHAR STRING 2 0 2 CounterRefA0 Counter Reference Category A Invoice      
SYL8016 NCHAR STRING 2 0 2 CounterRefA1 Counter Reference Category A Debit Note      
SYL8017 NCHAR STRING 2 0 2 CounterRefA2 Counter Reference Category A Credit Note      
SYL8018 NCHAR STRING 2 0 2 CounterRefB0 Counter Reference Category B Invoice      
SYL8019 NCHAR STRING 2 0 2 CounterRefB1 Counter Reference Category B Debit Note      
SYL8020 NCHAR STRING 2 0 2 CounterRefB2 Counter Reference Category B Credit Note      
SYL8021 NCHAR STRING 2 0 2 CounterRefC0 Counter Reference Category C Invoice      
SYL8022 NCHAR STRING 2 0 2 CounterRefC1 Counter Reference Category C Debit Note      
SYL8023 NCHAR STRING 2 0 2 CounterRefC2 Counter Reference Category C Credit Note      
SYL8024 NCHAR STRING 2 0 2 CounterrefE0 Counter Reference Category E Invoice      
SYL8025 NCHAR STRING 2 0 2 CounterRefE1 Counter Reference Category E Debit Note      
SYL8026 NCHAR STRING 2 0 2 CounterRefE2 Counter Reference Category E Credit Note      
SYL8027 NCHAR STRING 2 0 2 CounterRefZ0 Counter Reference Category Z Invoice      
SYL8028 NCHAR STRING 2 0 2 CounterRefZ1 Counter Reference Category Z Debit Note      
SYL8029 NCHAR STRING 2 0 2 CounterRefZ2 Counter Reference Category Z Credit Note      
SYL8030 NCHAR STRING 1 0 1 PrinterPaperType Printer Paper Type 0 - Plain paper
1 - Pre-printed/Pre-numbered
   
SYL8031 NVARCHAR VSTRING 1 0 1 PrefixLength Prefix Length      
SYL8032 NVARCHAR VSTRING 2 0 2 CounterLength Counter Length      
SYL8033 NCHAR SWITCH 1 0 1 POSMachine POS Machine      
SYL8034 NCHAR SWITCH 1 0 1 FlagDefInvDate        
SYL8035 NCHAR SWITCH 1 0 1 FlagReprintDelNote        

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | System Utilities/Office Autom. | Document Issuer