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

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table ST13 — Service Statistics

Таблица / Table: ST13 — «Service Statistics». Маска имени таблицы / Table name mask: «ST13%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
ST13001 NCHAR STRING 10 0 10 SearchIndex Index Key   1 Да / Yes
ST13002 BINARY BINSTRING 1 0 1 TransactType Transaction Type 0 — Contract Lines

1 — Service Order Time Activity Line

2 — Service Order Cost Activity Line

3 — Service Order Material Line

4 — Service Order Head		    
ST13003 NCHAR STRING 10 0 10 ServiceNo Service Order Number      
ST13004 NCHAR STRING 10 0 10 MasterOrdNo Master Order Number      
ST13005 NCHAR STRING 6 0 6 OrderType Order Type      
ST13006 NCHAR STRING 3 0 3 Salesman Salesman      
ST13007 NVARCHAR VSTRING 15 0 15 AnalysisCode Analysis Code      
ST13008 NVARCHAR VSTRING 20 0 20 DelivNoteNo Delivery Note Number      
ST13009 DATETIME DATE 0 0 8 SerCalLogDat Service Call Date Logged      
ST13010 NVARCHAR VSTRING 5 0 5 SerCalLogTim Service Call Time Logged      
ST13011 DATETIME DATE 0 0 8 SerCalOpeDat Service Call Date Opened      
ST13012 NVARCHAR VSTRING 5 0 5 SerCalOpeTim Service Call Time Opened      
ST13013 DATETIME DATE 0 0 8 SerCalComDat Service Call Date Committed      
ST13014 NVARCHAR VSTRING 5 0 5 SerCalComTim Service Call Time Committed      
ST13015 DATETIME DATE 0 0 8 SerCalCloDat Service Call Date Closed      
ST13016 NVARCHAR VSTRING 5 0 5 SerCalCloTim Service Call Time Closed      
ST13017 DATETIME DATE 0 0 8 SerCalTADate Service Call TA Date      
ST13018 NVARCHAR VSTRING 5 0 5 SerCalTATime Service Call TA Time      
ST13019 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code      
ST13020 NVARCHAR VSTRING 25 0 25 CustomerName Customer Name      
ST13021 NCHAR STRING 4 0 4 CustCategory Customer Category      
ST13022 NCHAR STRING 2 0 2 District Customer District      
ST13023 NCHAR STRING 2 0 2 AdvertisCode Customer Advertising Area      
ST13024 NCHAR STRING 4 0 4 CityCode Customer Area Code      
ST13025 NCHAR STRING 5 0 5 SNICode Customer Trade Code      
ST13026 NCHAR STRING 4 0 4 Site Site Code      
ST13027 NCHAR STRING 4 0 4 SiteName Site Name      
ST13028 NVARCHAR VSTRING 12 0 12 InternSiteNo Internal Site Number      
ST13029 NVARCHAR VSTRING 35 0 35 ObjStockCode Service Object Stock Item      
ST13030 NVARCHAR VSTRING 25 0 25 Discription1 Service Object Description Line 1      
ST13031 NVARCHAR VSTRING 25 0 25 Discription2 Service Object Description Line 2      
ST13032 NCHAR STRING 4 0 4 ObjProduGrp Service Object Product Group      
ST13033 NCHAR STRING 4 0 4 ObjAltProGrp Service Object Alternative Product Group      
ST13034 NVARCHAR VSTRING 20 0 20 ObjSerialNo Service Object Serial Number      
ST13035 NVARCHAR VSTRING 10 0 10 ServContraNo Service Contract Number      
ST13036 NCHAR STRING 3 0 3 ContractCode Contract Type      
ST13037 NVARCHAR VSTRING 10 0 10 CustCodeInv Customer Code Invoice      
ST13038 NVARCHAR VSTRING 25 0 25 CustNameInv Customer Name Invoice      
ST13039 NCHAR STRING 4 0 4 CustCategoryInv Customer Category Invoice      
ST13040 NCHAR STRING 2 0 2 TermsOfPaym Payment Terms      
ST13041 NVARCHAR VSTRING 7 0 7 HoursLogTA Hours Logged to TA      
ST13042 NVARCHAR VSTRING 7 0 7 HourLogCompl Hours Logged to Completed      
ST13043 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number      
ST13044 DATETIME DATE 0 0 8 InvoceDate Invoice Date      
ST13045 NVARCHAR VSTRING 35 0 35 StkCosActCod Activity/Cost/Stock Item Code      
ST13046 NVARCHAR VSTRING 35 0 35 Description Order Line Description      
ST13047 NCHAR STRING 4 0 4 ProductGroup Product Group Material Line Stock Item      
ST13048 NCHAR STRING 4 0 4 AltProdGroup Alternative Product Group Material Line Stock Item      
ST13049 NVARCHAR VSTRING 10 0 10 FldEngineer Field Engineer      
ST13050 NCHAR STRING 6 0 6 WH Warehouse      
ST13051 NVARCHAR VSTRING 35 0 35 LnStProdCode Material Line Product Code      
ST13052 NVARCHAR VSTRING 35 0 35 LnStatModule Material Line Module      
ST13053 NVARCHAR VSTRING 7 0 7 LineStatPos Material Line Position      
ST13054 NVARCHAR VSTRING 35 0 35 LnStatMatCod Material Line Material Code      
ST13055 NVARCHAR VSTRING 7 0 7 LnStFoultCod Error Code      
ST13056 NVARCHAR ACCSTR 50 0 50 AccntString Accounting String      
ST13057 NUMERIC X_NUMERIC 20 8 12 Quantity Quantity      
ST13058 NUMERIC MONEY 28 8 20 PriceLCU Unit Price (Local Currency)      
ST13059 NUMERIC MONEY 28 8 20 Discount Discount      
ST13060 NUMERIC X_NUMERIC 20 8 12 UsedQty Used Quantity      
ST13061 NUMERIC MONEY 28 8 20 CostPriceQty Unit Cost Price (Local Currency)      
ST13062 NUMERIC X_NUMERIC 20 8 12 BudgetQty Budgeted Quantity      
ST13063 NUMERIC MONEY 28 8 20 BudgetPriLCU Budgeted Unit Price (Local Currency)      
ST13064 NUMERIC MONEY 28 8 20 BudgetCstLCU Budgeted Unit Cost Price (Local Currency)      
ST13065 NUMERIC MONEY 28 8 20 CommissionWitheldCost Commission Witheld Cost      

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