На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SM45 — Service Order Material Lines History

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM45001 NCHAR STRING 10 0 10 ServiceOrder Service Order   1 Да / Yes
SM45002 NCHAR STRING 4 0 4 ItemNo Service Order Line Number   2 Да / Yes
SM45003 NCHAR STRING 1 0 1 LineType Line Type 0 — Normal material line

5 — Linked picture

9 — Text line		    
SM45004 NCHAR STRING 35 0 35 StockCode Stock Item Code      
SM45005 NVARCHAR VSTRING 25 0 25 DescrLine1 Description Line 1      
SM45006 NVARCHAR VSTRING 25 0 25 DescrLine2 Description Line 2      
SM45007 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM45008 NUMERIC X_NUMERIC 18 8 10 SellingPriMultip Selling Price Multiplier      
SM45009 NUMERIC X_NUMERIC 18 8 10 QtyUnitInDelivery Items per Package (Purchase)      
SM45010 NUMERIC MONEY 28 8 20 UnitCostPriceLCU Unit Cost Price (Local Currency)      
SM45011 NUMERIC X_NUMERIC 18 8 10 CostPriMultiplie Cost Price Multiplier      
SM45012 NUMERIC X_NUMERIC 18 8 10 QtyUnitOutDelivery Items per Package (Sales)      
SM45013 NUMERIC X_NUMERIC 15 8 7 CustomerDisc Customer Discount %      
SM45014 NUMERIC X_NUMERIC 15 8 7 VolumeDiscount Volume Discount %      
SM45015 INT INTEGER 0 0 4 UnitCode Unit Code      
SM45016 NUMERIC X_NUMERIC 20 8 12 QtyPlanedUse Quantity Planned (Order Unit)      
SM45017 NUMERIC X_NUMERIC 20 8 12 QtyUsedShipp Quantity Delivered (Order Unit)      
SM45018 DATETIME DATE 0 0 8 DeliveryDate Delivery Date Actual      
SM45019 NCHAR STRING 6 0 6 VATCode1 VAT Code 1      
SM45020 NCHAR STRING 2 0 2 AccCode Accounting Code      
SM45021 NCHAR STRING 6 0 6 Spare Discount Frozen      
SM45022 NCHAR STRING 6 0 6 Spare (obsolete)      
SM45023 NCHAR STRING 6 0 6 Spare (obsolete)      
SM45024 NCHAR STRING 6 0 6 Spare (obsolete)      
SM45025 NUMERIC MONEY 28 8 20 UnitPriceOCU Unit Price (Order Currency)      
SM45026 NUMERIC MONEY 28 8 20 StatistPriceLCU Statistical Price (Local Currency)      
SM45027 NUMERIC X_NUMERIC 15 8 7 StatistDiscount Statistical Discount %      
SM45028 NUMERIC MONEY 28 8 20 StatCostPriceLCU Statistical Cost Price (Local Currency)      
SM45029 NUMERIC MONEY 28 8 20 WIPTransactionLCU WIP Transaction      
SM45030 NUMERIC X_NUMERIC 28 8 20 CurrExchRate Currency Exchange Rate      
SM45031 DATETIME DATE 0 0 8 PlanDateCommit Delivery Date Committed      
SM45032 NCHAR SWITCH 1 0 1 InclFixPrice Included in Fixed Price      
SM45033 DATETIME DATE 0 0 8 Spare (obsolete)      
SM45034 NUMERIC X_NUMERIC 20 8 12 QtyAllocatedUsed Quantity Allocated (Order Unit)      
SM45035 INT INTEGER 0 0 1 StockStatus Stock Item Status      
SM45036 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.		    
SM45037 NCHAR STRING 6 0 6 WarehouseNo Warehouse   5 Да / Yes
SM45038 NCHAR STRING 10 0 10 PurchOrdNo Purchase Order Number      
SM45039 NCHAR STRING 12 0 12 PurchOrdLine Purchase Order Line Number      
SM45040 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		    
SM45041 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      
SM45042 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SM45043 NCHAR STRING 15 0 15 InvoiceNo Invoice Number   6 Да / Yes
SM45044 NCHAR SWITCH 1 0 1 StructureFlag Has Sub-items in structure      
SM45045 NCHAR STRING 6 0 6 Spare (obsolete)      
SM45046 NCHAR STRING 10 0 10 Spare (obsolete)      
SM45047 NCHAR STRING 15 0 15 ExtServStatist External Statistical Number      
SM45048 NVARCHAR VSTRING 35 0 35 ProductCode Product code      
SM45049 NVARCHAR VSTRING 35 0 35 Module Module      
SM45050 NVARCHAR VSTRING 7 0 7 Position Position      
SM45051 NVARCHAR VSTRING 35 0 35 MaterialCode Material Code      
SM45052 NVARCHAR VSTRING 7 0 7 FaultCode Error Code      
SM45053 NUMERIC X_NUMERIC 20 8 12 QtyIssuedShipped Quantity Lent to Engineer (Order Unit)      
SM45054 NCHAR STRING 2 0 2 OrderCurrency Currency Code Order      
SM45055 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.		    
SM45056 NCHAR STRING 2 0 2 PricelistNo Price List      
SM45057 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		    
SM45058 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
SM45059 NCHAR STRING 10 0 10 FieldEngineer Resource Code Engineer      
SM45060 NCHAR STRING 2 0 2 InvoiceCurrency Currency Code Invoice      
SM45061 NCHAR STRING 6 0 6 StructLineNo Service Order Sub-line Number   3 Да / Yes
SM45062 NCHAR STRING 6 0 6 VATCode2 VAT Code 2      
SM45063 NUMERIC X_NUMERIC 18 8 10 NetWeightOR Net Weight      
SM45064 NUMERIC X_NUMERIC 18 8 10 GrossWghtOR Gross Weight      
SM45065 NUMERIC X_NUMERIC 18 8 10 VolumeOR Volume      
SM45066 NCHAR STRING 6 0 6 WIPWHID Warehouse WIP      
SM45067 NCHAR STRING 6 0 6 WIPBinNo Bin WIP      
SM45068 NUMERIC X_NUMERIC 20 8 12 QtyPlanIssSC Quantity Planned Issue (Stock Unit)      
SM45069 NUMERIC X_NUMERIC 20 8 12 QtyAlloIssSC Quantity Allocated Issue (Stock Unit)      
SM45070 NUMERIC X_NUMERIC 20 8 12 QtyIssueSC Quantity Issued (Stock Unit)      
SM45071 DATETIME DATE 0 0 8 PlanIssuDate Date Planned Issue to Engineer      
SM45072 DATETIME DATE 0 0 8 IssueDate Date Issued to Engineer      
SM45073 NCHAR STRING 6 0 6 StatusIssue Issue Status      
SM45074 NUMERIC X_NUMERIC 20 8 12 QtyPlanReturn Quantity Planned Returns (Stock Unit)      
SM45075 NUMERIC X_NUMERIC 20 8 12 QtyAllocReturn Quantity Allocated Returns (Stock Unit)      
SM45076 NUMERIC X_NUMERIC 20 8 12 QtyReturnRec Quantity Bad Returned (Stock Unit)      
SM45077 DATETIME DATE 0 0 8 PlanRetuDate Date Planned Return      
SM45078 DATETIME DATE 0 0 8 ReturnDate Date Returned Bad Items      
SM45079 NCHAR STRING 6 0 6 StatusReturn Return Status      
SM45080 NUMERIC X_NUMERIC 18 8 10 Spare Spare      
SM45081 NUMERIC X_NUMERIC 20 8 12 QtyPlanUsage Quantity Planned (Stock Unit)      
SM45082 NUMERIC X_NUMERIC 20 8 12 QtyAllocUsage Quantity Allocated (Stock Unit)      
SM45083 NUMERIC X_NUMERIC 20 8 12 QtyUsedShip Quantity Delivered (Stock Unit)      
SM45084 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.		    
SM45085 NCHAR STRING 10 0 10 MaterialPicking Materials Picking Note Number      
SM45086 INT INTEGER 0 0 1 Spare BOM Blocked for Processing      
SM45087 NCHAR STRING 10 0 10 Spare (obsolete)      
SM45088 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.		    
SM45089 NVARCHAR VSTRING 20 0 20 ReturnNoteNo Return Note Number      
SM45090 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.		    
SM45091 NUMERIC X_NUMERIC 20 8 12 QtyDeallocUsage Quantity Bad Returned (Order Unit)      
SM45092 INT INTEGER 0 0 1 IncludedInCurrencyClause Included in Currency Clause      
SM45093 NCHAR STRING 2 0 2 Spare (obsolete)      
SM45094 INT INTEGER 0 0 1 DeliveryFlag Delivery Flag      
SM45095 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM45096 NUMERIC X_NUMERIC 20 8 12 QtityReturn Quantity Returned from Engineer (Stock Unit)      
SM45097 DATETIME DATE 0 0 8 DateReturn Date Returned Good Items      
SM45098 NVARCHAR VSTRING 6 0 6 DefectWHCode Warehouse Bad Items      
SM45099 NUMERIC X_NUMERIC 20 8 12 InvQtyORUnit Quantity Invoices (Order Unit)      
SM45100 NUMERIC X_NUMERIC 20 8 12 Spare Spare      
SM45101 NCHAR SWITCH 1 0 1 StatusSwitch0 Line Status 1      
SM45102 NCHAR SWITCH 1 0 1 StatusSwitch1 Line Status 2      
SM45103 NCHAR SWITCH 1 0 1 StatusSwitch2 Line Status 3      
SM45104 NCHAR SWITCH 1 0 1 StatusSwitch3 Line Status 4      
SM45105 NCHAR SWITCH 1 0 1 StatusSwitch4 Line Status 5      
SM45106 NCHAR SWITCH 1 0 1 StatusSwitch5 Marked for Invoice      
SM45107 NCHAR STRING 6 0 6 SubStrLinNo Service Order Child-line Number   4 Да / Yes
SM45108 NCHAR SWITCH 1 0 1 HasSubItem Is Parent      
SM45109 NCHAR STRING 150 0 150 Predecessors Predecessors MS Project Reserved for use when integrating with MS project    
SM45110 NCHAR STRING 6 0 6 JobNo Job Number      
SM45111 NCHAR STRING 10 0 10 CheckListID Check List ID      
SM45112 NCHAR SWITCH 1 0 1 FlagCreatedByJob Was Created from Job      
SM45113 INT INTEGER 0 0 1 DropShipmentLine Drop Shipment Line      
SM45114 NCHAR STRING 38 0 38 NodeID_BOM_SM BoM Node ID Service Order      
SM45115 NCHAR STRING 38 0 38 NodeID_BOM_SC BoM Node ID Stock      
SM45116 INT INTEGER 0 0 10 DiscountGroupNo Discount Group      
SM45117 INT INTEGER 0 0 9 DiscountSchemaCode Discount Schema Code      
SM45118 DATETIME DATE 0 0 8 DatePricingOn Discount Date      
SM45119 NCHAR SWITCH 1 0 1 CustomICURate Use Custom Invoice Currency Rate      
SM45120 NUMERIC X_NUMERIC 23 8 15 CustomICUExchRate1 Custom Invoice Currency Exchange Rate 1      
SM45121 NUMERIC X_NUMERIC 23 8 15 CustomICUExchRate2 Custom Invoice Currency Exchange Rate 2      
SM45122 NCHAR STRING 3 0 3 CustomICUExchRateAlg Custom Invoice Currency Exchange Rate Algorithm      
SM45123 NVARCHAR VSTRING 10 0 10 OperationTypeMaterial Operation Type Material      
SM45124 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeMaterial Financial Operation Code Material      
SM45125 NVARCHAR VSTRING 6 0 6 LineGroup Line Group      
SM45126 NCHAR SWITCH 1 0 1 Depreciation Depreciation      
SM45127 NVARCHAR VSTRING 35 0 35 Asset Asset      
SM45128 INT INTEGER 0 0 1 ExecutionLineType ExecutionLineType      
SM45129 NUMERIC X_NUMERIC 20 8 12 SoldQty Sold Qty      
SM45130 NUMERIC X_NUMERIC 20 8 12 SoldQtySC Sold Qty SC      
SM45131 DATETIME DATE 0 0 8 SalesDate Sales Date      
SM45132 NVARCHAR VSTRING 6 0 6 DisposalCode Disposal Code      
SM45133 NCHAR STRING 3 0 3 ReasonCode Reason Code      
SM45134 NVARCHAR VSTRING 20 0 20 DispatchNote Dispatch Note      
SM45135 NUMERIC X_NUMERIC 20 8 12 QtyInvoicedOR Quantity that has been Invoiced (Order Unit) for exec lines      
SM45136 NUMERIC X_NUMERIC 20 8 12 Spare Spare      
SM45137 INT INTEGER 0 0 9 JobID Job ID      
SM45138 INT INTEGER 0 0 1 DeliveryBlocked Delivery blocked      
SM45139 INT INTEGER 0 0 1 ItemType ItemType      
SM45140 NVARCHAR VSTRING 36 0 36 LineGUID Line GUID      
SM45141 NCHAR SWITCH 1 0 1 ApprovedCreditLimit Approved Credit Limit      
SM45142 NVARCHAR VSTRING 25 0 25 NomenclatureNumber Nomenclature Number      
SM45143 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
SM45144 NUMERIC MONEY 28 8 20 LineFreightAmountOCU Line Freight Amount OCU      
SM45145 NUMERIC MONEY 28 8 20 LineFreightAmountICU Line Freight Amount ICU      
SM45146 NVARCHAR VSTRING 15 0 15 EntryInvoiceNo Entry Invoice No      
SM45147 NCHAR STRING 6 0 6 InvPlanLineNo InvPlanLineNo   7 Да / Yes
SM45148 NVARCHAR VSTRING 6 0 6 Return WH Return WH      
SM45149 NCHAR STRING 3 0 3 Taxation Reason Code Taxation Reason Code      

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