Таблица / 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 | 20 | 0 | 20 | Reference1 | Reference 1 | |||
SL01007 | NVARCHAR | VSTRING | 20 | 0 | 20 | Reference2 | Reference 2 | |||
SL01008 | NVARCHAR | VSTRING | 20 | 0 | 20 | Reference3 | Reference 3 | |||
SL01009 | NVARCHAR | VSTRING | 20 | 0 | 20 | 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 | Telefax Number | |||
SL01014 | NVARCHAR | VSTRING | 1 | 0 | 1 | ReminderBlockFlag | Reminder Block | |||
SL01015 | NVARCHAR | VSTRING | 1 | 0 | 1 | ChargeInterestFlag | Charge Interest | |||
SL01016 | NVARCHAR | VSTRING | 6 | 0 | 6 | InterestLatePayment | Interest Late Payment % | |||
SL01017 | NVARCHAR | VSTRING | 50 | 0 | 50 | 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 | (obsolete) | |||
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 | |||
SL01024 | NVARCHAR | VSTRING | 2 | 0 | 2 | TermOfPaym | Payment Terms | |||
SL01025 | NVARCHAR | VSTRING | 1 | 0 | 1 | AutoGiroCust | Auto Giro Customer Flag | |||
SL01026 | NVARCHAR | VSTRING | 2 | 0 | 2 | TermOfDeliv | Delivery Terms | |||
SL01027 | NVARCHAR | VSTRING | 2 | 0 | 2 | WayOfDeliv | Delivery Method | |||
SL01028 | NVARCHAR | VSTRING | 1 | 0 | 1 | MergeInvoiceFlag | Consolidated Invoice | |||
SL01029 | NVARCHAR | VSTRING | 2 | 0 | 2 | PriceList | Price List | |||
SL01030 | NVARCHAR | VSTRING | 1 | 0 | 1 | ExportCode | Import/Export Customer Flag | |||
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 | 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 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountCreditLimit | Credit Limit | |||
SL01038 | NUMERIC | MONEY | 28 | 8 | 20 | Balance | Balance | |||
SL01039 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountPrevYearLCU | Sales Previous Year | |||
SL01040 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountYTDLCU | Sales YTD | |||
SL01041 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountPeriodLCU | Sales Period | |||
SL01042 | NVARCHAR | VSTRING | 20 | 0 | 20 | ProfitPrevYear | Profit Previous Year | |||
SL01043 | NVARCHAR | VSTRING | 20 | 0 | 20 | ProfitYTD | Profit YTD | |||
SL01044 | NVARCHAR | VSTRING | 20 | 0 | 20 | ProfitPeriod | Profit Period | |||
SL01045 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountBudget | Budget | |||
SL01046 | NVARCHAR | VSTRING | 6 | 0 | 6 | InvoicesYTD | No of Invoices YTD | |||
SL01047 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountChargedInterestYTD | Charged Interest YTD | |||
SL01048 | NVARCHAR | VSTRING | 6 | 0 | 6 | DaysNoTotalDuePayments | Total Days Due Payment | |||
SL01049 | NVARCHAR | VSTRING | 4 | 0 | 4 | InvoicesTotal | Number of 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 | Internal Note 1 | |||
SL01053 | NVARCHAR | VSTRING | 25 | 0 | 25 | Remark2 | Internal Note 2 | |||
SL01054 | NVARCHAR | VSTRING | 35 | 0 | 35 | AlphaSearchKey | Customer Search Key | |||
SL01055 | NVARCHAR | VSTRING | 3 | 0 | 3 | ReminderNo | Number of Reminders | |||
SL01056 | NVARCHAR | VSTRING | 10 | 0 | 10 | MainCustomerCode | Main Customer Code | |||
SL01057 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountOrderedNotShippedLCU | Ordered Not Shipped | |||
SL01058 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountShippedNotInvoicedLCU | Shipped 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 Invoices Printed | |||
SL01062 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountPrevYear-1 | Sales Previous Year — 1 | |||
SL01063 | NVARCHAR | VSTRING | 20 | 0 | 20 | ProfitPrevYear-1 | 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 Support | |||
SL01067 | NVARCHAR | VSTRING | 1 | 0 | 1 | InternalActionFlag | Frequency 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 | SNICode | Customer Trade Code | |||
SL01073 | NVARCHAR | VSTRING | 1 | 0 | 1 | FeeInvoiceFlag | Invoicing Fee (Local Currency) | |||
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 | EDI Delivery Address Number | |||
SL01080 | NVARCHAR | VSTRING | 5 | 0 | 5 | Bonus | Bonus % | |||
SL01081 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountAllocatedBonusYTD | Allocated Bonus YTD (Local Currency) | |||
SL01082 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountEarlySettlmentDiscountYTD | Cash Discounts Taken YTD (Local Currency) | |||
SL01083 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
SL01084 | NVARCHAR | VSTRING | 10 | 0 | 10 | Technician | Technician | |||
SL01085 | NVARCHAR | VSTRING | 1 | 0 | 1 | DocumentLayout | Document Layout | |||
SL01086 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccrualCode | Accrual Code | |||
SL01087 | NVARCHAR | VSTRING | 2 | 0 | 2 | CommissionCode | Commission Code | |||
SL01088 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountNextYTD | Sales Next YTD (Local Currency) | |||
SL01089 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountNextPeriod | Sales Next Period (Local Currency) | |||
SL01090 | NVARCHAR | VSTRING | 20 | 0 | 20 | ProfitNextYTD | Profit Next YTD (Local Currency) | |||
SL01091 | NVARCHAR | VSTRING | 20 | 0 | 20 | ProfitNextPeriod | Profit Next Period (Local Currency) | |||
SL01092 | NVARCHAR | VSTRING | 16 | 0 | 16 | FiscalCode | Fiscal Registration Code | |||
SL01093 | NVARCHAR | VSTRING | 10 | 0 | 10 | BankCode | Bank Code | |||
SL01094 | NVARCHAR | VSTRING | 34 | 0 | 34 | BankAccountNo | Bank Account Number | |||
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 | Common Warehouse | |||
SL01101 | NVARCHAR | VSTRING | 1 | 0 | 1 | PartialDeliveryFlag | 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. |
||
SL01102 | NVARCHAR | VSTRING | 1 | 0 | 1 | PaymentLedgerFlag | Payment Ledger | |||
SL01103 | NVARCHAR | VSTRING | 4 | 0 | 4 | Forwarder | 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 Flag | 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 | Complete 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 | Pre-payment Account | |||
SL01112 | 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 |
||
SL01113 | NCHAR | STRING | 1 | 0 | 1 | JurisdictionTAXCode | Tax Jurisdiction | 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 Terms | |||
SL01117 | NCHAR | STRING | 1 | 0 | 1 | DueDateMethodFlag | Due Date 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 On | |||
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 | DraftCustomerFlag | Draft Customer | |||
SL01125 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | The code that is used by the customer to identify us as supplier. | ||
SL01126 | NCHAR | STRING | 10 | 0 | 10 | ATPOrderPriorityRescheduling | Ordering Priority ATP Rescheduling | |||
SL01127 | NCHAR | SWITCH | 1 | 0 | 1 | ATPAcceptOrderLineSplit | Accept Order Line Split ATP | |||
SL01128 | NCHAR | SWITCH | 1 | 0 | 1 | ATPAcceptOrderSplit | Accept Order Split 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 | Spare | |||
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 | Fin 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 | |||
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 | Auto print DN | |||
SL01160 | NVARCHAR | VSTRING | 1 | 0 | 1 | AutosendDN | Auto send DN | |||
SL01161 | NCHAR | STRING | 1 | 0 | 1 | NeedBackOrder | Need back-order | |||
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 | TaxIDType | |||
SL01165 | NCHAR | STRING | 2 | 0 | 2 | ResponsibilityType | ResponsibilityType | |||
SL01166 | NVARCHAR | VSTRING | 4 | 0 | 4 | Harbour | Harbour | |||
SL01167 | NVARCHAR | VSTRING | 2 | 0 | 2 | Bundesland | Bundesland | |||
SL01168 | NVARCHAR | VSTRING | 6 | 0 | 6 | StatManner | StatManner | |||
SL01169 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrIdentNumber | CurrIdentNumber | |||
SL01170 | NVARCHAR | VSTRING | 2 | 0 | 2 | ECDepartment | ECDepartment | |||
SL01171 | NVARCHAR | VSTRING | 2 | 0 | 2 | Regime | Regime | |||
SL01172 | NVARCHAR | VSTRING | 1 | 0 | 1 | AutoPrintInvoice | Auto print Invoice | |||
SL01173 | NVARCHAR | VSTRING | 1 | 0 | 1 | AutoSendInvoice | Auto send Invoice | |||
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 | Paymnt Exclud Month | |||
SL01178 | NVARCHAR | VSTRING | 1 | 0 | 1 | ReleaseForDN | Release For DN | |||
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 | DA for Consolidated Sales Orders | |||
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 | Ext. User defined field 1 | |||
SL01199 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld2 | Ext. User defined field 2 | |||
SL01200 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld3 | Ext. User defined field 3 | |||
SL01201 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld4 | Ext. User defined field 4 | |||
SL01202 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld5 | Ext. User defined field 5 | |||
SL01203 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld6 | Ext. User defined field 6 | |||
SL01204 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld7 | Ext. User defined field 7 | |||
SL01205 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld8 | Ext. User defined field 8 | |||
SL01206 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld9 | Ext. User defined field 9 | |||
SL01207 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld10 | Ext. User defined field 10 | |||
SL01208 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld11 | Ext. User defined field 11 | |||
SL01209 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld12 | Ext. User defined field 12 | |||
SL01210 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld13 | Ext. User defined field 13 | |||
SL01211 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld14 | Ext. User defined field 14 | |||
SL01212 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld15 | Ext. User defined field 15 | |||
SL01213 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld16 | Ext. User defined field 16 | |||
SL01214 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld17 | Ext. User defined field 17 | |||
SL01215 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld18 | Ext. User defined field 18 | |||
SL01216 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld19 | Ext. User defined field 19 | |||
SL01217 | NVARCHAR | VSTRING | 150 | 0 | 150 | ExtUserDefFld20 | Ext. User defined field 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 on credit check | |||
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 | Spesometro Forms | |||
SL01240 | NVARCHAR | VSTRING | 15 | 0 | 15 | PostalGiroAC | Postal Giro A/C | |||
SL01241 | NVARCHAR | VSTRING | 15 | 0 | 15 | BankGiroAC | Postal Giro A/C | |||
SL01242 | NCHAR | STRING | 2 | 0 | 2 | CreditPayWay | Credit Pay Way | |||
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 | WHT axes On Add Order Costs LCU | |||
SL01247 | NUMERIC | MONEY | 28 | 8 | 20 | WHTaxesOnAllocNotShippedLCU | WH Taxes On Alloc 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 Add 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 | Tax Reason Code |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Основными Средствами» / List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Контрактами» / List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Прямая выписка счетов» / List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Ресурсами» / List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «База данных рынка» / List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заработная плата» / List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Долговые обязательства» / List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Статистика» / List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Системные Утилиты» / List of tables of module «System Utilities/Office Autom.»