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

Таблица: SYL1 - «Tax Types». Маска имени таблицы: «SYL1%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SYL1001 NCHAR STRING 6 0 6 TaxTypeCode Tax Type Code   1 Да
SYL1002 NVARCHAR VSTRING 35 0 35 Description Description      
SYL1003 INT INTEGER 0 0 2 CalcMethod Calculation Method 0 - Tax Calculated at Invoice Time
1 - Withholding Tax at Invoice Time (Bases per Invoice)
2 - Withholding Tax at Settlement Time (per invoice, proportional on part payment)
3 - Withholding Tax Based on payments per Period
4 - Tax Calculated at Invoice Time, but Offset when good are sold
5 - Self assessment of tax at the time of settlement (per invoice)
6 - Withholding Tax Calculated at Settlement Time (per payment)
7 - Withholding Tax at Invoice Time (Bases Per Period)
8 - Self assessment at the time of invoice
9 - Self assessment at the time of payment (per period)
10 - Withholding Tax at Invoice Time (Bases Per Invoice) for Sales Cycle		    
SYL1004 INT INTEGER 0 0 2 TaxBase Tax Base Option 0 - Net Sales Value after discounts
1 - Sales Value before Discounts
2 - Net Sales Amount for another type of tax
3 - Tax Amount from another type of Tax
4 - Sales amount before discounts plus tax
5 - Custom Base
6 - Gross Sales Including Full Tax Before Exemptions
7 - Sales amount after discounts plus tax		    
SYL1005 NVARCHAR VSTRING 6 0 6 TaxTypeBase Tax Type Used for Base Amount      
SYL1006 NCHAR STRING 1 0 1 RateType Rate Type 0 - Rates defined as percentage of Tax that are added
1 - Rates defined as percentage of Tax that are included
2 - Inside Calculation. Price includes Taxes.
3 - Inside Calculation. Price does not include Taxes		    
SYL1007 NCHAR STRING 1 0 1 CashMethod Cash Method      
SYL1008 NCHAR STRING 1 0 1 CentrTaxCertCount Use Central Tax Certificate Counter      
SYL1009 NCHAR STRING 1 0 1 UseTaxUnit Use Taxing Units      
SYL1010 NVARCHAR VSTRING 10 0 10 CalculationRule Tax Rule/Jurisdiction Code      
SYL1011 NVARCHAR VSTRING 10 0 10 TaxCategory Tax Category      
SYL1012 NVARCHAR VSTRING 1 0 1 TributarySubstitution Is Tributary Substitution/Is Vat Usage depends on the type of tax engine used for the company where Is 'Tributary Substitution' is for tax engine 2 (brazil) and 'Is Vat' is for tax engine 1 (Argentina and other)    
SYL1013 NVARCHAR VSTRING 1 0 1 IncludeFeeInv Includes Invoice Fee      
SYL1014 NVARCHAR VSTRING 1 0 1 IncludeFreight Includes Freight      
SYL1015 NVARCHAR VSTRING 1 0 1 IncludePackExp Includes Packing Expenses      
SYL1016 NVARCHAR VSTRING 1 0 1 IncludeInsurance Includes Insurance      
SYL1017 NVARCHAR VSTRING 1 0 1 IncludeInternalF Includes Internal Freight      
SYL1018 NVARCHAR VSTRING 1 0 1 DiscountConsi Discount Option      
SYL1019 NUMERIC X_NUMERIC 16 8 8 ReducedBase Reduced Base      
SYL1020 NUMERIC X_NUMERIC 16 8 8 IncreaseBase Increase Base      

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | System Utilities/Office Autom. | Tax Types