Таблица: PR37 - «Project Templates». Маска имени таблицы: «PR37%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR37001 | NVARCHAR | VSTRING | 2 | 0 | 2 | ProjTypeID | Project Type | 1 | Да | |
PR37002 | NVARCHAR | VSTRING | 2 | 0 | 2 | TemplateNo | Template Number | 2 | Да | |
PR37003 | NVARCHAR | VSTRING | 1 | 0 | 1 | RecordType | Record Type | A - Project head information
B - Sub-project information C - Activity line information |
3 | Да |
PR37004 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubProjectID | Sub-Project | 4 | Да | |
PR37005 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityLine | Activity Line Number | 5 | Да | |
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 | TpWIPCostAcc | 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 | WIPMarTimAct | (obsolete) | |||
PR37048 | NVARCHAR | VSTRING | 6 | 0 | 6 | WIPMarCosAct | (obsolete) | |||
PR37049 | NVARCHAR | VSTRING | 6 | 0 | 6 | WIPMarMater | (obsolete) | |||
PR37050 | NVARCHAR | VSTRING | 1 | 0 | 1 | MatHandAllow | (obsolete) | |||
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 | TpWIPCostAc | 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 | VSTRING | 50 | 0 | 50 | 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 | Apply accounting rules | 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 | Apply accounting rules from Activity Card | (obsolete) | |||
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 | Operation Type Time | |||
PR37066 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code Time | Financial Operation Code Time | |||
PR37067 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type Cost | Operation Type Cost | |||
PR37068 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code Cost | Financial Operation Code Cost | |||
PR37069 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type Material | Operation Type Material | |||
PR37070 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code Material | Financial Operation Code Material |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Project Management | Project Templates