Таблица / Table: PR37 — «Project Templates». Маска имени таблицы / Table name mask: «PR37%cc00»
Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
PR37001 | NVARCHAR | VSTRING | 2 | 0 | 2 | ProjTypeID | Project Type | 1 | Да / Yes | |
PR37002 | NVARCHAR | VSTRING | 2 | 0 | 2 | TemplateNo | Template Number | 2 | Да / Yes | |
PR37003 | NVARCHAR | VSTRING | 1 | 0 | 1 | RecordType | Record Type | A — Project head information B — Sub-project information C — Activity line information |
3 | Да / Yes |
PR37004 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubProjectID | Sub-Project | 4 | Да / Yes | |
PR37005 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityLine | Activity Line Number | 5 | Да / Yes | |
PR37006 | NVARCHAR | VSTRING | 35 | 0 | 35 | Description1 | Description Line 1 | |||
PR37007 | NVARCHAR | VSTRING | 35 | 0 | 35 | Description2 | Description Line 2 | |||
PR37008 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExtraText1 | Extra Description Line 1 | |||
PR37009 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExtraText2 | Extra Description Line 2 | |||
PR37010 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExtraText3 | Extra Description Line 3 | |||
PR37011 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExtraText4 | Extra Description Line 4 | |||
PR37012 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserDefined1 | User Defined Field 1 | |||
PR37013 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefined2 | User Defined Field 2 | |||
PR37014 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefined3 | User Defined Field 3 | |||
PR37015 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserDefined4 | User Defined Field 4 | |||
PR37016 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserDefined5 | User Defined Field 5 | |||
PR37017 | NVARCHAR | VSTRING | 4 | 0 | 4 | UserDefined6 | User Defined Field 6 | |||
PR37018 | NVARCHAR | VSTRING | 4 | 0 | 4 | UserDefined7 | User Defined Field 7 | |||
PR37019 | NVARCHAR | VSTRING | 2 | 0 | 2 | UserDefined8 | User Defined Field 8 | |||
PR37020 | NVARCHAR | VSTRING | 2 | 0 | 2 | UserDefined9 | User Defined Field 9 | |||
PR37021 | NVARCHAR | VSTRING | 1 | 0 | 1 | UserDefine10 | User Defined Field 10 | |||
PR37022 | NVARCHAR | VSTRING | 4 | 0 | 4 | ProjectCateg | Project Category | |||
PR37023 | NVARCHAR | VSTRING | 1 | 0 | 1 | InvModelCost | Included in Fixed Price | |||
PR37024 | NVARCHAR | VSTRING | 1 | 0 | 1 | InvModelTime | Separate Invoice | |||
PR37025 | NVARCHAR | VSTRING | 1 | 0 | 1 | EstStrAddUni | Estimated Start-up Time Unit | 1 — Hours 2 — Days 3 — Weeks 4 — Month 5 — Years |
||
PR37026 | NVARCHAR | VSTRING | 3 | 0 | 3 | EstStrAddTim | Estimated Start-up Time | |||
PR37027 | NVARCHAR | VSTRING | 1 | 0 | 1 | EstEndAddUni | Estimated Length Unit | 1 — Hours 2 — Days 3 — Weeks 4 — Month 5 — Years |
||
PR37028 | NVARCHAR | VSTRING | 3 | 0 | 3 | EstEndAddTim | Estimated Length Time | |||
PR37029 | NVARCHAR | VSTRING | 20 | 0 | 20 | DefBudgAmt | (obsolete) | |||
PR37030 | NVARCHAR | VSTRING | 20 | 0 | 20 | DefBudgCost | Linked to Purchase Order | |||
PR37031 | NVARCHAR | VSTRING | 35 | 0 | 35 | TemplDescrip | Template Description | |||
PR37032 | NVARCHAR | VSTRING | 1 | 0 | 1 | CountNoUsed | Project Counter | |||
PR37033 | NVARCHAR | VSTRING | 2 | 0 | 2 | ProjAccCode | Accounting Code Project | |||
PR37034 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityCode | Activity Code | |||
PR37035 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ActivQtyHour | Default Quantity/Hours | |||
PR37036 | NVARCHAR | VSTRING | 10 | 0 | 10 | Manager | Resource Code Manager | |||
PR37037 | NVARCHAR | VSTRING | 10 | 0 | 10 | DefResource | Resource Code Default | |||
PR37038 | NVARCHAR | VSTRING | 8 | 0 | 8 | ReportCode | Report Code | |||
PR37039 | NVARCHAR | VSTRING | 1 | 0 | 1 | ActivityType | Activity Type | |||
PR37040 | NVARCHAR | VSTRING | 1 | 0 | 1 | DocumCode | Document Code (Sub-project) | |||
PR37041 | NVARCHAR | VSTRING | 1 | 0 | 1 | DebtToCust | (obsolete) | |||
PR37042 | NVARCHAR | VSTRING | 2 | 0 | 2 | InvSortCode | Invoice Sort Code | |||
PR37043 | NVARCHAR | VSTRING | 2 | 0 | 2 | VATCodFixPri | VAT Code (Initial Invoice) | |||
PR37044 | NVARCHAR | VSTRING | 1 | 0 | 1 | DocCode44 | Document Layout | |||
PR37045 | NVARCHAR | VSTRING | 10 | 0 | 10 | DefPurchaseOrdCount | Default Purchase Order Count | |||
PR37046 | NVARCHAR | VSTRING | 1 | 0 | 1 | TpWIPCostAcTime | Type of WIP/Cost Accounting (Time) | Accounting method used for cost of time activities: 0 — No WIP/Cost accounting 1 — Direct Cost accounting (transactions entered are booked directly as cost) 2 — WIP accounting 3 — WIP accounting with reversal 4 — Percentage of completion (POC) 5 — WIP with reversal and variance transactions |
||
PR37047 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | Spare | |||
PR37048 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | Spare | |||
PR37049 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | Spare | |||
PR37050 | NVARCHAR | VSTRING | 1 | 0 | 1 | DefaultProjectStatus | Default Project Status | Only for records where PR37003 = ‘A’ | ||
PR37051 | NVARCHAR | VSTRING | 1 | 0 | 1 | DefOrCouOR | Default Sales Order Counter | |||
PR37052 | NVARCHAR | VSTRING | 1 | 0 | 1 | TpWIPCostAc | Type of WIP/Cost Accounting (Cost) | Accounting method used for cost of cost activities: 0 — No WIP/Cost accounting 1 — Direct Cost accounting (transactions entered are booked directly as cost) 2 — WIP accounting 3 — WIP accounting with reversal 4 — Percentage of completion (POC) 5 — WIP with reversal and variance transactions |
||
PR37053 | NVARCHAR | VSTRING | 1 | 0 | 1 | TpWIPCostAcMtrl | Type of WIP/Cost Accounting (Material) | Accounting method used for cost of material activities: 0 — No WIP/Cost accounting 1 — Direct Cost accounting (transactions entered are booked directly as cost) 2 — WIP accounting 3 — WIP accounting with reversal 4 — Percentage of completion (POC) 5 — WIP with reversal and variance transactions |
||
PR37054 | NVARCHAR | ACCSTR | 120 | 0 | 120 | AccCodeString | Accounting String | |||
PR37055 | NCHAR | STRING | 1 | 0 | 1 | DefLinkSalesOrderCounter | Default Linked Sales Order Counter | |||
PR37056 | NCHAR | STRING | 1 | 0 | 1 | DefLinkPurchOrderCounter | Default Linked Purchase Order Counter | |||
PR37057 | NVARCHAR | VSTRING | 6 | 0 | 6 | DefLinkServiceOrderCounter | Default Linked Service Order Type | |||
PR37058 | NVARCHAR | VSTRING | 3 | 0 | 3 | DefLinkServiceContractCounter | Default Linked Service Contract Type | |||
PR37059 | NCHAR | STRING | 1 | 0 | 1 | DefLinkWorkOrderCounter | Default Linked Work Order Counter | |||
PR37060 | INT | INTEGER | 0 | 0 | 1 | ApplyAccRules | Apply Accounting Rules | 0 — Accounting Dimensions values taken from the template will be kept unchanged during the creation of a project. 1 — Accounting Dimensions values taken from the template may be overwritten by the system. |
||
PR37061 | INT | INTEGER | 0 | 0 | 1 | DefaultTaxPoint | Default Tax Point | |||
PR37062 | NCHAR | STRING | 6 | 0 | 6 | InvoiceIssuer | Invoice Issuer Code | |||
PR37063 | NCHAR | SWITCH | 1 | 0 | 1 | InvoiceCategory | Invoice Category | |||
PR37064 | NCHAR | SWITCH | 1 | 0 | 1 | InvoiceType | Invoice Type | |||
PR37065 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type (Time activities level default) | Operation Type (Time activities level default) | |||
PR37066 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code (Time activities level default) | Financial Operation Code (Time activities level default) | |||
PR37067 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type (Cost activities level default) | Operation Type (Cost activities level default) | |||
PR37068 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code (Cost activities level default) | Financial Operation Code (Cost activities level default) | |||
PR37069 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type (Material activities level default) | Operation Type (Material activities level default) | |||
PR37070 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code (Material activities level default) | Financial Operation Code (Material activities level default) | |||
PR37071 | NCHAR | STRING | 3 | 0 | 3 | RecognitionModel | Recognition model | |||
PR37072 | NCHAR | STRING | 1 | 0 | 1 | CostReallocation | Cost Reallocation | |||
PR37073 | NCHAR | STRING | 1 | 0 | 1 | ClosingRule | Closing Rule | |||
PR37074 | NVARCHAR | VSTRING | 6 | 0 | 6 | WarrantySubProject | Warranty SubProject | |||
PR37075 | NVARCHAR | VSTRING | 6 | 0 | 6 | WarrantyActivityLine | Warranty Activity Line | |||
PR37076 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type (Linked activities level default) | Operation Type (Linked activities level default) | |||
PR37077 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code (Linked activities level default) | Financial Operation Code (Linked activities level default) |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Основными Средствами»/List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Контрактами»/List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Прямая выписка счетов»/List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Главная Книга»/List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Ресурсами»/List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «База Данных рынка»/List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Материалами в Производстве»/List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказы на Продажу»/List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Зарплата»/List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказ на Закупку»/List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Закупок»/List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Долговые обязательства»/List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Проектами»/List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Запасами»/List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Продаж»/List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление заказом на обслуживание»/List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Статистика»/List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Системные Утилиты/Автом. Офиса»/List of tables of module «System Utilities/Office Autom.»