One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Purchase Order»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PCD3 — Customs Declaration Batch Lines

Таблица: PCD3 — «Customs Declaration Batch Lines». Маска имени таблицы: «PCD3%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PCD3001 NVARCHAR VSTRING 10 0 10 BrokerSupplierCode Broker Supplier Code   1 Да
PCD3002 NVARCHAR VSTRING 25 0 25 CustomsDeclarationNumber Customs Declaration Number   2 Да
PCD3003 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code   4 Да
PCD3004 NVARCHAR VSTRING 25 0 25 InvoiceNumber Invoice Number   5 Да
PCD3005 NCHAR STRING 10 0 10 OrderNo Order Number   6 Да
PCD3006 NCHAR STRING 6 0 6 LineNo Line Number   7 Да
PCD3007 NCHAR STRING 6 0 6 StructLineNo Structure Line Number   8 Да
PCD3008 NCHAR STRING 4 0 4 AutSubStrLNo AutoSubStructLineNo   9 Да
PCD3009 NVARCHAR VSTRING 12 0 12 BatchNumber Batch Number      
PCD3010 NUMERIC X_NUMERIC 20 8 12 QtyInvoiced Quantity Invoiced      
PCD3011 NUMERIC X_NUMERIC 20 8 12 QtyDelivered Quantity Delivered      
PCD3012 DATETIME DATE 0 0 8 DelivDateAct Delivery Date Actual      
PCD3013 NVARCHAR VSTRING 20 0 20 DelivNoteNo Delivery Note Number      
PCD3014 NUMERIC MONEY 28 8 20 UnitCostPrice Unit Cost Price      
PCD3015 NVARCHAR VSTRING 6 0 6 BinNo Bin Number      
PCD3016 INT INTEGER 0 0 1 LockStatus09 LockStatus09      
PCD3017 NVARCHAR VSTRING 20 0 20 SearchField Search Field      
PCD3018 DATETIME DATE 0 0 8 DateReceived Date Received      
PCD3019 DATETIME DATE 0 0 8 DateManufact Date Manufactured      
PCD3020 DATETIME DATE 0 0 8 DateBestBefore Date Best Before      
PCD3021 DATETIME DATE 0 0 8 DateShipBefore Date Ship Before      
PCD3022 NVARCHAR VSTRING 20 0 20 SupplierBatchID Supplier Batch ID      
PCD3023 NVARCHAR VSTRING 20 0 20 UserDefFld1 UserDefFld1      
PCD3024 NVARCHAR VSTRING 10 0 10 UserDefFld2 UserDefFld2      
PCD3025 NVARCHAR VSTRING 10 0 10 UserDefFld3 UserDefFld3      
PCD3026 NVARCHAR VSTRING 8 0 8 UserDefFld4 UserDefFld4      
PCD3027 NVARCHAR VSTRING 8 0 8 UserDefFld5 UserDefFld5      
PCD3028 NVARCHAR VSTRING 4 0 4 UserDefFld6 UserDefFld6      
PCD3029 NVARCHAR VSTRING 4 0 4 UserDefFld7 UserDefFld7      
PCD3030 NVARCHAR VSTRING 2 0 2 UserDefFld8 UserDefFld8      
PCD3031 NVARCHAR VSTRING 2 0 2 UserDefFld9 UserDefFld9      
PCD3032 NVARCHAR VSTRING 1 0 1 UserDefFld10 UserDefFld10      
PCD3033 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
PCD3034 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
PCD3035 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
PCD3036 DATETIME DATE 0 0 8 DelDateRequested Delivery Date Requested      
PCD3037 DATETIME DATE 0 0 8 DeliveryDateCommitted Delivery Date Committed      
PCD3038 NUMERIC X_NUMERIC 28 8 20 DeliveryDateExchangeRate Delivery Date Exchange Rate      
PCD3039 NUMERIC X_NUMERIC 20 8 12 DeliveredQuantitySC Delivered Quantity SC      
PCD3040 DATETIME DATE 0 0 8 DeliveryDateBackOrder Delivery Date Back Order      
PCD3041 NUMERIC X_NUMERIC 14 8 6 PurchSurcharge PurchSurcharge      
PCD3042 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
PCD3043 NUMERIC X_NUMERIC 20 8 12 InvoicedQuantityPC Invoiced Quantity PC      
PCD3044 NUMERIC X_NUMERIC 20 8 12 QtyDelTimePC QtyDelTimePC      
PCD3045 NUMERIC X_NUMERIC 20 8 12 QtyDelTimeSC QtyDelTimeSC      
PCD3046 NUMERIC X_NUMERIC 20 8 12 QtyInvTimePC QtyInvTimePC      
PCD3047 NUMERIC X_NUMERIC 20 8 12 QtyInvTimeSC QtyInvTimeSC      
PCD3048 INT INTEGER 0 0 1 BatchDelExis BatchDelExis      
PCD3049 NUMERIC X_NUMERIC 18 8 10 DeliveryDateExchangeRate2 Delivery Date Exchange Rate 2      
PCD3050 NCHAR STRING 3 0 3 DeliveryDateExhchangeAlgorithm Delivery Date Exhchange Algorithm      
PCD3051 INT INTEGER 0 0 2 CurrencyCode Currency Code      
PCD3052 NVARCHAR VSTRING 10 0 10 AutoDelNoteNo AutoDelNoteNo      
PCD3053 NCHAR STRING 12 0 12 OriginalBatchID Original Batch ID      
PCD3054 NCHAR STRING 2 0 2 QCCategory QC Category      
PCD3055 NUMERIC X_NUMERIC 14 8 6 PotencyFactor PotencyFactor      
PCD3056 DATETIME DATE 0 0 8 DateOfExpiry Date of Expiry      
PCD3057 NCHAR STRING 25 0 25 CustomsDespatchNoteNumber Customs Despatch Note Number      
PCD3058 DATETIME DATE 0 0 8 DateImported Date Imported      
PCD3059 NCHAR STRING 3 0 3 CountryOfOrigin Country of Origin      
PCD3060 NCHAR STRING 10 0 10 CustomsOfficeCode Customs Office Code      
PCD3061 NUMERIC X_NUMERIC 20 8 12 QtyRejected Rejected quantity      
PCD3062 NVARCHAR VSTRING 4 0 4 RejectionCode Rejection Code      
PCD3063 NVARCHAR VSTRING 12 0 12 Temperature Temperature      
PCD3064 NVARCHAR VSTRING 12 0 12 Humidity Humidity      
PCD3065 NVARCHAR VSTRING 12 0 12 UserDef1 User def. 1      
PCD3066 NVARCHAR VSTRING 12 0 12 UserDef2 User def. 2      
PCD3067 NVARCHAR VSTRING 12 0 12 UserDef3 User def. 3      
PCD3068 NVARCHAR VSTRING 12 0 12 UserDef4 User def. 4      
PCD3069 NVARCHAR VSTRING 12 0 12 UserDef5 User def. 5      
PCD3070 NCHAR STRING 4 0 4 DestinationCode Destination Code      
PCD3071 INT INTEGER 0 0 1 AdditionalInvoiceFlag Additional Invoice Flag   3 Да

Навигация: