Таблица | Table: SC22 - «Price Calculations Customers». Маска имени таблицы | Table Name Mask: «SC22%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?
SC22001 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
SC22002 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code   2 Да / Yes
SC22003 NVARCHAR VSTRING 3 0 3 Basis0 Calculation Line 0 - Base Value      
SC22004 NVARCHAR VSTRING 12 0 12 Constant0 Calculation Line 0 - Constant      
SC22005 NVARCHAR VSTRING 3 0 3 Basis1 Calculation Line 1 - Base Value      
SC22006 NVARCHAR VSTRING 12 0 12 Constant1 Calculation Line 1 - Constant      
SC22007 NVARCHAR VSTRING 3 0 3 Basis2 Calculation Line 2 - Base Value      
SC22008 NVARCHAR VSTRING 12 0 12 Constant2 Calculation Line 2 - Constant      
SC22009 NVARCHAR VSTRING 3 0 3 Basis3 Calculation Line 3 - Base Value      
SC22010 NVARCHAR VSTRING 12 0 12 Constant3 Calculation Line 3 - Constant      
SC22011 NVARCHAR VSTRING 3 0 3 Basis4 Calculation Line 4 - Base Value      
SC22012 NVARCHAR VSTRING 12 0 12 Constant4 Calculation Line 4 - Constant      
SC22013 NVARCHAR VSTRING 3 0 3 Basis5 Calculation Line 5 - Base Value      
SC22014 NVARCHAR VSTRING 12 0 12 Constant5 Calculation Line 5 - Constant      
SC22015 NVARCHAR VSTRING 3 0 3 Basis6 Calculation Line 6 - Base Value      
SC22016 NVARCHAR VSTRING 12 0 12 Constant6 Calculation Line 6 - Constant      
SC22017 NVARCHAR VSTRING 3 0 3 Basis7 Calculation Line 7 - Base Value      
SC22018 NVARCHAR VSTRING 12 0 12 Constant7 Calculation Line 7 - Constant      
SC22019 NVARCHAR VSTRING 3 0 3 Basis8 Calculation Line 8 - Base Value      
SC22020 NVARCHAR VSTRING 12 0 12 Constant8 Calculation Line 8 - Constant      
SC22021 NVARCHAR VSTRING 3 0 3 Basis9 Calculation Line 9 - Base Value      
SC22022 NVARCHAR VSTRING 12 0 12 Constant9 Calculation Line 9 - Constant      
SC22023 NCHAR STRING 1 0 1 ModelNumber Calculation Model (1-6)      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Price Calculations Customers