На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PR01 — Project Master Table

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR01001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR01002 NVARCHAR VSTRING 12 0 12 MainProjeNo Main Project Number      
PR01003 NVARCHAR VSTRING 10 0 10 CustCodeInv Customer Code Invoice      
PR01004 NVARCHAR VSTRING 35 0 35 ExtrInfLine1 Extra Information Line 1      
PR01005 NVARCHAR VSTRING 35 0 35 ExtrInfLine2 Extra Information Line 2      
PR01006 NVARCHAR VSTRING 35 0 35 ExtrInfLine3 Extra Information Line 3      
PR01007 NVARCHAR VSTRING 35 0 35 ExtrInfLine4 Extra Information Line 4      
PR01008 NVARCHAR VSTRING 35 0 35 CustReferen Customer Reference      
PR01009 NVARCHAR VSTRING 25 0 25 ObjProjName Project Name      
PR01010 NVARCHAR VSTRING 35 0 35 Description1 Description Line 1      
PR01011 NVARCHAR VSTRING 35 0 35 Description2 Description Line 2      
PR01012 NVARCHAR VSTRING 35 0 35 OurReference Our Reference      
PR01013 NVARCHAR VSTRING 2 0 2 AutoProjStat Project Status (Automatic)      
PR01014 NVARCHAR VSTRING 2 0 2 ProjectType Project Type      
PR01015 NVARCHAR ACCSTR 50 0 50 AccounString Accounting String      
PR01016 NVARCHAR VSTRING 3 0 3 Salesman Salesman      
PR01017 NVARCHAR VSTRING 1 0 1 PrcModelInv Price Model for Invoicing      
PR01018 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		    
PR01019 NVARCHAR VSTRING 2 0 2 TermsOfPaym Payment Terms      
PR01020 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
PR01021 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
PR01022 NVARCHAR VSTRING 2 0 2 Pricelist Price List      
PR01023 NVARCHAR VSTRING 1 0 1 TaxliabHours Tax liable Hours      
PR01024 NVARCHAR VSTRING 1 0 1 TaxliablCost Tax liable Cost      
PR01025 NVARCHAR VSTRING 1 0 1 ProjectStat Project Status (Manual) 0 — The project is in quotation status

1 — The project is an active project

9 — The project has been closed		    
PR01026 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		    
PR01027 NVARCHAR VSTRING 1 0 1 TpWIPCostAcCost 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		    
PR01028 NUMERIC MONEY 28 8 20 FixedPrice Fixed Price      
PR01029 NUMERIC MONEY 28 8 20 CeilingPrice Ceiling Price      
PR01030 NVARCHAR VSTRING 10 0 10 Manager Resource Code Manager      
PR01031 NVARCHAR VSTRING 20 0 20 UserDefined1 User Defined Field 1      
PR01032 NVARCHAR VSTRING 10 0 10 UserDefined2 User Defined Field 2      
PR01033 NVARCHAR VSTRING 10 0 10 UserDefined3 User Defined Field 3      
PR01034 NVARCHAR VSTRING 8 0 8 UserDefined4 User Defined Field 4      
PR01035 NVARCHAR VSTRING 8 0 8 UserDefined5 User Defined Field 5      
PR01036 NVARCHAR VSTRING 4 0 4 UserDefined6 User Defined Field 6      
PR01037 NVARCHAR VSTRING 4 0 4 UserDefined7 User Defined Field 7      
PR01038 NVARCHAR VSTRING 2 0 2 UserDefined8 User Defined Field 8      
PR01039 NVARCHAR VSTRING 2 0 2 UserDefined9 User Defined Field 9      
PR01040 NVARCHAR VSTRING 1 0 1 UserDefine10 User Defined Field 10      
PR01041 NVARCHAR VSTRING 4 0 4 ProjCategory Project Category      
PR01042 DATETIME DATE 0 0 8 ActStartDate Actual Start Date      
PR01043 NVARCHAR VSTRING 8 0 8 EnterByUser Created By      
PR01044 DATETIME DATE 0 0 8 EnteredDate Created On      
PR01045 NVARCHAR VSTRING 20 0 20 Spare Spare      
PR01046 NVARCHAR VSTRING 43 0 43 Spare Spare      
PR01047 NVARCHAR VSTRING 6 0 6 Spare Spare      
PR01048 NVARCHAR VSTRING 6 0 6 Spare Spare      
PR01049 NVARCHAR VSTRING 6 0 6 Spare Spare      
PR01050 NVARCHAR VSTRING 1 0 1 Previous Project Status Previous Project Status Stores previous PR01025 value when the project is closed (i.e. PR01025 = ‘9’)    
PR01051 NVARCHAR VSTRING 1 0 1 FlagInvProp Invoice Proposal Status      
PR01052 NVARCHAR VSTRING 1 0 1 MultAlloProj Multi-allocation Project      
PR01053 NVARCHAR VSTRING 2 0 2 ProjAccCode Accounting Code Project      
PR01054 NVARCHAR VSTRING 2 0 2 CustAccCode Accounting Code Customer      
PR01055 NVARCHAR VSTRING 6 0 6 VATCodStdPro VAT Code Project (Standard Value)      
PR01056 NVARCHAR VSTRING 6 0 6 VATcodFxPrIn VAT Code (Initial Invoice)      
PR01057 NVARCHAR VSTRING 54 0 54 PR0157SPARE Accounting String (Internal Customer)      
PR01058 NUMERIC MONEY 28 8 20 WIPrecogCost WIP Recognised Cost (Local Currency)      
PR01059 NUMERIC MONEY 28 8 20 WIPRecRevenueTime WIP Recognised Revenue Time (Local Currency)      
PR01060 NVARCHAR VSTRING 20 0 20 WIPRecRevenueCost WIP Recognised Revenue Cost (Local Currency)      
PR01061 NVARCHAR VSTRING 20 0 20 WIPRecRevenueMtrl WIP Recognised Revenue Material (Local Currency)      
PR01062 NVARCHAR VSTRING 20 0 20 CommitedCost Committed Cost (Local Currency)      
PR01063 DATETIME DATE 0 0 8 LastInvDate Last Invoice Date      
PR01064 NVARCHAR VSTRING 15 0 15 LastInvNo Last Invoice Number      
PR01065 NVARCHAR VSTRING 10 0 10 CustCodeOrd Customer Code Order      
PR01066 DATETIME DATE 0 0 8 QuotatDate Date Quotation Printed      
PR01067 DATETIME DATE 0 0 8 EstStartDate Estimated Start Date      
PR01068 DATETIME DATE 0 0 8 LatestInvDat Latest Invoice Date      
PR01069 DATETIME DATE 0 0 8 EstiCompDate Estimated Completion Date      
PR01070 DATETIME DATE 0 0 8 DateForClos Date Project Closed      
PR01071 DATETIME DATE 0 0 8 StarDateWarr Start Date Warranty      
PR01072 NVARCHAR VSTRING 3 0 3 WarrantyPer Warranty Period Only for information, no functionality attached to warranty period. The value can be between 0 and 999 and it’s not defined which time unit this applies to.    
PR01073 NVARCHAR VSTRING 1 0 1 IndexClause Index Clause      
PR01074 NVARCHAR VSTRING 1 0 1 InteresBlock Interest Block      
PR01075 NVARCHAR VSTRING 1 0 1 Print Non-chargeable Activities Print Non-chargeable Activities 0 — Non-chargeable activities are not printed on Invoice proposal and invoice

1 — Non-chargeable activities are printed on invoice proposal only

2 — Non-chargeable activities are printed on both invoice proposal and invoice		    
PR01076 NVARCHAR VSTRING 1 0 1 InvPropFlag Invoice Print Status 0 — No sent/open invoice or invoice proposal exist for the project

1 — sent/open invoice proposal exist for the project

2 — sent/open invoice exist for the project		    
PR01077 NVARCHAR VSTRING 1 0 1 DefOrCouOR Default Order Counter for Sales Orders      
PR01078 NVARCHAR VSTRING 1 0 1 QuotaPrint Quotation Print Status 0 — Printing of quotation is not selected for the project, it can still be sent manually

1 — Printing of quotation is selected for the project

2 — Quotation has been sent for the project		    
PR01079 NVARCHAR VSTRING 2 0 2 ProjTempIDUs Project Template ID      
PR01080 NVARCHAR VSTRING 2 0 2 CurrBasBdgID Current Base-line Budget ID      
PR01081 NVARCHAR VSTRING 18 0 18 InvOnSubProjectLevl Invoice on Sub-Project Level      
PR01082 NVARCHAR VSTRING 1 0 1 QuotatFlag Is Quotation      
PR01083 NVARCHAR VSTRING 8 0 8 UserGroup User Group      
PR01084 NVARCHAR VSTRING 10 0 10 CustCodeDeli Customer Code Delivery      
PR01085 NVARCHAR VSTRING 1 0 1 FlagOrdeAck Order Confirmation Print Status 0 — Printing of order confirmation is not selected for the project, it can still be sent manually

1 — Printing of order confirmation is selected for the project

2 — Order confirmation has been sent for the project		    
PR01086 NVARCHAR VSTRING 1 0 1 FlagPickList Work-order Print Status 0 — Printing of work-order is not selected for the project, it can still be sent manually

1 — Printing of work-order is selected for the project

2 — Work-order has been sent for the project		    
PR01087 NVARCHAR VSTRING 1 0 1 FlagDipaNote Project Specification Print Status 0 — Printing of project specification is not selected for the project, it can still be sent manually

1 — Printing of project specification is selected for the project

2 — Project specification has been sent for the project		    
PR01088 NVARCHAR VSTRING 1 0 1 FlagInvoice Invoice Print Status      
PR01089 NVARCHAR VSTRING 1 0 1 Tax Point Tax Point      
PR01090 NVARCHAR VSTRING 2 0 2 TermsOfDeliv Delivery Terms      
PR01091 NVARCHAR VSTRING 2 0 2 WayOfDeliv Delivery Method      
PR01092 NUMERIC MONEY 28 8 20 HandlingFee Invoice Fee (Project Currency)      
PR01093 NVARCHAR VSTRING 20 0 20 FreightAmoun (obsolete)      
PR01094 NVARCHAR VSTRING 2 0 2 VATCodeFreig Budget Code for WIP Percentage of Completion      
PR01095 NVARCHAR VSTRING 20 0 20 Packing String Project Template      
PR01096 NVARCHAR VSTRING 10 0 10 VATCodePack Interest Late Payment %      
PR01097 DATETIME DATE 0 0 8 Insurance Last Revenue Recognition Date      
PR01098 NUMERIC X_NUMERIC 14 8 6 VATCodeInsur Last Revenue Recognition Percentage      
PR01099 NUMERIC X_NUMERIC 14 8 6 Warehouse Percentage of Revenue      
PR01100 NVARCHAR VSTRING 2 0 2 InvSortCode Invoice Sort Code      
PR01101 NVARCHAR VSTRING 1 0 1 DocumLayout Document Layout      
PR01102 NVARCHAR VSTRING 1 0 1 CurrContract Currency Contract      
PR01103 NUMERIC X_NUMERIC 28 8 20 FixeExchRate Fixed Exchange Rate 1      
PR01104 NVARCHAR VSTRING 15 0 15 ContractNo Currency Contract Number      
PR01105 NVARCHAR VSTRING 15 0 15 PurchaseOrderCount Default Purchase Order Counter      
PR01106 NVARCHAR VSTRING 20 0 20 CustomPONo Customer Purchase Order Number      
PR01107 DATETIME DATE 0 0 8 BookEntrDate Book-Entry Date      
PR01108 NVARCHAR VSTRING 1 0 1 InvMergeOpt Invoice Merge Option Invoice merge option (invoices will be consolidated in sales ledger).

0 — No consolidated invoice

1 — Consolidate invoice per week

2 — Consolidate invoice per month		    
PR01109 DATETIME DATE 0 0 8 UpdatedOn Updated On      
PR01110 NVARCHAR VSTRING 8 0 8 InterLatePay Updated By      
PR01111 DATETIME DATE 0 0 8 DateConvQuo Date Converted Quotation to Order      
PR01112 NVARCHAR VSTRING 8 0 8 ConvByUser Converted By      
PR01113 NUMERIC X_NUMERIC 18 8 10 FixedExchangeRate2 Fixed Exchange Rate 2      
PR01114 NCHAR STRING 3 0 3 FixedXchgRateAlgorit Fixed Exchange Rate Algorithm      
PR01115 INT INTEGER 0 0 2 invoiceCurrencyCode Currency Code Invoice      
PR01116 NCHAR STRING 10 0 10 RequestNo Customer Request No      
PR01117 NCHAR STRING 25 0 25 SiteCode Site Code      
PR01118 INT INTEGER 0 0 1 ProjectPriority Project Priority      
PR01119 INT INTEGER 0 0 1 ProjectPriorityWeighted Weighted Project Priority      
PR01120 NCHAR STRING 1 0 1 LinkedSalesOrderCounter Linked Sales Order Counter      
PR01121 NCHAR STRING 1 0 1 LinkedPurchOrderCounter Linked Purchase Order Counter      
PR01122 NVARCHAR VSTRING 6 0 6 LinkedServiceOrderCounter Linked Service Order Type      
PR01123 NVARCHAR VSTRING 3 0 3 LinkedServiceContractCounter Linked Service Contract Type      
PR01124 NCHAR STRING 1 0 1 LinkedWorkOrderCounter Linked Work Order Counter      
PR01125 NCHAR STRING 6 0 6 ProjectTaxLiability Tax Liability Code Project      
PR01126 NCHAR STRING 6 0 6 TaxCodeInvFee Tax Code Invoicing Fee      
PR01127 NCHAR STRING 6 0 6 InvoiceIssuer Invoice Issuer Code      
PR01128 NCHAR SWITCH 1 0 1 InvoiceCategory Invoice Category      
PR01129 NCHAR SWITCH 1 0 1 InvoiceType Invoice Type      
PR01130 NVARCHAR VSTRING 15 0 15 SpecificationNo Specification No      
PR01131 NVARCHAR VSTRING 10 0 10 Operation Type (Project level) Operation Type (Project level)      
PR01132 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Project level) Financial Operation Code (Project level)      
PR01133 NVARCHAR VSTRING 10 0 10 Operation Type (Time activities level default) Operation Type (Time activities level default)      
PR01134 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Time activities level default) Financial Operation Code (Time activities level default)      
PR01135 NVARCHAR VSTRING 10 0 10 Operation Type (Cost activities level default) Operation Type (Cost activities level default)      
PR01136 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Cost activities level default) Financial Operation Code (Cost activities level default)      
PR01137 NVARCHAR VSTRING 10 0 10 Operation Type (Material activities level default) Operation Type (Material activities level default)      
PR01138 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Material activities level default) Financial Operation Code (Material activities level default)      
PR01139 NCHAR SWITCH 1 0 1 Instalment Instalment      
PR01140 NVARCHAR VSTRING 6 0 6 InterestPercent Interest%      
PR01141 NVARCHAR VSTRING 6 0 6 NewInterestPercent New Interest%      
PR01142 DATETIME DATE 0 0 8 ActivateNewInterestDate Activate New Interest Date      
PR01143 NUMERIC MONEY 28 8 20 FinancialChage Financial Chage      
PR01144 NCHAR STRING 6 0 6 InterestTaxCode Interest Tax Code      
PR01145 NCHAR STRING 6 0 6 FinancialTaxCode Financial Tax Code      
PR01146 NCHAR STRING 2 0 2 District District      
PR01147 NCHAR STRING 2 0 2 AdvertisingCode Advertising Code      
PR01148 NCHAR STRING 4 0 4 CityCode City Code      
PR01149 NCHAR STRING 5 0 5 SNICode SNI Code      
PR01150 NCHAR STRING 1 0 1 CommissionDistributionMethod Commission Distribution Method      
PR01151 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
PR01152 NVARCHAR VSTRING 2 0 2 PaymentAddressCode Payment Address Code      
PR01153 NCHAR STRING 2 0 2 ExtendedCommissionCode Extended Commission Code      
PR01154 NVARCHAR VSTRING 10 0 10 ExternalCommissionCode External Commission Code      
PR01155 NUMERIC MONEY 28 8 20 ExternalComissionAmount External Comission Amount      
PR01156 INT INTEGER 0 0 1 FlagElectonicProject Flag Electonic Project      
PR01157 INT INTEGER 0 0 1 FlagDocXMLInvoice Flag Doc XML Invoice      
PR01158 NVARCHAR VSTRING 200 0 200 EmailAddress E-Mail Address      
PR01159 DATETIME X_DATETIME 0 0 17 LastInvoiceTime Last Invoice Time      
PR01160 NVARCHAR VSTRING 12 0 12 MasterProject Master Project      
PR01161 NCHAR STRING 3 0 3 RecognitionModel Recognition Model      
PR01162 NCHAR STRING 1 0 1 RecModelMasterProj Rec model from master project      
PR01163 NCHAR STRING 1 0 1 CostReallocation Cost Reallocation      
PR01164 NCHAR STRING 1 0 1 ClosingRule Closing rule      
PR01165 NVARCHAR VSTRING 6 0 6 WarrantySubProject Warranty SubProject      
PR01166 NVARCHAR VSTRING 6 0 6 WarrantyActivityLine Warranty Activity Line      
PR01167 NUMERIC MONEY 28 8 20 ProjectRevenuePCU Project Revenue PCU      
PR01168 NCHAR SWITCH 1 0 1 CreditCheckPassed Credit Check Passed      
PR01169 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
PR01170 NVARCHAR VSTRING 20 0 20 Public Procurement Code 1 Public Procurement Code 1      
PR01171 NVARCHAR VSTRING 20 0 20 Public Procurement Code 2 Public Procurement Code 2      
PR01172 NVARCHAR VSTRING 10 0 10 Operation Type (Linked activities level default) Operation Type (Linked activities level default)      
PR01173 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Linked activities level default) Financial Operation Code (Linked activities level default)      

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