пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GL06001 NVARCHAR ACCSTR 50 0 50 AccStrLCU Accounting String      
GL06002 NCHAR STRING 9 0 9 TransactionNo Transaction Number      
GL06003 DATETIME DATE 0 0 8 TransactionDate Transaction Date      
GL06004 NUMERIC MONEY 28 8 20 AmountLCU Amount (Local Currency)      
GL06005 NVARCHAR VSTRING 36 0 36 TransactTxt Transaction Text      
GL06006 NVARCHAR VSTRING 10 0 10 CustCode Customer/Supplier Code Information depends on GL06012:
3 or 4 - Customer Code
5 or 6 - Supplier Code
   
GL06007 NVARCHAR VSTRING 25 0 25 CodeString Document Number Information depends on GL06012:
3 or 4 - Customer Invoice Number
5 or 6 - Supplier Invoice Number
Other - Document Number
   
GL06008 NVARCHAR VSTRING 6 0 6 JournalCode Journal Code      
GL06009 NCHAR STRING 1 0 1 PeriodAlloc 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)
   
GL06010 NCHAR STRING 1 0 1 ProjectUpd Project Updated 0 - Project Management has not been updated with the transaction line (GL06028 holds a project activity line)
1 - Project Management has been updated with the transaction line (GL06028 holds a project activity line)
2 - Project Management has not been updated with the transaction line (GL06028 holds an activity code)
3 - Project Management has been updated with the transaction line (GL06028 holds an activity code)
   
GL06011 NCHAR STRING 1 0 1 CurrTrans Currency Transaction 0 - Standard value
1 - Transaction line is a currency revaluation transaction line
2 - Transaction line is in closing period
   
GL06012 BINARY BINSTRING 1 0 1 TransType Transaction Type / - Opening Balances
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 Cheques Transactions (Day-Book Journal)
U - Budget Alternative 1
V - Budget Alternative 2
W - Budget Alternative 3
X - Budget Alternative 4
Y - Budget Alternative 5
Z - Budget Previous Year
\ - Reporting Level Transaction Opening balances
a - Reporting Level Transaction
c - Reporting Level Transaction Budget Alternative 1
d - Reporting Level Transaction Budget Alternative 2
e - Reporting Level Transaction Budget Alternative 3
f - Reporting Level Transaction Budget Alternative 4
g - Reporting Level Transaction Budget Alternative 5
h - Reporting Level Transaction Budget Previous Year
i - Closing Period Transaction
j - Reporting Level Closing Period Transaction
k - Year End Closing Transaction
| - Transferred Open Balances of Currency Accounts
   
GL06013 NVARCHAR VSTRING 8 0 8 UserIDUpdatedBy User Id for Update      
GL06014 DATETIME DATE 0 0 8 EntryDate Date Entered      
GL06015 NCHAR STRING 13 0 13 ContraAccount Contra Account      
GL06016 NCHAR STRING 9 0 9 RunningCount Index Key   1 Да
GL06017 NCHAR STRING 1 0 1 TransactSign Transaction Sign 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit)
   
GL06018 NUMERIC MONEY 28 8 20 AmountOCU Amount (Document Currency)      
GL06019 NCHAR STRING 2 0 2 CurrencyCode Currency Code      
GL06020 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
GL06021 INT INTEGER 0 0 4 UnitCode Unit Code      
GL06022 NUMERIC MONEY 28 8 20 AmountCCU Amount (Alternative Currency)      
GL06023 NVARCHAR VSTRING 9 0 9 JournalNumber Journal Number      
GL06024 NCHAR STRING 9 0 9 PLReference Purchase Invoice Reference Number      
GL06025 NCHAR STRING 8 0 8 EntByUser Name of Entry User      
GL06026 DATETIME DATE 0 0 8 DateOfUpdate Date Updated      
GL06027 NCHAR STRING 6 0 6 SubProjectCode Sub-project Code      
GL06028 NCHAR STRING 6 0 6 ActivityCode Activity Code      
GL06029 NCHAR STRING 9 0 9 LegalTransNo Legal Transaction Number      
GL06030 NCHAR STRING 8 0 8 ConsolidFlags Compound Allocation Flags A string of 8 characters where each character is a flag between 0 and 3 and it's used to select if the transaction line shall be selected when running the compound allocation.    
GL06031 NCHAR STRING 9 0 9 LinkdRecCnt Linked Transaction Line (EMU Conversion)      
GL06032 NVARCHAR VSTRING 12 0 12 ConsSourceAccount Consolidation Source Account      
GL06033 NUMERIC MONEY 28 8 20 ConsSourceAmount Consolidation Source Amount      
GL06034 NCHAR STRING 3 0 3 ConsSourceCurrName Consolidation Source Currency Name      
GL06035 NVARCHAR VSTRING 15 0 15 GLDrillDownInformation General Ledger Drill Down Information Link to journal transaction number in stock control (SCGL)    
GL06036 INT INTEGER 0 0 1 GLExportFlag GL Export Flag      
GL06037 NCHAR STRING 2 0 2 SourceCompany Source Company      
GL06038 NCHAR STRING 2 0 2 SourceModule Source Module      
GL06039 NCHAR STRING 8 0 8 UserIDPrintedBy Printed By      
GL06040 DATETIME DATE 0 0 8 DateOfPrint Date Printed      
GL06041 NVARCHAR VSTRING 6 0 6 TaxCode TaxCode      
GL06042 DATETIME X_DATETIME 0 0 17 PostingDateTime Posting Date/Time      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | General Ledger Transactions

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.