Таблица | Table: SC90 - «Consumed Reservations». Маска имени таблицы | Table Name Mask: «SC90%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?
SC90001 NCHAR STRING 10 0 10 Sales Contract Number (consumed from) Sales Contract Number (consumed from)   3 Да / Yes
SC90002 NCHAR STRING 6 0 6 Sales Contract Line Number Sales Contract Line Number   4 Да / Yes
SC90003 NCHAR STRING 6 0 6 Sales Contract SubLine Number Sales Contract SubLine Number   5 Да / Yes
SC90004 NCHAR STRING 1 0 1 Reservation type Reservation type   1 Да / Yes
SC90005 NCHAR STRING 1 0 1 Reservation subtype Reservation subtype   2 Да / Yes
SC90006 NCHAR STRING 1 0 1 History flag History flag      
SC90007 NCHAR STRING 10 0 10 Contract/Order Number (consumed by) Contract/Order Number (consumed by)   8 Да / Yes
SC90008 NCHAR STRING 6 0 6 Contract/Order Line Number Contract/Order Line Number   9 Да / Yes
SC90009 NCHAR STRING 6 0 6 Contract/Order SubLine Number Contract/Order SubLine Number   10 Да / Yes
SC90010 NCHAR STRING 1 0 1 Reservation type Reservation type   6 Да / Yes
SC90011 NCHAR STRING 1 0 1 Reservation subtype Reservation subtype   7 Да / Yes
SC90012 NCHAR STRING 1 0 1 History flag History flag      
SC90013 NUMERIC X_NUMERIC 20 8 12 Consumed qty (SC units) Consumed qty (SC units)      
SC90014 NUMERIC X_NUMERIC 20 8 12 Consumed qty from Contract (OR units) Consumed qty from Contract (OR units)      
SC90015 NUMERIC X_NUMERIC 20 8 12 Consumed qty by Contract/Order (OR units) Consumed qty by Contract/Order (OR units)      
SC90016 DATETIME DATE 0 0 8 Consumed Date Consumed Date      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Consumed Reservations