One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказ на Закупку»/List of tables of module «Purchase Order»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table PC23 — Received Invoices — Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 25 0 25 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 QtyRejected Rejected quantity      
PC23020 NVARCHAR VSTRING 4 0 4 RejectionCode Rejection Code      
PC23021 NVARCHAR VSTRING 12 0 12 Temperature Temperature      
PC23022 NVARCHAR VSTRING 12 0 12 Humidity Humidity      
PC23023 NVARCHAR VSTRING 12 0 12 UserDef1 User def. 1      
PC23024 NVARCHAR VSTRING 12 0 12 UserDef2 User def. 2      
PC23025 NVARCHAR VSTRING 12 0 12 UserDef3 User def. 3      
PC23026 NVARCHAR VSTRING 12 0 12 UserDef4 User def. 4      
PC23027 NVARCHAR VSTRING 12 0 12 UserDef5 User def. 5      
PC23028 NVARCHAR VSTRING 7 0 7 Link Link      

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