Таблица: PR01 - «Project File» («Файл Проектов»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| PR01001 | VSTRING | 12 | ProjectNo | Да |
| PR01002 | VSTRING | 12 | MainProjeNo | |
| PR01003 | VSTRING | 10 | CustCodeInv | |
| PR01004 | VSTRING | 35 | ExtrInfLine1 | |
| PR01005 | VSTRING | 35 | ExtrInfLine2 | |
| PR01006 | VSTRING | 35 | ExtrInfLine3 | |
| PR01007 | VSTRING | 35 | ExtrInfLine4 | |
| PR01008 | VSTRING | 35 | CustReferen | |
| PR01009 | VSTRING | 25 | ObjProjName | |
| PR01010 | VSTRING | 35 | Description1 | |
| PR01011 | VSTRING | 35 | Description2 | |
| PR01012 | VSTRING | 35 | OurReference | |
| PR01013 | VSTRING | 2 | AutoProjStat | |
| PR01014 | VSTRING | 2 | ProjectType | |
| PR01015 | ACCSTR | 50 | AccounString | |
| PR01016 | VSTRING | 3 | Salesman | |
| PR01017 | VSTRING | 1 | PrcModelInv | |
| PR01018 | VSTRING | 1 | TpWIPCostAc | |
| PR01019 | VSTRING | 2 | TermsOfPaym | |
| PR01020 | VSTRING | 2 | CurrencyCode | |
| PR01021 | VSTRING | 1 | LanguageCode | |
| PR01022 | VSTRING | 2 | Pricelist | |
| PR01023 | VSTRING | 1 | TaxliabHours | |
| PR01024 | VSTRING | 1 | TaxliablCost | |
| PR01025 | VSTRING | 1 | ProjectStat | |
| PR01026 | VSTRING | 1 | TpWIPCostAc | |
| PR01027 | VSTRING | 1 | TpWIPCostAc | |
| PR01028 | MONEY | 20 | FixedPrice | |
| PR01029 | MONEY | 20 | CeilingPrice | |
| PR01030 | VSTRING | 10 | Manager | |
| PR01031 | VSTRING | 20 | UserDefined1 | |
| PR01032 | VSTRING | 10 | UserDefined2 | |
| PR01033 | VSTRING | 10 | UserDefined3 | |
| PR01034 | VSTRING | 8 | UserDefined4 | |
| PR01035 | VSTRING | 8 | UserDefined5 | |
| PR01036 | VSTRING | 4 | UserDefined6 | |
| PR01037 | VSTRING | 4 | UserDefined7 | |
| PR01038 | VSTRING | 2 | UserDefined8 | |
| PR01039 | VSTRING | 2 | UserDefined9 | |
| PR01040 | VSTRING | 1 | UserDefine10 | |
| PR01041 | VSTRING | 4 | ProjCategory | |
| PR01042 | DATE | 8 | ActStartDate | |
| PR01043 | VSTRING | 8 | EnterByUser | |
| PR01044 | DATE | 8 | EnteredDate | |
| PR01045 | VSTRING | 20 | Spare | |
| PR01046 | VSTRING | 43 | Spare | |
| PR01047 | VSTRING | 6 | Spare | |
| PR01048 | VSTRING | 6 | Spare | |
| PR01049 | VSTRING | 6 | Spare | |
| PR01050 | VSTRING | 1 | MatHandAllow | |
| PR01051 | VSTRING | 1 | FlagInvProp | |
| PR01052 | VSTRING | 1 | MultAlloProj | |
| PR01053 | VSTRING | 2 | ProjAccCode | |
| PR01054 | VSTRING | 2 | CustAccCode | |
| PR01055 | VSTRING | 2 | VATCodStdPro | |
| PR01056 | VSTRING | 2 | VATcodFxPrIn | |
| PR01057 | VSTRING | 54 | PR0157SPARE | |
| PR01058 | MONEY | 20 | WIPrecogCost | |
| PR01059 | MONEY | 20 | WIPrecoReven | |
| PR01060 | VSTRING | 20 | WIPrecoReven | |
| PR01061 | VSTRING | 20 | WIPrecoReven | |
| PR01062 | VSTRING | 20 | CommitedCost | |
| PR01063 | DATE | 8 | LastInvDate | |
| PR01064 | VSTRING | 10 | LastInvNo | |
| PR01065 | VSTRING | 10 | CustCodeOrd | |
| PR01066 | DATE | 8 | QuotatDate | |
| PR01067 | DATE | 8 | EstStartDate | |
| PR01068 | DATE | 8 | LatestInvDat | |
| PR01069 | DATE | 8 | EstiCompDate | |
| PR01070 | DATE | 8 | DateForClos | |
| PR01071 | DATE | 8 | StarDateWarr | |
| PR01072 | VSTRING | 3 | WarrantyPer | |
| PR01073 | VSTRING | 1 | IndexClause | |
| PR01074 | VSTRING | 1 | InteresBlock | |
| PR01075 | VSTRING | 1 | Spare | |
| PR01076 | VSTRING | 1 | InvPropFlag | |
| PR01077 | VSTRING | 1 | DefOrCouOR | |
| PR01078 | VSTRING | 1 | QuotaPrint | |
| PR01079 | VSTRING | 2 | ProjTempIDUs | |
| PR01080 | VSTRING | 2 | CurrBasBdgID | |
| PR01081 | VSTRING | 18 | InvOnSubProjectLevl | |
| PR01082 | VSTRING | 1 | QuotatFlag | |
| PR01083 | VSTRING | 8 | UserGroup | |
| PR01084 | VSTRING | 10 | CustCodeDeli | |
| PR01085 | VSTRING | 1 | FlagOrdeAck | |
| PR01086 | VSTRING | 1 | FlagPickList | |
| PR01087 | VSTRING | 1 | FlagDipaNote | |
| PR01088 | VSTRING | 1 | FlagInvoice | |
| PR01089 | VSTRING | 1 | ProcStruOrd | |
| PR01090 | VSTRING | 2 | TermsOfDeliv | |
| PR01091 | VSTRING | 2 | WayOfDeliv | |
| PR01092 | MONEY | 20 | HandlingFee | |
| PR01093 | VSTRING | 20 | FreightAmoun | |
| PR01094 | VSTRING | 2 | VATCodeFreig | |
| PR01095 | VSTRING | 20 | Packing | |
| PR01096 | VSTRING | 10 | VATCodePack | |
| PR01097 | DATE | 8 | Insurance | |
| PR01098 | X_NUMERIC | 6 | VATCodeInsur | |
| PR01099 | X_NUMERIC | 6 | Warehouse | |
| PR01100 | VSTRING | 2 | PriceList | |
| PR01101 | VSTRING | 1 | DocumLayout | |
| PR01102 | VSTRING | 1 | CurrContract | |
| PR01103 | X_NUMERIC | 20 | FixeExchRate | |
| PR01104 | VSTRING | 15 | ContractNo | |
| PR01105 | VSTRING | 15 | PurchaseOrderCount | |
| PR01106 | VSTRING | 20 | CustomPONo | |
| PR01107 | DATE | 8 | BookEntrDate | |
| PR01108 | VSTRING | 1 | InvMergeOpt | |
| PR01109 | DATE | 8 | InteresBlock | |
| PR01110 | VSTRING | 8 | InterLatePay | |
| PR01111 | DATE | 8 | DateConvQuo | |
| PR01112 | VSTRING | 8 | ConvByUser | |
| PR01113 | X_NUMERIC | 10 | FixedExchangeRate2 | |
| PR01114 | STRING | 3 | FixedXchgRateAlgorit | |
| PR01115 | INTEGER | 2 | invoiceCurrencyCode |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Project Management (Управление Проектами) | Project File (Файл Проектов)
/* */