Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...

Таблица: ORB4 - «OR BOM Branch». Маска имени таблицы: «ORB4%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
ORB4001 NCHAR STRING 38 0 38 ParentNodeID Parent Node ID   1 Да
ORB4002 INT INTEGER 0 0 9 BranchNo Branch Number   2 Да
ORB4003 INT INTEGER 0 0 1 Optional Optional      
ORB4004 INT INTEGER 0 0 1 SwitchedOff Switched Off      
ORB4005 NUMERIC X_NUMERIC 28 8 20 ChildQuantity Child Quantity      
ORB4006 INT INTEGER 0 0 1 IndependentChildQty Independent Child Quantity      
ORB4007 INT INTEGER 0 0 1 ChangableNode Changeable Child Node      
ORB4008 NCHAR STRING 2 0 2 PriceList Price List      
ORB4009 INT INTEGER 0 0 1 CalculatePrice Calculate Price      
ORB4010 INT INTEGER 0 0 1 PrintableinDocuments Printable on Documents      
ORB4011 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.		    
ORB4012 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.		    
ORB4013 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.		    
ORB4014 INT INTEGER 0 0 1 Create lines for intermediate phantom items Create Lines for Intermediate Phantom Items      
ORB4015 INT INTEGER 0 0 1 UnitCode (obsolete)      
ORB4016 INT INTEGER 0 0 1 RecalculateTopItemPrice Recalculate Top Item Price      
ORB4017 INT INTEGER 0 0 2 UnitCode Unit Code      
ORB4018 NCHAR STRING 1 0 1 Spare 11 NULL      
ORB4019 NCHAR STRING 1 0 1 Spare 12 NULL      
ORB4020 NCHAR STRING 1 0 1 Spare 13 NULL      
ORB4021 NCHAR STRING 1 0 1 Spare 14 NULL      
ORB4022 NCHAR STRING 1 0 1 Spare 15 NULL      
ORB4023 NCHAR STRING 2 0 2 Spare 16 NULL      
ORB4024 NCHAR STRING 2 0 2 Spare 17 NULL      
ORB4025 NCHAR STRING 2 0 2 Spare 18 NULL      
ORB4026 NCHAR STRING 2 0 2 Spare 19 NULL      
ORB4027 NCHAR STRING 2 0 2 Spare 20 NULL      
ORB4028 NUMERIC X_NUMERIC 26 8 18 UnitConvFactor NULL      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Order | Sales Order BOM Branch