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 PR37 — Project Templates

Таблица / Table: PR37 — «Project Templates». Маска имени таблицы / Table name mask: «PR37%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 TpWIPCostAcTime 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 Spare Spare      
PR37048 NVARCHAR VSTRING 6 0 6 Spare Spare      
PR37049 NVARCHAR VSTRING 6 0 6 Spare Spare      
PR37050 NVARCHAR VSTRING 1 0 1 DefaultProjectStatus Default Project Status Only for records where PR37003 = ‘A’    
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 TpWIPCostAcMtrl 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 ACCSTR 120 0 120 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 ApplyAccRules 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 DefaultTaxPoint Default Tax Point      
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 activities level default) Operation Type (Time activities level default)      
PR37066 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Time activities level default) Financial Operation Code (Time activities level default)      
PR37067 NVARCHAR VSTRING 10 0 10 Operation Type (Cost activities level default) Operation Type (Cost activities level default)      
PR37068 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Cost activities level default) Financial Operation Code (Cost activities level default)      
PR37069 NVARCHAR VSTRING 10 0 10 Operation Type (Material activities level default) Operation Type (Material activities level default)      
PR37070 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Material activities level default) Financial Operation Code (Material activities level default)      
PR37071 NCHAR STRING 3 0 3 RecognitionModel Recognition model      
PR37072 NCHAR STRING 1 0 1 CostReallocation Cost Reallocation      
PR37073 NCHAR STRING 1 0 1 ClosingRule Closing Rule      
PR37074 NVARCHAR VSTRING 6 0 6 WarrantySubProject Warranty SubProject      
PR37075 NVARCHAR VSTRING 6 0 6 WarrantyActivityLine Warranty Activity Line      
PR37076 NVARCHAR VSTRING 10 0 10 Operation Type (Linked activities level default) Operation Type (Linked activities level default)      
PR37077 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Linked activities level default) Financial Operation Code (Linked activities level default)      

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