Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
На один уровень вверх / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Stock Control»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SCB4 — Stock Control BOM Branch

Таблица: SCB4 — «SC BOM Branch». Маска имени таблицы: «SCB4%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SCB4001 NCHAR STRING 38 0 38 ParentNodeID Parent Node ID   1 Да
SCB4002 INT INTEGER 0 0 9 BranchNumber Branch Number   2 Да
SCB4003 INT INTEGER 0 0 1 Optional Optional      
SCB4004 INT INTEGER 0 0 1 SwitchedOff Switched Off      
SCB4005 NUMERIC X_NUMERIC 28 8 20 ChildQuantity Child Quantity      
SCB4006 INT INTEGER 0 0 1 IndependentChildQty Independent Child Quantity      
SCB4007 INT INTEGER 0 0 1 ChangeableNode Changeable Child Node      
SCB4008 NCHAR STRING 2 0 2 PriceList Price List      
SCB4009 INT INTEGER 0 0 1 CalculatePrice Calculate Price      
SCB4010 INT INTEGER 0 0 1 PrintableinDocuments Printable on Documents      
SCB4011 INT INTEGER 0 0 1 StructureType Structure Type 0 — Dependent, May only be delivered as a whole and in the quantity delivered. Partial delivery is not allowed.
1 — Independent, May only be delivered as a whole and in the quantity delivered. Partial delivery is allowed. Cannot be used for BOM Configurations.
2 — Semi-dependent, May be delivered both as a whole and partially, that is, not only by the top node, but also by sub-nodes. Cannot be used for BOM Configurations.
   
SCB4012 INT INTEGER 0 0 1 ORDSTransferOption Sales Order Drop Shipment Transfer Option 0 — All BOM components are transferred independently. No reference to the configuration is stored.
1 — BOM components are transferred independently. Source configuration data is stored in a text line.
2 — BOM is transferred as a structure.
   
SCB4013 INT INTEGER 0 0 1 SMDSTransferOption Service Order Drop Shipment Transfer Option 0 — All BOM components are transferred independently. No reference to the configuration is stored.
1 — BOM components are transferred independently. Source configuration data is stored in a text line.
2 — BOM is transferred as a structure.
   
SCB4014 INT INTEGER 0 0 1 CreateLinesIntermediatePhantom Create Lines for Intermediate Phantom Items      
SCB4015 INT INTEGER 0 0 1 Spare (obsolete)      
SCB4016 INT INTEGER 0 0 1 RecalculateTopItemPrice Recalculate Top Item Price      
SCB4017 INT INTEGER 0 0 4 UnitCode Unit Code      
SCB4018 NCHAR STRING 1 0 1 Spare11 Spare 11      
SCB4019 NCHAR STRING 1 0 1 Spare12 Spare 12      
SCB4020 NCHAR STRING 1 0 1 Spare13 Spare 13      
SCB4021 NCHAR STRING 1 0 1 Spare14 Spare 14      
SCB4022 NCHAR STRING 1 0 1 Spare15 Spare 15      
SCB4023 NCHAR STRING 2 0 2 Spare16 Spare 16      
SCB4024 NCHAR STRING 2 0 2 Spare17 Spare 17      
SCB4025 NCHAR STRING 2 0 2 Spare18 Spare 18      
SCB4026 NCHAR STRING 2 0 2 Spare19 Spare 19      
SCB4027 NCHAR STRING 2 0 2 Spare20 Spare 20      
SCB4028 NUMERIC X_NUMERIC 26 8 18 UnitConvFactor UnitConvFactor      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
SCB4017 0 2 0 2 0 4 0 4 0 4 0 4 0 4

Навигация: