Таблица: PR28 - «Project Invoice Proposal Total File». Маска имени таблицы: «PR28%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR28001 NVARCHAR VSTRING 12 0 12 ProjNumber Project Number   1 Да
PR28002 NVARCHAR VSTRING 6 0 6 Sub_Project Sub-Project   2 Да
PR28003 NVARCHAR VSTRING 2 0 2 SequenceNo Sequence Number   4 Да
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 Да
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      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Project Management | Project Invoice Proposal Head