One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказы на Продажу»/List of tables of module «Sales Order»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table ORT1 — Sales Order Tax Transactions

Таблица / Table: ORT1 — «Sales Order Tax Transactions». Маска имени таблицы / Table name mask: «ORT1%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 TaxCodeRateCode 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 60 0 60 InvoiceNoOld Invoice Number Old (Italian Cash Method) Also is used to store invoice line ID    
ORT1013 DATETIME DATE 0 0 8 InvoiceDateOld 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 2 0 2 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 ACCSTR 120 0 120 AccountingInfo Accounting Info      
ORT1052 NVARCHAR VSTRING 7 0 7 LineRefSL04 Line Ref SL04      
ORT1053 NVARCHAR VSTRING 4 0 4 FinYear Financial Year      
ORT1054 NVARCHAR VSTRING 9 0 9 RefGL06 Ref GL06      
ORT1055 NVARCHAR VSTRING 1 0 1 DirectfromGL 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 12 0 12 OrderLineNum Order Line Number Order Line Number    
ORT1059 NVARCHAR VSTRING 25 0 25 ReferPLInvoice Reference to PL Invoice      
ORT1060 NVARCHAR VSTRING 10 0 10 ReferPLSupplier ReferPLSupplier ReferPLSupplier for Italy VAT self-invoices    
ORT1061 NUMERIC MONEY 28 8 20 ActualTaxBase Actual Tax Base      
ORT1062 NUMERIC MONEY 28 8 20 FreightTaxAmount Freight Tax Amount      
ORT1063 NUMERIC X_NUMERIC 16 8 8 DestinationRate Destination Rate      
ORT1064 NVARCHAR VSTRING 30 0 30 TaxDescription Tax Description      
ORT1065 NVARCHAR VSTRING 6 0 6 InvoiceLineNo Invoice Line No      
ORT1066 NUMERIC MONEY 28 8 20 TaxAmountOCU Tax Amount OCU      

Навигация / Navigation: