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

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table PCD2 — Customs Declaration Lines

Таблица / Table: PCD2 — «Customs Declaration Lines». Маска имени таблицы / Table name mask: «PCD2%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PCD2001 NVARCHAR VSTRING 10 0 10 BrokerSupplierCode Broker Supplier Code   1 Да / Yes
PCD2002 NVARCHAR VSTRING 25 0 25 CustomsDeclarationNumber Customs Declaration Number   2 Да / Yes
PCD2003 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code   4 Да / Yes
PCD2004 NVARCHAR VSTRING 25 0 25 InvoiceNumber Invoice Number   5 Да / Yes
PCD2005 NVARCHAR VSTRING 10 0 10 PurchaseOrderNo Purchase Order No   6 Да / Yes
PCD2006 NVARCHAR VSTRING 12 0 12 PurchaseOrderLineNo Purchase Order Line No   7 Да / Yes
PCD2007 NVARCHAR ACCSTR 120 0 120 AccString Accounting String   8 Да / Yes
PCD2008 NVARCHAR VSTRING 1 0 1 PLLineType PL Line Type      
PCD2009 NVARCHAR VSTRING 1 0 1 CostAllocOnGRN Flag «Cost Allocation on GRN»      
PCD2010 NVARCHAR VSTRING 1 0 1 PRActivityType Flag «PR Activity Type»      
PCD2011 NUMERIC X_NUMERIC 20 8 12 DeliveredInvoiceQtyPC Delivered/Invoice Quantity [PC Unit]      
PCD2012 NUMERIC MONEY 28 8 20 AmountUnitPriceLCU Amount/Unit Price Local Currency      
PCD2013 NUMERIC MONEY 28 8 20 AmountUnitPriceOCU Amount/Unit Price Orig. Currency      
PCD2014 NUMERIC X_NUMERIC 20 8 12 OrderQtyPC] Order Quantity [PC Unit]      
PCD2015 NVARCHAR VSTRING 1 0 1 CostDistributionKey Cost Distribution Key      
PCD2016 NVARCHAR VSTRING 2 0 2 CostType Cost Type   9 Да / Yes
PCD2017 NVARCHAR VSTRING 35 0 35 TransactionText Transaction Text      
PCD2018 NVARCHAR VSTRING 1 0 1 PurchasePriceUpdate Purchase Price Update      
PCD2019 NVARCHAR VSTRING 10 0 10 DistributionBase Distribution Base      
PCD2020 NUMERIC MONEY 28 8 20 AdjustedOrderPrice Adjusted Order Price      
PCD2021 NVARCHAR VSTRING 10 0 10 DeliveryDateBackorderedQty Delivery Date Backordered Qty      
PCD2022 NVARCHAR VSTRING 6 0 6 PurchaseCharge] Purchase Charge [%]      
PCD2023 NVARCHAR VSTRING 10 0 10 POForTrans Purchase Order for Transactions      
PCD2024 NUMERIC X_NUMERIC 20 8 12 DeliveredInvoiceQtySC Delivered/Invoice Quantity [SC Unit]      
PCD2025 NUMERIC X_NUMERIC 20 8 12 OrderQtySC] Order Quantity [SC Unit]      
PCD2026 NVARCHAR VSTRING 6 0 6 SubProjectCode Sub-Project Code      
PCD2027 NVARCHAR VSTRING 6 0 6 ActivityCode Activity Code      
PCD2028 NVARCHAR VSTRING 6 0 6 RateVATCode Rate/Vat Code   10 Да / Yes
PCD2029 NVARCHAR VSTRING 6 0 6 TaxType Tax Type   11 Да / Yes
PCD2030 INT INTEGER 0 0 4 TaxArrayIndex Tax Array Index      
PCD2031 NVARCHAR VSTRING 25 0 25 AASCode AAS code   12 Да / Yes
PCD2032 NVARCHAR VSTRING 6 0 6 TaxCode Tax Code      
PCD2033 NVARCHAR VSTRING 6 0 6 TaxRate Tax Rate      
PCD2034 NUMERIC MONEY 28 8 20 LineAmountOCU Line Amount OCU      
PCD2035 NUMERIC MONEY 28 8 20 LineAmountOCUDisc Line Amount OCU with Discount      
PCD2036 NUMERIC MONEY 28 8 20 LineAmountLCU Line Amount LCU      
PCD2037 NUMERIC MONEY 28 8 20 LineAmountLCUDisc Line Amount LCU with Discount      
PCD2038 NUMERIC MONEY 28 8 20 TaxOCU Tax OCU      
PCD2039 NUMERIC MONEY 28 8 20 TaxOCUDisc Tax OCU with Discount      
PCD2040 NUMERIC MONEY 28 8 20 TaxLCU Tax LCU      
PCD2041 NUMERIC MONEY 28 8 20 TaxLCUDisc Tax LCU with Discount      
PCD2042 NUMERIC MONEY 28 8 20 DiscountOCU Discount OCU      
PCD2043 NUMERIC MONEY 28 8 20 DiscountLCU Discount LCU      
PCD2044 NVARCHAR VSTRING 25 0 25 NomenclatureNumber Nomenclature Number (NCM code)      
PCD2045 NCHAR STRING 3 0 3 GroupNum Group Number      
PCD2046 INT INTEGER 0 0 1 AdditionalInvoiceFlag Additional Invoice Flag   3 Да / Yes
PCD2047 NCHAR STRING 6 0 6 TaxCode2 Tax Code 2      

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