Таблица: PC27 - «Spare». Маска имени таблицы: «PC27%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PC27001 | NCHAR | STRING | 10 | 0 | 10 | OrderNo | Purchase Order Number | 1 | Да | |
PC27002 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | NetWeight | Net Weight | |||
PC27003 | INT | INTEGER | 0 | 0 | 2 | NumberofPackages | Number of Packages | |||
PC27004 | NVARCHAR | VSTRING | 35 | 0 | 35 | ImportCarriageLine1 | Import Carriage Line 1 | |||
PC27005 | NVARCHAR | VSTRING | 35 | 0 | 35 | ImportCarriageLine2 | Import Carriage Line 2 | |||
PC27006 | NVARCHAR | VSTRING | 35 | 0 | 35 | ImportCarriageLine3 | Import Carriage Line 3 | |||
PC27007 | NVARCHAR | VSTRING | 35 | 0 | 35 | ImportCarriageLine4 | Import Carriage Line 4 | |||
PC27008 | NVARCHAR | VSTRING | 35 | 0 | 35 | ImportCarriageLine5 | Import Carriage Line 5 | |||
PC27009 | NVARCHAR | VSTRING | 15 | 0 | 15 | PlaceofDischarge | Place of Discharge | |||
PC27010 | NCHAR | STRING | 10 | 0 | 10 | PackageType | Package Type | |||
PC27011 | NVARCHAR | VSTRING | 15 | 0 | 15 | MarksLine2 | Marks Line 2 | |||
PC27012 | NVARCHAR | VSTRING | 15 | 0 | 15 | MarksLine3 | Marks Line 3 | |||
PC27013 | NVARCHAR | VSTRING | 15 | 0 | 15 | MarksLine4 | Marks Line 4 | |||
PC27014 | NVARCHAR | VSTRING | 25 | 0 | 25 | ContentLine2 | Content Line 2 | |||
PC27015 | NVARCHAR | VSTRING | 25 | 0 | 25 | ContentLine3 | Content Line 3 | |||
PC27016 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | GrossWeight | Gross Weight | |||
PC27017 | NCHAR | STRING | 10 | 0 | 10 | Volume | Volume | |||
PC27018 | NVARCHAR | VSTRING | 25 | 0 | 25 | Destination | Destination | |||
PC27019 | NVARCHAR | VSTRING | 25 | 0 | 25 | MarksLine1 | Marks Line 1 | |||
PC27020 | NVARCHAR | VSTRING | 25 | 0 | 25 | ContentLine1 | Content Line 1 | |||
PC27021 | NVARCHAR | VSTRING | 16 | 0 | 16 | FiscalCode | Fiscal Registration Code | |||
PC27022 | INT | INTEGER | 0 | 0 | 6 | Transportformcode | Transport Form Code | |||
PC27023 | NVARCHAR | VSTRING | 30 | 0 | 30 | LoadingPlace | Loading Place | |||
PC27024 | NVARCHAR | VSTRING | 30 | 0 | 30 | BorderCrossingPlace | Border Crossing Place | |||
PC27025 | INT | INTEGER | 0 | 0 | 3 | BorderCrossingCode | Border Crossing Code | |||
PC27026 | NVARCHAR | VSTRING | 30 | 0 | 30 | DepartureCustomOffice | Departure Custom Office | |||
PC27027 | NCHAR | STRING | 3 | 0 | 3 | DepartureCustomCountry | Departure Custom Country | |||
PC27028 | NVARCHAR | VSTRING | 30 | 0 | 30 | DestinationCustomOffice | Destination Custom Office | |||
PC27029 | NCHAR | STRING | 3 | 0 | 3 | DestinationCustomCountry | Destination Custom Country | |||
PC27030 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Foreignfees | Foreign Fees (Order Currency) | |||
PC27031 | INT | INTEGER | 0 | 0 | 4 | Numberofunits | Number of Units |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Order | Import Documents