Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PRGL - «Project History WIP Journal». Маска имени таблицы: «PRGL%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PRGL001 | NUMERIC | NUMBER | 20 | 0 | 9 | RecCounter | RecCounter | |||
PRGL002 | NCHAR | STRING | 9 | 0 | 9 | TransactionNo | TransactionNo | 4 | Да | |
PRGL003 | NCHAR | STRING | 7 | 0 | 7 | LineNumber | LineNumber | 5 | Да | |
PRGL004 | DATETIME | DATE | 0 | 0 | 8 | TransactionDate | TransactionDate | |||
PRGL005 | NCHAR | SWITCH | 1 | 0 | 1 | Flag | Flag | |||
PRGL006 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccountingString | AccountingString | |||
PRGL007 | NUMERIC | MONEY | 28 | 8 | 20 | AmountLCU | AmountLCU | |||
PRGL008 | INT | INTEGER | 0 | 0 | 2 | CurrencyCode | CurrencyCode | |||
PRGL009 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccountingStringLCU | AccountingStringLCU | |||
PRGL010 | NUMERIC | MONEY | 28 | 8 | 20 | AmountOCU | AmountOCU | Amount in Project Currency | ||
PRGL011 | NVARCHAR | VSTRING | 36 | 0 | 36 | TransactionText | TransactionText | |||
PRGL012 | NCHAR | STRING | 10 | 0 | 10 | Code1Engineer | Code1Engineer | |||
PRGL013 | NVARCHAR | VSTRING | 25 | 0 | 25 | Code2Project | Code2Project | |||
PRGL014 | NCHAR | STRING | 6 | 0 | 6 | Code3ActivityStructLineNum | Code3ActivityStructLineNum | |||
PRGL015 | NCHAR | STRING | 2 | 0 | 2 | Code4 | Code4 | |||
PRGL016 | NVARCHAR | VSTRING | 35 | 0 | 35 | Code5 | Code5 | |||
PRGL017 | NCHAR | STRING | 8 | 0 | 8 | Code6TransLineNumber | Code6TransLineNumber | |||
PRGL018 | NCHAR | STRING | 1 | 0 | 1 | Tag1 | Tag1 | |||
PRGL019 | NCHAR | STRING | 1 | 0 | 1 | Tag2 | Tag2 | |||
PRGL020 | NCHAR | STRING | 1 | 0 | 1 | Tag3 | Tag3 | |||
PRGL021 | NCHAR | STRING | 1 | 0 | 1 | TransLineType | TransLineType | |||
PRGL022 | NCHAR | STRING | 1 | 0 | 1 | TransLineSign | TransLineSign | |||
PRGL023 | NUMERIC | NUMBER | 20 | 0 | 1 | NumberOfDecimals | NumberOfDecimals | |||
PRGL024 | NCHAR | STRING | 5 | 0 | 5 | LinkCode | LinkCode | |||
PRGL025 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
PRGL026 | INT | INTEGER | 0 | 0 | 4 | UnitCode | UnitCode | |||
PRGL027 | NUMERIC | MONEY | 28 | 8 | 20 | AmountCCU | AmountCCU | |||
PRGL028 | NCHAR | STRING | 13 | 0 | 13 | ContraAcc | ContraAcc | |||
PRGL029 | NUMERIC | NUMBER | 20 | 0 | 6 | JournalNo | JournalNo | |||
PRGL030 | NCHAR | STRING | 9 | 0 | 9 | PLReference | PLReference | |||
PRGL031 | NCHAR | STRING | 6 | 0 | 6 | SubprojectNum | SubprojectNum | |||
PRGL032 | NCHAR | STRING | 6 | 0 | 6 | ActivityLineNum | ActivityLineNum | |||
PRGL033 | NCHAR | STRING | 8 | 0 | 8 | UserIDEnteredBy | UserIDEnteredBy | 1 | Да | |
PRGL034 | DATETIME | DATE | 0 | 0 | 8 | DateOfEntry | DateOfEntry | 3 | Да | |
PRGL035 | NCHAR | STRING | 8 | 0 | 8 | UserIDUpdatedBy | UserIDUpdatedBy | |||
PRGL036 | DATETIME | DATE | 0 | 0 | 8 | DateOfUpdate | DateOfUpdate | |||
PRGL037 | NVARCHAR | VSTRING | 36 | 0 | 36 | TransactionTextOCU | TransactionTextOCU | |||
PRGL038 | NCHAR | STRING | 2 | 0 | 2 | SourceCompany | SourceCompany | |||
PRGL039 | NCHAR | STRING | 8 | 0 | 8 | UserIDPrintedBy | UserIDPrintedBy | |||
PRGL040 | DATETIME | DATE | 0 | 0 | 8 | DateOfPrint | DateOfPrint | |||
PRGL041 | NCHAR | SWITCH | 1 | 0 | 1 | PrintStatus | PrintStatus | |||
PRGL042 | NCHAR | STRING | 9 | 0 | 9 | GLTransactionNum | GLTransactionNum | 2 | Да |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Project History WIP Journal