One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SL19 — Customer Templates

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL19001 NCHAR STRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
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 35 0 35 Reference1 Reference 1      
SL19007 NVARCHAR VSTRING 35 0 35 Reference2 Reference 2      
SL19008 NVARCHAR VSTRING 35 0 35 Reference3 Reference 3      
SL19009 NVARCHAR VSTRING 35 0 35 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 NUMERIC X_NUMERIC 14 8 6 IntLatPayment Interest Late Payment      
SL19017 NVARCHAR ACCSTR 120 0 120 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 NUMERIC MONEY 28 8 20 CreditLimit Credit Limit (Local Currency)      
SL19038 NUMERIC MONEY 28 8 20 Balance Balance (Local Currency)      
SL19039 NUMERIC MONEY 28 8 20 SalePrevYear Sales Previous Year (Local Currency)      
SL19040 NUMERIC MONEY 28 8 20 SalesYTD Sales YTD (Local Currency)      
SL19041 NUMERIC MONEY 28 8 20 SalesPeriod Sales Period (Local Currency)      
SL19042 NUMERIC MONEY 28 8 20 ProfPrevYear Profit Previous Year (Local Currency)      
SL19043 NUMERIC MONEY 28 8 20 ProfitYTD Profit YTD (Local Currency)      
SL19044 NUMERIC MONEY 28 8 20 ProfitPeriod Profit Period (Local Currency)      
SL19045 NUMERIC MONEY 28 8 20 Budget Budget (Local Currency)      
SL19046 INT INTEGER 0 0 6 NoofInvYTD Number of Invoices YTD      
SL19047 NUMERIC MONEY 28 8 20 ChrgInterYTD Charged Interest YTD (Local Currency)      
SL19048 INT INTEGER 0 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 NUMERIC MONEY 28 8 20 OrdNotShiLoC Ordered Not Shipped (Local Currency)      
SL19058 NUMERIC MONEY 28 8 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 NUMERIC MONEY 28 8 20 SalePrevYear1 Sales Previous Year — 1 (Local Currency)      
SL19063 NUMERIC MONEY 28 8 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 NUMERIC X_NUMERIC 13 8 5 Bonus Bonus Percent      
SL19081 NUMERIC MONEY 28 8 20 AllocBonusYTD Allocated Bonus YTD (Local Currency)      
SL19082 NUMERIC MONEY 28 8 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 NUMERIC MONEY 28 8 20 SalesNextYTD Sales Next YTD (Local Currency)      
SL19089 NUMERIC MONEY 28 8 20 SalesNextPer Sales Next Period (Local Currency)      
SL19090 NUMERIC MONEY 28 8 20 ProfNextYTD Profit Next YTD (Local Currency)      
SL19091 NUMERIC MONEY 28 8 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 TaxLiabilityFlag Tax Liability Flag Yes (1) ? Tax is debited to customer, No (0) ? Tax is not debted to customer.    
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 LifeCycleStatus Life Cycle Status      
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 TaxCode Customer Tax Code      
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 SpecialICMSregimeBrazil 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      
SL19254 NCHAR STRING 3 0 3 TaxReasonCode Tax Reason Code      
SL19255 NCHAR STRING 1 0 1 SplitPayment Split Payments      
SL19256 NVARCHAR VSTRING 10 0 10 BankCode2 Bank Code 2      
SL19257 NVARCHAR VSTRING 34 0 34 BankAccount2 Bank Account 2      
SL19258 NCHAR SWITCH 1 0 1 BlockNewOrders Block New Orders      
SL19259 NCHAR SWITCH 1 0 1 Anonymized Anonymized      

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