Таблица | Table: SCT2 - «Batch User Authorization». Маска имени таблицы | Table Name Mask: «SCT2%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?
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 ExpireDate_Pwd Password Expiry Date      
SCT2025 NVARCHAR VSTRING 8 0 8 PotencyFactor_Pwd Password Potency Factor      

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