Таблица | Table: GL30 - «Transaction Workfile B». Маска имени таблицы | Table Name Mask: «GL30%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
GL30001 | NVARCHAR | VSTRING | 42 | 0 | 42 | TerminalNo | 1 | Да / Yes | ||
GL30002 | NVARCHAR | VSTRING | 6 | 0 | 6 | LineNumber | 2 | Да / Yes | ||
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 | ||||
GL30058 | NCHAR | STRING | 1 | 0 | 1 | AllocationType | Allocation Type | |||
GL30059 | NUMERIC | MONEY | 28 | 8 | 20 | AmField15 | ||||
GL30060 | NUMERIC | MONEY | 28 | 8 | 20 | AmField16 | ||||
GL30061 | NUMERIC | MONEY | 28 | 8 | 20 | AmField17 | ||||
GL30062 | NUMERIC | MONEY | 28 | 8 | 20 | AmField18 | ||||
GL30063 | NUMERIC | MONEY | 28 | 8 | 20 | AmField19 | ||||
GL30064 | NUMERIC | MONEY | 28 | 8 | 20 | AmField20 | ||||
GL30065 | NUMERIC | MONEY | 28 | 8 | 20 | AmField21 | ||||
GL30066 | NUMERIC | MONEY | 28 | 8 | 20 | AmField22 | ||||
GL30067 | NUMERIC | MONEY | 28 | 8 | 20 | AmField23 | ||||
GL30068 | NUMERIC | MONEY | 28 | 8 | 20 | AmField24 | ||||
GL30069 | NUMERIC | MONEY | 28 | 8 | 20 | AmField25 | ||||
GL30070 | NUMERIC | MONEY | 28 | 8 | 20 | AmField26 | ||||
GL30071 | NUMERIC | MONEY | 28 | 8 | 20 | AmField27 | ||||
GL30072 | NUMERIC | MONEY | 28 | 8 | 20 | AmField28 | ||||
GL30073 | NUMERIC | MONEY | 28 | 8 | 20 | AmField29 | ||||
GL30074 | NUMERIC | MONEY | 28 | 8 | 20 | AmField30 | ||||
GL30075 | NUMERIC | MONEY | 28 | 8 | 20 | AmField31 | ||||
GL30076 | NUMERIC | MONEY | 28 | 8 | 20 | AmField32 | ||||
GL30077 | NUMERIC | MONEY | 28 | 8 | 20 | AmField33 | ||||
GL30078 | NUMERIC | MONEY | 28 | 8 | 20 | AmField34 | ||||
GL30079 | NUMERIC | MONEY | 28 | 8 | 20 | AmField35 | ||||
GL30080 | NUMERIC | MONEY | 28 | 8 | 20 | AmField36 |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | Transaction Workfile B