Таблица: SM11 - «Service Contract Master File I/O». Маска имени таблицы: «SM11%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SM11001 NCHAR STRING 10 0 10 ServContrNo Service Contract Number   1 Да
SM11002 NCHAR STRING 10 0 10 ICusCodeBuyer Customer Code Invoice (Contract)      
SM11003 NCHAR STRING 10 0 10 CustCodeCont Customer Code Service Address      
SM11004 NVARCHAR VSTRING 35 0 35 CustomerRef Customer Reference      
SM11005 NVARCHAR VSTRING 35 0 35 Remarks1 Remark Line 1      
SM11006 NVARCHAR VSTRING 35 0 35 Remarks2 Remark Line 2      
SM11007 INT INTEGER 0 0 1 FLAGContract Contract Print Status 0 - The contract will not be sent.
1 - The contract is sent automatically when a new contract is entered.
2 - The contract has been sent.
   
SM11008 INT INTEGER 0 0 1 FLAGDoc2 Document 1 Print Status 0 - Own Document 1 will not be sent.
1 - Own Document 1 will be sent.
2 - Own Document 1 has been sent.
   
SM11009 INT INTEGER 0 0 1 FLAGDoc3 Document 2 Print Status 0 - Own Document 2 will not be sent.
1 - Own Document 2 will be sent.
2 - Own Document 2 has been sent.
   
SM11010 INT INTEGER 0 0 1 FLAGInvoice Invoice Print Status 0 - Invoice will not be sent
1 - Invoice will be sent
Note: Invoice printing is controlled internally by schedule, not this status
   
SM11011 NCHAR STRING 2 0 2 PaymentTerm Payment Terms      
SM11012 DATETIME DATE 0 0 8 ContractDate Contract Date      
SM11013 DATETIME DATE 0 0 8 NextInvDate Next Invoicing Date      
SM11014 INT INTEGER 0 0 4 InvIntervall Invoicing Interval Defines the time interval in month, years, week or days between each invoice. The time unit is defined in column SM11134    
SM11015 DATETIME DATE 0 0 8 ContrStrDate Contract Start Date      
SM11016 DATETIME DATE 0 0 8 ContrEndDate Contract End Date      
SM11017 NCHAR STRING 3 0 3 SalesmanNo Salesman      
SM11018 NVARCHAR VSTRING 35 0 35 OurReference Our Reference      
SM11019 NUMERIC X_NUMERIC 15 8 7 OrdDiscount Order Discount Period 1 %      
SM11020 NCHAR STRING 15 0 15 InvoiceNo Invoice Number Current invoice number for contract that have been invoice but not closed    
SM11021 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SM11022 NUMERIC MONEY 28 8 20 ContractValueOCU Contract Value (Contract Currency)      
SM11023 INT INTEGER 0 0 6 Spare Currency Code Invoice      
SM11024 NCHAR STRING 6 0 6 Spare (obsolete)      
SM11025 NCHAR STRING 6 0 6 TaxLiability Tax Liability Code      
SM11026 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
SM11027 NCHAR STRING 2 0 2 ContractCurrencyCode Currency Code Contract      
SM11028 NCHAR SWITCH 1 0 1 FLAGExpOrder Is Export Contract      
SM11029 NCHAR SWITCH 1 0 1 IndexClause Has Index Clause      
SM11030 NUMERIC MONEY 28 8 20 MinServCharLCU Minimum Service Charge (Local Currency)      
SM11031 NUMERIC MONEY 28 8 20 AccInvAmntOCU Accumulated Invoiced Amount (Contract Currency)      
SM11032 NUMERIC MONEY 28 8 20 HandlingFeeLCU Invoice Fee (Local Currency)      
SM11033 NCHAR STRING 2 0 2 PriceList_Default Price List      
SM11034 NCHAR STRING 3 0 3 ContractCode Contract Type      
SM11035 NCHAR SWITCH 1 0 1 PriceType Price Type 0 - The prices entered on the contract lines are used, index can be used to restate the prices at invoice time.
1 - Current price from price list will be used at the time of invoice.
   
SM11036 NUMERIC X_NUMERIC 15 8 7 ExternalComm External Commission %      
SM11037 NCHAR STRING 10 0 10 ExternComCode External Commission Code      
SM11038 NCHAR STRING 1 0 1 DocumLayout Document Layout      
SM11039 NCHAR STRING 1 0 1 InvRoundMod Invoice Rounding Model Used internally to keep information how rounding where calculated during printing of invoices.    
SM11040 NCHAR STRING 20 0 20 CustPONo Customer Purchase Order Number      
SM11041 DATETIME DATE 0 0 8 LastInvDate Last Invoicing Date      
SM11042 NCHAR STRING 15 0 15 LastInvoicNo Last Invoice Number Specifies the last contract invoice number that was printed and closed.    
SM11043 INT INTEGER 0 0 1 OrdMergeOption Order Merge Option Invoice merge option (invoices will be consolidated in sales ledger).
0 - No consolidated invoice
1 - Consolidate invoice per week
2 - Consolidate invoice per month
   
SM11044 NCHAR STRING 4 0 4 CustSiteNo Site Code      
SM11045 INT INTEGER 0 0 2 IndexSched1 Index Month 1      
SM11046 INT INTEGER 0 0 2 IndexSched2 Index Month 2      
SM11047 INT INTEGER 0 0 2 IndexSched3 Index Month 3      
SM11048 INT INTEGER 0 0 2 IndexSched4 Index Month 4      
SM11049 INT INTEGER 0 0 1 Index1No Index 1 Number      
SM11050 DATETIME DATE 0 0 8 Idx1BaseDate Index 1 Base Date      
SM11051 NUMERIC X_NUMERIC 18 8 10 Idx1Value Index 1 Value      
SM11052 NUMERIC X_NUMERIC 15 8 7 Idx1Weighting Index 1 Weighting      
SM11053 INT INTEGER 0 0 1 Index2No Index 2 Number      
SM11054 DATETIME DATE 0 0 8 Idx2BaseDate Index 2 Base Date      
SM11055 NUMERIC X_NUMERIC 18 8 10 Idx2Value Index 2 Value      
SM11056 NUMERIC X_NUMERIC 15 8 7 Idx2Weighting Index 2 Weighting      
SM11057 INT INTEGER 0 0 1 Index3No Index 3 Number      
SM11058 DATETIME DATE 0 0 8 Idx3BaseDate Index 3 Base Date      
SM11059 NUMERIC X_NUMERIC 18 8 10 Idx3Value Index 3 Value      
SM11060 NUMERIC X_NUMERIC 15 8 7 Idx3Weighting Index 3 Weighting      
SM11061 INT INTEGER 0 0 1 Index4No Index 4 Number      
SM11062 DATETIME DATE 0 0 8 Idx4BaseDate Index 4 Base Date      
SM11063 NUMERIC X_NUMERIC 18 8 10 Idx4Value Index 4 Value      
SM11064 NUMERIC X_NUMERIC 15 8 7 Idx4Weighting Index 4 Weighting      
SM11065 INT INTEGER 0 0 1 FLContrCancel Cancellation Document Print Status 0 - Cancellation Document will not be sent.
1 - Cancellation Document will be sent.
2 - Cancellation Document been sent.
   
SM11066 NCHAR SWITCH 1 0 1 FLCreditInv Credit When Cancel 1 - When deleting a contract line from the contract, a credit is
made for overcharging, for example payment in advance.
0 - No credit is allowed when deleting a line.
   
SM11067 NCHAR SWITCH 1 0 1 FLFixPrices Has Fixed Prices      
SM11068 NCHAR STRING 2 0 2 ContractType Contract Code      
SM11069 NUMERIC X_NUMERIC 15 8 7 DiscntLabour Discount on Labour %      
SM11070 NUMERIC X_NUMERIC 15 8 7 DiscntCosts Discount on Costs %      
SM11071 NUMERIC X_NUMERIC 15 8 7 DiscntParts Discount on Parts %      
SM11072 NCHAR STRING 2 0 2 LabPricCode Labour Price Code      
SM11073 NUMERIC MONEY 28 8 20 PricehourOCU Labour Price per Hour (Contract Currency)      
SM11074 NUMERIC X_NUMERIC 20 8 12 HoursIncluded Labour Hours Included      
SM11075 NCHAR STRING 2 0 2 LabPricCode Cost Price Code      
SM11076 NUMERIC MONEY 28 8 20 PricehourOCU Cost Unit Price (Contract Currency)      
SM11077 NUMERIC X_NUMERIC 20 8 12 HoursIncluded Cost Quantity Included      
SM11078 NCHAR STRING 2 0 2 LabPricCode Material Price Code      
SM11079 NUMERIC MONEY 28 8 20 PricehourOCU Material Unit Price (Contract Currency)      
SM11080 NUMERIC X_NUMERIC 20 8 12 HoursIncluded Material Quantity Included      
SM11081 NCHAR STRING 1 0 1 TypeOfTimeBank Type of Time Bank      
SM11082 NUMERIC X_NUMERIC 20 8 12 HoursIncluded Hours Included      
SM11083 NUMERIC X_NUMERIC 20 8 12 HoursWorked Hours Worked      
SM11084 INT INTEGER 0 0 1 FLAGLabels Labels Print Status 0 - Labels will not be sent.
1 - Labels will be sent.
2 - Labels been sent.
   
SM11085 NUMERIC X_NUMERIC 18 8 10 LatestIdxAdjust Latest Index Adjustment      
SM11086 NCHAR STRING 15 0 15 InvoiceNo Invoice 1 Number Last invoice printed and closed    
SM11087 DATETIME DATE 0 0 8 DueDate Invoice 1 Due Date      
SM11088 NCHAR STRING 15 0 15 InvoiceNo Invoice 2 Number Second to last invoice printed and closed    
SM11089 DATETIME DATE 0 0 8 DueDate Invoice 2 Due Date      
SM11090 NCHAR SWITCH 1 0 1 FLInvDuePmt Invoice is Due for Payment      
SM11091 INT INTEGER 0 0 1 QuotationStatus Contract Status 0 - Quotation
1 - Equipment/reference
2 - Contract terms, no invoice
3 - Invoice contract
   
SM11092 INT INTEGER 0 0 1 FLQuotation Quotation Print Status 0 - Quotation will not be sent.
1 - Quotation will be sent.
2 - Quotation has been sent.
   
SM11093 NCHAR STRING 20 0 20 CustAlphaKey Customer Search Key      
SM11094 NVARCHAR VSTRING 20 0 20 SiteName Site Name      
SM11095 NCHAR SWITCH 1 0 1 FLAGTempInv Invoice is Blocked 0 - Invoices will be generated according to specified invoice interval and terms
1 - Generation of invoices is temporary blocked for the contract
   
SM11096 INT INTEGER 0 0 1 ExtensStatus Contract Terms 0 - Automatic renewal with 12 months after expiration of contract time.
1 - Manual renewal, the contract must be renewed after expiration.
2 - Cancelled.
   
SM11097 DATETIME DATE 0 0 8 LastChngDate Date Changed      
SM11098 DATETIME DATE 0 0 8 LastChngIdx Date Index Changed      
SM11099 NCHAR SWITCH 1 0 1 FlagChanging Changes are Made      
SM11100 DATETIME DATE 0 0 8 LateIdxTabDt Latest Index Table Date      
SM11101 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
SM11102 NCHAR STRING 10 0 10 ICusCodeCont Customer Code Invoice (Contractual Service) Specifies the customer that shall be charged for services that are covered by the contract, excluding service of part with valid warranty.    
SM11103 NCHAR SWITCH 1 0 1 StdContCode Standard Contract Type      
SM11104 NUMERIC X_NUMERIC 20 8 12 ResponceTime Response Time      
SM11105 NUMERIC X_NUMERIC 20 8 12 ETATime Call-back Time (ETA)      
SM11106 NCHAR STRING 1 0 1 InvoiceRoundModel Invoice Rounding Model      
SM11107 NCHAR STRING 1 0 1 CurrencyContract Has Currency Contract      
SM11108 NCHAR STRING 1 0 1 Flag_Create_CreditNote Generate Credit Note/Invoice      
SM11109 NCHAR STRING 1 0 1 Spare (obsolete)      
SM11110 NCHAR STRING 1 0 1 Spare (obsolete)      
SM11111 NCHAR STRING 1 0 1 Spare (obsolete)      
SM11112 NCHAR SWITCH 1 0 1 FlagForText Has Extended Text      
SM11113 NCHAR STRING 3 0 3 Manager Salesman Contract Administrator      
SM11114 NCHAR STRING 10 0 10 MasterContract Master Contract      
SM11115 NCHAR STRING 4 0 4 Spare (obsolete)      
SM11116 NUMERIC X_NUMERIC 15 8 7 OrderDisc2 Order Discount Period 2 %      
SM11117 NCHAR STRING 4 0 4 Spare (obsolete)      
SM11118 NUMERIC X_NUMERIC 15 8 7 OrderDisc3 Order Discount Period 3 %      
SM11119 NCHAR STRING 4 0 4 Spare (obsolete)      
SM11120 NUMERIC X_NUMERIC 15 8 7 OrderDisc4 Order Discount Period 4 %      
SM11121 NCHAR STRING 4 0 4 Spare (obsolete)      
SM11122 NCHAR STRING 10 0 10 ICustGaranti Customer Code Invoice (Warranty Service) Specifies thee customer that shall be charged for services that are covered by a valid warranty.    
SM11123 NCHAR STRING 3 0 3 ContCodeGuarantee Contract Type Warranty      
SM11124 NUMERIC MONEY 28 8 20 ContractValueLCU Contract Value (Local Currency)      
SM11125 NUMERIC MONEY 28 8 20 ActInvAmountLCU Accumulated Invoiced Amount (Local Currency)      
SM11126 NUMERIC X_NUMERIC 23 8 15 FixExchRate1 Fixed Exchange Rate 1      
SM11127 NUMERIC X_NUMERIC 23 8 15 FixExchRate2 Fixed Exchange Rate 2      
SM11128 NCHAR STRING 3 0 3 FixExchAlgorithm Fixed Exchange Rate Algorithm      
SM11129 NCHAR STRING 15 0 15 CurrencyContractNr Currency Contract Number      
SM11130 NCHAR STRING 8 0 8 CampaignCode Campaign Code      
SM11131 NCHAR SWITCH 1 0 1 InvInAdvance Invoice In Advance      
SM11132 NCHAR STRING 10 0 10 RequestNo Customer Request Number      
SM11133 NCHAR STRING 10 0 10 CalendarID Calendar ID      
SM11134 INT INTEGER 0 0 2 Default_InvoiceIntervalTimeUnit Unit Code Invoice Interval 1 - Years
2 - Month
3 - Weeks
4 - Days
   
SM11135 INT INTEGER 0 0 20 Discount interval 1 Discount Interval Period 1      
SM11136 INT INTEGER 0 0 10 Discount interval 2 Discount Interval Period 2      
SM11137 INT INTEGER 0 0 10 Discount interval 3 Discount Interval Period 3      
SM11138 INT INTEGER 0 0 10 Discount interval 4 Discount Interval Period 4      
SM11139 INT INTEGER 0 0 10 Discount 1 Time Unit Discount Time Unit Period 1 -1 - During Warranty
1 - Years
2 - Month
3 - Weeks
4 - Days
   
SM11140 INT INTEGER 0 0 10 Discount 2 Time Unit Discount Time Unit Period 2 -1 - During Warranty
1 - Years
2 - Month
3 - Weeks
4 - Days
   
SM11141 INT INTEGER 0 0 10 Discount 3 Time Unit Discount Time Unit Period 3 -1 - During Warranty
1 - Years
2 - Month
3 - Weeks
4 - Days
   
SM11142 INT INTEGER 0 0 10 Discount 4 Time Unit Discount Time Unit Period 4 -1 - During Warranty
1 - Years
2 - Month
3 - Weeks
4 - Days
   
SM11143 NCHAR STRING 2 0 2 Accounting Code Accounting Code      
SM11144 NCHAR SWITCH 1 0 1 FLAGElectronicContract Has Electronic Contract      
SM11145 INT INTEGER 0 0 1 FLAGDocXMLContract EDI/XML Contract Status 0 - The contract will not be sent.
1 - The contract is sent automatically when a new contract is entered.
2 - The contract has been sent.
   
SM11146 INT INTEGER 0 0 1 FLAGDocXMLDoc2 EDI/XML Document 1 0 - Own Document 1 will not be sent.
1 - Own Document 1 will be sent.
2 - Own Document 1 has been sent.
   
SM11147 INT INTEGER 0 0 1 FLAGDocXMLDoc3 EDI/XML Document 2 0 - Own Document 2 will not be sent.
1 - Own Document 2 will be sent.
2 - Own Document 2 has been sent.
   
SM11148 INT INTEGER 0 0 1 FLAGDocXMLCancel EDI/XML Cancellation Document 0 - Cancellation Document will not be sent.
1 - Cancellation Document will be sent.
2 - Cancellation Document been sent.
   
SM11149 INT INTEGER 0 0 1 FLAGDocXMLLabels EDI/XML Labels 0 - Labels will not be sent.
1 - Labels will be sent.
2 - Labels been sent.
   
SM11150 INT INTEGER 0 0 1 FLAGDocXMLQuotation EDI/XML Quotation 0 - Quotation will not be sent.
1 - Quotation will be sent.
2 - Quotation has been sent.
   
SM11151 NVARCHAR VSTRING 4 0 4 InvIssuer Invoice Issuer Code      
SM11152 NCHAR SWITCH 1 0 1 InvCategory Invoice Category      
SM11153 NCHAR SWITCH 1 0 1 InvType Invoice Type      
SM11154 DATETIME DATE 0 0 8 CancellationDate Contract Cancellation Date      
SM11155 DATETIME DATE 0 0 8 InvoiceFrom Invoice From Date      
SM11156 DATETIME DATE 0 0 8 InvoiceTo Invoice To Date      
SM11157 NCHAR STRING 10 0 10 SupplierCode Supplier Code      
SM11158 NVARCHAR VSTRING 35 0 35 CustomerName Customer Name      
SM11159 NVARCHAR VSTRING 35 0 35 ShippingAddress1 Shipping Address Line 1      
SM11160 NVARCHAR VSTRING 35 0 35 ShippingAddress2 Shipping Address Line 2      
SM11161 NVARCHAR VSTRING 35 0 35 ShippingAddress3 Shipping Address Line 3      
SM11162 NVARCHAR VSTRING 35 0 35 ShippingAddress4 Shipping Address Line 4      
SM11163 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser      
SM11164 NVARCHAR VSTRING 2 0 2 PaymentTerms Payment Terms      
SM11165 NVARCHAR VSTRING 2 0 2 DeliveryMethod Delivery Method      
SM11166 NVARCHAR VSTRING 2 0 2 DeliveryTerms Delivery Terms      
SM11167 DATETIME DATE 0 0 8 BookEntryDate Book Entry Date      
SM11168 NCHAR STRING 6 0 6 TaxCodeForInvFee Tax Code for Invoice Fee      
SM11169 INT INTEGER 0 0 2 ReservationDuration Reservation Time Out (Duration)      
SM11170 INT INTEGER 0 0 2 ReservationTimeUnit Reservation Time Out (Time unit)      
SM11171 NCHAR SWITCH 1 0 1 Avoid Backorders Avoid Backorders      
SM11172 NCHAR SWITCH 1 0 1 AcceptLineSplit Accept Line Split      
SM11173 NCHAR SWITCH 1 0 1 Accept Order Split AcceptOrderSplit      
SM11174 NCHAR SWITCH 1 0 1 UseLTM Use LTM      
SM11175 INT INTEGER 0 0 2 AcceptedDeliveryInterval Accepted Delivery Interval      
SM11176 NVARCHAR VSTRING 10 0 10 CarrierCode Carrier Code      
SM11177 NVARCHAR VSTRING 35 0 35 CarrierName Carrier Name      
SM11178 INT INTEGER 0 0 4 Delivery Note, sort Delivery Note, sort      
SM11179 NVARCHAR VSTRING 1 0 1 Auto print DN Auto print DN      
SM11180 NVARCHAR VSTRING 1 0 1 Auto send DN Auto send DN      
SM11181 NVARCHAR VSTRING 10 0 10 Operation Type Operation Type      
SM11182 NVARCHAR VSTRING 10 0 10 Financial Operation Code Financial Operation Code      
SM11183 NCHAR SWITCH 1 0 1 Instalment Instalment      
SM11184 NUMERIC X_NUMERIC 20 8 12 Interest% Interest%      
SM11185 NUMERIC X_NUMERIC 20 8 12 New Interest% New Interest%      
SM11186 DATETIME DATE 0 0 8 Activate New Interest Date Activate New Interest Date      
SM11187 NUMERIC MONEY 28 8 20 Financial Charge Financial Charge      
SM11188 NCHAR STRING 6 0 6 Interest Tax Code Interest Tax Code      
SM11189 NCHAR STRING 6 0 6 Financial Tax Code Financial Tax Code      
SM11190 NVARCHAR VSTRING 10 0 10 Default Engineer Default Engineer      
SM11191 NCHAR SWITCH 1 0 1 Reorder Customer Reorder Customer      
SM11192 INT INTEGER 0 0 1 Delivery note printing Delivery note printing      
SM11193 INT INTEGER 0 0 1 Invoice printing Invoice printing      
SM11194 DATETIME DATE 0 0 8 Contract Pricing Date Contract Pricing Date      
SM11195 NCHAR STRING 10 0 10 Contract Pricing Number Contract Pricing Number      
SM11196 INT INTEGER 0 0 1 Invoice Status Invoice Status      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Service Contract Master