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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SYL3001 NCHAR STRING 6 0 6 TaxLiabilityCode Tax Liability Code   1 Да
SYL3002 NCHAR STRING 6 0 6 TaxTypeCode Tax Type Code   2 Да
SYL3003 NCHAR STRING 1 0 1 RateOption Rate Option 0 - Use the tax rate code specified for the tax code
1 - Use the tax rate code specified for the tax liability code		    
SYL3004 NCHAR STRING 2 0 2 TaxRateCode Tax Rate Code      
SYL3005 NCHAR STRING 1 0 1 CalculationLevel Calculation Level Tax is calculated:
0 - On total base amount
1 - On unit price
2 - On line total		    
SYL3006 NCHAR STRING 1 0 1 ExemptionType 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		    
SYL3007 NUMERIC X_NUMERIC 20 8 12 ExemptionPercent Exemption Percent      
SYL3008 INT INTEGER 0 0 3 SortOrder Sort Order      
SYL3009 NVARCHAR VSTRING 10 0 10 TaxSituation Tax Situation Code      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | System Utilities/Office Autom. | Tax Liabilities