Таблица: SM75 - «Delivery Schedule». Маска имени таблицы: «SM75%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SM75001 NCHAR STRING 10 0 10 ContractNumber Contract Number   1 Да
SM75002 NCHAR STRING 6 0 6 ContractLineNumber Contract Line Number   2 Да
SM75003 NCHAR STRING 6 0 6 ScheduleLineNumber Schedule Line Number   3 Да
SM75004 NUMERIC X_NUMERIC 28 8 20 OrderedQty Ordered Qty      
SM75005 DATETIME DATE 0 0 8 RequestedDeliveryDate Requested Delivery Date      
SM75006 DATETIME DATE 0 0 8 ConfirmedDeliveryDate Confirmed Delivery Date      
SM75007 NVARCHAR VSTRING 25 0 25 Spare Spare      
SM75008 NVARCHAR VSTRING 25 0 25 Spare Spare      
SM75009 NCHAR STRING 10 0 10 PurchaseOrderNumber Purchase Order Number      
SM75010 NCHAR STRING 6 0 6 PurchaseOrderLine Purchase Order Line reference      
SM75011 NCHAR STRING 6 0 6 PurchaseOrderSubLine Purchase Order SubLine reference      
SM75012 DATETIME DATE 0 0 8 ActualDeliveryDate Actual Delivery Date      
SM75013 NUMERIC X_NUMERIC 28 8 20 ActualQty Actual Qty      
SM75014 NUMERIC X_NUMERIC 28 8 20 InvoicedQty Invoiced Qty      
SM75015 DATETIME DATE 0 0 8 ReservationEndDate Reservation End Date      
SM75016 NUMERIC X_NUMERIC 28 8 20 UsedQty UsedQty      
SM75017 DATETIME DATE 0 0 8 LastUsedDate Last Used Date      
SM75018 DATETIME DATE 0 0 8 AtpPromisedDate Atp Promised Date      
SM75019 NUMERIC X_NUMERIC 28 8 20 RequestedQtySCU Requested Qty Stock Units      
SM75020 NUMERIC X_NUMERIC 28 8 20 ConfirmedQtySCU Confirmed Qty Stock Units      
SM75021 NUMERIC X_NUMERIC 28 8 20 UsedQtySCU Used Qty Stock Units      
SM75022 NCHAR STRING 15 0 15 InvoiceNo InvoiceNo      
SM75023 DATETIME DATE 0 0 8 OrderedDate Ordered Date      
SM75024 INT INTEGER 0 0 1 ScheduleSubtype Schedule subtype      
SM75025 NCHAR STRING 6 0 6 Warehouse Warehouse      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Service Order Management | Delivery Schedule