Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
На один уровень вверх / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Ledger»

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

Таблица: 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 20 0 20 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 NoofInvYTD 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 SalePrevYear1 Sales Previous Year — 1 (Local Currency)      
SL19063 NVARCHAR VSTRING 20 0 20 ProfPrevYear1 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 AreaCode Customer Area Code      
SL19072 NVARCHAR VSTRING 5 0 5 SNICode 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 INT INTEGER 0 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 VATCode1 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 200 0 200 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 FlagIncludeQuotation Include Quotations      
SL19137 NCHAR STRING 2 0 2 ContractPriceList Price List Contract      
SL19138 INT INTEGER 0 0 9 CalendarColRef Calendar Collection      
SL19139 NCHAR STRING 2 0 2 TaxCode1 VAT Code 1      
SL19140 NCHAR SWITCH 1 0 1 AllowSurchDistrib Allowance/Surcharge Distribution      
SL19141 NCHAR STRING 6 0 6 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 EntityType Entity Type      
SL19145 NVARCHAR VSTRING 18 0 18 Spare Spare      
SL19146 NVARCHAR VSTRING 20 0 20 SubstRegNo Substitution Registration Number      
SL19147 NVARCHAR VSTRING 20 0 20 MunicRegNo Municipal Registration Number      
SL19148 NVARCHAR VSTRING 20 0 20 StateRegNo State Registration Number      
SL19149 NVARCHAR VSTRING 10 0 10 CustActType Customer Activity Type      
SL19150 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
SL19151 NVARCHAR VSTRING 10 0 10 FinOperationCode Financial Operation Code      
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)      
SL19156 NCHAR STRING 6 0 6 LTMGroup LTM Group      
SL19157 NCHAR STRING 1 0 1 DropShipment Drop Shipment Flag      
SL19158 INT INTEGER 0 0 4 DelNoteSort Delivery Note, sort      
SL19159 NVARCHAR VSTRING 1 0 1 AutoprintDN Auto print DN      
SL19160 NVARCHAR VSTRING 1 0 1 AutosendDN Auto send DN      
SL19161 NCHAR STRING 1 0 1 NeedBackOrder Need back-order      
SL19162 INT INTEGER 0 0 1 DelNotePrinting Delivery note printing      
SL19163 INT INTEGER 0 0 1 InvPrinting Invoice printing      
SL19164 NCHAR STRING 2 0 2 TaxIDType TaxIDType      
SL19165 NCHAR STRING 2 0 2 ResponsibilityType ResponsibilityType      
SL19166 NVARCHAR VSTRING 4 0 4 Harbour Harbour      
SL19167 NVARCHAR VSTRING 2 0 2 Bundesland Bundesland      
SL19168 NVARCHAR VSTRING 6 0 6 StatManner StatManner      
SL19169 NVARCHAR VSTRING 2 0 2 CurrIdentNumber CurrIdentNumber      
SL19170 NVARCHAR VSTRING 2 0 2 ECDepartment ECDepartment      
SL19171 NVARCHAR VSTRING 2 0 2 Regime Regime      
SL19172 NVARCHAR VSTRING 1 0 1 AutoPrintInvoice Auto print Invoice      
SL19173 NVARCHAR VSTRING 1 0 1 AutoSendInvoice Auto send Invoice      
SL19174 INT INTEGER 0 0 2 FixPaymentDay1 Fix Payment Day 1      
SL19175 INT INTEGER 0 0 2 FixPaymentDay2 Fix Payment Day 2      
SL19176 INT INTEGER 0 0 2 FixPaymentDay3 Fix Payment Day 3      
SL19177 INT INTEGER 0 0 2 PaymntExcludMonth Paymnt Exclud Month      
SL19178 NVARCHAR VSTRING 1 0 1 ReleaseForDN Release For DN      
SL19179 NCHAR STRING 2 0 2 ExtendedCommissionCode Extended Commission Code      
SL19180 NVARCHAR VSTRING 6 0 6 TaxType Tax Type This field should contain the tax (VAT) type.    
SL19181 NCHAR SWITCH 1 0 1 TaxSurcharge Tax Surcharge      
SL19182 NCHAR SWITCH 1 0 1 MergeRIBA Merge RIBA      
SL19183 NVARCHAR VSTRING 2 0 2 PaymentAddressCode Payment Address Code      
SL19184 NVARCHAR VSTRING 2 0 2 InvoiceAddressCode Invoice Address Code      
SL19185 NVARCHAR VSTRING 2 0 2 InvoiceSentAddressCode Invoice Sent Address Code      
SL19186 NVARCHAR VSTRING 25 0 25 ExcContrCode Excise Control Code Excise Control Code    
SL19187 NVARCHAR VSTRING 25 0 25 ExcRegNo Excise Registration Number Excise Registration Number    
SL19188 NVARCHAR VSTRING 25 0 25 ExciseDivision Excise Division Excise Division    
SL19189 NVARCHAR VSTRING 2 0 2 DAForConsolidatedOR DA for Consolidated Sales Orders      
SL19190 NVARCHAR VSTRING 10 0 10 RegionCode Region Code GEO unit    
SL19191 NVARCHAR VSTRING 10 0 10 StateProvinceCode State/Province Code GEo unit    
SL19192 NVARCHAR VSTRING 10 0 10 CountyCode County Code GEO unit    
SL19193 NVARCHAR VSTRING 200 0 200 EmailAddress Email address      
SL19194 NVARCHAR VSTRING 35 0 35 AddressLine5 Address Line 5      
SL19195 NVARCHAR VSTRING 35 0 35 AddressLine6 Address Line 6      
SL19196 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
SL19197 NVARCHAR VSTRING 1 0 1 ConsolidationModeForLeaseContracts Consolidation Mode for Lease Contracts      
SL19198 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 Ext. User defined field 1      
SL19199 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Ext. User defined field 2      
SL19200 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Ext. User defined field 3      
SL19201 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Ext. User defined field 4      
SL19202 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Ext. User defined field 5      
SL19203 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Ext. User defined field 6      
SL19204 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Ext. User defined field 7      
SL19205 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Ext. User defined field 8      
SL19206 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Ext. User defined field 9      
SL19207 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Ext. User defined field 10      
SL19208 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Ext. User defined field 11      
SL19209 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Ext. User defined field 12      
SL19210 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Ext. User defined field 13      
SL19211 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Ext. User defined field 14      
SL19212 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Ext. User defined field 15      
SL19213 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Ext. User defined field 16      
SL19214 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Ext. User defined field 17      
SL19215 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Ext. User defined field 18      
SL19216 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Ext. User defined field 19      
SL19217 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Ext. User defined field 20      
SL19218 NVARCHAR VSTRING 1 0 1 PartialDeliveryPlanning Partial Delivery Planning 0 – allowed
1 – prohibited		    
SL19219 NCHAR SWITCH 1 0 1 LicenseFlag License Flag      
SL19220 DATETIME DATE 0 0 8 LicensedFrom Licensed From      
SL19221 DATETIME DATE 0 0 8 LicensedTo Licensed To      
SL19222 NCHAR SWITCH 1 0 1 PartDelOnCreditCheck Partial delivery on credit check      
SL19223 NUMERIC MONEY 28 8 20 TaxesOnOrderedNotShippedLCU Taxes on Ordered Not Shipped amount (LCU)      
SL19224 NUMERIC MONEY 28 8 20 AddOrderCostsLCU Additional costs on order (LCU)      
SL19225 NUMERIC MONEY 28 8 20 TaxesOnAddOrderCostsLCU Taxes on additional order costs (LCU)      
SL19226 NUMERIC MONEY 28 8 20 AmtAllocNotShippedLCU Allocated not shipped amount (LCU)      
SL19227 NUMERIC MONEY 28 8 20 TaxesOnAllocNotShippedLCU Taxes on allocated not shipped amount (LCU)      
SL19228 NUMERIC MONEY 28 8 20 TaxesOnShippedNotInvoicedLCU Taxes on shipped not invoiced amount (LCU)      
SL19229 NUMERIC MONEY 28 8 20 AddShippedCostsLCU Additional costs on order (shipped; LCU)      
SL19230 NUMERIC MONEY 28 8 20 TaxesOnAddShippedCostsLCU Taxes on additional costs on order (shipped; LCU)      
SL19231 NUMERIC X_NUMERIC 36 8 28 Longitude Longitude      
SL19232 NUMERIC X_NUMERIC 36 8 28 Latitude Latitude      
SL19233 NUMERIC X_NUMERIC 36 8 28 Altitude Altitude      
SL19234 NUMERIC MONEY 28 8 20 PrepaymCrCh Prepayments for Credit Check      
SL19235 NVARCHAR VSTRING 36 0 36 ExternalID External ID      
SL19236 NVARCHAR VSTRING 10 0 10 SUFARMA SUFARMA      
SL19237 NVARCHAR VSTRING 50 0 50 SpecialICMSregime–Brazil Special ICMS regime – Brazil      
SL19238 NCHAR STRING 1 0 1 SpareBrazil Spare (Brazil)      
SL19239 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
SL19240 NVARCHAR VSTRING 15 0 15 PostalGiroAC Postal Giro A/C      
SL19241 NVARCHAR VSTRING 15 0 15 BankGiroAC Bank Giro A/C      
SL19242 NCHAR STRING 2 0 2 CreditPayWay Credit Pay Way      
SL19243 NCHAR STRING 2 0 2 PO3Subtype PO3 Sub type      
SL19244 NVARCHAR VSTRING 12 0 12 SWIFTAddress SWIFT Address      
SL19245 NUMERIC MONEY 28 8 20 WHTaxesOnOrderedNotShippedLCU WH Taxes On Ordered Not Shipped LCU      
SL19246 NUMERIC MONEY 28 8 20 WHTaxesOnAddOrderCostsLCU WH Taxes On Add Order Costs LCU      
SL19247 NUMERIC MONEY 28 8 20 WHTaxesOnAllocNotShippedLCU WH Taxes On Alloc Not Shipped LCU      
SL19248 NUMERIC MONEY 28 8 20 WHTaxesOnShippedNotInvoicedLCU WH Taxes On Shipped Not Invoiced LCU      
SL19249 NUMERIC MONEY 28 8 20 WHTaxesOnAddShippedCostsLCU WH Taxes On Add Shipped Costs LCU      
SL19250 INT INTEGER 0 0 3 OverdueTolerancePeriod Overdue tolerance period      
SL19251 NUMERIC MONEY 28 8 20 OverdueTotalToleranceAmnt Overdue total tolerance amount      
SL19252 NUMERIC MONEY 28 8 20 OverdueInvoiceToleranceAmnt Overdue invoice tolerance amount      
SL19253 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
SL19021 15 15 20 20 20 20 20 20 20 20 20 20 20 20
SL19076 1 1 0 1 0 1 0 1 0 1 0 1 0 1
SL19109 50 50 50 50 200 200 200 200 200 200 200 200 200 200
SL19141 4 4 4 4 4 4 6 6 6 6 6 6 6 6
SL19151 1 1 10 10 10 10 10 10 10 10 10 10 10 10
SL19156 — — 6 6 6 6 6 6 6 6 6 6 6 6
SL19157 — — 1 1 1 1 1 1 1 1 1 1 1 1
SL19158 — — 0 4 0 4 0 4 0 4 0 4 0 4
SL19159 — — 1 1 1 1 1 1 1 1 1 1 1 1
SL19160 — — 1 1 1 1 1 1 1 1 1 1 1 1
SL19161 — — 1 1 1 1 1 1 1 1 1 1 1 1
SL19162 — — 0 1 0 1 0 1 0 1 0 1 0 1
SL19163 — — 0 1 0 1 0 1 0 1 0 1 0 1
SL19164 — — 2 2 2 2 2 2 2 2 2 2 2 2
SL19165 — — 2 2 2 2 2 2 2 2 2 2 2 2
SL19166 — — 4 4 4 4 4 4 4 4 4 4 4 4
SL19167 — — 2 2 2 2 2 2 2 2 2 2 2 2
SL19168 — — 6 6 6 6 6 6 6 6 6 6 6 6
SL19169 — — 2 2 2 2 2 2 2 2 2 2 2 2
SL19170 — — 2 2 2 2 2 2 2 2 2 2 2 2
SL19171 — — 2 2 2 2 2 2 2 2 2 2 2 2
SL19172 — — — — 1 1 1 1 1 1 1 1 1 1
SL19173 — — — — 1 1 1 1 1 1 1 1 1 1
SL19174 — — — — 0 2 0 2 0 2 0 2 0 2
SL19175 — — — — 0 2 0 2 0 2 0 2 0 2
SL19176 — — — — 0 2 0 2 0 2 0 2 0 2
SL19177 — — — — 0 2 0 2 0 2 0 2 0 2
SL19178 — — — — 1 1 1 1 1 1 1 1 1 1
SL19179 — — — — 2 2 2 2 2 2 2 2 2 2
SL19180 — — — — 6 6 6 6 6 6 6 6 6 6
SL19181 — — — — 1 1 1 1 1 1 1 1 1 1
SL19182 — — — — 1 1 1 1 1 1 1 1 1 1
SL19183 — — — — 2 2 2 2 2 2 2 2 2 2
SL19184 — — — — 2 2 2 2 2 2 2 2 2 2
SL19185 — — — — 2 2 2 2 2 2 2 2 2 2
SL19186 — — — — 25 25 25 25 25 25 25 25 25 25
SL19187 — — — — 25 25 25 25 25 25 25 25 25 25
SL19188 — — — — 25 25 25 25 25 25 25 25 25 25
SL19189 — — — — — — 2 2 2 2 2 2 2 2
SL19190 — — — — — — 10 10 10 10 10 10 10 10
SL19191 — — — — — — 10 10 10 10 10 10 10 10
SL19192 — — — — — — 10 10 10 10 10 10 10 10
SL19193 — — — — — — 200 200 200 200 200 200 200 200
SL19194 — — — — — — 35 35 35 35 35 35 35 35
SL19195 — — — — — — 35 35 35 35 35 35 35 35
SL19196 — — — — — — 35 35 35 35 35 35 35 35
SL19197 — — — — — — 1 1 1 1 1 1 1 1
SL19198 — — — — — — 50 50 50 50 50 50 150 150
SL19199 — — — — — — 50 50 50 50 50 50 150 150
SL19200 — — — — — — 50 50 50 50 50 50 150 150
SL19201 — — — — — — 50 50 50 50 50 50 150 150
SL19202 — — — — — — 50 50 50 50 50 50 150 150
SL19203 — — — — — — 50 50 50 50 50 50 150 150
SL19204 — — — — — — 50 50 50 50 50 50 150 150
SL19205 — — — — — — 50 50 50 50 50 50 150 150
SL19206 — — — — — — 50 50 50 50 50 50 150 150
SL19207 — — — — — — 50 50 50 50 50 50 150 150
SL19208 — — — — — — 50 50 50 50 50 50 150 150
SL19209 — — — — — — 50 50 50 50 50 50 150 150
SL19210 — — — — — — 50 50 50 50 50 50 150 150
SL19211 — — — — — — 50 50 50 50 50 50 150 150
SL19212 — — — — — — 50 50 50 50 50 50 150 150
SL19213 — — — — — — 50 50 50 50 50 50 150 150
SL19214 — — — — — — 50 50 50 50 50 50 150 150
SL19215 — — — — — — 50 50 50 50 50 50 150 150
SL19216 — — — — — — 50 50 50 50 50 50 150 150
SL19217 — — — — — — 50 50 50 50 50 50 150 150
SL19218 — — — — — — 1 1 1 1 1 1 1 1
SL19219 — — — — — — 1 1 1 1 1 1 1 1
SL19220 — — — — — — 0 8 0 8 0 8 0 8
SL19221 — — — — — — 0 8 0 8 0 8 0 8
SL19222 — — — — — — — — 1 1 1 1 1 1
SL19223 — — — — — — — — 28 20 28 20 28 20
SL19224 — — — — — — — — 28 20 28 20 28 20
SL19225 — — — — — — — — 28 20 28 20 28 20
SL19226 — — — — — — — — 28 20 28 20 28 20
SL19227 — — — — — — — — 28 20 28 20 28 20
SL19228 — — — — — — — — 28 20 28 20 28 20
SL19229 — — — — — — — — 28 20 28 20 28 20
SL19230 — — — — — — — — 28 20 28 20 28 20
SL19231 — — — — — — — — 36 28 36 28 36 28
SL19232 — — — — — — — — 36 28 36 28 36 28
SL19233 — — — — — — — — 36 28 36 28 36 28
SL19234 — — — — — — — — 28 20 28 20 28 20
SL19235 — — — — — — — — 36 36 36 36 36 36
SL19236 — — — — — — — — — — 10 10 10 10
SL19237 — — — — — — — — — — 50 50 50 50
SL19238 — — — — — — — — — — 1 1 1 1
SL19239 — — — — — — — — — — 12 12 12 12
SL19240 — — — — — — — — — — 15 15 15 15
SL19241 — — — — — — — — — — 15 15 15 15
SL19242 — — — — — — — — — — 2 2 2 2
SL19243 — — — — — — — — — — 2 2 2 2
SL19244 — — — — — — — — — — 12 12 12 12
SL19245 — — — — — — — — — — 28 20 28 20
SL19246 — — — — — — — — — — 28 20 28 20
SL19247 — — — — — — — — — — 28 20 28 20
SL19248 — — — — — — — — — — 28 20 28 20
SL19249 — — — — — — — — — — 28 20 28 20
SL19250 — — — — — — — — — — — — 0 3
SL19251 — — — — — — — — — — — — 28 20
SL19252 — — — — — — — — — — — — 28 20
SL19253 — — — — — — — — — — — — 0 2

Навигация: