Таблица | Table: SCT8 - «Batch Templates». Маска имени таблицы | Table Name Mask: «SCT8%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?
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 Code Warehouse Code Option      
SCT8006 NVARCHAR VSTRING 6 0 6 Value Warehouse      
SCT8007 NCHAR STRING 1 0 1 UsageBin Usage Bin      
SCT8008 NCHAR STRING 2 0 2 Code Bin Code Option      
SCT8009 NVARCHAR VSTRING 6 0 6 Value Bin      
SCT8010 NCHAR STRING 1 0 1 UsageBatchID Usage Batch Number      
SCT8011 NCHAR STRING 2 0 2 Code Batch Number Option      
SCT8012 NVARCHAR VSTRING 24 0 24 Value Batch Number Prefix      
SCT8013 NVARCHAR VSTRING 12 0 12 CounterID Batch Number Counter ID      
SCT8014 NCHAR STRING 1 0 1 UsageOrigBatchID Usage Batch ID      
SCT8015 NCHAR STRING 2 0 2 Code Batch ID Option      
SCT8016 NVARCHAR VSTRING 24 0 24 Value 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 Code Batch Status Option      
SCT8020 NCHAR STRING 1 0 1 Value Batch Status      
SCT8021 NCHAR STRING 1 0 1 UsageSearchField Usage Search Field      
SCT8022 NCHAR STRING 2 0 2 Code Search Field Option      
SCT8023 NCHAR STRING 20 0 20 Value Search Field Value      
SCT8024 NCHAR STRING 1 0 1 UsageDatereceived Usage Date Received      
SCT8025 NCHAR STRING 2 0 2 Code Date Received Option      
SCT8026 NCHAR STRING 5 0 5 Value Date Received Offset      
SCT8027 NCHAR STRING 1 0 1 UsageDateManufact Usage Date Manufactured      
SCT8028 NCHAR STRING 2 0 2 Code Date Manufactured Option      
SCT8029 NCHAR STRING 5 0 5 Value Date Manufactured Offset      
SCT8030 NCHAR STRING 1 0 1 UsageDatebestbefore Usage Best Before Date      
SCT8031 NCHAR STRING 2 0 2 Code Best Before Date Option      
SCT8032 NCHAR STRING 5 0 5 Value Best Before Date Offset      
SCT8033 NCHAR STRING 1 0 1 UsageDateShipBy Usage Ship By Date      
SCT8034 NCHAR STRING 2 0 2 Code Ship By Date Option      
SCT8035 NCHAR STRING 5 0 5 Value Ship By Date Offset      
SCT8036 NCHAR STRING 1 0 1 UsageUserdef1 Usage User Defined Field 1      
SCT8037 NCHAR STRING 2 0 2 Code User Defined Field 1 Option      
SCT8038 NCHAR STRING 20 0 20 Value User Defined Field 1 Value      
SCT8039 NCHAR STRING 1 0 1 UsageUserdef2 Usage User Defined Field 2      
SCT8040 NCHAR STRING 2 0 2 Code User Defined Field 2 Option      
SCT8041 NCHAR STRING 10 0 10 Value User Defined Field 2 Value      
SCT8042 NCHAR STRING 1 0 1 UsageUserdef3 Usage User Defined Field 3      
SCT8043 NCHAR STRING 2 0 2 Code User Defined Field 3 Option      
SCT8044 NCHAR STRING 10 0 10 Value User Defined Field 3 Value      
SCT8045 NCHAR STRING 1 0 1 UsageUserdef4 Usage User Defined Field 4      
SCT8046 NCHAR STRING 2 0 2 Code User Defined Field 4 Option      
SCT8047 NCHAR STRING 8 0 8 Value User Defined Field 4 Value      
SCT8048 NCHAR STRING 1 0 1 UsageUserdef5 Usage User Defined Field 5      
SCT8049 NCHAR STRING 2 0 2 Code User Defined Field 5 Option      
SCT8050 NCHAR STRING 8 0 8 Value User Defined Field 5 Value      
SCT8051 NCHAR STRING 1 0 1 UsageUserdef6 Usage User Defined Field 6      
SCT8052 NCHAR STRING 2 0 2 Code User Defined Field 6 Option      
SCT8053 NCHAR STRING 4 0 4 Value User Defined Field 6 Value      
SCT8054 NCHAR STRING 1 0 1 UsageUserdef7 Usage User Defined Field 7      
SCT8055 NCHAR STRING 2 0 2 Code User Defined Field 7 Option      
SCT8056 NCHAR STRING 4 0 4 Value User Defined Field 7 Value      
SCT8057 NCHAR STRING 1 0 1 UsageUserdef8 Usage User Defined Field 8      
SCT8058 NCHAR STRING 2 0 2 Code User Defined Field 8 Option      
SCT8059 NCHAR STRING 2 0 2 Value User Defined Field 8 Value      
SCT8060 NCHAR STRING 1 0 1 UsageUserdef9 Usage User Defined Field 9      
SCT8061 NCHAR STRING 2 0 2 Code User Defined Field 9 Option      
SCT8062 NCHAR STRING 2 0 2 Value User Defined Field 9 Value      
SCT8063 NCHAR STRING 1 0 1 UsageUserdef10 Usage User Defined Field 10      
SCT8064 NCHAR STRING 2 0 2 Code User Defined Field 10 Option      
SCT8065 NCHAR STRING 1 0 1 Value User Defined Field 10 Value      
SCT8066 NCHAR STRING 1 0 1 UsageSuppBatch Usage Supplier Batch ID      
SCT8067 NCHAR STRING 2 0 2 Code Supplier Batch ID Option      
SCT8068 NCHAR STRING 20 0 20 Value Supplier Batch ID Value      
SCT8069 NCHAR STRING 1 0 1 UsageExpireDate Usage Expiry Date      
SCT8070 NCHAR STRING 2 0 2 Code Expiry Date Option      
SCT8071 NCHAR STRING 5 0 5 Value Expiry Date Offset      
SCT8072 NCHAR STRING 1 0 1 UsagePotencyFactor Usage Potency Factor      
SCT8073 NCHAR STRING 2 0 2 Code Potency Factor Option      
SCT8074 NUMERIC X_NUMERIC 14 8 6 Value Potency Factor      

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