Таблица | Table: SCT6 - «Trace Batch Changes». Маска имени таблицы | Table Name Mask: «SCT6%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?
SCT6001 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code   1 Да / Yes
SCT6002 NCHAR STRING 12 0 12 OrigBatchId Batch Number   2 Да / Yes
SCT6003 NCHAR STRING 12 0 12 BatchID Batch ID   3 Да / Yes
SCT6004 NCHAR STRING 6 0 6 SequenceNo Line Number   4 Да / Yes
SCT6005 NCHAR STRING 2 0 2 FromQCCategory Quality Control Category (Before Change)      
SCT6006 NCHAR STRING 2 0 2 ToQCCategory Quality Control Category (After Change)      
SCT6007 NCHAR STRING 6 0 6 FromWH Warehouse (Before Change)      
SCT6008 NCHAR STRING 6 0 6 ToWH Warehouse (After Change)      
SCT6009 NCHAR STRING 6 0 6 FromBinLocation Bin (Before Change)      
SCT6010 NCHAR STRING 6 0 6 ToBinLocation Bin (After Change)      
SCT6011 DATETIME DATE 0 0 8 Date Date Changed      
SCT6012 NCHAR STRING 9 0 9 Time Time Changed      
SCT6013 NCHAR STRING 8 0 8 UserID Changed By      
SCT6014 INT INTEGER 0 0 1 FromBatchStatus Batch Status (Before Change)      
SCT6015 INT INTEGER 0 0 1 ToBatchStatus Batch Status (After Change)      
SCT6016 DATETIME DATE 0 0 8 FromDateReceived Date Received (Before Change)      
SCT6017 DATETIME DATE 0 0 8 ToDateReceived Date Received (After Change)      
SCT6018 DATETIME DATE 0 0 8 FromDateManufactured Date Manufactured (Before Change)      
SCT6019 DATETIME DATE 0 0 8 ToDateManufactured Date Manufactured (After Change)      
SCT6020 DATETIME DATE 0 0 8 FromDateBestBefore Best Before Date (Before Change)      
SCT6021 DATETIME DATE 0 0 8 ToDateBestBefore Best Before Date (After Change)      
SCT6022 DATETIME DATE 0 0 8 FromDateShipBefore Ship Before Date (Before Change)      
SCT6023 DATETIME DATE 0 0 8 ToDateShipBefore Ship Before Date (After Change)      
SCT6024 DATETIME DATE 0 0 8 FromDateOfExpiry Date of Expiry (Before Change)      
SCT6025 DATETIME DATE 0 0 8 ToDateOfExpiry Date of Expiry (After Change)      
SCT6026 NCHAR STRING 20 0 20 FromSupplierBatchId Supplier Batch ID (Before Change)      
SCT6027 NCHAR STRING 20 0 20 ToSupplierBatchId Supplier Batch ID (After Change)      
SCT6028 NCHAR STRING 20 0 20 FromUserDefined1 User Defined Field 1 (Before Change)      
SCT6029 NCHAR STRING 20 0 20 ToUserDefined1 User Defined Field 1 (After Change)      
SCT6030 NCHAR STRING 10 0 10 FromUserDefined2 User Defined Field 2 (Before Change)      
SCT6031 NCHAR STRING 10 0 10 ToUserDefined2 User Defined Field 2 (After Change)      
SCT6032 NCHAR STRING 10 0 10 FromUserDefined3 User Defined Field 3 (Before Change)      
SCT6033 NCHAR STRING 10 0 10 ToUserDefined3 User Defined Field 3 (After Change)      
SCT6034 NCHAR STRING 8 0 8 FromUserDefined4 User Defined Field 4 (Before Change)      
SCT6035 NCHAR STRING 8 0 8 ToUserDefined4 User Defined Field 4 (After Change)      
SCT6036 NCHAR STRING 8 0 8 FromUserDefined5 User Defined Field 5 (Before Change)      
SCT6037 NCHAR STRING 8 0 8 ToUserDefined5 User Defined Field 5 (After Change)      
SCT6038 NCHAR STRING 4 0 4 FromUserDefined6 User Defined Field 6 (Before Change)      
SCT6039 NCHAR STRING 4 0 4 ToUserDefined6 User Defined Field 6 (After Change)      
SCT6040 NCHAR STRING 4 0 4 FromUserDefined7 User Defined Field 7 (Before Change)      
SCT6041 NCHAR STRING 4 0 4 ToUserDefined7 User Defined Field 7 (After Change)      
SCT6042 NCHAR STRING 2 0 2 FromUserDefined8 User Defined Field 8 (Before Change)      
SCT6043 NCHAR STRING 2 0 2 ToUserDefined8 User Defined Field 8 (After Change)      
SCT6044 NCHAR STRING 2 0 2 FromUserDefined9 User Defined Field 9 (Before Change)      
SCT6045 NCHAR STRING 2 0 2 ToUserDefined9 User Defined Field 9 (After Change)      
SCT6046 NCHAR STRING 1 0 1 FromUserDefined10 User Defined Field 10 (Before Change)      
SCT6047 NCHAR STRING 1 0 1 ToUserDefined10 User Defined Field 10 (After Change)      
SCT6048 NCHAR STRING 20 0 20 FromSearchField Search Field (Before Change)      
SCT6049 NCHAR STRING 20 0 20 ToSearchField Search Field (After Change)      

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