На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Продаж»/List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table SL08 — Sales Ledger Parameters

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL08001 NVARCHAR VSTRING 1 0 1 IndexID Index ID   1 Да / Yes
SL08002 NUMERIC X_NUMERIC 9 8 1 InternIntRate Internal Interest Rate %      
SL08003 NUMERIC X_NUMERIC 9 8 1 PaymTransNo Payment Transaction Number      
SL08004 NUMERIC X_NUMERIC 9 8 1 TransacNoInv Invoice Transaction Number      
SL08005 NUMERIC X_NUMERIC 9 8 1 TransNoPayJournal Transaction Number Payment Journal      
SL08006 NUMERIC X_NUMERIC 9 8 1 TransNoInvJournal Transaction Number Invoice Journal      
SL08007 NUMERIC X_NUMERIC 9 8 1 InterCalcModel Interest Calculation Model      
SL08008 NUMERIC X_NUMERIC 15 8 7 InterestRate Penalty Interest Rate      
SL08009 NUMERIC X_NUMERIC 15 8 7 MinInterAmnt Minimum Interest Amount (Local Currency)      
SL08010 NUMERIC X_NUMERIC 14 8 6 InvCntrInterest Interest Invoice Number      
SL08011 NUMERIC X_NUMERIC 10 8 2 IntInvCopies Number of Interest Invoice Copies      
SL08012 NUMERIC X_NUMERIC 10 8 2 PaymentTerm Payment Term for Interest Invoices      
SL08013 NUMERIC X_NUMERIC 15 8 7 InvFeeInterest Invoicing Fee for Interest Invoices      
SL08014 NUMERIC X_NUMERIC 10 8 2 RemindHoldDay Reminder Hold Days      
SL08015 NUMERIC X_NUMERIC 10 8 2 ReminderPers Period Between Reminders      
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 Allowed Difference for Question      
SL08019 NUMERIC X_NUMERIC 15 8 7 RemAmntAutomat Allowed Difference for Automatic Accept      
SL08020 NUMERIC X_NUMERIC 14 8 6 AverageMargin Average Margin %      
SL08021 NCHAR SWITCH 1 0 1 DeductGracePeriod Deduct Grace Period from Interest Calculation      
SL08022 NUMERIC X_NUMERIC 9 8 1 VATRate2 VAT Rate 2      
SL08023 NUMERIC X_NUMERIC 9 8 1 VATRate3 VAT Rate 3      
SL08024 NUMERIC X_NUMERIC 9 8 1 VATRate4 VAT Rate 4      
SL08025 NUMERIC X_NUMERIC 9 8 1 VATRate5 VAT Rate 5      
SL08026 NUMERIC X_NUMERIC 9 8 1 VATRate6 VAT Rate 6      
SL08027 NUMERIC X_NUMERIC 9 8 1 VATRate7 VAT Rate 7      
SL08028 NUMERIC X_NUMERIC 9 8 1 VATRate8 VAT Rate 8      
SL08029 NUMERIC X_NUMERIC 9 8 1 VATRate9 VAT Rate 9      
SL08030 DATETIME DATE 0 0 8 RateDate1 Rate Date 1      
SL08031 NUMERIC X_NUMERIC 14 8 6 InteresRate1 Interest Rate 1      
SL08032 DATETIME DATE 0 0 8 RateDate2 Rate Date 2      
SL08033 NUMERIC X_NUMERIC 14 8 6 InteresRate2 Interest Rate 2      
SL08034 DATETIME DATE 0 0 8 RateDate3 Rate Date 3      
SL08035 NUMERIC X_NUMERIC 14 8 6 InteresRate3 Interest Rate 3      
SL08036 NUMERIC X_NUMERIC 9 8 1 CntrPremCust Counter for Customer Codes (Permanent Customers)      
SL08037 NUMERIC X_NUMERIC 9 8 1 CntrTempCust Counter for Customer Codes (Temporary Customers)      
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 to enter/adjust Customer File      
SL08041 NUMERIC X_NUMERIC 10 8 2 AccntYear Financial Year Common Sales Ledger      
SL08042 NUMERIC X_NUMERIC 14 8 6 MergerInvoices Number for Consolidated invoices      
SL08043 NUMERIC X_NUMERIC 10 8 2 SalesTaxCode Sales Tax Code On-Account Payment      
SL08044 NUMERIC X_NUMERIC 11 8 3 InfFldCusQuery Information Field on Customer Query      
SL08045 NUMERIC X_NUMERIC 9 8 1 NoReminders Number of Reminder Copies      
SL08046 NUMERIC X_NUMERIC 11 8 3 GracePeriod Interest Grace Period      
SL08047 INT INTEGER 0 0 1 CashMethod Use Cash Method for Tax Accounting      
SL08048 INT INTEGER 0 0 1 UpdateVolume Update Statistics on Direct 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 Show Interest Due on Reminders      
SL08052 INT INTEGER 0 0 1 UpdGLPaymJrn Update GL with Payment Journal Totals      
SL08053 INT INTEGER 0 0 1 UpdGLInvJrn Update GL with Invoice Journal Totals      
SL08054 INT INTEGER 0 0 1 IntegratedGL Integrated with 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 Note Included in Due Amounts      
SL08058 INT INTEGER 0 0 1 InclPaidInv Include Paid Invoices in Statement      
SL08059 INT INTEGER 0 0 1 CustCodInvNo Customer Code + Invoice No as Transaction Text      
SL08060 INT INTEGER 0 0 1 CentralLedger Common Sales Ledger      
SL08061 INT INTEGER 0 0 1 OrdAmntCredCheck Include Ordered not Shipped Amount in Credit Check      
SL08062 INT INTEGER 0 0 1 SaveVatTrans Save Tax Transactions      
SL08063 INT INTEGER 0 0 1 ExtPaymInfo Extended Payment Info      
SL08064 INT INTEGER 0 0 1 ConnentedAVP Connected to AVP      
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 Tax      
SL08068 INT INTEGER 0 0 1 TaxPoint Point for Cash Method of Tax Accounting      
SL08069 INT INTEGER 0 0 1 cussw23 23      
SL08070 INT INTEGER 0 0 1 cussw24 24      
SL08071 NVARCHAR VSTRING 6 0 6 cusjou0 Invoices Journal Code      
SL08072 NVARCHAR VSTRING 6 0 6 cusjou1 Credit Notes Journal Code      
SL08073 NVARCHAR VSTRING 6 0 6 cusjou2 Internal Invoices Journal Code      
SL08074 NVARCHAR VSTRING 6 0 6 cusjou3 Periodical Transactions Journal Code      
SL08075 NVARCHAR VSTRING 6 0 6 cusjou4 Payments Journal Code      
SL08076 INT INTEGER 0 0 3 DaysPerYear Days per Year (Interest Calculation)      
SL08077 NUMERIC MONEY 28 8 20 RoundOffTolerance Rounding Tolerance Amount      
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 Billing Statement Number      
SL08082 NUMERIC X_NUMERIC 18 8 10 TAXVarianceSerNo Tax Correctional Invoice Number      
SL08083 NUMERIC X_NUMERIC 14 8 6 BillingProposCounter Billing Statement Number      
SL08084 NCHAR STRING 6 0 6 TaxCodeInvFee Tax Code for Invoicing Fee      
SL08085 NCHAR STRING 6 0 6 DefaultTaxCodeInsurance Default Tax Code for Insurance      
SL08086 NCHAR STRING 6 0 6 DefaultTaxCodePacking Default Tax Code for Packing      
SL08087 NCHAR STRING 6 0 6 TaxCodeInterest Default Tax Code for 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 Chanel      
SL08091 NCHAR STRING 12 0 12 AccDiscGroup1 Account Discount Customer/Product Group 1      
SL08092 NCHAR STRING 12 0 12 AccDiscGroup2 Account Discount Customer/Product Group 2      
SL08093 NCHAR STRING 12 0 12 AccDiscPromot Account Discount Temporary (Promotional)      
SL08094 NCHAR STRING 12 0 12 AccDiscLogist Account Discount Logistics      
SL08095 NCHAR STRING 6 0 6 DefTaxCodeDist Default Tax Code Distribution      
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 Exchange 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      
SL08101 INT INTEGER 0 0 1 DedRuleFinalInv Deduction Rule — Partial Invoice      
SL08102 INT INTEGER 0 0 1 TaxInfoInTransText Print Tax Code and Base Amount as text      
SL08103 INT INTEGER 0 0 1 SalesTransType Type of Sales Transaction      
SL08104 NCHAR STRING 6 0 6 DefaultTaxCode Default Tax Code      
SL08105 NVARCHAR VSTRING 15 0 15 TaxNoteNo Tax Note Number Counter    
SL08106 INT INTEGER 0 0 1 TaxNoteNoFlag Tax Note Number Flag      
SL08107 NUMERIC MONEY 28 8 20 MinAmntForFOCitems Minimum 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 Tax Liability Code for Interest      
SL08110 NCHAR SWITCH 1 0 1 LicenseFlag Default Customer License Flag      
SL08111 DATETIME DATE 0 0 8 LicensedFrom Customer Licensed from      
SL08112 DATETIME DATE 0 0 8 LicensedTo Customer Licensed to      
SL08113 INT INTEGER 0 0 1 TaxNoteDailyCounterFlag Use Daily Based Counter for Tax Notes 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 Tax Mode for Freight      
SL08126 INT INTEGER 0 0 2 MaxAcceptableCRCStatus Maximum Acceptable Credit Control Status      
SL08127 NCHAR SWITCH 1 0 1 MultiLevelCRC Multi-Level Credit Control Approval      
SL08128 NVARCHAR VSTRING 8 0 8 AuthApprGroup Credit Control Approval Group      
SL08129 INT INTEGER 0 0 1 CrLimitBoundary Credit Limit Boundary      
SL08130 INT INTEGER 0 0 1 OverdueBoundary Overdue Boundary      
SL08131 NCHAR SWITCH 1 0 1 MultiLevelCRCLine Multi-level Approval on Line Level      
SL08132 NUMERIC X_NUMERIC 28 8 20 CancelToleranceAmnt Tolerance for Cancel of Approval, Amount      
SL08133 NUMERIC X_NUMERIC 14 8 6 CancelTolerancePrc Tolerance for Cancel of Approval, Percent      
SL08134 NVARCHAR VSTRING 8 0 8 FixedApprGroup Fixed Level Credit Control Approval Group      
SL08135 NCHAR STRING 1 0 1 CurrExchRateDate Currency Exchange Rate Date      
SL08136 INT INTEGER 0 0 1 DefaultCustomerLifeCycleStatus Default Customer Life Cycle Status      

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