Таблица: SM96 - «Transport Documents». Маска имени таблицы: «SM96%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SM96001 NCHAR STRING 10 0 10 OrderNo Service Order Number   1 Да
SM96002 NCHAR STRING 1 0 1 DocumentType Document Type   3 Да
SM96003 INT INTEGER 0 0 2 UnitCode Unit Code      
SM96004 INT INTEGER 0 0 4 NOofUnits Number of Units      
SM96005 NUMERIC X_NUMERIC 10 8 2 NoOfPackages Number of Packages      
SM96006 NCHAR STRING 10 0 10 PackageType Parcel Type      
SM96007 NVARCHAR VSTRING 25 0 25 MarksLine1 Marks Line 1      
SM96008 NVARCHAR VSTRING 25 0 25 MarksLine2 Marks Line 2      
SM96009 NVARCHAR VSTRING 25 0 25 MarksLine3 Marks Line 3      
SM96010 NVARCHAR VSTRING 25 0 25 MarksLine4 Marks Line 4      
SM96011 NVARCHAR VSTRING 25 0 25 ContentsLn1 Content Line 1      
SM96012 NVARCHAR VSTRING 25 0 25 ContentsLn2 Content Line 2      
SM96013 NVARCHAR VSTRING 25 0 25 ContentsLn3 Content Line 3      
SM96014 NVARCHAR VSTRING 15 0 15 PlaceOfDischarge Place of Discharge      
SM96015 NVARCHAR VSTRING 25 0 25 Destination Destination      
SM96016 NUMERIC MONEY 28 8 20 CODAmount Cash to Pay (Local Currency)      
SM96017 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
SM96018 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
SM96019 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
SM96020 INT INTEGER 0 0 6 TransportFormCode Transport Code at Border      
SM96021 NVARCHAR VSTRING 30 0 30 LoadingPlace Loading Place      
SM96022 NVARCHAR VSTRING 30 0 30 BorderCrossPlace Border Cross Place      
SM96023 INT INTEGER 0 0 3 BorderCrossCode Border Cross Code      
SM96024 NVARCHAR VSTRING 30 0 30 DepartCustomOffice Departure Custom Office      
SM96025 NCHAR STRING 3 0 3 DepartCustomCountry Departure Custom Office Country      
SM96026 NVARCHAR VSTRING 30 0 30 DestCustomOffice Destination Custom Office      
SM96027 NCHAR STRING 3 0 3 DestCustomCountry Destination Custom Office Country      
SM96028 NUMERIC X_NUMERIC 28 8 20 ForeignFees Foreign Fees (Local Currency)      
SM96029 NVARCHAR VSTRING 35 0 35 ExportCarriageLine1 Transport Details Line 1      
SM96030 NVARCHAR VSTRING 35 0 35 ExportcarriageLine2 Transport Details Line 2      
SM96031 NVARCHAR VSTRING 35 0 35 ExportCarriageLine3 Transport Details Line 3      
SM96032 NVARCHAR VSTRING 35 0 35 ExportcarriageLine4 Transport Details Line 4      
SM96033 NVARCHAR VSTRING 35 0 35 ExportCarriageLine5 Transport Details Line 5      
SM96034 NCHAR STRING 10 0 10 CustomerCode Customer Code   2 Да

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Service Order Management | Service Order Transport Documents