Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: 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 | |||
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 | CostAccount | (Italian functionality to properly booked VAT) |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | System Utilities/Office Autom. | Vat Codes/Tax Rate Codes