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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SCT2 — Batch User Authorization

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SCT2001 NCHAR STRING 8 0 8 UserID User ID   1 Да / Yes
SCT2002 NCHAR STRING 8 0 8 ProgramName Program Name   2 Да / Yes
SCT2003 NVARCHAR VSTRING 8 0 8 WHpwd Password Warehouse      
SCT2004 NVARCHAR VSTRING 8 0 8 Binpassword Password Bin      
SCT2005 NVARCHAR VSTRING 8 0 8 BatchIDpwd Password Batch ID      
SCT2006 NVARCHAR VSTRING 8 0 8 Origbatchidpwd Password Batch Number      
SCT2007 NVARCHAR VSTRING 8 0 8 Batchstatuspasswor Password Batch Status      
SCT2008 NVARCHAR VSTRING 8 0 8 Searchfieldpwd Password Search Field      
SCT2009 NVARCHAR VSTRING 8 0 8 Datereceivedpwd Password Date Received      
SCT2010 NVARCHAR VSTRING 8 0 8 Datemanufpwd Password Date Manufactured      
SCT2011 NVARCHAR VSTRING 8 0 8 Datebestbefpwd Password Date Best Before      
SCT2012 NVARCHAR VSTRING 8 0 8 dateshipbypwd Password Date Ship By      
SCT2013 NVARCHAR VSTRING 8 0 8 Userdef1pwd Password User Defined Field 1      
SCT2014 NVARCHAR VSTRING 8 0 8 Userdef2pwd Password User Defined Field 2      
SCT2015 NVARCHAR VSTRING 8 0 8 Userdef3pwd Password User Defined Field 3      
SCT2016 NVARCHAR VSTRING 8 0 8 Userdef4pwd Password User Defined Field 4      
SCT2017 NVARCHAR VSTRING 8 0 8 Userdef5pwd Password User Defined Field 5      
SCT2018 NVARCHAR VSTRING 8 0 8 Userdef6pwd Password User Defined Field 6      
SCT2019 NVARCHAR VSTRING 8 0 8 Userdef7pwd Password User Defined Field 7      
SCT2020 NVARCHAR VSTRING 8 0 8 Userdef8pwd Password User Defined Field 8      
SCT2021 NVARCHAR VSTRING 8 0 8 Userdef9pwd Password User Defined Field 9      
SCT2022 NVARCHAR VSTRING 8 0 8 Userdef10pwd Password User Defined Field 10      
SCT2023 NVARCHAR VSTRING 8 0 8 SuppBatchIDpwd Password Supplier Batch ID      
SCT2024 NVARCHAR VSTRING 8 0 8 ExpireDatePwd Password Expiry Date      
SCT2025 NVARCHAR VSTRING 8 0 8 PotencyFactorPwd Password Potency Factor      

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