пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table ORB4 — Sales Order BOM Branch

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
ORB4001 NCHAR STRING 38 0 38 ParentNodeID Parent Node ID   1 Да / Yes
ORB4002 INT INTEGER 0 0 9 BranchNo Branch Number   2 Да / Yes
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 StructureType 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 ORDSTransferOption 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 SMDSTransferOption 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 CreateLinesIntermediatePhantom Create Lines for Intermediate Phantom Items      
ORB4015 INT INTEGER 0 0 1 UnitCode2 (obsolete)      
ORB4016 INT INTEGER 0 0 1 RecalculateTopItemPrice Recalculate Top Item Price      
ORB4017 INT INTEGER 0 0 4 UnitCode Unit Code      
ORB4018 NCHAR STRING 1 0 1 Spare11 Spare 11      
ORB4019 NCHAR STRING 1 0 1 Spare12 Spare 12      
ORB4020 NCHAR STRING 1 0 1 Spare13 Spare 13      
ORB4021 NCHAR STRING 1 0 1 Spare14 Spare 14      
ORB4022 NCHAR STRING 1 0 1 Spare15 Spare 15      
ORB4023 NCHAR STRING 2 0 2 Spare16 Spare 16      
ORB4024 NCHAR STRING 2 0 2 Spare17 Spare 17      
ORB4025 NCHAR STRING 2 0 2 Spare18 Spare 18      
ORB4026 NCHAR STRING 2 0 2 Spare19 Spare 19      
ORB4027 NCHAR STRING 2 0 2 Spare20 Spare 20      
ORB4028 NUMERIC X_NUMERIC 26 8 18 UnitConvFactor UnitConvFactor      

Навигация / Navigation: