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

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table PR46 — Invoice Statistics Lines

Таблица / Table: PR46 — «Invoice Statistics Lines». Маска имени таблицы / Table name mask: «PR46%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR46001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR46002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да / Yes
PR46003 NVARCHAR VSTRING 6 0 6 LineNumber Line Number   3 Да / Yes
PR46004 NVARCHAR VSTRING 6 0 6 SubProject Sub-Project      
PR46005 NVARCHAR VSTRING 35 0 35 DescrSubProj Description Sub-Project      
PR46006 NVARCHAR VSTRING 10 0 10 ManagSubProj Manager Sub-Project      
PR46007 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number      
PR46008 NVARCHAR VSTRING 6 0 6 ActivStrLine Activity Sub-line Number      
PR46009 NVARCHAR VSTRING 6 0 6 ActivCode Activity Code      
PR46010 NVARCHAR VSTRING 1 0 1 TypeOfActiv 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		    
PR46011 NVARCHAR VSTRING 35 0 35 DescActiLine Description Activity Line      
PR46012 NVARCHAR VSTRING 10 0 10 ManaActiLine Manager Activity Line      
PR46013 NVARCHAR VSTRING 1 0 1 InclFixPrice Is Included in Fixed Price      
PR46014 NVARCHAR VSTRING 8 0 8 ReportCode Report Code Transaction      
PR46015 NVARCHAR VSTRING 1 0 1 LinkedModule Linked Module Only used for activity type 0 and 2:

0 — Purchase Order

1 — Sales Order		    
PR46016 NVARCHAR VSTRING 10 0 10 LinkedOrdNo Linked Order Number      
PR46017 DATETIME DATE 0 0 8 TransactDate Transaction Date      
PR46018 NVARCHAR VSTRING 10 0 10 ResourceCode Resource Code      
PR46019 NUMERIC X_NUMERIC 20 8 12 InvcdHrsQty Invoiced Quantity/Hours      
PR46020 NUMERIC MONEY 28 8 20 InvoicePrice Unit Price Invoiced (Project Currency)      
PR46021 NUMERIC MONEY 28 8 20 Cost Unit Cost (Local Currency)      
PR46022 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		    
PR46023 NVARCHAR ACCSTR 120 0 120 AccounString Accounting String      
PR46024 NVARCHAR VSTRING 6 0 6 VATcode VAT Code      
PR46025 NVARCHAR VSTRING 6 0 6 LinkActiLine Linked Activity Line Number      
PR46026 NVARCHAR VSTRING 6 0 6 LnkActStrLin Linked Activity Sub-line Number      
PR46027 NVARCHAR VSTRING 1 0 1 DateType012 Date Type Time reported as per:

0 — Date

1 — Week

2 — Month		    
PR46028 NUMERIC X_NUMERIC 20 8 12 ActuHrsQty Actual Quantity/Hours      
PR46029 NCHAR STRING 6 0 6 TransactionNoAct Activity Transaction Line      
PR46030 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      

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