Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...

Таблица | Table: PC23 - «Invoice Line». Маска имени таблицы | Table Name Mask: «PC23%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?
PC23001 NCHAR STRING 10 0 10 SuppCode Supplier Code   1 Да / Yes
PC23002 NCHAR STRING 15 0 15 InvNum Invoice Number   2 Да / Yes
PC23003 NVARCHAR VSTRING 20 0 20 ShipmentNum Shipment Number   5 Да / Yes
PC23004 DATETIME DATE 0 0 8 ShipmentDate Shipment Date      
PC23005 NCHAR STRING 10 0 10 OrdNum Purchase Order Number   3 Да / Yes
PC23006 NCHAR STRING 6 0 6 OrdLine Purchase Order Line Number   4 Да / Yes
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 7 0 7 Link Link      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Order | Received Invoices - Lines