Таблица | Table: SYR6 - «Licenses». Маска имени таблицы | Table Name Mask: «SYR6%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?
SYR6001 NVARCHAR VSTRING 10 0 10 License Number License Number   1 Да / Yes
SYR6002 NVARCHAR VSTRING 10 0 10 Legal Regulation No Legal Regulation No      
SYR6003 NCHAR STRING 1 0 1 License Type License Type      
SYR6004 NVARCHAR VSTRING 50 0 50 License Code License Code      
SYR6005 NVARCHAR VSTRING 100 0 100 Name Name      
SYR6006 NVARCHAR VSTRING 50 0 50 Source Source      
SYR6007 NVARCHAR VSTRING 50 0 50 Confirmed by Confirmed by      
SYR6008 DATETIME DATE 0 0 8 Entry Date Entry Date      
SYR6009 DATETIME DATE 0 0 8 Valid. Start Date Valid. Start Date      
SYR6010 DATETIME DATE 0 0 8 Valid. Finish Date Valid. Finish Date      
SYR6011 NCHAR STRING 1 0 1 Activity Activity      
SYR6012 NVARCHAR VSTRING 35 0 35 Stock Item Code Stock Item Code      
SYR6013 NVARCHAR VSTRING 35 0 35 Stock Item Family Stock Item Family      
SYR6014 NVARCHAR VSTRING 15 0 15 Stock Item Classifier Stock Item Classifier      
SYR6015 NVARCHAR VSTRING 10 0 10 Business Partner Business Partner      
SYR6016 NVARCHAR VSTRING 15 0 15 Business Partner Classifier Business Partner Classifier      
SYR6017 NVARCHAR VSTRING 3 0 3 Country Code Country Code      
SYR6018 NVARCHAR VSTRING 15 0 15 Country Code Classifier Country Code Classifier      
SYR6019 NVARCHAR VSTRING 10 0 10 Document No Document No      
SYR6020 NCHAR STRING 1 0 1 Single Delivery Single Delivery      
SYR6021 NCHAR STRING 2 0 2 Delivery Method Delivery Method      
SYR6022 NUMERIC X_NUMERIC 20 8 12 Qty Licensed Qty Licensed      
SYR6023 NUMERIC X_NUMERIC 20 8 12 Qty Reserved Qty Reserved      
SYR6024 NUMERIC X_NUMERIC 20 8 12 Qty Consumed Qty Consumed      
SYR6025 NUMERIC X_NUMERIC 18 8 10 Weight Licensed Weight Licensed      
SYR6026 NUMERIC X_NUMERIC 18 8 10 Weight Reserved Weight Reserved      
SYR6027 NUMERIC X_NUMERIC 18 8 10 Weight Consumed Weight Consumed      
SYR6028 NUMERIC X_NUMERIC 18 8 10 Volume Licensed Volume Licensed      
SYR6029 NUMERIC X_NUMERIC 18 8 10 Volume Reserved Volume Reserved      
SYR6030 NUMERIC X_NUMERIC 18 8 10 Volume Consumed Volume Consumed      
SYR6031 NCHAR STRING 1 0 1 Status Status      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | System Utilities/Office Autom. | Licenses