Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PR45 - «Invoice Statistics Head». Маска имени таблицы: «PR45%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR45001 | NVARCHAR | VSTRING | 12 | 0 | 12 | ProjectNo | Project Number | 1 | Да | |
PR45002 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 2 | Да | |
PR45003 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date | |||
PR45004 | NVARCHAR | VSTRING | 12 | 0 | 12 | MainProjNo | Main Project Number | |||
PR45005 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCodeInv | Customer Code Invoice | |||
PR45006 | NVARCHAR | VSTRING | 25 | 0 | 25 | ObjProjName | Project Name | |||
PR45007 | NVARCHAR | VSTRING | 2 | 0 | 2 | ProjectType | Project Type | |||
PR45008 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccounString | Accounting String | |||
PR45009 | NVARCHAR | VSTRING | 3 | 0 | 3 | Salesman | Salesman | |||
PR45010 | NVARCHAR | VSTRING | 1 | 0 | 1 | PrModelInvo | Price Model | 0 - Ongoing
1 - Fixed Price 2 - Repeat Invoice |
||
PR45011 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | Currency Code | |||
PR45012 | NVARCHAR | VSTRING | 10 | 0 | 10 | Manager | Resource Code Manager | |||
PR45013 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserDefined1 | User Defined Field 1 | |||
PR45014 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefined2 | User Defined Field 2 | |||
PR45015 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefined3 | User Defined Field 3 | |||
PR45016 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserDefined4 | User Defined Field 4 | |||
PR45017 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserDefined5 | User Defined Field 5 | |||
PR45018 | NVARCHAR | VSTRING | 4 | 0 | 4 | UserDefined6 | User Defined Field 6 | |||
PR45019 | NVARCHAR | VSTRING | 4 | 0 | 4 | UserDefined7 | User Defined Field 7 | |||
PR45020 | NVARCHAR | VSTRING | 2 | 0 | 2 | UserDefined8 | User Defined Field 8 | |||
PR45021 | NVARCHAR | VSTRING | 2 | 0 | 2 | UserDefined9 | User Defined Field 9 | |||
PR45022 | NVARCHAR | VSTRING | 1 | 0 | 1 | UserDefine10 | User Defined Field 10 | |||
PR45023 | NVARCHAR | VSTRING | 4 | 0 | 4 | ProjCategory | Project Category | |||
PR45024 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCodeOrd | Customer Code Order | |||
PR45025 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserGroup | User Group | |||
PR45026 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCodeDeli | Customer Code Delivery | |||
PR45027 | NVARCHAR | VSTRING | 20 | 0 | 20 | CustPOno | Customer Purchase Order Number | |||
PR45028 | 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) |
||
PR45029 | NUMERIC | MONEY | 28 | 8 | 20 | InvoicedAmou | Invoiced Amount (Project Currency) | |||
PR45030 | NVARCHAR | VSTRING | 35 | 0 | 35 | TextAnnotat1 | Text Annotation Line 1 | |||
PR45031 | NVARCHAR | VSTRING | 35 | 0 | 35 | TextAnnotat2 | Text Annotation Line 2 | |||
PR45032 | NUMERIC | MONEY | 28 | 8 | 20 | AmoNoInFxPri | Amount Not Included in Fixed Price (Project Currency) | |||
PR45033 | NUMERIC | MONEY | 28 | 8 | 20 | FixedPricTim | Fixed Price Time Activities (Project Currency) | |||
PR45034 | NUMERIC | MONEY | 28 | 8 | 20 | FixePricCost | Fixed Price Cost Activities (Project Currency) | |||
PR45035 | NUMERIC | MONEY | 28 | 8 | 20 | FixPricMtrl | Fixed Price Material (Project Currency) | |||
PR45036 | NUMERIC | MONEY | 28 | 8 | 20 | DeduAdvInvo | Deducted Advance Amount (Project Currency) | |||
PR45037 | NUMERIC | MONEY | 28 | 8 | 20 | DeduRetenInv | Deducted Retention Amount (Project Currency) | |||
PR45038 | NUMERIC | MONEY | 28 | 8 | 20 | DeduCeilPric | Deducted Ceiling Overrun Amount (Project Currency) | |||
PR45039 | NVARCHAR | VSTRING | 7 | 0 | 7 | SortOrder | Sort Order | |||
PR45040 | 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. | ||
PR45041 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | CurrExcRate | Currency Exchange Rate | |||
PR45042 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | FixedExchangeRate2 | Fixed Exchange Rate 2 | |||
PR45043 | NCHAR | STRING | 3 | 0 | 3 | FixedXchgRateAlgor | Fixed Exchange Rate Algorithm | |||
PR45044 | NCHAR | STRING | 6 | 0 | 6 | TaxLiability | Tax Liability |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Invoice Statistics Head