Таблица: 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 Actual Invoiced Cost LCU 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 (obsolete)      
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 Created For Distribute Revenue Created For Distribute Revenue      
PR03046 NCHAR STRING 1 0 1 SpareFlag2 (obsolete)      
PR03047 NCHAR STRING 10 0 10 InvoiceNo_Customer Customer Code Invoice      
PR03048 NCHAR STRING 9 0 9 GL_Transaction_Line_ID General Ledger Transaction Line Reference      
PR03049 NCHAR STRING 4 0 4 GL_Transaction_Year General Ledger Financial Year      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Project Management | Project Activity Transactions