Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: 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 | Structure_Type | 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 | OR DS Transfer Option | 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 | SM DS Transfer Option | 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 | Create lines for intermediate phantom items | 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 | 2 | UnitCode | Unit Code | |||
SCB4018 | NCHAR | STRING | 1 | 0 | 1 | Spare 11 | NULL | |||
SCB4019 | NCHAR | STRING | 1 | 0 | 1 | Spare 12 | NULL | |||
SCB4020 | NCHAR | STRING | 1 | 0 | 1 | Spare 13 | NULL | |||
SCB4021 | NCHAR | STRING | 1 | 0 | 1 | Spare 14 | NULL | |||
SCB4022 | NCHAR | STRING | 1 | 0 | 1 | Spare 15 | NULL | |||
SCB4023 | NCHAR | STRING | 2 | 0 | 2 | Spare 16 | NULL | |||
SCB4024 | NCHAR | STRING | 2 | 0 | 2 | Spare 17 | NULL | |||
SCB4025 | NCHAR | STRING | 2 | 0 | 2 | Spare 18 | NULL | |||
SCB4026 | NCHAR | STRING | 2 | 0 | 2 | Spare 19 | NULL | |||
SCB4027 | NCHAR | STRING | 2 | 0 | 2 | Spare 20 | NULL | |||
SCB4028 | NUMERIC | X_NUMERIC | 26 | 8 | 18 | UnitConvFactor | NULL |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Stock Control | Stock Control BOM Branch