Таблица | Table: SC76 - «Iscala stock balance History». Маска имени таблицы | Table Name Mask: «SC76%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?
SC76001 NCHAR STRING 6 0 6 Warehouse Code Warehouse   1 Да / Yes
SC76002 NCHAR STRING 35 0 35 Stock Item Code Stock Item Code   2 Да / Yes
SC76003 NCHAR STRING 6 0 6 Bin Number Bin   3 Да / Yes
SC76004 DATETIME DATE 0 0 8 History Date History Date   4 Да / Yes
SC76005 NUMERIC X_NUMERIC 20 8 12 Balance quantity (iScala) Stock Balance (iScala)      
SC76006 DATETIME DATE 0 0 8 Date of entry of the record Date Record Created      
SC76007 NCHAR STRING 8 0 8 User ID User ID      
SC76008 NUMERIC MONEY 28 8 20 Weighted average cost (LCU) Weighted Average Cost (Local Currency)      
SC76009 NUMERIC MONEY 28 8 20 Standard cost (LCU) Standard Cost (Local Currency)      
SC76010 NUMERIC MONEY 28 8 20 FIFO cost (LCU) FIFO Cost (Local Currency)      
SC76011 NUMERIC MONEY 28 8 20 LIFO cost (LCU) LIFO Cost (Local Currency)      
SC76012 NUMERIC MONEY 28 8 20 Weighted average cost (CCU) Weighted Average Cost (Alternative Currency)      
SC76013 NUMERIC MONEY 28 8 20 Standard cost (CCU) Standard Cost (Alternative Currency)      
SC76014 NUMERIC MONEY 28 8 20 FIFO cost (CCU) FIFO Cost (Alternative Currency)      
SC76015 NUMERIC MONEY 28 8 20 LIFO cost (CCU) LIFO Cost (Alternative Currency)      

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