One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «System Utilities/Office Autom.»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SY29 — Vat Codes/Tax Rate Codes

Таблица / Table: SY29 — «VAT Codes». Маска имени таблицы / Table name mask: «SY29%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SY29001 NVARCHAR VSTRING 2 0 2 VATCode Tax (VAT) Code   2 Да / Yes
SY29002 NVARCHAR VSTRING 25 0 25 Description Description      
SY29003 NVARCHAR VSTRING 6 0 6 Percentage Tax Rate %      
SY29004 NVARCHAR VSTRING 6 0 6 Deductible Deductible %      
SY29005 NVARCHAR VSTRING 1 0 1 VATRule VAT Rule 0 — TAX rate at time of creating the transaction is used.

1 — TAX recalculated using current TAX rate.		    
SY29006 NVARCHAR VSTRING 12 0 12 AccOutVAT Output Tax Account      
SY29007 NVARCHAR VSTRING 12 0 12 AccInpVAT Input Tax Account      
SY29008 NVARCHAR VSTRING 2 0 2 AccNoNeBaDebPL Accumulator Net Amount Debit (Output)      
SY29009 NVARCHAR VSTRING 2 0 2 AccNoNeBaCreSL Accumulator Net Amount Credit (Input)      
SY29010 NVARCHAR VSTRING 2 0 2 AccNoGrBaDebPL Accumulator Gross Amount Debit (Output)      
SY29011 NVARCHAR VSTRING 2 0 2 AccNoGrBaCreSL Accumulator Gross Amount Credit (Input)      
SY29012 NVARCHAR VSTRING 2 0 2 AccNoVatDebPL Accumulator Tax Debit (Output)      
SY29013 NVARCHAR VSTRING 2 0 2 AccNoVatCreSL Accumulator Tax Credit (Input)      
SY29014 NVARCHAR VSTRING 1 0 1 VATMacro Tax Macro Indicate in which column on the TAX report this TAX rate shall be printed.

Used in few countries, depending on country code. ‘*’ indicates that Input/Output

TAX sums on supplier invoices are to be calculated and entered into accounts.		    
SY29015 NVARCHAR VSTRING 2 0 2 AccNoNeBaCrePL Accumulator Net Amount Debit (Input)      
SY29016 NVARCHAR VSTRING 2 0 2 AccNoNeBaDebSL Accumulator Net Amount Credit (Output)      
SY29017 NVARCHAR VSTRING 2 0 2 AccNoGrBaCrePL Accumulator Gross Amount Debit (Input)      
SY29018 NVARCHAR VSTRING 2 0 2 AccNoGrBaDebSL Accumulator Gross Amount Credit (Output)      
SY29019 NVARCHAR VSTRING 2 0 2 AccNoVatCrePL Accumulator Tax Debit (Input)      
SY29020 NVARCHAR VSTRING 2 0 2 AccNoVatDebSL Accumulator Tax Credit (Output)      
SY29021 NVARCHAR VSTRING 1 0 1 TaxOverride Tax Override      
SY29022 NVARCHAR VSTRING 1 0 1 InvestmenTax Investment Tax      
SY29023 NVARCHAR VSTRING 5 0 5 InvestmeTax Investment Tax %      
SY29024 NVARCHAR VSTRING 12 0 12 AccOutVATEC Account Output VAT EC      
SY29025 NVARCHAR VSTRING 12 0 12 AccInVATEC Account Input VAT EC      
SY29026 NVARCHAR VSTRING 12 0 12 SLPrepayTaxAcc Customer Prepayment Tax Account      
SY29027 NCHAR STRING 6 0 6 TaxTypeCode Tax Type Code Only used for tax engine 1 or 2 (Latin America), for tax engine 0 this field will always be ‘ZZZZZZ’. 1 Да / Yes
SY29028 NUMERIC X_NUMERIC 20 8 12 PecentageNew Surcharge Tax Code      
SY29029 DATETIME DATE 0 0 8 ActualNewRate Date for New Rate Activation      
SY29030 NUMERIC MONEY 28 8 20 MinAmount Minimum Amount      
SY29031 NUMERIC MONEY 28 8 20 ExemtAmount Exemption Amount      
SY29032 NCHAR SWITCH 1 0 1 AmountDependRates Amount Depended Rates Flag      
SY29033 NVARCHAR VSTRING 1 0 1 FixAmountFlag Fixed Tax Amount Flag      
SY29034 NVARCHAR VSTRING 10 0 10 RateRule Rate Rule Code      
SY29035 NVARCHAR VSTRING 12 0 12 AccOutVATContr Control Account for Output Tax      
SY29036 NVARCHAR VSTRING 12 0 12 AccInVATContr Control Account for Input Tax      
SY29037 NVARCHAR VSTRING 8 0 8 LinkedTaxCode Linked Tax Code This field should contain the tax codes linked to the Internal EU.    
SY29038 NVARCHAR VSTRING 8 0 8 SurchTaxCode Surcharge Tax Code      
SY29039 NUMERIC MONEY 28 8 20 MaxAmount Maximum Tax Amount To limit the calculated tax amount by maximum tax amount.    
SY29040 NVARCHAR VSTRING 12 0 12 CostAccount Cost Account (Italian functionality to properly booked VAT)    
SY29041 NCHAR STRING 2 0 2 CostType Cost Type CostType    
SY29042 NCHAR STRING 1 0 1 CostAccounting Cost Accounting Cost Accounting {0,1}    
SY29043 NCHAR STRING 3 0 3 TaxReasonCode Tax Reason Code      
SY29044 NCHAR STRING 1 0 1 TaxReasonNecessity Tax Reason Necessity      

Навигация / Navigation: