пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PR31 — Project Invoice Plan

Таблица / Table: PR31 — «Project Invoice Plan File». Маска имени таблицы / Table name mask: «PR31%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR31001 NCHAR STRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR31002 NCHAR STRING 6 0 6 SubProjectNA Sub-Project   2 Да / Yes
PR31003 NCHAR STRING 4 0 4 LineNo Line Number Line 0000 : Main record defining the invoice model

Line 0001-9998 : Ongoing/Stage Invoice Events

Line 9999 : Final Invoice (Retention)
3 Да / Yes
PR31004 NVARCHAR VSTRING 1 0 1 PR31Spare4 Type of Invoice 0 — Normal Stage Invoice Event

1 — Advance Invoice (Deducted)

2 — Initial Invoice (Not Deducted)

3 — Pretension Invoice
   
PR31005 NVARCHAR VSTRING 1 0 1 PR31Spare5 Deduct Advance Invoice Completely on First Invoice      
PR31006 NVARCHAR VSTRING 1 0 1 PriceModel Price Model 0 — Ongoing

1 — Fixed Price

2 — Repeat Invoice
   
PR31007 NVARCHAR VSTRING 2 0 2 EventNumber Event Type Defined the type of event that will trigger the invoice:

0 — Not active event, will not trigger any invoice.

1 — Date: Invoice is created on specified date

2 — Project started: Invoice is created when the project has actually started (first transaction entered).

3 — Sub-project started: Invoice is created when the sub-project has actually started (first transaction entered for the sub-project defined by PR31008.

4 — Activity started: Invoice is created when the project activity has actually started, first transaction entered for the project activity line defined by PR31008 and PR31009.

5 — Project ended: Invoice is created when the project is closed.

6 — Sub-project ended: Invoice is created when the sub-project defined by PR31008 is closed.

7 — Activity ended: Invoice is created when the activity line defined by PR31008 and PR31009 is closed.

8 — Hours on project: Invoice is created when number of hours defined by PR31010 has been reported for the project.

9 — Hours on sub-project: Invoice is created when number of hours defined by PR31010 has been reported for the sub-project defined by PR31008.

10 — Hours on activity line: Invoice is created when number of hours defined by PR31010 has been reported for the activity line defined by PR31008 and PR31009.

11 — Interval: Invoices will be created on a schedule defined by interval start date, end date, next invoice date and interval between the invoices.

12 — Will print the final invoice for the project clearing all open values, used for fixed price projects.
   
PR31008 NVARCHAR VSTRING 6 0 6 EventSubProj Event Sub Project      
PR31009 NVARCHAR VSTRING 12 0 12 EventActLine Event Activity Line Number      
PR31010 NUMERIC X_NUMERIC 17 8 9 EventNoOfHrs Event Number of Hours      
PR31011 NUMERIC X_NUMERIC 14 8 6 EvenPercOfHr Event Percentage of Hours      
PR31012 NVARCHAR VSTRING 1 0 1 EvenManuInv Event Manual/Automatic Selection Used for ongoing invoicing of transactions:

0 — Transaction are automatically selected to be included on the invoice.

1 — When creating the invoice proposal open transaction are include in the proposal but they are marked to not be included on the invoice. The user must then manually adjust the proposal and select the transaction that shall be included on the invoice.
   
PR31013 NVARCHAR VSTRING 1 0 1 DeductIniInv Deduct Initial invoice      
PR31014 NVARCHAR VSTRING 1 0 1 OngoDebFixPr Ongoing Debiting on Fixed Price Project      
PR31015 DATETIME DATE 0 0 8 EventDate Event Date      
PR31016 NUMERIC MONEY 28 8 20 InvoiceAmt Amount to Invoice (Project Currency) The amount to be invoiced and depending on the invoice type it can have different meaning, like advance amount, fixed price stage invoice amount, etc..    
PR31017 NUMERIC MONEY 28 8 20 FixPriTotal Fixed Price Total (Project Currency) Total fixed price for the project.    
PR31018 NUMERIC MONEY 28 8 20 Spare Fixed Price Amount related to Time Activities (Project Currency) Estimated amount of the total fixed price that is related to time activities.    
PR31019 NUMERIC MONEY 28 8 20 Spare Fixed Price Amount related to Cost Activities (Project Currency) Estimated amount of the total fixed price that is related to cost activities.    
PR31020 NUMERIC MONEY 28 8 20 Spare Fixed Price Amount related to Material (Project Currency) Estimated amount of the total fixed price that is related to material.    
PR31021 NUMERIC X_NUMERIC 14 8 6 FixPriceHrs Fixed Price Time Activities % Estimated percentage of the total fixed price that is related to time activities.    
PR31022 NUMERIC X_NUMERIC 14 8 6 FixPriceCost Fixed Price Cost Activities % Estimated percentage of the total fixed price that is related to cost activities.    
PR31023 NUMERIC X_NUMERIC 14 8 6 FixPriceMat Fixed Price Material % Estimated percentage of the total fixed price that is related to material.    
PR31024 NCHAR STRING 1 0 1 FLAGUpdateInvStatus Update Invoice Status      
PR31025 NVARCHAR VSTRING 4 0 4 RepeatInterv Repeat Interval Defines the invoice interval in days, weeks or month depending on the first character in the string.

No leading character, is for number of days

— as leading character is for month

+ as leading character is for weeks
   
PR31026 DATETIME DATE 0 0 8 RepeaEndDate Repeat End Date      
PR31027 NVARCHAR VSTRING 35 0 35 TextAnnot1 Text Annotation 1      
PR31028 NVARCHAR VSTRING 35 0 35 TextAnnot2 Text Annotation 2      
PR31029 NVARCHAR VSTRING 1 0 1 InvoiceStatus Invoice Status      
PR31030 DATETIME DATE 0 0 8 RepeStarDate Repeat Start Date      
PR31031 DATETIME DATE 0 0 8 RepNxtInvDat Repeat Next Invoice Date      
PR31032 NUMERIC MONEY 28 8 20 CeilingPrice Ceiling Price (Project Currency)      
PR31033 NVARCHAR VSTRING 6 0 6 VATFixPrHrs VAT Code Fixed Price Hours      
PR31034 NVARCHAR VSTRING 6 0 6 VATFixPrCost VAT Code Fixed Price Costs      
PR31035 NVARCHAR VSTRING 6 0 6 VATFixPriMat VAT Code Fixed Price Material      
PR31036 NCHAR STRING 4 0 4 ReverseLinNo Reverse Line Number      
PR31037 NCHAR STRING 2 0 2 PaymentTerm Payment Term      
PR31038 NVARCHAR VSTRING 6 0 6 TaxCode Tax Code Default Tax Code for invoice event    
PR31039 NUMERIC MONEY 28 8 20 DeductedAmountPCU Deducted Amount PCU      
PR31040 NCHAR STRING 3 0 3 TaxationReasonCodeMaterial Taxation Reason Code Material      
PR31041 NCHAR STRING 3 0 3 TaxationReasonCodeCost Taxation Reason Code Cost      
PR31042 NCHAR STRING 3 0 3 TaxationReasonCodeTime Taxation Reason Code Time      
PR31043 NCHAR STRING 3 0 3 TaxationReasonCode Taxation Reason Code      

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