Таблица: SM01 - «Service Order Head» («Заголовки Заказов на обслуживание»)

Поле Тип поля Scala Длина Scala Комментарий Первич­ный ключ?
SM01001 STRING 10 ServiceOrdNo Да
SM01002 STRING 10 CustCodeInv  
SM01003 STRING 10 CustCodeServ  
SM01004 VSTRING 35 CustomerRef  
SM01005 STRING 20 CustomerPONo  
SM01006 STRING 35 ObjStockCode  
SM01007 STRING 20 ObjSerialNo  
SM01008 VSTRING 25 ObjectDescr1  
SM01009 VSTRING 25 ObjectDescr2  
SM01010 STRING 10 ObjMaintContNo  
SM01011 VSTRING 70 ServiceReq1  
SM01012 VSTRING 70 ServiceReq2  
SM01013 VSTRING 70 ServiceReq3  
SM01014 VSTRING 70 ServiceReq4  
SM01015 VSTRING 35 OurReference  
SM01016 STRING 10 FieldEngineer  
SM01017 DATE 8 CALLETADate  
SM01018 X_NUMERIC 5 CALLETATime  
SM01019 DATE 8 CALLETRDate  
SM01020 X_NUMERIC 5 CALLETRTime  
SM01021 DATE 8 CALLLOGEDDt  
SM01022 X_NUMERIC 5 CALLLOGEDTime  
SM01023 DATE 8 CALLOPENDate  
SM01024 X_NUMERIC 5 CALLOPENTime  
SM01025 DATE 8 CALLCOMPLDate  
SM01026 X_NUMERIC 5 CALLCOMPLTime  
SM01027 DATE 8 CALLCLOSEDt  
SM01028 X_NUMERIC 5 CALLCLOSETime  
SM01029 STRING 4 ProPriGroCode  
SM01030 MONEY 20 FixPriceHrs  
SM01031 MONEY 20 FixPriceCst  
SM01032 MONEY 20 FixPriceMat  
SM01033 INTEGER 1 InvSpecHours  
SM01034 INTEGER 1 InvSpecCosts  
SM01035 INTEGER 1 InvSpecMat  
SM01036 STRING 2 PaymentTerm  
SM01037 DATE 8 InvoiceDate  
SM01038 STRING 10 InvoiceNo  
SM01039 INTEGER 1 InteStatFlag  
SM01040 INTEGER 1 DOCFLAGQuotation  
SM01041 INTEGER 1 DOCFLAGConfirm  
SM01042 INTEGER 1 DOCFLAGSrvOrder  
SM01043 INTEGER 1 InvUpdStatus  
SM01044 STRING 1 LanguageCode  
SM01045 STRING 1 DocmntLayout  
SM01046 INTEGER 1 EngnPagingFlag  
SM01047 INTEGER 1 InvMergeOption  
SM01048 MONEY 20 HandlingFee  
SM01049 STRING 2 CurrencyCode  
SM01050 STRING 2 Pricelist  
SM01051 STRING 6 WareHouse  
SM01052 DATE 8 BookEntryDate  
SM01053 STRING 1 CurrencyClause  
SM01054 STRING 1 CurrencyContract  
SM01055 STRING 1 Spare  
SM01056 INTEGER 2 EDITransmCnt  
SM01057 INTEGER 2 EDIReceivCnt  
SM01058 SWITCH 1 EDIFlag1  
SM01059 SWITCH 1 EDIFlag2  
SM01060 SWITCH 1 EDIFlag3  
SM01061 SWITCH 1 EDIFlag4  
SM01062 SWITCH 1 PriorityFlg1  
SM01063 SWITCH 1 PriorityFlg2  
SM01064 STRING 2 OrderStatus  
SM01065 STRING 3 MaintenaCode  
SM01066 SWITCH 1 LetterOfCredit  
SM01067 DATE 8 LCOpenDate  
SM01068 DATE 8 LCDueDate  
SM01069 VSTRING 20 LCReference  
SM01070 SWITCH 1 GenerPIATrans  
SM01071 STRING 4 CustSiteNo  
SM01072 DATE 8 CALLATADate  
SM01073 X_NUMERIC 5 CALLATATime  
SM01074 DATE 8 MaterialDate  
SM01075 X_NUMERIC 5 MaterialTime  
SM01076 STRING 4 IncidentCode  
SM01077 STRING 15 AnalysisCode  
SM01078 STRING 10 MasterServOrder  
SM01079 INTEGER 1 OrderStruStatus  
SM01080 INTEGER 1 DOCFLAGPckNo  
SM01081 INTEGER 1 DOCFLAGTrans  
SM01082 INTEGER 1 DOCFLAGExport  
SM01083 INTEGER 1 DOCFLAGProformInv  
SM01084 STRING 15 ExtSrvStaCode  
SM01085 STRING 10 DeliveryNotNo  
SM01086 STRING 2 DeliveryCode  
SM01087 STRING 2 DeliveryMethod  
SM01088 INTEGER 1 DOCFLDeliNot  
SM01089 INTEGER 1 DOCFLSubsuppler  
SM01090 INTEGER 1 DOCFLFridok1  
SM01091 INTEGER 1 DOCFLFridok2  
SM01092 INTEGER 1 DOCFLFridok3  
SM01093 INTEGER 1 DOCFLCustDel  
SM01094 SWITCH 1 MastOrdPrint  
SM01095 DATE 8 SerNoDelDate  
SM01096 DATE 8 SerNoWarrExp  
SM01097 STRING 2 OrderType  
SM01098 X_NUMERIC 12 PlannedHours  
SM01099 STRING 35 SwapArtNo  
SM01100 VSTRING 25 SwapDescr1  
SM01101 VSTRING 25 SwapDescr2  
SM01102 STRING 20 SwapSerieNo  
SM01103 INTEGER 1 PickinglCenter  
SM01104 INTEGER 1 ReturnNote  
SM01105 INTEGER 1 Proforma  
SM01106 INTEGER 1 Ettikes  
SM01107 INTEGER 1 CustDelNote  
SM01108 STRING 14 StatistCode  
SM01109 MONEY 20 StatistValue  
SM01110 STRING 3 SalesmanOrder  
SM01111 STRING 3 SalesmanInvoicer  
SM01112 STRING 4 ObjPriceGroup  
SM01113 ACCSTR 50 AccString  
SM01114 DATE 8 STATUSDate  
SM01115 X_NUMERIC 5 STATUSTime  
SM01116 VSTRING 20 STATUSTEXT  
SM01117 X_NUMERIC 12 RespTimeCont  
SM01118 STRING 10 CustContrGar  
SM01119 STRING 2 PriclCntrGar  
SM01120 STRING 10 CustomerCntr  
SM01121 STRING 6 WIPWHGood  
SM01122 STRING 6 WIPBinGood  
SM01123 STRING 6 WIPDACode  
SM01124 DATE 8 ExchangeDate  
SM01125 X_NUMERIC 5 Spare  
SM01126 X_NUMERIC 12 RespTimePhone  
SM01127 INTEGER 1 WIPDACtype  
SM01128 STRING 4 InteEscaCode  
SM01129 STRING 20 TextRef  
SM01130 DATE 8 ETCDate  
SM01131 X_NUMERIC 5 ETCTime  
SM01132 INTEGER 1 CustStatus  
SM01133 STRING 10 ReferenceNo  
SM01134 X_NUMERIC 12 Spare  
SM01135 STRING 3 ExchangeAlgorithm  
SM01136 STRING 2 Spare  
SM01137 STRING 10 OrderedCustomerCode  
SM01138 STRING 2 Spare  
SM01139 STRING 10 Spare  
SM01140 STRING 2 Spare  
SM01141 X_NUMERIC 12 MassRepairQty  
SM01142 X_NUMERIC 7 OrderDiscPerc  
SM01143 X_NUMERIC 7 ExtComissPerc  
SM01144 VSTRING 10 ExtComissText  
SM01145 STRING 2 SOAccCode  
SM01146 X_NUMERIC 15 ExchangeRate1  
SM01147 X_NUMERIC 15 ExchangeRate2  
SM01148 MONEY 20 FixPriceHoursLcu  
SM01149 MONEY 20 FixPriceCostsLcu  
SM01150 MONEY 20 FixPriceMatLcu  
SM01151 X_NUMERIC 15 FixedExchRate1  
SM01152 X_NUMERIC 15 FixedExchRate2  
SM01153 STRING 3 FixesExchAlgorithm  
SM01154 VSTRING 15 CurrencyContractNr  
SM01155 VSTRING 8 CampaignCode  
SM01156 X_NUMERIC 6 LimitForCurrClausePc  
SM01157 X_NUMERIC 6 CompensationPer  

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