One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table SM07 — Service Order Material Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM07001 NCHAR STRING 10 0 10 ServiceOrder Service Order   1 Да / Yes
SM07002 NCHAR STRING 4 0 4 ItemNo Service Order Line Number   2 Да / Yes
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 120 0 120 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 Да / Yes
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 Spare Spare      
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 NVARCHAR VSTRING 20 0 20 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 Spare Spare      
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 Да / Yes
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 FlagCreatedbyJobOrder Was Created from Job      
SM07113 INT INTEGER 0 0 1 DropShipmentLine 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 DiscountGroupNo Discount Group      
SM07117 INT INTEGER 0 0 9 DiscountSchemaCode Discount Schema Code      
SM07118 DATETIME DATE 0 0 8 DatePricingOn Discount Date      
SM07119 NCHAR SWITCH 1 0 1 CustomICURate Use Custom Invoice Currency Rate      
SM07120 NUMERIC X_NUMERIC 23 8 15 CustomICUExchRate1 Custom Invoice Currency Exchange Rate 1      
SM07121 NUMERIC X_NUMERIC 23 8 15 CustomICUExchRate2 Custom Invoice Currency Exchange Rate 2      
SM07122 NCHAR STRING 3 0 3 CustomICUExchRateAlg Custom Invoice Currency Exchange Rate Algorithm      
SM07123 NVARCHAR VSTRING 10 0 10 OperationTypeMaterial Operation Type Material      
SM07124 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeMaterial Financial Operation Code Material      
SM07125 NVARCHAR VSTRING 6 0 6 LineGroup 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 SoldQty Sold Qty      
SM07130 NUMERIC X_NUMERIC 20 8 12 SoldQtySC Sold Qty SC      
SM07131 DATETIME DATE 0 0 8 SalesDate Sales Date      
SM07132 NVARCHAR VSTRING 6 0 6 DisposalCode Disposal Code      
SM07133 NCHAR STRING 3 0 3 ReasonCode Reason Code      
SM07134 NVARCHAR VSTRING 20 0 20 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 Spare Spare      
SM07137 INT INTEGER 0 0 9 JobID Job ID      
SM07138 INT INTEGER 0 0 1 DeliveryBlocked Delivery blocked      
SM07139 INT INTEGER 0 0 1 ItemType ItemType      
SM07140 NVARCHAR VSTRING 36 0 36 LineGUID Line GUID      
SM07141 NCHAR SWITCH 1 0 1 ApprovedCreditLimit Approved Credit Limit      
SM07142 NVARCHAR VSTRING 25 0 25 NomenclatureNumber Nomenclature Number      
SM07143 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
SM07144 NUMERIC MONEY 28 8 20 LineFreightAmountOCU Line Freight Amount OCU      
SM07145 NUMERIC MONEY 28 8 20 LineFreightAmountICU Line FreightAmount ICU      
SM07146 NVARCHAR VSTRING 15 0 15 EntryInvoiceNo Entry Invoice No      
SM07147 NCHAR STRING 6 0 6 InvPlanLineNo InvPlanLineNo      
SM07148 NVARCHAR VSTRING 6 0 6 ReturnWH Return WH      
SM07149 NCHAR STRING 3 0 3 TaxationReasonCode Taxation Reason Code      

Навигация / Navigation: