One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SM75 — Delivery Schedule

Таблица / Table: SM75 — «Delivery Schedule». Маска имени таблицы / Table name mask: «SM75%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM75001 NCHAR STRING 10 0 10 ContractNumber Contract Number   1 Да / Yes
SM75002 NCHAR STRING 6 0 6 ContractLineNumber Contract Line Number   2 Да / Yes
SM75003 NCHAR STRING 6 0 6 ScheduleLineNumber Schedule Line Number   3 Да / Yes
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      

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