Таблица | Table: GLGL - «GL Consolidation». Маска имени таблицы | Table Name Mask: «GLGL%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
GLGL001 NCHAR STRING 36 0 36 JournalID Journal ID   1 Да / Yes
GLGL002 NUMERIC NUMBER 20 0 8 RecCounter Record Counter      
GLGL003 NCHAR STRING 9 0 9 TransNum Transaction Number   2 Да / Yes
GLGL004 NCHAR STRING 7 0 7 LineNum Line Number   3 Да / Yes
GLGL005 DATETIME DATE 0 0 8 TransDate Transaction Date      
GLGL006 NCHAR SWITCH 1 0 1 Flag Primary Line Currency      
GLGL007 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
GLGL008 NUMERIC MONEY 28 8 20 AmountLCU Amount (Local Currency)      
GLGL009 INT INTEGER 0 0 2 CurrCode Currency Code Line      
GLGL010 NVARCHAR ACCSTR 50 0 50 AccStringOCU Accounting String Line Currency      
GLGL011 NUMERIC MONEY 28 8 20 AmountOCU Amount (Line Currency)      
GLGL012 NVARCHAR VSTRING 25 0 25 TransText Transaction Line Text      
GLGL013 NCHAR STRING 10 0 10 Code1 Customer/Supplier Code      
GLGL014 NVARCHAR VSTRING 23 0 23 Code2 Document Number      
GLGL015 NCHAR STRING 6 0 6 Code3 Journal Code      
GLGL016 NCHAR STRING 2 0 2 Code4 General Ledger Period      
GLGL017 NVARCHAR VSTRING 35 0 35 Code5 Foreign Amount (Currency Account)      
GLGL018 NCHAR STRING 8 0 8 Code6 Compound Allocation Switches      
GLGL019 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)
   
GLGL020 NCHAR STRING 1 0 1 Tag2 Project Line Type Only valid of GL07031 and GL07032 has a value:
0 - GL07032 is linked to a project activity line
1 - GL07032 is linked to a activity code
   
GLGL021 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
   
GLGL022 NCHAR STRING 1 0 1 TransLineType 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
   
GLGL023 NCHAR STRING 1 0 1 TransLineSign Transaction Sign 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit)
   
GLGL024 NUMERIC NUMBER 20 0 1 NumOfDecimals Number of Decimals      
GLGL025 NCHAR STRING 5 0 5 LinkCode Link Code      
GLGL026 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
GLGL027 NCHAR STRING 2 0 2 UnitCode Unit Code      
GLGL028 NUMERIC MONEY 28 8 20 AmountCCU Amount (Alternative Currency)      
GLGL029 NCHAR STRING 13 0 13 ContraAcc Contra Account      
GLGL030 NUMERIC NUMBER 20 0 6 JournalNum Journal Number      
GLGL031 NCHAR STRING 9 0 9 PLReference PL Reference      
GLGL032 NCHAR STRING 6 0 6 SubPrjCode Sub-Project Number      
GLGL033 NCHAR STRING 6 0 6 ActivityCode Activity Code      
GLGL034 NCHAR STRING 8 0 8 UsrIDEntBy Entered By      
GLGL035 DATETIME DATE 0 0 8 DateOfEntry Date Entered      
GLGL036 NCHAR STRING 8 0 8 UsrIDUpdBy Updated By      
GLGL037 DATETIME DATE 0 0 8 DateOfUpd Date Updated      
GLGL038 NVARCHAR VSTRING 25 0 25 TransTxtOCU Transaction Text Line Currency      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | GL Consolidation