Таблица: PR03 - «Project Act. Transactions» («Проект, Проводки по Работам»)
Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
PR03001 | VSTRING | 12 | ProjectNo | Да |
PR03002 | VSTRING | 6 | SubProject | Да |
PR03003 | VSTRING | 6 | ActivityLine | Да |
PR03004 | VSTRING | 3 | ActStrucLine | Да |
PR03005 | DATE | 8 | TransactDate | Да |
PR03006 | VSTRING | 10 | ResourceCode | Да |
PR03007 | VSTRING | 3 | TransactLine | Да |
PR03008 | X_NUMERIC | 12 | HoursQty | |
PR03009 | X_NUMERIC | 12 | HoursQtyInv | |
PR03010 | MONEY | 20 | Price | |
PR03011 | MONEY | 20 | PriceToInvoi | |
PR03012 | MONEY | 20 | CostLCU | |
PR03013 | VSTRING | 35 | Description | |
PR03014 | VSTRING | 1 | ChargeCode | |
PR03015 | VSTRING | 20 | Spare | |
PR03016 | MONEY | 20 | ActInvAmount | |
PR03017 | VSTRING | 1 | InvoiceFlag | |
PR03018 | MONEY | 20 | ActInvPrice | |
PR03019 | MONEY | 20 | WIPTransLCU | |
PR03020 | ACCSTR | 50 | AccounString | |
PR03021 | X_NUMERIC | 12 | ActuaInvHour | |
PR03022 | VSTRING | 20 | Spare | |
PR03023 | VSTRING | 20 | Spare | |
PR03024 | VSTRING | 1 | ActivityType | |
PR03025 | VSTRING | 2 | VATCode | |
PR03026 | X_NUMERIC | 6 | Markup | |
PR03027 | VSTRING | 10 | SupplCode | |
PR03028 | VSTRING | 1 | InvLinLayout | |
PR03029 | VSTRING | 6 | LinkActiLine | |
PR03030 | VSTRING | 3 | LinActStrLin | |
PR03031 | VSTRING | 6 | VoucherNo | |
PR03032 | VSTRING | 2 | CurrencyCode | |
PR03033 | DATE | 8 | WIPBEDate | |
PR03034 | VSTRING | 10 | EnterByUser | |
PR03035 | VSTRING | 10 | ConfirByUser | |
PR03036 | VSTRING | 1 | DateType012 | |
PR03037 | VSTRING | 6 | WIPTransacNo | |
PR03038 | MONEY | 20 | WIPAmtMarkup | |
PR03039 | VSTRING | 1 | WIPStatus | |
PR03040 | X_NUMERIC | 6 | PercentCompl | |
PR03041 | VSTRING | 1 | IntDebUpdate | |
PR03042 | DATE | 8 | WIPReturnDate | |
PR03043 | STRING | 6 | WIPTreturnTranNo | |
PR03044 | STRING | 8 | ReservedForCredit | |
PR03045 | STRING | 1 | SpareFlag1 | |
PR03046 | STRING | 1 | SpareFlag2 |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Project Management (Управление Проектами) | Project Act. Transactions (Проект, Проводки по Работам)