Таблица | Table: ORT1 - «Sales Order Tax Transactions». Маска имени таблицы | Table Name Mask: «ORT1%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
ORT1001 NVARCHAR VSTRING 15 0 15 OrderLineNo Order Line Number   2 Да / Yes
ORT1002 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   3 Да / Yes
ORT1003 NVARCHAR VSTRING 1 0 1 TransactType Transaction Type   4 Да / Yes
ORT1004 NVARCHAR VSTRING 2 0 2 TaxCode/RateCode TaxCode/RateCode   7 Да / Yes
ORT1005 DATETIME DATE 0 0 8 TransactDate Transaction Date   8 Да / Yes
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 Да / Yes
ORT1010 NVARCHAR VSTRING 9 0 9 TransactionNo Transaction Number   9 Да / Yes
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 Да / Yes
ORT1021 NCHAR STRING 7 0 7 TransactLineNo Transaction Line Number   10 Да / Yes
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 Да / Yes
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 7 0 7 Line Ref SL04 Line Ref SL04      
ORT1053 NVARCHAR VSTRING 4 0 4 Financial Year Financial Year      
ORT1054 NVARCHAR VSTRING 9 0 9 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    
ORT1057 NVARCHAR VSTRING 25 0 25 AAScode AAS code      
ORT1058 NCHAR STRING 10 0 10 OrderLineNo Order Line Number Order Line Number    
ORT1059 NVARCHAR VSTRING 15 0 15 ReferPLInvoice Reference to PL Invoice      
ORT1060 NVARCHAR VSTRING 10 0 10 ReferPLSupplier ReferPLSupplier ReferPLSupplier for Italy VAT self-invoices    

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Sales Order | Sales Order Tax Transactions