Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: OR20 - «HI. Order Head» («ИСТ.Заголовок Заказа»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| OR20001 | STRING | 10 | OrderNo | Да |
| OR20002 | INTEGER | 1 | OrderType | |
| OR20003 | STRING | 10 | CustCodeInv | |
| OR20004 | STRING | 10 | CustCodDeliv | |
| OR20005 | VSTRING | 35 | AddressText1 | |
| OR20006 | VSTRING | 35 | AddressText2 | |
| OR20007 | INTEGER | 1 | FLAGOrderAck | |
| OR20008 | INTEGER | 1 | FLAGPickList | |
| OR20009 | INTEGER | 1 | FLAGDispNote | |
| OR20010 | INTEGER | 1 | FLAGInv | |
| OR20011 | SWITCH | 1 | FLAGProcStru | |
| OR20012 | VSTRING | 2 | TermsOfPaym | |
| OR20013 | VSTRING | 2 | TermsOfDeliv | |
| OR20014 | VSTRING | 2 | WayOfDeliv | |
| OR20015 | DATE | 8 | OrderDate | |
| OR20016 | DATE | 8 | DeliveryDate | |
| OR20017 | VSTRING | 35 | OurReference | |
| OR20018 | VSTRING | 35 | YourReferenc | |
| OR20019 | VSTRING | 3 | SalesmanNo | |
| OR20020 | VSTRING | 6 | OrDiscount | |
| OR20021 | STRING | 6 | InvoiceNo | Да |
| OR20022 | DATE | 8 | InvDaQuotDa | |
| OR20023 | VSTRING | 6 | DispatNotNo | |
| OR20024 | MONEY | 20 | OrderValue | |
| OR20025 | ACCSTR | 50 | AccingString | |
| OR20026 | INTEGER | 1 | OrMergeOptio | |
| OR20027 | INTEGER | 1 | LanguageCode | |
| OR20028 | INTEGER | 2 | CurrencyCode | |
| OR20029 | SWITCH | 1 | FLAGExportOr | |
| OR20030 | INTEGER | 1 | FLAGExporDoc | |
| OR20031 | INTEGER | 1 | FLAGTrnspDoc | |
| OR20032 | SWITCH | 1 | FLAGCurrComp | |
| OR20033 | INTEGER | 2 | CompensCurr | |
| OR20034 | X_NUMERIC | 6 | LimitCompens | |
| OR20035 | X_NUMERIC | 6 | Compensation | |
| OR20036 | X_NUMERIC | 20 | OrderDExRate | |
| OR20037 | X_NUMERIC | 20 | DelivDateExc | |
| OR20038 | STRING | 4 | OrRepeatIntr | |
| OR20039 | DATE | 8 | RepOrStartDa | |
| OR20040 | DATE | 8 | RepOrStopDa | |
| OR20041 | MONEY | 20 | ROrAccInvAmt | |
| OR20042 | MONEY | 20 | ROrAccCost | |
| OR20043 | MONEY | 20 | HandlingFee | |
| OR20044 | MONEY | 20 | FreightAmont | |
| OR20045 | VSTRING | 10 | CustCodeOrd | |
| OR20046 | MONEY | 20 | Packing | |
| OR20047 | INTEGER | 1 | FLAGDeliProp | |
| OR20048 | MONEY | 20 | Insurance | |
| OR20049 | VSTRING | 1 | Spare | |
| OR20050 | VSTRING | 6 | WareHouse | |
| OR20051 | VSTRING | 2 | PriceList | |
| OR20052 | SWITCH | 1 | FLAGUpdIntra | |
| OR20053 | VSTRING | 1 | Spare | |
| OR20054 | VSTRING | 1 | PrTypeOnRepe | |
| OR20055 | VSTRING | 1 | FLAGTaxInvoice | |
| OR20056 | VSTRING | 35 | ShipmentMark | |
| OR20057 | X_NUMERIC | 10 | NetWeight | |
| OR20058 | X_NUMERIC | 10 | GrossWeight | |
| OR20059 | X_NUMERIC | 10 | Volume | |
| OR20060 | X_NUMERIC | 10 | NoOfUnits | |
| OR20061 | X_NUMERIC | 6 | ExternCommis | |
| OR20062 | VSTRING | 10 | ExtCommCode | |
| OR20063 | MONEY | 20 | OwnFreight | |
| OR20064 | MONEY | 20 | CommBaseOrd | |
| OR20065 | INTEGER | 1 | DocLayout | |
| OR20066 | SWITCH | 1 | CurrContract | |
| OR20067 | X_NUMERIC | 20 | FixedExcRate | |
| OR20068 | VSTRING | 15 | ContractNo | |
| OR20069 | VSTRING | 8 | CampaignCode | |
| OR20070 | VSTRING | 15 | ExtDeliNotNo | |
| OR20071 | INTEGER | 1 | InvRoundMod | |
| OR20072 | VSTRING | 20 | CustPONo | |
| OR20073 | SWITCH | 1 | LetterOfCred | |
| OR20074 | DATE | 8 | LCOpenDate | |
| OR20075 | DATE | 8 | LCDueDate | |
| OR20076 | VSTRING | 20 | LCReference | |
| OR20077 | DATE | 8 | BookEntrDate | |
| OR20078 | VSTRING | 6 | CommonWHouNo | |
| OR20079 | SWITCH | 1 | PartDelivCod | |
| OR20080 | INTEGER | 2 | EDITransmCou | |
| OR20081 | INTEGER | 2 | EDIReceCount | |
| OR20082 | VSTRING | 1 | EDIFlag1 | |
| OR20083 | VSTRING | 1 | EDIFlag2 | |
| OR20084 | VSTRING | 1 | EDIFlag3 | |
| OR20085 | VSTRING | 1 | EDIFlag4 | |
| OR20086 | VSTRING | 3 | SalesmanNo2 | |
| OR20087 | VSTRING | 3 | SalesmanNo3 | |
| OR20088 | VSTRING | 1 | OR2088SPARE | |
| OR20089 | VSTRING | 4 | SaleTaxRemar | |
| OR20090 | VSTRING | 4 | Forwarder | |
| OR20091 | INTEGER | 1 | OrderStatus | |
| OR20092 | INTEGER | 2 | VATCodFreigh | |
| OR20093 | INTEGER | 2 | VATCodePack | |
| OR20094 | INTEGER | 2 | VATCodeInsur | |
| OR20095 | VSTRING | 2 | OverrideSTax | |
| OR20096 | VSTRING | 8 | UserIdEntry | |
| OR20097 | DATE | 8 | DueDate | |
| OR20098 | VSTRING | 10 | SuborContrNo | |
| OR20099 | VSTRING | 10 | SuborderNo | |
| OR20100 | INTEGER | 1 | OrCreatModul | |
| OR20101 | VSTRING | 30 | OrigModulLiD | |
| OR20102 | INTEGER | 1 | OrigModuStat | |
| OR20103 | VSTRING | 27 | Contract | |
| OR20104 | STRING | 1 | VATFlag | |
| OR20105 | STRING | 3 | OrderHandler | |
| OR20106 | SWITCH | 1 | IntereBlock | |
| OR20107 | VSTRING | 6 | InterLatePay | |
| OR20108 | ACCSTR | 50 | INTRDeSdAcSt | |
| OR20109 | VSTRING | 4 | InvPrefix | |
| OR20110 | X_NUMERIC | 10 | Odexrate2 | |
| OR20111 | STRING | 3 | Odexalgm | |
| OR20112 | X_NUMERIC | 10 | Deldtexrate2 | |
| OR20113 | STRING | 3 | Deldtexalgm | |
| OR20114 | X_NUMERIC | 10 | Fixexrate2 | |
| OR20115 | STRING | 3 | Fixexalgm | |
| OR20116 | INTEGER | 2 | Invcurcode | |
| OR20117 | SWITCH | 1 | Ediswitch | |
| OR20118 | INTEGER | 2 | VATCodeInvFee | |
| OR20119 | X_NUMERIC | 10 | InvCurrExchRate1 | |
| OR20120 | X_NUMERIC | 10 | InvCurrExchRate2 | |
| OR20121 | STRING | 3 | InvCurrExchAlg | |
| OR20122 | INTEGER | 1 | InclInStat | |
| OR20123 | MONEY | 20 | AllowAmICU | |
| OR20124 | STRING | 2 | AllowTaxRate | |
| OR20125 | MONEY | 20 | SurchargeAmICU | |
| OR20126 | STRING | 2 | SurchargeTaxRate | |
| OR20127 | MONEY | 20 | AdvanceAmount | |
| OR20128 | SWITCH | 1 | ExternalControl | |
| OR20129 | INTEGER | 1 | FLAGOrAcknXML | |
| OR20130 | INTEGER | 1 | FLAGPickListXML | |
| OR20131 | INTEGER | 1 | FLAGDispNoteXML | |
| OR20132 | INTEGER | 1 | FLAGInvoiceXML | |
| OR20133 | INTEGER | 1 | FLAGExportORXML | |
| OR20134 | INTEGER | 1 | FLAGExpDocXML | |
| OR20135 | INTEGER | 1 | DeliPropFlagXML | |
| OR20136 | INTEGER | 1 | FLAGTaxInvoiceXML | |
| OR20137 | INTEGER | 12 | ProjectNumber | |
| OR20138 | STRING | 25 | SiteCode | |
| OR20139 | STRING | 6 | OriginalInvoiceNo | |
| OR20140 | STRING | 10 | OriginalOrderNo |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Sales Order (Заказ на Продажу) | HI. Order Head (ИСТ.Заголовок Заказа)
/* */