пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: PC23 - «Invoice Line». Маска имени таблицы: «PC23%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PC23001 NCHAR STRING 10 0 10 SuppCode Supplier Code   1 Да
PC23002 NCHAR STRING 15 0 15 InvNum Invoice Number   2 Да
PC23003 NVARCHAR VSTRING 20 0 20 ShipmentNum Shipment Number   5 Да
PC23004 DATETIME DATE 0 0 8 ShipmentDate Shipment Date      
PC23005 NCHAR STRING 10 0 10 OrdNum Purchase Order Number   3 Да
PC23006 NCHAR STRING 6 0 6 OrdLine Purchase Order Line Number   4 Да
PC23007 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
PC23008 NUMERIC X_NUMERIC 20 8 12 QtyOrdered Quantity Ordered      
PC23009 NUMERIC X_NUMERIC 20 8 12 QtyShipped Quantity Shipped      
PC23010 NUMERIC X_NUMERIC 20 8 12 QtyInvoiced Quantity Invoiced      
PC23011 NUMERIC X_NUMERIC 18 8 10 Weight Weight      
PC23012 NUMERIC X_NUMERIC 28 8 20 UnitPrice Unit Price (Invoice Currency)      
PC23013 NUMERIC X_NUMERIC 13 8 5 DiscPerc Discount %      
PC23014 NCHAR STRING 6 0 6 SuppLineNum Suppliers Order Line Number      
PC23015 NVARCHAR VSTRING 35 0 35 SuppStockCode Suppliers Stock Item Code      
PC23016 NUMERIC MONEY 28 8 20 LineTotal Line Total Amount (Invoice Currency)      
PC23017 NUMERIC X_NUMERIC 18 8 10 CostpriceMultiplier Cost Price Multiplier      
PC23018 NCHAR STRING 1 0 1 IsAmountSpecifiedInIncomingXml Is Amount Specified In Incoming Document      
PC23019 NUMERIC X_NUMERIC 20 8 12 Rejected quantity Rejected quantity      
PC23020 NVARCHAR VSTRING 4 0 4 Rejection Code Rejection Code      
PC23021 NVARCHAR VSTRING 12 0 12 Temperature Temperature      
PC23022 NVARCHAR VSTRING 12 0 12 Humidity Humidity      
PC23023 NVARCHAR VSTRING 12 0 12 User def. 1 User def. 1      
PC23024 NVARCHAR VSTRING 12 0 12 User def. 2 User def. 2      
PC23025 NVARCHAR VSTRING 12 0 12 User def. 3 User def. 3      
PC23026 NVARCHAR VSTRING 12 0 12 User def. 4 User def. 4      
PC23027 NVARCHAR VSTRING 12 0 12 User def. 5 User def. 5      
PC23028 NVARCHAR VSTRING 5 0 5 Link Link      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Order | Received Invoices - Lines

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.