Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: OR92 - «Freight Document» («Докум. на фрахт»)
Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
OR92001 | STRING | 9 | TransportDocNO | Да |
OR92002 | STRING | 10 | CustomerCodeDelivery | |
OR92003 | STRING | 2 | WayOfDelivery | |
OR92004 | STRING | 10 | OrderNO1 | |
OR92005 | STRING | 10 | OrderNO2 | |
OR92006 | STRING | 10 | OrderNO3 | |
OR92007 | STRING | 10 | OrderNO4 | |
OR92008 | STRING | 10 | OrderNO5 | |
OR92009 | STRING | 10 | OrderNO8 | |
OR92010 | STRING | 10 | OrderNO7 | |
OR92011 | STRING | 10 | OrderNO8 | |
OR92012 | VSTRING | 35 | CustomerName | |
OR92013 | VSTRING | 35 | CustomerAddr1 | |
OR92014 | VSTRING | 35 | CustomerAddr2 | |
OR92015 | VSTRING | 35 | CustomerAddr3 | |
OR92016 | VSTRING | 20 | CustomerPhone | |
OR92017 | STRING | 3 | DestID1 | |
OR92018 | STRING | 2 | DestID2 | |
OR92019 | DATE | 8 | DeliveryDate | |
OR92020 | VSTRING | 15 | Explain4OtherPayway | |
OR92021 | VSTRING | 25 | TransportInfo1 | |
OR92022 | VSTRING | 25 | TransportInfo2 | |
OR92023 | VSTRING | 25 | TransportInfo3 | |
OR92024 | VSTRING | 30 | WayOfDeliveryText | |
OR92025 | STRING | 1 | FreightPayer | |
OR92026 | SWITCH | 1 | LavaOrKontti | |
OR92027 | X_NUMERIC | 3 | LavaOrKonttiQTY | |
OR92028 | VSTRING | 50 | Cash2PayInTextForm | |
OR92029 | NUMBER | 10 | Cah2PayInNumbers | |
OR92030 | VSTRING | 50 | BankAccountInfo | |
OR92031 | STRING | 10 | CustomersContractNO | |
OR92032 | VSTRING | 20 | Mark1 | |
OR92033 | NUMBER | 3 | NOofItems1 | |
OR92034 | STRING | 4 | PackageType1 | |
OR92035 | VSTRING | 25 | Content1 | |
OR92036 | INTEGER | 6 | Code1 | |
OR92037 | NUMBER | 9 | GrossWeight1 | |
OR92038 | VSTRING | 20 | Mark2 | |
OR92039 | NUMBER | 3 | NOofItems2 | |
OR92040 | STRING | 4 | PackageType2 | |
OR92041 | VSTRING | 25 | Content2 | |
OR92042 | INTEGER | 6 | Code2 | |
OR92043 | NUMBER | 9 | GrossWeight2 | |
OR92044 | VSTRING | 20 | Mark3 | |
OR92045 | NUMBER | 3 | NOofItems3 | |
OR92046 | STRING | 4 | PackageType3 | |
OR92047 | VSTRING | 25 | Content3 | |
OR92048 | INTEGER | 6 | Code3 | |
OR92049 | NUMBER | 9 | GrossWeight3 | |
OR92050 | VSTRING | 20 | Mark4 | |
OR92051 | NUMBER | 3 | NOofItems4 | |
OR92052 | STRING | 4 | PackageType4 | |
OR92053 | VSTRING | 25 | Content4 | |
OR92054 | INTEGER | 6 | Code4 | |
OR92055 | NUMBER | 9 | GrossWeight4 | |
OR92056 | VSTRING | 20 | Mark5 | |
OR92057 | NUMBER | 3 | NOofItems5 | |
OR92058 | STRING | 4 | PackageType5 | |
OR92059 | VSTRING | 25 | Content5 | |
OR92060 | INTEGER | 6 | Code5 | |
OR92061 | NUMBER | 9 | GrossWeight5 | |
OR92062 | VSTRING | 20 | Mark6 | |
OR92063 | NUMBER | 3 | NOofItems6 | |
OR92064 | STRING | 4 | PackageType6 | |
OR92065 | VSTRING | 25 | Content6 | |
OR92066 | INTEGER | 6 | Code6 | |
OR92067 | NUMBER | 9 | GrossWeight6 | |
OR92068 | VSTRING | 20 | Mark7 | |
OR92069 | NUMBER | 3 | NOofItems7 | |
OR92070 | STRING | 4 | PackageType7 | |
OR92071 | VSTRING | 25 | Content7 | |
OR92072 | INTEGER | 6 | Code7 | |
OR92073 | NUMBER | 9 | GrossWeight7 | |
OR92074 | VSTRING | 20 | Mark8 | |
OR92075 | NUMBER | 3 | NOofItems8 | |
OR92076 | STRING | 4 | PackageType8 | |
OR92077 | VSTRING | 25 | Content8 | |
OR92078 | INTEGER | 6 | Code8 | |
OR92079 | NUMBER | 9 | GrossWeight8 | |
OR92080 | X_NUMERIC | 5 | TotalLavaQTY4Par1 | |
OR92081 | NUMBER | 10 | TotalGrossWeight | |
OR92082 | STRING | 10 | RouteNO | |
OR92083 | STRING | 10 | OtherContract | |
OR92084 | STRING | 10 | OurCustomerNO | |
OR92085 | STRING | 10 | OurContractNO | |
OR92086 | STRING | 2 | TermsOfDelivery | |
OR92087 | VSTRING | 30 | TermsOfDeliveryText | |
OR92088 | STRING | 10 | OrderNO9 | |
OR92089 | STRING | 10 | OrderNO10 | |
OR92090 | STRING | 10 | OrderNO11 | |
OR92091 | STRING | 10 | OrderNO12 | |
OR92092 | STRING | 10 | OrderNO13 | |
OR92093 | STRING | 10 | OrderNO14 | |
OR92094 | STRING | 10 | OrderNO15 | |
OR92095 | VSTRING | 10 | Volume | |
OR92096 | VSTRING | 35 | spare | |
OR92097 | NUMBER | 2 | TransportForm | |
OR92098 | VSTRING | 2 | CurrCode | |
OR92099 | NUMBER | 1 | AddService1 | |
OR92100 | NUMBER | 1 | AddService2 | |
OR92101 | NUMBER | 1 | AddService3 | |
OR92102 | NUMBER | 1 | AddService4 | |
OR92103 | NUMBER | 11 | ShipmentCode | |
OR92104 | NUMBER | 1 | SpecialTreatment | |
OR92105 | NUMBER | 1 | TransportUnit | |
OR92106 | NUMBER | 1 | DocumentCode | |
OR92107 | NUMBER | 1 | PrintoutFlag | |
OR92108 | NUMBER | 1 | OrderFromModule |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Sales Order (Заказ на Продажу) | Freight Document (Докум. на фрахт)