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

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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GL52001 NCHAR STRING 1 0 1 RecordType Record Type 0 — Account Balance
1 — Budget Alternative 1
2 — Budget Alternative 2
3 — Budget Alternative 3
4 — Budget Alternative 4
5 — Budget Alternative 5
6 — Previous Year
1 Да
GL52002 NCHAR STRING 12 0 12 CodeString1 Account   2 Да
GL52003 NCHAR STRING 12 0 12 CodeString2 Accounting Dimension 1   3 Да
GL52004 NCHAR STRING 12 0 12 CodeString3 Accounting Dimension 2   4 Да
GL52005 NCHAR STRING 12 0 12 CodeString4 Accounting Dimension 3   5 Да
GL52006 NUMERIC MONEY 28 8 20 YearOpBal Year Opening Balance      
GL52007 NUMERIC MONEY 28 8 20 P1DebitAm Period 1 Debit Amount      
GL52008 NUMERIC MONEY 28 8 20 P2DebitAm Period 2 Debit Amount      
GL52009 NUMERIC MONEY 28 8 20 P3DebitAm Period 3 Debit Amount      
GL52010 NUMERIC MONEY 28 8 20 P4DebitAm Period 4 Debit Amount      
GL52011 NUMERIC MONEY 28 8 20 P5DebitAm Period 5 Debit Amount      
GL52012 NUMERIC MONEY 28 8 20 P6DebitAm Period 6 Debit Amount      
GL52013 NUMERIC MONEY 28 8 20 P7DebitAm Period 7 Debit Amount      
GL52014 NUMERIC MONEY 28 8 20 P8DebitAm Period 8 Debit Amount      
GL52015 NUMERIC MONEY 28 8 20 P9DebitAm Period 9 Debit Amount      
GL52016 NUMERIC MONEY 28 8 20 P10DebitAm Period 10 Debit Amount      
GL52017 NUMERIC MONEY 28 8 20 P11DebitAm Period 11 Debit Amount      
GL52018 NUMERIC MONEY 28 8 20 P12DebitAm Period 12 Debit Amount      
GL52019 NUMERIC MONEY 28 8 20 P13DebitAm Period 13 Debit Amount      
GL52020 NUMERIC MONEY 28 8 20 P14DebitAm Period 14 Debit Amount      
GL52021 NUMERIC MONEY 28 8 20 P15DebitAm Period 15 Debit Amount      
GL52022 NUMERIC MONEY 28 8 20 P16DebitAm Period 16 Debit Amount      
GL52023 NUMERIC MONEY 28 8 20 P17DebitAm Period 17 Debit Amount      
GL52024 NUMERIC MONEY 28 8 20 P18DebitAm Period 18 Debit Amount      
GL52025 NUMERIC MONEY 28 8 20 P1CredAm Period 1 Credit Amount      
GL52026 NUMERIC MONEY 28 8 20 P2CredAm Period 2 Credit Amount      
GL52027 NUMERIC MONEY 28 8 20 P3CredAm Period 3 Credit Amount      
GL52028 NUMERIC MONEY 28 8 20 P4CredAm Period 4 Credit Amount      
GL52029 NUMERIC MONEY 28 8 20 P5CredAm Period 5 Credit Amount      
GL52030 NUMERIC MONEY 28 8 20 P6CredAm Period 6 Credit Amount      
GL52031 NUMERIC MONEY 28 8 20 P7CredAm Period 7 Credit Amount      
GL52032 NUMERIC MONEY 28 8 20 P8CredAm Period 8 Credit Amount      
GL52033 NUMERIC MONEY 28 8 20 P9CredAm Period 9 Credit Amount      
GL52034 NUMERIC MONEY 28 8 20 P10CredAm Period 10 Credit Amount      
GL52035 NUMERIC MONEY 28 8 20 P11CredAm Period 11 Credit Amount      
GL52036 NUMERIC MONEY 28 8 20 P12CredAm Period 12 Credit Amount      
GL52037 NUMERIC MONEY 28 8 20 P13CredAm Period 13 Credit Amount      
GL52038 NUMERIC MONEY 28 8 20 P14CredAm Period 14 Credit Amount      
GL52039 NUMERIC MONEY 28 8 20 P15CredAm Period 15 Credit Amount      
GL52040 NUMERIC MONEY 28 8 20 P16CredAm Period 16 Credit Amount      
GL52041 NUMERIC MONEY 28 8 20 P17CredAm Period 17 Credit Amount      
GL52042 NUMERIC MONEY 28 8 20 P18CredAm Period 18 Credit Amount      
GL52043 NCHAR STRING 1 0 1 AddUpLevel Reporting Level      
GL52044 NUMERIC MONEY 28 8 20 P19DebitAm Period 19 Debit Amount      
GL52045 NUMERIC MONEY 28 8 20 P20DebitAm Period 20 Debit Amount      
GL52046 NUMERIC MONEY 28 8 20 P21DebitAm Period 21 Debit Amount      
GL52047 NUMERIC MONEY 28 8 20 P22DebitAm Period 22 Debit Amount      
GL52048 NUMERIC MONEY 28 8 20 P23DebitAm Period 23 Debit Amount      
GL52049 NUMERIC MONEY 28 8 20 P24DebitAm Period 24 Debit Amount      
GL52050 NUMERIC MONEY 28 8 20 P19CredAm Period 19 Credit Amount      
GL52051 NUMERIC MONEY 28 8 20 P20CredAm Period 20 Credit Amount      
GL52052 NUMERIC MONEY 28 8 20 P21CredAm Period 21 Credit Amount      
GL52053 NUMERIC MONEY 28 8 20 P22CredAm Period 22 Credit Amount      
GL52054 NUMERIC MONEY 28 8 20 P23CredAm Period 23 Credit Amount      
GL52055 NUMERIC MONEY 28 8 20 P24CredAm Period 24 Credit Amount      
GL52056 NUMERIC MONEY 28 8 20 ClDebitAm Closing Period Debit Amount      
GL52057 NUMERIC MONEY 28 8 20 ClCredAm Closing Period Credit Amount      

Навигация: