Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: GL30 - «Transaction Workfile B». Маска имени таблицы: «GL30%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GL30001 | NVARCHAR | VSTRING | 42 | 0 | 42 | TerminalNo | NULL | 1 | Да | |
GL30002 | NVARCHAR | VSTRING | 6 | 0 | 6 | LineNumber | NULL | 2 | Да | |
GL30003 | NVARCHAR | VSTRING | 12 | 0 | 12 | DebitAccount | NULL | |||
GL30004 | NVARCHAR | VSTRING | 12 | 0 | 12 | CredAccount | NULL | |||
GL30005 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccountNo | NULL | |||
GL30006 | NUMERIC | MONEY | 28 | 8 | 20 | PeriodBal | NULL | |||
GL30007 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod1 | NULL | |||
GL30008 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod2 | NULL | |||
GL30009 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod3 | NULL | |||
GL30010 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod4 | NULL | |||
GL30011 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod5 | NULL | |||
GL30012 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod6 | NULL | |||
GL30013 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod7 | NULL | |||
GL30014 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod8 | NULL | |||
GL30015 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod9 | NULL | |||
GL30016 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod10 | NULL | |||
GL30017 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod11 | NULL | |||
GL30018 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod12 | NULL | |||
GL30019 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod13 | NULL | |||
GL30020 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod14 | NULL | |||
GL30021 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod15 | NULL | |||
GL30022 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod16 | NULL | |||
GL30023 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod17 | NULL | |||
GL30024 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod18 | NULL | |||
GL30025 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod19 | NULL | |||
GL30026 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod20 | NULL | |||
GL30027 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod21 | NULL | |||
GL30028 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod22 | NULL | |||
GL30029 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod23 | NULL | |||
GL30030 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod24 | NULL | |||
GL30031 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod25 | NULL | |||
GL30032 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod26 | NULL | |||
GL30033 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod27 | NULL | |||
GL30034 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod28 | NULL | |||
GL30035 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod29 | NULL | |||
GL30036 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod30 | NULL | |||
GL30037 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod31 | NULL | |||
GL30038 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod32 | NULL | |||
GL30039 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod33 | NULL | |||
GL30040 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod34 | NULL | |||
GL30041 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod35 | NULL | |||
GL30042 | NUMERIC | MONEY | 28 | 8 | 20 | AmPeriod36 | NULL | |||
GL30043 | NVARCHAR | VSTRING | 25 | 0 | 25 | Text | NULL | |||
GL30044 | NUMERIC | MONEY | 28 | 8 | 20 | AmField1 | NULL | |||
GL30045 | NUMERIC | MONEY | 28 | 8 | 20 | AmField2 | NULL | |||
GL30046 | NUMERIC | MONEY | 28 | 8 | 20 | AmField3 | NULL | |||
GL30047 | NUMERIC | MONEY | 28 | 8 | 20 | AmField4 | NULL | |||
GL30048 | NUMERIC | MONEY | 28 | 8 | 20 | AmField5 | NULL | |||
GL30049 | NUMERIC | MONEY | 28 | 8 | 20 | AmField6 | NULL | |||
GL30050 | NUMERIC | MONEY | 28 | 8 | 20 | AmField7 | NULL | |||
GL30051 | NUMERIC | MONEY | 28 | 8 | 20 | AmField8 | NULL | |||
GL30052 | NUMERIC | MONEY | 28 | 8 | 20 | AmField9 | NULL | |||
GL30053 | NUMERIC | MONEY | 28 | 8 | 20 | AmField10 | NULL | |||
GL30054 | NUMERIC | MONEY | 28 | 8 | 20 | AmField11 | NULL | |||
GL30055 | NUMERIC | MONEY | 28 | 8 | 20 | AmField12 | NULL | |||
GL30056 | NUMERIC | MONEY | 28 | 8 | 20 | AmField13 | NULL | |||
GL30057 | NUMERIC | MONEY | 28 | 8 | 20 | AmField14 | NULL |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | General Ledger | Transaction Workfile B