пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «General Ledger»

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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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      

История изменения структуры таблицы / 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
GL06002 6 6 6 6 6 6 9 9 9 9 9 9 9 9
GL06005 25 25 25 25 25 25 25 25 25 25 36 36 36 36
GL06007 23 23 23 23 23 23 23 23 23 23 25 25 25 25
GL06016 8 8 8 8 8 8 9 9 9 9 9 9 9 9
GL06021 2 2 2 2 0 4 0 4 0 4 0 4 0 4
GL06023 6 6 6 6 6 6 9 9 9 9 9 9 9 9
GL06024 6 6 6 6 6 6 6 6 9 9 9 9 9 9
GL06029 6 6 6 6 6 6 9 9 9 9 9 9 9 9
GL06031 8 8 8 8 8 8 9 9 9 9 9 9 9 9
GL06036 0 1 0 1 0 1 0 1 0 1 0 1
GL06037 2 2 2 2 2 2 2 2 2 2 2 2
GL06038 2 2 2 2 2 2 2 2 2 2 2 2
GL06039 8 8 8 8 8 8 8 8 8 8 8 8
GL06040 0 8 0 8 0 8 0 8 0 8 0 8
GL06041 6 6 6 6
GL06042 0 17 0 17

Навигация: