|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Project Management - Summary
Table Name: PMG8
Table Description: Project Management - Summary
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | - | Â | Â | Â |
| LineID | Row No. | Int | 11 | - | Â | Â | Â |
| PhBudget | Subproject Budget | Num | 19.6 | - | Â | Â | Â |
| OpenAmtAP | Open Amount (A/P) | Num | 19.6 | - | Â | Â | Â |
| InvoicedAP | Invoiced (A/P) | Num | 19.6 | - | Â | Â | Â |
| TotalAP | Total (A/P) | Num | 19.6 | - | Â | Â | Â |
| TotVarAP | Total Variance (A/P) | Num | 19.6 | - | Â | Â | Â |
| VarPercAP | Variance Percentage (A/P) | Num | 19.6 | - | Â | Â | Â |
| AccPhBudg | Accumulated Subproject Budget | Num | 19.6 | - | Â | Â | Â |
| AccOpAmAP | Accumulated Open Amount (A/P) | Num | 19.6 | - | Â | Â | Â |
| AccInvAP | Accumulated Invoiced (A/P) | Num | 19.6 | - | Â | Â | Â |
| AccTotAP | Accumulated Total (A/P) | Num | 19.6 | - | Â | Â | Â |
| AccTVarAP | Accumulated Total Variance (A/P) | Num | 19.6 | - | Â | Â | Â |
| AccVPercAP | Accumulated Variance Percentage (A/P) | Num | 19.6 | - | Â | Â | Â |
| PoPhAmt | Potential Subproject Amount | Num | 19.6 | - | Â | Â | Â |
| OpenAmtAR | Open Amount (A/R) | Num | 19.6 | - | Â | Â | Â |
| InvoicedAR | Invoiced (A/R) | Num | 19.6 | - | Â | Â | Â |
| TotalAR | Total (A/R) | Num | 19.6 | - | Â | Â | Â |
| TotVarAR | Total Variance (A/R) | Num | 19.6 | - | Â | Â | Â |
| VarPercAR | Variance Percentage (A/R) | Num | 19.6 | - | Â | Â | Â |
| AccPoPhAmt | Accumulated Potential Subproject Amount | Num | 19.6 | - | Â | Â | Â |
| AccOpAmAR | Accumulated Open Amount (A/R) | Num | 19.6 | - | Â | Â | Â |
| AccInvAR | Accumulated Invoiced (A/R) | Num | 19.6 | - | Â | Â | Â |
| AccTotAR | Accumulated Total (A/R) | Num | 19.6 | - | Â | Â | Â |
| AccTVarAR | Accumulated Total Variance (A/R) | Num | 19.6 | - | Â | Â | Â |
| AccVPercAR | Accumulated Variance Percentage (A/R) | Num | 19.6 | - | Â | Â | Â |
| ActICCost | Actual Item Component Cost | Num | 19.6 | - | Â | Â | Â |
| ActRCCost | Actual Resource Component Cost | Num | 19.6 | - | Â | Â | Â |
| ActAddCost | Actual Additional Cost | Num | 19.6 | - | Â | Â | Â |
| ActPrCost | Actual Product Cost | Num | 19.6 | - | Â | Â | Â |
| ActBPrCost | Actual By-Product Cost | Num | 19.6 | - | Â | Â | Â |
| TotalVar | Total Variance | Num | 19.6 | - | Â | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| CloseDate | Actual Closing Date | Date | 8 | - | Â | Â | Â |
| Overdue | Overdue | Int | 11 | - | 0 | Â | Â |
| Valid | If the calculated data is valid | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineID |