пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SL01 — Customer File

Таблица: 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 HighestAmntCrLimit 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 TermOfPaym Payment Terms      
SL01025 NVARCHAR VSTRING 1 0 1 AutoGiroCust Auto Giro Customer Flag      
SL01026 NVARCHAR VSTRING 2 0 2 TermOfDeliv Delivery Terms      
SL01027 NVARCHAR VSTRING 2 0 2 WayOfDeliv 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 ExportCode Import/Export Customer Flag      
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 AreaCode 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 NumOfReminders 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 AccountTAXRecalculatePL 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 CalendarColRef 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 6 0 6 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 LTMGroup LTM Group      
SL01157 NCHAR STRING 1 0 1 DropShipment Drop Shipment Flag      
SL01158 INT INTEGER 0 0 4 DelNoteSort Delivery Note, sort      
SL01159 NVARCHAR VSTRING 1 0 1 AutoprintDN Auto print DN      
SL01160 NVARCHAR VSTRING 1 0 1 AutosendDN Auto send DN      
SL01161 NCHAR STRING 1 0 1 NeedBackOrder Need back-order      
SL01162 INT INTEGER 0 0 1 DelNotePrinting Delivery note printing      
SL01163 INT INTEGER 0 0 1 InvPrinting 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 Harbour      
SL01167 NVARCHAR VSTRING 2 0 2 Bundesland Bundesland      
SL01168 NVARCHAR VSTRING 6 0 6 StatManner StatManner      
SL01169 NVARCHAR VSTRING 2 0 2 CurrIdentNumber CurrIdentNumber      
SL01170 NVARCHAR VSTRING 2 0 2 ECDepartment ECDepartment      
SL01171 NVARCHAR VSTRING 2 0 2 Regime 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 MergeRIBA Merge RIBA      
SL01183 NVARCHAR VSTRING 2 0 2 PaymentAddressCode Payment Address Code      
SL01184 NVARCHAR VSTRING 2 0 2 InvoiceAddressCode Invoice Address Code      
SL01185 NVARCHAR VSTRING 2 0 2 InvoiceSentAddressCode 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 ExciseDivision Excise Division Excise Division    
SL01189 NVARCHAR VSTRING 2 0 2 DAForConsolidatedOR DA for Consolidated Sales Orders      
SL01190 NVARCHAR VSTRING 10 0 10 RegionCode Region Code GEO unit    
SL01191 NVARCHAR VSTRING 10 0 10 StateProvinceCode State/Province Code GEO unit    
SL01192 NVARCHAR VSTRING 10 0 10 CountyCode County Code GEO unit    
SL01193 NVARCHAR VSTRING 200 0 200 EmailAddress Email address      
SL01194 NVARCHAR VSTRING 35 0 35 AddressLine5 Address Line 5      
SL01195 NVARCHAR VSTRING 35 0 35 AddressLine6 Address Line 6      
SL01196 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
SL01197 NVARCHAR VSTRING 1 0 1 ConsolidationModeForLeaseContracts Consolidation Mode for Lease Contracts      
SL01198 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 Ext. User defined field 1      
SL01199 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Ext. User defined field 2      
SL01200 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Ext. User defined field 3      
SL01201 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Ext. User defined field 4      
SL01202 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Ext. User defined field 5      
SL01203 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Ext. User defined field 6      
SL01204 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Ext. User defined field 7      
SL01205 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Ext. User defined field 8      
SL01206 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Ext. User defined field 9      
SL01207 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Ext. User defined field 10      
SL01208 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Ext. User defined field 11      
SL01209 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Ext. User defined field 12      
SL01210 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Ext. User defined field 13      
SL01211 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Ext. User defined field 14      
SL01212 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Ext. User defined field 15      
SL01213 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Ext. User defined field 16      
SL01214 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Ext. User defined field 17      
SL01215 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Ext. User defined field 18      
SL01216 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Ext. User defined field 19      
SL01217 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Ext. User defined field 20      
SL01218 NVARCHAR VSTRING 1 0 1 PartialDeliveryPlanning Partial Delivery Planning 0 – allowed
1 – prohibited
   
SL01219 NCHAR SWITCH 1 0 1 LicenseFlag License Flag      
SL01220 DATETIME DATE 0 0 8 LicensedFrom Licensed From      
SL01221 DATETIME DATE 0 0 8 LicensedTo Licensed To      
SL01222 NCHAR SWITCH 1 0 1 PartDelOnCreditCheck Partial delivery on credit check      
SL01223 NUMERIC MONEY 28 8 20 TaxesOnOrderedNotShippedLCU Taxes on Ordered Not Shipped amount (LCU)      
SL01224 NUMERIC MONEY 28 8 20 AddOrderCostsLCU Additional costs on order (LCU)      
SL01225 NUMERIC MONEY 28 8 20 TaxesOnAddOrderCostsLCU Taxes on additional order costs (LCU)      
SL01226 NUMERIC MONEY 28 8 20 AmtAllocNotShippedLCU Allocated not shipped amount (LCU)      
SL01227 NUMERIC MONEY 28 8 20 TaxesOnAllocNotShippedLCU Taxes on allocated not shipped amount (LCU)      
SL01228 NUMERIC MONEY 28 8 20 TaxesOnShippedNotInvoicedLCU Taxes on shipped not invoiced amount (LCU)      
SL01229 NUMERIC MONEY 28 8 20 AddShippedCostsLCU Additional costs on order (shipped; LCU)      
SL01230 NUMERIC MONEY 28 8 20 TaxesOnAddShippedCostsLCU Taxes on additional costs on order (shipped; LCU)      
SL01231 NUMERIC X_NUMERIC 36 8 28 Longitude Longitude      
SL01232 NUMERIC X_NUMERIC 36 8 28 Latitude Latitude      
SL01233 NUMERIC X_NUMERIC 36 8 28 Altitude Altitude      
SL01234 NUMERIC MONEY 28 8 20 PrepaymCrCh Prepayments for Credit Check      
SL01235 NVARCHAR VSTRING 36 0 36 ExternalID External ID      
SL01236 NVARCHAR VSTRING 10 0 10 SUFARMA SUFARMA      
SL01237 NVARCHAR VSTRING 50 0 50 SpecialICMSRegime Special ICMS regime – Brazil      
SL01238 NCHAR STRING 1 0 1 SpareBrazil Spare (Brazil)      
SL01239 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
SL01240 NVARCHAR VSTRING 15 0 15 PostalGiroAC Postal Giro A/C      
SL01241 NVARCHAR VSTRING 15 0 15 BankGiroAC Postal Giro A/C      
SL01242 NCHAR STRING 2 0 2 CreditPayWay Credit Pay Way      
SL01243 NCHAR STRING 2 0 2 PO3Subtype PO3 Sub type      
SL01244 NVARCHAR VSTRING 12 0 12 SWIFTAddress SWIFT Address      
SL01245 NUMERIC MONEY 28 8 20 WHTaxesOnOrderedNotShippedLCU WH Taxes On Ordered Not Shipped LCU      
SL01246 NUMERIC MONEY 28 8 20 WHTaxesOnAddOrderCostsLCU WHT axes On Add Order Costs LCU      
SL01247 NUMERIC MONEY 28 8 20 WHTaxesOnAllocNotShippedLCU WH Taxes On Alloc Not Shipped LCU      
SL01248 NUMERIC MONEY 28 8 20 WHTaxesOnShippedNotInvoicedLCU WH Taxes On Shipped Not Invoiced LCU      
SL01249 NUMERIC MONEY 28 8 20 WHTaxesOnAddShippedCostsLCU WH Taxes On Add Shipped Costs LCU      
SL01250 INT INTEGER 0 0 3 OverdueTolerancePeriod Overdue tolerance period      
SL01251 NUMERIC MONEY 28 8 20 OverdueTotalToleranceAmnt Overdue total tolerance amount      
SL01252 NUMERIC MONEY 28 8 20 OverdueInvToleranceAmnt Overdue invoice tolerance amount      
SL01253 INT INTEGER 0 0 2 CreditControlStatus Credit control status      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
SL01021 15 15 20 20 20 20 20 20 20 20 20 20 20 20
SL01109 50 50 50 50 200 200 200 200 200 200 200 200 200 200
SL01141 4 4 4 4 4 4 6 6 6 6 6 6 6 6
SL01151 1 1 10 10 10 10 10 10 10 10 10 10 10 10
SL01156 6 6 6 6 6 6 6 6 6 6 6 6
SL01157 1 1 1 1 1 1 1 1 1 1 1 1
SL01158 0 4 0 4 0 4 0 4 0 4 0 4
SL01159 1 1 1 1 1 1 1 1 1 1 1 1
SL01160 1 1 1 1 1 1 1 1 1 1 1 1
SL01161 1 1 1 1 1 1 1 1 1 1 1 1
SL01162 0 1 0 1 0 1 0 1 0 1 0 1
SL01163 0 1 0 1 0 1 0 1 0 1 0 1
SL01164 2 2 2 2 2 2 2 2 2 2 2 2
SL01165 2 2 2 2 2 2 2 2 2 2 2 2
SL01166 4 4 4 4 4 4 4 4 4 4 4 4
SL01167 2 2 2 2 2 2 2 2 2 2 2 2
SL01168 6 6 6 6 6 6 6 6 6 6 6 6
SL01169 2 2 2 2 2 2 2 2 2 2 2 2
SL01170 2 2 2 2 2 2 2 2 2 2 2 2
SL01171 2 2 2 2 2 2 2 2 2 2 2 2
SL01172 1 1 1 1 1 1 1 1 1 1
SL01173 1 1 1 1 1 1 1 1 1 1
SL01174 0 2 0 2 0 2 0 2 0 2
SL01175 0 2 0 2 0 2 0 2 0 2
SL01176 0 2 0 2 0 2 0 2 0 2
SL01177 0 2 0 2 0 2 0 2 0 2
SL01178 1 1 1 1 1 1 1 1 1 1
SL01179 2 2 2 2 2 2 2 2 2 2
SL01180 6 6 6 6 6 6 6 6 6 6
SL01181 1 1 1 1 1 1 1 1 1 1
SL01182 1 1 1 1 1 1 1 1 1 1
SL01183 2 2 2 2 2 2 2 2 2 2
SL01184 2 2 2 2 2 2 2 2 2 2
SL01185 2 2 2 2 2 2 2 2 2 2
SL01186 25 25 25 25 25 25 25 25 25 25
SL01187 25 25 25 25 25 25 25 25 25 25
SL01188 25 25 25 25 25 25 25 25 25 25
SL01189 2 2 2 2 2 2 2 2
SL01190 10 10 10 10 10 10 10 10
SL01191 10 10 10 10 10 10 10 10
SL01192 10 10 10 10 10 10 10 10
SL01193 200 200 200 200 200 200 200 200
SL01194 35 35 35 35 35 35 35 35
SL01195 35 35 35 35 35 35 35 35
SL01196 35 35 35 35 35 35 35 35
SL01197 1 1 1 1 1 1 1 1
SL01198 50 50 50 50 50 50 150 150
SL01199 50 50 50 50 50 50 150 150
SL01200 50 50 50 50 50 50 150 150
SL01201 50 50 50 50 50 50 150 150
SL01202 50 50 50 50 50 50 150 150
SL01203 50 50 50 50 50 50 150 150
SL01204 50 50 50 50 50 50 150 150
SL01205 50 50 50 50 50 50 150 150
SL01206 50 50 50 50 50 50 150 150
SL01207 50 50 50 50 50 50 150 150
SL01208 50 50 50 50 50 50 150 150
SL01209 50 50 50 50 50 50 150 150
SL01210 50 50 50 50 50 50 150 150
SL01211 50 50 50 50 50 50 150 150
SL01212 50 50 50 50 50 50 150 150
SL01213 50 50 50 50 50 50 150 150
SL01214 50 50 50 50 50 50 150 150
SL01215 50 50 50 50 50 50 150 150
SL01216 50 50 50 50 50 50 150 150
SL01217 50 50 50 50 50 50 150 150
SL01218 1 1 1 1 1 1 1 1
SL01219 1 1 1 1 1 1 1 1
SL01220 0 8 0 8 0 8 0 8
SL01221 0 8 0 8 0 8 0 8
SL01222 1 1 1 1 1 1
SL01223 28 20 28 20 28 20
SL01224 28 20 28 20 28 20
SL01225 28 20 28 20 28 20
SL01226 28 20 28 20 28 20
SL01227 28 20 28 20 28 20
SL01228 28 20 28 20 28 20
SL01229 28 20 28 20 28 20
SL01230 28 20 28 20 28 20
SL01231 36 28 36 28 36 28
SL01232 36 28 36 28 36 28
SL01233 36 28 36 28 36 28
SL01234 28 20 28 20 28 20
SL01235 36 36 36 36 36 36
SL01236 10 10 10 10
SL01237 50 50 50 50
SL01238 1 1 1 1
SL01239 12 12 12 12
SL01240 15 15 15 15
SL01241 15 15 15 15
SL01242 2 2 2 2
SL01243 2 2 2 2
SL01244 12 12 12 12
SL01245 28 20 28 20
SL01246 28 20 28 20
SL01247 28 20 28 20
SL01248 28 20 28 20
SL01249 28 20 28 20
SL01250 0 3
SL01251 28 20
SL01252 28 20
SL01253 0 2

Навигация: