Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
На один уровень вверх / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SL17 — VAT Transactions

Таблица: 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 VATCode 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 9 0 9 TransactioNo Transaction Number   8 Да
SL17011 NVARCHAR VSTRING 1 0 1 CashMethod Cash Method      
SL17012 NVARCHAR VSTRING 60 0 60 OrderLineId Order Line plus Subline or CostId Also is used to store invoice line ID    
SL17013 DATETIME DATE 0 0 8 InvoiceDateOld 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 7 0 7 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 2 0 2 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 ResolutionDate Resolution Date      
SL17047 NVARCHAR VSTRING 15 0 15 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. 		   
SL17048 NVARCHAR VSTRING 2 0 2 OrigCurrCode Original Currency Code This field should contain the invoice currency code.    
SL17049 NUMERIC MONEY 28 8 20 BaseAmountOCU Base Amount (Original Currency) This field should contain the base amount in original currency.    
SL17050 NVARCHAR VSTRING 6 0 6 VATType VAT Type This field should contain the VAT type.    
SL17051 NVARCHAR VSTRING 50 0 50 AccountingInfo Accounting Info      
SL17052 NVARCHAR VSTRING 7 0 7 LineRefSL04 Line Ref SL04      
SL17053 NVARCHAR VSTRING 4 0 4 FinYear Financial Year      
SL17054 NVARCHAR VSTRING 9 0 9 RefGL06 Ref GL06      
SL17055 NVARCHAR VSTRING 1 0 1 DirectfromGL Direct from GL      
SL17056 NVARCHAR VSTRING 6 0 6 SurchTaxCode Surcharge Tax Code This field should contain the surcharge tax code linked to usual VAT    
SL17057 NVARCHAR VSTRING 25 0 25 AASCode AAS code      
SL17058 NCHAR STRING 12 0 12 OrderLineNo Order Line Number Order Line Number    
SL17059 NVARCHAR VSTRING 25 0 25 ReferPLInvoice Reference to PL Invoice      
SL17060 NVARCHAR VSTRING 10 0 10 ReferPLSupplier ReferPLSupplier ReferPLSupplier for Italian VAT self-invoices    
SL17061 NUMERIC MONEY 28 8 20 ActualTaxBase Actual Tax Base      
SL17062 NUMERIC MONEY 28 8 20 FreightTaxAmount Freight Tax Amount      
SL17063 NUMERIC X_NUMERIC 16 8 8 Destination Rate Destination Rate      
SL17064 NVARCHAR VSTRING 30 0 30 Tax Description Tax Description      
SL17065 NVARCHAR VSTRING 6 0 6 Invoice Line No Invoice Line No      
SL17066 NUMERIC MONEY 28 8 20 Tax Amount OCU Tax Amount OCU      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
SL17010 6 6 6 6 6 6 9 9 9 9 9 9 9 9
SL17012 15 15 15 15 15 15 15 15 15 15 15 15 60 60
SL17021 5 5 5 5 5 5 7 7 7 7 7 7 7 7
SL17031 1 1 1 1 1 1 1 1 1 1 2 2 2 2
SL17047 — — 15 15 15 15 15 15 15 15 15 15 15 15
SL17048 — — — — 2 2 2 2 2 2 2 2 2 2
SL17049 — — — — 28 20 28 20 28 20 28 20 28 20
SL17050 — — — — 6 6 6 6 6 6 6 6 6 6
SL17051 — — — — 50 50 50 50 50 50 50 50 50 50
SL17052 — — — — 5 5 7 7 7 7 7 7 7 7
SL17053 — — — — 4 4 4 4 4 4 4 4 4 4
SL17054 — — — — 8 8 9 9 9 9 9 9 9 9
SL17055 — — — — 1 1 1 1 1 1 1 1 1 1
SL17056 — — — — 6 6 6 6 6 6 6 6 6 6
SL17057 — — — — — — 25 25 25 25 25 25 25 25
SL17058 — — — — — — 10 10 10 10 12 12 12 12
SL17059 — — — — — — 15 15 15 15 25 25 25 25
SL17060 — — — — — — 10 10 10 10 10 10 10 10
SL17061 — — — — — — — — — — 28 20 28 20
SL17062 — — — — — — — — — — 28 20 28 20
SL17063 — — — — — — — — — — 16 8 16 8
SL17064 — — — — — — — — — — — — 30 30
SL17065 — — — — — — — — — — — — 6 6
SL17066 — — — — — — — — — — — — 28 20

Навигация: