One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table GL5D — Multi-Link Statistical Account Balances

Таблица / Table: GL5D — «Multi-Link Statistical Account Balances». Маска имени таблицы / Table name mask: «GL5D%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GL5D001 NCHAR STRING 12 0 12 StatAccountNo Statistical Account Number   1 Да / Yes
GL5D002 NCHAR STRING 12 0 12 LinkedAccountNo Linked Account Number   2 Да / Yes
GL5D003 INT INTEGER 0 0 2 CurrencyCode Currency Code      
GL5D004 NUMERIC MONEY 28 8 20 YearOpeningBalance Year Opening Balance      
GL5D005 NUMERIC MONEY 28 8 20 Period1DebitAmnt Period 1 Debit Amount      
GL5D006 NUMERIC MONEY 28 8 20 Period2DebitAmnt Period 2 Debit Amount      
GL5D007 NUMERIC MONEY 28 8 20 Period3DebitAmnt Period 3 Debit Amount      
GL5D008 NUMERIC MONEY 28 8 20 Period4DebitAmnt Period 4 Debit Amount      
GL5D009 NUMERIC MONEY 28 8 20 Period5DebitAmnt Period 5 Debit Amount      
GL5D010 NUMERIC MONEY 28 8 20 Period6DebitAmnt Period 6 Debit Amount      
GL5D011 NUMERIC MONEY 28 8 20 Period7DebitAmnt Period 7 Debit Amount      
GL5D012 NUMERIC MONEY 28 8 20 Period8DebitAmnt Period 8 Debit Amount      
GL5D013 NUMERIC MONEY 28 8 20 Period9DebitAmnt Period 9 Debit Amount      
GL5D014 NUMERIC MONEY 28 8 20 Period10DebitAmnt Period 10 Debit Amount      
GL5D015 NUMERIC MONEY 28 8 20 Period11DebitAmnt Period 11 Debit Amount      
GL5D016 NUMERIC MONEY 28 8 20 Period12DebitAmnt Period 12 Debit Amount      
GL5D017 NUMERIC MONEY 28 8 20 Period13DebitAmnt Period 13 Debit Amount      
GL5D018 NUMERIC MONEY 28 8 20 Period14DebitAmnt Period 14 Debit Amount      
GL5D019 NUMERIC MONEY 28 8 20 Period15DebitAmnt Period 15 Debit Amount      
GL5D020 NUMERIC MONEY 28 8 20 Period16DebitAmnt Period 16 Debit Amount      
GL5D021 NUMERIC MONEY 28 8 20 Period17DebitAmnt Period 17 Debit Amount      
GL5D022 NUMERIC MONEY 28 8 20 Period18DebitAmnt Period 18 Debit Amount      
GL5D023 NUMERIC MONEY 28 8 20 Period19DebitAmnt Period 19 Debit Amount      
GL5D024 NUMERIC MONEY 28 8 20 Period20DebitAmnt Period 20 Debit Amount      
GL5D025 NUMERIC MONEY 28 8 20 Period21DebitAmnt Period 21 Debit Amount      
GL5D026 NUMERIC MONEY 28 8 20 Period22DebitAmnt Period 22 Debit Amount      
GL5D027 NUMERIC MONEY 28 8 20 Period23DebitAmnt Period 23 Debit Amount      
GL5D028 NUMERIC MONEY 28 8 20 Period24DebitAmnt Period 24 Debit Amount      
GL5D029 NUMERIC MONEY 28 8 20 ClosingPeriodDebitAmnt Closing Period Debit Amount      
GL5D030 NUMERIC MONEY 28 8 20 Period1CreditAmnt Period 1 Credit Amount      
GL5D031 NUMERIC MONEY 28 8 20 Period2CreditAmnt Period 2 Credit Amount      
GL5D032 NUMERIC MONEY 28 8 20 Period3CreditAmnt Period 3 Credit Amount      
GL5D033 NUMERIC MONEY 28 8 20 Period4CreditAmnt Period 4 Credit Amount      
GL5D034 NUMERIC MONEY 28 8 20 Period5CreditAmnt Period 5 Credit Amount      
GL5D035 NUMERIC MONEY 28 8 20 Period6CreditAmnt Period 6 Credit Amount      
GL5D036 NUMERIC MONEY 28 8 20 Period7CreditAmnt Period 7 Credit Amount      
GL5D037 NUMERIC MONEY 28 8 20 Period8CreditAmnt Period 8 Credit Amount      
GL5D038 NUMERIC MONEY 28 8 20 Period9CreditAmnt Period 9 Credit Amount      
GL5D039 NUMERIC MONEY 28 8 20 Period10CreditAmnt Period 10 Credit Amount      
GL5D040 NUMERIC MONEY 28 8 20 Period11CreditAmnt Period 11 Credit Amount      
GL5D041 NUMERIC MONEY 28 8 20 Period12CreditAmnt Period 12 Credit Amount      
GL5D042 NUMERIC MONEY 28 8 20 Period13CreditAmnt Period 13 Credit Amount      
GL5D043 NUMERIC MONEY 28 8 20 Period14CreditAmnt Period 14 Credit Amount      
GL5D044 NUMERIC MONEY 28 8 20 Period15CreditAmnt Period 15 Credit Amount      
GL5D045 NUMERIC MONEY 28 8 20 Period16CreditAmnt Period 16 Credit Amount      
GL5D046 NUMERIC MONEY 28 8 20 Period17CreditAmnt Period 17 Credit Amount      
GL5D047 NUMERIC MONEY 28 8 20 Period18CreditAmnt Period 18 Credit Amount      
GL5D048 NUMERIC MONEY 28 8 20 Period19CreditAmnt Period 19 Credit Amount      
GL5D049 NUMERIC MONEY 28 8 20 Period20CreditAmnt Period 20 Credit Amount      
GL5D050 NUMERIC MONEY 28 8 20 Period21CreditAmnt Period 21 Credit Amount      
GL5D051 NUMERIC MONEY 28 8 20 Period22CreditAmnt Period 22 Credit Amount      
GL5D052 NUMERIC MONEY 28 8 20 Period23CreditAmnt Period 23 Credit Amount      
GL5D053 NUMERIC MONEY 28 8 20 Period24CreditAmnt Period 24 Credit Amount      
GL5D054 NUMERIC MONEY 28 8 20 ClosingPeriodCreditAmnt Closing Period Credit Amount      

Навигация / Navigation: