пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: 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        
SYL8036 NVARCHAR VSTRING 10 0 10 InvSerialCode Invoice Serial Code      
SYL8037 NCHAR STRING 1 0 1 PrefixType Prefix Type      
SYL8038 NCHAR STRING 1 0 1 Delimiter Delimiter      
SYL8039 NCHAR STRING 2 0 2 CounterRefA3 Counter Reference TaxNote Category A      
SYL8040 NCHAR STRING 2 0 2 CounterRefB3 Counter Reference TaxNote Category B      
SYL8041 NCHAR STRING 2 0 2 CounterRefC3 Counter Reference TaxNote Category C      
SYL8042 NCHAR STRING 2 0 2 CounterRefE3 Counter Reference TaxNote Category E      
SYL8043 NCHAR STRING 2 0 2 CounterRefZ3 Counter Reference TaxNote Category Z      
SYL8044 NCHAR STRING 4 0 4 SiteCode Site Code Site Code    
SYL8045 NCHAR STRING 8 0 8 Prefix Prefix Prefix    

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | System Utilities/Office Autom. | Document Issuer

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.