Таблица: 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 | 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 | 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 | 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 | 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 | 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 | 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 | LTM Group | LTM Group | |||
SL19157 | NCHAR | STRING | 1 | 0 | 1 | DropShipment | Drop Shipment Flag | |||
SL19158 | INT | INTEGER | 0 | 0 | 4 | Delivery Note, sort | Delivery Note, sort | |||
SL19159 | NVARCHAR | VSTRING | 1 | 0 | 1 | Auto print DN | Auto print DN | |||
SL19160 | NVARCHAR | VSTRING | 1 | 0 | 1 | Auto send DN | Auto send DN | |||
SL19161 | NCHAR | STRING | 1 | 0 | 1 | Need back-order | Need back-order | |||
SL19162 | INT | INTEGER | 0 | 0 | 1 | Delivery note printing | Delivery note printing | |||
SL19163 | INT | INTEGER | 0 | 0 | 1 | Invoice printing | 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 | ||||
SL19167 | NVARCHAR | VSTRING | 2 | 0 | 2 | Bundesland | ||||
SL19168 | NVARCHAR | VSTRING | 6 | 0 | 6 | StatManner | ||||
SL19169 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrIdentNumber | ||||
SL19170 | NVARCHAR | VSTRING | 2 | 0 | 2 | ECDepartment | ||||
SL19171 | NVARCHAR | VSTRING | 2 | 0 | 2 | 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 | Merge RIBA | Merge RIBA | |||
SL19183 | NVARCHAR | VSTRING | 2 | 0 | 2 | Payment Address Code | Payment Address Code | |||
SL19184 | NVARCHAR | VSTRING | 2 | 0 | 2 | Invoice Address Code | Invoice Address Code | |||
SL19185 | NVARCHAR | VSTRING | 2 | 0 | 2 | Invoice Sent Address Code | 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 | DA for Consolidated Sales Orders | DA for Consolidated Sales Orders | |||
SL19190 | NVARCHAR | VSTRING | 10 | 0 | 10 | Region Code | Region Code | GEO unit | ||
SL19191 | NVARCHAR | VSTRING | 10 | 0 | 10 | State/Province Code | State/Province Code | GEo unit | ||
SL19192 | NVARCHAR | VSTRING | 10 | 0 | 10 | County Code | County Code | GEO unit | ||
SL19193 | NVARCHAR | VSTRING | 200 | 0 | 200 | Email address | 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 | 50 | 0 | 50 | Ext. User defined field 1 | Ext. User defined field 1 | |||
SL19199 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 2 | Ext. User defined field 2 | |||
SL19200 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 3 | Ext. User defined field 3 | |||
SL19201 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 4 | Ext. User defined field 4 | |||
SL19202 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 5 | Ext. User defined field 5 | |||
SL19203 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 6 | Ext. User defined field 6 | |||
SL19204 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 7 | Ext. User defined field 7 | |||
SL19205 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 8 | Ext. User defined field 8 | |||
SL19206 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 9 | Ext. User defined field 9 | |||
SL19207 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 10 | Ext. User defined field 10 | |||
SL19208 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 11 | Ext. User defined field 11 | |||
SL19209 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 12 | Ext. User defined field 12 | |||
SL19210 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 13 | Ext. User defined field 13 | |||
SL19211 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 14 | Ext. User defined field 14 | |||
SL19212 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 15 | Ext. User defined field 15 | |||
SL19213 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 16 | Ext. User defined field 16 | |||
SL19214 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 17 | Ext. User defined field 17 | |||
SL19215 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 18 | Ext. User defined field 18 | |||
SL19216 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 19 | Ext. User defined field 19 | |||
SL19217 | NVARCHAR | VSTRING | 50 | 0 | 50 | Ext. User defined field 20 | Ext. User defined field 20 | |||
SL19218 | NVARCHAR | VSTRING | 1 | 0 | 1 | Partial Delivery Planning | Partial Delivery Planning | 0 – allowed
1 – prohibited |
||
SL19219 | NCHAR | SWITCH | 1 | 0 | 1 | License Flag | License Flag | |||
SL19220 | DATETIME | DATE | 0 | 0 | 8 | Licensed From | Licensed From | |||
SL19221 | DATETIME | DATE | 0 | 0 | 8 | Licensed To | Licensed To |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Sales Ledger | Customer Templates