Таблица: SL17 - «VAT Transactions». Маска имени таблицы: «SL17%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SL17001 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 1 | Да | |
SL17002 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | 2 | Да | |
SL17003 | NVARCHAR | VSTRING | 1 | 0 | 1 | TransactType | Transaction Type | X - Tax transaction created at the time of invoice (To be used for non cash tax method).
Y - Tax transaction created at the time of payment. (To be used for cash tax method). Z - Tax transaction for tax portion of discount for early payments. (Note that both X and Y transaction type are created regardless if you use cash method or not). |
3 | Да |
SL17004 | NVARCHAR | VSTRING | 2 | 0 | 2 | VATCode | VAT Code | 6 | Да | |
SL17005 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | 7 | Да | |
SL17006 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date | |||
SL17007 | NUMERIC | MONEY | 28 | 8 | 20 | BaseAmount | Base Amount (Local Currency) | |||
SL17008 | NUMERIC | MONEY | 28 | 8 | 20 | TaxAmount | Tax Amount (Local Currency) | |||
SL17009 | NVARCHAR | VSTRING | 4 | 0 | 4 | Remark | Remark | |||
SL17010 | NVARCHAR | VSTRING | 9 | 0 | 9 | TransactioNo | Transaction Number | 8 | Да | |
SL17011 | NVARCHAR | VSTRING | 1 | 0 | 1 | CashMethod | Cash Method | |||
SL17012 | NVARCHAR | VSTRING | 15 | 0 | 15 | OrderLineId | Order Line plus Subline or CostId | |||
SL17013 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDateOld | Invoice Date Old (Italian Cash Method) | |||
SL17014 | NVARCHAR | VSTRING | 1 | 0 | 1 | IntVersOfFile | Internal Table Version | Used internally in earlier versions of Scala to specify the version of the table. | ||
SL17015 | NVARCHAR | VSTRING | 1 | 0 | 1 | ExpandedMacro | Expanded Macro | Indicates if the transaction has expanded as a result of a VAT macro. This will be done when printing the VAT statement. | ||
SL17016 | NVARCHAR | VSTRING | 1 | 0 | 1 | Reported | Reported | |||
SL17017 | NVARCHAR | VSTRING | 1 | 0 | 1 | TransNature | Transaction Nature | 0 - Goods
1 - Service |
||
SL17018 | NVARCHAR | VSTRING | 8 | 0 | 8 | SalesTaxPercent | Tax Percent | |||
SL17019 | NCHAR | STRING | 6 | 0 | 6 | TaxCode | Tax Code | 4 | Да | |
SL17020 | NCHAR | STRING | 6 | 0 | 6 | TaxType | Tax Type | 5 | Да | |
SL17021 | NCHAR | STRING | 7 | 0 | 7 | TransactLineNo | Line Number | 9 | Да | |
SL17022 | NCHAR | STRING | 6 | 0 | 6 | TaxLiability | Tax Liability Code | |||
SL17023 | NCHAR | STRING | 2 | 0 | 2 | TaxClassifCode | Tax Classification Code | |||
SL17024 | NCHAR | STRING | 15 | 0 | 15 | TaxCertificate | Tax Certificate | |||
SL17025 | NCHAR | STRING | 2 | 0 | 2 | PaymentNumber | Payment Number | |||
SL17026 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockItem | Stock Item Code | |||
SL17027 | NVARCHAR | VSTRING | 12 | 0 | 12 | OrigBatchNumber | Batch Number | |||
SL17028 | INT | INTEGER | 0 | 0 | 2 | TaxCalculMethod | Tax Calculation Method | Used for tax engine 1 and 2 (see SYL1003 for details) | ||
SL17029 | NCHAR | STRING | 1 | 0 | 1 | RateType | Rate Type | Used for tax engine 1 and 2 (see SYL1006 for details) | ||
SL17030 | INT | INTEGER | 0 | 0 | 2 | TaxBase | Tax Base Type | Used for tax engine 1 and 2 (see SYL1004 for details) | ||
SL17031 | NCHAR | STRING | 2 | 0 | 2 | TaxExemption | Tax Exemption Type | Used for tax engine 1 and 2 (see SLL1006 for details) | ||
SL17032 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TaxExemptionRate | Tax Exemption Rate | |||
SL17033 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | TaxRate | Tax Rate | |||
SL17034 | NVARCHAR | VSTRING | 10 | 0 | 10 | TributarySitCode | Tributary Situation Code | |||
SL17035 | NVARCHAR | VSTRING | 10 | 0 | 10 | CVFCode | CVF Code | |||
SL17036 | NVARCHAR | VSTRING | 10 | 0 | 10 | SalesOrderNo | Sales Order Number | |||
SL17037 | NVARCHAR | VSTRING | 10 | 0 | 10 | FiscTextCode | Fiscal Text Code | |||
SL17038 | NUMERIC | MONEY | 28 | 8 | 20 | STBase | Exemption Amount (Local Currency) | |||
SL17039 | NUMERIC | MONEY | 28 | 8 | 20 | STAmount | Tributary Substitution Amount (Local Currency) | |||
SL17040 | NVARCHAR | VSTRING | 10 | 0 | 10 | TaxCategory | Tax Category | Only used in brazil and Argentina, to classify the type of tax. | ||
SL17041 | NVARCHAR | VSTRING | 2 | 0 | 2 | OriginalCompany | Original Company | |||
SL17042 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MarginPercent | Margin % | |||
SL17043 | NUMERIC | MONEY | 28 | 8 | 20 | FixedPrice | Fixed Price (Local Currency) | |||
SL17044 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AcceptedDifference | Accepted Difference % | |||
SL17045 | NVARCHAR | VSTRING | 40 | 0 | 40 | ResolutionName | Resolution Name | |||
SL17046 | DATETIME | DATE | 0 | 0 | 8 | ResolutionDate | Resolution Date | |||
SL17047 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceRefer | InvoiceRefer | This field can be filled in the records related to the Prepayments.
The reference to Invoice for the same customer code must be added for all “compensative” prepayment tax records. |
||
SL17048 | NVARCHAR | VSTRING | 2 | 0 | 2 | OrigCurrCode | Original Currency Code | This field should contain the invoice currency code. | ||
SL17049 | NUMERIC | MONEY | 28 | 8 | 20 | BaseAmountOCU | Base Amount (Original Currency) | This field should contain the base amount in original currency. | ||
SL17050 | NVARCHAR | VSTRING | 6 | 0 | 6 | VATType | VAT Type | This field should contain the VAT type. | ||
SL17051 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccountingInfo | Accounting Info | |||
SL17052 | NVARCHAR | VSTRING | 7 | 0 | 7 | LineRefSL04 | Line Ref SL04 | |||
SL17053 | NVARCHAR | VSTRING | 4 | 0 | 4 | FinYear | Financial Year | |||
SL17054 | NVARCHAR | VSTRING | 9 | 0 | 9 | RefGL06 | Ref GL06 | |||
SL17055 | NVARCHAR | VSTRING | 1 | 0 | 1 | DirectfromGL | Direct from GL | |||
SL17056 | NVARCHAR | VSTRING | 6 | 0 | 6 | SurchTaxCode | Surcharge Tax Code | This field should contain the surcharge tax code linked to usual VAT | ||
SL17057 | NVARCHAR | VSTRING | 25 | 0 | 25 | AASCode | AAS code | |||
SL17058 | NCHAR | STRING | 12 | 0 | 12 | OrderLineNo | Order Line Number | Order Line Number | ||
SL17059 | NVARCHAR | VSTRING | 25 | 0 | 25 | ReferPLInvoice | Reference to PL Invoice | |||
SL17060 | NVARCHAR | VSTRING | 10 | 0 | 10 | ReferPLSupplier | ReferPLSupplier | ReferPLSupplier for Italian VAT self-invoices | ||
SL17061 | NUMERIC | MONEY | 28 | 8 | 20 | ActualTaxBase | Actual Tax Base | |||
SL17062 | NUMERIC | MONEY | 28 | 8 | 20 | FreightTaxAmount | Freight Tax Amount | |||
SL17063 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | Destination Rate | Destination Rate |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger | VAT Transactions