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