Таблица: SM47 - «Service Order Line Delivery History File». Маска имени таблицы: «SM47%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM47001 | NCHAR | STRING | 10 | 0 | 10 | ServOrderNo | Service Order Number | 1 | Да | |
SM47002 | NCHAR | STRING | 4 | 0 | 4 | ItemNo | Service Order Line Number | 2 | Да | |
SM47003 | NCHAR | STRING | 6 | 0 | 6 | StructLineNo | Service Order Sub-line Number | 3 | Да | |
SM47004 | NCHAR | STRING | 4 | 0 | 4 | AutoSubStrLine | Delivery Line Number | 6 | Да | |
SM47005 | NCHAR | STRING | 12 | 0 | 12 | BatchNumber | Batch ID | |||
SM47006 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyAllocated | Quantity Allocated (Order Unit) | |||
SM47007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyDelivered | Quantity Delivered (Order Unit) | |||
SM47008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyPropDeliv | Quantity Proposed for Delivery (Order Unit) | |||
SM47009 | DATETIME | DATE | 0 | 0 | 8 | DelivDateReq | Delivery Date Requested | |||
SM47010 | DATETIME | DATE | 0 | 0 | 8 | DelivDateCom | Delivery Date Committed | |||
SM47011 | DATETIME | DATE | 0 | 0 | 8 | DelivDateAct | Delivery Date Actual | |||
SM47012 | NVARCHAR | VSTRING | 20 | 0 | 20 | DelivNoteNo | Delivery Note Number | |||
SM47013 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | DeliDateExch | Delivery Date Exchange Rate 1 | |||
SM47014 | NUMERIC | MONEY | 28 | 8 | 20 | UnitCostPriceLCU | Unit Cost Price (Local Currency) | |||
SM47015 | 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. |
||
SM47016 | INT | INTEGER | 0 | 0 | 1 | FLPickListPrint | Picking List Status | |||
SM47017 | INT | INTEGER | 0 | 0 | 1 | FLDelPropPrint | Delivery Proposal Status | |||
SM47018 | INT | INTEGER | 0 | 0 | 1 | FLRetNotePrint | Return Note Status | |||
SM47019 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM47020 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM47021 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM47022 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM47023 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM47024 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
SM47025 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | NetWeight | Net Weight | |||
SM47026 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | GrossWeight | Gross Weight | |||
SM47027 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Volume | Volume | |||
SM47028 | NCHAR | STRING | 1 | 0 | 1 | DelTransType | Delivery Transaction Type | 5 | Да | |
SM47029 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyAllocated | Quantity Allocated (Stock Unit) | |||
SM47030 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyDelivered | Quantity Delivered (Stock Unit) | |||
SM47031 | NCHAR | STRING | 2 | 0 | 2 | OrderCurrencyCode | Currency Code Order | |||
SM47032 | NCHAR | STRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SM47033 | NCHAR | STRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SM47034 | NCHAR | STRING | 10 | 0 | 10 | Spare | (obsolete) | |||
SM47035 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
SM47036 | NCHAR | STRING | 10 | 0 | 10 | PickinListNo | Picking List Number | |||
SM47037 | NCHAR | STRING | 10 | 0 | 10 | DelivPropNo | Delivery Proposal Number | |||
SM47038 | NUMERIC | MONEY | 28 | 8 | 20 | ConsolCostPr | Unit Cost Price (Alternative Currency) | |||
SM47039 | NCHAR | STRING | 10 | 0 | 10 | ReturnNoteNo | Return Note Number | |||
SM47040 | NCHAR | STRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
SM47041 | NCHAR | STRING | 6 | 0 | 6 | WarehouseID | Warehouse | |||
SM47042 | NCHAR | STRING | 20 | 0 | 20 | SerialNo | Serial Number | |||
SM47043 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | DelDateExchRate2 | Delivery Date Exchange Rate 2 | |||
SM47044 | NCHAR | STRING | 3 | 0 | 3 | DelDateExchAlgorithm | Delivery Date Exchange Algorithm | |||
SM47045 | NCHAR | STRING | 6 | 0 | 6 | ChildItemLinNo | Child Item Line Number | 4 | Да | |
SM47046 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | GoodReturnQty_in_ORunits | Quantity Returned Good Items (Order Unit) | |||
SM47047 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | BadReturnQty_in_ORunits | Quantity Returned Bad Items (Order Unit) | |||
SM47048 | NCHAR | STRING | 15 | 0 | 15 | Invoice Number | Invoice Number | 7 | Да | |
SM47049 | NCHAR | STRING | 3 | 0 | 3 | ReasonCode | Reason Code | |||
SM47050 | NVARCHAR | VSTRING | 10 | 0 | 10 | DispatchNote | Dispatch Note |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Service Order Management | Service Order Delivery Lines History