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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR29001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да
PR29002 NVARCHAR VSTRING 6 0 6 Sub_Project Sub-Project   2 Да
PR29003 DATETIME DATE 0 0 8 InvoiceDate Invoice Date   3 Да
PR29004 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   4 Да
PR29005 NVARCHAR VSTRING 1 0 1 InvTypeStat 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)		    
PR29006 NUMERIC MONEY 28 8 20 InvoicedAmou Invoice Amount (Project Currency) Total invoice amount including tax, cost and deductions. The amount is in the currency of the project.    
PR29007 NUMERIC MONEY 28 8 20 InvoicedVAT Invoice VAT Amount (Project Currency) VAT amount included in the invoice total    
PR29008 NVARCHAR VSTRING 2 0 2 VATcode VAT Code      
PR29009 NVARCHAR VSTRING 35 0 35 ReTxtAnnot1 Text Annotation Line 1      
PR29010 NUMERIC MONEY 28 8 20 DeductAmount Deducted Advance Amount (Project Currency) The amount that was deducted from the invoice amount according to previous invoiced advance amount    
PR29011 NUMERIC MONEY 28 8 20 DeductAmount Deducted Retention Amount (Project Currency) The amount that was deducted from the invoice amount to be retained for the final invoice. The amount is in the currency of the project.    
PR29012 NVARCHAR VSTRING 4 0 4 LinNoInvPlan Line Number Invoice Plan      
PR29013 NUMERIC MONEY 28 8 20 AmNoInclFxPr Amount Not Included in Fixed Price Amount part of the invoice that is not included in the fixed price    
PR29014 NUMERIC MONEY 28 8 20 CurrencyRate Currency Exchange Rate 1      
PR29015 NVARCHAR VSTRING 10 0 10 Manager Resource Code Manager      
PR29016 NVARCHAR VSTRING 1 0 1 FinalInvoice Advance Invoice is Deductible      
PR29017 NVARCHAR VSTRING 1 0 1 PriceModel Price Model 0 - Ongoing
1 - Fixed Price
2 - Repeat Invoice		    
PR29018 NUMERIC MONEY 28 8 20 TrRepeAmou Invoice Amount before Deductions (Project Currency)      
PR29019 NUMERIC MONEY 28 8 20 FxPriceTime Fixed Price Time Activities (Project Currency) For fixed price invoice, the amount related to time activities according to the split defined in the invoice plan.    
PR29020 NUMERIC MONEY 28 8 20 FxPriceCost Fixed Price Cost Activities (Project Currency) For fixed price invoice, the amount related to cost activities according to the split defined in the invoice plan.    
PR29021 NUMERIC MONEY 28 8 20 FxPriceMater Fixed Price Material (Project Currency) For fixed price invoice, the amount related to material according to the split defined in the invoice plan.    
PR29022 NVARCHAR VSTRING 35 0 35 TextAnnot2 Text Annotation Line 2      
PR29023 NUMERIC MONEY 28 8 20 Spare Open Balance Advances (Project Currency) For advance invoice, the open amount that has not yet been deduct on other invoice. The amount is in the currency of the project.    
PR29024 NUMERIC MONEY 28 8 20 Spare Open Balance Advances (Local Currency) For advance invoice, the open amount that has not yet been deduct on other invoice. The amount is in the currency of the local currency for the company.    
PR29025 NUMERIC MONEY 28 8 20 DeduCeiPrice Deducted Ceiling Overrun Amount (Project Currency) The amount that was deducted from the invoice amount as a result of exceeding the ceiling price for the project    
PR29026 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.    
PR29027 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.    
PR29028 NUMERIC MONEY 28 8 20 RetensionAmount Deducted Retention Amount (Local Currency) The amount that was deducted from the invoice amount to be retained for the final invoice. The amount is in the local currency of the company.    
PR29029 NUMERIC MONEY 28 8 20 InvoiceAmount Invoice Amount (Invoice Currency) Total invoice amount including tax, cost and deductions. The amount is in the currency of the invoice.    
PR29030 INT INTEGER 0 0 2 InvoiceCurrencyCode Currency Code Invoice      
PR29031 NUMERIC X_NUMERIC 18 8 10 ExchangeRate2 Currency Exchange Rate 2      
PR29032 NCHAR STRING 3 0 3 ExchangeRateAlgor Currency Exchange Algorithm      
PR29033 INT INTEGER 0 0 2 CurrencyCodeProject Currency Code Project      
PR29034 NCHAR STRING 15 0 15 InvoiceNo_Original\CreditNoteNo Original Invoice Number/Credit Note      
PR29035 NCHAR STRING 10 0 10 InvoiceNo_Customer Customer Code Invoice      
PR29036 NCHAR STRING 6 0 6 Time Tax Code Time Tax Code      
PR29037 NCHAR STRING 6 0 6 Cost Tax Code Cost Tax Code      
PR29038 NCHAR STRING 6 0 6 Material Tax Code Material Tax Code      
PR29039 NCHAR STRING 6 0 6 Tax Liability        
PR29040 NCHAR STRING 4 0 4 Invoice Prefix        
PR29041 NCHAR STRING 2 0 2 Payment Term Payment Term      
PR29042 DATETIME DATE 0 0 8 Invoice Due Date Invoice Due Date      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Project Management | Project Invoice History