Таблица | Table: SM06 - «Service Order Line Delivery Definition». Маска имени таблицы | Table Name Mask: «SM06%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SM06001 | NCHAR | STRING | 10 | 0 | 10 | ServOrderNo | Service Order Number | 1 | Да / Yes | |
SM06002 | NCHAR | STRING | 4 | 0 | 4 | ItemNo | Service Order Line Number | 2 | Да / Yes | |
SM06003 | NCHAR | STRING | 6 | 0 | 6 | StructLineNo | Service Order Sub-line Number | 3 | Да / Yes | |
SM06004 | NCHAR | STRING | 4 | 0 | 4 | AutoSubStrLine | Delivery Line Number | 6 | Да / Yes | |
SM06005 | NCHAR | STRING | 12 | 0 | 12 | BatchNumber | Batch ID | |||
SM06006 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyAllocated_in_ORunits | Quantity Allocated (Order Unit) | |||
SM06007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyDelivered_in_ORunits | Quantity Delivered (Order Unit) | |||
SM06008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyPropDeliv | Quantity Proposed for Delivery (Order Unit) | |||
SM06009 | DATETIME | DATE | 0 | 0 | 8 | DelivDateReq | Delivery Date Requested | |||
SM06010 | DATETIME | DATE | 0 | 0 | 8 | DelivDateCom | Delivery Date Committed | |||
SM06011 | DATETIME | DATE | 0 | 0 | 8 | DelivDateAct | Delivery Date Actual | |||
SM06012 | NVARCHAR | VSTRING | 20 | 0 | 20 | DelivNoteNo | Delivery Note Number | |||
SM06013 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | DeliDateExch | Delivery Date Exchange Rate 1 | |||
SM06014 | NUMERIC | MONEY | 28 | 8 | 20 | UnitCostPriceLCU | Unit Cost Price (Local Currency) | |||
SM06015 | INT | INTEGER | 0 | 0 | 1 | FLDelNotePrint | Delivery Note Status | 0/1 - Print delivery note for delivery line
2 - Delivery note has been sent for the delivery line. |
||
SM06016 | INT | INTEGER | 0 | 0 | 1 | FLPickListPrint | Picking List Status | |||
SM06017 | INT | INTEGER | 0 | 0 | 1 | FLDelPropPrint | Delivery Proposal Status | |||
SM06018 | INT | INTEGER | 0 | 0 | 1 | FLRetNotePrint | Return Note Status | |||
SM06019 | INT | INTEGER | 0 | 0 | 1 | FLDelNotePrint2 | Delivery Note Customer 2 Status | |||
SM06020 | INT | INTEGER | 0 | 0 | 1 | FLDelNotePrint3 | Delivery Note Customer 3 Status | |||
SM06021 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM06022 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM06023 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM06024 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM06025 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | NetWeight | Net Weight | |||
SM06026 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | GrossWeight | Gross Weight | |||
SM06027 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Volume | Volume | |||
SM06028 | NCHAR | STRING | 1 | 0 | 1 | DelTransType | Delivery Transaction Type | 5 | Да / Yes | |
SM06029 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyAllocated_in_SCunits | Quantity Allocated (Stock Unit) | |||
SM06030 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyDelivered_in_SCunits | Quantity Delivered (Stock Unit) | |||
SM06031 | NCHAR | STRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SM06032 | NCHAR | STRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SM06033 | NCHAR | STRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SM06034 | NVARCHAR | VSTRING | 10 | 0 | 10 | Spare | (obsolete) | |||
SM06035 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
SM06036 | NCHAR | STRING | 10 | 0 | 10 | PickinListNo | Picking List Number | |||
SM06037 | NCHAR | STRING | 10 | 0 | 10 | DelivPropNo | Delivery Proposal Number | |||
SM06038 | NUMERIC | MONEY | 28 | 8 | 20 | ConsolCostPr | Unit Cost Price (Alternative Currency) | |||
SM06039 | NCHAR | STRING | 10 | 0 | 10 | ReturnNoteNo | Return Note Number | |||
SM06040 | NCHAR | STRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
SM06041 | NCHAR | STRING | 6 | 0 | 6 | WarehouseID | Warehouse | |||
SM06042 | NCHAR | STRING | 20 | 0 | 20 | SerialNo | Serial Number | |||
SM06043 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | DelDateExchRate2 | Delivery Date Exchange Rate 2 | |||
SM06044 | NCHAR | STRING | 3 | 0 | 3 | DelDateExchAlgorithm | Delivery Date Exchange Algorithm | |||
SM06045 | NCHAR | STRING | 6 | 0 | 6 | ChildItemLinNo | Child Item Line Number | 4 | Да / Yes | |
SM06046 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | GoodReturnQty_in_ORunits | Quantity Returned Good Items (Order Unit) | |||
SM06047 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | BadReturnQty_in_ORunits | Quantity Returned Bad Items (Order Unit) | |||
SM06048 | NCHAR | STRING | 15 | 0 | 15 | Invoice Number | Invoice Number | 7 | Да / Yes | |
SM06049 | NCHAR | STRING | 3 | 0 | 3 | ReasonCode | Reason Code | |||
SM06050 | NVARCHAR | VSTRING | 20 | 0 | 20 | DispatchNote | Dispatch Note | |||
SM06051 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | GoodReturnQty_in_SCunits | Quantity Returned Good Items (Stock Unit) | |||
SM06052 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | BadReturnQty_in_SCunits | Quantity Returned Bad Items (Stock Unit) | |||
SM06053 | NCHAR | STRING | 4 | 0 | 4 | ParentSubStrLine | Parent Delivery Line Number | |||
SM06054 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | SoldQty_in_ORunits | Quantity Sold (Order Unit) | |||
SM06055 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | SoldQty_in_SCunits | Quantity Sold (Stock Unit) | |||
SM06056 | NCHAR | STRING | 6 | 0 | 6 | DNIssuerCode | DNIssuerCode |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Service Order Delivery Lines