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

Таблица | Table: SYL5 - «Tax Codes Lines». Маска имени таблицы | Table Name Mask: «SYL5%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SYL5001 NCHAR STRING 6 0 6 TaxCode Tax Code   1 Да / Yes
SYL5002 NCHAR STRING 6 0 6 TaxTypeCode Tax Type Code   2 Да / Yes
SYL5003 NCHAR STRING 2 0 2 TaxRateCode Tax Rate Code   3 Да / Yes
SYL5004 NCHAR STRING 4 0 4 TaxClassifCode Tax Classification Code      
SYL5005 NCHAR STRING 1 0 1 ExemptType Exemption Type The exemption is specified as:
0 - No tax exemption
1 - Reduced rate, defined as percentage of the standard rate specified for the rate code
2 - Reduced base, defined as percentage of the tax base amount		    
SYL5006 NCHAR STRING 1 0 1 RateOption Rate Option 0 - Use the tax rate code specified for the tax code (rate option on liability has higher priority)
1 - Use the tax rate code specified for the tax code (rate option regardless of rate option on liability)
1 - Use the tax rate code specified for the tax liability code		    
SYL5007 NUMERIC X_NUMERIC 20 8 12 ExemptionPercent Exemption Percent      
SYL5008 NVARCHAR VSTRING 10 0 10 TaxSituation Tax Situation Code      
SYL5009 NVARCHAR VSTRING 10 0 10 TsMarginCode Ts Margin Code      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | System Utilities/Office Autom. | Tax Codes Lines