Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PR03 — Project Activity Transactions — О системах планирования ресурсов предприятия Scala, iScala

Таблица: PR03 — «Project Activity Transactions». Маска имени таблицы: «PR03%cc00»

Поле	Тип поля	Тип поля Scala	Длина поля	Точность	Длина Scala	Комментарий	Расширенный комментарий	Дополнительное описание	Позиция в индексе	Первичный ключ?
PR03001	NVARCHAR	VSTRING	12	0	12	ProjectNo	Project Number		1	Да
PR03002	NVARCHAR	VSTRING	6	0	6	SubProject	Sub-Project		2	Да
PR03003	NVARCHAR	VSTRING	6	0	6	ActivityLine	Activity Line Number		3	Да
PR03004	NVARCHAR	VSTRING	6	0	6	ActStrucLine	Activity Sub-line Number		4	Да
PR03005	DATETIME	DATE	0	0	8	TransactDate	Transaction Date		5	Да
PR03006	NVARCHAR	VSTRING	10	0	10	ResourceCode	Resource Code		6	Да
PR03007	NVARCHAR	VSTRING	6	0	6	TransactLine	Transaction Line Number		7	Да
PR03008	NUMERIC	X_NUMERIC	20	8	12	HoursQty	Quantity/Hours Reported
PR03009	NUMERIC	X_NUMERIC	20	8	12	HoursQtyInv	Quantity/Hours to Invoice
PR03010	NUMERIC	MONEY	28	8	20	Price	Unit Price (Project Currency)
PR03011	NUMERIC	MONEY	28	8	20	PriceToInvoi	Unit Price to Invoice (Project Currency)
PR03012	NUMERIC	MONEY	28	8	20	CostLCU	Unit Cost (Local Currency)
PR03013	NVARCHAR	VSTRING	35	0	35	Description	Text
PR03014	NVARCHAR	VSTRING	1	0	1	ChargeCode	Charge Activity	0 — Activity shall not be charged to customer but cost allocated to the project 1 — Activity will included when invoicing the project
PR03015	NUMERIC	MONEY	28	8	20	ActualInvoicedCostLCU	Actual Invoiced Cost LCU
PR03016	NUMERIC	MONEY	28	8	20	ActInvAmount	Actual Invoiced Amount (Project Currency)
PR03017	NVARCHAR	VSTRING	1	0	1	InvoiceFlag	Has Been Invoiced
PR03018	NUMERIC	MONEY	28	8	20	ActInvPrice	Actual Invoiced Amount (Local Currency)
PR03019	NUMERIC	MONEY	28	8	20	WIPTransLCU	WIP Transaction Amount (Local Currency)
PR03020	NVARCHAR	ACCSTR	50	0	50	AccounString	Accounting String
PR03021	NUMERIC	X_NUMERIC	20	8	12	ActuaInvHour	Actual Invoiced Quantity/Hours
PR03022	NVARCHAR	VSTRING	20	0	20	Spare	Spare
PR03023	NVARCHAR	VSTRING	20	0	20	Spare	(obsolete)
PR03024	NVARCHAR	VSTRING	1	0	1	ActivityType	Activity Type	0 — Cost Activity 1 — Time Activity 2 — Material Activity (Sales Order or Purchase Order) 3 — Milestone 4 — Text Annotation 5 — Linked Sales Order 6 — Linked Purchase Order 7 — Linked Service Order 8 — Linked Contract 9 — Linked Work Order
PR03025	NVARCHAR	VSTRING	6	0	6	VATCode	VAT Code
PR03026	NUMERIC	X_NUMERIC	14	8	6	Markup	Mark-up %
PR03027	NVARCHAR	VSTRING	10	0	10	SupplCode	Supplier Code
PR03028	NVARCHAR	VSTRING	1	0	1	InvLinLayout	Invoice Line Layout	1 — Invoice lines include quantity, unit price and total amount. 2 — Invoice lines include only the totals. (The actual layout is defined in the ddf files for invoices and invoice proposal)
PR03029	NVARCHAR	VSTRING	6	0	6	LinkActiLine	Linked Activity Line Number
PR03030	NVARCHAR	VSTRING	6	0	6	LinActStrLin	Linked Activity Sub-line Number
PR03031	NVARCHAR	VSTRING	9	0	9	VoucherNo	General Ledger Transaction Number	This information is updated for transaction updated from general ledger and manual general ledger transactions entered with project activity relation.
PR03032	NVARCHAR	VSTRING	2	0	2	CurrencyCode	Currency Code
PR03033	DATETIME	DATE	0	0	8	WIPBEDate	WIP Book-Entry Date
PR03034	NVARCHAR	VSTRING	10	0	10	EnterByUser	Created By
PR03035	NVARCHAR	VSTRING	10	0	10	ConfirByUser	Confirmed By
PR03036	NVARCHAR	VSTRING	1	0	1	DateType012	Date Type	Time reported as per: 0 — Date 1 — Week 2 — Month
PR03037	NVARCHAR	VSTRING	9	0	9	WIPTransacNo	WIP Transaction Number
PR03038	NUMERIC	MONEY	28	8	20	WIPAmtMarkup	WIP Amount Mark-up (Local Currency)
PR03039	NVARCHAR	VSTRING	1	0	1	WIPStatus	WIP Status	0 — No cost/wip has been booked for the transaction line 1 — Transaction cost has been booked directly to P&L as cost (wip/cost method 1) 2 — Transaction cost has been booked to WIP account 3 — Booked wip amount has been booked as cost (reversed)
PR03040	NUMERIC	X_NUMERIC	14	8	6	PercentCompl	Estimated % to Completion	Indicates how much is left to complete the activity. This estimate is entered by the user when reporting time.
PR03041	NVARCHAR	VSTRING	1	0	1	IntDebUpdate	Internal Debiting Updated
PR03042	DATETIME	DATE	0	0	8	WIPReturnDate	WIP Return Date
PR03043	NCHAR	STRING	9	0	9	WIPTreturnTranNo	WIP Return Transaction Number
PR03044	NCHAR	STRING	8	0	8	ReservedForCredit	Reserved For Credit
PR03045	NCHAR	STRING	1	0	1	CreatedForDistributeRevenue	Created For Distribute Revenue
PR03046	NCHAR	STRING	1	0	1	SpareFlag2	(obsolete)
PR03047	NCHAR	STRING	10	0	10	InvoiceNoCustomer	Customer Code Invoice
PR03048	NCHAR	STRING	9	0	9	GLTransactionLineID	General Ledger Transaction Line Reference
PR03049	NCHAR	STRING	4	0	4	GLTransactionYear	General Ledger Financial Year
PR03050	NCHAR	STRING	1	0	1	IncludeInRevenueRcgn	Included into Revenue Recognition
PR03051	DATETIME	DATE	0	0	8	CloseDate	Close Date
PR03052	NVARCHAR	VSTRING	10	0	10	Operation Type	Operation Type
PR03053	NVARCHAR	VSTRING	10	0	10	Financial Operation Code	Financial Operation Code
PR03054	NVARCHAR	VSTRING	25	0	25	NCM Code	NCM Code
PR03055	NVARCHAR	VSTRING	10	0	10	Product Tax Type	Product Tax Type

Навигация:

Изменение полей в таблицах БД 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