Таблица: ORT1 - «Sales Order Tax Transactions». Маска имени таблицы: «ORT1%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ORT1001 | NVARCHAR | VSTRING | 15 | 0 | 15 | OrderLineNo | Order Line Number | 2 | Да | |
ORT1002 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | 3 | Да | |
ORT1003 | NVARCHAR | VSTRING | 1 | 0 | 1 | TransactType | Transaction Type | 4 | Да | |
ORT1004 | NVARCHAR | VSTRING | 2 | 0 | 2 | TaxCode/RateCode | TaxCode/RateCode | 7 | Да | |
ORT1005 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | 8 | Да | |
ORT1006 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date | |||
ORT1007 | NUMERIC | MONEY | 28 | 8 | 20 | BaseAmount | Base Amount | |||
ORT1008 | NUMERIC | MONEY | 28 | 8 | 20 | TaxAmount | Tax Amount | |||
ORT1009 | NVARCHAR | VSTRING | 4 | 0 | 4 | Remark | Remark | 5 | Да | |
ORT1010 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransactionNo | Transaction Number | 9 | Да | |
ORT1011 | NVARCHAR | VSTRING | 1 | 0 | 1 | CashMethod | Cash Method | |||
ORT1012 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNoOld | Invoice Number Old (Italian Cash Method) | |||
ORT1013 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date Old (Italian Cash Method) | |||
ORT1014 | NVARCHAR | VSTRING | 1 | 0 | 1 | IntVersOfFile | Internal Table Version | |||
ORT1015 | NVARCHAR | VSTRING | 1 | 0 | 1 | ExpandedMacro | Expanded Macro | |||
ORT1016 | NVARCHAR | VSTRING | 1 | 0 | 1 | Reported | Reported | |||
ORT1017 | NVARCHAR | VSTRING | 1 | 0 | 1 | TransNature | Transaction Nature | |||
ORT1018 | NVARCHAR | VSTRING | 8 | 0 | 8 | SalesTaxPercent | Sales Tax Percent | |||
ORT1019 | NCHAR | STRING | 6 | 0 | 6 | TaxCode | Tax Code | |||
ORT1020 | NCHAR | STRING | 6 | 0 | 6 | TaxType | Tax Type | 6 | Да | |
ORT1021 | NCHAR | STRING | 5 | 0 | 5 | TransactLineNo | Transaction Line Number | 10 | Да | |
ORT1022 | NCHAR | STRING | 6 | 0 | 6 | TaxLiability | Tax Liability Code | |||
ORT1023 | NCHAR | STRING | 2 | 0 | 2 | TaxClassifCode | Tax Classification Code | |||
ORT1024 | NCHAR | STRING | 15 | 0 | 15 | TaxCertificate | Tax Certificate | |||
ORT1025 | NCHAR | STRING | 2 | 0 | 2 | PaymentNumber | Payment Number | |||
ORT1026 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockItem | Stock Item Code | |||
ORT1027 | NVARCHAR | VSTRING | 12 | 0 | 12 | OrigBatchNumber | Original Batch Number | |||
ORT1028 | INT | INTEGER | 0 | 0 | 2 | TaxCalculMethod | Tax Calculation Method | |||
ORT1029 | NCHAR | STRING | 1 | 0 | 1 | RateType | Rate Type | |||
ORT1030 | INT | INTEGER | 0 | 0 | 2 | TaxBase | Tax Base Type | |||
ORT1031 | NCHAR | STRING | 1 | 0 | 1 | TaxExemption | Tax Exemption Type | |||
ORT1032 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TaxExemptionRate | Tax Exemption Rate | |||
ORT1033 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | TaxRate | Tax Rate | |||
ORT1034 | NVARCHAR | VSTRING | 10 | 0 | 10 | TributarySitCode | Tributary Situation Code | |||
ORT1035 | NVARCHAR | VSTRING | 10 | 0 | 10 | CVFCode | CVF Code | |||
ORT1036 | NVARCHAR | VSTRING | 10 | 0 | 10 | SalesOrderNo | Sales Order Number | 1 | Да | |
ORT1037 | NVARCHAR | VSTRING | 10 | 0 | 10 | FiscTextCode | Fiscal Text Code | |||
ORT1038 | NUMERIC | MONEY | 28 | 8 | 20 | STBase | Tributary Substitution Amount (Local Currency) | |||
ORT1039 | NUMERIC | MONEY | 28 | 8 | 20 | STAmount | Tributary Substitution Amount (Local Currency) | |||
ORT1040 | NVARCHAR | VSTRING | 10 | 0 | 10 | TaxCategory | Tax Category | |||
ORT1041 | NVARCHAR | VSTRING | 2 | 0 | 2 | OriginalCompany | Original Company | |||
ORT1042 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MarginPercent | Margin Percent | |||
ORT1043 | NUMERIC | MONEY | 28 | 8 | 20 | FixedPrice | Fixed Price (Local Currency) | |||
ORT1044 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AcceptedDifference | Accepted Difference | |||
ORT1045 | NVARCHAR | VSTRING | 40 | 0 | 40 | ResolutionName | Resolution Name | |||
ORT1046 | DATETIME | DATE | 0 | 0 | 8 | ResolutionDate | Resolution Date | |||
ORT1047 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceRefer | InvoiceRefer | |||
ORT1048 | NVARCHAR | VSTRING | 2 | 0 | 2 | OrigCurrCode | Original Currency Code | This field should contain the invoice currency code. | ||
ORT1049 | NUMERIC | MONEY | 28 | 8 | 20 | BaseAmountOCU | Base Amount (Original Currency) | This field should contain the base amount in original currency. | ||
ORT1050 | NVARCHAR | VSTRING | 6 | 0 | 6 | VATType | VAT Type | This field should contain the VAT type. | ||
ORT1051 | NVARCHAR | VSTRING | 50 | 0 | 50 | Accounting Info | Accounting Info | |||
ORT1052 | NVARCHAR | VSTRING | 5 | 0 | 5 | Line Ref SL04 | Line Ref SL04 | |||
ORT1053 | NVARCHAR | VSTRING | 4 | 0 | 4 | Financial Year | Financial Year | |||
ORT1054 | NVARCHAR | VSTRING | 8 | 0 | 8 | Ref GL06 | Ref GL06 | |||
ORT1055 | NVARCHAR | VSTRING | 1 | 0 | 1 | Direct from GL | Direct from GL | |||
ORT1056 | NVARCHAR | VSTRING | 6 | 0 | 6 | SurchTaxCode | Surcharge Tax Code | This field should contain the surcharge tax code linked to usual VAT |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Order | Sales Order Tax Transactions