One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Stock Control»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SCT8 — Batch Templates

Таблица / Table: SCT8 — «Batch Templates». Маска имени таблицы / Table name mask: «SCT8%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SCT8001 NCHAR STRING 2 0 2 Templatetype Template Type 0 — Template for Stock Item

1 — Template for Product Group

2 — Template for Alternative Product Group

3 — Template for Extended Product Group

4 — Template for Stock Item Status

5 — Template for Supplier

6 — Default Template
1 Да / Yes
SCT8002 NCHAR STRING 35 0 35 TemplateID Batch Template ID   2 Да / Yes
SCT8003 NVARCHAR VSTRING 20 0 20 Description Description      
SCT8004 NCHAR STRING 1 0 1 UsageWH Usage Warehouse      
SCT8005 NCHAR STRING 2 0 2 WHOpt Warehouse Code Option      
SCT8006 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
SCT8007 NCHAR STRING 1 0 1 UsageBin Usage Bin      
SCT8008 NCHAR STRING 2 0 2 BinOpt Bin Code Option      
SCT8009 NVARCHAR VSTRING 6 0 6 Bin Bin      
SCT8010 NCHAR STRING 1 0 1 UsageBatchID Usage Batch Number      
SCT8011 NCHAR STRING 2 0 2 BatchNoOpt Batch Number Option      
SCT8012 NVARCHAR VSTRING 24 0 24 BatchNoPrefix Batch Number Prefix      
SCT8013 NVARCHAR VSTRING 12 0 12 BatchNoCounter Batch Number Counter ID      
SCT8014 NCHAR STRING 1 0 1 UsageOrigBatchID Usage Batch ID      
SCT8015 NCHAR STRING 2 0 2 BatchIDOpt Batch ID Option      
SCT8016 NVARCHAR VSTRING 24 0 24 BatchIDPrefix Batch ID Prefix      
SCT8017 NVARCHAR VSTRING 12 0 12 CounterID Batch ID Counter ID      
SCT8018 NCHAR STRING 1 0 1 UsageBatchStatus Usage Batch Status      
SCT8019 NCHAR STRING 2 0 2 BatchStatOpt Batch Status Option      
SCT8020 NCHAR STRING 1 0 1 BatchStatus Batch Status      
SCT8021 NCHAR STRING 1 0 1 UsageSearchField Usage Search Field      
SCT8022 NCHAR STRING 2 0 2 SearchFldOpt Search Field Option      
SCT8023 NCHAR STRING 20 0 20 SearchFldValue Search Field Value      
SCT8024 NCHAR STRING 1 0 1 UsageDatereceived Usage Date Received      
SCT8025 NCHAR STRING 2 0 2 DateReceivedOpt Date Received Option      
SCT8026 NCHAR STRING 5 0 5 DateReceivedOffset Date Received Offset      
SCT8027 NCHAR STRING 1 0 1 UsageDateManufact Usage Date Manufactured      
SCT8028 NCHAR STRING 2 0 2 DateManufOpt Date Manufactured Option      
SCT8029 NCHAR STRING 5 0 5 DateManufOffset Date Manufactured Offset      
SCT8030 NCHAR STRING 1 0 1 UsageDatebestbefore Usage Best Before Date      
SCT8031 NCHAR STRING 2 0 2 BestBeforeDateOpt Best Before Date Option      
SCT8032 NCHAR STRING 5 0 5 BestBeforeDateOffset Best Before Date Offset      
SCT8033 NCHAR STRING 1 0 1 UsageDateShipBy Usage Ship By Date      
SCT8034 NCHAR STRING 2 0 2 ShipByDateOpt Ship By Date Option      
SCT8035 NCHAR STRING 5 0 5 ShipByDateOffset Ship By Date Offset      
SCT8036 NCHAR STRING 1 0 1 UsageUserdef1 Usage User Defined Field 1      
SCT8037 NCHAR STRING 2 0 2 UserDefFld1Opt User Defined Field 1 Option      
SCT8038 NCHAR STRING 20 0 20 UserDefFld1 User Defined Field 1 Value      
SCT8039 NCHAR STRING 1 0 1 UsageUserdef2 Usage User Defined Field 2      
SCT8040 NCHAR STRING 2 0 2 UserDefFld2Opt User Defined Field 2 Option      
SCT8041 NCHAR STRING 10 0 10 UserDefFld2 User Defined Field 2 Value      
SCT8042 NCHAR STRING 1 0 1 UsageUserdef3 Usage User Defined Field 3      
SCT8043 NCHAR STRING 2 0 2 UserDefFld3Opt User Defined Field 3 Option      
SCT8044 NCHAR STRING 10 0 10 UserDefFld3 User Defined Field 3 Value      
SCT8045 NCHAR STRING 1 0 1 UsageUserdef4 Usage User Defined Field 4      
SCT8046 NCHAR STRING 2 0 2 UserDefFld4Opt User Defined Field 4 Option      
SCT8047 NCHAR STRING 8 0 8 UserDefFld4 User Defined Field 4 Value      
SCT8048 NCHAR STRING 1 0 1 UsageUserdef5 Usage User Defined Field 5      
SCT8049 NCHAR STRING 2 0 2 UserDefFld5Opt User Defined Field 5 Option      
SCT8050 NCHAR STRING 8 0 8 UserDefFld5 User Defined Field 5 Value      
SCT8051 NCHAR STRING 1 0 1 UsageUserdef6 Usage User Defined Field 6      
SCT8052 NCHAR STRING 2 0 2 UserDefFld6Opt User Defined Field 6 Option      
SCT8053 NCHAR STRING 4 0 4 UserDefFld6 User Defined Field 6 Value      
SCT8054 NCHAR STRING 1 0 1 UsageUserdef7 Usage User Defined Field 7      
SCT8055 NCHAR STRING 2 0 2 UserDefFld7Opt User Defined Field 7 Option      
SCT8056 NCHAR STRING 4 0 4 UserDefFld7 User Defined Field 7 Value      
SCT8057 NCHAR STRING 1 0 1 UsageUserdef8 Usage User Defined Field 8      
SCT8058 NCHAR STRING 2 0 2 UserDefFld8Opt User Defined Field 8 Option      
SCT8059 NCHAR STRING 2 0 2 UserDefFld8 User Defined Field 8 Value      
SCT8060 NCHAR STRING 1 0 1 UsageUserdef9 Usage User Defined Field 9      
SCT8061 NCHAR STRING 2 0 2 UserDefFld9Opt User Defined Field 9 Option      
SCT8062 NCHAR STRING 2 0 2 UserDefFld9 User Defined Field 9 Value      
SCT8063 NCHAR STRING 1 0 1 UsageUserdef10 Usage User Defined Field 10      
SCT8064 NCHAR STRING 2 0 2 UserDefFld10Opt User Defined Field 10 Option      
SCT8065 NCHAR STRING 1 0 1 UserDefFld10 User Defined Field 10 Value      
SCT8066 NCHAR STRING 1 0 1 UsageSuppBatch Usage Supplier Batch ID      
SCT8067 NCHAR STRING 2 0 2 SuppBatchIDOpt Supplier Batch ID Option      
SCT8068 NCHAR STRING 20 0 20 SuppBatchID Supplier Batch ID Value      
SCT8069 NCHAR STRING 1 0 1 UsageExpireDate Usage Expiry Date      
SCT8070 NCHAR STRING 2 0 2 ExpiryDateOpt Expiry Date Option      
SCT8071 NCHAR STRING 5 0 5 ExpiryDateOffset Expiry Date Offset      
SCT8072 NCHAR STRING 1 0 1 UsagePotencyFactor Usage Potency Factor      
SCT8073 NCHAR STRING 2 0 2 PotencyFctOpt Potency Factor Option      
SCT8074 NUMERIC X_NUMERIC 14 8 6 PotencyFactor Potency Factor      

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