Таблица: PR02 - «Project Activities» («Вид деятельности по Проекту»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| PR02001 | STRING | 12 | ProjectNo | Да |
| PR02002 | STRING | 6 | SubProject | Да |
| PR02003 | STRING | 6 | ActivityLine | Да |
| PR02004 | STRING | 3 | ActiStruLine | Да |
| PR02005 | STRING | 1 | ActivType05 | |
| PR02006 | STRING | 6 | ActivityCode | |
| PR02007 | STRING | 10 | ResourceCode | |
| PR02008 | VSTRING | 35 | Description | |
| PR02009 | VSTRING | 35 | ExtraDescr1 | |
| PR02010 | VSTRING | 35 | ExtraDescr2 | |
| PR02011 | VSTRING | 35 | ExtraDescr3 | |
| PR02012 | STRING | 10 | Manager | |
| PR02013 | ACCSTR | 50 | AccounString | |
| PR02014 | VSTRING | 2 | AccounCode | |
| PR02015 | DATE | 8 | EstStartDate | |
| PR02016 | DATE | 8 | ActStartDate | |
| PR02017 | DATE | 8 | EstimEndDate | |
| PR02018 | DATE | 8 | ActuEndDate | |
| PR02019 | VSTRING | 1 | IncFixedPric | |
| PR02020 | X_NUMERIC | 12 | ForecastHour | |
| PR02021 | X_NUMERIC | 12 | ForcDeHrsQty | |
| PR02022 | X_NUMERIC | 12 | ActRepHrsQty | |
| PR02023 | X_NUMERIC | 12 | ActDebHrsQty | |
| PR02024 | X_NUMERIC | 12 | EstRemHrsQty | |
| PR02025 | X_NUMERIC | 12 | PlannedHours | |
| PR02026 | MONEY | 20 | ForecRevenue | |
| PR02027 | MONEY | 20 | ForecDebReve | |
| PR02028 | MONEY | 20 | ActualReven | |
| PR02029 | VSTRING | 20 | Spare | |
| PR02030 | VSTRING | 20 | Spare | |
| PR02031 | MONEY | 20 | ForecastReve | |
| PR02032 | MONEY | 20 | ForecastCost | |
| PR02033 | MONEY | 20 | ActualCost | |
| PR02034 | VSTRING | 20 | Spare | |
| PR02035 | MONEY | 20 | ForecDebReve | |
| PR02036 | VSTRING | 20 | PurchaseOrderMarkup | |
| PR02037 | MONEY | 20 | ActualDebRev | |
| PR02038 | VSTRING | 20 | ActivityToPurchOrd | |
| PR02039 | VSTRING | 1 | InvLinLayout | |
| PR02040 | VSTRING | 2 | VATCode | |
| PR02041 | VSTRING | 8 | ReporCode | |
| PR02042 | VSTRING | 1 | LinkedModule | |
| PR02043 | VSTRING | 10 | LinkedOrdNo | |
| PR02044 | DATE | 8 | EstDelivDate | |
| PR02045 | VSTRING | 1 | AutUpdEstMtr | |
| PR02046 | DATE | 8 | LinkCreatDat | |
| PR02047 | DATE | 8 | LinkClosDate | |
| PR02048 | VSTRING | 2 | LinkStatus | |
| PR02049 | MONEY | 20 | WIPTransAmo | |
| PR02050 | VSTRING | 1 | WIPStatus | |
| PR02051 | VSTRING | 1 | FlReqNotePrn | |
| PR02052 | STRING | 9 | ReverIndLine | |
| PR02053 | VSTRING | 1 | FlaPrintDoc1 | |
| PR02054 | VSTRING | 1 | FlaPrintDoc2 | |
| PR02055 | VSTRING | 1 | FlaPrintDoc3 | |
| PR02056 | VSTRING | 1 | FlaPrintDoc4 | |
| PR02057 | VSTRING | 1 | FixPriceUnit | |
| PR02058 | X_NUMERIC | 10 | ExchangeRate1 | |
| PR02059 | X_NUMERIC | 10 | ExchangeRate2 | |
| PR02060 | STRING | 3 | ExchangeAlgorithm | |
| PR02061 | INTEGER | 2 | CurrencyCode | |
| PR02062 | STRING | 35 | StockCode | |
| PR02063 | STRING | 10 | Workorder |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Project Management (Управление Проектами) | Project Activities (Вид деятельности по Проекту)
/* */