Таблица: SM11 - «Service Contract Head» («Контракты на Обслуживание Загл.»)

Поле Тип поля Scala Длина Scala Комментарий Первич­ный ключ?
SM11001 STRING 10 ServContrNo Да
SM11002 STRING 10 ICusCodeBuyer  
SM11003 STRING 10 CustCodeCont  
SM11004 VSTRING 35 CustomerRef  
SM11005 VSTRING 35 Remarks1  
SM11006 VSTRING 35 Remarks2  
SM11007 INTEGER 1 FLAGContract  
SM11008 INTEGER 1 FLAGDoc2  
SM11009 INTEGER 1 FLAGDoc3  
SM11010 INTEGER 1 FLAGInvoice  
SM11011 STRING 2 PaymentTerm  
SM11012 DATE 8 ContractDate  
SM11013 DATE 8 NextInvDate  
SM11014 INTEGER 4 InvIntervall  
SM11015 DATE 8 ContrStrDate  
SM11016 DATE 8 ContrEndDate  
SM11017 STRING 3 SalesmanNo  
SM11018 VSTRING 35 OurReference  
SM11019 X_NUMERIC 7 OrdDiscount  
SM11020 STRING 10 InvoiceNo  
SM11021 DATE 8 InvoiceDate  
SM11022 MONEY 20 ContractValueOCU  
SM11023 STRING 6 Spare  
SM11024 STRING 6 Spare  
SM11025 STRING 6 Spare  
SM11026 STRING 1 LanguageCode  
SM11027 STRING 2 ContractCurrencyCode  
SM11028 SWITCH 1 FLAGExpOrder  
SM11029 SWITCH 1 IndexClause  
SM11030 MONEY 20 MinServCharLCU  
SM11031 MONEY 20 AccInvAmntOCU  
SM11032 MONEY 20 HandlingFeeLCU  
SM11033 STRING 2 PriceListNo  
SM11034 STRING 3 ContractCode  
SM11035 SWITCH 1 PriceType  
SM11036 X_NUMERIC 7 ExternalComm  
SM11037 STRING 10 ExternComCode  
SM11038 STRING 1 DocumLayout  
SM11039 STRING 1 InvRoundMod  
SM11040 STRING 20 CustPONo  
SM11041 DATE 8 LastInvDate  
SM11042 STRING 10 LastInvoicNo  
SM11043 INTEGER 1 OrdMergeOption  
SM11044 STRING 4 CustSiteNo  
SM11045 INTEGER 2 IndexSched1  
SM11046 INTEGER 2 IndexSched2  
SM11047 INTEGER 2 IndexSched3  
SM11048 INTEGER 2 IndexSched4  
SM11049 INTEGER 1 Index1No  
SM11050 DATE 8 Idx1BaseDate  
SM11051 X_NUMERIC 10 Idx1Value  
SM11052 X_NUMERIC 7 Idx1Weighting  
SM11053 INTEGER 1 Index2No  
SM11054 DATE 8 Idx2BaseDate  
SM11055 X_NUMERIC 10 Idx2Value  
SM11056 X_NUMERIC 7 Idx2Weighting  
SM11057 INTEGER 1 Index3No  
SM11058 DATE 8 Idx3BaseDate  
SM11059 X_NUMERIC 10 Idx3Value  
SM11060 X_NUMERIC 7 Idx3Weighting  
SM11061 INTEGER 1 Index4No  
SM11062 DATE 8 Idx4BaseDate  
SM11063 X_NUMERIC 10 Idx4Value  
SM11064 X_NUMERIC 7 Idx4Weighting  
SM11065 INTEGER 1 FLContrCancel  
SM11066 SWITCH 1 FLCreditInv  
SM11067 SWITCH 1 FLFixPrices  
SM11068 STRING 2 ContractType  
SM11069 X_NUMERIC 7 DiscntLabour  
SM11070 X_NUMERIC 7 DiscntCosts  
SM11071 X_NUMERIC 7 DiscntParts  
SM11072 STRING 2 LabPricCode  
SM11073 MONEY 20 PricehourOCU  
SM11074 X_NUMERIC 12 HoursIncluded  
SM11075 STRING 2 LabPricCode  
SM11076 MONEY 20 PricehourOCU  
SM11077 X_NUMERIC 12 HoursIncluded  
SM11078 STRING 2 LabPricCode  
SM11079 MONEY 20 PricehourOCU  
SM11080 X_NUMERIC 21 HoursIncluded  
SM11081 STRING 1 TypeOfTimeBank  
SM11082 X_NUMERIC 12 HoursIncluded  
SM11083 X_NUMERIC 12 HoursWorked  
SM11084 INTEGER 1 FLAGLabels  
SM11085 X_NUMERIC 10 LatestIdxAdjust  
SM11086 STRING 10 InvoiceNo  
SM11087 DATE 8 DueDate  
SM11088 STRING 10 InvoiceNo  
SM11089 DATE 8 DueDate  
SM11090 SWITCH 1 FLInvDuePmt  
SM11091 INTEGER 1 QuotationStatus  
SM11092 INTEGER 1 FLQuotation  
SM11093 STRING 20 CustAlphaKey  
SM11094 VSTRING 20 SiteName  
SM11095 SWITCH 1 FLAGTempInv  
SM11096 INTEGER 1 ExtensStatus  
SM11097 DATE 8 LastChngDate  
SM11098 DATE 8 LastChngIdx  
SM11099 SWITCH 1 FlagChanging  
SM11100 DATE 8 LateIdxTabDt  
SM11101 ACCSTR 50 AccString  
SM11102 STRING 10 ICusCodeCont  
SM11103 SWITCH 1 StdContCode  
SM11104 X_NUMERIC 12 ResponceTime  
SM11105 X_NUMERIC 12 ETATime  
SM11106 STRING 1 InvoiceRoundModel  
SM11107 STRING 1 CurrencyContract  
SM11108 STRING 1 Spare  
SM11109 STRING 1 Spare  
SM11110 STRING 1 Spare  
SM11111 STRING 1 Spare  
SM11112 SWITCH 1 FlagForText  
SM11113 STRING 3 Manager  
SM11114 STRING 10 MasterContract  
SM11115 STRING 4 Disc1Intrvall  
SM11116 X_NUMERIC 7 OrderDisc2  
SM11117 STRING 4 Disc2Intervall  
SM11118 X_NUMERIC 7 OrderDisc3  
SM11119 STRING 4 Disc3Intervall  
SM11120 X_NUMERIC 7 OrderDisc4  
SM11121 STRING 4 Disc4Intervall  
SM11122 STRING 10 ICustGaranti  
SM11123 STRING 3 ContCodeGuarantee  
SM11124 MONEY 20 ContractValueLCU  
SM11125 MONEY 20 ActInvAmountLCU  
SM11126 X_NUMERIC 15 FixExchRate1  
SM11127 X_NUMERIC 15 FixExchRate2  
SM11128 STRING 3 FixExchAlgorithm  
SM11129 STRING 15 CurrencyContractNr  
SM11130 STRING 8 CampaignCode  

Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Service Order Management (Управление Заказами на Обслуживание) | Service Contract Head (Контракты на Обслуживание Загл.)