Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PC19 — Purchase Order Delivery Lines — О системах планирования ресурсов предприятия Scala, iScala

Таблица: PC19 — «Purchase Order Delivery Lines». Маска имени таблицы: «PC19%cc00»

Поле	Тип поля	Тип поля Scala	Длина поля	Точность	Длина Scala	Комментарий	Расширенный комментарий	Дополнительное описание	Позиция в индексе	Первичный ключ?
PC19001	NCHAR	STRING	10	0	10	OrderNo	Purchase Order Number		1	Да
PC19002	NCHAR	STRING	6	0	6	LineNo	Purchase Order Line Number		2	Да
PC19003	NCHAR	STRING	6	0	6	StructLineNo	Purchase Order Sub-line Number		3	Да
PC19004	NCHAR	STRING	4	0	4	AutSubStrLNo	Purchase Order Delivery Line Number		4	Да
PC19005	NVARCHAR	VSTRING	12	0	12	BatchNumber	Batch Number
PC19006	NUMERIC	X_NUMERIC	20	8	12	QtyRequested	Quantity Ordered
PC19007	NUMERIC	X_NUMERIC	20	8	12	QtyDelivered	Quantity Delivered
PC19008	NUMERIC	X_NUMERIC	20	8	12	QtyPropDeliv	Quantity Proposed Delivery
PC19009	DATETIME	DATE	0	0	8	DelDatRequst	Delivery Date Requested
PC19010	DATETIME	DATE	0	0	8	DelDateComm	Delivery Date Committed
PC19011	DATETIME	DATE	0	0	8	DelivDateActl	Delivery Date Actual
PC19012	NVARCHAR	VSTRING	20	0	20	DelivNoteNo	Delivery Note Number
PC19013	NUMERIC	X_NUMERIC	28	8	20	DelDatExcRat	Delivery Date Exchange Rate
PC19014	NUMERIC	MONEY	28	8	20	UnitPrice	Unit Price (Purchase Currency)
PC19015	INT	INTEGER	0	0	1	FlagGRNPrinted	Goods Received Note Printed
PC19016	INT	INTEGER	0	0	1	FlagGRNSent	Goods Received Note Sent (XML)
PC19017	INT	INTEGER	0	0	1	DocumFLAG1	(obsolete)
PC19018	INT	INTEGER	0	0	1	DocumFLAG2	(obsolete)
PC19019	INT	INTEGER	0	0	1	DocumFLAG3	(obsolete)
PC19020	INT	INTEGER	0	0	1	DocumFLAG4	(obsolete)
PC19021	INT	INTEGER	0	0	1	DocumFLAG5	(obsolete)
PC19022	INT	INTEGER	0	0	1	DocumFLAG6	(obsolete)
PC19023	INT	INTEGER	0	0	1	DocumFLAG7	(obsolete)
PC19024	INT	INTEGER	0	0	1	DocumFLAG8	(obsolete)
PC19025	NUMERIC	X_NUMERIC	18	8	10	NetWeight	Net Weight
PC19026	NUMERIC	X_NUMERIC	18	8	10	GrossWeight	Gross Weight
PC19027	NUMERIC	X_NUMERIC	18	8	10	Volume	Volume
PC19028	NVARCHAR	VSTRING	1	0	1	SPARE1	(obsolete)
PC19029	NVARCHAR	VSTRING	5	0	5	SPARE2	(obsolete)
PC19030	NVARCHAR	VSTRING	6	0	6	SPARE3	(obsolete)
PC19031	NVARCHAR	VSTRING	3	0	3	SPARE4	(obsolete)
PC19032	NUMERIC	X_NUMERIC	14	8	6	Discount	Discount
PC19033	NVARCHAR	VSTRING	6	0	6	DeliveryTime	Time Entered
PC19034	NUMERIC	X_NUMERIC	20	8	12	PurchSurchar	Purchase On-charge
PC19035	NUMERIC	X_NUMERIC	20	8	12	QtyInvSCUnit	Quantity Invoiced (Stock Unit)
PC19036	NUMERIC	X_NUMERIC	20	8	12	QtyDelSCUnit	Quantity Delivered (Stock Unit)
PC19037	NUMERIC	X_NUMERIC	20	8	12	QtyInvPCUnit	Quantity Invoiced (Purchase Unit)
PC19038	NUMERIC	X_NUMERIC	18	8	10	DlvryDateExchgRate2	Delivery Date Exchange Rate 2
PC19039	NCHAR	STRING	3	0	3	DlvryDateExchgAlgtm	Delivery Date Exchange Rate Algorithm
PC19040	INT	INTEGER	0	0	2	CurrencyCode	Currency Code Order
PC19041	NVARCHAR	VSTRING	10	0	10	AutoDelNoteNo	Internal Goods Received Note Number
PC19042	NVARCHAR	VSTRING	10	0	10	ConsGoodsRecNoteNo	Consolidated Goods Received Note Number
PC19043	NVARCHAR	VSTRING	1	0	1	InclInCGRNFlag	Has Been Included in Goods Received Note
PC19044	NVARCHAR	VSTRING	25	0	25	InvoiceNoLast	Invoice Number
PC19045	INT	INTEGER	0	0	2	ConsCurrCode	Currency Code Alternative
PC19046	NUMERIC	X_NUMERIC	18	8	10	CCExchgRate1	Alternative Currency Exchange Rate
PC19047	NUMERIC	X_NUMERIC	18	8	10	CCExchgRate2	Alternative Currency Exchange Rate 2
PC19048	NCHAR	STRING	3	0	3	CCExchgAlgtm	Alternative Currency Exchange Rate Algorithm
PC19049	NUMERIC	MONEY	28	8	20	AllocCostsOnPO	Allocation of Costs on Purchase Order
PC19050	NUMERIC	X_NUMERIC	28	8	20	QtyPCUnitLastInvoice	LastInvoice Qty in PCUnit
PC19051	NUMERIC	X_NUMERIC	28	8	20	QtySCUnitLastInvoice	LastInvoice Qty in SCUnit
PC19052	NCHAR	SWITCH	1	0	1	ProductLabelPrinted	Product Label Printed
PC19053	NUMERIC	X_NUMERIC	20	8	12	QtyRejected	Rejected quantity
PC19054	NVARCHAR	VSTRING	4	0	4	RejectionCode	Rejection Code
PC19055	NVARCHAR	VSTRING	12	0	12	Temperature	Temperature
PC19056	NVARCHAR	VSTRING	12	0	12	Humidity	Humidity
PC19057	NVARCHAR	VSTRING	12	0	12	UserDef1	User def. 1
PC19058	NVARCHAR	VSTRING	12	0	12	UserDef2	User def. 2
PC19059	NVARCHAR	VSTRING	12	0	12	UserDef3	User def. 3
PC19060	NVARCHAR	VSTRING	12	0	12	UserDef4	User def. 4
PC19061	NVARCHAR	VSTRING	12	0	12	UserDef5	User def. 5
PC19062	NUMERIC	MONEY	28	8	20	SubcontractCost	Subcontract cost
PC19063	NCHAR	STRING	1	0	1	TaxRegStatus	Tax Reg. Status
PC19064	DATETIME	DATE	0	0	8	TaxRegDate	Tax Reg. Date

Навигация:

Изменение полей в таблицах БД iScala 3.4 по сравнению с iScala 3.2 / Difference between DB structure of iScala 3.4 and iScala 3.2
Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2
Изменение структуры таблиц iScala 3.1 по сравнению с iScala 3.0 FSP4 / Table structure changes between iScala 3.0 FSP4 and iScala 3.1
История изменения структуры таблиц разных версий iScala / Tables structure changes history from iScala 2.2 SR2 to iScala 3.0 FSP4
Структура таблиц / Table structure Epicor iScala 3.0 FSP4 — 3.0.4267
Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419
Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399
Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0.0429