Таблица | Table: SLIN - «Invoice Based Intrastat SL». Маска имени таблицы | Table Name Mask: «SLIN%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SLIN001 NCHAR STRING 10 0 10 Customer Code Customer Code   1 Да / Yes
SLIN002 NCHAR STRING 15 0 15 Invoice Number Invoice Number   2 Да / Yes
SLIN003 NVARCHAR VSTRING 14 0 14 Statistical Code Statistical Code      
SLIN004 NUMERIC MONEY 28 8 20 Amount LCU Amount LCU      
SLIN005 NCHAR STRING 2 0 2 Nature of Transaction Nature of Transaction      
SLIN006 NCHAR STRING 10 0 10 Sales Order Sales Order      
SLIN007 NUMERIC X_NUMERIC 18 8 10 Volume Net Volume Net      
SLIN008 NCHAR STRING 10 0 10 Sup Units QTY or Descr Supplementary Units QTY or Description      
SLIN009 NUMERIC MONEY 28 8 20 Statistical Value Statistical Value      
SLIN010 NCHAR STRING 2 0 2 Regime Regime      
SLIN011 NCHAR STRING 2 0 2 Transport Method Transport Method      
SLIN012 NCHAR STRING 3 0 3 Country of Nature Country of Nature      
SLIN013 NCHAR STRING 3 0 3 Country of Origin Country of Origin      
SLIN014 NCHAR STRING 3 0 3 Country of Destination Country of Destination      
SLIN015 NCHAR STRING 2 0 2 Period Reference Period Reference      
SLIN016 NCHAR STRING 4 0 4 Year Reference Year Reference      
SLIN017 NUMERIC MONEY 28 8 20 Amount OCU Amount OCU      
SLIN018 INT INTEGER 0 0 2 Original Currency Code Original Currency Code      
SLIN019 DATETIME DATE 0 0 8 Transaction Date Transaction Date      
SLIN020 INT INTEGER 0 0 3 Line Number Line Number   3 Да / Yes

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Sales Ledger | Invoice Based Intrastat SL