Table 1022 "Job Planning Line Invoice"
Base Application · Microsoft.Projects.Project.Planning
Across versions
- BC23present
- BC244 fields changed
- BC25-26unchanged
- BC272 fields changed
- BC289 fields changed
- BC29-30unchanged
Neighbourhood 8 connected objects and pages
Base Application · Microsoft.Projects.Project.Planning · captioned “Project Planning Line Invoice” · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1029 “Job Invoices” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Project Planning Line Invoice |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Job No. Δ BC24 | Code[20] | Project No. caption | TableRelation Table 167 “Job”; not editable |
| 2 | Job Task No. Δ BC24 | Code[20] | Project Task No. caption | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))); not editable |
| 3 | Job Planning Line No. Δ BC24 | Integer | Project Planning Line No. caption | TableRelation Table 1003 “Job Planning Line” (“Job Planning Line”.“Line No.” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”))); not editable |
| 4 | Document Type Δ BC28 | Enum “Job Planning Line Invoice Document Type” | Specifies the information about the type of document. There are four options: | enum Enum 1022 “Job Planning Line Invoice Document Type”; not editable |
| 5 | Document No. Δ BC28 | Code[20] | Specifies the number associated with the document. For example, if you have created an invoice, the field Specifies the invoice number. | not editable |
| 6 | Line No. Δ BC28 | Integer | Specifies the line number that is linked to the document. Numbers are created sequentially. | |
| 7 | Quantity Transferred Δ BC28 | Decimal | Specifies the quantity transferred from the project planning line to the invoice or credit memo. | not editable |
| 8 | Transferred Date Δ BC28 | Date | Specifies the date on which the invoice or credit document was created. The date is set to the posting date you specified when you created the invoice or credit memo. | not editable |
| 9 | Invoiced Date Δ BC28 | Date | Specifies the date on which the invoice or credit memo was posted. | not editable |
| 10 | Invoiced Amount (LCY) Δ BC27 Δ BC28 | Decimal | Specifies the amount (LCY) that was posted from the invoice or credit memo. The amount is calculated based on Quantity, Line Discount %, and Unit Price. via Page 1029 “Job Invoices” | not editable |
| 11 | Invoiced Cost Amount (LCY) Δ BC27 Δ BC28 | Decimal | Specifies the amount of the unit costs that has been posted from the invoice or credit memo. The amount is calculated based on Quantity, Unit Cost, and Line Discount %. via Page 1029 “Job Invoices” | not editable |
| 12 | Job Ledger Entry No. Δ BC24 Δ BC28 | Integer | Specifies a link to the project ledger entry that was created when the document was posted. | TableRelation Table 169 “Job Ledger Entry” (Job Ledger Entry); not editable |
Keys
- Key1: Job No., Job Task No., Job Planning Line No., Document Type, Document No., Line No. (clustered)
- Key2: Document Type, Document No., Job Ledger Entry No.
- Key3: Job No., Job Planning Line No., Job Task No., Document Type
Events published
OnAfterInitFromJobPlanningLine(var JobPlanningLineInvoice: Record "Job Planning Line Invoice"; JobPlanningLine: Record "Job Planning Line")(integration)
Procedures
InitFromJobPlanningLine(JobPlanningLine: Record "Job Planning Line")InitFromSales(SalesHeader: Record "Sales Header"; PostingDate: Date; LineNo: Integer)
Relations
- drill-down page Page 1029 “Job Invoices”
- lookup page Page 1029 “Job Invoices”
- Job Task No.: TableRelation Table 1001 “Job Task”
- Job Planning Line No.: TableRelation Table 1003 “Job Planning Line”
- Job No.: TableRelation Table 167 “Job”
- Job Ledger Entry No.: TableRelation Table 169 “Job Ledger Entry”
Referenced by
4 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 1003 “Job Planning Line”: Invoiced Amount (LCY), Invoiced Cost Amount (LCY), Qty. Invoiced, Qty. Transferred to Invoice
Pages and codeunits on this table
- Page 1029 “Job Invoices” (source table)
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Job Planning Line Invoice"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.