Таблица: PR31 - «Project Invoice Plan File». Маска имени таблицы: «PR31%cc00»
|Поле||Тип поля||Тип поля Scala||Длина поля||Точность||Длина Scala||Комментарий||Расширенный комментарий||Дополнительное описание||Позиция в индексе||Первичный ключ?|
|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)
|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|
|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|
|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||Payment Term||Payment Term|
|PR31038||NVARCHAR||VSTRING||6||0||6||Tax Code||Tax Code||Default Tax Code for invoice event|
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Project Management | Project Invoice Plan