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

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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PCD7001 NVARCHAR VSTRING 10 0 10 BrokerSupplierCode Broker Supplier Code   1 Да
PCD7002 NVARCHAR VSTRING 25 0 25 CustomsDeclarationNumber Customs Declaration Number   2 Да
PCD7003 NVARCHAR VSTRING 25 0 25 InvoiceNumber Invoice Number   5 Да
PCD7004 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code   4 Да
PCD7005 NVARCHAR VSTRING 1 0 1 TransactionType Transaction Type      
PCD7006 NVARCHAR VSTRING 2 0 2 RateCode Rate Code   12 Да
PCD7007 NVARCHAR VSTRING 7 0 7 LineNumber Line Number      
PCD7008 DATETIME DATE 0 0 8 TransactionDate Transaction Date      
PCD7009 DATETIME DATE 0 0 8 InvDate Invoice Date      
PCD7010 NUMERIC MONEY 28 8 20 BaseAmount Base Amount      
PCD7011 NUMERIC MONEY 28 8 20 TaxAmount Tax Amount      
PCD7012 NVARCHAR VSTRING 4 0 4 Remark Remark      
PCD7013 NVARCHAR VSTRING 9 0 9 TransactionNumber Transaction Number      
PCD7014 NVARCHAR VSTRING 1 0 1 CashMethod Cash Method      
PCD7015 NVARCHAR VSTRING 6 0 6 DeductiblePercent Deductible %      
PCD7016 NVARCHAR VSTRING 1 0 1 ExpandedMacro Expanded Macro      
PCD7017 NVARCHAR VSTRING 1 0 1 Reported Reported      
PCD7018 NUMERIC MONEY 28 8 20 DeductibleAmount Deductible Amount      
PCD7019 NUMERIC MONEY 28 8 20 BookedCostAmount Booked Cost Amount      
PCD7020 NUMERIC MONEY 28 8 20 VATDiffAmount VAT Diff Amount      
PCD7021 NVARCHAR VSTRING 9 0 9 LineNum Line Number      
PCD7022 NVARCHAR VSTRING 6 0 6 TaxType Tax Type   11 Да
PCD7023 NVARCHAR VSTRING 6 0 6 TaxLiability Tax Liability      
PCD7024 NCHAR STRING 6 0 6 TaxCode Tax Code   10 Да
PCD7025 NCHAR STRING 3 0 3 DocumentType Document Type      
PCD7026 NCHAR STRING 2 0 2 TaxClassification Tax Classification      
PCD7027 NVARCHAR VSTRING 15 0 15 TaxCertificate Tax Certificate      
PCD7028 NCHAR STRING 1 0 1 TaxCertifFlag TaxCertifFlag      
PCD7029 NCHAR STRING 2 0 2 PaymentNumber Payment Number      
PCD7030 NCHAR STRING 2 0 2 PaymentSubNumber Payment Sub-Number      
PCD7031 NVARCHAR VSTRING 35 0 35 StockItem Stock Item      
PCD7032 NVARCHAR VSTRING 12 0 12 OriginalBatchNumber Original Batch Number      
PCD7033 NUMERIC X_NUMERIC 20 8 12 TaxRate Tax Rate      
PCD7034 INT INTEGER 0 0 2 TaxCalculationMethod Tax Calculation Method      
PCD7035 NCHAR STRING 1 0 1 RateType Rate Type      
PCD7036 INT INTEGER 0 0 2 TaxBaseType Tax Base Type      
PCD7037 NCHAR STRING 2 0 2 TaxExemption Tax Exemption      
PCD7038 NUMERIC X_NUMERIC 20 8 12 TaxExemptionRate Tax Exemption Rate      
PCD7039 NVARCHAR VSTRING 10 0 10 PurchaseOrder Purchase Order Number   6 Да
PCD7040 NVARCHAR VSTRING 10 0 10 FiscalTextCode Fiscal Text Code      
PCD7041 NVARCHAR VSTRING 10 0 10 TributarySiteCode Tributary Site Code      
PCD7042 NVARCHAR VSTRING 10 0 10 CVFCode CVF Code      
PCD7043 NUMERIC MONEY 28 8 20 STBaseAmount ST Base Amount      
PCD7044 NUMERIC MONEY 28 8 20 STTaxAmount ST Tax Amount      
PCD7045 NVARCHAR VSTRING 10 0 10 TaxCategory Tax Category      
PCD7046 NVARCHAR VSTRING 2 0 2 OriginalCompany Original Company      
PCD7047 NUMERIC X_NUMERIC 20 8 12 MarginPercent Margin Percent      
PCD7048 NUMERIC MONEY 28 8 20 FixedPrice Fixed Price      
PCD7049 NUMERIC X_NUMERIC 20 8 12 AcceptedDifference Accepted Difference      
PCD7050 NVARCHAR VSTRING 40 0 40 ResolutionName Resolution Name      
PCD7051 DATETIME DATE 0 0 8 ResolutionDate Resolution Date      
PCD7052 NVARCHAR VSTRING 15 0 15 InvoiceReference Invoice Reference      
PCD7053 NVARCHAR VSTRING 2 0 2 OriginalCurrencyCode Original Currency Code      
PCD7054 NUMERIC MONEY 28 8 20 BaseAmountOCU Base Amount OCU      
PCD7055 NVARCHAR VSTRING 15 0 15 TaxSlipNo Tax Slip No      
PCD7056 NVARCHAR VSTRING 6 0 6 TaxSlipLine Tax Slip Line      
PCD7057 NVARCHAR VSTRING 50 0 50 AccountingInfo Accounting Info      
PCD7058 NVARCHAR VSTRING 7 0 7 LineReference Line Reference      
PCD7059 NVARCHAR VSTRING 4 0 4 FinYear Financial Year      
PCD7060 NVARCHAR VSTRING 9 0 9 RefGL06 Ref GL06      
PCD7061 NVARCHAR VSTRING 1 0 1 DirectfromGL Direct from GL      
PCD7062 NCHAR STRING 6 0 6 IssuerCode Issuer Code      
PCD7063 NCHAR STRING 10 0 10 OrderLineNum Order Line Number   7 Да
PCD7064 NVARCHAR VSTRING 25 0 25 AASCode AAS code      
PCD7065 NVARCHAR VSTRING 10 0 10 ThirdPartySupplier Third Party Supplier      
PCD7066 NUMERIC MONEY 28 8 20 ProRataAmount ProRataAmount      
PCD7067 NVARCHAR VSTRING 15 0 15 ReferenceSLInvoice Reference SL Invoice      
PCD7068 DATETIME DATE 0 0 8 CertificateDate Certificate Date      
PCD7069 NUMERIC MONEY 28 8 20 NonDeductibleAmount Non Deductible Amount      
PCD7070 NVARCHAR VSTRING 6 0 6 OrderSublineNo Order Subline No   9 Да
PCD7071 NUMERIC MONEY 28 8 20 ActualTaxBase Actual Tax Base      
PCD7072 NUMERIC X_NUMERIC 20 8 12 ActualTaxRate Actual Tax Rate      
PCD7073 INT INTEGER 0 0 1 AdditionalInvoiceFlag Additional Invoice Flag   3 Да
PCD7074 NUMERIC X_NUMERIC 16 8 8 Destination Rate Destination Rate      
PCD7075 NCHAR STRING 2 0 2 CostType Cost Type      

Навигация: