Таблица: SL08 - «Sales Ledger Parameters». Маска имени таблицы: «SL08%cc%yy»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL08001 NVARCHAR VSTRING 1 0 1 IndexID 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 VATRate1 (obsolete)      
SL08022 NUMERIC X_NUMERIC 9 8 1 VATRate2 (obsolete)      
SL08023 NUMERIC X_NUMERIC 9 8 1 VATRate3 (obsolete)      
SL08024 NUMERIC X_NUMERIC 9 8 1 VATRate4 (obsolete)      
SL08025 NUMERIC X_NUMERIC 9 8 1 VATRate5 (obsolete)      
SL08026 NUMERIC X_NUMERIC 9 8 1 VATRate6 (obsolete)      
SL08027 NUMERIC X_NUMERIC 9 8 1 VATRate7 (obsolete)      
SL08028 NUMERIC X_NUMERIC 9 8 1 VATRate8 (obsolete)      
SL08029 NUMERIC X_NUMERIC 9 8 1 VATRate9 (obsolete)      
SL08030 DATETIME DATE 0 0 8 RateDate1 Rate From Date 1      
SL08031 NUMERIC X_NUMERIC 14 8 6 InteresRate1 Interest Rate 1      
SL08032 DATETIME DATE 0 0 8 RateDate2 Rate From Date 2      
SL08033 NUMERIC X_NUMERIC 14 8 6 InteresRate2 Interest Rate 2      
SL08034 DATETIME DATE 0 0 8 RateDate3 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 NoReminders Number of Reminders      
SL08046 NUMERIC X_NUMERIC 11 8 3 GracePeriod Interest Grace Period      
SL08047 INT INTEGER 0 0 1 CashMethod 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 OrdAmntCredCheck Include ordered not shipped amount 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 cussw20 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 cussw23 (obsolete)      
SL08070 INT INTEGER 0 0 1 cussw24 (obsolete)      
SL08071 NVARCHAR VSTRING 6 0 6 cusjou0 (obsolete)      
SL08072 NVARCHAR VSTRING 6 0 6 cusjou1 (obsolete)      
SL08073 NVARCHAR VSTRING 6 0 6 cusjou2 (obsolete)      
SL08074 NVARCHAR VSTRING 6 0 6 cusjou3 (obsolete)      
SL08075 NVARCHAR VSTRING 6 0 6 cusjou4 (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 TaxCodeInvFee Tax Code Invoice Fee      
SL08085 NCHAR STRING 6 0 6 DefaultTaxCodeInsurance Default Tax Code Insurance      
SL08086 NCHAR STRING 6 0 6 DefaultTaxCodePacking Default Tax Code Packing      
SL08087 NCHAR STRING 6 0 6 TaxCodeInterest Tax Code Interest      
SL08088 INT INTEGER 0 0 4 SalesTransactionType 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    
SL08108 INT INTEGER 0 0 1 TaxIntrFlag Tax on Interest Flag      
SL08109 NVARCHAR VSTRING 6 0 6 LiabilityCodeIntr Liability Code Interest      
SL08110 NCHAR SWITCH 1 0 1 LicenseFlag Default customer license flag      
SL08111 DATETIME DATE 0 0 8 LicensedFrom New customer licensed from      
SL08112 DATETIME DATE 0 0 8 LicensedTo New customer licensed to      
SL08113 INT INTEGER 0 0 1 TaxNoteDailyCounterFlag Tax Note Use Daily Counter Flag Use Daily based counter for Tax Notes    
SL08114 INT INTEGER 0 0 1 AdvInvoiceAmntApportionRule Advance Invoice Amount Apportion Rule      
SL08115 NCHAR SWITCH 1 0 1 BalanceInCredCheck Use customer balance in credit check      
SL08116 NCHAR SWITCH 1 0 1 OrdTaxInCredCheck Use order tax in credit check      
SL08117 NCHAR SWITCH 1 0 1 AddCostInCredCheck Use additional costs in credit check      
SL08118 NCHAR SWITCH 1 0 1 AddCostTaxInCrCheck Use taxes on additional costs on order in credit check      
SL08119 NCHAR SWITCH 1 0 1 AllcInCrCheck Use allocated amount in credit check      
SL08120 NCHAR SWITCH 1 0 1 AllcTaxInCrCheck Use taxes on allocated amount in credit check      
SL08121 NCHAR SWITCH 1 0 1 DelivInCrCheck Use shipped amount in credit check      
SL08122 NCHAR SWITCH 1 0 1 DlvTaxInCrCheck Use taxes on shipped amount in credit check      
SL08123 NCHAR SWITCH 1 0 1 AddShipCostInCredCheck Use additional costs on order (shipped) in credit check      
SL08124 NCHAR SWITCH 1 0 1 AddShipCostTaxInCrCheck Use taxes on additional costs on order (shipped) in credit check      
SL08125 NCHAR STRING 1 0 1 FreightTaxMode Taxes for Freight      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger | Sales Ledger Parameters