Таблица: SL30 - «Tax details for Payments». Маска имени таблицы: «SL30%cc00»
| Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| SL30001 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | 1 | Да | ||
| SL30002 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | 2 | Да | ||
| SL30003 | NVARCHAR | VSTRING | 1 | 0 | 1 | TransactType | 3 | Да | ||
| SL30004 | NVARCHAR | VSTRING | 2 | 0 | 2 | TaxRateCode | 6 | Да | ||
| SL30005 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | 7 | Да | ||
| SL30006 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | ||||
| SL30007 | NUMERIC | MONEY | 28 | 8 | 20 | BaseAmount | ||||
| SL30008 | NUMERIC | MONEY | 28 | 8 | 20 | TaxAmount | ||||
| SL30009 | NVARCHAR | VSTRING | 4 | 0 | 4 | Remark | ||||
| SL30010 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransactioNo | 8 | Да | ||
| SL30011 | NVARCHAR | VSTRING | 1 | 0 | 1 | CashMethod | ||||
| SL30012 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNoOld | ||||
| SL30013 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | ||||
| SL30014 | NVARCHAR | VSTRING | 1 | 0 | 1 | IntVersOfFile | ||||
| SL30015 | NVARCHAR | VSTRING | 1 | 0 | 1 | ExpandedMacro | ||||
| SL30016 | NVARCHAR | VSTRING | 1 | 0 | 1 | Reported | ||||
| SL30017 | NVARCHAR | VSTRING | 1 | 0 | 1 | TransNature | ||||
| SL30018 | NVARCHAR | VSTRING | 8 | 0 | 8 | SalesTaxPercent | ||||
| SL30019 | NCHAR | STRING | 6 | 0 | 6 | TaxCode | 4 | Да | ||
| SL30020 | NCHAR | STRING | 6 | 0 | 6 | TaxType | 5 | Да | ||
| SL30021 | NCHAR | STRING | 5 | 0 | 5 | TransactLineNo | 9 | Да | ||
| SL30022 | NCHAR | STRING | 6 | 0 | 6 | TaxLiability | ||||
| SL30023 | NCHAR | STRING | 2 | 0 | 2 | TaxClassifCode | ||||
| SL30024 | NCHAR | STRING | 15 | 0 | 15 | TaxCertificate | ||||
| SL30025 | NCHAR | STRING | 2 | 0 | 2 | PaymentNumber | ||||
| SL30026 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockItem | ||||
| SL30027 | NVARCHAR | VSTRING | 12 | 0 | 12 | OrigBatchNumber | ||||
| SL30028 | INT | INTEGER | 0 | 0 | 2 | TaxCalculMethod | ||||
| SL30029 | NCHAR | STRING | 1 | 0 | 1 | RateType | ||||
| SL30030 | INT | INTEGER | 0 | 0 | 2 | TaxBase | ||||
| SL30031 | NCHAR | STRING | 1 | 0 | 1 | TaxExemption | ||||
| SL30032 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TaxExemptionRate | ||||
| SL30033 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | TaxRate | ||||
| SL30034 | NVARCHAR | VSTRING | 10 | 0 | 10 | TributarySitCode | ||||
| SL30035 | NVARCHAR | VSTRING | 10 | 0 | 10 | CVFCode | ||||
| SL30036 | NVARCHAR | VSTRING | 10 | 0 | 10 | SalesOrderNo | ||||
| SL30037 | NVARCHAR | VSTRING | 10 | 0 | 10 | FiscTextCode | ||||
| SL30038 | NUMERIC | MONEY | 28 | 8 | 20 | STBase | ||||
| SL30039 | NUMERIC | MONEY | 28 | 8 | 20 | STAmount | ||||
| SL30040 | NVARCHAR | VSTRING | 10 | 0 | 10 | TaxCategory | ||||
| SL30041 | NVARCHAR | VSTRING | 2 | 0 | 2 | OriginalCompany | ||||
| SL30042 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MarginPercent | ||||
| SL30043 | NUMERIC | MONEY | 28 | 8 | 20 | FixedPrice | ||||
| SL30044 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AcceptedDifference | ||||
| SL30045 | NVARCHAR | VSTRING | 40 | 0 | 40 | ResolutionName | ||||
| SL30046 | DATETIME | DATE | 0 | 0 | 8 | Resolution Date | ||||
| SL30047 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceRefer | InvoiceRefer |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Ledger | Tax details for Payments
/* */