Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PR41 - «Transaction Journal». Маска имени таблицы: «PR41%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR41001 | NVARCHAR | VSTRING | 12 | 0 | 12 | ProjectNo | Project Number | 1 | Да | |
PR41002 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubProject | Sub-Project | 2 | Да | |
PR41003 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityLine | Activity Line Number | 3 | Да | |
PR41004 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivStruLin | Activity Sub-line Number | 4 | Да | |
PR41005 | NVARCHAR | VSTRING | 8 | 0 | 8 | TransactDate | Transaction Date | 5 | Да | |
PR41006 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceCode | Resource Code | 6 | Да | |
PR41007 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransactLine | Transaction Line Number | 7 | Да | |
PR41008 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivCode | Activity Code | |||
PR41009 | NVARCHAR | VSTRING | 1 | 0 | 1 | CostCode | Cost Category | |||
PR41010 | NVARCHAR | VSTRING | 35 | 0 | 35 | Text | Text | |||
PR41011 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyActual | Quantity/Hours Reported | |||
PR41012 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyForInvoic | Quantity/Hours to Invoice | |||
PR41013 | NUMERIC | MONEY | 28 | 8 | 20 | Price | Unit Price (Project Currency) | |||
PR41014 | NUMERIC | MONEY | 28 | 8 | 20 | PriceForInv | Unit Price to Invoice (Project Currency) | |||
PR41015 | NUMERIC | MONEY | 28 | 8 | 20 | Cost | Unit Cost (Local Currency) | |||
PR41016 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Markup | Mark-up % | |||
PR41017 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | TimeLeftActi | Estimated % to Completion | Indicates the percentage that remains to complete the activity. This estimate is entered by the user when reporting time activities. | ||
PR41018 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccounString | Accounting String | |||
PR41019 | NUMERIC | MONEY | 28 | 8 | 20 | WIPAmount | WIP Transaction Amount (Local Currency) | |||
PR41020 | NVARCHAR | VSTRING | 10 | 0 | 10 | Manager | Resource Code Manager | |||
PR41021 | NVARCHAR | VSTRING | 1 | 0 | 1 | ActivityType | Activity Type | 0 - Cost Activity
1 - Time Activity 2 - Material Activity (Sales Order or Purchase Order) 5 - Linked Sales Order 6 - Linked Purchase Order 7 - Linked Service Order 8 - Linked Contract 9 - Linked Work Order |
||
PR41022 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | Currency Code | |||
PR41023 | NVARCHAR | VSTRING | 6 | 0 | 6 | LnkTimActLne | Linked Activity Line Number | |||
PR41024 | NVARCHAR | VSTRING | 6 | 0 | 6 | LnkTiAcStrLn | Linked Activity Sub-line Number | |||
PR41025 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
PR41026 | 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. | ||
PR41027 | NVARCHAR | VSTRING | 1 | 0 | 1 | ConfirmManag | Is Confirmed by User | |||
PR41028 | NVARCHAR | VSTRING | 10 | 0 | 10 | EnterByUser | Created By | |||
PR41029 | NVARCHAR | VSTRING | 10 | 0 | 10 | ConfByUser | Confirmed By | |||
PR41030 | NVARCHAR | VSTRING | 1 | 0 | 1 | DateType | Date Type | Time reported as per:
0 - Date 1 - Week 2 - Month |
||
PR41031 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TimLeftActiv | Estimated Hours to Completion | Indicates the number of hours that remains to complete the activity. This estimate is entered by the user when reporting time activities. | ||
PR41032 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAGGLTrans | General Ledger Transaction Flag | Used for transactions updated/entered from general ledger:
0 - When updating from general ledger, WIP will be booked according to the accounting rules on the project 1 - When updating from general ledger, WIP will be directly reversed. 2 - Used for transactions preliminary entered in general ledger, these will not be included when printing/updating the transaction journal. |
||
PR41033 | NCHAR | STRING | 10 | 0 | 10 | ORInvoiceCustomer | Customer Code Invoice (Sales Order) | |||
PR41034 | NCHAR | STRING | 9 | 0 | 9 | GLTransactionLineID | General Ledger Transaction Line Reference | |||
PR41035 | NCHAR | STRING | 4 | 0 | 4 | GLTransactionYear | General Ledger Financial Year | |||
PR41036 | NVARCHAR | VSTRING | 42 | 0 | 42 | TerminalNo | Terminal Number | Terminal number, used internally for preliminary transactions entered in general ledger. | ||
PR41037 | NVARCHAR | VSTRING | 6 | 0 | 6 | MasterLine | Master Line Number | Master line number, used internally for preliminary transactions entered in general ledger. | ||
PR41038 | NCHAR | STRING | 2 | 0 | 2 | JournalNumber | Journal Number | |||
PR41039 | NCHAR | STRING | 7 | 0 | 7 | JournalLine | Journal Line Number | |||
PR41040 | NCHAR | STRING | 9 | 0 | 9 | GLTransactionLineCounter | General Ledger Line Counter |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Transaction Journal