One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table PR45 — Invoice Statistics Head

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR45001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR45002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да / Yes
PR45003 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
PR45004 NVARCHAR VSTRING 12 0 12 MainProjNo Main Project Number      
PR45005 NVARCHAR VSTRING 10 0 10 CustCodeInv Customer Code Invoice      
PR45006 NVARCHAR VSTRING 25 0 25 ObjProjName Project Name      
PR45007 NVARCHAR VSTRING 2 0 2 ProjectType Project Type      
PR45008 NVARCHAR ACCSTR 120 0 120 AccounString Accounting String      
PR45009 NVARCHAR VSTRING 3 0 3 Salesman Salesman      
PR45010 NVARCHAR VSTRING 1 0 1 PrModelInvo Price Model 0 — Ongoing

1 — Fixed Price

2 — Repeat Invoice
   
PR45011 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
PR45012 NVARCHAR VSTRING 10 0 10 Manager Resource Code Manager      
PR45013 NVARCHAR VSTRING 20 0 20 UserDefined1 User Defined Field 1      
PR45014 NVARCHAR VSTRING 10 0 10 UserDefined2 User Defined Field 2      
PR45015 NVARCHAR VSTRING 10 0 10 UserDefined3 User Defined Field 3      
PR45016 NVARCHAR VSTRING 8 0 8 UserDefined4 User Defined Field 4      
PR45017 NVARCHAR VSTRING 8 0 8 UserDefined5 User Defined Field 5      
PR45018 NVARCHAR VSTRING 4 0 4 UserDefined6 User Defined Field 6      
PR45019 NVARCHAR VSTRING 4 0 4 UserDefined7 User Defined Field 7      
PR45020 NVARCHAR VSTRING 2 0 2 UserDefined8 User Defined Field 8      
PR45021 NVARCHAR VSTRING 2 0 2 UserDefined9 User Defined Field 9      
PR45022 NVARCHAR VSTRING 1 0 1 UserDefine10 User Defined Field 10      
PR45023 NVARCHAR VSTRING 4 0 4 ProjCategory Project Category      
PR45024 NVARCHAR VSTRING 10 0 10 CustCodeOrd Customer Code Order      
PR45025 NVARCHAR VSTRING 8 0 8 UserGroup User Group      
PR45026 NVARCHAR VSTRING 10 0 10 CustCodeDeli Customer Code Delivery      
PR45027 NVARCHAR VSTRING 30 0 30 CustPOno Customer Purchase Order Number      
PR45028 NVARCHAR VSTRING 1 0 1 InvTypeStat Invoice Type 0 — Initial invoice

1 — Ongoing invoice

2 — Fixed price invoice (ongoing)

3 — Fixed price invoice (invoice plan)

4 — Final invoice (retention)

5 — Repeat invoice

6 — Fixed price invoice (final invoice)
   
PR45029 NUMERIC MONEY 28 8 20 InvoicedAmou Invoiced Amount (Project Currency)      
PR45030 NVARCHAR VSTRING 35 0 35 TextAnnotat1 Text Annotation Line 1      
PR45031 NVARCHAR VSTRING 35 0 35 TextAnnotat2 Text Annotation Line 2      
PR45032 NUMERIC MONEY 28 8 20 AmoNoInFxPri Amount Not Included in Fixed Price (Project Currency)      
PR45033 NUMERIC MONEY 28 8 20 FixedPricTim Fixed Price Time Activities (Project Currency)      
PR45034 NUMERIC MONEY 28 8 20 FixePricCost Fixed Price Cost Activities (Project Currency)      
PR45035 NUMERIC MONEY 28 8 20 FixPricMtrl Fixed Price Material (Project Currency)      
PR45036 NUMERIC MONEY 28 8 20 DeduAdvInvo Deducted Advance Amount (Project Currency)      
PR45037 NUMERIC MONEY 28 8 20 DeduRetenInv Deducted Retention Amount (Project Currency)      
PR45038 NUMERIC MONEY 28 8 20 DeduCeilPric Deducted Ceiling Overrun Amount (Project Currency)      
PR45039 NVARCHAR VSTRING 7 0 7 SortOrder Sort Order      
PR45040 NVARCHAR VSTRING 1 0 1 DetailLevel Detail Level Value from 1-7 indicating which level in the sort order that should be used as last summary level.    
PR45041 NUMERIC X_NUMERIC 28 8 20 CurrExcRate Currency Exchange Rate      
PR45042 NUMERIC X_NUMERIC 18 8 10 FixedExchangeRate2 Fixed Exchange Rate 2      
PR45043 NCHAR STRING 3 0 3 FixedXchgRateAlgor Fixed Exchange Rate Algorithm      
PR45044 NCHAR STRING 6 0 6 TaxLiability Tax Liability      

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

Добавить комментарий