|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Project Management - Charged Document Lines Log - Used by Billing Wizard
Table Name: PMG9
Table Description: Project Management - Charged Document Lines Log - Used by Billing Wizard
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | - | Â | Â | Â |
| LineID | Row No. | Int | 11 | - | Â | Â | Â |
| BWRefID | Billing Wizard Reference ID | Int | 11 | - | Â | Â | Â |
| TargetType | Target Document Type | Int | 11 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 15 | Delivery |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoice |
| TargetAbs | Target Document Abs. Entry | Int | 11 | - | Â | Â | Â |
| TargetNum | Target Document Number | Int | 11 | - | Â | Â | Â |
| TargetLine | Target Document Line Number | Int | 11 | - | Â | Â | Â |
| SubProjID | Subproject ID | Int | 11 | - | -1 | Â | Â |
| StageID | Stage ID | Int | 11 | - | Â | Â | Â |
| SourceType | Source Document Type | Int | 11 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 23 | Sales Quotation |
| Â | Â | Â | Â | Â | Â | 17 | Sales Order |
| Â | Â | Â | Â | Â | Â | 13002 | A/R Reserve Invoice |
| Â | Â | Â | Â | Â | Â | 15 | Delivery |
| Â | Â | Â | Â | Â | Â | 33 | Activity |
| Â | Â | Â | Â | Â | Â | 202 | Work Order |
| Â | Â | Â | Â | Â | Â | 234000024 | Timesheet |
| SourceAbs | Source Document Abs. Entry | Int | 11 | - | Â | Â | Â |
| SourceNum | Source Document Number | Int | 11 | - | Â | Â | Â |
| SourceLine | Source Document Line Number | Int | 11 | - | Â | Â | Â |
| Charged | Charged | Num | 19.6 | - | Â | Â | Â |
| ChargedQty | Charged Quantity | Num | 19.6 | - | Â | Â | Â |
| DestType | Destination Table Type | Int | 11 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 234000021 | Project Management Document |
| Â | Â | Â | Â | Â | Â | 234000022 | Project Management Subproject |
| Â | Â | Â | Â | Â | Â | 234000024 | Time Sheet Document |
| DestArr | Destination Table Array | Int | 11 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 1 | Time Sheet Lines |
| Â | Â | Â | Â | Â | Â | 4 | Stage Documents |
| Â | Â | Â | Â | Â | Â | 6 | Stage Activities |
| Â | Â | Â | Â | Â | Â | 7 | Stage Workorders |
| DestAbs | Destination Table Abs. Entry | Int | 11 | - | Â | Â | Â |
| DestLine | Destination Table Line Number | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | BWRefID |
| Â | Â | TargetType |
| Â | Â | TargetAbs |
| Â | Â | LineID |