На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PR41 — Transaction Journal

Таблица / Table: PR41 — «Transaction Journal». Маска имени таблицы / Table name mask: «PR41%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR41001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR41002 NVARCHAR VSTRING 6 0 6 SubProject Sub-Project   2 Да / Yes
PR41003 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number   3 Да / Yes
PR41004 NVARCHAR VSTRING 6 0 6 ActivStruLin Activity Sub-line Number   4 Да / Yes
PR41005 NVARCHAR VSTRING 8 0 8 TransactDate Transaction Date   5 Да / Yes
PR41006 NVARCHAR VSTRING 10 0 10 ResourceCode Resource Code   6 Да / Yes
PR41007 NVARCHAR VSTRING 6 0 6 TransactLine Transaction Line Number   7 Да / Yes
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      
PR41041 NVARCHAR VSTRING 10 0 10 Operation Type Operation Type      
PR41042 NVARCHAR VSTRING 10 0 10 Financial Operation Code Financial Operation Code      
PR41043 NVARCHAR VSTRING 25 0 25 NCM Code NCM Code Nomenclature Number    
PR41044 NVARCHAR VSTRING 10 0 10 Product Tax Type Product Tax Type      
PR41045 NCHAR STRING 3 0 3 Taxation Reason Code Taxation Reason Code      

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