Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

Таблица | Table: PR28 - «Project Invoice Proposal Total File». Маска имени таблицы | Table Name Mask: «PR28%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?
PR28001 NVARCHAR VSTRING 12 0 12 ProjNumber Project Number   1 Да / Yes
PR28002 NVARCHAR VSTRING 6 0 6 Sub_Project Sub-Project   2 Да / Yes
PR28003 NVARCHAR VSTRING 2 0 2 SequenceNo Sequence Number   4 Да / Yes
PR28004 NVARCHAR VSTRING 1 0 1 InvoiceType Invoice Type 0 - Initial invoice
1 - Ongoing invoice
2 - Fixed price invoice (ongoing)
3 - Fixed price invoice (invoice plan)
4 - Final invoice (retention)
5 - Repeat invoice
6 - Fixed price invoice (final invoice)		    
PR28005 NVARCHAR VSTRING 10 0 10 Manager Resource Code Manager      
PR28006 NVARCHAR VSTRING 4 0 4 LnNoInvPlan Line Number on Invoice Plan      
PR28007 NVARCHAR VSTRING 1 0 1 FinalInvoice Advance Invoice is Deductible      
PR28008 NVARCHAR VSTRING 1 0 1 PriceModel Price Model 0 - Ongoing
1 - Fixed Price
2 - Repeat Invoice		    
PR28009 NUMERIC MONEY 28 8 20 TrAmouRepAmo Invoice Amount (Project Currency) Invoice total excluding tax and additional costs (invoice fee)    
PR28010 NUMERIC MONEY 28 8 20 FixePricTime Fixed Price Time Activities (Project Currency) For fixed amount invoices the part of the invoice amount that are related to time activities according to the split setup on the invoice plan.    
PR28011 NUMERIC MONEY 28 8 20 FixPriceCost Fixed Price Cost Activities (Project Currency) For fixed amount invoices the part of the invoice amount that are related to cost activities according to the split setup on the invoice plan.    
PR28012 NUMERIC MONEY 28 8 20 FixPriMateri Fixed Price Material (Project Currency) For fixed amount invoices the part of the invoice amount that are related to material activities according to the split setup on the invoice plan.    
PR28013 NVARCHAR VSTRING 2 0 2 VATCode VAT Code      
PR28014 NVARCHAR VSTRING 35 0 35 TextAnnot1 Text Annotation Line 1      
PR28015 NVARCHAR VSTRING 35 0 35 TextAnnot2 Text Annotation Line 2      
PR28016 NUMERIC MONEY 28 8 20 DeduAdvInvo Deducted Advance Amount (Project Currency) The amount that is deducted from the invoice amount according to previous invoiced advance amount    
PR28017 NUMERIC MONEY 28 8 20 DeduRetenInv Deducted Retention Amount (Project Currency) The amount that is deducted from the invoice amount to be retained for the final invoice    
PR28018 NUMERIC MONEY 28 8 20 DedCeilPrice Deducted Ceiling Overrun Amount (Project Currency) The amount that is deducted from the invoice amount as a result of exceeding the ceiling price for the project    
PR28019 NVARCHAR VSTRING 7 0 7 SortOrder Sort Order String defining the sort order to be used on the invoice, its created based on the invoice sort order code.    
PR28020 NVARCHAR VSTRING 1 0 1 DetailLevel Detail Level Value from 1-7 indicating which level in the sort order that should be used as last summary level.    
PR28021 NUMERIC MONEY 28 8 20 AmNoInclFxPr Amount Not Included in Fixed Price (Project Currency) Invoice amount that is not included in the fixed price, this amount is added to the invoice amount in PR28009.    
PR28022 NCHAR STRING 1 0 1 LineUsedForProposal Invoice Proposal Print Status 0 - Invoice proposal has not been sent for the line
1 - Invoice proposal has been sent		    
PR28023 NCHAR STRING 1 0 1 SpareFlag2 (obsolete)      
PR28024 INT INTEGER 0 0 2 CurrencyCode Currency Code Invoice      
PR28025 DATETIME DATE 0 0 8 CurrencyDate Currency Date      
PR28026 NCHAR STRING 15 0 15 InvoiceNo_for_Credit Invoice Number to be Credited      
PR28027 NCHAR STRING 10 0 10 Customer_Code_Invoice Customer Code Invoice   3 Да / Yes
PR28028 NCHAR STRING 15 0 15 InvoiceNo Invoice Number      
PR28029 INT INTEGER 0 0 4 InvoiceCopyNumber Invoice Copy Number      
PR28030 NCHAR STRING 3 0 3 Language Code Language Code      
PR28031 NCHAR STRING 1 0 1 Document Code Document Code      

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