One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table PR03 — Project Activity Transactions

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR03001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR03002 NVARCHAR VSTRING 6 0 6 SubProject Sub-Project   2 Да / Yes
PR03003 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number   3 Да / Yes
PR03004 NVARCHAR VSTRING 6 0 6 ActStrucLine Activity Sub-line Number   4 Да / Yes
PR03005 DATETIME DATE 0 0 8 TransactDate Transaction Date   5 Да / Yes
PR03006 NVARCHAR VSTRING 10 0 10 ResourceCode Resource Code   6 Да / Yes
PR03007 NVARCHAR VSTRING 6 0 6 TransactLine Transaction Line Number   7 Да / Yes
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 120 0 120 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 OperationType Operation Type      
PR03053 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
PR03054 NVARCHAR VSTRING 25 0 25 NCMCode NCM Code      
PR03055 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
PR03056 NCHAR STRING 3 0 3 TaxationReasonCode Taxation Reason Code      

Навигация / Navigation: