Не забудьте посетить страницу «Наши услуги» и заказать интеграцию 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»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SY29001 | NVARCHAR | VSTRING | 2 | 0 | 2 | VATCode | 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 | 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 | Account Output Tax | |||
SY29007 | NVARCHAR | VSTRING | 12 | 0 | 12 | AccInpVAT | Account Input Tax | |||
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 | 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 | 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 | 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 | AccOutVATContr | Control Account for Output taxes | |||
SY29036 | NVARCHAR | VSTRING | 12 | 0 | 12 | AccInVATContr | 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) | ||
SY29041 | NCHAR | STRING | 2 | 0 | 2 | CostType | CostType | CostType | ||
SY29042 | NCHAR | STRING | 1 | 0 | 1 | CostAccounting | Cost Accounting | Cost Accounting {0,1} | ||
SY29043 | NVARCHAR | VSTRING | 3 | 0 | 3 | TaxExemptionReasonCode | Tax Exemption Reason Code |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | System Utilities/Office Autom. | Vat Codes/Tax Rate Codes