Таблица | Table: GL26 - «Cash Flow Planning 1». Маска имени таблицы | Table Name Mask: «GL26%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?
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)      

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