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