Таблица | Table: MP96 - «MRP/SRP Repl. Prop.». Маска имени таблицы | Table Name Mask: «MP96%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
MP96001 NCHAR STRING 10 0 10 Supplier Supplier Code   1 Да / Yes
MP96002 NCHAR STRING 35 0 35 StockCode Stock Item Code   2 Да / Yes
MP96003 DATETIME DATE 0 0 8 DeliveryDate Delivery Date   3 Да / Yes
MP96004 NCHAR STRING 10 0 10 OrderNo Work Order Number   4 Да / Yes
MP96005 NUMERIC X_NUMERIC 20 8 12 QuantitySC Quantity (Stock Unit)      
MP96006 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
MP96007 INT INTEGER 0 0 1 Status Status      
MP96008 NVARCHAR VSTRING 10 0 10 OldSupplier Supplier Code Old      
MP96009 DATETIME DATE 0 0 8 OldDelDate Delivery Date Old      
MP96010 NUMERIC X_NUMERIC 20 8 12 OldQuantity Quantity Old      
MP96011 DATETIME DATE 0 0 8 OrderDate Order Date      
MP96012 NCHAR STRING 22 0 22 SOLineKey Sales Order Line      
MP96013 NUMERIC X_NUMERIC 20 8 12 QuantityPC Quantity (Purchase Unit)      
MP96014 NUMERIC X_NUMERIC 18 8 10 UnitConvPurchase Unit Conversion Factor      
MP96015 NCHAR STRING 10 0 10 WONumber Work Order Number      
MP96016 NCHAR STRING 10 0 10 ReportNo Report Number      
MP96017 NCHAR STRING 4 0 4 Number Number      
MP96018 NCHAR STRING 1 0 1 NeedFrom Need From      
MP96019 DATETIME DATE 0 0 8 OriginalDeliveryDate        
MP96020 NVARCHAR VSTRING 8 0 8 UserID User ID      
MP96021 INT INTEGER 0 0 1 Order type Order type      
MP96022 NVARCHAR VSTRING 38 0 38 ReleaseBatch Release Batch      
MP96023 NVARCHAR VSTRING 1 0 1 ProposalSource Proposal Source      
MP96024 NUMERIC X_NUMERIC 28 8 20 PurchasePrice Purchase Price      
MP96025 INT INTEGER 0 0 2 CurrencyCode Currency Code      
MP96026 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
MP96027 NVARCHAR VSTRING 10 0 10 ContractNumber Contract Number      
MP96028 NVARCHAR VSTRING 6 0 6 ContractLine Contract Line      
MP96029 INT INTEGER 0 0 1 RequisitionType Requisition Type      
MP96030 NVARCHAR VSTRING 6 0 6 SourceWarehouse Source Warehouse      
MP96031 DATETIME DATE 0 0 8 ReminderDateFPO Reminder Date FPO      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Material Production Control | MRP/SRP Replenishment Proposals