Таблица: OR91 - «Export Invoice». Маска имени таблицы: «OR91%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
OR91001 | NUMERIC | NUMBER | 20 | 0 | 10 | OrderNO | Order Number | 1 | Да | |
OR91002 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | NetWeight | Net Weight | |||
OR91003 | NUMERIC | NUMBER | 20 | 0 | 2 | NOofPackages | No of Packages | |||
OR91004 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExportCarriageLine1 | Transport Details Line 1 | |||
OR91005 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExportcarriageLine2 | Transport Details Line 2 | |||
OR91006 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExportCarriageLine3 | Transport Details Line 3 | |||
OR91007 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExportcarriageLine4 | Transport Details Line 4 | |||
OR91008 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExportCarriageLine5 | Transport Details Line 5 | |||
OR91009 | NVARCHAR | VSTRING | 15 | 0 | 15 | PlaceOfDischarge | Place of Discharge | |||
OR91010 | NCHAR | STRING | 10 | 0 | 10 | PackageType | Package Type | |||
OR91011 | NVARCHAR | VSTRING | 15 | 0 | 15 | MarksLine2 | Marks Line 2 | |||
OR91012 | NVARCHAR | VSTRING | 15 | 0 | 15 | MarksLine3 | Marks Line 3 | |||
OR91013 | NVARCHAR | VSTRING | 15 | 0 | 15 | MarksLine4 | Marks Line 4 | |||
OR91014 | NVARCHAR | VSTRING | 25 | 0 | 25 | ContentLine2 | Content Line 2 | |||
OR91015 | NVARCHAR | VSTRING | 25 | 0 | 25 | ContentLine3 | Content Line 3 | |||
OR91016 | NVARCHAR | VSTRING | 24 | 0 | 24 | spare | (obsolete) | |||
OR91017 | NVARCHAR | VSTRING | 13 | 0 | 13 | spare | (obsolete) | |||
OR91018 | NVARCHAR | VSTRING | 13 | 0 | 13 | spare | (obsolete) | |||
OR91019 | NVARCHAR | VSTRING | 13 | 0 | 13 | spare | (obsolete) | |||
OR91020 | NVARCHAR | VSTRING | 13 | 0 | 13 | spare | (obsolete) | |||
OR91021 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | GrossWeight | Gross Weight | |||
OR91022 | NCHAR | STRING | 10 | 0 | 10 | Volume | Volume | |||
OR91023 | NVARCHAR | VSTRING | 25 | 0 | 25 | Destination | Destination | |||
OR91024 | NVARCHAR | VSTRING | 25 | 0 | 25 | MarksLine1 | Marks Line 1 | |||
OR91025 | NVARCHAR | VSTRING | 25 | 0 | 25 | ContentLine1 | Content Line 1 | |||
OR91026 | NVARCHAR | VSTRING | 16 | 0 | 16 | FiscalCode | Fiscal Code | |||
OR91027 | INT | INTEGER | 0 | 0 | 6 | TransportFormCode | Transport Form Code | |||
OR91028 | NVARCHAR | VSTRING | 30 | 0 | 30 | LoadingPlace | Loading Place | |||
OR91029 | NVARCHAR | VSTRING | 30 | 0 | 30 | BorderCrossPlace | Border Cross Place | |||
OR91030 | INT | INTEGER | 0 | 0 | 3 | BorderCrossCode | Border Cross Code | |||
OR91031 | NVARCHAR | VSTRING | 30 | 0 | 30 | DepartCustomOffice | Departure Custom Office | |||
OR91032 | NCHAR | STRING | 3 | 0 | 3 | DepartCustomCountry | Departure Custom Country | |||
OR91033 | NVARCHAR | VSTRING | 30 | 0 | 30 | DestCustomOffice | Destination Custom Office | |||
OR91034 | NCHAR | STRING | 3 | 0 | 3 | DestCustomCountry | Destination Custom Country | |||
OR91035 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | ForeignFees | Foreign Fees (Order Currency) | |||
OR91036 | INT | INTEGER | 0 | 0 | 4 | NOofUnits | Number of Units | |||
OR91037 | NVARCHAR | VSTRING | 37 | 0 | 37 | spare | (obsolete) |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Order | Export Invoice