пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Прямая выписка счетов»/List of tables of module «Direct Invoicing»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table DI01 — Stock Items

Таблица / Table: DI01 — «Stock Item File». Маска имени таблицы / Table name mask: «DI01%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
DI01001 NCHAR STRING 35 0 35 StockCode Stock Item Code   1 Да / Yes
DI01002 NVARCHAR VSTRING 25 0 25 DescrLang0 Description      
DI01003 NVARCHAR VSTRING 4 0 4 StockCateg Category      
DI01004 NUMERIC MONEY 28 8 20 Pricelist0 Unit Price      
DI01005 NUMERIC MONEY 28 8 20 CalcCostLCU Calculate Unit Cost      
DI01006 NUMERIC X_NUMERIC 20 8 12 BudgetQty Budgeted Quantity      
DI01007 NUMERIC X_NUMERIC 20 8 12 BudgetVolume Budgeted Turnover      
DI01008 NUMERIC X_NUMERIC 20 8 12 QtySoldPeriod Quantity Sold Current Period      
DI01009 NUMERIC X_NUMERIC 20 8 12 QtySoldYTD Quantity Sold Current Year      
DI01010 NUMERIC X_NUMERIC 20 8 12 QtySoldPyear Quantity Sold Previous Year      
DI01011 NUMERIC X_NUMERIC 20 8 12 VolumePeriod Turnover Current Period      
DI01012 NUMERIC X_NUMERIC 20 8 12 VolumeYTD Turnover Current Year      
DI01013 NUMERIC X_NUMERIC 20 8 12 VolumePyear Turnover Previous Year      
DI01014 NUMERIC MONEY 28 8 20 ProfitPeriod Profit Current Period      
DI01015 NUMERIC MONEY 28 8 20 ProfitYTD Profit Current Year      
DI01016 NUMERIC MONEY 28 8 20 ProfitPyear Profit Previous Year      
DI01017 NCHAR STRING 2 0 2 AccCode Accounting Code      
DI01018 NVARCHAR VSTRING 6 0 6 VATCode VAT Code This field should contain the Tax Code for stock item    
DI01019 INT INTEGER 0 0 1 ExtraTaxCode Extra Tax Code      
DI01020 NVARCHAR VSTRING 1 0 1 FrequencyC Frequency Code      
DI01021 NVARCHAR VSTRING 1 0 1 ABCCode ABC Code      
DI01022 NVARCHAR VSTRING 1 0 1 InterActFlag Update Frequency Code Indicates if frequency code shall be shifted up or down:

0 — The stock item has NOT been sold since last time frequency analysis was executed.

1 — The stock item has been sold since last time frequency analysis was executed.
   
DI01023 DATETIME DATE 0 0 8 LatestDelivD Last Delivery Date to Customer      
DI01024 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
DI01025 NUMERIC X_NUMERIC 20 8 12 VolNextPeriod Turnover Next Period      
DI01026 NUMERIC X_NUMERIC 20 8 12 VolNextYTD Turnover Next Year      
DI01027 NUMERIC MONEY 28 8 20 ProfNextPer Profit Next Period      
DI01028 NUMERIC MONEY 28 8 20 ProfNextYTD Profit Next Year      
DI01029 NUMERIC X_NUMERIC 20 8 12 QtySoldNPer Quantity Sold Next Period      
DI01030 NUMERIC X_NUMERIC 20 8 12 QtySoldNYTD Quantity Sold Next Year      

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