Таблица | Table: SM70 - «Contract Invoicing History». Маска имени таблицы | Table Name Mask: «SM70%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SM70001 NCHAR STRING 10 0 10 ServContrNo Service Contract Number   1 Да / Yes
SM70002 NCHAR STRING 8 0 8 MinInvoice Reversed Invoice Date   2 Да / Yes
SM70003 NCHAR STRING 15 0 15 InvoiceNo Invoice Number   3 Да / Yes
SM70004 NCHAR STRING 1 0 1 Type Invoice Type   4 Да / Yes
SM70005 NCHAR STRING 10 0 10 InvCustomer Invoice Customer      
SM70006 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SM70007 NUMERIC MONEY 28 8 20 Invoice Net Amount LCU Invoice Net Amount LCU      
SM70008 NUMERIC MONEY 28 8 20 Invoice Net Amount ICU 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 Operation Type Operation Type      
SM70028 NVARCHAR VSTRING 10 0 10 Financial Operation Code Financial Operation Code      
SM70029 NCHAR STRING 6 0 6 Plan Line Number Plan Line Number      
SM70030 INT INTEGER 0 0 2 Invoice Type Invoice Type      
SM70031 INT INTEGER 0 0 2 Event Type Event Type      
SM70032 DATETIME DATE 0 0 8 Event Date Event Date      
SM70033 NUMERIC MONEY 28 8 20 Invoiced Amount CCU Invoiced Amount CCU      
SM70034 NUMERIC MONEY 28 8 20 Deducted Amount CCU Deducted Amount CCU      
SM70035 NCHAR STRING 6 0 6 Tax Code Tax Code      
SM70036 NCHAR STRING 6 0 6 Tax Liability Tax Liability      
SM70037 NCHAR STRING 2 0 2 Payment term Payment term      
SM70038 NVARCHAR VSTRING 200 0 200 Comment Comment      
SM70039 NUMERIC MONEY 28 8 20 Invoiced Amount ICU Invoiced Amount ICU      
SM70040 NUMERIC MONEY 28 8 20 Invoiced Amount LCU Invoiced Amount LCU      
SM70041 NUMERIC MONEY 28 8 20 Deducted Amount ICU Deducted Amount ICU      
SM70042 NUMERIC MONEY 28 8 20 Deducted Amount LCU Deducted Amount LCU      
SM70043 NCHAR STRING 50 0 50 Accounting String Accounting String      
SM70044 NCHAR STRING 25 0 25 AAS Code AAS Code      
SM70045 NCHAR STRING 6 0 6 Line Sorting Number Line Sorting Number      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Contract Invoicing History