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 PC19 — Purchase Order Delivery Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC19001 NCHAR STRING 10 0 10 OrderNo Purchase Order Number   1 Да / Yes
PC19002 NCHAR STRING 6 0 6 LineNo Purchase Order Line Number   2 Да / Yes
PC19003 NCHAR STRING 6 0 6 StructLineNo Purchase Order Sub-line Number   3 Да / Yes
PC19004 NCHAR STRING 4 0 4 AutSubStrLNo Purchase Order Delivery Line Number   4 Да / Yes
PC19005 NVARCHAR VSTRING 12 0 12 BatchNumber Batch Number      
PC19006 NUMERIC X_NUMERIC 20 8 12 QtyRequested Quantity Ordered      
PC19007 NUMERIC X_NUMERIC 20 8 12 QtyDelivered Quantity Delivered      
PC19008 NUMERIC X_NUMERIC 20 8 12 QtyPropDeliv Quantity Proposed Delivery      
PC19009 DATETIME DATE 0 0 8 DelDatRequst Delivery Date Requested      
PC19010 DATETIME DATE 0 0 8 DelDateComm Delivery Date Committed      
PC19011 DATETIME DATE 0 0 8 DelivDateActl Delivery Date Actual      
PC19012 NVARCHAR VSTRING 20 0 20 DelivNoteNo Delivery Note Number      
PC19013 NUMERIC X_NUMERIC 28 8 20 DelDatExcRat Delivery Date Exchange Rate      
PC19014 NUMERIC MONEY 28 8 20 UnitPrice Unit Price (Purchase Currency)      
PC19015 INT INTEGER 0 0 1 FlagGRNPrinted Goods Received Note Printed      
PC19016 INT INTEGER 0 0 1 FlagGRNSent Goods Received Note Sent (XML)      
PC19017 INT INTEGER 0 0 1 DocumFLAG1 (obsolete)      
PC19018 INT INTEGER 0 0 1 DocumFLAG2 (obsolete)      
PC19019 INT INTEGER 0 0 1 DocumFLAG3 (obsolete)      
PC19020 INT INTEGER 0 0 1 DocumFLAG4 (obsolete)      
PC19021 INT INTEGER 0 0 1 DocumFLAG5 (obsolete)      
PC19022 INT INTEGER 0 0 1 DocumFLAG6 (obsolete)      
PC19023 INT INTEGER 0 0 1 DocumFLAG7 (obsolete)      
PC19024 INT INTEGER 0 0 1 DocumFLAG8 (obsolete)      
PC19025 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
PC19026 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
PC19027 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
PC19028 NVARCHAR VSTRING 1 0 1 SPARE1 (obsolete)      
PC19029 NVARCHAR VSTRING 5 0 5 SPARE2 (obsolete)      
PC19030 NVARCHAR VSTRING 6 0 6 SPARE3 (obsolete)      
PC19031 NVARCHAR VSTRING 3 0 3 SPARE4 (obsolete)      
PC19032 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
PC19033 NVARCHAR VSTRING 6 0 6 DeliveryTime Time Entered      
PC19034 NUMERIC X_NUMERIC 20 8 12 PurchSurchar Purchase On-charge      
PC19035 NUMERIC X_NUMERIC 20 8 12 QtyInvSCUnit Quantity Invoiced (Stock Unit)      
PC19036 NUMERIC X_NUMERIC 20 8 12 QtyDelSCUnit Quantity Delivered (Stock Unit)      
PC19037 NUMERIC X_NUMERIC 20 8 12 QtyInvPCUnit Quantity Invoiced (Purchase Unit)      
PC19038 NUMERIC X_NUMERIC 18 8 10 DlvryDateExchgRate2 Delivery Date Exchange Rate 2      
PC19039 NCHAR STRING 3 0 3 DlvryDateExchgAlgtm Delivery Date Exchange Rate Algorithm      
PC19040 INT INTEGER 0 0 2 CurrencyCode Currency Code Order      
PC19041 NVARCHAR VSTRING 10 0 10 AutoDelNoteNo Internal Goods Received Note Number      
PC19042 NVARCHAR VSTRING 10 0 10 ConsGoodsRecNoteNo Consolidated Goods Received Note Number      
PC19043 NVARCHAR VSTRING 1 0 1 InclInCGRNFlag Has Been Included in Goods Received Note      
PC19044 NVARCHAR VSTRING 25 0 25 InvoiceNoLast Invoice Number      
PC19045 INT INTEGER 0 0 2 ConsCurrCode Currency Code Alternative      
PC19046 NUMERIC X_NUMERIC 18 8 10 CCExchgRate1 Alternative Currency Exchange Rate      
PC19047 NUMERIC X_NUMERIC 18 8 10 CCExchgRate2 Alternative Currency Exchange Rate 2      
PC19048 NCHAR STRING 3 0 3 CCExchgAlgtm Alternative Currency Exchange Rate Algorithm      
PC19049 NUMERIC MONEY 28 8 20 AllocCostsOnPO Allocation of Costs on Purchase Order      
PC19050 NUMERIC X_NUMERIC 28 8 20 QtyPCUnitLastInvoice LastInvoice Qty in PCUnit      
PC19051 NUMERIC X_NUMERIC 28 8 20 QtySCUnitLastInvoice LastInvoice Qty in SCUnit      
PC19052 NCHAR SWITCH 1 0 1 ProductLabelPrinted Product Label Printed      
PC19053 NUMERIC X_NUMERIC 20 8 12 QtyRejected Rejected quantity      
PC19054 NVARCHAR VSTRING 4 0 4 RejectionCode Rejection Code      
PC19055 NVARCHAR VSTRING 12 0 12 Temperature Temperature      
PC19056 NVARCHAR VSTRING 12 0 12 Humidity Humidity      
PC19057 NVARCHAR VSTRING 12 0 12 UserDef1 User def. 1      
PC19058 NVARCHAR VSTRING 12 0 12 UserDef2 User def. 2      
PC19059 NVARCHAR VSTRING 12 0 12 UserDef3 User def. 3      
PC19060 NVARCHAR VSTRING 12 0 12 UserDef4 User def. 4      
PC19061 NVARCHAR VSTRING 12 0 12 UserDef5 User def. 5      
PC19062 NUMERIC MONEY 28 8 20 SubcontractCost Subcontract cost      
PC19063 NCHAR STRING 1 0 1 TaxRegStatus Tax Reg. Status      
PC19064 DATETIME DATE 0 0 8 TaxRegDate Tax Reg. Date      

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