Таблица: SCT8 - «Batch Templates». Маска имени таблицы: «SCT8%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
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 | Да |
SCT8002 | NCHAR | STRING | 35 | 0 | 35 | TemplateID | Batch Template ID | 2 | Да | |
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 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Stock Control | Batch Templates