One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table SM11 — Service Contract Master

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM11001 NCHAR STRING 10 0 10 ServContrNo Service Contract Number   1 Да / Yes
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 Spare (obsolete)      
SM11011 NCHAR STRING 2 0 2 PaymentTerm Payment Terms      
SM11012 DATETIME DATE 0 0 8 ContractDate Contract Date      
SM11013 DATETIME DATE 0 0 8 Spare Spare      
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 InvoiceCurrencyCode 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 PriceListDefault Price List      
SM11034 NCHAR STRING 3 0 3 ContractCode Contract Type      
SM11035 INT INTEGER 0 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 NVARCHAR VSTRING 30 0 30 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 LabourHoursIncluded Labour Hours Included      
SM11075 NCHAR STRING 2 0 2 CostPriceCode Cost Price Code      
SM11076 NUMERIC MONEY 28 8 20 CostPriceOCU Cost Unit Price (Contract Currency)      
SM11077 NUMERIC X_NUMERIC 20 8 12 CostHoursIncluded Cost Quantity Included      
SM11078 NCHAR STRING 2 0 2 MtrlPriceCode Material Price Code      
SM11079 NUMERIC MONEY 28 8 20 MtrlPriceOCU Material Unit Price (Contract Currency)      
SM11080 NUMERIC X_NUMERIC 20 8 12 MtrlHoursIncluded 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 Invoice1No 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 Invoice2No Invoice 2 Number Second to last invoice printed and closed    
SM11089 DATETIME DATE 0 0 8 DueDateInv2 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 120 0 120 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 FlagCreateCreditNote Generate Credit Note/Invoice      
SM11109 NCHAR STRING 1 0 1 ConsolidationModeForLeaseContracts Consolidation Mode for Lease Contracts      
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 6 0 6 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 OngoingContractBalanceNetLCU Ongoing contract balance, net in LCU      
SM11125 NUMERIC MONEY 28 8 20 OngoingContractBalanceTaxLCU Ongoing contract balance, tax in LCU      
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 DefaultInvoiceIntervalTimeUnit Unit Code Invoice Interval 1 — Years

2 — Month

3 — Weeks

4 — Days
   
SM11135 INT INTEGER 0 0 20 DiscountInterval1 Discount Interval Period 1      
SM11136 INT INTEGER 0 0 10 DiscountInterval2 Discount Interval Period 2      
SM11137 INT INTEGER 0 0 10 DiscountInterval3 Discount Interval Period 3      
SM11138 INT INTEGER 0 0 10 DiscountInterval4 Discount Interval Period 4      
SM11139 INT INTEGER 0 0 10 Discount1TimeUnit Discount Time Unit Period 1 -1 — During Warranty

1 — Years

2 — Month

3 — Weeks

4 — Days
   
SM11140 INT INTEGER 0 0 10 Discount2TimeUnit Discount Time Unit Period 2 -1 — During Warranty

1 — Years

2 — Month

3 — Weeks

4 — Days
   
SM11141 INT INTEGER 0 0 10 Discount3TimeUnit Discount Time Unit Period 3 -1 — During Warranty

1 — Years

2 — Month

3 — Weeks

4 — Days
   
SM11142 INT INTEGER 0 0 10 Discount4TimeUnit Discount Time Unit Period 4 -1 — During Warranty

1 — Years

2 — Month

3 — Weeks

4 — Days
   
SM11143 NCHAR STRING 2 0 2 AccountingCode 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 6 0 6 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 Spare Spare      
SM11156 DATETIME DATE 0 0 8 Spare Spare      
SM11157 NCHAR STRING 10 0 10 SupplierCode Supplier Code      
SM11158 NVARCHAR VSTRING 35 0 35 CustomerName Customer Name      
SM11159 NVARCHAR VSTRING 35 0 35 ShippingAddress Shipping Address      
SM11160 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
SM11161 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
SM11162 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
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 AvoidBackorders Avoid Backorders      
SM11172 NCHAR SWITCH 1 0 1 AcceptLineSplit Accept Line Split      
SM11173 NCHAR SWITCH 1 0 1 AcceptOrderSplit 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 DelNoteSort Delivery Note, sort      
SM11179 NVARCHAR VSTRING 1 0 1 AutoprintDN Auto print DN      
SM11180 NVARCHAR VSTRING 1 0 1 AutosendDN Auto send DN      
SM11181 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
SM11182 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
SM11183 NCHAR SWITCH 1 0 1 Instalment Instalment      
SM11184 NUMERIC X_NUMERIC 20 8 12 InterestPercent Interest%      
SM11185 NUMERIC X_NUMERIC 20 8 12 NewInterestPercent New Interest%      
SM11186 DATETIME DATE 0 0 8 ActivateNewInterestDate Activate New Interest Date      
SM11187 NUMERIC MONEY 28 8 20 FinancialCharge Financial Charge      
SM11188 NCHAR STRING 6 0 6 InterestTaxCode Interest Tax Code      
SM11189 NCHAR STRING 6 0 6 FinancialTaxCode Financial Tax Code      
SM11190 NVARCHAR VSTRING 10 0 10 DefaultEngineer Default Engineer      
SM11191 NCHAR SWITCH 1 0 1 ReorderCustomer Reorder Customer      
SM11192 INT INTEGER 0 0 1 DelNotePrinting Delivery note printing      
SM11193 INT INTEGER 0 0 1 InvPrinting Invoice printing      
SM11194 DATETIME DATE 0 0 8 ContractPricingDate Contract Pricing Date      
SM11195 NCHAR STRING 10 0 10 ContractPricingNumber Contract Pricing Number      
SM11196 INT INTEGER 0 0 1 CreditNoteClosureStatus Credit Note Closure Status      
SM11197 NCHAR STRING 10 0 10 ExecutionOrderNo Execution Order No      
SM11198 NCHAR STRING 2 0 2 District District      
SM11199 NCHAR STRING 2 0 2 AdvertisingCode Advertising Code      
SM11200 NCHAR STRING 4 0 4 CityCode City Code      
SM11201 NCHAR STRING 5 0 5 SNICode SNI Code      
SM11202 NCHAR STRING 1 0 1 CommissionDistributionMethod Commission Distribution Method      
SM11203 NCHAR STRING 2 0 2 CustomerAccountCode Customer Account Code      
SM11204 NCHAR SWITCH 1 0 1 Spare (obsolete)      
SM11205 NVARCHAR VSTRING 6 0 6 DepotWH Depot WH      
SM11206 INT INTEGER 0 0 1 PriceTypeAsset Price Type Asset      
SM11207 INT INTEGER 0 0 1 PriceTypeAccessory Price Type Accessory      
SM11208 INT INTEGER 0 0 1 DocumentSpecification Document Specification      
SM11209 INT INTEGER 0 0 1 InvoiceSpecification Invoice Specification      
SM11210 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
SM11211 NVARCHAR VSTRING 2 0 2 PaymentAddressCode Payment Address Code      
SM11212 NVARCHAR VSTRING 12 0 12 Spare Spare Previously it was «Invoice Counter ID»    
SM11213 INT INTEGER 0 0 7 ContrIntervalLength Contract Interval Length      
SM11214 INT INTEGER 0 0 1 ContrIntervalTimeUnit Contract Interval Time Unit 1 — Years

2 — Month

3 — Weeks

4 — Days
   
SM11215 INT INTEGER 0 0 1 DeliveryDateMilestone Delivery Date Milestone      
SM11216 NUMERIC X_NUMERIC 20 8 12 DeliveryTimeValue Delivery Time Value      
SM11217 INT INTEGER 0 0 2 DeliveryTimeUnit Delivery Time Unit      
SM11218 INT INTEGER 0 0 4 InvoiceCopyNumber Invoice Copy Number      
SM11219 INT INTEGER 0 0 1 Spare (obsolete)      
SM11220 NVARCHAR VSTRING 200 0 200 EmailAddress E-Mail Address      
SM11221 DATETIME X_DATETIME 0 0 17 InvoiceTime Invoice Time      
SM11222 INT INTEGER 0 0 2 InvoicingModel Invoicing Model      
SM11223 NUMERIC MONEY 28 8 20 FixedPrice Fixed Price      
SM11224 NCHAR SWITCH 1 0 1 CreditCheckPassed Credit Check Passed      
SM11225 NVARCHAR VSTRING 30 0 30 LinkedProjectActivity Linked Project Activity      
SM11226 NCHAR STRING 6 0 6 InvoicePlanLineNumber Invoice Plan Line Number      
SM11227 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
SM11228 NCHAR STRING 1 0 1 TaxPoint Tax Point      
SM11229 NVARCHAR VSTRING 20 0 20 PublicProcurementCode1 Public Procurement Code 1      
SM11230 NVARCHAR VSTRING 20 0 20 PublicProcurementCode2 Public Procurement Code 2      
SM11231 NVARCHAR VSTRING 10 0 10 Operation Type (Service Contract Line or Asset Lease Line) Operation Type (Service Contract Line or Asset Lease Line)      
SM11232 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Service Contract Line or Asset Lease Line) Financial Operation Code (Service Contract Line or Asset Lease Line)      
SM11233 NVARCHAR VSTRING 10 0 10 OperationType_AssetMaintenanceLine Operation Type (Asset Maintenance Line)      
SM11234 NVARCHAR VSTRING 10 0 10 FinancialOperationCode_AssetMaintenanceLine Financial Operation Code (Asset Maintenance Line)      
SM11235 NVARCHAR VSTRING 10 0 10 OperationType_AccessoryLeaseLine Operation Type (Accessory Lease Line)      
SM11236 NVARCHAR VSTRING 10 0 10 FinancialOperationCode_AccessoryLeaseLine Financial Operation Code (Accessory Lease Line)      
SM11237 NVARCHAR VSTRING 10 0 10 OperationType_AccessoryMaintenanceLine Operation Type (Accessory Maintenance Line)      
SM11238 NVARCHAR VSTRING 10 0 10 FinancialOperationCode_AccessoryMaintenanceLine Financial Operation Code (Accessory Maintenance Line)      
SM11239 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate1 OCU Exchange Rate 1      
SM11240 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate2 OCU Exchange Rate 2      
SM11241 NCHAR STRING 3 0 3 OCUExchangeAlgorithm OCU Exchange Algorithm      
SM11242 NUMERIC X_NUMERIC 18 8 10 ICUExchangeRate1 ICU Exchange Rate 1      
SM11243 NUMERIC X_NUMERIC 18 8 10 ICUExchangeRate2 ICU Exchange Rate 2      
SM11244 NCHAR STRING 3 0 3 ICUExchangeAlgorithm ICU Exchange Algorithm      

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