One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table GL42 — Cash-Book Reconciliation Accounts

Таблица / Table: GL42 — «Reconciliation Accounts File». Маска имени таблицы / Table name mask: «GL42%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GL42001 NCHAR STRING 2 0 2 IndexKey Index Key   1 Да / Yes
GL42002 NVARCHAR VSTRING 12 0 12 ReconAcc00 Reconciliation Account 1      
GL42003 NVARCHAR VSTRING 12 0 12 ReconAcc10 Linked Cash-Book Code 1      
GL42004 NVARCHAR VSTRING 12 0 12 ReconAcc01 Reconciliation Account 2      
GL42005 NVARCHAR VSTRING 12 0 12 ReconAcc11 Linked Cash-Book Code 2      
GL42006 NVARCHAR VSTRING 12 0 12 ReconAcc02 Reconciliation Account 3      
GL42007 NVARCHAR VSTRING 12 0 12 ReconAcc12 Linked Cash-Book Code 3      
GL42008 NVARCHAR VSTRING 12 0 12 ReconAcc03 Reconciliation Account 4      
GL42009 NVARCHAR VSTRING 12 0 12 ReconAcc13 Linked Cash-Book Code 4      
GL42010 NVARCHAR VSTRING 12 0 12 ReconAcc04 Reconciliation Account 5      
GL42011 NVARCHAR VSTRING 12 0 12 ReconAcc14 Linked Cash-Book Code 5      
GL42012 NVARCHAR VSTRING 12 0 12 ReconAcc05 Reconciliation Account 6      
GL42013 NVARCHAR VSTRING 12 0 12 ReconAcc15 Linked Cash-Book Code 6      
GL42014 NVARCHAR VSTRING 12 0 12 ReconAcc06 Reconciliation Account 7      
GL42015 NVARCHAR VSTRING 12 0 12 ReconAcc16 Linked Cash-Book Code 7      
GL42016 NVARCHAR VSTRING 12 0 12 ReconAcc07 Reconciliation Account 8      
GL42017 NVARCHAR VSTRING 12 0 12 ReconAcc17 Linked Cash-Book Code 8      
GL42018 NVARCHAR VSTRING 12 0 12 ReconAcc08 Reconciliation Account 9      
GL42019 NVARCHAR VSTRING 12 0 12 ReconAcc18 Linked Cash-Book Code 9      
GL42020 NVARCHAR VSTRING 12 0 12 ReconAcc09 Reconciliation Account 10      
GL42021 NVARCHAR VSTRING 12 0 12 ReconAcc19 Linked Cash-Book Code 10      
GL42022 NVARCHAR VSTRING 12 0 12 ReconAcc010 Reconciliation Account 11      
GL42023 NVARCHAR VSTRING 12 0 12 ReconAcc110 Linked Cash-Book Code 11      
GL42024 NVARCHAR VSTRING 12 0 12 ReconAcc011 Reconciliation Account 12      
GL42025 NVARCHAR VSTRING 12 0 12 ReconAcc111 Linked Cash-Book Code 12      
GL42026 NVARCHAR VSTRING 12 0 12 ReconAcc012 Reconciliation Account 13      
GL42027 NVARCHAR VSTRING 12 0 12 ReconAcc112 Linked Cash-Book Code 13      
GL42028 NVARCHAR VSTRING 12 0 12 ReconAcc013 Reconciliation Account 14      
GL42029 NVARCHAR VSTRING 12 0 12 ReconAcc113 Linked Cash-Book Code 14      
GL42030 NVARCHAR VSTRING 12 0 12 ReconAcc014 Reconciliation Account 15      
GL42031 NVARCHAR VSTRING 12 0 12 ReconAcc114 Linked Cash-Book Code 15      
GL42032 NVARCHAR VSTRING 12 0 12 ReconAcc015 Reconciliation Account 16      
GL42033 NVARCHAR VSTRING 12 0 12 ReconAcc115 Linked Cash-Book Code 16      
GL42034 NVARCHAR VSTRING 12 0 12 ReconAcc016 Reconciliation Account 17      
GL42035 NVARCHAR VSTRING 12 0 12 ReconAcc116 Linked Cash-Book Code 17      
GL42036 NVARCHAR VSTRING 12 0 12 ReconAcc017 Reconciliation Account 18      
GL42037 NVARCHAR VSTRING 12 0 12 ReconAcc117 Linked Cash-Book Code 18      
GL42038 NVARCHAR VSTRING 12 0 12 ReconAcc018 Reconciliation Account 19      
GL42039 NVARCHAR VSTRING 12 0 12 ReconAcc118 Linked Cash-Book Code 19      
GL42040 NVARCHAR VSTRING 12 0 12 ReconAcc019 Reconciliation Account 20      
GL42041 NVARCHAR VSTRING 12 0 12 ReconAcc119 Linked Cash-Book Code 20      
GL42042 NVARCHAR VSTRING 12 0 12 ReconAcc020 Reconciliation Account 21      
GL42043 NVARCHAR VSTRING 12 0 12 ReconAcc120 Linked Cash-Book Code 21      
GL42044 NVARCHAR VSTRING 12 0 12 ReconAcc021 Reconciliation Account 22      
GL42045 NVARCHAR VSTRING 12 0 12 ReconAcc121 Linked Cash-Book Code 22      
GL42046 NVARCHAR VSTRING 12 0 12 ReconAcc022 Reconciliation Account 23      
GL42047 NVARCHAR VSTRING 12 0 12 ReconAcc122 Linked Cash-Book Code 23      
GL42048 NVARCHAR VSTRING 12 0 12 ReconAcc023 Reconciliation Account 24      
GL42049 NVARCHAR VSTRING 12 0 12 ReconAcc123 Linked Cash-Book Code 24      
GL42050 NVARCHAR VSTRING 12 0 12 ReconAcc024 Reconciliation Account 25      
GL42051 NVARCHAR VSTRING 12 0 12 ReconAcc124 Linked Cash-Book Code 25      
GL42052 NVARCHAR VSTRING 12 0 12 ReconAcc025 Reconciliation Account 26      
GL42053 NVARCHAR VSTRING 12 0 12 ReconAcc125 Linked Cash-Book Code 26      
GL42054 NVARCHAR VSTRING 12 0 12 ReconAcc026 Reconciliation Account 27      
GL42055 NVARCHAR VSTRING 12 0 12 ReconAcc126 Linked Cash-Book Code 27      
GL42056 NVARCHAR VSTRING 12 0 12 ReconAcc027 Reconciliation Account 28      
GL42057 NVARCHAR VSTRING 12 0 12 ReconAcc127 Linked Cash-Book Code 28      
GL42058 NVARCHAR VSTRING 12 0 12 ReconAcc028 Reconciliation Account 29      
GL42059 NVARCHAR VSTRING 12 0 12 ReconAcc128 Linked Cash-Book Code 29      
GL42060 NVARCHAR VSTRING 12 0 12 ReconAcc029 Reconciliation Account 30      
GL42061 NVARCHAR VSTRING 12 0 12 ReconAcc129 Linked Cash-Book Code 30      
GL42062 NVARCHAR VSTRING 12 0 12 ReconAcc030 Reconciliation Account 31      
GL42063 NVARCHAR VSTRING 12 0 12 ReconAcc130 Linked Cash-Book Code 31      
GL42064 NVARCHAR VSTRING 12 0 12 ReconAcc031 Reconciliation Account 32      
GL42065 NVARCHAR VSTRING 12 0 12 ReconAcc131 Linked Cash-Book Code 32      
GL42066 NVARCHAR VSTRING 12 0 12 ReconAcc032 Reconciliation Account 33      
GL42067 NVARCHAR VSTRING 12 0 12 ReconAcc132 Linked Cash-Book Code 33      
GL42068 NVARCHAR VSTRING 12 0 12 ReconAcc033 Reconciliation Account 34      
GL42069 NVARCHAR VSTRING 12 0 12 ReconAcc133 Linked Cash-Book Code 34      

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