Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: SL08 - «Sales Ledger Parameters». Маска имени таблицы: «SL08%cc%yy»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SL08001 | NVARCHAR | VSTRING | 1 | 0 | 1 | Index_ID | Index ID | 1 | Да | |
SL08002 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | InternIntRate | Internal Interest Rate % | |||
SL08003 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | PaymTransNo | (obsolete) | |||
SL08004 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | TransacNoInv | (obsolete) | |||
SL08005 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | TransNoPayJournal | (obsolete) | |||
SL08006 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | TransNoInvJournal | (obsolete) | |||
SL08007 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | InterCalcModel | Interest Calculation Model | |||
SL08008 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | InterestRate | Interest Rate % | |||
SL08009 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | MinInterAmnt | Minimum Interest Amount (Local Currency) | |||
SL08010 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | InvCntrInterest | (obsolete) | |||
SL08011 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | IntInvCopies | Number of Interest Invoice Copies | |||
SL08012 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | PaymentTerm | Payment Terms Interest Invoices | |||
SL08013 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | InvFeeInterest | Invoicing Fee Interest Invoices (Local Currency) | |||
SL08014 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | RemindHoldDay | Reminder Hold Days | |||
SL08015 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | ReminderPers | Reminder Period | |||
SL08016 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | ReminderCopies | Number of Reminder Copies | |||
SL08017 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | StatementPeriod | Statement Period | |||
SL08018 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | RemAmntQuest | Remaining Amount for Question (Local Currency) | |||
SL08019 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | RemAmntAutomat | Remaining Amount for Automatic (Local Currency) | |||
SL08020 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | AverageMargin | Average Margin % | |||
SL08021 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VAT_Rate_1 | (obsolete) | |||
SL08022 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VAT_Rate_2 | (obsolete) | |||
SL08023 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VAT_Rate_3 | (obsolete) | |||
SL08024 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VAT_Rate_4 | (obsolete) | |||
SL08025 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VAT_Rate_5 | (obsolete) | |||
SL08026 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VAT_Rate_6 | (obsolete) | |||
SL08027 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VAT_Rate_7 | (obsolete) | |||
SL08028 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VAT_Rate_8 | (obsolete) | |||
SL08029 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | VAT_Rate_9 | (obsolete) | |||
SL08030 | DATETIME | DATE | 0 | 0 | 8 | Rate_Date_1 | Rate From Date 1 | |||
SL08031 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | InteresRate1 | Interest Rate 1 | |||
SL08032 | DATETIME | DATE | 0 | 0 | 8 | Rate_Date_2 | Rate From Date 2 | |||
SL08033 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | InteresRate2 | Interest Rate 2 | |||
SL08034 | DATETIME | DATE | 0 | 0 | 8 | Rate_Date_3 | Rate From Date 3 | |||
SL08035 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | InteresRate3 | Interest Rate 3 | |||
SL08036 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | CntrPremCust | (obsolete) | |||
SL08037 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | CntrTempCust | (obsolete) | |||
SL08038 | NUMERIC | X_NUMERIC | 11 | 8 | 3 | InterestChrg | Interest Charged per Period in Days | |||
SL08039 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | ReminderChrg | Reminder Fee (Local Currency) | |||
SL08040 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | AccessLevel | Access Level | |||
SL08041 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | AccntYear | Accounting Year for Central Ledger | |||
SL08042 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | MergerInvoices | (obsolete) | |||
SL08043 | NUMERIC | X_NUMERIC | 10 | 8 | 2 | SalesTaxCode | VAT Code on Account Invoices | |||
SL08044 | NUMERIC | X_NUMERIC | 11 | 8 | 3 | InfFldCusQuery | Information Field on Customer Query | |||
SL08045 | NUMERIC | X_NUMERIC | 9 | 8 | 1 | No_Reminders | Number of Reminders | |||
SL08046 | NUMERIC | X_NUMERIC | 11 | 8 | 3 | Grace_Period | Interest Grace Period | |||
SL08047 | INT | INTEGER | 0 | 0 | 1 | Cash_Method | Use Cash Method for Tax | |||
SL08048 | INT | INTEGER | 0 | 0 | 1 | UpdateVolume | Update Volume on Ledger Entry | |||
SL08049 | INT | INTEGER | 0 | 0 | 1 | BasedInvDate | Statement Based on Invoice Date | |||
SL08050 | INT | INTEGER | 0 | 0 | 1 | CreditInterest | Credit Interest on early Payments | |||
SL08051 | INT | INTEGER | 0 | 0 | 1 | PrintDueInterest | Print Due Interest on Remainders | |||
SL08052 | INT | INTEGER | 0 | 0 | 1 | UpdGLPaymJrn | Update GL with Payment Journal | |||
SL08053 | INT | INTEGER | 0 | 0 | 1 | UpdGLInvJrn | Update GL with Invoice Journal | |||
SL08054 | INT | INTEGER | 0 | 0 | 1 | IntegratedGL | Integrated to General Ledger | |||
SL08055 | INT | INTEGER | 0 | 0 | 1 | AutoVouchNo | Automatic Transaction Numbers | |||
SL08056 | INT | INTEGER | 0 | 0 | 1 | UseGLVouCntr | Use General Ledger Transaction Number | |||
SL08057 | INT | INTEGER | 0 | 0 | 1 | InclCreditNotes | Credit Notes Included in Due Amount | |||
SL08058 | INT | INTEGER | 0 | 0 | 1 | InclPaidInv | Paid Invoiced included on Statement | |||
SL08059 | INT | INTEGER | 0 | 0 | 1 | CustCodInvNo | Customer Code + Invoice No as Transaction text | |||
SL08060 | INT | INTEGER | 0 | 0 | 1 | CentralLedger | Central Ledger | |||
SL08061 | INT | INTEGER | 0 | 0 | 1 | OrdValCredCh | Include Ordered Value in Credit Check | |||
SL08062 | INT | INTEGER | 0 | 0 | 1 | SaveVatTrans | Save Vat Transactions | |||
SL08063 | INT | INTEGER | 0 | 0 | 1 | ExtPaymInfo | Extended Payment Info | |||
SL08064 | INT | INTEGER | 0 | 0 | 1 | ConnentedAVP | Connected to AVP (US TAX) | |||
SL08065 | INT | INTEGER | 0 | 0 | 1 | TaxJurisdCode | Coding on Auto Payment Collection | |||
SL08066 | INT | INTEGER | 0 | 0 | 1 | cus_sw_20 | Tax Jurisdiction Code | |||
SL08067 | INT | INTEGER | 0 | 0 | 1 | PrepaymentTax | Prepayment VAT | |||
SL08068 | INT | INTEGER | 0 | 0 | 1 | TaxPoint | (obsolete) | |||
SL08069 | INT | INTEGER | 0 | 0 | 1 | cus_sw_23 | (obsolete) | |||
SL08070 | INT | INTEGER | 0 | 0 | 1 | cus_sw_24 | (obsolete) | |||
SL08071 | NVARCHAR | VSTRING | 6 | 0 | 6 | cus_jou_0 | (obsolete) | |||
SL08072 | NVARCHAR | VSTRING | 6 | 0 | 6 | cus_jou_1 | (obsolete) | |||
SL08073 | NVARCHAR | VSTRING | 6 | 0 | 6 | cus_jou_2 | (obsolete) | |||
SL08074 | NVARCHAR | VSTRING | 6 | 0 | 6 | cus_jou_3 | (obsolete) | |||
SL08075 | NVARCHAR | VSTRING | 6 | 0 | 6 | cus_jou_4 | (obsolete) | |||
SL08076 | INT | INTEGER | 0 | 0 | 3 | DaysPerYear | Days per Year Interest Calculation | |||
SL08077 | NUMERIC | MONEY | 28 | 8 | 20 | RoundOffTolerance | Rounding Tolerance limit (Local Currency) | |||
SL08078 | NVARCHAR | VSTRING | 12 | 0 | 12 | RoundOffProfitAcc | Rounding Tolerance Profit Account | |||
SL08079 | NVARCHAR | VSTRING | 12 | 0 | 12 | RoundOffLossAcc | Rounding Tolerance Loss Account | |||
SL08080 | NVARCHAR | VSTRING | 6 | 0 | 6 | PaymPropCounter | (obsolete) | |||
SL08081 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | SalesStatSerNo | (obsolete) | |||
SL08082 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | TAXVarianceSerNo | (obsolete) | |||
SL08083 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | BillingProposCounter | (obsolete) | |||
SL08084 | NCHAR | STRING | 6 | 0 | 6 | Tax Code Invoice Fee | Tax Code Invoice Fee | |||
SL08085 | NCHAR | STRING | 6 | 0 | 6 | Default Tax Code Insurance | Default Tax Code Insurance | |||
SL08086 | NCHAR | STRING | 6 | 0 | 6 | Default Tax Code Packing | Default Tax Code Packing | |||
SL08087 | NCHAR | STRING | 6 | 0 | 6 | Tax Code Interest | Tax Code Interest | |||
SL08088 | INT | INTEGER | 0 | 0 | 4 | Sales Transaction Type | Sales Transaction Type | |||
SL08089 | NCHAR | STRING | 12 | 0 | 12 | AccDiscCust | Account Discount Customer | |||
SL08090 | NCHAR | STRING | 12 | 0 | 12 | AccDiscChann | Account Discount Channel | |||
SL08091 | NCHAR | STRING | 12 | 0 | 12 | AccDiscGroup1 | Account Discount Product Group 1 | |||
SL08092 | NCHAR | STRING | 12 | 0 | 12 | AccDiscGroup2 | Account Discount Product Group 2 | |||
SL08093 | NCHAR | STRING | 12 | 0 | 12 | AccDiscPromot | Account Discount Promotional | |||
SL08094 | NCHAR | STRING | 12 | 0 | 12 | AccDiscLogist | Account Discount Logistics | |||
SL08095 | NCHAR | STRING | 6 | 0 | 6 | DefTaxCodeDist | Default Tax Code Distribution Fees | |||
SL08096 | NCHAR | STRING | 6 | 0 | 6 | DefTaxCodeAllow | Default Tax Code Allowance | |||
SL08097 | NCHAR | STRING | 6 | 0 | 6 | DefTaxCodeSurch | Default Tax Code Surcharge | |||
SL08098 | INT | INTEGER | 0 | 0 | 1 | AccGainsLosses | Accounting of Currency Gains/Losses | 0 = Only recognise gains/losses when invoices are fully settled, using current value
1 = Only recognise gains/losses when invoices are fully settled, using original value 2 = Recognise gains/losses on partial payment as unrealized. 3 = Recognise gains/losses on partial payment as realized. |
||
SL08099 | INT | INTEGER | 0 | 0 | 1 | PrpTaxAllocRule | Prepayment tax allocation rule | |||
SL08100 | INT | INTEGER | 0 | 0 | 1 | DedRulePartInv | Deduction Rule - Partial Invoice | |||
SL08101 | INT | INTEGER | 0 | 0 | 1 | DedRuleFinalInv | Deduction Rule - Final Invoice | |||
SL08102 | INT | INTEGER | 0 | 0 | 1 | TaxInfoInTransText | Tax Information in Transaction Text | |||
SL08103 | INT | INTEGER | 0 | 0 | 1 | SalesTransType | Sales Transaction Type | |||
SL08104 | NCHAR | STRING | 6 | 0 | 6 | DefaultTaxCode | DefaultTaxCode | |||
SL08105 | NVARCHAR | VSTRING | 15 | 0 | 15 | TaxNoteNo | TaxNoteNo | Counter | ||
SL08106 | INT | INTEGER | 0 | 0 | 1 | TaxNoteNoFlag | TaxNoteNoFlag | |||
SL08107 | NUMERIC | MONEY | 28 | 8 | 20 | MinAmntForFOCitems | Min amount for FOC items | Minimum amount for FOC items |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Ledger | Sales Ledger Parameters