На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table SL01 — Customer File

Таблица / Table: SL01 — «Customer File». Маска имени таблицы / Table name mask: «SL01%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL01001 NCHAR STRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
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 35 0 35 Reference1 Reference 1      
SL01007 NVARCHAR VSTRING 35 0 35 Reference2 Reference 2      
SL01008 NVARCHAR VSTRING 35 0 35 Reference3 Reference 3      
SL01009 NVARCHAR VSTRING 35 0 35 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 Fax Number      
SL01014 NVARCHAR VSTRING 1 0 1 ReminderBlockFlag Reminder Block      
SL01015 NVARCHAR VSTRING 1 0 1 ChargeInterestFlag Overdue Interest      
SL01016 NUMERIC X_NUMERIC 14 8 6 InterestLatePayment Interest/Year Percent      
SL01017 NVARCHAR ACCSTR 120 0 120 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 Spare      
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 Code      
SL01024 NVARCHAR VSTRING 2 0 2 TermOfPaym Payment Term      
SL01025 NVARCHAR VSTRING 1 0 1 AutoGiroCust Auto Giro Customer      
SL01026 NVARCHAR VSTRING 2 0 2 TermOfDeliv Delivery Term      
SL01027 NVARCHAR VSTRING 2 0 2 WayOfDeliv Delivery Method      
SL01028 NVARCHAR VSTRING 1 0 1 MergeInvoiceFlag Consolidate Invoice      
SL01029 NVARCHAR VSTRING 2 0 2 PriceList Price List      
SL01030 NVARCHAR VSTRING 1 0 1 ExportCode Export Customer      
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 Automatic 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 NUMERIC MONEY 28 8 20 AmountCreditLimit Credit Limit      
SL01038 NUMERIC MONEY 28 8 20 Balance Balance      
SL01039 NUMERIC MONEY 28 8 20 AmountPrevYearLCU Turnover previous year      
SL01040 NUMERIC MONEY 28 8 20 AmountYTDLCU Turnover YTD      
SL01041 NUMERIC MONEY 28 8 20 AmountPeriodLCU Turnover period      
SL01042 NUMERIC MONEY 28 8 20 ProfitPrevYear Profit previous year      
SL01043 NUMERIC MONEY 28 8 20 ProfitYTD Profit YTD      
SL01044 NUMERIC MONEY 28 8 20 ProfitPeriod Profit period      
SL01045 NUMERIC MONEY 28 8 20 AmountBudget Budget      
SL01046 INT INTEGER 0 0 6 InvoicesYTD Number of invoices YTD      
SL01047 NUMERIC MONEY 28 8 20 AmountChargedInterestYTD Interest YTD      
SL01048 INT INTEGER 0 0 6 DaysNoTotalDuePayments Number of due dates      
SL01049 NVARCHAR VSTRING 4 0 4 InvoicesTotal Number of due 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 Remark Line 1      
SL01053 NVARCHAR VSTRING 25 0 25 Remark2 Remark Line 2      
SL01054 NVARCHAR VSTRING 35 0 35 AlphaSearchKey Search Name      
SL01055 NVARCHAR VSTRING 3 0 3 ReminderNo Number of reminders      
SL01056 NVARCHAR VSTRING 10 0 10 MainCustomerCode Main Customer Code      
SL01057 NUMERIC MONEY 28 8 20 AmountOrderedNotShippedLCU Ordered not delivered      
SL01058 NUMERIC MONEY 28 8 20 AmountShippedNotInvoicedLCU Delivered 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 Invoice Sets      
SL01062 NUMERIC MONEY 28 8 20 AmountPrevYear1 Turnover previous year -1      
SL01063 NUMERIC MONEY 28 8 20 ProfitPrevYear1 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 Subsidy      
SL01067 NVARCHAR VSTRING 1 0 1 InternalActionFlag Internal 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 TradeCode Customer Trade Code      
SL01073 NVARCHAR VSTRING 1 0 1 FeeInvoiceFlag Invoicing Fee      
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 Delivery Address Number      
SL01080 NUMERIC X_NUMERIC 13 8 5 Bonus Bonus percent      
SL01081 NUMERIC MONEY 28 8 20 AmountAllocatedBonusYTD Allocated Bonus      
SL01082 NUMERIC MONEY 28 8 20 AmountEarlySettlmentDiscountYTD Cash Discounts Taken      
SL01083 NVARCHAR VSTRING 10 0 10 ZipCode Post Code      
SL01084 NVARCHAR VSTRING 10 0 10 Technician Field Engineer      
SL01085 NVARCHAR VSTRING 1 0 1 DocumentLayout Document Layout Code      
SL01086 NVARCHAR VSTRING 2 0 2 AccrualCode Accrual Bonus Code      
SL01087 NVARCHAR VSTRING 2 0 2 CommissionCode Commission Code      
SL01088 NUMERIC MONEY 28 8 20 AmountNextYTD Turnover next year      
SL01089 NUMERIC MONEY 28 8 20 AmountNextPeriod Turnover next period      
SL01090 NUMERIC MONEY 28 8 20 ProfitNextYTD Profit next year      
SL01091 NUMERIC MONEY 28 8 20 ProfitNextPeriod Profit next period      
SL01092 NVARCHAR VSTRING 16 0 16 FiscalCode Company Registration Number      
SL01093 NVARCHAR VSTRING 10 0 10 BankCode Bank Code 1      
SL01094 NVARCHAR VSTRING 34 0 34 BankAccountNo Bank Account Number 1      
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 Alternate Warehouse      
SL01101 NVARCHAR VSTRING 1 0 1 PartialDeliveryFlag Avoid Partial Deliveries 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 Freight 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 TaxLiabilityFlag TAX Liability Yes (1) ? Tax is debited to customer, No (0) ? Tax is not debted to customer.    
SL01108 NVARCHAR VSTRING 2 0 2 TAXCode2 VAT Code 2      
SL01109 NVARCHAR VSTRING 200 0 200 CompleteCustomerName Long 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 Prepayment Account      
SL01112 NCHAR STRING 2 0 2 WayOfPayment Way of Payment (Invoices) 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 Code 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 Code      
SL01117 NCHAR STRING 1 0 1 DueDateMethodFlag Date Shifting 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      
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 LifeCycleStatus Life Cycle Status      
SL01125 NVARCHAR VSTRING 10 0 10 SupplierCode Our Code at Supplier The code that is used by the customer to identify us as supplier.    
SL01126 NCHAR STRING 10 0 10 ATPOrderPriorityRescheduling ATP Rescheduling Priority      
SL01127 NCHAR SWITCH 1 0 1 ATPAcceptOrderLineSplit Accept Order Line Split by ATP      
SL01128 NCHAR SWITCH 1 0 1 ATPAcceptOrderSplit Accept Order Split by 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 TaxCode Customer Tax Code      
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 Tax Identification      
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 Financial 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 (Brazil)      
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 Print Delivery Note at Picking Confirmation      
SL01160 NVARCHAR VSTRING 1 0 1 AutosendDN Send Delivery Note at Picking Confirmation      
SL01161 NCHAR STRING 1 0 1 NeedBackOrder Reorder Customer      
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 ID type      
SL01165 NCHAR STRING 2 0 2 ResponsibilityType Tax Responsibility Type      
SL01166 NVARCHAR VSTRING 4 0 4 Harbour Harbour      
SL01167 NVARCHAR VSTRING 2 0 2 Bundesland Bundesland      
SL01168 NVARCHAR VSTRING 6 0 6 StatManner Statistical Manner Code      
SL01169 NVARCHAR VSTRING 2 0 2 CurrIdentNumber Currency ID Number      
SL01170 NVARCHAR VSTRING 2 0 2 ECDepartment EC Department Code      
SL01171 NVARCHAR VSTRING 2 0 2 Regime Regime Code      
SL01172 NVARCHAR VSTRING 1 0 1 AutoPrintInvoice Print Invoice at Picking Confirmation      
SL01173 NVARCHAR VSTRING 1 0 1 AutoSendInvoice Send Invoice at Picking Confirmation      
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 Month Excluded from Payment      
SL01178 NVARCHAR VSTRING 1 0 1 ReleaseForDN Picking Confirmation, release for Delivery Note      
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 Consolidated Sales Order Address Code      
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 Extended User defined 1      
SL01199 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Extended User defined 2      
SL01200 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Extended User defined 3      
SL01201 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Extended User defined 4      
SL01202 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Extended User defined 5      
SL01203 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Extended User defined 6      
SL01204 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Extended User defined 7      
SL01205 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Extended User defined 8      
SL01206 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Extended User defined 9      
SL01207 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Extended User defined 10      
SL01208 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Extended User defined 11      
SL01209 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Extended User defined 12      
SL01210 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Extended User defined 13      
SL01211 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Extended User defined 14      
SL01212 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Extended User defined 15      
SL01213 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Extended User defined 16      
SL01214 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Extended User defined 17      
SL01215 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Extended User defined 18      
SL01216 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Extended User defined 19      
SL01217 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Extended User defined 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 if Credit Limit is Exceeded      
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 Include in Spesometro Form      
SL01240 NVARCHAR VSTRING 15 0 15 PostalGiroAC Postal Giro A/C      
SL01241 NVARCHAR VSTRING 15 0 15 BankGiroAC Bank Giro Number      
SL01242 NCHAR STRING 2 0 2 CreditPayWay Way of Payments (Credit Note)      
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 WH Taxes on Additional Order Costs (LCU)      
SL01247 NUMERIC MONEY 28 8 20 WHTaxesOnAllocNotShippedLCU WH Taxes on Allocated 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 Additional 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      
SL01254 NCHAR STRING 3 0 3 TaxReasonCode Reason Code for Non-Standard Taxation      
SL01255 NCHAR STRING 1 0 1 SplitPayment Split Payments      
SL01256 NVARCHAR VSTRING 10 0 10 BankCode2 Bank Code 2      
SL01257 NVARCHAR VSTRING 34 0 34 BankAccount2 Bank Account Number 2      
SL01258 NCHAR SWITCH 1 0 1 BlockNewOrders Block New Orders      
SL01259 NCHAR SWITCH 1 0 1 Anonymized Anonymized      

Навигация / Navigation: