Таблица: SL19 - «Standard Customers». Маска имени таблицы: «SL19%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL19001 NCHAR STRING 10 0 10 CustomerCode Customer Code   1 Да
SL19002 NVARCHAR VSTRING 35 0 35 CustomerName Customer Name      
SL19003 NVARCHAR VSTRING 35 0 35 AddressLine1 Address Line 1      
SL19004 NVARCHAR VSTRING 35 0 35 AddressLine2 Address Line 2      
SL19005 NVARCHAR VSTRING 35 0 35 AddressLine3 Address Line 3      
SL19006 NVARCHAR VSTRING 20 0 20 Reference1 Reference 1      
SL19007 NVARCHAR VSTRING 20 0 20 Reference2 Reference 2      
SL19008 NVARCHAR VSTRING 20 0 20 Reference3 Reference 3      
SL19009 NVARCHAR VSTRING 20 0 20 Reference4 Reference 4      
SL19010 NVARCHAR VSTRING 4 0 4 Category Customer Category      
SL19011 NVARCHAR VSTRING 20 0 20 TelephoneNo Telephone Number      
SL19012 NVARCHAR VSTRING 10 0 10 TelexNo Telex Number      
SL19013 NVARCHAR VSTRING 20 0 20 TelefaxNo Telefax Number      
SL19014 NVARCHAR VSTRING 1 0 1 ReminderBlck Reminder Block      
SL19015 NVARCHAR VSTRING 1 0 1 ChargeInterest Charge Interest      
SL19016 NVARCHAR VSTRING 6 0 6 IntLatPayment Interest Late Payment      
SL19017 NVARCHAR VSTRING 50 0 50 AccString Accounting String      
SL19018 NVARCHAR VSTRING 20 0 20 HighCredLimit Highest Credit Limit (Local Currency) This is the highest credit limit that has bee n given to the customer, this is normally automatically updated by the system.    
SL19019 NVARCHAR VSTRING 2 0 2 PriceListPrj Price List Project      
SL19020 NVARCHAR VSTRING 19 0 19 Spare (obsolete)      
SL19021 NVARCHAR VSTRING 15 0 15 SalesTaxCode Tax Registration Number      
SL19022 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
SL19023 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
SL19024 NVARCHAR VSTRING 2 0 2 PaymentTerm Payment Terms      
SL19025 NVARCHAR VSTRING 1 0 1 AutogiroCust Autogiro Customer      
SL19026 NVARCHAR VSTRING 2 0 2 DeliveryTerms Delivery Terms      
SL19027 NVARCHAR VSTRING 2 0 2 DeliveryWay Delivery Way      
SL19028 NVARCHAR VSTRING 1 0 1 MergeInvoice Consolidated Invoice      
SL19029 NVARCHAR VSTRING 2 0 2 PriceList Price List      
SL19030 NVARCHAR VSTRING 1 0 1 ImpExpCustomer Export Code      
SL19031 NVARCHAR VSTRING 1 0 1 ExtenTaxHand Extended Tax Handling Only used in US (country code 1) and indicates if external application for tax handling shall be used for the customer.    
SL19032 NVARCHAR VSTRING 2 0 2 AccCodeSales Accounting Code      
SL19033 NVARCHAR VSTRING 1 0 1 FrequencyCode Frequency Code      
SL19034 NVARCHAR VSTRING 1 0 1 ABCCode ABC Code      
SL19035 NVARCHAR VSTRING 3 0 3 SalesMan Salesman      
SL19036 NVARCHAR VSTRING 2 0 2 DiscountCode Discount Code      
SL19037 NVARCHAR VSTRING 20 0 20 CreditLimit Credit Limit (Local Currency)      
SL19038 NUMERIC MONEY 28 8 20 Balance Balance (Local Currency)      
SL19039 NVARCHAR VSTRING 20 0 20 SalePrevYear Sales Previous Year (Local Currency)      
SL19040 NVARCHAR VSTRING 20 0 20 SalesYTD Sales YTD (Local Currency)      
SL19041 NVARCHAR VSTRING 20 0 20 SalesPeriod Sales Period (Local Currency)      
SL19042 NVARCHAR VSTRING 20 0 20 ProfPrevYear Profit Previous Year (Local Currency)      
SL19043 NVARCHAR VSTRING 20 0 20 ProfitYTD Profit YTD (Local Currency)      
SL19044 NVARCHAR VSTRING 20 0 20 ProfitPeriod Profit Period (Local Currency)      
SL19045 NVARCHAR VSTRING 20 0 20 Budget Budget (Local Currency)      
SL19046 NVARCHAR VSTRING 6 0 6 No_of_InvYTD Number of Invoices YTD      
SL19047 NVARCHAR VSTRING 20 0 20 ChrgInterYTD Charged Interest YTD (Local Currency)      
SL19048 NVARCHAR VSTRING 6 0 6 TotDayDuePay Total Days Due Payment      
SL19049 NVARCHAR VSTRING 4 0 4 NoOfInvoices Number of Invoices      
SL19050 DATETIME DATE 0 0 8 LastInvDate Last Invoice Date      
SL19051 DATETIME DATE 0 0 8 LastPaymDate Last Payment Date      
SL19052 NVARCHAR VSTRING 25 0 25 Remark1 Internal Note 1      
SL19053 NVARCHAR VSTRING 25 0 25 Remark2 Internal Note 2      
SL19054 NVARCHAR VSTRING 35 0 35 AlphaSrchKey Customer Search Key      
SL19055 NVARCHAR VSTRING 3 0 3 ReminderNo Number of Reminders      
SL19056 NVARCHAR VSTRING 10 0 10 MainCustCode Main Customer Code      
SL19057 NVARCHAR VSTRING 20 0 20 OrdNotShiLoC Ordered Not Shipped (Local Currency)      
SL19058 NVARCHAR VSTRING 20 0 20 ShiNotInvLoC Shipped Not Invoiced (Local Currency)      
SL19059 NVARCHAR VSTRING 1 0 1 CollectCust Collection Customer      
SL19060 NVARCHAR VSTRING 1 0 1 ShipmentBlck Delivery Block      
SL19061 NVARCHAR VSTRING 1 0 1 InvPrinted Number of Invoices Printed      
SL19062 NVARCHAR VSTRING 20 0 20 SalePrevYear Sales Previous Year - 1 (Local Currency)      
SL19063 NVARCHAR VSTRING 20 0 20 ProfPrevYear Profit Previous Year - 1 (Local Currency)      
SL19064 NVARCHAR VSTRING 2 0 2 OrderPerioNo Number of Orders Period      
SL19065 NVARCHAR VSTRING 3 0 3 OrderYTDNo Number of Orders YTD      
SL19066 NVARCHAR VSTRING 9 0 9 MarketingSupport Marketing Support (Local Currency)      
SL19067 NVARCHAR VSTRING 1 0 1 InterActFlag Internal Action Flag      
SL19068 NVARCHAR VSTRING 1 0 1 CreditCode Credit Code User defined code that can be used as selection term on customer reports.    
SL19069 NVARCHAR VSTRING 2 0 2 District Customer District      
SL19070 NVARCHAR VSTRING 2 0 2 AdvertCode Customer Advertising Area      
SL19071 NVARCHAR VSTRING 4 0 4 CityCode Customer Area Code      
SL19072 NVARCHAR VSTRING 5 0 5 SNI_Code Customer Trade Code      
SL19073 NVARCHAR VSTRING 1 0 1 InvoicingFee Invoicing Fee (Local Currency)      
SL19074 NVARCHAR VSTRING 1 0 1 DistributFee Distribution Fee Code      
SL19075 NVARCHAR VSTRING 1 0 1 AutoDelivBlck 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
   
SL19076 NVARCHAR VSTRING 1 0 1 ServicePriority Customer Priority      
SL19077 NVARCHAR VSTRING 2 0 2 PriLisSerOrd Price List Service Order      
SL19078 NVARCHAR VSTRING 13 0 13 ContainerNo Container Number      
SL19079 NVARCHAR VSTRING 35 0 35 DelivAddrNo EDI Delivery Address Number      
SL19080 NVARCHAR VSTRING 5 0 5 Bonus Bonus %      
SL19081 NVARCHAR VSTRING 20 0 20 AllocBonusYTD Allocated Bonus YTD (Local Currency)      
SL19082 NVARCHAR VSTRING 20 0 20 EarSetDisYTD Early Settlement Discounts YTD (Local Currency)      
SL19083 NVARCHAR VSTRING 10 0 10 ZipCode Zip Code      
SL19084 NVARCHAR VSTRING 10 0 10 Technician Technician      
SL19085 NVARCHAR VSTRING 1 0 1 DocumentLayout Document Layout      
SL19086 NVARCHAR VSTRING 2 0 2 AccrualCode Accrual Code      
SL19087 NVARCHAR VSTRING 2 0 2 ComisionCode Commission Code      
SL19088 NVARCHAR VSTRING 20 0 20 SalesNextYTD Sales Next YTD (Local Currency)      
SL19089 NVARCHAR VSTRING 20 0 20 SalesNextPer Sales Next Period (Local Currency)      
SL19090 NVARCHAR VSTRING 20 0 20 ProfNextYTD Profit Next YTD (Local Currency)      
SL19091 NVARCHAR VSTRING 20 0 20 ProfNextPer Profit Next Period (Local Currency)      
SL19092 NVARCHAR VSTRING 16 0 16 FiscalCode Fiscal Registration Code      
SL19093 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
SL19094 NVARCHAR VSTRING 34 0 34 BankAccntNo Bank Account Number      
SL19095 NVARCHAR VSTRING 1 0 1 TypeOfOrganiz Type of Organization      
SL19096 NVARCHAR VSTRING 1 0 1 IncOnTaxRep Include in Tax Reports      
SL19097 NVARCHAR VSTRING 1 0 1 CashMetSalTax Cash Method in Sales Tax Reports      
SL19098 NVARCHAR VSTRING 6 0 6 DefWarehNo Default Warehouse      
SL19099 NVARCHAR VSTRING 35 0 35 AddrLine4 Address Line 4      
SL19100 NVARCHAR VSTRING 6 0 6 CommonWarehNo Common Warehouse      
SL19101 NVARCHAR VSTRING 1 0 1 PartDelivCode 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.
   
SL19102 NVARCHAR VSTRING 1 0 1 PaymentLedger Payment Ledger      
SL19103 NVARCHAR VSTRING 4 0 4 Forwarder Forwarder      
SL19104 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      
SL19105 NVARCHAR VSTRING 1 0 1 MandatoryPO Mandatory Purchase Order Number      
SL19106 NVARCHAR VSTRING 10 0 10 BlanketPONum Blanket Purchase Order Number      
SL19107 NVARCHAR VSTRING 2 0 2 Tax Liability 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.
   
SL19108 NVARCHAR VSTRING 2 0 2 VATCode2 VAT Code 2      
SL19109 NVARCHAR VSTRING 50 0 50 CompleteName Complete Customer Name      
SL19110 NVARCHAR VSTRING 1 0 1 NoOfReminders Number of Reminders The maximum number of reminders that shall be printed per invoice for the customer.    
SL19111 NVARCHAR VSTRING 12 0 12 NomLedgerAC Pre-payment Account      
SL19112 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
   
SL19113 NCHAR STRING 1 0 1 TaxJurisdictionCode Tax Jurisdiction Only used in US (country code 1) when integrating with external tax handling application.    
SL19114 NCHAR SWITCH 1 0 1 EDIContractSwitch 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.
   
SL19115 NCHAR SWITCH 1 0 1 BlockOrderAccept Block Order Acceptance      
SL19116 NCHAR STRING 4 0 4 BillingCode Billing Terms      
SL19117 NCHAR STRING 1 0 1 DueDateMeth Due date Method      
SL19118 NCHAR STRING 1 0 1 TaxRoundMeth Tax Rounding Method 0 - Standard scala rounding
1 - Round-up to decimal in currency
2 - Round-down to decimal in currency
3 - Normal rounding
   
SL19119 NCHAR STRING 1 0 1 TaxCalcMeth Tax Calculation Method 0 - By order line
1 - By order total
   
SL19120 INT INTEGER 0 0 1 OtherTaxLiability 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
   
SL19121 INT INTEGER 0 0 1 DueDateBasedOn Due Date Base On      
SL19122 INT INTEGER 0 0 1 TaxRecalculation Tax Recalculation Allowed      
SL19123 NVARCHAR VSTRING 12 0 12 TaxRecalPLAccount Tax Recalculation P&L account      
SL19124 INT INTEGER 0 0 1 DraftCustomer Draft customer      
SL19125 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code The code that is used by the customer to identify us as supplier.    
SL19126 NCHAR STRING 10 0 10 PriReschedule Ordering Priority ATP Rescheduling      
SL19127 NCHAR SWITCH 1 0 1 AccLineSplit Accept Order Line Split ATP      
SL19128 NCHAR SWITCH 1 0 1 AccOrderSplit Accept Order Split ATP      
SL19129 NVARCHAR VSTRING 25 0 25 GlobalID Global ID      
SL19130 INT INTEGER 0 0 1 IBANactivation IBAN Activation      
SL19131 INT INTEGER 0 0 9 DiscountSchemeCode Discount Scheme Code      
SL19132 DATETIME DATE 0 0 8 Advancedgroupdiscountstartdate Group Discount Start Date      
SL19133 INT INTEGER 0 0 2 TimeIntervalValue Group Discount Time Interval      
SL19134 INT INTEGER 0 0 1 TimeIntervalUnits Group Discount Time Interval Unit 0 - Days
1 - Weeks
2 - Month
3 - Years
   
SL19135 NCHAR SWITCH 1 0 1 BatchPricingFlag Use Batch Pricing      
SL19136 INT INTEGER 0 0 1 Flag_IncludeQuotation Include Quotations      
SL19137 NCHAR STRING 2 0 2 Contract_PriceList Price List Contract      
SL19138 INT INTEGER 0 0 9 Calendar_Collection_Reference Calendar Collection      
SL19139 NCHAR STRING 2 0 2 Tax Code 1 VAT Code 1      
SL19140 NCHAR SWITCH 1 0 1 AllowSurchDistrib Allowance/Surcharge Distribution      
SL19141 NCHAR STRING 4 0 4 InvoiceIssuer Invoice Issuer Code      
SL19142 NCHAR SWITCH 1 0 1 InvoiceCategory Invoice Category      
SL19143 NCHAR STRING 6 0 6 TaxLiability Tax Liability Code      
SL19144 NVARCHAR VSTRING 10 0 10 LegalEntityType Legal Entity Type      
SL19145 NVARCHAR VSTRING 18 0 18 TaxID Tax ID      
SL19146 NVARCHAR VSTRING 20 0 20 IESTCode IEST Code      
SL19147 NVARCHAR VSTRING 20 0 20 IMCode IM Code      
SL19148 NVARCHAR VSTRING 20 0 20 IECode IE Code      
SL19149 NVARCHAR VSTRING 10 0 10 CustType Customer Type      
SL19150 NVARCHAR VSTRING 10 0 10 BussinessType Business Type      
SL19151 NCHAR SWITCH 1 0 1 IsBranch Is Branch      
SL19152 NVARCHAR VSTRING 10 0 10 CityCode City Code      
SL19153 NVARCHAR VSTRING 2 0 2 CustGroup Customer Group Code      
SL19154 NVARCHAR VSTRING 1 0 1 FreightPayer Freight Payer      
SL19155 NVARCHAR VSTRING 2 0 2 CollectionPeriod Collection Period (Brazil)      

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Sales Ledger | Customer Templates