пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Project Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PR03 — Project Activity Transactions

Таблица: 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      

Навигация: