Таблица: PCD2 - «Customs Declaration Lines». Маска имени таблицы: «PCD2%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PCD2001 | NVARCHAR | VSTRING | 10 | 0 | 10 | BrokerSupplierCode | Broker Supplier Code | 1 | Да | |
PCD2002 | NVARCHAR | VSTRING | 25 | 0 | 25 | CustomsDeclarationNumber | Customs Declaration Number | 2 | Да | |
PCD2003 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | 4 | Да | |
PCD2004 | NVARCHAR | VSTRING | 25 | 0 | 25 | InvoiceNumber | Invoice Number | 5 | Да | |
PCD2005 | NVARCHAR | VSTRING | 10 | 0 | 10 | PurchaseOrderNo | Purchase Order No | 6 | Да | |
PCD2006 | NVARCHAR | VSTRING | 12 | 0 | 12 | PurchaseOrderLineNo | Purchase Order Line No | 7 | Да | |
PCD2007 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccString | Accounting String | 8 | Да | |
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 | Да | |
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 | Да | |
PCD2029 | NVARCHAR | VSTRING | 6 | 0 | 6 | TaxType | Tax Type | 11 | Да | |
PCD2030 | INT | INTEGER | 0 | 0 | 4 | TaxArrayIndex | Tax Array Index | |||
PCD2031 | NVARCHAR | VSTRING | 25 | 0 | 25 | AASCode | AAS code | 12 | Да | |
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 | Да | |
PCD2047 | NCHAR | STRING | 6 | 0 | 6 | TaxCode2 | Tax Code 2 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Order | Customs Declaration Lines