пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: SM07 - «Service Order Material File I/O». Маска имени таблицы: «SM07%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SM07001 NCHAR STRING 10 0 10 ServiceOrder Service Order   1 Да
SM07002 NCHAR STRING 4 0 4 ItemNo Service Order Line Number   2 Да
SM07003 NCHAR STRING 1 0 1 LineType Line Type 0 - Normal material line
5 - Linked picture
9 - Text line
   
SM07004 NCHAR STRING 35 0 35 StockCode Stock Item Code      
SM07005 NVARCHAR VSTRING 25 0 25 DescrLine1 Description Line 1      
SM07006 NVARCHAR VSTRING 25 0 25 DescrLine2 Description Line 2      
SM07007 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM07008 NUMERIC X_NUMERIC 18 8 10 SellingPriMultip Selling Price Multiplier      
SM07009 NUMERIC X_NUMERIC 18 8 10 QtyUnitInDelivery Items per Package (Purchase)      
SM07010 NUMERIC MONEY 28 8 20 UnitCostPriceLCU Unit Cost Price (Local Currency)      
SM07011 NUMERIC X_NUMERIC 18 8 10 CostPriMultiplie Cost Price Multiplier      
SM07012 NUMERIC X_NUMERIC 18 8 10 QtyUnitOutDelivery Items per Package (Sales)      
SM07013 NUMERIC X_NUMERIC 15 8 7 CustomerDisc Customer Discount %      
SM07014 NUMERIC X_NUMERIC 15 8 7 VolumeDiscount Volume Discount %      
SM07015 INT INTEGER 0 0 4 UnitCode Unit Code      
SM07016 NUMERIC X_NUMERIC 20 8 12 QtyPlanOR Quantity Planned (Order Unit)      
SM07017 NUMERIC X_NUMERIC 20 8 12 QtyDeliveryOR Quantity Delivered (Order Unit)      
SM07018 DATETIME DATE 0 0 8 DeliveryDate Delivery Date Actual      
SM07019 NCHAR STRING 6 0 6 VATCode1 VAT Code 1      
SM07020 NCHAR STRING 2 0 2 AccCode Accounting Code      
SM07021 NCHAR STRING 6 0 6 Spare Discount Frozen      
SM07022 NCHAR STRING 6 0 6 Spare (obsolete)      
SM07023 NCHAR STRING 6 0 6 Spare (obsolete)      
SM07024 NCHAR STRING 6 0 6 Spare (obsolete)      
SM07025 NUMERIC MONEY 28 8 20 UnitPriceOCU Unit Price (Order Currency)      
SM07026 NUMERIC MONEY 28 8 20 StatistPriceLCU Statistical Price (Local Currency)      
SM07027 NUMERIC X_NUMERIC 15 8 7 StatistDiscount Statistical Discount %      
SM07028 NUMERIC MONEY 28 8 20 StatCostPriceLCU Statistical Cost Price (Local Currency)      
SM07029 NUMERIC MONEY 28 8 20 WIPTransactionLCU WIP Transaction      
SM07030 NUMERIC X_NUMERIC 28 8 20 CurrExchRate Currency Exchange Rate      
SM07031 DATETIME DATE 0 0 8 PlanDate Delivery Date Committed      
SM07032 NCHAR SWITCH 1 0 1 InclFixPrice Included in Fixed Price      
SM07033 DATETIME DATE 0 0 8 Spare (obsolete)      
SM07034 NUMERIC X_NUMERIC 20 8 12 QtyAllocatedOR Quantity Allocated (Order Unit)      
SM07035 INT INTEGER 0 0 1 StockStatus Stock Item Status      
SM07036 NCHAR STRING 1 0 1 ShipmentRule Delivery Rule 0 - No test of the stock balance.
1 - Test on positive stock balance .
2 - Closed stock item, blocked orders.
3 - Direct delivery from supplier to customer.
4 - No over delivery.
5 - Back-delivery to purchase control.
   
SM07037 NCHAR STRING 6 0 6 WarehouseNo Warehouse      
SM07038 NCHAR STRING 10 0 10 PurchOrdNo Purchase Order Number      
SM07039 NCHAR STRING 12 0 12 PurchOrdLine Purchase Order Line Number      
SM07040 NCHAR SWITCH 1 0 1 PurchOrdShipp Purchase Order Status 0 - Purchase order line created
1 - Purchase order printed
2 - Purchase order line confirmed
3 - Delivery entered for purchase order line
   
SM07041 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      
SM07042 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SM07043 NCHAR STRING 15 0 15 InvoiceNo Invoice Number      
SM07044 NCHAR SWITCH 1 0 1 StructureFlag Has Sub-items in structure      
SM07045 NCHAR STRING 6 0 6 Spare (obsolete)      
SM07046 NCHAR STRING 10 0 10 Spare (obsolete)      
SM07047 NCHAR STRING 15 0 15 ExtServStatist External Statistical Number      
SM07048 NVARCHAR VSTRING 35 0 35 ProductCode Product code      
SM07049 NVARCHAR VSTRING 35 0 35 Module Module      
SM07050 NVARCHAR VSTRING 7 0 7 Position Position      
SM07051 NVARCHAR VSTRING 35 0 35 MaterialCode Material Code      
SM07052 NVARCHAR VSTRING 7 0 7 FaultCode Error Code      
SM07053 NUMERIC X_NUMERIC 20 8 12 QtyLentOR Quantity Lent to Engineer (Order Unit)      
SM07054 NCHAR STRING 2 0 2 OrderCurrency Currency Code Order      
SM07055 INT INTEGER 0 0 1 FLAGInvUpdate Invoice Status 0/1 - The line has not been sent on a invoice
2 - The activity line has been sent/included in a invoice.
   
SM07056 NCHAR STRING 2 0 2 PricelistNo Price List      
SM07057 NCHAR SWITCH 1 0 1 ChangeCustFlag Calculate Price Option used internally to indicate if price needs to be recalculated on the cost line.
1 - The price on the cost line has not been recalculated after change of customer
2 - The price on the cost line has already been calculated for the customer on the order line
   
SM07058 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
SM07059 NCHAR STRING 10 0 10 FieldEngineer Resource Code Engineer      
SM07060 NCHAR STRING 2 0 2 InvoiceCurrency Currency Code Invoice      
SM07061 NCHAR STRING 6 0 6 StructLineNo Service Order Sub-line Number   3 Да
SM07062 NCHAR STRING 6 0 6 VATCode2 VAT Code 2      
SM07063 NUMERIC X_NUMERIC 18 8 10 NetWeightOR Net Weight      
SM07064 NUMERIC X_NUMERIC 18 8 10 GrossWghtOR Gross Weight      
SM07065 NUMERIC X_NUMERIC 18 8 10 VolumeOR Volume      
SM07066 NCHAR STRING 6 0 6 WIPWHID Warehouse WIP      
SM07067 NCHAR STRING 6 0 6 WIPBinNo Bin WIP      
SM07068 NUMERIC X_NUMERIC 20 8 12 QtyPlanIssSC Quantity Planned Issue (Stock Unit)      
SM07069 NUMERIC X_NUMERIC 20 8 12 QtyAlloIssSC Quantity Allocated Issue (Stock Unit)      
SM07070 NUMERIC X_NUMERIC 20 8 12 QtyLentSC Quantity Issued (Stock Unit)      
SM07071 DATETIME DATE 0 0 8 PlanIssuDate Date Planned Issue to Engineer      
SM07072 DATETIME DATE 0 0 8 LentDate Date Issued to Engineer      
SM07073 NCHAR STRING 6 0 6 StatusIssue Issue Status      
SM07074 NUMERIC X_NUMERIC 20 8 12 QtyGoodReturnSC Quantity Planned Returns (Stock Unit)      
SM07075 NUMERIC X_NUMERIC 20 8 12 QtyAllocReturn Quantity Allocated Returns (Stock Unit)      
SM07076 NUMERIC X_NUMERIC 20 8 12 QtyBadReturnSC Quantity Bad Returned (Stock Unit)      
SM07077 DATETIME DATE 0 0 8 PlanRetuDate Date Planned Return      
SM07078 DATETIME DATE 0 0 8 BadReturnDate Date Returned Bad Items      
SM07079 NCHAR STRING 6 0 6 StatusReturn Return Status      
SM07080 NUMERIC X_NUMERIC 18 8 10 ConverFactor Unit Conversion Factor      
SM07081 NUMERIC X_NUMERIC 20 8 12 QtyPlanSC Quantity Planned (Stock Unit)      
SM07082 NUMERIC X_NUMERIC 20 8 12 QtyAllocatedSC Quantity Allocated (Stock Unit)      
SM07083 NUMERIC X_NUMERIC 20 8 12 QtyDeliverySC Quantity Delivered (Stock Unit)      
SM07084 INT INTEGER 0 0 1 DocFlagMatPick Material Picking List Print Status 0/1 - Material picking list will be sent for the order line
2 - Material picking list has been sent for the order line.
   
SM07085 NCHAR STRING 10 0 10 MaterialPicking Materials Picking Note Number      
SM07086 INT INTEGER 0 0 1 Spare BOM Blocked for Processing      
SM07087 NCHAR STRING 10 0 10 Spare (obsolete)      
SM07088 INT INTEGER 0 0 1 DocflRetNote Return Note Print Status 0/1 - Return note will be sent for the order line
2 - Return note has been sent for the order line.
   
SM07089 NCHAR STRING 10 0 10 ReturnNoteNo Return Note Number      
SM07090 INT INTEGER 0 0 1 FlagExchRule Exchange Rule 0 - No test is performed for exchange items.
1 - Test for exchange items is performed when releasing the service orders.
2 - Exchange item must be in stock before releasing the service orders.
   
SM07091 NUMERIC X_NUMERIC 20 8 12 QtyBadReturnOR Quantity Bad Returned (Order Unit)      
SM07092 INT INTEGER 0 0 1 IncludedInCurrencyClause Included in Currency Clause      
SM07093 NCHAR STRING 2 0 2 Spare (obsolete)      
SM07094 INT INTEGER 0 0 1 DeliveryFlag Delivery Flag      
SM07095 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM07096 NUMERIC X_NUMERIC 20 8 12 QtyGoodReturnOR Quantity Returned from Engineer (Stock Unit)      
SM07097 DATETIME DATE 0 0 8 GoodReturnDate Date Returned Good Items      
SM07098 NVARCHAR VSTRING 6 0 6 DefectWHCode Warehouse Bad Items      
SM07099 NUMERIC X_NUMERIC 20 8 12 QtyInvoiceOR Quantity Invoices (Order Unit)      
SM07100 NUMERIC X_NUMERIC 20 8 12 QtyInvoiceSC Quantity Invoices (Stock Unit)      
SM07101 NCHAR SWITCH 1 0 1 StatusSwitch0 Line Status 1      
SM07102 NCHAR SWITCH 1 0 1 StatusSwitch1 Line Status 2      
SM07103 NCHAR SWITCH 1 0 1 StatusSwitch2 Line Status 3      
SM07104 NCHAR SWITCH 1 0 1 StatusSwitch3 Line Status 4      
SM07105 NCHAR SWITCH 1 0 1 StatusSwitch4 Line Status 5      
SM07106 NCHAR SWITCH 1 0 1 StatusSwitch5 Marked for Invoice      
SM07107 NCHAR STRING 6 0 6 SubStrLinNo Service Order Child-line Number   4 Да
SM07108 NCHAR SWITCH 1 0 1 ParentRChild Is Parent      
SM07109 NCHAR STRING 150 0 150 Predecessors Predecessors MS Project Reserved for use when integrating with MS project    
SM07110 NCHAR STRING 6 0 6 JobNo Job Number      
SM07111 NCHAR STRING 10 0 10 CheckLineID Check List ID      
SM07112 NCHAR SWITCH 1 0 1 Flag_Created_by_JobOrder Was Created from Job      
SM07113 NCHAR SWITCH 1 0 1 DropShipment_Line Drop Shipment Line      
SM07114 NCHAR STRING 38 0 38 NodeID_BOM_SM BoM Node ID Service Order      
SM07115 NCHAR STRING 38 0 38 NodeID_BOM_SC BoM Node ID Stock      
SM07116 INT INTEGER 0 0 10 Discount_GroupNo Discount Group      
SM07117 INT INTEGER 0 0 9 Discount_Schema_Code Discount Schema Code      
SM07118 DATETIME DATE 0 0 8 Date_Pricing_on Discount Date      
SM07119 NCHAR SWITCH 1 0 1 Flag Custom ICU rate Use Custom Invoice Currency Rate      
SM07120 NUMERIC X_NUMERIC 23 8 15 Custom ICU rate Custom Invoice Currency Exchange Rate 1      
SM07121 NUMERIC X_NUMERIC 23 8 15 Custom ICU Exchange Rate 2 Custom Invoice Currency Exchange Rate 2      
SM07122 NCHAR STRING 3 0 3 Custom ICU Exchange Rate Algorithm Custom Invoice Currency Exchange Rate Algorithm      
SM07123 NVARCHAR VSTRING 10 0 10 Operation Type Material Operation Type Material      
SM07124 NVARCHAR VSTRING 10 0 10 Financial Operation Code Material Financial Operation Code Material      
SM07125 NVARCHAR VSTRING 6 0 6 Line Group Line Group      
SM07126 NCHAR SWITCH 1 0 1 Depreciation Depreciation      
SM07127 NVARCHAR VSTRING 35 0 35 Asset Asset      
SM07128 INT INTEGER 0 0 1 ExecutionLineType ExecutionLineType      
SM07129 NUMERIC X_NUMERIC 20 8 12 Sold Qty Sold Qty      
SM07130 NUMERIC X_NUMERIC 20 8 12 Sold Qty SC Sold Qty SC      
SM07131 DATETIME DATE 0 0 8 Sales Date Sales Date      
SM07132 NVARCHAR VSTRING 6 0 6 Disposal Code Disposal Code      
SM07133 NCHAR STRING 3 0 3 ReasonCode Reason Code      
SM07134 NVARCHAR VSTRING 10 0 10 DispatchNote Dispatch Note      
SM07135 NUMERIC X_NUMERIC 20 8 12 QtyInvoicedOR Quantity that has been Invoiced (Order Unit) for exec lines      
SM07136 NUMERIC X_NUMERIC 20 8 12 QtyInvoicedSC Quantity that has been Invoiced (Stock Unit) for exec lines      
SM07137 INT INTEGER 0 0 9 JobID Job ID      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Service Order Management | Service Order Material Lines

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.