Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: OR21 - «HI. Order Lines» («ИСТ.Строки Заказа»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| OR21001 | STRING | 10 | OrderNo | Да |
| OR21002 | STRING | 6 | LineNo | Да |
| OR21003 | STRING | 3 | StrucLineNo | Да |
| OR21004 | INTEGER | 1 | LineType | |
| OR21005 | VSTRING | 35 | StockCode | |
| OR21006 | VSTRING | 25 | DescripLine1 | |
| OR21007 | VSTRING | 25 | DescripLine2 | |
| OR21008 | MONEY | 20 | UnitPrice | |
| OR21009 | MONEY | 20 | UnitCostPric | |
| OR21010 | INTEGER | 2 | UnitCode | |
| OR21011 | X_NUMERIC | 12 | QtyOrdered | |
| OR21012 | X_NUMERIC | 12 | QtyShipped | |
| OR21013 | VSTRING | 1 | Spare | |
| OR21014 | INTEGER | 2 | AccountCode | |
| OR21015 | SWITCH | 1 | BackOrdrFlag | |
| OR21016 | INTEGER | 1 | LinePrntFlag | |
| OR21017 | VSTRING | 6 | VolDiscount | |
| OR21018 | VSTRING | 6 | CustDiscount | |
| OR21019 | DATE | 8 | DeliveryDate | |
| OR21020 | X_NUMERIC | 10 | QtyUnInDeliv | |
| OR21021 | X_NUMERIC | 10 | QtyUnOutDeli | |
| OR21022 | X_NUMERIC | 10 | SellPrMultip | |
| OR21023 | X_NUMERIC | 10 | CostPrMultip | |
| OR21024 | X_NUMERIC | 20 | CurrExchRate | |
| OR21025 | INTEGER | 1 | ExtraTaxCode | |
| OR21026 | INTEGER | 1 | DistCostCode | |
| OR21027 | INTEGER | 1 | RepOrPrcCode | |
| OR21028 | ACCSTR | 50 | AccounString | |
| OR21029 | INTEGER | 1 | FLAGDeliStat | |
| OR21030 | INTEGER | 1 | FLAGInvStat | |
| OR21031 | INTEGER | 1 | StockStatus | |
| OR21032 | BINSTRING | 1 | ShipmRoule | |
| OR21033 | X_NUMERIC | 12 | QyAllocated | |
| OR21034 | SWITCH | 1 | FLAGHasSubIt | |
| OR21035 | VSTRING | 8 | Spare | |
| OR21036 | MONEY | 20 | Spare | |
| OR21037 | DATE | 8 | DelivDateReq | |
| OR21038 | SWITCH | 1 | FLAGCurrComp | |
| OR21039 | VSTRING | 2 | CompensCurr | |
| OR21040 | MONEY | 20 | OrDateExch | |
| OR21041 | VSTRING | 20 | OR2141SPARE | |
| OR21042 | DATE | 8 | DelivDatBkOr | |
| OR21043 | X_NUMERIC | 10 | NetWeight | |
| OR21044 | X_NUMERIC | 10 | GrossWeight | |
| OR21045 | X_NUMERIC | 10 | Volume | |
| OR21046 | VSTRING | 6 | WarehouseID | |
| OR21047 | MONEY | 20 | StatistPrice | |
| OR21048 | X_NUMERIC | 6 | StatiDiscou | |
| OR21049 | MONEY | 20 | StatCostPrc | |
| OR21050 | X_NUMERIC | 12 | QtyOriginal | |
| OR21051 | VSTRING | 6 | Spare | |
| OR21052 | VSTRING | 5 | Spare | |
| OR21053 | VSTRING | 12 | Spare | |
| OR21054 | VSTRING | 12 | Spare | |
| OR21055 | SWITCH | 1 | FLAGStatNot | |
| OR21056 | VSTRING | 12 | Spare | |
| OR21057 | X_NUMERIC | 10 | UnitConvFact | |
| OR21058 | X_NUMERIC | 4 | CusDisCalIt1 | |
| OR21059 | X_NUMERIC | 4 | CusDisCalIt2 | |
| OR21060 | X_NUMERIC | 4 | CusDisCalIt3 | |
| OR21061 | INTEGER | 2 | VATCode1099 | |
| OR21062 | INTEGER | 2 | VATCode2099 | |
| OR21063 | MONEY | 20 | OrigDefaPri | |
| OR21064 | VSTRING | 6 | OriDefCusCod | |
| OR21065 | STRING | 6 | InvoiceNo | Да |
| OR21066 | STRING | 10 | SuborderNo | |
| OR21067 | STRING | 10 | PurchaseOrNo | |
| OR21068 | STRING | 9 | PurchaLineNo | |
| OR21069 | VSTRING | 1 | PurcStatFlag | |
| OR21070 | STRING | 1 | Status1 | |
| OR21071 | STRING | 1 | Status2 | |
| OR21072 | STRING | 1 | Status3 | |
| OR21073 | STRING | 1 | SubType | |
| OR21074 | VSTRING | 27 | Contract | |
| OR21075 | VSTRING | 35 | SearchField | |
| OR21076 | NUMBER | 10 | PickingList | |
| OR21077 | X_NUMERIC | 10 | Curexrate2 | |
| OR21078 | STRING | 3 | Curexalgm | |
| OR21079 | X_NUMERIC | 10 | Orddtexrate2 | |
| OR21080 | STRING | 3 | Orddtexalgm | |
| OR21081 | X_NUMERIC | 10 | Deldtexrate2 | |
| OR21082 | STRING | 3 | Deldtexalgm | |
| OR21083 | INTEGER | 2 | Currcode | |
| OR21084 | SWITCH | 1 | Ediswitch | |
| OR21085 | INTEGER | 2 | OrigPriceCurCode | |
| OR21086 | MONEY | 20 | OrigUnitPrice | |
| OR21087 | VSTRING | 11 | PriceDiscountHistory | |
| OR21088 | MONEY | 20 | CostPriceCC | |
| OR21089 | STRING | 25 | SiteCode | |
| OR21090 | DATE | 8 | TargetDate |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Sales Order (Заказ на Продажу) | HI. Order Lines (ИСТ.Строки Заказа)
/* */