На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Sales Order»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table OR92 — Freight Document (Finnish)

Таблица / Table: OR92 — «Freight Document». Маска имени таблицы / Table name mask: «OR92%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
OR92001 NCHAR STRING 9 0 9 TransportDocNO Transport Document Number   1 Да / Yes
OR92002 NCHAR STRING 10 0 10 CustomerCodeDelivery Customer Code Delivery      
OR92003 NCHAR STRING 2 0 2 WayOfDelivery Delivery Method      
OR92004 NCHAR STRING 10 0 10 OrderNO1 Order Number 1      
OR92005 NCHAR STRING 10 0 10 OrderNO2 Order Number 2      
OR92006 NCHAR STRING 10 0 10 OrderNO3 Order Number 3      
OR92007 NCHAR STRING 10 0 10 OrderNO4 Order Number 4      
OR92008 NCHAR STRING 10 0 10 OrderNO5 Order Number 5      
OR92009 NCHAR STRING 10 0 10 OrderNO6 Order Number 6      
OR92010 NCHAR STRING 10 0 10 OrderNO7 Order Number 7      
OR92011 NCHAR STRING 10 0 10 OrderNO8 Order Number 8      
OR92012 NVARCHAR VSTRING 35 0 35 CustomerName Customer Name      
OR92013 NVARCHAR VSTRING 35 0 35 CustomerAddr1 Customer Address Line 1      
OR92014 NVARCHAR VSTRING 35 0 35 CustomerAddr2 Customer Address Line 2      
OR92015 NVARCHAR VSTRING 35 0 35 CustomerAddr3 Customer Address Line 3      
OR92016 NVARCHAR VSTRING 20 0 20 CustomerPhone Customer Telephone Number      
OR92017 NCHAR STRING 3 0 3 DestID1 Destination ID 1      
OR92018 NCHAR STRING 2 0 2 DestID2 Destination ID 2      
OR92019 DATETIME DATE 0 0 8 DeliveryDate Delivery Date      
OR92020 NVARCHAR VSTRING 15 0 15 Explain4OtherPayway Explanation for Other Payment Way      
OR92021 NVARCHAR VSTRING 25 0 25 TransportInfo1 Transportation Information Line 1      
OR92022 NVARCHAR VSTRING 25 0 25 TransportInfo2 Transportation Information Line 2      
OR92023 NVARCHAR VSTRING 25 0 25 TransportInfo3 Transportation Information Line 3      
OR92024 NVARCHAR VSTRING 30 0 30 WayOfDeliveryText Delivery Method Text      
OR92025 NCHAR STRING 1 0 1 FreightPayer Freight Payer      
OR92026 NCHAR SWITCH 1 0 1 LavaOrKontti Lava or Kontti      
OR92027 NUMERIC X_NUMERIC 11 8 3 LavaOrKonttiQTY Lava or Kontti Quantity      
OR92028 NVARCHAR VSTRING 50 0 50 Cash2PayInTextForm Cash to Pay In Text      
OR92029 NUMERIC MONEY 28 8 20 Cah2PayInNumbers Cash to Pay In Numbers      
OR92030 NVARCHAR VSTRING 50 0 50 BankAccountInfo Bank Account      
OR92031 NCHAR STRING 10 0 10 CustomersContractNO Customers Contract Number      
OR92032 NVARCHAR VSTRING 20 0 20 Mark1 Mark Line 1      
OR92033 NUMERIC NUMBER 20 0 3 NOofItems1 Number of Items 1      
OR92034 NCHAR STRING 4 0 4 PackageType1 Package Type 1      
OR92035 NVARCHAR VSTRING 25 0 25 Content1 Content 1      
OR92036 INT INTEGER 0 0 6 Code1 Code 1      
OR92037 NUMERIC X_NUMERIC 17 8 9 GrossWeight1 Gross Weight 1      
OR92038 NVARCHAR VSTRING 20 0 20 Mark2 Mark Line 2      
OR92039 NUMERIC NUMBER 20 0 3 NOofItems2 Number of Items 2      
OR92040 NCHAR STRING 4 0 4 PackageType2 Package Type 2      
OR92041 NVARCHAR VSTRING 25 0 25 Content2 Content 2      
OR92042 INT INTEGER 0 0 6 Code2 Code 2      
OR92043 NUMERIC X_NUMERIC 17 8 9 GrossWeight2 Gross Weight 2      
OR92044 NVARCHAR VSTRING 20 0 20 Mark3 Mark Line 3      
OR92045 NUMERIC NUMBER 20 0 3 NOofItems3 Number of Items 3      
OR92046 NCHAR STRING 4 0 4 PackageType3 Package Type 3      
OR92047 NVARCHAR VSTRING 25 0 25 Content3 Content 3      
OR92048 INT INTEGER 0 0 6 Code3 Code 3      
OR92049 NUMERIC X_NUMERIC 17 8 9 GrossWeight3 Gross Weight 3      
OR92050 NVARCHAR VSTRING 20 0 20 Mark4 Mark Line 4      
OR92051 NUMERIC NUMBER 20 0 3 NOofItems4 Number of Items 4      
OR92052 NCHAR STRING 4 0 4 PackageType4 Package Type 4      
OR92053 NVARCHAR VSTRING 25 0 25 Content4 Content 4      
OR92054 INT INTEGER 0 0 6 Code4 Code 4      
OR92055 NUMERIC X_NUMERIC 17 8 9 GrossWeight4 Gross Weight 4      
OR92056 NVARCHAR VSTRING 20 0 20 Mark5 Mark Line 5      
OR92057 NUMERIC NUMBER 20 0 3 NOofItems5 Number of Items 5      
OR92058 NCHAR STRING 4 0 4 PackageType5 Package Type 5      
OR92059 NVARCHAR VSTRING 25 0 25 Content5 Content 5      
OR92060 INT INTEGER 0 0 6 Code5 Code 5      
OR92061 NUMERIC X_NUMERIC 17 8 9 GrossWeight5 Gross Weight 5      
OR92062 NVARCHAR VSTRING 20 0 20 Mark6 Mark Line 6      
OR92063 NUMERIC NUMBER 20 0 3 NOofItems6 Number of Items 6      
OR92064 NCHAR STRING 4 0 4 PackageType6 Package Type 6      
OR92065 NVARCHAR VSTRING 25 0 25 Content6 Content 6      
OR92066 INT INTEGER 0 0 6 Code6 Code 6      
OR92067 NUMERIC X_NUMERIC 17 8 9 GrossWeight6 Gross Weight 6      
OR92068 NVARCHAR VSTRING 20 0 20 Mark7 Mark Line 7      
OR92069 NUMERIC NUMBER 20 0 3 NOofItems7 Number of Items 7      
OR92070 NCHAR STRING 4 0 4 PackageType7 Package Type 7      
OR92071 NVARCHAR VSTRING 25 0 25 Content7 Content 7      
OR92072 INT INTEGER 0 0 6 Code7 Code 7      
OR92073 NUMERIC X_NUMERIC 17 8 9 GrossWeight7 Gross Weight 7      
OR92074 NVARCHAR VSTRING 20 0 20 Mark8 Mark Line 8      
OR92075 NUMERIC NUMBER 20 0 3 NOofItems8 Number of Items 8      
OR92076 NCHAR STRING 4 0 4 PackageType8 Package Type 8      
OR92077 NVARCHAR VSTRING 25 0 25 Content8 Content 8      
OR92078 INT INTEGER 0 0 6 Code8 Code 8      
OR92079 NUMERIC X_NUMERIC 17 8 9 GrossWeight8 Gross Weight 8      
OR92080 NUMERIC X_NUMERIC 13 8 5 TotalLavaQTY4Par1 Total Lava Quantity      
OR92081 NUMERIC X_NUMERIC 18 8 10 TotalGrossWeight Total Gross Weight      
OR92082 NCHAR STRING 10 0 10 RouteNO Route Number      
OR92083 NCHAR STRING 10 0 10 OtherContract Other Contract      
OR92084 NCHAR STRING 10 0 10 OurCustomerNO Our Customer Number      
OR92085 NCHAR STRING 10 0 10 OurContractNO Our Contract Number      
OR92086 NCHAR STRING 2 0 2 TermsOfDelivery Delivery Terms      
OR92087 NVARCHAR VSTRING 30 0 30 TermsOfDeliveryText Delivery Terms Text      
OR92088 NCHAR STRING 10 0 10 OrderNO9 Order Number 9      
OR92089 NCHAR STRING 10 0 10 OrderNO10 Order Number 10      
OR92090 NCHAR STRING 10 0 10 OrderNO11 Order Number 11      
OR92091 NCHAR STRING 10 0 10 OrderNO12 Order Number 12      
OR92092 NCHAR STRING 10 0 10 OrderNO13 Order Number 13      
OR92093 NCHAR STRING 10 0 10 OrderNO14 Order Number 14      
OR92094 NCHAR STRING 10 0 10 OrderNO15 Order Number 15      
OR92095 NVARCHAR VSTRING 10 0 10 Volume Volume      
OR92096 NVARCHAR VSTRING 35 0 35 spare Packed Information      
OR92097 NUMERIC NUMBER 20 0 2 TransportForm Transport Form      
OR92098 NVARCHAR VSTRING 2 0 2 CurrCode Currency Code      
OR92099 NUMERIC NUMBER 20 0 1 AddService1 Additional Service 1      
OR92100 NUMERIC NUMBER 20 0 1 AddService2 Additional Service 2      
OR92101 NUMERIC NUMBER 20 0 1 AddService3 Additional Service 3      
OR92102 NUMERIC NUMBER 20 0 1 AddService4 Additional Service 4      
OR92103 NUMERIC NUMBER 20 0 11 ShipmentCode Shipment Code      
OR92104 NUMERIC NUMBER 20 0 1 SpecialTreatment Special Treatment      
OR92105 NUMERIC NUMBER 20 0 1 TransportUnit Transport Unit      
OR92106 NUMERIC NUMBER 20 0 1 DocumentCode Document Code      
OR92107 NUMERIC NUMBER 20 0 1 PrintoutFlag Printout Flag      
OR92108 NUMERIC NUMBER 20 0 1 OrderFromModule Order From Module      

Навигация / Navigation: