Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

Таблица: SL17 - «VAT Transactions». Маска имени таблицы: «SL17%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL17001 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   1 Да
SL17002 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   2 Да
SL17003 NVARCHAR VSTRING 1 0 1 TransactType 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 Да
SL17004 NVARCHAR VSTRING 2 0 2 Tax_Code/TaxRateCode VAT Code   6 Да
SL17005 DATETIME DATE 0 0 8 TransactDate Transaction Date   7 Да
SL17006 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SL17007 NUMERIC MONEY 28 8 20 BaseAmount Base Amount (Local Currency)      
SL17008 NUMERIC MONEY 28 8 20 TaxAmount Tax Amount (Local Currency)      
SL17009 NVARCHAR VSTRING 4 0 4 Remark Remark      
SL17010 NVARCHAR VSTRING 6 0 6 TransactioNo Transaction Number   8 Да
SL17011 NVARCHAR VSTRING 1 0 1 CashMethod Cash Method      
SL17012 NVARCHAR VSTRING 15 0 15 InvoiceNoOld Invoice Number Old (Italian Cash Method)      
SL17013 DATETIME DATE 0 0 8 InvoiceDate Invoice Date Old (Italian Cash Method)      
SL17014 NVARCHAR VSTRING 1 0 1 IntVersOfFile Internal Table Version Used internally in earlier versions of Scala to specify the version of the table.    
SL17015 NVARCHAR VSTRING 1 0 1 ExpandedMacro Expanded Macro Indicates if the transaction has expanded as a result of a VAT macro. This will be done when printing the VAT statement.    
SL17016 NVARCHAR VSTRING 1 0 1 Reported Reported      
SL17017 NVARCHAR VSTRING 1 0 1 TransNature Transaction Nature 0 - Goods
1 - Service		    
SL17018 NVARCHAR VSTRING 8 0 8 SalesTaxPercent Tax Percent      
SL17019 NCHAR STRING 6 0 6 TaxCode Tax Code   4 Да
SL17020 NCHAR STRING 6 0 6 TaxType Tax Type   5 Да
SL17021 NCHAR STRING 5 0 5 TransactLineNo Line Number   9 Да
SL17022 NCHAR STRING 6 0 6 TaxLiability Tax Liability Code      
SL17023 NCHAR STRING 2 0 2 TaxClassifCode Tax Classification Code      
SL17024 NCHAR STRING 15 0 15 TaxCertificate Tax Certificate      
SL17025 NCHAR STRING 2 0 2 PaymentNumber Payment Number      
SL17026 NVARCHAR VSTRING 35 0 35 StockItem Stock Item Code      
SL17027 NVARCHAR VSTRING 12 0 12 OrigBatchNumber Batch Number      
SL17028 INT INTEGER 0 0 2 TaxCalculMethod Tax Calculation Method Used for tax engine 1 and 2 (see SYL1003 for details)    
SL17029 NCHAR STRING 1 0 1 RateType Rate Type Used for tax engine 1 and 2 (see SYL1006 for details)    
SL17030 INT INTEGER 0 0 2 TaxBase Tax Base Type Used for tax engine 1 and 2 (see SYL1004 for details)    
SL17031 NCHAR STRING 1 0 1 TaxExemption Tax Exemption Type Used for tax engine 1 and 2 (see SLL1006 for details)    
SL17032 NUMERIC X_NUMERIC 20 8 12 TaxExemptionRate Tax Exemption Rate      
SL17033 NUMERIC X_NUMERIC 16 8 8 TaxRate Tax Rate      
SL17034 NVARCHAR VSTRING 10 0 10 TributarySitCode Tributary Situation Code      
SL17035 NVARCHAR VSTRING 10 0 10 CVFCode CVF Code      
SL17036 NVARCHAR VSTRING 10 0 10 SalesOrderNo Sales Order Number      
SL17037 NVARCHAR VSTRING 10 0 10 FiscTextCode Fiscal Text Code      
SL17038 NUMERIC MONEY 28 8 20 STBase Exemption Amount (Local Currency)      
SL17039 NUMERIC MONEY 28 8 20 STAmount Tributary Substitution Amount (Local Currency)      
SL17040 NVARCHAR VSTRING 10 0 10 TaxCategory Tax Category Only used in brazil and Argentina, to classify the type of tax.    
SL17041 NVARCHAR VSTRING 2 0 2 OriginalCompany Original Company      
SL17042 NUMERIC X_NUMERIC 20 8 12 MarginPercent Margin %      
SL17043 NUMERIC MONEY 28 8 20 FixedPrice Fixed Price (Local Currency)      
SL17044 NUMERIC X_NUMERIC 20 8 12 AcceptedDifference Accepted Difference %      
SL17045 NVARCHAR VSTRING 40 0 40 ResolutionName Resolution Name      
SL17046 DATETIME DATE 0 0 8 Resolution Date Resolution Date      

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Sales Ledger | VAT Transactions