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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SM45001 NCHAR STRING 10 0 10 ServiceOrder Service Order   1 Да
SM45002 NCHAR STRING 4 0 4 ItemNo Service Order Line Number   2 Да
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 Да
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 Да
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 Да
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 ConverFactor Unit Conversion Factor      
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 NCHAR STRING 10 0 10 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 InvQtySCUnit Quantity Invoices (Stock Unit)      
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 Да
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 Flag_CreatedByJob Was Created from Job      
SM45113 NCHAR SWITCH 1 0 1 DropShipment_Line 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 Discount_GroupNo Discount Group      
SM45117 INT INTEGER 0 0 9 Discount_Schema_Code Discount Schema Code      
SM45118 DATETIME DATE 0 0 8 Date_Pricing_on Discount Date      
SM45119 NCHAR SWITCH 1 0 1 Flag Custom ICU rate Use Custom Invoice Currency Rate      
SM45120 NUMERIC X_NUMERIC 23 8 15 Custom ICU rate Custom Invoice Currency Exchange Rate 1      
SM45121 NUMERIC X_NUMERIC 23 8 15 Custom ICU Exchange Rate 2 Custom Invoice Currency Exchange Rate 2      
SM45122 NCHAR STRING 3 0 3 Custom ICU Exchange Rate Algorithm Custom Invoice Currency Exchange Rate Algorithm      
SM45123 NVARCHAR VSTRING 10 0 10 Operation Type Material Operation Type Material      
SM45124 NVARCHAR VSTRING 10 0 10 Financial Operation Code Material Financial Operation Code Material      
SM45125 NVARCHAR VSTRING 6 0 6 Line Group 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 Sold Qty Sold Qty      
SM45130 NUMERIC X_NUMERIC 20 8 12 Sold Qty SC Sold Qty SC      
SM45131 DATETIME DATE 0 0 8 Sales Date Sales Date      
SM45132 NVARCHAR VSTRING 6 0 6 Disposal Code Disposal Code      
SM45133 NCHAR STRING 3 0 3 ReasonCode Reason Code      
SM45134 NVARCHAR VSTRING 10 0 10 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 QtyInvoicedSC Quantity that has been Invoiced (Order Unit) for exec lines      
SM45137 INT INTEGER 0 0 9 JobID Job ID      

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

TopList

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