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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table PC14 — Order Line Del.

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC14001 NCHAR STRING 10 0 10 OrderNo OrderNo   1 Да / Yes
PC14002 NCHAR STRING 6 0 6 LineNo LineNo   2 Да / Yes
PC14003 NCHAR STRING 6 0 6 StructLineNo StructLineNo   3 Да / Yes
PC14004 NCHAR STRING 4 0 4 AutSubStrLNo AutSubStrLNo   4 Да / Yes
PC14005 NVARCHAR VSTRING 12 0 12 BatchNumber BatchNumber      
PC14006 NUMERIC X_NUMERIC 20 8 12 QtyInvoiced QtyInvoiced      
PC14007 NUMERIC X_NUMERIC 20 8 12 QtyDelivered QtyDelivered      
PC14008 DATETIME DATE 0 0 8 DelivDateAct DelivDateAct      
PC14009 NVARCHAR VSTRING 20 0 20 DelivNoteNo DelivNoteNo      
PC14010 NUMERIC MONEY 28 8 20 UnitCostPric UnitCostPric      
PC14011 NVARCHAR VSTRING 6 0 6 BinNo BinNo      
PC14012 INT INTEGER 0 0 1 LockStatus09 LockStatus09      
PC14013 NVARCHAR VSTRING 20 0 20 SearchField SearchField      
PC14014 DATETIME DATE 0 0 8 DateReceived DateReceived      
PC14015 DATETIME DATE 0 0 8 DateManufact DateManufact      
PC14016 DATETIME DATE 0 0 8 DatBestBefor DatBestBefor      
PC14017 DATETIME DATE 0 0 8 DateShipBef DateShipBef      
PC14018 NVARCHAR VSTRING 20 0 20 SupplBatchID SupplBatchID      
PC14019 NVARCHAR VSTRING 20 0 20 UserDefFld1 UserDefFld1      
PC14020 NVARCHAR VSTRING 10 0 10 UserDefFld2 UserDefFld2      
PC14021 NVARCHAR VSTRING 10 0 10 UserDefFld3 UserDefFld3      
PC14022 NVARCHAR VSTRING 8 0 8 UserDefFld4 UserDefFld4      
PC14023 NVARCHAR VSTRING 8 0 8 UserDefFld5 UserDefFld5      
PC14024 NVARCHAR VSTRING 4 0 4 UserDefFld6 UserDefFld6      
PC14025 NVARCHAR VSTRING 4 0 4 UserDefFld7 UserDefFld7      
PC14026 NVARCHAR VSTRING 2 0 2 UserDefFld8 UserDefFld8      
PC14027 NVARCHAR VSTRING 2 0 2 UserDefFld9 UserDefFld9      
PC14028 NVARCHAR VSTRING 1 0 1 UserDefFld10 UserDefFld10      
PC14029 NUMERIC X_NUMERIC 18 8 10 NetWeight NetWeight      
PC14030 NUMERIC X_NUMERIC 18 8 10 GrossWeight GrossWeight      
PC14031 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
PC14032 DATETIME DATE 0 0 8 DelDateRequ DelDateRequ      
PC14033 DATETIME DATE 0 0 8 DelDateCommi DelDateCommi      
PC14034 NUMERIC X_NUMERIC 28 8 20 DelDatExRate DelDatExRate      
PC14035 NUMERIC X_NUMERIC 20 8 12 QtyDelivSc QtyDelivSc      
PC14036 DATETIME DATE 0 0 8 DelDatBackOr DelDatBackOr      
PC14037 NUMERIC X_NUMERIC 14 8 6 PurchSurchar PurchSurchar      
PC14038 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
PC14039 NUMERIC X_NUMERIC 20 8 12 QtyInvcedPC QtyInvcedPC      
PC14040 NUMERIC X_NUMERIC 20 8 12 QtyDelTimePC QtyDelTimePC      
PC14041 NUMERIC X_NUMERIC 20 8 12 QtyDelTimeSC QtyDelTimeSC      
PC14042 NUMERIC X_NUMERIC 20 8 12 QtyInvTimePC QtyInvTimePC      
PC14043 NUMERIC X_NUMERIC 20 8 12 QtyInvTimeSC QtyInvTimeSC      
PC14044 INT INTEGER 0 0 1 BatchDelExis BatchDelExis      
PC14045 NUMERIC X_NUMERIC 18 8 10 DlvryDateExchgRate2 DlvryDateExchgRate2      
PC14046 NCHAR STRING 3 0 3 DlvryDateExchgAlgtm DlvryDateExchgAlgtm      
PC14047 INT INTEGER 0 0 2 CurrencyCode CurrencyCode      
PC14048 NVARCHAR VSTRING 10 0 10 AutoDelNoteNo AutoDelNoteNo      
PC14049 NCHAR STRING 12 0 12 OriginalBatchId OriginalBatchId      
PC14050 NCHAR STRING 2 0 2 QCCategory QCCategory      
PC14051 NUMERIC X_NUMERIC 14 8 6 PotencyFactor PotencyFactor      
PC14052 DATETIME DATE 0 0 8 DateOfExpiry DateOfExpiry      
PC14053 NVARCHAR VSTRING 30 0 30 CustomsDispatchNoteNumber Customs Dispatch Note Number      
PC14054 DATETIME DATE 0 0 8 DateImported Date Imported      
PC14055 NCHAR STRING 3 0 3 CountryOfOrigin Country of Origin      
PC14056 NCHAR STRING 10 0 10 CustomsOfficeCode Customs Office Code      
PC14057 NUMERIC X_NUMERIC 20 8 12 QtyRejected Rejected quantity      
PC14058 NVARCHAR VSTRING 4 0 4 RejectionCode Rejection Code      
PC14059 NVARCHAR VSTRING 12 0 12 Temperature Temperature      
PC14060 NVARCHAR VSTRING 12 0 12 Humidity Humidity      
PC14061 NVARCHAR VSTRING 12 0 12 UserDef1 User def. 1      
PC14062 NVARCHAR VSTRING 12 0 12 UserDef2 User def. 2      
PC14063 NVARCHAR VSTRING 12 0 12 UserDef3 User def. 3      
PC14064 NVARCHAR VSTRING 12 0 12 UserDef4 User def. 4      
PC14065 NVARCHAR VSTRING 12 0 12 UserDef5 User def. 5      
PC14066 NCHAR STRING 4 0 4 DestinationCode DestinationCode      

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