Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: OR03 - «Order Lines» («Строки Заказа»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| OR03001 | STRING | 10 | OrderNo | Да |
| OR03002 | STRING | 6 | LineNumber | Да |
| OR03003 | STRING | 3 | StructLineNo | Да |
| OR03004 | INTEGER | 1 | LineType | |
| OR03005 | VSTRING | 35 | StockCode | |
| OR03006 | VSTRING | 25 | DescrLine1 | |
| OR03007 | VSTRING | 25 | DescrLine2 | |
| OR03008 | MONEY | 20 | UnitPrice | |
| OR03009 | MONEY | 20 | UnitCostPric | |
| OR03010 | INTEGER | 2 | UnitCode | |
| OR03011 | X_NUMERIC | 12 | ORQtyOrdered | |
| OR03012 | X_NUMERIC | 12 | QtyShipped | |
| OR03013 | INTEGER | 1 | FlagPickList | |
| OR03014 | INTEGER | 2 | AcctingCode | |
| OR03015 | SWITCH | 1 | FLAGBackOrFl | |
| OR03016 | INTEGER | 1 | FLAGLinePrn | |
| OR03017 | VSTRING | 6 | VolDiscount | |
| OR03018 | VSTRING | 6 | CustDiscount | |
| OR03019 | DATE | 8 | DelDateCommi | |
| OR03020 | X_NUMERIC | 10 | QtyUnitInDel | |
| OR03021 | X_NUMERIC | 10 | QtyUniOutDel | |
| OR03022 | X_NUMERIC | 10 | SellPrMultip | |
| OR03023 | X_NUMERIC | 10 | CostPrMultip | |
| OR03024 | X_NUMERIC | 20 | CurrExchRate | |
| OR03025 | INTEGER | 1 | ExtraTaxCode | |
| OR03026 | INTEGER | 1 | DistriCostCo | |
| OR03027 | INTEGER | 1 | ReptOrPriceC | |
| OR03028 | ACCSTR | 50 | AccCodString | |
| OR03029 | INTEGER | 1 | FLAGDelStat | |
| OR03030 | INTEGER | 1 | FLAGInvStat | |
| OR03031 | INTEGER | 1 | StockStatus | |
| OR03032 | BINSTRING | 1 | ShipmentRoul | |
| OR03033 | X_NUMERIC | 12 | QtyAlloc | |
| OR03034 | SWITCH | 1 | HasSubitemin | |
| OR03035 | VSTRING | 8 | Spare | |
| OR03036 | MONEY | 20 | Spare | |
| OR03037 | DATE | 8 | DelDateReque | |
| OR03038 | SWITCH | 1 | FLAGCurrComp | |
| OR03039 | INTEGER | 2 | CompCurrNo | |
| OR03040 | X_NUMERIC | 20 | OrDExchRate | |
| OR03041 | X_NUMERIC | 20 | DelivDExRate | |
| OR03042 | DATE | 8 | DelDBackOrd | |
| OR03043 | X_NUMERIC | 10 | NetWeight | |
| OR03044 | X_NUMERIC | 10 | GrossWeight | |
| OR03045 | X_NUMERIC | 10 | Volume | |
| OR03046 | VSTRING | 6 | WarehouseNo | |
| OR03047 | MONEY | 20 | StatisPrice | |
| OR03048 | X_NUMERIC | 6 | StatisDisco | |
| OR03049 | MONEY | 20 | StatisCost | |
| OR03050 | X_NUMERIC | 12 | QtyOrig | |
| OR03051 | VSTRING | 6 | PickListNo | |
| OR03052 | VSTRING | 5 | Spare | |
| OR03053 | X_NUMERIC | 12 | QtyAllocated | |
| OR03054 | X_NUMERIC | 12 | QtyDelivered | |
| OR03055 | SWITCH | 1 | FLAGStatupda | |
| OR03056 | X_NUMERIC | 12 | QtyReservded | |
| OR03057 | X_NUMERIC | 10 | UnitConvFact | |
| OR03058 | X_NUMERIC | 4 | CustDiscoun1 | |
| OR03059 | X_NUMERIC | 4 | CustDiscoun2 | |
| OR03060 | X_NUMERIC | 4 | CustDiscoun3 | |
| OR03061 | INTEGER | 2 | VATCode1 | |
| OR03062 | INTEGER | 2 | VATCode2 | |
| OR03063 | MONEY | 20 | OrigDefaulPr | |
| OR03064 | X_NUMERIC | 6 | OrigDefaCust | |
| OR03065 | VSTRING | 6 | InvNoDummy | |
| OR03066 | VSTRING | 10 | SuborderNo | |
| OR03067 | VSTRING | 10 | PurchaseOrNo | |
| OR03068 | VSTRING | 9 | PurchaLineNo | |
| OR03069 | INTEGER | 1 | PurcStatFlag | |
| OR03070 | STRING | 1 | Status1 | |
| OR03071 | STRING | 1 | Status2 | |
| OR03072 | STRING | 1 | Status3 | |
| OR03073 | STRING | 1 | SubType | |
| OR03074 | VSTRING | 27 | Contract | |
| OR03075 | VSTRING | 35 | SearchField | |
| OR03076 | NUMBER | 10 | PickingList | |
| OR03077 | X_NUMERIC | 10 | CurrExchgRate2 | |
| OR03078 | STRING | 3 | CurrExchgAlgtm | |
| OR03079 | X_NUMERIC | 10 | OrderDateExchgRate2 | |
| OR03080 | STRING | 3 | OrderDateExchgAlgtm | |
| OR03081 | X_NUMERIC | 10 | DlvryDateExchgRate2 | |
| OR03082 | STRING | 3 | DlvryDateExchgAlgtm | |
| OR03083 | INTEGER | 2 | CurrencyCode | |
| OR03084 | SWITCH | 1 | EDIContractSwitch | |
| OR03085 | INTEGER | 2 | OrigPriceCurCode | |
| OR03086 | MONEY | 20 | OrigUnitPrice | |
| OR03087 | VSTRING | 11 | PriceDiscountHistory | |
| OR03088 | MONEY | 20 | CostPriceCC | |
| OR03089 | STRING | 25 | SiteCode | |
| OR03090 | DATE | 8 | TargetDate |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Sales Order (Заказ на Продажу) | Order Lines (Строки Заказа)
/* */