Таблица: PR34 - «Project Budget File» («Проект, Файл Сметы»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| PR34001 | VSTRING | 12 | ProjectNo | Да |
| PR34002 | VSTRING | 6 | SubProject | Да |
| PR34003 | VSTRING | 6 | ActivityLine | Да |
| PR34004 | VSTRING | 3 | ActiStruLine | Да |
| PR34005 | VSTRING | 2 | BudgForecID | Да |
| PR34006 | VSTRING | 4 | BudgYear | Да |
| PR34007 | VSTRING | 25 | Description | |
| PR34008 | VSTRING | 4 | GL_BE_Year | |
| PR34009 | VSTRING | 1 | GLBudgAltern | |
| PR34010 | VSTRING | 1 | GLBudgUpdate | |
| PR34011 | VSTRING | 1 | BudUpdFrolow | |
| PR34012 | VSTRING | 8 | EnterByUser | |
| PR34013 | DATE | 8 | DateEntered | |
| PR34014 | VSTRING | 1 | BudgetLocked | |
| PR34015 | DATE | 8 | BudgLockDate | |
| PR34016 | VSTRING | 8 | BudgLockbyus | |
| PR34017 | INTEGER | 2 | NoOfPeriods | |
| PR34018 | VSTRING | 1 | BudgSpliYear | |
| PR34019 | VSTRING | 8 | Spare | |
| PR34020 | VSTRING | 1 | BudSplIntPer | |
| PR34021 | VSTRING | 8 | Spare | |
| PR34022 | X_NUMERIC | 12 | OBQtyHours | |
| PR34023 | MONEY | 20 | CostUnitOB | |
| PR34024 | MONEY | 20 | PricUnLCUOB | |
| PR34025 | MONEY | 20 | PricUnPCUOB | |
| PR34026 | X_NUMERIC | 12 | Period1QtyHr | |
| PR34027 | MONEY | 20 | CostUnitPer1 | |
| PR34028 | MONEY | 20 | PrUnLCUPer1 | |
| PR34029 | MONEY | 20 | PrUnPCUPer1 | |
| PR34030 | X_NUMERIC | 12 | Perio2QtyHrs | |
| PR34031 | MONEY | 20 | CostUnitPer2 | |
| PR34032 | MONEY | 20 | PrUnLCUPer2 | |
| PR34033 | MONEY | 20 | PrUnPCUPer2 | |
| PR34034 | X_NUMERIC | 12 | Perio3QtyHrs | |
| PR34035 | MONEY | 20 | CostUnitPer3 | |
| PR34036 | MONEY | 20 | PrUnLCUPer3 | |
| PR34037 | MONEY | 20 | PrUnPCUPer3 | |
| PR34038 | X_NUMERIC | 12 | Perio4QtyHrs | |
| PR34039 | MONEY | 20 | CostUnitPer4 | |
| PR34040 | MONEY | 20 | PrUnLCUPer4 | |
| PR34041 | MONEY | 20 | PrUnPCUPer4 | |
| PR34042 | X_NUMERIC | 12 | Perio5QtyHrs | |
| PR34043 | MONEY | 20 | CostUnitPer5 | |
| PR34044 | MONEY | 20 | PrUnLCUPer5 | |
| PR34045 | MONEY | 20 | PrUnPCUPer5 | |
| PR34046 | X_NUMERIC | 12 | Perio6QtyHrs | |
| PR34047 | MONEY | 20 | CostUnitPer6 | |
| PR34048 | MONEY | 20 | PrUnLCUPer6 | |
| PR34049 | MONEY | 20 | PrUnPCUPer6 | |
| PR34050 | X_NUMERIC | 12 | Perio7QtyHrs | |
| PR34051 | MONEY | 20 | CostUnitPer7 | |
| PR34052 | MONEY | 20 | PrUnLCUPer7 | |
| PR34053 | MONEY | 20 | PrUnPCUPer7 | |
| PR34054 | X_NUMERIC | 12 | Perio8QtyHrs | |
| PR34055 | MONEY | 20 | CostUnitPer8 | |
| PR34056 | MONEY | 20 | PrUnLCUPer8 | |
| PR34057 | MONEY | 20 | PrUnPCUPer8 | |
| PR34058 | X_NUMERIC | 12 | Perio9QtyHrs | |
| PR34059 | MONEY | 20 | CostUnitPer9 | |
| PR34060 | MONEY | 20 | PrUnLCUPer9 | |
| PR34061 | MONEY | 20 | PrUnPCUPer9 | |
| PR34062 | X_NUMERIC | 12 | Peri10QtyHrs | |
| PR34063 | MONEY | 20 | CostUniPer10 | |
| PR34064 | MONEY | 20 | PrUnLCUPer10 | |
| PR34065 | MONEY | 20 | PrUnPCUPer10 | |
| PR34066 | X_NUMERIC | 12 | Peri11QtyHrs | |
| PR34067 | MONEY | 20 | CostUnPer11 | |
| PR34068 | MONEY | 20 | PrUnLCUPer11 | |
| PR34069 | MONEY | 20 | PrUnPCUPer11 | |
| PR34070 | X_NUMERIC | 12 | Peri12QtyHrs | |
| PR34071 | MONEY | 20 | CostUniPer12 | |
| PR34072 | MONEY | 20 | PrUnLCUPer12 | |
| PR34073 | MONEY | 20 | PrUnPCUPer12 | |
| PR34074 | X_NUMERIC | 12 | Peri13QtyHrs | |
| PR34075 | MONEY | 20 | CostUniPer13 | |
| PR34076 | MONEY | 20 | PrUnLCUPer13 | |
| PR34077 | MONEY | 20 | PrUnPCUPer13 | |
| PR34078 | X_NUMERIC | 12 | Peri14QtyHrs | |
| PR34079 | MONEY | 20 | CostUniPer14 | |
| PR34080 | MONEY | 20 | PrUnLCUPer14 | |
| PR34081 | MONEY | 20 | PrUnPCUPer14 | |
| PR34082 | X_NUMERIC | 12 | Peri15QtyHrs | |
| PR34083 | MONEY | 20 | CostUniPer15 | |
| PR34084 | MONEY | 20 | PrUnLCUPer15 | |
| PR34085 | MONEY | 20 | PrUnPCUPer15 | |
| PR34086 | X_NUMERIC | 12 | Peri16QtyHrs | |
| PR34087 | MONEY | 20 | CostUniPer16 | |
| PR34088 | MONEY | 20 | PrUnLCUPer16 | |
| PR34089 | MONEY | 20 | PrUnPCUPer16 | |
| PR34090 | X_NUMERIC | 12 | Peri17QtyHrs | |
| PR34091 | MONEY | 20 | CostUniPer17 | |
| PR34092 | MONEY | 20 | PrUnLCUPer17 | |
| PR34093 | MONEY | 20 | PrUnPCUPer17 | |
| PR34094 | X_NUMERIC | 12 | Peri18QtyHrs | |
| PR34095 | MONEY | 20 | CostUnitPer18 | |
| PR34096 | MONEY | 20 | PrUnLCUPer18 | |
| PR34097 | MONEY | 20 | PrUnPCUPer18 | |
| PR34098 | X_NUMERIC | 12 | CBQtyHrs | |
| PR34099 | MONEY | 20 | CostUnitCB | |
| PR34100 | MONEY | 20 | PriUniLCUCB | |
| PR34101 | MONEY | 20 | PrUnitPCUCB | |
| PR34102 | X_NUMERIC | 12 | RemainQtyHrs | |
| PR34103 | MONEY | 20 | CostUnitRema | |
| PR34104 | MONEY | 20 | PrUnitLCURem | |
| PR34105 | MONEY | 20 | PrUnitPCURem | |
| PR34106 | VSTRING | 1 | AutUpdCosAct | |
| PR34107 | VSTRING | 1 | AutUpdTimAct | |
| PR34108 | VSTRING | 1 | AutUpdMtrAct | |
| PR34109 | VSTRING | 1 | Spare | |
| PR34110 | VSTRING | 1 | Spare | |
| PR34111 | VSTRING | 1 | Spare | |
| PR34112 | VSTRING | 1 | Spare | |
| PR34113 | VSTRING | 1 | Spare |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Project Management (Управление Проектами) | Project Budget File (Проект, Файл Сметы)
/* */