One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PR28 — Project Invoice Proposal Head

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 SubProject 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 InvoiceNoforCredit Invoice Number to be Credited      
PR28027 NCHAR STRING 10 0 10 CustCodeInv 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 LanCode Language Code      
PR28031 NCHAR STRING 1 0 1 DocCode Document Code      
PR28032 NCHAR STRING 4 0 4 InvoicePrefix Invoice Prefix      
PR28033 NVARCHAR VSTRING 6 0 6 InvoiceIssuerCode Invoice Issuer Code      
PR28034 NCHAR STRING 1 0 1 InvoiceCategory Invoice Category      
PR28035 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate1 OCU Exchange Rate 1      
PR28036 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate2 OCU Exchange Rate 2      
PR28037 NCHAR STRING 3 0 3 OCUExchangeAlgorithm OCU Exchange Algorithm      
PR28038 NUMERIC X_NUMERIC 18 8 10 ICUExchangeRate1 ICU Exchange Rate 1      
PR28039 NUMERIC X_NUMERIC 18 8 10 ICUExchangeRate2 ICU Exchange Rate 2      
PR28040 NCHAR STRING 3 0 3 ICUExchangeAlgorithm ICU Exchange Algorithm      

Навигация / Navigation: