One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table GL06 — General Ledger Transactions

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GL06001 NVARCHAR ACCSTR 120 0 120 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 Да / Yes
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      

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