Не забудьте посетить страницу «Наши услуги» и заказать интеграцию 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

Навигация: