Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: 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