Таблица | Table: PR37 - «Project Templates». Маска имени таблицы | Table Name Mask: «PR37%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?
PR37001 NVARCHAR VSTRING 2 0 2 ProjTypeID Project Type   1 Да / Yes
PR37002 NVARCHAR VSTRING 2 0 2 TemplateNo Template Number   2 Да / Yes
PR37003 NVARCHAR VSTRING 1 0 1 RecordType Record Type A - Project head information
B - Sub-project information
C - Activity line information		 3 Да / Yes
PR37004 NVARCHAR VSTRING 6 0 6 SubProjectID Sub-Project   4 Да / Yes
PR37005 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number   5 Да / Yes
PR37006 NVARCHAR VSTRING 35 0 35 Description1 Description Line 1      
PR37007 NVARCHAR VSTRING 35 0 35 Description2 Description Line 2      
PR37008 NVARCHAR VSTRING 35 0 35 ExtraText1 Extra Description Line 1      
PR37009 NVARCHAR VSTRING 35 0 35 ExtraText2 Extra Description Line 2      
PR37010 NVARCHAR VSTRING 35 0 35 ExtraText3 Extra Description Line 3      
PR37011 NVARCHAR VSTRING 35 0 35 ExtraText4 Extra Description Line 4      
PR37012 NVARCHAR VSTRING 20 0 20 UserDefined1 User Defined Field 1      
PR37013 NVARCHAR VSTRING 10 0 10 UserDefined2 User Defined Field 2      
PR37014 NVARCHAR VSTRING 10 0 10 UserDefined3 User Defined Field 3      
PR37015 NVARCHAR VSTRING 8 0 8 UserDefined4 User Defined Field 4      
PR37016 NVARCHAR VSTRING 8 0 8 UserDefined5 User Defined Field 5      
PR37017 NVARCHAR VSTRING 4 0 4 UserDefined6 User Defined Field 6      
PR37018 NVARCHAR VSTRING 4 0 4 UserDefined7 User Defined Field 7      
PR37019 NVARCHAR VSTRING 2 0 2 UserDefined8 User Defined Field 8      
PR37020 NVARCHAR VSTRING 2 0 2 UserDefined9 User Defined Field 9      
PR37021 NVARCHAR VSTRING 1 0 1 UserDefine10 User Defined Field 10      
PR37022 NVARCHAR VSTRING 4 0 4 ProjectCateg Project Category      
PR37023 NVARCHAR VSTRING 1 0 1 InvModelCost Included in Fixed Price      
PR37024 NVARCHAR VSTRING 1 0 1 InvModelTime Separate Invoice      
PR37025 NVARCHAR VSTRING 1 0 1 EstStrAddUni Estimated Start-up Time Unit 1 - Hours
2 - Days
3 - Weeks
4 - Month
5 - Years		    
PR37026 NVARCHAR VSTRING 3 0 3 EstStrAddTim Estimated Start-up Time      
PR37027 NVARCHAR VSTRING 1 0 1 EstEndAddUni Estimated Length Unit 1 - Hours
2 - Days
3 - Weeks
4 - Month
5 - Years		    
PR37028 NVARCHAR VSTRING 3 0 3 EstEndAddTim Estimated Length Time      
PR37029 NVARCHAR VSTRING 20 0 20 DefBudgAmt (obsolete)      
PR37030 NVARCHAR VSTRING 20 0 20 DefBudgCost Linked to Purchase Order      
PR37031 NVARCHAR VSTRING 35 0 35 TemplDescrip Template Description      
PR37032 NVARCHAR VSTRING 1 0 1 CountNoUsed Project Counter      
PR37033 NVARCHAR VSTRING 2 0 2 ProjAccCode Accounting Code Project      
PR37034 NVARCHAR VSTRING 6 0 6 ActivityCode Activity Code      
PR37035 NUMERIC X_NUMERIC 20 8 12 ActivQtyHour Default Quantity/Hours      
PR37036 NVARCHAR VSTRING 10 0 10 Manager Resource Code Manager      
PR37037 NVARCHAR VSTRING 10 0 10 DefResource Resource Code Default      
PR37038 NVARCHAR VSTRING 8 0 8 ReportCode Report Code      
PR37039 NVARCHAR VSTRING 1 0 1 ActivityType Activity Type      
PR37040 NVARCHAR VSTRING 1 0 1 DocumCode Document Code (Sub-project)      
PR37041 NVARCHAR VSTRING 1 0 1 DebtToCust (obsolete)      
PR37042 NVARCHAR VSTRING 2 0 2 InvSortCode Invoice Sort Code      
PR37043 NVARCHAR VSTRING 2 0 2 VATCodFixPri VAT Code (Initial Invoice)      
PR37044 NVARCHAR VSTRING 1 0 1 DocCode44 Document Layout      
PR37045 NVARCHAR VSTRING 10 0 10 DefPurchaseOrdCount Default Purchase Order Count      
PR37046 NVARCHAR VSTRING 1 0 1 TpWIPCostAcc Type of WIP/Cost Accounting (Time) Accounting method used for cost of time activities:
0 - No WIP/Cost accounting
1 - Direct Cost accounting (transactions entered are booked directly as cost)
2 - WIP accounting
3 - WIP accounting with reversal
4 - Percentage of completion (POC)
5 - WIP with reversal and variance transactions		    
PR37047 NVARCHAR VSTRING 6 0 6 WIPMarTimAct (obsolete)      
PR37048 NVARCHAR VSTRING 6 0 6 WIPMarCosAct (obsolete)      
PR37049 NVARCHAR VSTRING 6 0 6 WIPMarMater (obsolete)      
PR37050 NVARCHAR VSTRING 1 0 1 MatHandAllow (obsolete)      
PR37051 NVARCHAR VSTRING 1 0 1 DefOrCouOR Default Sales Order Counter      
PR37052 NVARCHAR VSTRING 1 0 1 TpWIPCostAc Type of WIP/Cost Accounting (Cost) Accounting method used for cost of cost activities:
0 - No WIP/Cost accounting
1 - Direct Cost accounting (transactions entered are booked directly as cost)
2 - WIP accounting
3 - WIP accounting with reversal
4 - Percentage of completion (POC)
5 - WIP with reversal and variance transactions		    
PR37053 NVARCHAR VSTRING 1 0 1 TpWIPCostAc Type of WIP/Cost Accounting (Material) Accounting method used for cost of material activities:
0 - No WIP/Cost accounting
1 - Direct Cost accounting (transactions entered are booked directly as cost)
2 - WIP accounting
3 - WIP accounting with reversal
4 - Percentage of completion (POC)
5 - WIP with reversal and variance transactions		    
PR37054 NVARCHAR VSTRING 50 0 50 AccCodeString Accounting String      
PR37055 NCHAR STRING 1 0 1 DefLinkSalesOrderCounter Default Linked Sales Order Counter      
PR37056 NCHAR STRING 1 0 1 DefLinkPurchOrderCounter Default Linked Purchase Order Counter      
PR37057 NVARCHAR VSTRING 6 0 6 DefLinkServiceOrderCounter Default Linked Service Order Type      
PR37058 NVARCHAR VSTRING 3 0 3 DefLinkServiceContractCounter Default Linked Service Contract Type      
PR37059 NCHAR STRING 1 0 1 DefLinkWorkOrderCounter Default Linked Work Order Counter      
PR37060 INT INTEGER 0 0 1 Apply accounting rules Apply Accounting Rules 0 - Accounting Dimensions values taken from the template will be kept unchanged during the creation of a project.
1 - Accounting Dimensions values taken from the template may be overwritten by the system.
   
PR37061 INT INTEGER 0 0 1 Apply accounting rules from Activity Card (obsolete)      
PR37062 NCHAR STRING 6 0 6 InvoiceIssuer Invoice Issuer Code      
PR37063 NCHAR SWITCH 1 0 1 InvoiceCategory Invoice Category      
PR37064 NCHAR SWITCH 1 0 1 InvoiceType Invoice Type      
PR37065 NVARCHAR VSTRING 10 0 10 Operation Type Time Operation Type Time      
PR37066 NVARCHAR VSTRING 10 0 10 Financial Operation Code Time Financial Operation Code Time      
PR37067 NVARCHAR VSTRING 10 0 10 Operation Type Cost Operation Type Cost      
PR37068 NVARCHAR VSTRING 10 0 10 Financial Operation Code Cost Financial Operation Code Cost      
PR37069 NVARCHAR VSTRING 10 0 10 Operation Type Material Operation Type Material      
PR37070 NVARCHAR VSTRING 10 0 10 Financial Operation Code Material Financial Operation Code Material      
PR37071 NCHAR STRING 3 0 3 Recognition model Recognition model      
PR37072 NCHAR STRING 1 0 1 Cost Reallocation Cost Reallocation      
PR37073 NCHAR STRING 1 0 1 Closing Rule Closing Rule      
PR37074 NVARCHAR VSTRING 6 0 6 Warranty SubProject Warranty SubProject      
PR37075 NVARCHAR VSTRING 6 0 6 Warranty Activity Line Warranty Activity Line      

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