Таблица: 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