Таблица: SY29 - «VAT Codes». Маска имени таблицы: «SY29%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SY29001 NVARCHAR VSTRING 2 0 2 VAT_Code VAT Code/Tax Rate Code   2 Да
SY29002 NVARCHAR VSTRING 25 0 25 Description Description      
SY29003 NVARCHAR VSTRING 6 0 6 Percentage Percentage      
SY29004 NVARCHAR VSTRING 6 0 6 Deductible Deductible      
SY29005 NVARCHAR VSTRING 1 0 1 VAT_Rule 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 Acc_Out_VAT Account Output Tax      
SY29007 NVARCHAR VSTRING 12 0 12 Acc_Inp_VAT Account Input Tax      
SY29008 NVARCHAR VSTRING 2 0 2 AccNoNeBaDeb Accumulator Net Amount Debit (Output)      
SY29009 NVARCHAR VSTRING 2 0 2 AccNoNeBaCre Accumulator Net Amount Credit (Input)      
SY29010 NVARCHAR VSTRING 2 0 2 AccNoGrBaDeb Accumulator Gross Amount Debit (Output)      
SY29011 NVARCHAR VSTRING 2 0 2 AccNoGrBaCre Accumulator Gross Amount Credit (Input)      
SY29012 NVARCHAR VSTRING 2 0 2 AccNoVatDeb Accumulator Tax Debit (Output)      
SY29013 NVARCHAR VSTRING 2 0 2 AccNoVatCre Accumulator Tax Credit (Input)      
SY29014 NVARCHAR VSTRING 1 0 1 VAT_Macro VAT 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 AccNoNeBaCre Accumulator Net Amount Debit (Input)      
SY29016 NVARCHAR VSTRING 2 0 2 AccNoNeBaDeb Accumulator Net Amount Credit (Output)      
SY29017 NVARCHAR VSTRING 2 0 2 AccNoGrBaCre Accumulator Gross Amount Debit (Input)      
SY29018 NVARCHAR VSTRING 2 0 2 AccNoGrBaDeb Accumulator Gross Amount Credit (Output)      
SY29019 NVARCHAR VSTRING 2 0 2 AccNoVatCre Accumulator Tax Debit (Input)      
SY29020 NVARCHAR VSTRING 2 0 2 AccNoVatDeb Accumulator Tax Credit (Output)      
SY29021 NVARCHAR VSTRING 1 0 1 Tax_Override 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 Acc_Out_VAT_EC Account Output VAT EC      
SY29025 NVARCHAR VSTRING 12 0 12 Acc_In_VAT_EC Account Input VAT EC      
SY29026 NVARCHAR VSTRING 12 0 12 SLPrepayTaxAcc Account Customer Prepayment Tax      
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 Да
SY29028 NUMERIC X_NUMERIC 20 8 12 PecentageNew Percentage New      
SY29029 DATETIME DATE 0 0 8 ActualNewRate Date to Activate New Rate      
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      
SY29033 NVARCHAR VSTRING 1 0 1 FixAmountFlag Use Fixed Tax Amount      
SY29034 NVARCHAR VSTRING 10 0 10 RateRule Rate Rule Code      
SY29035 NVARCHAR VSTRING 12 0 12 Acc_Out_VAT_Contr Control Account for Output taxes      
SY29036 NVARCHAR VSTRING 12 0 12 Acc_In_VAT_Contr Control Account for Input taxes      
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      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | System Utilities/Office Autom. | Vat Codes/Tax Rate Codes