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 GL26 — Cash Flow Planned Transaction Setup

Таблица / Table: GL26 — «Cash Flow Planning 1». Маска имени таблицы / Table name mask: «GL26%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GL26001 DATETIME DATE 0 0 8 PlanTranDate Planned Transaction Date   1 Да / Yes
GL26002 NVARCHAR VSTRING 2 0 2 TransacType Transaction Type 00 — General Ledger Planning Rule

01 — Sales Ledger Transaction

02 — Purchase Ledger Transaction

03 — Sales Order Transaction

04 — Purchase Order Transaction

05 — Project Transaction

06 — Contract Transaction

07 — Service Order Transaction
2 Да / Yes
GL26003 NVARCHAR VSTRING 4 0 4 ReferenceNo Reference Number   3 Да / Yes
GL26004 NVARCHAR VSTRING 2 0 2 InfoType Information Type 0 — Cumulative Balance

1 — Period Balance

2 — Cumulative Budget (1)

3 — Period Budget (1)

4 — Cumulative Budget (2)

5 — Period Budget (2)

6 — Cumulative Budget (3)

7 — Period Budget (3)

8 — Cumulative Budget (4)

9 — Period Budget (4)

10 — Cumulative Budget (5)

11 — Period Budget (5)

12 — Cumulative Previous Year

13 — Period Previous Year

14 — Constant
   
GL26005 NUMERIC MONEY 28 8 20 TransAmount Transaction Amount (Local Currency)      
GL26006 NVARCHAR VSTRING 10 0 10 Constant Constant (Local Currency)      
GL26007 NVARCHAR VSTRING 2 0 2 BaseMinPer Base Minimum Period      
GL26008 NVARCHAR VSTRING 2 0 2 BaseMaxPer Base Maximum Period      
GL26009 NVARCHAR VSTRING 12 0 12 MinAccount Minimum Account      
GL26010 NVARCHAR VSTRING 12 0 12 MaxAccount Maximum Account      
GL26011 DATETIME DATE 0 0 8 ValidFrom Valid From Date      
GL26012 DATETIME DATE 0 0 8 ValidTo Valid To Date      
GL26013 NVARCHAR VSTRING 2 0 2 Category Category      
GL26014 NVARCHAR VSTRING 25 0 25 Remark Remark      
GL26015 NUMERIC MONEY 28 8 20 TransAmCur Transaction Amount (Original Currency)      

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