Таблица: SM41 - «HI. Service Order Head» («История Заголовки Заказов на обслуживание»)

Поле Тип поля Scala Длина Scala Комментарий Первич­ный ключ?
SM41001 STRING 10 ServiceOrdNo Да
SM41002 STRING 10 CustCodeInv  
SM41003 STRING 10 CustCodeServ  
SM41004 VSTRING 35 CustomerRef  
SM41005 STRING 20 CustomerPONo  
SM41006 STRING 35 ObjStockCode  
SM41007 STRING 20 ObjSerialNo  
SM41008 VSTRING 25 ObjectDescr1  
SM41009 VSTRING 25 ObjectDescr2  
SM41010 STRING 10 ObjMaintContNo  
SM41011 VSTRING 70 ServiceReq1  
SM41012 VSTRING 70 ServiceReq2  
SM41013 VSTRING 70 ServiceReq3  
SM41014 VSTRING 70 ServiceReq4  
SM41015 VSTRING 35 OurReference  
SM41016 STRING 10 FieldEngineer  
SM41017 DATE 8 CALLETADate  
SM41018 X_NUMERIC 5 CALLETATime  
SM41019 DATE 8 CALLETRDate  
SM41020 X_NUMERIC 5 CALLETRTime  
SM41021 DATE 8 CALLLOGEDDt  
SM41022 X_NUMERIC 5 CALLLOGEDTime  
SM41023 DATE 8 CALLOPENDate  
SM41024 X_NUMERIC 5 CALLOPENTime  
SM41025 DATE 8 CALLCOMPLDate  
SM41026 X_NUMERIC 5 CALLCOMPLTime  
SM41027 DATE 8 CALLCLOSEDt  
SM41028 X_NUMERIC 5 CALLCLOSETime  
SM41029 STRING 4 ProPriGroCode  
SM41030 MONEY 20 FixPriceHrs  
SM41031 MONEY 20 FixPriceCst  
SM41032 MONEY 20 FixPriceMat  
SM41033 INTEGER 1 InvSpecHours  
SM41034 INTEGER 1 InvSpecCosts  
SM41035 INTEGER 1 InvSpecMat  
SM41036 STRING 2 PaymentTerm  
SM41037 DATE 8 InvoiceDate  
SM41038 STRING 10 InvoiceNo  
SM41039 INTEGER 1 InteStatFlag  
SM41040 INTEGER 1 DOCFLAGQuotation  
SM41041 INTEGER 1 DOCFLAGConfirm  
SM41042 INTEGER 1 DOCFLAGSrvOrder  
SM41043 INTEGER 1 InvUpdStatus  
SM41044 STRING 1 LanguageCode  
SM41045 STRING 1 DocmntLayout  
SM41046 INTEGER 1 EngnPagingFlag  
SM41047 INTEGER 1 InvMergeOption  
SM41048 MONEY 20 HandlingFee  
SM41049 STRING 2 CurrencyCode  
SM41050 STRING 2 Pricelist  
SM41051 STRING 6 WareHouse  
SM41052 DATE 8 BookEntryDate  
SM41053 STRING 1 CurrencyClause  
SM41054 STRING 1 CurrencyContract  
SM41055 STRING 1 Spare  
SM41056 INTEGER 2 EDITransmCnt  
SM41057 INTEGER 2 EDIReceivCnt  
SM41058 SWITCH 1 EDIFlag1  
SM41059 SWITCH 1 EDIFlag2  
SM41060 SWITCH 1 EDIFlag3  
SM41061 SWITCH 1 EDIFlag4  
SM41062 SWITCH 1 PriorityFlg1  
SM41063 SWITCH 1 PriorityFlg2  
SM41064 STRING 2 OrderStatus  
SM41065 STRING 3 MaintenaCode  
SM41066 SWITCH 1 LetterOfCredit  
SM41067 DATE 8 LCOpenDate  
SM41068 DATE 8 LCDueDate  
SM41069 VSTRING 20 LCReference  
SM41070 SWITCH 1 GenerPIATrans  
SM41071 STRING 4 CustSiteNo  
SM41072 DATE 8 CALLATADate  
SM41073 X_NUMERIC 5 CALLATATime  
SM41074 DATE 8 MaterialDate  
SM41075 X_NUMERIC 5 MaterialTime  
SM41076 STRING 4 IncidentCode  
SM41077 STRING 15 AnalysisCode  
SM41078 STRING 10 MasterServOrder  
SM41079 INTEGER 1 OrderStruStatus  
SM41080 INTEGER 1 DOCFLAGPckNo  
SM41081 INTEGER 1 DOCFLAGTrans  
SM41082 INTEGER 1 DOCFLAGExport  
SM41083 INTEGER 1 DOCFLAGProformInv  
SM41084 STRING 15 ExtSrvStaCode  
SM41085 STRING 10 DeliveryNotNo  
SM41086 STRING 2 DeliveryCode  
SM41087 STRING 2 DeliveryMethod  
SM41088 INTEGER 1 DOCFLDeliNot  
SM41089 INTEGER 1 DOCFLSubsuppler  
SM41090 INTEGER 1 DOCFLFridok1  
SM41091 INTEGER 1 DOCFLFridok2  
SM41092 INTEGER 1 DOCFLFridok3  
SM41093 INTEGER 1 DOCFLCustDel  
SM41094 SWITCH 1 MastOrdPrint  
SM41095 DATE 8 SerNoDelDate  
SM41096 DATE 8 SerNoWarrExp  
SM41097 STRING 2 OrderType  
SM41098 X_NUMERIC 12 PlannedHours  
SM41099 STRING 35 SwapArtNo  
SM41100 VSTRING 25 SwapDescr1  
SM41101 VSTRING 25 SwapDescr2  
SM41102 STRING 20 SwapSerieNo  
SM41103 INTEGER 1 PickinglCenter  
SM41104 INTEGER 1 ReturnNote  
SM41105 INTEGER 1 Proforma  
SM41106 INTEGER 1 Ettikes  
SM41107 INTEGER 1 CustDelNote  
SM41108 STRING 14 StatistCode  
SM41109 MONEY 20 StatistValue  
SM41110 STRING 3 SalesmanOrder  
SM41111 STRING 3 SalesmanInvoicer  
SM41112 STRING 4 ObjPriceGroup  
SM41113 ACCSTR 50 AccString  
SM41114 DATE 8 STATUSDate  
SM41115 X_NUMERIC 5 STATUSTime  
SM41116 VSTRING 20 STATUSTEXT  
SM41117 X_NUMERIC 12 RespTimeCont  
SM41118 STRING 10 CustContrGar  
SM41119 STRING 2 PriclCntrGar  
SM41120 STRING 10 CustomerCntr  
SM41121 STRING 6 WIPWHGood  
SM41122 STRING 6 WIPBinGood  
SM41123 STRING 6 WIPDACode  
SM41124 DATE 8 ExchangeDate  
SM41125 X_NUMERIC 5 Spare  
SM41126 X_NUMERIC 12 RespTimePhone  
SM41127 INTEGER 1 WIPDACtype  
SM41128 STRING 4 InteEscaCode  
SM41129 STRING 20 TextRef  
SM41130 DATE 8 ETCDate  
SM41131 X_NUMERIC 5 ETCTime  
SM41132 INTEGER 1 CustStatus  
SM41133 STRING 10 ReferenceNo  
SM41134 X_NUMERIC 12 Spare  
SM41135 STRING 3 ExchangeAlgorithm  
SM41136 STRING 2 Spare  
SM41137 STRING 10 OrderedCustomerCode  
SM41138 STRING 2 Spare  
SM41139 STRING 10 Spare  
SM41140 STRING 2 Spare  
SM41141 X_NUMERIC 12 MassRepairQty  
SM41142 X_NUMERIC 7 OrderDiscPerc  
SM41143 X_NUMERIC 7 ExtComissPerc  
SM41144 VSTRING 10 ExtComissText  
SM41145 STRING 2 SOAccCode  
SM41146 X_NUMERIC 15 ExchangeRate1  
SM41147 X_NUMERIC 15 ExchangeRate2  
SM41148 MONEY 20 FixPriceHoursLcu  
SM41149 MONEY 20 FixPriceCostsLcu  
SM41150 MONEY 20 FixPriceMatLcu  
SM41151 X_NUMERIC 15 FixedExchRate1  
SM41152 X_NUMERIC 15 FixedExchRate2  
SM41153 STRING 3 FixesExchAlgorithm  
SM41154 VSTRING 15 CurrencyContractNr  
SM41155 VSTRING 8 CampaignCode  
SM41156 X_NUMERIC 6 LimitForCurrClausePc  
SM41157 X_NUMERIC 6 CompensationPer  

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