Таблица | Table: PC10 - «Purchase Proposals». Маска имени таблицы | Table Name Mask: «PC10%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?
PC10001 NCHAR STRING 10 0 10 SupplierCode Supplier Code   1 Да / Yes
PC10002 NCHAR STRING 6 0 6 Purchaser Purchaser Code   2 Да / Yes
PC10003 NCHAR STRING 12 0 12 CustOrderNo Sales Order Number   3 Да / Yes
PC10004 NCHAR STRING 6 0 6 Warehouse Warehouse   4 Да / Yes
PC10005 NCHAR STRING 6 0 6 LineNumber Sales Order Line Number   5 Да / Yes
PC10006 NCHAR STRING 6 0 6 StructLineNo Sales Order Sub-line Number   6 Да / Yes
PC10007 NCHAR STRING 4 0 4 PCQtyOrdered Sales Order Delivery Line Number   7 Да / Yes
PC10008 NCHAR STRING 35 0 35 StockCode Stock Item Code   8 Да / Yes
PC10009 DATETIME DATE 0 0 8 DeliveryDate Delivery Date   9 Да / Yes
PC10010 NUMERIC X_NUMERIC 20 8 12 QtyOrdSCqty Quantity Ordered (Stock Unit)      
PC10011 NUMERIC X_NUMERIC 20 8 12 QtyOrdORqty Quantity Ordered (Sales Unit)      
PC10012 NUMERIC X_NUMERIC 20 8 12 QtyOrdPCqty Quantity Ordered (Purchase Unit)      
PC10013 INT INTEGER 0 0 1 CreatedFrMod Created From Module 1 - Sales Order
2 - Service Order
3 - Sales Order (related to Project)
4 - Work Order (MPC)		    
PC10014 NCHAR STRING 10 0 10 Reporting Report Number      
PC10015 NCHAR STRING 4 0 4 BomLine BoM Line Number      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Order | Purchase Proposals