Таблица: PR35 - «Project Sub-projects File». Маска имени таблицы: «PR35%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR35001 NCHAR STRING 12 0 12 ProjectNo Project Number   1 Да
PR35002 NCHAR STRING 6 0 6 SubProject Sub-Project   2 Да
PR35003 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      
PR35004 NCHAR STRING 10 0 10 CustCodeDeli Customer Code Delivery      
PR35005 NCHAR STRING 35 0 35 Description Description      
PR35006 NVARCHAR VSTRING 35 0 35 ExtraDescr1 Extra Description Line 1      
PR35007 NVARCHAR VSTRING 35 0 35 ExtraDescr2 Extra Description Line 2      
PR35008 NVARCHAR VSTRING 35 0 35 ExtraDescr3 Extra Description Line 3      
PR35009 NVARCHAR ACCSTR 50 0 50 AccounString Accounting String      
PR35010 NCHAR STRING 10 0 10 Manager Resource Code Manager      
PR35011 DATETIME DATE 0 0 8 PlanStartDat Planned Start Date      
PR35012 DATETIME DATE 0 0 8 ActStartDate Actual Start Date      
PR35013 DATETIME DATE 0 0 8 PlanEndDate Planned End Date      
PR35014 DATETIME DATE 0 0 8 ActEndDate Actual End Date      
PR35015 NVARCHAR VSTRING 2 0 2 AccounCode Accounting Code Project      
PR35016 NVARCHAR VSTRING 1 0 1 InclFixPrice Included in Fixed Price      
PR35017 NVARCHAR VSTRING 8 0 8 ReportCode Report Code      
PR35018 NVARCHAR VSTRING 8 0 8 UserGroup User Group      
PR35019 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
PR35020 NVARCHAR VSTRING 1 0 1 DocumCode Document Layout      
PR35021 NVARCHAR VSTRING 20 0 20 UserDefined1 User Defined Field 1      
PR35022 NVARCHAR VSTRING 10 0 10 UserDefined2 User Defined Field 2      
PR35023 NVARCHAR VSTRING 10 0 10 UserDefined3 User Defined Field 3      
PR35024 NVARCHAR VSTRING 8 0 8 UserDefined4 User Defined Field 4      
PR35025 NVARCHAR VSTRING 8 0 8 UserDefined5 User Defined Field 5      
PR35026 NVARCHAR VSTRING 4 0 4 UserDefined6 User Defined Field 6      
PR35027 NVARCHAR VSTRING 4 0 4 UserDefined7 User Defined Field 7      
PR35028 NVARCHAR VSTRING 2 0 2 UserDefined8 User Defined Field 8      
PR35029 NVARCHAR VSTRING 2 0 2 UserDefined9 User Defined Field 9      
PR35030 NVARCHAR VSTRING 1 0 1 UserDefine10 User Defined Field 10      
PR35031 NVARCHAR VSTRING 2 0 2 CustAccCode Accounting Code Customer      
PR35032 NVARCHAR VSTRING 1 0 1 SeparInvoic Separate Invoice 0 - Sub-project will be invoiced together with the project
1 - Sub-project is invoiced separately, independent of the project.
   
PR35033 NVARCHAR VSTRING 1 0 1 InvoiceProposalFlag Invoice Proposal Print Status      
PR35034 NVARCHAR VSTRING 8 0 8 InvoiceDate Invoice Date      
PR35035 NVARCHAR VSTRING 15 0 15 InvoiceNumber Invoice Number      
PR35036 NVARCHAR VSTRING 20 0 20 CommitedCost Committed Cost (Local Currency)      
PR35037 NUMERIC MONEY 28 8 20 WIPRecCost WIP Recognised Cost (Local Currency)      
PR35038 NUMERIC MONEY 28 8 20 WIPRecRevTime WIP Recognised Revenue Time (Local Currency)      
PR35039 NUMERIC MONEY 28 8 20 WIPRecRevCost WIP Recognised Revenue Cost (Local Currency)      
PR35040 NUMERIC MONEY 28 8 20 WIPRecRevMate WIP Recognised Revenue Material (Local Currency)      
PR35041 DATETIME DATE 0 0 8 LatRevenueDate Last Revenue Recognition Date      
PR35042 NUMERIC X_NUMERIC 14 8 6 LastRevenuePerc Last Revenue Recognition Percentage      
PR35043 NVARCHAR VSTRING 50 0 50 AccString Accounting String (Internal Customer)      
PR35044 NVARCHAR VSTRING 4 0 4 InvoiceIssuer        
PR35045 NCHAR SWITCH 1 0 1 InvoiceCategory        
PR35046 NCHAR SWITCH 1 0 1 InvoiceType        
PR35047 NCHAR STRING 6 0 6 Tax Liability        
PR35048 NVARCHAR VSTRING 10 0 10 Operation Type Sub-Project Operation Type Sub-Project      
PR35049 NVARCHAR VSTRING 10 0 10 Financial Operation Code Sub-Project Financial Operation Code Sub-Project      
PR35050 NVARCHAR VSTRING 10 0 10 Operation Type Time Operation Type Time      
PR35051 NVARCHAR VSTRING 10 0 10 Financial Operation Code Time Financial Operation Code Time      
PR35052 NVARCHAR VSTRING 10 0 10 Operation Type Cost Operation Type Cost      
PR35053 NVARCHAR VSTRING 10 0 10 Financial Operation Code Cost Financial Operation Code Cost      
PR35054 NVARCHAR VSTRING 10 0 10 Operation Type Material Operation Type Material      
PR35055 NVARCHAR VSTRING 10 0 10 Financial Operation Code Material Financial Operation Code Material      
PR35056 NVARCHAR VSTRING 32 0 32 Line GUID Line GUID      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Project Management | Project Sub-projects