One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «General Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица GL5B — Multi-Currency General Ledger Balances

Таблица: GL5B — «Multi-Currency General Ledger Balances». Маска имени таблицы: «GL5B%cc%yy»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GL5B001 NCHAR STRING 12 0 12 AccountCode Account   1 Да
GL5B002 INT INTEGER 0 0 2 CurrencyCode Currency Code   2 Да
GL5B003 NUMERIC X_NUMERIC 28 8 20 YearOpeningBalance Year Opening Balance      
GL5B004 NUMERIC MONEY 28 8 20 Period1DebitAmount Period 1 Debit Amount      
GL5B005 NUMERIC MONEY 28 8 20 Period2DebitAmount Period 2 Debit Amount      
GL5B006 NUMERIC MONEY 28 8 20 Period3DebitAmount Period 3 Debit Amount      
GL5B007 NUMERIC MONEY 28 8 20 Period4DebitAmout Period 4 Debit Amount      
GL5B008 NUMERIC MONEY 28 8 20 Period5DebitAmount Period 5 Debit Amount      
GL5B009 NUMERIC MONEY 28 8 20 Period6DebitAmount Period 6 Debit Amount      
GL5B010 NUMERIC MONEY 28 8 20 Period7DebitAmount Period 7 Debit Amount      
GL5B011 NUMERIC MONEY 28 8 20 Period8DebitAmount Period 8 Debit Amount      
GL5B012 NUMERIC MONEY 28 8 20 Period9DebitAmount Period 9 Debit Amount      
GL5B013 NUMERIC MONEY 28 8 20 Period10DebitAmount Period 10 Debit Amount      
GL5B014 NUMERIC MONEY 28 8 20 Period11DebitAmount Period 11 Debit Amount      
GL5B015 NUMERIC MONEY 28 8 20 Period12DebitAmount Period 12 Debit Amount      
GL5B016 NUMERIC MONEY 28 8 20 Period13DebitAmount Period 13 Debit Amount      
GL5B017 NUMERIC MONEY 28 8 20 Period14DebitAmount Period 14 Debit Amount      
GL5B018 NUMERIC MONEY 28 8 20 Period15DebitAmount Period 15 Debit Amount      
GL5B019 NUMERIC MONEY 28 8 20 Period16DebitAmount Period 16 Debit Amount      
GL5B020 NUMERIC MONEY 28 8 20 Period17DebitAmount Period 17 Debit Amount      
GL5B021 NUMERIC MONEY 28 8 20 Period18DebitAmount Period 18 Debit Amount      
GL5B022 NUMERIC MONEY 28 8 20 Period19DebitAmount Period 19 Debit Amount      
GL5B023 NUMERIC MONEY 28 8 20 Period20DebitAmount Period 20 Debit Amount      
GL5B024 NUMERIC MONEY 28 8 20 Period21DebitAmount Period 21 Debit Amount      
GL5B025 NUMERIC MONEY 28 8 20 Period22DebitAmount Period 22 Debit Amount      
GL5B026 NUMERIC MONEY 28 8 20 Period23DebitAmount Period 23 Debit Amount      
GL5B027 NUMERIC MONEY 28 8 20 Period24DebitAmount Period 24 Debit Amount      
GL5B028 NUMERIC MONEY 28 8 20 ClosPeriodDebitAmo Closing Period Debit Amount      
GL5B029 NUMERIC MONEY 28 8 20 Period1CreditAmount Period 1 Credit Amount      
GL5B030 NUMERIC MONEY 28 8 20 Period2CreditAmount Period 2 Credit Amount      
GL5B031 NUMERIC MONEY 28 8 20 Period3CreditAmount Period 3 Credit Amount      
GL5B032 NUMERIC MONEY 28 8 20 Period4CreditAmount Period 4 Credit Amount      
GL5B033 NUMERIC MONEY 28 8 20 Period5CreditAmount Period 5 Credit Amount      
GL5B034 NUMERIC MONEY 28 8 20 Period6CreditAmount Period 6 Credit Amount      
GL5B035 NUMERIC MONEY 28 8 20 Period7CreditAmount Period 7 Credit Amount      
GL5B036 NUMERIC MONEY 28 8 20 Period8CreditAmount Period 8 Credit Amount      
GL5B037 NUMERIC MONEY 28 8 20 Period9CreditAmount Period 9 Credit Amount      
GL5B038 NUMERIC MONEY 28 8 20 Period10CreditAmount Period 10 Credit Amount      
GL5B039 NUMERIC MONEY 28 8 20 Period11CreditAmount Period 11 Credit Amount      
GL5B040 NUMERIC MONEY 28 8 20 Period12CreditAmount Period 12 Credit Amount      
GL5B041 NUMERIC MONEY 28 8 20 Period13CreditAmount Period 13 Credit Amount      
GL5B042 NUMERIC MONEY 28 8 20 Period14CreditAmount Period 14 Credit Amount      
GL5B043 NUMERIC MONEY 28 8 20 Period15CreditAmount Period 15 Credit Amount      
GL5B044 NUMERIC MONEY 28 8 20 Period16CreditAmount Period 16 Credit Amount      
GL5B045 NUMERIC MONEY 28 8 20 Period17CreditAmount Period 17 Credit Amount      
GL5B046 NUMERIC MONEY 28 8 20 Period18CreditAmount Period 18 Credit Amount      
GL5B047 NUMERIC MONEY 28 8 20 Period19CreditAmount Period 19 Credit Amount      
GL5B048 NUMERIC MONEY 28 8 20 Period20CreditAmount Period 20 Credit Amount      
GL5B049 NUMERIC MONEY 28 8 20 Period21CreditAmount Period 21 Credit Amount      
GL5B050 NUMERIC MONEY 28 8 20 Period22CreditAmount Period 22 Credit Amount      
GL5B051 NUMERIC MONEY 28 8 20 Period23CreditAmount Period 23 Credit Amount      
GL5B052 NUMERIC MONEY 28 8 20 Period24CreditAmount Period 24 Credit Amount      
GL5B053 NUMERIC MONEY 28 8 20 ClosPeriodCreditAmo Closing Period Credit Amount      

Навигация: