Таблица | Table: SM07 - «Service Order Material File I/O». Маска имени таблицы | Table Name Mask: «SM07%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | 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 | 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 | Да / 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 | 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 | 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 | Flag_Created_by_JobOrder | Was Created from Job | |||
SM07113 | INT | INTEGER | 0 | 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 | 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 | Delivery blocked | 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 | Approved Credit Limit | Approved Credit Limit |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Service Order Material Lines