One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PR35 — Project Sub-projects

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR35001 NCHAR STRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR35002 NCHAR STRING 6 0 6 SubProject Sub-Project   2 Да / Yes
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 120 0 120 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 ACCSTR 120 0 120 AccString Accounting String (Internal Customer)      
PR35044 NVARCHAR VSTRING 6 0 6 InvoiceIssuer InvoiceIssuer      
PR35045 NCHAR SWITCH 1 0 1 InvoiceCategory InvoiceCategory      
PR35046 NCHAR SWITCH 1 0 1 InvoiceType InvoiceType      
PR35047 NCHAR STRING 6 0 6 TaxLiability Tax Liability      
PR35048 NVARCHAR VSTRING 10 0 10 Operation Type (Sub-Project level) Operation Type (Sub-Project level)      
PR35049 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Sub-Project level) Financial Operation Code (Sub-Project level)      
PR35050 NVARCHAR VSTRING 10 0 10 Operation Type (Time activities level) Operation Type (Time activities level)      
PR35051 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Time activities level) Financial Operation Code (Time activities level)      
PR35052 NVARCHAR VSTRING 10 0 10 Operation Type (Cost activities level) Operation Type (Cost activities level)      
PR35053 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Cost activities level) Financial Operation Code (Cost activities level)      
PR35054 NVARCHAR VSTRING 10 0 10 Operation Type (Material activities level) Operation Type (Material activities level)      
PR35055 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Material activities level) Financial Operation Code (Material activities level)      
PR35056 NVARCHAR VSTRING 36 0 36 LineGUID External ID      
PR35057 DATETIME DATE 0 0 8 BookEntryDate Book-Entry Date      
PR35058 INT INTEGER 0 0 1 FlagDocXMLInvoice Flag Doc XML Invoice      
PR35059 DATETIME X_DATETIME 0 0 17 InvoiceTime Invoice Time      
PR35060 NVARCHAR VSTRING 10 0 10 Operation Type (Linked activities level) Operation Type (Linked activities level)      
PR35061 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Linked activities level) Financial Operation Code (Linked activities level)      
PR35062 DATETIME DATE 0 0 8 LatestInvoiceDate Latest Invoice Date      

Навигация / Navigation: