Таблица: PR44 - «Material Specification» («Спецификация Материалов»)
Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
PR44001 | VSTRING | 12 | ProjectNo | Да |
PR44002 | VSTRING | 6 | Sub_Project | Да |
PR44003 | VSTRING | 6 | ActivityLine | Да |
PR44004 | VSTRING | 3 | ActivStrLine | Да |
PR44005 | DATE | 8 | TransactDate | Да |
PR44006 | VSTRING | 10 | ResourceCode | Да |
PR44007 | VSTRING | 3 | TransactLine | Да |
PR44008 | VSTRING | 6 | DelivTransLn | Да |
PR44009 | VSTRING | 2 | StoItemAcCod | |
PR44010 | ACCSTR | 50 | AccounString | |
PR44011 | VSTRING | 35 | StockItem | |
PR44012 | VSTRING | 12 | BatchNoDeliv | |
PR44013 | VSTRING | 10 | Order_Number | |
PR44014 | VSTRING | 6 | Line_Number | |
PR44015 | VSTRING | 3 | StructLineNo | |
PR44016 | VSTRING | 4 | AutSubStrLNo | |
PR44017 | X_NUMERIC | 12 | QtyOrdered | |
PR44018 | X_NUMERIC | 12 | QtyDelivered | |
PR44019 | X_NUMERIC | 12 | QtyOrdered | |
PR44020 | X_NUMERIC | 12 | QtyDelivered | |
PR44021 | VSTRING | 12 | Spare | |
PR44022 | VSTRING | 12 | Spare | |
PR44023 | MONEY | 20 | PrUnitDisc | |
PR44024 | MONEY | 20 | PrUnitDisc | |
PR44025 | MONEY | 20 | PrUnitDisc | |
PR44026 | MONEY | 20 | PrUnitDisc | |
PR44027 | X_NUMERIC | 20 | DelivDaExRat | |
PR44028 | MONEY | 20 | CostUnit | |
PR44029 | DATE | 8 | DeliDateRequ | |
PR44030 | DATE | 8 | DeliDateComm | |
PR44031 | DATE | 8 | DeliDateActu | |
PR44032 | VSTRING | 10 | DeliNoteNo | |
PR44033 | VSTRING | 1 | DelivNotePrn | |
PR44034 | VSTRING | 1 | PickListPrin | |
PR44035 | VSTRING | 1 | DeliPropPrin | |
PR44036 | X_NUMERIC | 10 | NetWeight | |
PR44037 | X_NUMERIC | 10 | GrossWeight | |
PR44038 | X_NUMERIC | 10 | Volume | |
PR44039 | VSTRING | 10 | PickListNo | |
PR44040 | VSTRING | 10 | DelivPropNo | |
PR44041 | MONEY | 20 | ConsCostType | |
PR44042 | VSTRING | 2 | VAT_Code | |
PR44043 | VSTRING | 6 | Warehouse | |
PR44044 | X_NUMERIC | 6 | LineDiscount | |
PR44045 | X_NUMERIC | 6 | OrdDiscount |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Project Management (Управление Проектами) | Material Specification (Спецификация Материалов)