Таблица: 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 | 15 | 0 | 15 | 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 | No_of_InvYTD | 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 | SalePrevYear | Sales Previous Year - 1 (Local Currency) | |||
SL19063 | NVARCHAR | VSTRING | 20 | 0 | 20 | ProfPrevYear | 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 | CityCode | Customer Area Code | |||
SL19072 | NVARCHAR | VSTRING | 5 | 0 | 5 | SNI_Code | 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 | NVARCHAR | VSTRING | 1 | 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 | Tax Liability | 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 | 50 | 0 | 50 | 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 | Flag_IncludeQuotation | Include Quotations | |||
SL19137 | NCHAR | STRING | 2 | 0 | 2 | Contract_PriceList | Price List Contract | |||
SL19138 | INT | INTEGER | 0 | 0 | 9 | Calendar_Collection_Reference | Calendar Collection | |||
SL19139 | NCHAR | STRING | 2 | 0 | 2 | Tax Code 1 | VAT Code 1 | |||
SL19140 | NCHAR | SWITCH | 1 | 0 | 1 | AllowSurchDistrib | Allowance/Surcharge Distribution | |||
SL19141 | NCHAR | STRING | 4 | 0 | 4 | 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 | LegalEntityType | Legal Entity Type | |||
SL19145 | NVARCHAR | VSTRING | 18 | 0 | 18 | TaxID | Tax ID | |||
SL19146 | NVARCHAR | VSTRING | 20 | 0 | 20 | IESTCode | IEST Code | |||
SL19147 | NVARCHAR | VSTRING | 20 | 0 | 20 | IMCode | IM Code | |||
SL19148 | NVARCHAR | VSTRING | 20 | 0 | 20 | IECode | IE Code | |||
SL19149 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustType | Customer Type | |||
SL19150 | NVARCHAR | VSTRING | 10 | 0 | 10 | BussinessType | Business Type | |||
SL19151 | NCHAR | SWITCH | 1 | 0 | 1 | IsBranch | Is Branch | |||
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) |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Sales Ledger | Customer Templates