Таблица: SM07 - «Service Order Material Lines» («Заказы на обслуживание Строки матер.»)

Поле Тип поля Scala Длина Scala Комментарий Первич­ный ключ?
SM07001 STRING 10 ServiceOrder Да
SM07002 STRING 4 ItemNo Да
SM07003 STRING 1 LineType  
SM07004 STRING 35 StockCode  
SM07005 VSTRING 25 DescrLine1  
SM07006 VSTRING 25 DescrLine2  
SM07007 MONEY 20 UnitPriceOCU  
SM07008 X_NUMERIC 10 SellingPriMultip  
SM07009 X_NUMERIC 10 QtyUnitInDelivery  
SM07010 MONEY 20 UnitCostPriceLCU  
SM07011 X_NUMERIC 10 CostPriMultiplie  
SM07012 X_NUMERIC 10 QtyUnitOutDelivery  
SM07013 X_NUMERIC 7 CustomerDisc  
SM07014 X_NUMERIC 7 VolumeDiscount  
SM07015 STRING 2 UnitCode  
SM07016 X_NUMERIC 12 QtyPlanedUse  
SM07017 X_NUMERIC 12 QtyUsedShipp  
SM07018 DATE 8 DeliveryDate  
SM07019 STRING 2 VATCode1  
SM07020 STRING 2 AccCode  
SM07021 STRING 6 Spare  
SM07022 STRING 6 Spare  
SM07023 STRING 6 Spare  
SM07024 STRING 6 Spare  
SM07025 MONEY 20 UnitPriceICU  
SM07026 MONEY 20 StatistPriceLCU  
SM07027 X_NUMERIC 7 StatistDiscount  
SM07028 MONEY 20 StatCostPriceLCU  
SM07029 MONEY 20 WIPTransactionLCU  
SM07030 X_NUMERIC 20 CurrExchRate  
SM07031 DATE 8 PlanDateCommit  
SM07032 SWITCH 1 InclFixPrice  
SM07033 DATE 8 Spare  
SM07034 X_NUMERIC 12 QtyAllocatedUsed  
SM07035 INTEGER 1 StockStatus  
SM07036 STRING 1 ShipmentRule  
SM07037 STRING 6 WarehouseNo  
SM07038 STRING 10 PurchOrdNo  
SM07039 STRING 9 PurchOrdLine  
SM07040 SWITCH 1 PurchOrdShipp  
SM07041 STRING 10 CustCodeInv  
SM07042 DATE 8 InvoiceDate  
SM07043 STRING 10 InvoiceNo  
SM07044 SWITCH 1 StructureFlag  
SM07045 STRING 6 Spare  
SM07046 STRING 10 Spare  
SM07047 STRING 15 ExtServStatist  
SM07048 VSTRING 35 ProductCode  
SM07049 VSTRING 35 Module  
SM07050 VSTRING 7 Position  
SM07051 VSTRING 35 MaterialCode  
SM07052 VSTRING 7 FaultCode  
SM07053 X_NUMERIC 12 QtyIssuedShipped  
SM07054 STRING 2 OrderCurrency  
SM07055 INTEGER 1 FLAGInvUpdate  
SM07056 STRING 2 PricelistNo  
SM07057 SWITCH 1 ChangeCustFlag  
SM07058 ACCSTR 50 AccString  
SM07059 STRING 10 FieldEngineer  
SM07060 STRING 2 InvoiceCurrency  
SM07061 STRING 3 StructLineNo Да
SM07062 STRING 2 VATCode2  
SM07063 X_NUMERIC 10 NetWeightOR  
SM07064 X_NUMERIC 10 GrossWghtOR  
SM07065 X_NUMERIC 10 VolumeOR  
SM07066 STRING 6 WIPWHID  
SM07067 STRING 6 WIPBinNo  
SM07068 X_NUMERIC 12 QtyPlanIssSC  
SM07069 X_NUMERIC 12 QtyAlloIssSC  
SM07070 X_NUMERIC 12 QtyIssueSC  
SM07071 DATE 8 PlanIssuDate  
SM07072 DATE 8 IssueDate  
SM07073 STRING 6 StatusIssue  
SM07074 X_NUMERIC 12 QtyPlanReturn  
SM07075 X_NUMERIC 12 QtyAllocReturn  
SM07076 X_NUMERIC 12 QtyReturnRec  
SM07077 DATE 8 PlanRetuDate  
SM07078 DATE 8 ReturnDate  
SM07079 STRING 6 StatusReturn  
SM07080 X_NUMERIC 10 ConverFactor  
SM07081 X_NUMERIC 12 QtyPlanUsage  
SM07082 X_NUMERIC 12 QtyAllocUsage  
SM07083 X_NUMERIC 12 QtyUsedShip  
SM07084 INTEGER 1 DocFlagMatPick  
SM07085 STRING 10 MaterialPicking  
SM07086 INTEGER 1 Spare  
SM07087 STRING 10 Spare  
SM07088 INTEGER 1 DocflRetNote  
SM07089 STRING 10 ReturnNoteNo  
SM07090 INTEGER 1 FlagExchRule  
SM07091 X_NUMERIC 12 QtyDeallocUsage  
SM07092 INTEGER 1 Spare  
SM07093 STRING 2 Spare  
SM07094 INTEGER 1 DeliveryFlag  
SM07095 MONEY 20 UnitPriceLCU  
SM07096 X_NUMERIC 12 QtityReturn  
SM07097 DATE 8 DateReturn  
SM07098 VSTRING 6 DefectWHCode  
SM07099 X_NUMERIC 12 QtyORUnit  
SM07100 X_NUMERIC 12 InvQtySCUnit  
SM07101 SWITCH 1 StatusSwitch0  
SM07102 SWITCH 1 StatusSwitch1  
SM07103 SWITCH 1 StatusSwitch2  
SM07104 SWITCH 1 StatusSwitch3  
SM07105 SWITCH 1 StatusSwitch4  
SM07106 SWITCH 1 StatusSwitch5  

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