Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PLIN - «Invoice Based Intrastat PL». Маска имени таблицы: «PLIN%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PLIN001 | NCHAR | STRING | 10 | 0 | 10 | Supplier Code | Supplier Code | 1 | Да | |
PLIN002 | NCHAR | STRING | 15 | 0 | 15 | Invoice Number | Invoice Number | 2 | Да | |
PLIN003 | NVARCHAR | VSTRING | 14 | 0 | 14 | Statistical Code | Statistical Code | |||
PLIN004 | NUMERIC | MONEY | 28 | 8 | 20 | Amount LCU | Amount LCU | |||
PLIN005 | NCHAR | STRING | 2 | 0 | 2 | Nature of Transaction | Nature of Transaction | |||
PLIN006 | NCHAR | STRING | 10 | 0 | 10 | Purchase Order | Purchase Order | |||
PLIN007 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Volume Net | Volume Net | |||
PLIN008 | NCHAR | STRING | 10 | 0 | 10 | Sup Units QTY or Descr | Supplementary Units QTY or Description | |||
PLIN009 | NUMERIC | MONEY | 28 | 8 | 20 | Statistical Value | Statistical Value | |||
PLIN010 | NCHAR | STRING | 2 | 0 | 2 | Regime | Regime | |||
PLIN011 | NCHAR | STRING | 2 | 0 | 2 | Transport Method | Transport Method | |||
PLIN012 | NCHAR | STRING | 3 | 0 | 3 | Country of Nature | Country of Nature | |||
PLIN013 | NCHAR | STRING | 3 | 0 | 3 | Country of Origin | Country of Origin | |||
PLIN014 | NCHAR | STRING | 3 | 0 | 3 | Country of Destination | Country of Destination | |||
PLIN015 | NCHAR | STRING | 2 | 0 | 2 | Period Reference | Period Reference | |||
PLIN016 | NCHAR | STRING | 4 | 0 | 4 | Year Reference | Year Reference | |||
PLIN017 | NUMERIC | MONEY | 28 | 8 | 20 | Amount OCU | Amount OCU | |||
PLIN018 | INT | INTEGER | 0 | 0 | 2 | Original Currency Code | Original Currency Code | |||
PLIN019 | DATETIME | DATE | 0 | 0 | 8 | Transaction Date | Transaction Date | |||
PLIN020 | INT | INTEGER | 0 | 0 | 3 | Line Number | Line Number | 3 | Да |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Ledger | Invoice Based Intrastat PL