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

Таблица: ST13 - «Service Statistics». Маска имени таблицы: «ST13%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
ST13001 NCHAR STRING 10 0 10 SearchIndex Index Key   1 Да
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 CustCategory Customer Category Invoice      
ST13040 NCHAR STRING 2 0 2 TermsOfPaym Payment Terms      
ST13041 NVARCHAR VSTRING 7 0 7 HoursLog_TA 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 25 0 25 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 NVARCHAR VSTRING 6 0 6 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)      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Statistics | Service Statistics

TopList

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