Таблица | Table: PCH4 - «BOM Branch». Маска имени таблицы | Table Name Mask: «PCH4%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
PCH4001 | NCHAR | STRING | 38 | 0 | 38 | ParentNodeID | Parent Node ID | 1 | Да / Yes | |
PCH4002 | INT | INTEGER | 0 | 0 | 9 | BranchNo | Branch Number | 2 | Да / Yes | |
PCH4003 | INT | INTEGER | 0 | 0 | 1 | Flag_Optional | Optional | |||
PCH4004 | INT | INTEGER | 0 | 0 | 1 | Flag_SwitchedOff | Switched Off | |||
PCH4005 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Qty_Child | Child Quantity | |||
PCH4006 | INT | INTEGER | 0 | 0 | 1 | Flag_Independent_Child_Qty | Independent Child Quantity | |||
PCH4007 | INT | INTEGER | 0 | 0 | 1 | Flag_Changable_Node | Changeable Child Quantity | |||
PCH4008 | NCHAR | STRING | 2 | 0 | 2 | PriceList | Price List | |||
PCH4009 | INT | INTEGER | 0 | 0 | 1 | Flag_Calculate_Price | Calculate Price | |||
PCH4010 | INT | INTEGER | 0 | 0 | 1 | Flag_Printable_in)Document | Printable on Documents | |||
PCH4011 | INT | INTEGER | 0 | 0 | 1 | Spare | 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. |
||
PCH4012 | 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. |
||
PCH4013 | 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. |
||
PCH4014 | INT | INTEGER | 0 | 0 | 1 | Create lines for intermediate phantom items | (obsolete) | |||
PCH4015 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
PCH4016 | INT | INTEGER | 0 | 0 | 1 | RecalculateTopItemPrice | Recalculate Top Item Price | |||
PCH4017 | INT | INTEGER | 0 | 0 | 4 | UnitCode | Unit Code | |||
PCH4018 | NCHAR | STRING | 1 | 0 | 1 | Spare 11 | ||||
PCH4019 | NCHAR | STRING | 1 | 0 | 1 | Spare 12 | ||||
PCH4020 | NCHAR | STRING | 1 | 0 | 1 | Spare 13 | ||||
PCH4021 | NCHAR | STRING | 1 | 0 | 1 | Spare 14 | ||||
PCH4022 | NCHAR | STRING | 1 | 0 | 1 | Spare 15 | ||||
PCH4023 | NCHAR | STRING | 2 | 0 | 2 | Spare 16 | ||||
PCH4024 | NCHAR | STRING | 2 | 0 | 2 | Spare 17 | ||||
PCH4025 | NCHAR | STRING | 2 | 0 | 2 | Spare 18 | ||||
PCH4026 | NCHAR | STRING | 2 | 0 | 2 | Spare 19 | ||||
PCH4027 | NCHAR | STRING | 2 | 0 | 2 | Spare 20 | ||||
PCH4028 | NUMERIC | X_NUMERIC | 26 | 8 | 18 | UnitConvFactor |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Order | Purchase Order BOM Branch History