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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица GL07 — Daybook Journal Transactions

Таблица: GL07 — «Daybook Transactions». Маска имени таблицы: «GL07%cc%yy»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GL07001 NUMERIC NUMBER 20 0 9 Reccounter Record Counter      
GL07002 NCHAR STRING 9 0 9 TransactNo Transaction Number   1 Да
GL07003 NCHAR STRING 7 0 7 Linenumber Line Number   2 Да
GL07004 DATETIME DATE 0 0 8 Trandate Transaction Date      
GL07005 NCHAR SWITCH 1 0 1 Flag Primary Line Currency Used for currency/quantity accounting transactions to specify what the primary currency was for the transaction line:
0 — Normal transaction line in local currency, no foreign amount or quantity is specified.
1 — Only foreign amount or quantity is specified, no local amount exist for the transaction line.
2 — Foreign amount or quantity is specified for the transaction line but the local currency amount is the primary amount.
3 — Foreign amount is specified and was the primary amount when the transaction line was entered.
(Foreign amounts and quantity is booked on statistical accounts and column GL07009 and GL07010 is used for specifying the accounting string and amount)		    
GL07006 NVARCHAR ACCSTR 50 0 50 Accstring Accounting String      
GL07007 NUMERIC MONEY 28 8 20 Amountlcu Amount (Local Currency)      
GL07008 INT INTEGER 0 0 2 Currcode Currency Code Line      
GL07009 NVARCHAR ACCSTR 50 0 50 Accstringocu Accounting String Line Currency      
GL07010 NUMERIC MONEY 28 8 20 Amountocu Amount (Line Currency)      
GL07011 NVARCHAR VSTRING 36 0 36 Trantext Transaction Line Text      
GL07012 NCHAR STRING 10 0 10 Code1 Customer/Supplier Code      
GL07013 NVARCHAR VSTRING 25 0 25 Code2 Document Number      
GL07014 NCHAR STRING 6 0 6 Code3 Journal Code      
GL07015 NCHAR STRING 2 0 2 Code4 General Ledger Period      
GL07016 NVARCHAR VSTRING 35 0 35 Code5 Foreign Amount (Currency Account)      
GL07017 NCHAR STRING 8 0 8 Code6 Compound Allocation Switches      
GL07018 NCHAR STRING 1 0 1 Tag1 Period Allocation 0 — Period allocation has not been executed for the transaction line
1 — Period allocation has been executed for the transaction line
2 — (used with analytical ledger)
3 — (used with analytical ledger)		    
GL07019 NCHAR STRING 1 0 1 Tag2 Project Line Type Only valid if GL07031 and GL07032 has a value:
0 — GL07032 is linked to a project activity line
1 — GL07032 is linked to a activity code		    
GL07020 NCHAR STRING 1 0 1 Tag3 Transaction Flag 0 — Standard value
1 — Transaction line is a currency revaluation transaction line
2 — Transaction line is in closing period		    
GL07021 NCHAR STRING 1 0 1 Tranlinetype Line Type 0 — Manual Transaction in General Ledger
1 — Reversal Transaction in General Ledger
2 — Accrued Transaction (Periodic Allocation)
3 — Customer Invoice (From Sales Ledger)
4 — Customer Payment (From Sales Ledger)
5 — Supplier Invoice (From Purchase Ledger)
6 — Supplier Payment (From Purchase Ledger)
7 — Depreciation Transaction (From Asset Management)
8 — Automatic Period Allocation
9 — Transaction from Project Management
A — Transaction from Payroll
B — Transaction from Stock Journal
C — Transaction from Promissory Notes
D — Petty Cash Transaction
K — Fixed Assets Revaluation Transaction
L — Cash-Books Transaction
M — Transaction from MPC WIP Journal
S — Transaction from Source Company (Consolidation)
T — Temporary Cheque Transactions (Day-Book Journal)
i — Closing Period Transaction
k — Year End Closing Transaction
| — Transferred Open Balances of Currency Accounts		    
GL07022 NCHAR STRING 1 0 1 Tranlinesign Transaction Sign 0 — Normal Sign (+ debit, — credit)
1 — Reversed Sign (+ credit, — debit)		    
GL07023 NUMERIC NUMBER 20 0 1 Noofdecimals Number of Decimals      
GL07024 NCHAR STRING 5 0 5 Linkcode Link Code      
GL07025 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
GL07026 INT INTEGER 0 0 4 Unitcode Unit Code      
GL07027 NUMERIC MONEY 28 8 20 Amountccu Amount (Alternative Currency)      
GL07028 NCHAR STRING 13 0 13 Contraacc Contra Account      
GL07029 NUMERIC NUMBER 20 0 6 Journalno Journal Number      
GL07030 NCHAR STRING 9 0 9 Plreference PL Reference      
GL07031 NCHAR STRING 6 0 6 Subprjcode Sub-Project Number      
GL07032 NCHAR STRING 6 0 6 Activitycode Activity Code      
GL07033 NCHAR STRING 8 0 8 Usridupdby UserID for Update      
GL07034 DATETIME DATE 0 0 8 Dateofentry Date Entered      
GL07035 NCHAR STRING 8 0 8 Usridentby UserID for Entry      
GL07036 DATETIME DATE 0 0 8 Dateofupd Date Updated      
GL07037 NVARCHAR VSTRING 36 0 36 Trantxtocu Transaction Text Line Currency      
GL07038 NCHAR STRING 2 0 2 SourceCompany Source Company      
GL07039 NCHAR STRING 2 0 2 SourceModule Source Module      
GL07040 NCHAR STRING 8 0 8 Usridprnby Printed By      
GL07041 DATETIME DATE 0 0 8 Dateofprn Date Printed      
GL07042 NCHAR SWITCH 1 0 1 PrnStatus PrintedStatus      
GL07043 NVARCHAR VSTRING 25 0 25 AASCode AAS code      
GL07044 NVARCHAR VSTRING 6 0 6 TaxCode TaxCode      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
GL07001 20 8 20 8 20 8 20 9 20 9 20 9 20 9
GL07002 6 6 6 6 6 6 9 9 9 9 9 9 9 9
GL07003 5 5 5 5 5 5 7 7 7 7 7 7 7 7
GL07011 25 25 25 25 25 25 25 25 25 25 36 36 36 36
GL07013 23 23 23 23 23 23 23 23 23 23 25 25 25 25
GL07026 2 2 2 2 0 4 0 4 0 4 0 4 0 4
GL07030 6 6 6 6 6 6 6 6 9 9 9 9 9 9
GL07037 25 25 25 25 25 25 25 25 25 25 36 36 36 36
GL07038 — — 2 2 2 2 2 2 2 2 2 2 2 2
GL07039 — — 2 2 2 2 2 2 2 2 2 2 2 2
GL07040 — — 8 8 8 8 8 8 8 8 8 8 8 8
GL07041 — — 0 8 0 8 0 8 0 8 0 8 0 8
GL07042 — — — — — — 1 1 1 1 1 1 1 1
GL07043 — — — — — — 25 25 25 25 25 25 25 25
GL07044 — — — — — — — — — — 6 6 6 6

Навигация: