Таблица: SL01 - «Customer File». Маска имени таблицы: «SL01%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL01001 NCHAR STRING 10 0 10 CustomerCode Customer Code   1 Да
SL01002 NVARCHAR VSTRING 35 0 35 CustomerName Customer Name      
SL01003 NVARCHAR VSTRING 35 0 35 AddressLine1 Address Line 1      
SL01004 NVARCHAR VSTRING 35 0 35 AddressLine2 Address Line 2      
SL01005 NVARCHAR VSTRING 35 0 35 AddressLine3 Address Line 3      
SL01006 NVARCHAR VSTRING 20 0 20 Reference1 Reference 1      
SL01007 NVARCHAR VSTRING 20 0 20 Reference2 Reference 2      
SL01008 NVARCHAR VSTRING 20 0 20 Reference3 Reference 3      
SL01009 NVARCHAR VSTRING 20 0 20 Reference4 Reference 4      
SL01010 NVARCHAR VSTRING 4 0 4 Category Customer Category      
SL01011 NVARCHAR VSTRING 20 0 20 TelephoneNo Telephone Number      
SL01012 NVARCHAR VSTRING 10 0 10 TelexNo Telex Number      
SL01013 NVARCHAR VSTRING 20 0 20 TelefaxNo Telefax Number      
SL01014 NVARCHAR VSTRING 1 0 1 ReminderBlockFlag Reminder Block      
SL01015 NVARCHAR VSTRING 1 0 1 ChargeInterestFlag Charge Interest      
SL01016 NVARCHAR VSTRING 6 0 6 InterestLatePayment Interest Late Payment %      
SL01017 NVARCHAR VSTRING 50 0 50 AccountString Accounting String      
SL01018 NVARCHAR VSTRING 20 0 20 HighestAmountCreditLimit Highest Credit Limit This is the highest credit limit that has bee n given to the customer, this is normally automatically updated by the system.    
SL01019 NVARCHAR VSTRING 2 0 2 PriceListProject Price List Project      
SL01020 NVARCHAR VSTRING 19 0 19 Spare (obsolete)      
SL01021 NVARCHAR VSTRING 20 0 20 TaxRegNo Tax Registration Number      
SL01022 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
SL01023 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
SL01024 NVARCHAR VSTRING 2 0 2 TermsofPayment Payment Terms      
SL01025 NVARCHAR VSTRING 1 0 1 AutoGiroCustomerFlag Autogiro Customer      
SL01026 NVARCHAR VSTRING 2 0 2 TermsofDelivery Delivery Terms      
SL01027 NVARCHAR VSTRING 2 0 2 WayofDelivery Delivery Method      
SL01028 NVARCHAR VSTRING 1 0 1 MergeInvoiceFlag Consolidated Invoice      
SL01029 NVARCHAR VSTRING 2 0 2 PriceList Price List      
SL01030 NVARCHAR VSTRING 1 0 1 Import\ExportCustomerFlag Export Code      
SL01031 NVARCHAR VSTRING 1 0 1 ExtendedTAXHandlingFlag Extended Tax Handling Only used in US (country code 1) and indicates if external application for tax handling shall be used for the customer.    
SL01032 NVARCHAR VSTRING 2 0 2 SalesAccountCode Accounting Code      
SL01033 NVARCHAR VSTRING 1 0 1 FrequencyCode Frequency Code      
SL01034 NVARCHAR VSTRING 1 0 1 ABCCode ABC Code      
SL01035 NVARCHAR VSTRING 3 0 3 Salesman Salesman      
SL01036 NVARCHAR VSTRING 2 0 2 DiscountCode Discount Code      
SL01037 NVARCHAR VSTRING 20 0 20 AmountCreditLimit Credit Limit      
SL01038 NUMERIC MONEY 28 8 20 Balance Balance      
SL01039 NVARCHAR VSTRING 20 0 20 AmountPrevYearLCU Sales Previous Year      
SL01040 NVARCHAR VSTRING 20 0 20 AmountYTDLCU Sales YTD      
SL01041 NVARCHAR VSTRING 20 0 20 AmountPeriodLCU Sales Period      
SL01042 NVARCHAR VSTRING 20 0 20 ProfitPrevYear Profit Previous Year      
SL01043 NVARCHAR VSTRING 20 0 20 ProfitYTD Profit YTD      
SL01044 NVARCHAR VSTRING 20 0 20 ProfitPeriod Profit Period      
SL01045 NVARCHAR VSTRING 20 0 20 AmountBudget Budget      
SL01046 NVARCHAR VSTRING 6 0 6 InvoicesYTD No of Invoices YTD      
SL01047 NVARCHAR VSTRING 20 0 20 AmountChargedInterestYTD Charged Interest YTD      
SL01048 NVARCHAR VSTRING 6 0 6 DaysNoTotalDuePayments Total Days Due Payment      
SL01049 NVARCHAR VSTRING 4 0 4 InvoicesTotal Number of Invoices      
SL01050 DATETIME DATE 0 0 8 DateLastInvoice Last Invoice Date      
SL01051 DATETIME DATE 0 0 8 DateLastPayment Last Payment Date      
SL01052 NVARCHAR VSTRING 25 0 25 Remark1 Internal Note 1      
SL01053 NVARCHAR VSTRING 25 0 25 Remark2 Internal Note 2      
SL01054 NVARCHAR VSTRING 35 0 35 AlphaSearchKey Customer Search Key      
SL01055 NVARCHAR VSTRING 3 0 3 ReminderNo Number of Reminders      
SL01056 NVARCHAR VSTRING 10 0 10 MainCustomerCode Main Customer Code      
SL01057 NVARCHAR VSTRING 20 0 20 AmountOrderedNotShippedLCU Ordered Not Shipped      
SL01058 NVARCHAR VSTRING 20 0 20 AmountShippedNotInvoicedLCU Shipped Not Invoiced      
SL01059 NVARCHAR VSTRING 1 0 1 CustomerCollectionFlag Collection Customer      
SL01060 NVARCHAR VSTRING 1 0 1 ShipmentBlockFlag Delivery Block      
SL01061 NVARCHAR VSTRING 1 0 1 InvoicesPrintedFlag Number of Invoices Printed      
SL01062 NVARCHAR VSTRING 20 0 20 AmountPrevYear-1 Sales Previous Year - 1      
SL01063 NVARCHAR VSTRING 20 0 20 ProfitPrevYear-1 Profit Previous Year - 1      
SL01064 NVARCHAR VSTRING 2 0 2 NumberOfOrdersInPeriod Number of Orders Period      
SL01065 NVARCHAR VSTRING 3 0 3 NumberOfOrdersYTD Number of Orders YTD      
SL01066 NVARCHAR VSTRING 9 0 9 MarketingSupport Marketing Support      
SL01067 NVARCHAR VSTRING 1 0 1 InternalActionFlag Frequency Flag Used internally to indicate if frequency code (SL01033) shall be increased or decreased next time the function for frequency analysis is executed. If the frequency flag is 1, some order activities has incurred for the customer since last time the function was executed, the frequency code will in this case be moved to a lower character (maximum A). If the frequency flag is 0, no activity has incurred and the frequency code will in this case be moved to a higher character (maximum P).    
SL01068 NVARCHAR VSTRING 1 0 1 CreditCode Credit Code User defined code that can be used as selection term on customer reports.    
SL01069 NVARCHAR VSTRING 2 0 2 District Customer District      
SL01070 NVARCHAR VSTRING 2 0 2 AdvertisingCode Customer Advertising Area      
SL01071 NVARCHAR VSTRING 4 0 4 CityCode Customer Area Code      
SL01072 NVARCHAR VSTRING 5 0 5 SNICode Customer Trade Code      
SL01073 NVARCHAR VSTRING 1 0 1 FeeInvoiceFlag Invoicing Fee (Local Currency)      
SL01074 NVARCHAR VSTRING 1 0 1 DistributionFeeFlag Distribution Fee Code      
SL01075 NVARCHAR VSTRING 1 0 1 AutoDeliveryBlockFlag Automatic Delivery Block This fields is normally update by the function for automatic credit hold.
1 - Documents can't be printed, deliveries can't be done
0 - No restrictions		    
SL01076 INT INTEGER 0 0 1 ServicePriority Customer Priority      
SL01077 NVARCHAR VSTRING 2 0 2 PriceListServiceOrder Price List Service Order      
SL01078 NVARCHAR VSTRING 13 0 13 ContainerNo Container Number      
SL01079 NVARCHAR VSTRING 35 0 35 DeliveryAddress EDI Delivery Address Number      
SL01080 NVARCHAR VSTRING 5 0 5 Bonus Bonus %      
SL01081 NVARCHAR VSTRING 20 0 20 AmountAllocatedBonusYTD Allocated Bonus YTD (Local Currency)      
SL01082 NVARCHAR VSTRING 20 0 20 AmountEarlySettlmentDiscountYTD Cash Discounts Taken YTD (Local Currency)      
SL01083 NVARCHAR VSTRING 10 0 10 ZipCode Zip Code      
SL01084 NVARCHAR VSTRING 10 0 10 Technician Technician      
SL01085 NVARCHAR VSTRING 1 0 1 DocumentLayout Document Layout      
SL01086 NVARCHAR VSTRING 2 0 2 AccrualCode Accrual Code      
SL01087 NVARCHAR VSTRING 2 0 2 CommissionCode Commission Code      
SL01088 NVARCHAR VSTRING 20 0 20 AmountNextYTD Sales Next YTD (Local Currency)      
SL01089 NVARCHAR VSTRING 20 0 20 AmountNextPeriod Sales Next Period (Local Currency)      
SL01090 NVARCHAR VSTRING 20 0 20 ProfitNextYTD Profit Next YTD (Local Currency)      
SL01091 NVARCHAR VSTRING 20 0 20 ProfitNextPeriod Profit Next Period (Local Currency)      
SL01092 NVARCHAR VSTRING 16 0 16 FiscalCode Fiscal Registration Code      
SL01093 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
SL01094 NVARCHAR VSTRING 34 0 34 BankAccountNo Bank Account Number      
SL01095 NVARCHAR VSTRING 1 0 1 OrganizationType Type of Organization      
SL01096 NVARCHAR VSTRING 1 0 1 IncludeOnTAXReportFlag Include in Tax Reports      
SL01097 NVARCHAR VSTRING 1 0 1 CashMethodOnSalesTAXReportFlag Use Cash Method for Tax      
SL01098 NVARCHAR VSTRING 6 0 6 DefaultWarehouse Default Warehouse      
SL01099 NVARCHAR VSTRING 35 0 35 AddressLine4 Address Line 4      
SL01100 NVARCHAR VSTRING 6 0 6 CommonWarehouse Common Warehouse      
SL01101 NVARCHAR VSTRING 1 0 1 PartialDeliveryFlag No Backorders 0 - Backorders and partial deliveries are allowed
1 - Backorders are not allowed, order can only take place if the whole order can be shipped at once.		    
SL01102 NVARCHAR VSTRING 1 0 1 PaymentLedgerFlag Payment Ledger      
SL01103 NVARCHAR VSTRING 4 0 4 Forwarder Forwarder      
SL01104 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      
SL01105 NVARCHAR VSTRING 1 0 1 MandatoryPurchaseOrderFlag Mandatory Purchase Order Number      
SL01106 NVARCHAR VSTRING 10 0 10 BlanketPONo Blanket Purchase Order Number      
SL01107 NVARCHAR VSTRING 2 0 2 TaxLiability Tax Liability/Vat Code 1 This field is dependent on company parameter 'Tax Calculation Rule' which can be either:
1 (yes) - Vat code is taken from the customer, in this case the field will hold the default vat code to be used for the customer.
0 (no) - Vat code is taken from the stock item, in this case the field will be a yes/no (1/0) switch indicating if the customer is liable for vat or not.		    
SL01108 NVARCHAR VSTRING 2 0 2 TAXCode2 VAT Code 2      
SL01109 NVARCHAR VSTRING 200 0 200 CompleteCustomerName Complete Customer Name      
SL01110 NVARCHAR VSTRING 1 0 1 ReminderNo Number of Reminders The maximum number of reminders that shall be printed per invoice for the customer.    
SL01111 NVARCHAR VSTRING 12 0 12 PrePaymentAccount Pre-payment Account      
SL01112 NCHAR STRING 2 0 2 WayOfPayment Way of Payment 0 - No automatic payments
1 - Transfer to payment ledger (standard)
2 - German collection method 1
3 - German collection method 2
4 - PN/PDC domestic payments
5 - PN/PDC foreign payments		    
SL01113 NCHAR STRING 1 0 1 JurisdictionTAXCode Tax Jurisdiction Only used in US (country code 1) when integrating with external tax handling application.    
SL01114 NCHAR SWITCH 1 0 1 EDIContractFlag Electronic Partner 0 - The customer is not an electronic partner and printed documents are used when communicating with the customer.
1 - The customer is an electronic partner and electronic documents are primary used when communicating with the customer.		    
SL01115 NCHAR SWITCH 1 0 1 BlockOrderAcceptFlag Block Order Acceptance      
SL01116 NCHAR STRING 4 0 4 BillingCode Billing Terms      
SL01117 NCHAR STRING 1 0 1 DueDateMethodFlag Due Date Method      
SL01118 NCHAR STRING 1 0 1 TAXRoundingMethodFlag Tax Rounding Method 0 - Standard scala rounding
1 - Round-up to decimal in currency
2 - Round-down to decimal in currency
3 - Normal rounding		    
SL01119 NCHAR STRING 1 0 1 TAXCalculationMethodFlag Tax Calculation Method 0 - By order line
1 - By order total		    
SL01120 INT INTEGER 0 0 1 OtherTAXLiabilityFlag Other Tax Liabilities 0 - Extra tax defined for stock item will not be charged to the customer
1 - Extra tax defined for stock items will be charged to the customer		    
SL01121 INT INTEGER 0 0 1 DueDateBasedOnFlag Due Date Base On      
SL01122 INT INTEGER 0 0 1 TaxRecalculateFlag Tax Recalculation Allowed      
SL01123 NVARCHAR VSTRING 12 0 12 AccountTAXRecalculateP\L Tax Recalculation P&L Account      
SL01124 INT INTEGER 0 0 1 DraftCustomerFlag Draft Customer      
SL01125 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code The code that is used by the customer to identify us as supplier.    
SL01126 NCHAR STRING 10 0 10 ATPOrderPriorityRescheduling Ordering Priority ATP Rescheduling      
SL01127 NCHAR SWITCH 1 0 1 ATPAcceptOrderLineSplit Accept Order Line Split ATP      
SL01128 NCHAR SWITCH 1 0 1 ATPAcceptOrderSplit Accept Order Split ATP      
SL01129 NVARCHAR VSTRING 25 0 25 GlobalID Global ID      
SL01130 INT INTEGER 0 0 1 IBANActivationFlag IBAN Activation      
SL01131 INT INTEGER 0 0 9 DiscountSchemaCode Discount Scheme Code      
SL01132 DATETIME DATE 0 0 8 AdvancedGroupDiscountStartDate Group Discount Start Date      
SL01133 INT INTEGER 0 0 2 TimeIntervalValue Group Discount Time Interval      
SL01134 INT INTEGER 0 0 1 TimeIntervalUnits Group Discount Time Interval Unit 0 - Days
1 - Weeks
2 - Month
3 - Years		    
SL01135 NCHAR SWITCH 1 0 1 BatchPricingFlag Use Batch Pricing      
SL01136 INT INTEGER 0 0 1 IncludeQuotationFlag Include Quotations      
SL01137 NCHAR STRING 2 0 2 ContractPriceList Price List Contract      
SL01138 INT INTEGER 0 0 9 Calendar_Collection_Reference Calendar Collection      
SL01139 NCHAR STRING 2 0 2 TaxCode1 Reserved for VAT Code 1      
SL01140 NCHAR SWITCH 1 0 1 AllowSurchDistrib Allowance/Surcharge Distribution      
SL01141 NCHAR STRING 4 0 4 InvoiceIssuer Invoice Issuer Code      
SL01142 NCHAR SWITCH 1 0 1 InvoiceCategory Invoice Category      
SL01143 NCHAR STRING 6 0 6 TaxLiabilityCode Tax Liability Code      
SL01144 NVARCHAR VSTRING 10 0 10 EntityType Entity Type      
SL01145 NVARCHAR VSTRING 18 0 18 Spare Spare      
SL01146 NVARCHAR VSTRING 20 0 20 SubstRegNo Substitution Registration Number      
SL01147 NVARCHAR VSTRING 20 0 20 MunicRegNo Municipal Registration Number      
SL01148 NVARCHAR VSTRING 20 0 20 StateRegNo State Registration Number      
SL01149 NVARCHAR VSTRING 10 0 10 CustActType Customer Activity Type      
SL01150 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
SL01151 NVARCHAR VSTRING 10 0 10 FinOperationCode Fin Operation Code      
SL01152 NVARCHAR VSTRING 10 0 10 CityCode City Code      
SL01153 NVARCHAR VSTRING 2 0 2 CustGroupCode Customer Group Code      
SL01154 NVARCHAR VSTRING 1 0 1 FreightPayer Freight Payer      
SL01155 NVARCHAR VSTRING 2 0 2 CollectionPeriod Collection Period      
SL01156 NCHAR STRING 6 0 6 LTM Group LTM Group      
SL01157 NCHAR STRING 1 0 1 DropShipment Drop Shipment Flag      
SL01158 INT INTEGER 0 0 4 Delivery Note, sort Delivery Note, sort      
SL01159 NVARCHAR VSTRING 1 0 1 Auto print DN Auto print DN      
SL01160 NVARCHAR VSTRING 1 0 1 Auto send DN Auto send DN      
SL01161 NCHAR STRING 1 0 1 Need back-order Need back-order      
SL01162 INT INTEGER 0 0 1 Delivery note printing Delivery note printing      
SL01163 INT INTEGER 0 0 1 Invoice printing Invoice printing      
SL01164 NCHAR STRING 2 0 2 TaxIDType TaxIDType      
SL01165 NCHAR STRING 2 0 2 ResponsibilityType ResponsibilityType      
SL01166 NVARCHAR VSTRING 4 0 4 Harbour        
SL01167 NVARCHAR VSTRING 2 0 2 Bundesland        
SL01168 NVARCHAR VSTRING 6 0 6 StatManner        
SL01169 NVARCHAR VSTRING 2 0 2 CurrIdentNumber        
SL01170 NVARCHAR VSTRING 2 0 2 ECDepartment        
SL01171 NVARCHAR VSTRING 2 0 2 Regime        
SL01172 NVARCHAR VSTRING 1 0 1 AutoPrintInvoice Auto print Invoice      
SL01173 NVARCHAR VSTRING 1 0 1 AutoSendInvoice Auto send Invoice      
SL01174 INT INTEGER 0 0 2 FixPaymentDay1 Fix Payment Day 1      
SL01175 INT INTEGER 0 0 2 FixPaymentDay2 Fix Payment Day 2      
SL01176 INT INTEGER 0 0 2 FixPaymentDay3 Fix Payment Day 3      
SL01177 INT INTEGER 0 0 2 PaymntExcludMonth Paymnt Exclud Month      
SL01178 NVARCHAR VSTRING 1 0 1 ReleaseForDN Release For DN      
SL01179 NCHAR STRING 2 0 2 ExtendedCommissionCode Extended Commission Code      
SL01180 NVARCHAR VSTRING 6 0 6 TaxType Tax Type This field should contain the tax (VAT) type.    
SL01181 NCHAR SWITCH 1 0 1 TaxSurcharge Tax Surcharge      
SL01182 NCHAR SWITCH 1 0 1 Merge RIBA Merge RIBA      
SL01183 NVARCHAR VSTRING 2 0 2 Payment Address Code Payment Address Code      
SL01184 NVARCHAR VSTRING 2 0 2 Invoice Address Code Invoice Address Code      
SL01185 NVARCHAR VSTRING 2 0 2 Invoice Sent Address Code Invoice Sent Address Code      
SL01186 NVARCHAR VSTRING 25 0 25 ExcContrCode Excise Control Code Excise Control Code    
SL01187 NVARCHAR VSTRING 25 0 25 ExcRegNo Excise Registration Number Excise Registration Number    
SL01188 NVARCHAR VSTRING 25 0 25 CentSalesTaxRegNo Central Sales Tax Registration Number Central Sales Tax Registration Number    

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Ledger | Customer File