One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Service Order Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SM70 — Contract Invoicing History

Таблица: SM70 — «Contract Invoicing History». Маска имени таблицы: «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 InvoiceNetAmountLCU Invoice Net Amount LCU      
SM70008 NUMERIC MONEY 28 8 20 InvoiceNetAmountICU Invoice Net Amount ICU      
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 OperationType Operation Type      
SM70028 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
SM70029 NCHAR STRING 6 0 6 PlanLineNumber Plan Line Number      
SM70030 INT INTEGER 0 0 2 InvoiceType Invoice Type      
SM70031 INT INTEGER 0 0 2 EventType Event Type      
SM70032 DATETIME DATE 0 0 8 EventDate Event Date      
SM70033 NUMERIC MONEY 28 8 20 InvoicedAmountCCU Invoiced Amount CCU      
SM70034 NUMERIC MONEY 28 8 20 DeductedAmountCCU Deducted Amount CCU      
SM70035 NCHAR STRING 6 0 6 TaxCode Tax Code      
SM70036 NCHAR STRING 6 0 6 TaxLiability Tax Liability      
SM70037 NCHAR STRING 2 0 2 PaymentTerm Payment term      
SM70038 NVARCHAR VSTRING 200 0 200 Comment Comment      
SM70039 NUMERIC MONEY 28 8 20 InvoicedAmountICU Invoiced Amount ICU      
SM70040 NUMERIC MONEY 28 8 20 InvoicedAmountLCU Invoiced Amount LCU      
SM70041 NUMERIC MONEY 28 8 20 DeductedAmountICU Deducted Amount ICU      
SM70042 NUMERIC MONEY 28 8 20 DeductedAmountLCU Deducted Amount LCU      
SM70043 NCHAR STRING 50 0 50 AccString Accounting String      
SM70044 NCHAR STRING 25 0 25 AASCode AAS Code      
SM70045 NCHAR STRING 6 0 6 LineSortingNumber Line Sorting Number      
SM70046 NCHAR STRING 6 0 6 InvoicePlanLineNumber Invoice Plan Line Number   5 Да

Навигация: