Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: PC03 - «Purchase Order Lines» («Строки Заказов на Зак.»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| PC03001 | STRING | 10 | PurchaOrdNo | Да |
| PC03002 | STRING | 6 | LineNumber | Да |
| PC03003 | STRING | 3 | StructLineNo | Да |
| PC03004 | INTEGER | 1 | LineType | |
| PC03005 | VSTRING | 35 | StockCode | |
| PC03006 | VSTRING | 25 | DescriptLine1 | |
| PC03007 | VSTRING | 25 | DescriptLine2 | |
| PC03008 | MONEY | 20 | UnitPrice | |
| PC03009 | INTEGER | 2 | UnitCode | |
| PC03010 | X_NUMERIC | 12 | PCQtyOrdered | |
| PC03011 | X_NUMERIC | 12 | PCQtyReceive | |
| PC03012 | X_NUMERIC | 12 | PCQtyInvoice | |
| PC03013 | STRING | 2 | AccountCode | |
| PC03014 | SWITCH | 1 | FLAGBackOrd | |
| PC03015 | X_NUMERIC | 6 | Discount | |
| PC03016 | DATE | 8 | DelDateCommi | |
| PC03017 | DATE | 8 | DelDateActua | |
| PC03018 | X_NUMERIC | 10 | QtyUnitInDel | |
| PC03019 | X_NUMERIC | 10 | CostPrcMult | |
| PC03020 | VSTRING | 3 | SPARE | |
| PC03021 | INTEGER | 1 | TransactSour | |
| PC03022 | VSTRING | 1 | SPARE | |
| PC03023 | INTEGER | 1 | StockStatus | |
| PC03024 | DATE | 8 | BatchCreatDt | |
| PC03025 | X_NUMERIC | 20 | DelExchRate | |
| PC03026 | VSTRING | 1 | Spare | |
| PC03027 | STRING | 1 | FLAGNewOrLin | |
| PC03028 | VSTRING | 1 | UserOption2 | |
| PC03029 | VSTRING | 1 | UserOption3 | |
| PC03030 | DATE | 8 | DelDateReque | |
| PC03031 | DATE | 8 | DelDatBackOr | |
| PC03032 | X_NUMERIC | 10 | NetWeight | |
| PC03033 | X_NUMERIC | 10 | GrossWeight | |
| PC03034 | X_NUMERIC | 10 | Volume | |
| PC03035 | VSTRING | 6 | WarehouseID | |
| PC03036 | VSTRING | 50 | AccounString | |
| PC03037 | VSTRING | 12 | ProjectRefer | |
| PC03038 | X_NUMERIC | 12 | QtyRecDispNt | |
| PC03039 | VSTRING | 10 | OrReference | |
| PC03040 | VSTRING | 9 | SPARE3 | |
| PC03041 | VSTRING | 12 | DelivBatchNo | |
| PC03042 | X_NUMERIC | 10 | UnConvForPur | |
| PC03043 | X_NUMERIC | 12 | DeliverQtySC | |
| PC03044 | X_NUMERIC | 12 | OrdQtySCunit | |
| PC03045 | STRING | 14 | OrdLineRefer | |
| PC03046 | X_NUMERIC | 12 | RemainQtySC | |
| PC03047 | X_NUMERIC | 12 | RemainQtyPC | |
| PC03048 | STRING | 1 | SubType | |
| PC03049 | X_NUMERIC | 12 | QCQuantity | |
| PC03050 | STRING | 1 | StatusQC | |
| PC03051 | VSTRING | 27 | Contract | |
| PC03052 | STRING | 3 | Spare1 | |
| PC03053 | STRING | 3 | Spare2 | |
| PC03054 | X_NUMERIC | 10 | DelExchRate2 | |
| PC03055 | STRING | 3 | DelExchRateAlg | |
| PC03056 | INTEGER | 2 | CurrencyCode | |
| PC03057 | STRING | 1 | OverDeliveryControl | |
| PC03058 | X_NUMERIC | 6 | OverDeliveryPerc | |
| PC03059 | X_NUMERIC | 12 | OverDeliveryQTY | |
| PC03060 | SWITCH | 1 | EDIContractSwitch | |
| PC03061 | INTEGER | 2 | OrigPriceCurCode | |
| PC03062 | MONEY | 20 | OrigUnitPrice | |
| PC03063 | STRING | 20 | SupplierOrderNumber | |
| PC03064 | STRING | 20 | SupplierOrderLineRef | |
| PC03065 | STRING | 6 | OurOrderLineRef | |
| PC03066 | X_NUMERIC | 12 | PCQtyPrev |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Purchase Order (Заказ на Закупку) | Purchase Order Lines (Строки Заказов на Зак.)
/* */