Таблица | Table: PCB4 - «BOM Branch». Маска имени таблицы | Table Name Mask: «PCB4%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
PCB4001 NCHAR STRING 38 0 38 NodeID_Parent Parent Node ID   1 Да / Yes
PCB4002 INT INTEGER 0 0 9 BranchNo Branch Number   2 Да / Yes
PCB4003 INT INTEGER 0 0 1 Flag_Optional Optional      
PCB4004 INT INTEGER 0 0 1 Flag_SwitchedOff Switched Off      
PCB4005 NUMERIC X_NUMERIC 28 8 20 Qty_Child Child Quantity      
PCB4006 INT INTEGER 0 0 1 Flag_Changable_Node Independent Child Quantity      
PCB4007 INT INTEGER 0 0 1 Flag_Child_Qty_Changable Changeable Child Node      
PCB4008 NCHAR STRING 2 0 2 PriceList Price List      
PCB4009 INT INTEGER 0 0 1 Flag_Calculate_Price Calculate Price      
PCB4010 INT INTEGER 0 0 1 Flag_Printable Printable on Documents      
PCB4011 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.		    
PCB4012 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.		    
PCB4013 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.		    
PCB4014 INT INTEGER 0 0 1 Create lines for intermediate phantom items Create Lines for Intermediate Phantom Items      
PCB4015 INT INTEGER 0 0 1 Spare (obsolete)      
PCB4016 INT INTEGER 0 0 1 RecalculateTopItemPrice Recalculate Top Item Price      
PCB4017 INT INTEGER 0 0 4 UnitCode Unit Code      
PCB4018 NCHAR STRING 1 0 1 Spare 11        
PCB4019 NCHAR STRING 1 0 1 Spare 12        
PCB4020 NCHAR STRING 1 0 1 Spare 13        
PCB4021 NCHAR STRING 1 0 1 Spare 14        
PCB4022 NCHAR STRING 1 0 1 Spare 15        
PCB4023 NCHAR STRING 2 0 2 Spare 16        
PCB4024 NCHAR STRING 2 0 2 Spare 17        
PCB4025 NCHAR STRING 2 0 2 Spare 18        
PCB4026 NCHAR STRING 2 0 2 Spare 19        
PCB4027 NCHAR STRING 2 0 2 Spare 20        
PCB4028 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