Таблица: PRX5 - «Ed.Inv.Prop.wr1». Маска имени таблицы: «PRX50000»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PRX5001 | NVARCHAR | VSTRING | 8 | 0 | 8 | TransactDate | NULL | 1 | Да | |
PRX5002 | NVARCHAR | VSTRING | 2 | 0 | 2 | VAT_code | NULL | 2 | Да | |
PRX5003 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | NULL | 3 | Да | |
PRX5004 | NVARCHAR | VSTRING | 10 | 0 | 10 | Order_No | NULL | 4 | Да | |
PRX5005 | NVARCHAR | VSTRING | 6 | 0 | 6 | Order_Line | NULL | 5 | Да | |
PRX5006 | NVARCHAR | VSTRING | 6 | 0 | 6 | OrdStruLine | NULL | 6 | Да | |
PRX5007 | NVARCHAR | VSTRING | 4 | 0 | 4 | OrdDelivLine | NULL | 7 | Да | |
PRX5008 | NVARCHAR | VSTRING | 2 | 0 | 2 | StoItAccCode | NULL | |||
PRX5009 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccounString | NULL | |||
PRX5010 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockItem | NULL | |||
PRX5011 | NVARCHAR | VSTRING | 12 | 0 | 12 | BatchNoDeliv | NULL | |||
PRX5012 | NVARCHAR | VSTRING | 12 | 0 | 12 | QtyOrdered | NULL | |||
PRX5013 | NVARCHAR | VSTRING | 12 | 0 | 12 | QtyDelivered | NULL | |||
PRX5014 | NVARCHAR | VSTRING | 12 | 0 | 12 | QtyOrdered | NULL | |||
PRX5015 | NVARCHAR | VSTRING | 12 | 0 | 12 | QtyDelivered | NULL | |||
PRX5016 | NVARCHAR | VSTRING | 20 | 0 | 20 | PrUnWoDisc | NULL | |||
PRX5017 | NVARCHAR | VSTRING | 20 | 0 | 20 | PrUnWDisc | NULL | |||
PRX5018 | NVARCHAR | VSTRING | 20 | 0 | 20 | PrUnWoDisc | NULL | |||
PRX5019 | NVARCHAR | VSTRING | 20 | 0 | 20 | PrUnWDisc | NULL | |||
PRX5020 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeliDatExRat | NULL | |||
PRX5021 | NVARCHAR | VSTRING | 20 | 0 | 20 | CostUnit | NULL | |||
PRX5022 | NVARCHAR | VSTRING | 8 | 0 | 8 | DeliDateRequ | NULL | |||
PRX5023 | NVARCHAR | VSTRING | 8 | 0 | 8 | DeliDateComm | NULL | |||
PRX5024 | NVARCHAR | VSTRING | 8 | 0 | 8 | DeliDateActu | NULL | |||
PRX5025 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeliNoteNo | NULL | |||
PRX5026 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeliNotePrin | NULL | |||
PRX5027 | NVARCHAR | VSTRING | 1 | 0 | 1 | PickListPrin | NULL | |||
PRX5028 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeliPropPrin | NULL | |||
PRX5029 | NVARCHAR | VSTRING | 10 | 0 | 10 | NetWeight | NULL | |||
PRX5030 | NVARCHAR | VSTRING | 10 | 0 | 10 | GrossWeght | NULL | |||
PRX5031 | NVARCHAR | VSTRING | 10 | 0 | 10 | Volume | NULL | |||
PRX5032 | NVARCHAR | VSTRING | 10 | 0 | 10 | PickListNo | NULL | |||
PRX5033 | NVARCHAR | VSTRING | 10 | 0 | 10 | DelivPropNo | NULL | |||
PRX5034 | NVARCHAR | VSTRING | 20 | 0 | 20 | ConsCostPric | NULL | |||
PRX5035 | NVARCHAR | VSTRING | 2 | 0 | 2 | VAT_Code | NULL | |||
PRX5036 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | NULL | |||
PRX5037 | NVARCHAR | VSTRING | 6 | 0 | 6 | LineDiscount | NULL | |||
PRX5038 | NVARCHAR | VSTRING | 6 | 0 | 6 | OrderDiscou | NULL |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Project Management | Ed.Inv.Prop.wr1