Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PR03 - «Project Activity Transactions». Маска имени таблицы: «PR03%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
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 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Project Activity Transactions