Таблица: 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 (Контракты на Обслуживание Загл.)