Таблица | Table: SMH4 - «BOM Branch». Маска имени таблицы | Table Name Mask: «SMH4%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SMH4001 | NCHAR | STRING | 38 | 0 | 38 | ParentNodeID | Parent Node ID | 1 | Да / Yes | |
SMH4002 | INT | INTEGER | 0 | 0 | 9 | BranchNo | Branch Number | 2 | Да / Yes | |
SMH4003 | INT | INTEGER | 0 | 0 | 1 | Flag_Optional | Optional | |||
SMH4004 | INT | INTEGER | 0 | 0 | 1 | Flag_SwitchedOff | Switched Off | |||
SMH4005 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Qty_Child | Child Quantity | |||
SMH4006 | INT | INTEGER | 0 | 0 | 1 | Flag_Independent_Child_Qty | Independent Child Quantity | |||
SMH4007 | INT | INTEGER | 0 | 0 | 1 | Flag_Changable_Node | Changeable Child Node | |||
SMH4008 | NCHAR | STRING | 2 | 0 | 2 | PriceList | Price List | |||
SMH4009 | INT | INTEGER | 0 | 0 | 1 | Flag_Calculate_Price | Calculate Price | |||
SMH4010 | INT | INTEGER | 0 | 0 | 1 | Flag_Printable_in)Document | Printable on Documents | |||
SMH4011 | INT | INTEGER | 0 | 0 | 1 | Spare | Structure Type | |||
SMH4012 | INT | INTEGER | 0 | 0 | 1 | OR DS Transfer Option | Sales Order Drop Shipment Transfer Option | |||
SMH4013 | INT | INTEGER | 0 | 0 | 1 | SM DS Transfer Option | Service Order Drop Shipment Transfer Option | |||
SMH4014 | INT | INTEGER | 0 | 0 | 1 | Create lines for intermediate phantom items | Create Lines for Intermediate Phantom Items | |||
SMH4015 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SMH4016 | INT | INTEGER | 0 | 0 | 1 | RecalculateTopItemPrice | Recalculate Top Item Price | |||
SMH4017 | INT | INTEGER | 0 | 0 | 4 | UnitCode | Unit Code | |||
SMH4018 | NCHAR | STRING | 1 | 0 | 1 | Spare 11 | ||||
SMH4019 | NCHAR | STRING | 1 | 0 | 1 | Spare 12 | ||||
SMH4020 | NCHAR | STRING | 1 | 0 | 1 | Spare 13 | ||||
SMH4021 | NCHAR | STRING | 1 | 0 | 1 | Spare 14 | ||||
SMH4022 | NCHAR | STRING | 1 | 0 | 1 | Spare 15 | ||||
SMH4023 | NCHAR | STRING | 2 | 0 | 2 | Spare 16 | ||||
SMH4024 | NCHAR | STRING | 2 | 0 | 2 | Spare 17 | ||||
SMH4025 | NCHAR | STRING | 2 | 0 | 2 | Spare 18 | ||||
SMH4026 | NCHAR | STRING | 2 | 0 | 2 | Spare 19 | ||||
SMH4027 | NCHAR | STRING | 2 | 0 | 2 | Spare 20 | ||||
SMH4028 | NUMERIC | X_NUMERIC | 26 | 8 | 18 | UnitConvFactor |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Service Order BOM Branches History