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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SM70001 NCHAR STRING 10 0 10 ServContrNo Service Contract Number   1 Да
SM70002 NCHAR STRING 8 0 8 MinInvoice Reversed Invoice Date   2 Да
SM70003 NCHAR STRING 15 0 15 InvoiceNo Invoice Number   3 Да
SM70004 NCHAR STRING 1 0 1 Type Invoice Type   4 Да
SM70005 NCHAR STRING 10 0 10 InvCustomer Invoice Customer      
SM70006 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SM70007 NUMERIC MONEY 28 8 20 InvAmntLocal Invoice Amount (Local Currency)      
SM70008 NUMERIC MONEY 28 8 20 InvAmntOrig Invoice Amount (Invoice Currency)      
SM70009 NCHAR STRING 2 0 2 CurrencyCode Currency Code Invoice      
SM70010 NCHAR STRING 6 0 6 NomLedgerAC (obsolete)      
SM70011 NCHAR STRING 10 0 10 ServOrderNo Service Order Number      
SM70012 NCHAR STRING 10 0 10 Customer Customer      
SM70013 NCHAR STRING 4 0 4 Site Site Code      
SM70014 NVARCHAR VSTRING 35 0 35 SStckCode Stock Item Code      
SM70015 NVARCHAR VSTRING 20 0 20 SerialNo Serial Number      
SM70016 DATETIME DATE 0 0 8 IdxTabelDate Date Index Table      
SM70017 NUMERIC X_NUMERIC 20 8 12 Cfactor Index Conversion Factor      
SM70018 DATETIME DATE 0 0 8 StartPerDate Period Start Date      
SM70019 DATETIME DATE 0 0 8 StopPeriDate Period End Date      
SM70020 NVARCHAR ACCSTR 50 0 50 AccntString Accounting String      
SM70021 NUMERIC MONEY 28 8 20 VATAmountOCU VAT Amount (Invoice Currency)      
SM70022 NUMERIC MONEY 28 8 20 VATAmountLCU VAT Amount (Local Currency)      
SM70023 DATETIME DATE 0 0 8 BookEntryDate Book Entry Date      
SM70024 NUMERIC X_NUMERIC 21 8 13 InvFeeAmountLCU Invoice Fee Amount LCU      
SM70025 NUMERIC X_NUMERIC 21 8 13 InvFeeAmountOCU Invoice Fee Amount OCU      
SM70026 NCHAR STRING 6 0 6 TaxCodeForInvFee Tax Code for Invoice Fee      
SM70027 NVARCHAR VSTRING 10 0 10 Operation Type Operation Type      
SM70028 NVARCHAR VSTRING 10 0 10 Financial Operation Code Financial Operation Code      

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