Таблица | Table: OR50 - «Packaging Material per Sales Order Line». Маска имени таблицы | Table Name Mask: «OR50%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
OR50001 NCHAR STRING 10 0 10 Order Number Order Number   1 Да / Yes
OR50002 NCHAR STRING 6 0 6 Order Line Number Order Line Number   2 Да / Yes
OR50003 NCHAR STRING 6 0 6 Structure Line Number Structure Line Number   3 Да / Yes
OR50004 NVARCHAR VSTRING 5 0 5 Material Code 1 Material Code 1      
OR50005 NUMERIC X_NUMERIC 18 8 10 Weight 1 Weight 1      
OR50006 NVARCHAR VSTRING 5 0 5 Material Code 2 Material Code 2      
OR50007 NUMERIC X_NUMERIC 18 8 10 Weight 2 Weight 2      
OR50008 NVARCHAR VSTRING 5 0 5 Material Code 3 Material Code 3      
OR50009 NUMERIC X_NUMERIC 18 8 10 Weight 3 Weight 3      
OR50010 NVARCHAR VSTRING 5 0 5 Material Code 4 Material Code 4      
OR50011 NUMERIC X_NUMERIC 18 8 10 Weight 4 Weight 4      
OR50012 NVARCHAR VSTRING 5 0 5 Material Code 5 Material Code 5      
OR50013 NUMERIC X_NUMERIC 18 8 10 Weight 5 Weight 5      
OR50014 NVARCHAR VSTRING 5 0 5 Material Code 6 Material Code 6      
OR50015 NUMERIC X_NUMERIC 18 8 10 Weight 6 Weight 6      
OR50016 NVARCHAR VSTRING 5 0 5 Material Code 7 Material Code 7      
OR50017 NUMERIC X_NUMERIC 18 8 10 Weight 7 Weight 7      
OR50018 NVARCHAR VSTRING 5 0 5 Material Code 8 Material Code 8      
OR50019 NUMERIC X_NUMERIC 18 8 10 Weight 8 Weight 8      
OR50020 NVARCHAR VSTRING 5 0 5 Material Code 9 Material Code 9      
OR50021 NUMERIC X_NUMERIC 18 8 10 Weight 9 Weight 9      
OR50022 NVARCHAR VSTRING 5 0 5 Material Code 10 Material Code 10      
OR50023 NUMERIC X_NUMERIC 18 8 10 Weight 10 Weight 10      
OR50024 NVARCHAR VSTRING 5 0 5 Material Code 11 Material Code 11      
OR50025 NUMERIC X_NUMERIC 18 8 10 Weight 11 Weight 11      
OR50026 NVARCHAR VSTRING 5 0 5 Material Code 12 Material Code 12      
OR50027 NUMERIC X_NUMERIC 18 8 10 Weight 12 Weight 12      
OR50028 NVARCHAR VSTRING 5 0 5 Material Code 13 Material Code 13      
OR50029 NUMERIC X_NUMERIC 18 8 10 Weight 13 Weight 13      
OR50030 NVARCHAR VSTRING 5 0 5 Material Code 14 Material Code 14      
OR50031 NUMERIC X_NUMERIC 18 8 10 Weight 14 Weight 14      
OR50032 NVARCHAR VSTRING 5 0 5 Material Code 15 Material Code 15      
OR50033 NUMERIC X_NUMERIC 18 8 10 Weight 15 Weight 15      
OR50034 NVARCHAR VSTRING 5 0 5 Material Code 16 Material Code 16      
OR50035 NUMERIC X_NUMERIC 18 8 10 Weight 16 Weight 16      
OR50036 NVARCHAR VSTRING 5 0 5 Material Code 17 Material Code 17      
OR50037 NUMERIC X_NUMERIC 18 8 10 Weight 17 Weight 17      
OR50038 NVARCHAR VSTRING 5 0 5 Material Code 18 Material Code 18      
OR50039 NUMERIC X_NUMERIC 18 8 10 Weight 18 Weight 18      
OR50040 NVARCHAR VSTRING 5 0 5 Material Code 19 Material Code 19      
OR50041 NUMERIC X_NUMERIC 18 8 10 Weight 19 Weight 19      
OR50042 NVARCHAR VSTRING 5 0 5 Material Code 20 Material Code 20      
OR50043 NUMERIC X_NUMERIC 18 8 10 Weight 20 Weight 20      
OR50044 NCHAR STRING 15 0 15 Invoice Number (dummy) Invoice Number (dummy)      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Sales Order | Packaging Material per Sales Order Line