One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Системные Утилиты» / List of tables of module «System Utilities/Office Autom.»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SYL8 — Document Issuer

Таблица / Table: SYL8 — «Document Issuer». Маска имени таблицы / Table name mask: «SYL8%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SYL8001 NCHAR SWITCH 1 0 1 DocumentType Document Type A — Invoice Issuer

B — Delivery Note Issuer

C — Receipt Issuer
1 Да / Yes
SYL8002 NCHAR STRING 6 0 6 DocumentIssuerCode Issuer Code   2 Да / Yes
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 AdrName Address Name      
SYL8006 NVARCHAR VSTRING 35 0 35 AddrLine1 Address Line 1      
SYL8007 NVARCHAR VSTRING 35 0 35 AddrLine2 Address Line 2      
SYL8008 NVARCHAR VSTRING 35 0 35 AddrLine3 Address Line 3      
SYL8009 NVARCHAR VSTRING 10 0 10 ZipCode Zip Code      
SYL8010 NCHAR STRING 2 0 2 StateCode State Code      
SYL8011 NCHAR STRING 10 0 10 CityCode City 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 FlagDefInvDate      
SYL8035 NCHAR SWITCH 1 0 1 FlagReprintDelNote 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 40 0 40 IssuerDescription Issuer Description      
SYL8045 NCHAR STRING 8 0 8 Prefix Prefix Prefix    
SYL8046 DATETIME DATE 0 0 8 AuthDate Authorization Date      
SYL8047 NVARCHAR VSTRING 20 0 20 AuthNo Authorization No      
SYL8048 NCHAR SWITCH 1 0 1 ApplyToOtherWH ApplyOtherWareh      
SYL8049 NCHAR SWITCH 1 0 1 UseSuffix UseSuffix      
SYL8050 NVARCHAR VSTRING 35 0 35 AddrLine4 Address Line 4      
SYL8051 NVARCHAR VSTRING 35 0 35 AddrLine5 Address Line 5      
SYL8052 NVARCHAR VSTRING 35 0 35 AddrLine6 Address Line 6      
SYL8053 NVARCHAR VSTRING 35 0 35 AddrLine7 Address Line 7      
SYL8054 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      

Навигация / Navigation: