На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Purchase Ledger»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table PL17 — VAT Transactions

Таблица / Table: PL17 — «VAT Transactions». Маска имени таблицы / Table name mask: «PL17%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PL17001 NVARCHAR VSTRING 25 0 25 InvoiceNo Invoice Number   1 Да / Yes
PL17002 NVARCHAR VSTRING 10 0 10 CustomerCode Supplier Code   2 Да / Yes
PL17003 NVARCHAR VSTRING 1 0 1 TransType Transaction Type X — Tax transaction created at the time of invoice (To be used for non cash tax method).

Y — Tax transaction created at the time of payment. (To be used for cash tax method).

Z — Tax transaction for tax portion of discount for early payments.

(Note that both X and Y transaction type are created regardless if you use cash method or not).		 3 Да / Yes
PL17004 NVARCHAR VSTRING 2 0 2 TaxCodeTaxRate VAT Code   6 Да / Yes
PL17005 NVARCHAR VSTRING 7 0 7 LineNo Line Number   7 Да / Yes
PL17006 DATETIME DATE 0 0 8 TransDate Transaction Date   8 Да / Yes
PL17007 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
PL17008 NUMERIC MONEY 28 8 20 BaseAmount Base Amount (Local Currency)      
PL17009 NUMERIC MONEY 28 8 20 TaxAmount Tax Amount (Local Currency)      
PL17010 NVARCHAR VSTRING 4 0 4 Remark Remark      
PL17011 NVARCHAR VSTRING 9 0 9 TransNo Invoice Reference Number      
PL17012 NVARCHAR VSTRING 1 0 1 CashMethod Cash Method      
PL17013 NVARCHAR VSTRING 6 0 6 Deductable Deductible      
PL17014 NVARCHAR VSTRING 1 0 1 ExpandedMacro Expanded Macro      
PL17015 NVARCHAR VSTRING 1 0 1 Reported Reported      
PL17016 NUMERIC MONEY 28 8 20 DeductibleAm Deductible Amount      
PL17017 NUMERIC MONEY 28 8 20 BookedCostAmount Booked Cost Amount      
PL17018 NUMERIC MONEY 28 8 20 VATDiffAmount VAT Difference Amount      
PL17019 NVARCHAR VSTRING 9 0 9 TransactionNoLineNo Transaction Number   9 Да / Yes
PL17020 NCHAR STRING 6 0 6 TaxType Tax Type   5 Да / Yes
PL17021 NCHAR STRING 6 0 6 TaxLiability Tax Liability Code      
PL17022 NCHAR STRING 6 0 6 TaxCode Tax Code   4 Да / Yes
PL17023 NCHAR STRING 3 0 3 DocumentType Document Type      
PL17024 NCHAR STRING 2 0 2 TaxClassification Tax Classification      
PL17025 NVARCHAR VSTRING 15 0 15 TaxCertificate Tax Certificate      
PL17026 NCHAR STRING 1 0 1 TaxCertifFlag Tax Certificate Print Status      
PL17027 NCHAR STRING 2 0 2 PaymentNumber Payment Number      
PL17028 NCHAR STRING 2 0 2 PaymentSubNumber Payment Sub Number      
PL17029 NVARCHAR VSTRING 35 0 35 StockItem Stock Item Code      
PL17030 NVARCHAR VSTRING 12 0 12 OrigBatchNumber Batch Number      
PL17031 NUMERIC X_NUMERIC 20 8 12 TaxRate Tax Rate      
PL17032 INT INTEGER 0 0 2 TaxCalcMethod Tax Calculation Method Used for tax engine 1 and 2 (see SYL1003 for details)    
PL17033 NCHAR STRING 1 0 1 RateType Rate Type Used for tax engine 1 and 2 (see SYL1006 for details)    
PL17034 INT INTEGER 0 0 2 TaxBaseType Tax Base Type Used for tax engine 1 and 2 (see SYL1004 for details)    
PL17035 NCHAR STRING 2 0 2 TaxExemption Tax Exemption Used for tax engine 1 and 2 (see PLL1006 for details)    
PL17036 NUMERIC X_NUMERIC 20 8 12 TaxExemptionRate Tax Exemption Rate      
PL17037 NVARCHAR VSTRING 10 0 10 PurchOrderNo Purchase Order Number      
PL17038 NVARCHAR VSTRING 10 0 10 FiscTextCode Fiscal Text Code      
PL17039 NVARCHAR VSTRING 10 0 10 TributarySitCode Tributary Situation Code      
PL17040 NVARCHAR VSTRING 10 0 10 CVFCode CVF Code      
PL17041 NUMERIC MONEY 28 8 20 STBaseAmount Exemption Amount (Local Currency)      
PL17042 NUMERIC MONEY 28 8 20 STTaxAmount Tributary Substitution Amount (Local Currency)      
PL17043 NVARCHAR VSTRING 10 0 10 TaxCategory Tax Category      
PL17044 NVARCHAR VSTRING 2 0 2 OriginalCompany Original Company      
PL17045 NUMERIC X_NUMERIC 20 8 12 MarginPercent Margin %      
PL17046 NUMERIC MONEY 28 8 20 FixedPrice Fixed Price (Local Currency)      
PL17047 NUMERIC X_NUMERIC 20 8 12 AcceptedDifference Accepted Difference %      
PL17048 NVARCHAR VSTRING 40 0 40 ResolutionName Resolution Name      
PL17049 DATETIME DATE 0 0 8 ResolutionDate Resolution Date      
PL17050 NVARCHAR VSTRING 25 0 25 InvoiceRefer InvoiceRefer This field can be filled in the records related to the Prepayments.

The reference to Invoice for the same customer code must be added for all “compensative” prepayment tax records.		    
PL17051 NVARCHAR VSTRING 2 0 2 OrigCurrCode Original Currency Code This field should contain the original currency code.    
PL17052 NUMERIC MONEY 28 8 20 BaseAmountOCU Base Amount (Original Currency) This field should contain the tax base amount in original currency.    
PL17053 NVARCHAR VSTRING 15 0 15 TaxSlipNo Tax Slip No This field should contain the purchase tax slip number.    
PL17054 NVARCHAR VSTRING 6 0 6 TaxSlipLine Tax Slip Line This field should contain the purchase tax slip line.    
PL17055 NVARCHAR ACCSTR 120 0 120 AccountingInfo Accounting Info      
PL17056 NVARCHAR VSTRING 7 0 7 LineReference Line Reference      
PL17057 NVARCHAR VSTRING 4 0 4 FinYear Financial Year      
PL17058 NVARCHAR VSTRING 9 0 9 RefGL06 Ref GL06      
PL17059 NVARCHAR VSTRING 1 0 1 DirectfromGL Direct from GL      
PL17060 NCHAR STRING 6 0 6 IssuerCode Issuer Code Issuer Code    
PL17061 NCHAR STRING 10 0 10 OrderLineNo Order Line Number Order Line Number    
PL17062 NVARCHAR VSTRING 25 0 25 AASCode AAS code      
PL17063 NVARCHAR VSTRING 10 0 10 ThirdPartySupplier ThirdPartySupplier ThirdPartySupplier    
PL17064 NUMERIC MONEY 28 8 20 ProRataAmount ProRataAmount Italian functionality to story VAT deductible    
PL17065 NVARCHAR VSTRING 25 0 25 ReferSLInvoice Reference to SL Invoice      
PL17066 DATETIME DATE 0 0 8 CertificateDate Certificate Date      
PL17067 NUMERIC MONEY 28 8 20 NonDeductAm Non Deductible Amount      
PL17068 NVARCHAR VSTRING 6 0 6 OrderSubLineNo OrderSubLineNo OrderSubLineNo    
PL17069 NUMERIC MONEY 28 8 20 ActualTaxBase Actual Tax Base      
PL17070 NUMERIC X_NUMERIC 20 8 12 ActualTaxRate Actual Tax Rate      
PL17071 NUMERIC X_NUMERIC 16 8 8 DestinationRate Destination Rate      
PL17072 NCHAR STRING 2 0 2 CostType Cost Type      
PL17073 NVARCHAR VSTRING 4 0 4 HMRCPeriodKey HMRC Period Key Key of HMRC period to which this transaction line is included.    
PL17074 NCHAR STRING 3 0 3 TaxRegCountry Tax Registration Country      

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