Таблица | Table: GL26 - «Cash Flow Planning 1». Маска имени таблицы | Table Name Mask: «GL26%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | 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