Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: OR01 - «Order Head» («Заголовок Заказа»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| OR01001 | STRING | 10 | OrderNumber | Да |
| OR01002 | INTEGER | 1 | OrderType | |
| OR01003 | STRING | 10 | CustCodeInv | |
| OR01004 | STRING | 10 | CustCodeDel | |
| OR01005 | VSTRING | 35 | AddressText1 | |
| OR01006 | VSTRING | 35 | AddressText2 | |
| OR01007 | INTEGER | 1 | FLAGOrAckn | |
| OR01008 | INTEGER | 1 | FLAGPickList | |
| OR01009 | INTEGER | 1 | FLAGDispNote | |
| OR01010 | INTEGER | 1 | FLAGInvoice | |
| OR01011 | INTEGER | 1 | FLAGProcStru | |
| OR01012 | INTEGER | 2 | TermsPayment | |
| OR01013 | INTEGER | 2 | TermsofDel | |
| OR01014 | INTEGER | 2 | WayofDel | |
| OR01015 | DATE | 8 | OrderDate | |
| OR01016 | DATE | 8 | DelDate | |
| OR01017 | VSTRING | 35 | OurReferen | |
| OR01018 | VSTRING | 35 | YourReferen | |
| OR01019 | VSTRING | 3 | SalesmanNo | |
| OR01020 | VSTRING | 6 | OrdDiscount | |
| OR01021 | STRING | 6 | InvoiceNo | |
| OR01022 | DATE | 8 | InvoiceQuot | |
| OR01023 | VSTRING | 6 | DispatNoteNo | |
| OR01024 | MONEY | 20 | OrderValue | |
| OR01025 | ACCSTR | 50 | AccCodString | |
| OR01026 | INTEGER | 1 | ORMergeOption | |
| OR01027 | INTEGER | 1 | LanguageCode | |
| OR01028 | INTEGER | 2 | CurrCode | |
| OR01029 | INTEGER | 1 | FLAGExportOR | |
| OR01030 | INTEGER | 1 | FLAGExpDoc | |
| OR01031 | INTEGER | 1 | FLAGTransDoc | |
| OR01032 | INTEGER | 1 | FLAGCurrComp | |
| OR01033 | INTEGER | 2 | CompCurrNo | |
| OR01034 | X_NUMERIC | 6 | LimitCompens | |
| OR01035 | X_NUMERIC | 6 | Compensation | |
| OR01036 | VSTRING | 20 | ORDateExRat | |
| OR01037 | X_NUMERIC | 20 | DelDateExRat | |
| OR01038 | STRING | 4 | OrRepInterva | |
| OR01039 | DATE | 8 | RepOrStartD | |
| OR01040 | DATE | 8 | RepOrStopDa | |
| OR01041 | MONEY | 20 | RepOrAccInv | |
| OR01042 | MONEY | 20 | RepOrdAccum | |
| OR01043 | MONEY | 20 | HandlingFee | |
| OR01044 | MONEY | 20 | FreightAmoun | |
| OR01045 | VSTRING | 10 | CustCodeOrd | |
| OR01046 | MONEY | 20 | Packing | |
| OR01047 | INTEGER | 1 | FLAGDeliProp | |
| OR01048 | MONEY | 20 | Insurance | |
| OR01049 | VSTRING | 1 | StornoInvSw | |
| OR01050 | VSTRING | 6 | WareHouse | |
| OR01051 | VSTRING | 2 | PriceList | |
| OR01052 | SWITCH | 1 | FLAGUpdatInt | |
| OR01053 | VSTRING | 1 | PtOfTitlPass | |
| OR01054 | VSTRING | 1 | PricTypOnRep | |
| OR01055 | VSTRING | 1 | FLAGTaxInvoice | |
| OR01056 | VSTRING | 35 | ShipmentMark | |
| OR01057 | X_NUMERIC | 10 | NetWeight | |
| OR01058 | X_NUMERIC | 10 | GrossWeight | |
| OR01059 | X_NUMERIC | 10 | Volume | |
| OR01060 | X_NUMERIC | 10 | NoOfUnits | |
| OR01061 | X_NUMERIC | 6 | ExternComm1 | |
| OR01062 | VSTRING | 10 | ExternComm2 | |
| OR01063 | MONEY | 20 | OwnFreight | |
| OR01064 | MONEY | 20 | CommBaseOrd | |
| OR01065 | INTEGER | 1 | DocuLayout | |
| OR01066 | SWITCH | 1 | CurrContract | |
| OR01067 | X_NUMERIC | 20 | FixedExchRat | |
| OR01068 | VSTRING | 15 | ContractNo | |
| OR01069 | VSTRING | 8 | CampaignCode | |
| OR01070 | VSTRING | 15 | ExtDelNoteNo | |
| OR01071 | INTEGER | 1 | InvRoundMod | |
| OR01072 | VSTRING | 20 | CustPONo | |
| OR01073 | SWITCH | 1 | LetterOfCred | |
| OR01074 | DATE | 8 | LetterCredOp | |
| OR01075 | DATE | 8 | LetterCredDu | |
| OR01076 | VSTRING | 20 | LetteCredRef | |
| OR01077 | DATE | 8 | BookEntrDate | |
| OR01078 | VSTRING | 6 | CommWarehNo | |
| OR01079 | SWITCH | 1 | PartialDelCd | |
| OR01080 | INTEGER | 2 | EDITrmittCou | |
| OR01081 | INTEGER | 2 | EDIReceivCou | |
| OR01082 | VSTRING | 1 | EDIFlag1 | |
| OR01083 | VSTRING | 1 | EDIFlag2 | |
| OR01084 | VSTRING | 1 | EDIFlag3 | |
| OR01085 | VSTRING | 1 | EDIFlag4 | |
| OR01086 | VSTRING | 3 | SalesmanNo2 | |
| OR01087 | VSTRING | 3 | SalesmanNo3 | |
| OR01088 | VSTRING | 1 | Spare | |
| OR01089 | VSTRING | 4 | SalesTaxRema | |
| OR01090 | VSTRING | 4 | Forwarder | |
| OR01091 | INTEGER | 1 | OrderStatus | |
| OR01092 | INTEGER | 2 | VATCodeFreig | |
| OR01093 | INTEGER | 2 | VATCodePack | |
| OR01094 | INTEGER | 2 | VATCodeInsur | |
| OR01095 | VSTRING | 2 | OvrideSlTaxC | |
| OR01096 | VSTRING | 8 | UserIDEntry | |
| OR01097 | DATE | 8 | DueDate | |
| OR01098 | VSTRING | 10 | SuborContrNo | |
| OR01099 | VSTRING | 10 | SuborderNo | |
| OR01100 | INTEGER | 1 | OrCreatModul | |
| OR01101 | VSTRING | 30 | OrigModLinID | |
| OR01102 | INTEGER | 1 | OrigModStatu | |
| OR01103 | VSTRING | 27 | Contract | |
| OR01104 | STRING | 1 | VATFlag | |
| OR01105 | STRING | 3 | OrdHandler | |
| OR01106 | SWITCH | 1 | IntereBlock | |
| OR01107 | VSTRING | 6 | IntrLatePaym | |
| OR01108 | ACCSTR | 50 | INTRDebit | |
| OR01109 | VSTRING | 4 | InvPrefix | |
| OR01110 | X_NUMERIC | 10 | OrderDateExchgRate1 | |
| OR01111 | STRING | 3 | OrderDateExchgAlgtm | |
| OR01112 | X_NUMERIC | 10 | DlvryDateExchgRate2 | |
| OR01113 | STRING | 3 | DlvryDateExchgAlgtm | |
| OR01114 | X_NUMERIC | 10 | FixedExchgRate2 | |
| OR01115 | STRING | 3 | FixedExchgAlgtm | |
| OR01116 | INTEGER | 2 | InvoiceCurrCode | |
| OR01117 | SWITCH | 1 | EDIContractSwitch | |
| OR01118 | INTEGER | 2 | VATCodeInvFee | |
| OR01119 | X_NUMERIC | 10 | InvCurrExchRate1 | |
| OR01120 | X_NUMERIC | 10 | InvCurrExchRate2 | |
| OR01121 | STRING | 3 | InvCurrExchAlg | |
| OR01122 | INTEGER | 1 | InclInStat | |
| OR01123 | MONEY | 20 | AllowAmICU | |
| OR01124 | STRING | 2 | AllowTaxRate | |
| OR01125 | MONEY | 20 | SurchargeAmICU | |
| OR01126 | STRING | 2 | SurchargeTaxRate | |
| OR01127 | MONEY | 20 | AdvanceAmount | |
| OR01128 | SWITCH | 1 | ExternalControl | |
| OR01129 | INTEGER | 1 | FLAGOrAcknXML | |
| OR01130 | INTEGER | 1 | FLAGPickListXML | |
| OR01131 | INTEGER | 1 | FLAGDispNoteXML | |
| OR01132 | INTEGER | 1 | FLAGInvoiceXML | |
| OR01133 | INTEGER | 1 | FLAGExportORXML | |
| OR01134 | INTEGER | 1 | FLAGExpDocXML | |
| OR01135 | INTEGER | 1 | DeliPropFlagXML | |
| OR01136 | INTEGER | 1 | FLAGTaxInvoiceXML | |
| OR01137 | INTEGER | 12 | ProjectNumber | |
| OR01138 | STRING | 25 | SiteCode | |
| OR01139 | STRING | 6 | OriginalInvoiceNo | |
| OR01140 | STRING | 10 | OriginalOrderNo |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Sales Order (Заказ на Продажу) | Order Head (Заголовок Заказа)
/* */