Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PRX5 - «Ed.Inv.Prop.wr1». Маска имени таблицы: «PRX50000»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PRX5001 | NVARCHAR | VSTRING | 8 | 0 | 8 | TransactDate | TransactDate | 1 | Да | |
PRX5002 | NVARCHAR | VSTRING | 2 | 0 | 2 | VATcode | VAT_code | 2 | Да | |
PRX5003 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | CurrencyCode | 3 | Да | |
PRX5004 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNo | Order_No | 4 | Да | |
PRX5005 | NVARCHAR | VSTRING | 6 | 0 | 6 | OrderLine | Order_Line | 5 | Да | |
PRX5006 | NVARCHAR | VSTRING | 6 | 0 | 6 | OrdStruLine | OrdStruLine | 6 | Да | |
PRX5007 | NVARCHAR | VSTRING | 4 | 0 | 4 | OrdDelivLine | OrdDelivLine | 7 | Да | |
PRX5008 | NVARCHAR | VSTRING | 2 | 0 | 2 | StoItAccCode | StoItAccCode | |||
PRX5009 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccounString | AccounString | |||
PRX5010 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockItem | StockItem | |||
PRX5011 | NVARCHAR | VSTRING | 12 | 0 | 12 | BatchNoDeliv | BatchNoDeliv | |||
PRX5012 | NVARCHAR | VSTRING | 12 | 0 | 12 | QtyOrdered | QtyOrdered | |||
PRX5013 | NVARCHAR | VSTRING | 12 | 0 | 12 | QtyDelivered | QtyDelivered | |||
PRX5014 | NVARCHAR | VSTRING | 12 | 0 | 12 | QtyOrderSC | QtyOrdered | |||
PRX5015 | NVARCHAR | VSTRING | 12 | 0 | 12 | QtyDelivSC | QtyDelivered | |||
PRX5016 | NVARCHAR | VSTRING | 20 | 0 | 20 | PrUnWoDisc | PrUnWoDisc | |||
PRX5017 | NVARCHAR | VSTRING | 20 | 0 | 20 | PrUnWDisc | PrUnWDisc | |||
PRX5018 | NVARCHAR | VSTRING | 20 | 0 | 20 | PrUnWoDiscLCU | PrUnWoDisc | |||
PRX5019 | NVARCHAR | VSTRING | 20 | 0 | 20 | PrUnWDiscLCU | PrUnWDisc | |||
PRX5020 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeliDatExRat | DeliDatExRat | |||
PRX5021 | NVARCHAR | VSTRING | 20 | 0 | 20 | CostUnit | CostUnit | |||
PRX5022 | NVARCHAR | VSTRING | 8 | 0 | 8 | DeliDateRequ | DeliDateRequ | |||
PRX5023 | NVARCHAR | VSTRING | 8 | 0 | 8 | DeliDateComm | DeliDateComm | |||
PRX5024 | NVARCHAR | VSTRING | 8 | 0 | 8 | DeliDateActu | DeliDateActu | |||
PRX5025 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeliNoteNo | DeliNoteNo | |||
PRX5026 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeliNotePrin | DeliNotePrin | |||
PRX5027 | NVARCHAR | VSTRING | 1 | 0 | 1 | PickListPrin | PickListPrin | |||
PRX5028 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeliPropPrin | DeliPropPrin | |||
PRX5029 | NVARCHAR | VSTRING | 10 | 0 | 10 | NetWeight | NetWeight | |||
PRX5030 | NVARCHAR | VSTRING | 10 | 0 | 10 | GrossWeght | GrossWeght | |||
PRX5031 | NVARCHAR | VSTRING | 10 | 0 | 10 | Volume | Volume | |||
PRX5032 | NVARCHAR | VSTRING | 10 | 0 | 10 | PickListNo | PickListNo | |||
PRX5033 | NVARCHAR | VSTRING | 10 | 0 | 10 | DelivPropNo | DelivPropNo | |||
PRX5034 | NVARCHAR | VSTRING | 20 | 0 | 20 | ConsCostPric | ConsCostPric | |||
PRX5035 | NVARCHAR | VSTRING | 2 | 0 | 2 | VATCode2 | VAT_Code | |||
PRX5036 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
PRX5037 | NVARCHAR | VSTRING | 6 | 0 | 6 | LineDiscount | LineDiscount | |||
PRX5038 | NVARCHAR | VSTRING | 6 | 0 | 6 | OrderDiscou | OrderDiscou | |||
PRX5039 | NCHAR | STRING | 1 | 0 | 1 | ItemType | Item Type |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Ed.Inv.Prop.wr1