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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR01001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да
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 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
   
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 TpWIPCostAc 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 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
   
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 (obsolete)      
PR01046 NVARCHAR VSTRING 43 0 43 Spare (obsolete)      
PR01047 NVARCHAR VSTRING 6 0 6 Spare WIP Mark-up Time Activities      
PR01048 NVARCHAR VSTRING 6 0 6 Spare WIP Mark-up Cost Activities      
PR01049 NVARCHAR VSTRING 6 0 6 Spare WIP Mark-up Material Activities      
PR01050 NVARCHAR VSTRING 1 0 1 MatHandAllow Material Handling Is Allowed      
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 WIPrecoReven WIP Recognised Revenue Time (Local Currency)      
PR01060 NVARCHAR VSTRING 20 0 20 WIPrecoReven WIP Recognised Revenue Cost (Local Currency)      
PR01061 NVARCHAR VSTRING 20 0 20 WIPrecoReven 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 Spare 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 ProcStruOrd (obsolete)      
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 PriceList 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 InteresBlock 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 Site_Code Site Code      
PR01118 INT INTEGER 0 0 1 Project_Priority Project Priority      
PR01119 INT INTEGER 0 0 1 Project_Priority_Weighted 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 Project Tax Liability Tax Liability Code Project      
PR01126 NCHAR STRING 6 0 6 Tax Code for invoicing fee Tax Code Invoicing Fee      
PR01127 NCHAR STRING 4 0 4 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 Specification No Specification No      
PR01131 NVARCHAR VSTRING 10 0 10 Operation Type Project Operation Type Project      
PR01132 NVARCHAR VSTRING 10 0 10 Financial Operation Code Project Financial Operation Code Project      
PR01133 NVARCHAR VSTRING 10 0 10 Operation Type Time Operation Type Time      
PR01134 NVARCHAR VSTRING 10 0 10 Financial Operation Code Time Financial Operation Code Time      
PR01135 NVARCHAR VSTRING 10 0 10 Operation Type Cost Operation Type Cost      
PR01136 NVARCHAR VSTRING 10 0 10 Financial Operation Code Cost Financial Operation Code Cost      
PR01137 NVARCHAR VSTRING 10 0 10 Operation Type Material Operation Type Material      
PR01138 NVARCHAR VSTRING 10 0 10 Financial Operation Code Material Financial Operation Code Material      
PR01139 NCHAR SWITCH 1 0 1 Instalment Instalment      
PR01140 NVARCHAR VSTRING 6 0 6 Interest% Interest%      
PR01141 NVARCHAR VSTRING 6 0 6 New Interest% New Interest%      
PR01142 DATETIME DATE 0 0 8 Activate New Interest Date Activate New Interest Date      
PR01143 NUMERIC MONEY 28 8 20 Financial Chage Financial Chage      
PR01144 NCHAR STRING 6 0 6 Interest Tax Code Interest Tax Code      
PR01145 NCHAR STRING 6 0 6 Financial Tax Code Financial Tax Code      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Project Management | Project Master Table