Таблица: 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      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Ledger | Sales Ledger Parameters