Таблица | Table: PR45 - «Invoice Statistics Head». Маска имени таблицы | Table Name Mask: «PR45%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?
PR45001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR45002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да / Yes
PR45003 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
PR45004 NVARCHAR VSTRING 12 0 12 MainProjNo Main Project Number      
PR45005 NVARCHAR VSTRING 10 0 10 CustCodeInv Customer Code Invoice      
PR45006 NVARCHAR VSTRING 25 0 25 ObjProjName Project Name      
PR45007 NVARCHAR VSTRING 2 0 2 ProjectType Project Type      
PR45008 NVARCHAR ACCSTR 50 0 50 AccounString Accounting String      
PR45009 NVARCHAR VSTRING 3 0 3 Salesman Salesman      
PR45010 NVARCHAR VSTRING 1 0 1 PrModelInvo Price Model 0 - Ongoing
1 - Fixed Price
2 - Repeat Invoice		    
PR45011 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
PR45012 NVARCHAR VSTRING 10 0 10 Manager Resource Code Manager      
PR45013 NVARCHAR VSTRING 20 0 20 UserDefined1 User Defined Field 1      
PR45014 NVARCHAR VSTRING 10 0 10 UserDefined2 User Defined Field 2      
PR45015 NVARCHAR VSTRING 10 0 10 UserDefined3 User Defined Field 3      
PR45016 NVARCHAR VSTRING 8 0 8 UserDefined4 User Defined Field 4      
PR45017 NVARCHAR VSTRING 8 0 8 UserDefined5 User Defined Field 5      
PR45018 NVARCHAR VSTRING 4 0 4 UserDefined6 User Defined Field 6      
PR45019 NVARCHAR VSTRING 4 0 4 UserDefined7 User Defined Field 7      
PR45020 NVARCHAR VSTRING 2 0 2 UserDefined8 User Defined Field 8      
PR45021 NVARCHAR VSTRING 2 0 2 UserDefined9 User Defined Field 9      
PR45022 NVARCHAR VSTRING 1 0 1 UserDefine10 User Defined Field 10      
PR45023 NVARCHAR VSTRING 4 0 4 ProjCategory Project Category      
PR45024 NVARCHAR VSTRING 10 0 10 CustCodeOrd Customer Code Order      
PR45025 NVARCHAR VSTRING 8 0 8 UserGroup User Group      
PR45026 NVARCHAR VSTRING 10 0 10 CustCodeDeli Customer Code Delivery      
PR45027 NVARCHAR VSTRING 20 0 20 CustPOno Customer Purchase Order Number      
PR45028 NVARCHAR VSTRING 1 0 1 InvTypeStat Invoice Type 0 - Initial invoice
1 - Ongoing invoice
2 - Fixed price invoice (ongoing)
3 - Fixed price invoice (invoice plan)
4 - Final invoice (retention)
5 - Repeat invoice
6 - Fixed price invoice (final invoice)		    
PR45029 NUMERIC MONEY 28 8 20 InvoicedAmou Invoiced Amount (Project Currency)      
PR45030 NVARCHAR VSTRING 35 0 35 TextAnnotat1 Text Annotation Line 1      
PR45031 NVARCHAR VSTRING 35 0 35 TextAnnotat2 Text Annotation Line 2      
PR45032 NUMERIC MONEY 28 8 20 AmoNoInFxPri Amount Not Included in Fixed Price (Project Currency)      
PR45033 NUMERIC MONEY 28 8 20 FixedPricTim Fixed Price Time Activities (Project Currency)      
PR45034 NUMERIC MONEY 28 8 20 FixePricCost Fixed Price Cost Activities (Project Currency)      
PR45035 NUMERIC MONEY 28 8 20 FixPricMtrl Fixed Price Material (Project Currency)      
PR45036 NUMERIC MONEY 28 8 20 DeduAdvInvo Deducted Advance Amount (Project Currency)      
PR45037 NUMERIC MONEY 28 8 20 DeduRetenInv Deducted Retention Amount (Project Currency)      
PR45038 NUMERIC MONEY 28 8 20 DeduCeilPric Deducted Ceiling Overrun Amount (Project Currency)      
PR45039 NVARCHAR VSTRING 7 0 7 SortOrder Sort Order      
PR45040 NVARCHAR VSTRING 1 0 1 DetailLevel Detail Level Value from 1-7 indicating which level in the sort order that should be used as last summary level.    
PR45041 NUMERIC X_NUMERIC 28 8 20 CurrExcRate Currency Exchange Rate      
PR45042 NUMERIC X_NUMERIC 18 8 10 FixedExchangeRate2 Fixed Exchange Rate 2      
PR45043 NCHAR STRING 3 0 3 FixedXchgRateAlgor Fixed Exchange Rate Algorithm      
PR45044 NCHAR STRING 6 0 6 Tax Liability        

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Project Management | Invoice Statistics Head