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

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

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Purchase Order | Order Line Del.