Table "Job Planning Line Archive"
ID 5137
Namespace: Microsoft.Projects.Project.Archive
Properties
| Name | Value |
|---|---|
| Caption | Project Planning Line |
| DrillDownPageID | Page Microsoft.Projects.Project.Archive."Job Planning Archive Lines" |
| LookupPageID | Page Microsoft.Projects.Project.Archive."Job Planning Archive Lines" |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Line No." | Integer | |
| "Job No." | Code[20] | |
| "Planning Date" | Date | |
| "Document No." | Code[20] | |
| Type | Enum Microsoft.Projects.Project.Planning."Job Planning Line Type" | |
| "No." | Code[20] | |
| Description | Text[100] | |
| Quantity | Decimal | |
| "Direct Unit Cost (LCY)" | Decimal | |
| "Unit Cost (LCY)" | Decimal | |
| "Total Cost (LCY)" | Decimal | |
| "Unit Price (LCY)" | Decimal | |
| "Total Price (LCY)" | Decimal | |
| "Resource Group No." | Code[20] | |
| "Unit of Measure Code" | Code[10] | |
| "Qty. Rounding Precision" | Decimal | |
| "Qty. Rounding Precision (Base)" | Decimal | |
| "Location Code" | Code[10] | |
| "Last Date Modified" | Date | |
| "User ID" | Code[50] | |
| "Work Type Code" | Code[10] | |
| "Customer Price Group" | Code[10] | |
| "Country/Region Code" | Code[10] | |
| "Gen. Bus. Posting Group" | Code[20] | |
| "Gen. Prod. Posting Group" | Code[20] | |
| "Document Date" | Date | |
| "Planning Due Date" | Date | |
| "Qty. to Assemble" | Decimal | |
| "Qty. to Assemble (Base)" | Decimal | |
| "Assemble to Order" | Boolean | |
| "BOM Item No." | Code[20] | |
| "Attached to Line No." | Integer | |
| "Job Task No." | Code[20] | |
| "Line Amount (LCY)" | Decimal | |
| "Unit Cost" | Decimal | |
| "Total Cost" | Decimal | |
| "Unit Price" | Decimal | |
| "Total Price" | Decimal | |
| "Line Amount" | Decimal | |
| "Line Discount Amount" | Decimal | |
| "Line Discount Amount (LCY)" | Decimal | |
| "Cost Factor" | Decimal | |
| "Serial No." | Code[50] | |
| "Lot No." | Code[50] | |
| "Line Discount %" | Decimal | |
| "Line Type" | Enum Microsoft.Projects.Project.Planning."Job Planning Line Line Type" | |
| "Currency Code" | Code[10] | |
| "Currency Date" | Date | |
| "Currency Factor" | Decimal | |
| "Schedule Line" | Boolean | |
| "Contract Line" | Boolean | |
| "Job Contract Entry No." | Integer | |
| "Invoiced Amount (LCY)" | Decimal | |
| "Invoiced Cost Amount (LCY)" | Decimal | |
| "VAT Unit Price" | Decimal | |
| "VAT Line Discount Amount" | Decimal | |
| "VAT Line Amount" | Decimal | |
| "VAT %" | Decimal | |
| "Description 2" | Text[50] | |
| "Job Ledger Entry No." | Integer | |
| Status | Enum Microsoft.Projects.Project.Planning."Job Planning Line Status" | |
| "Ledger Entry Type" | Enum Microsoft.Projects.Project.Ledger."Job Ledger Entry Type" | |
| "Ledger Entry No." | Integer | |
| "System-Created Entry" | Boolean | |
| "Usage Link" | Boolean | |
| "Remaining Qty." | Decimal | |
| "Remaining Qty. (Base)" | Decimal | |
| "Remaining Total Cost" | Decimal | |
| "Remaining Total Cost (LCY)" | Decimal | |
| "Remaining Line Amount" | Decimal | |
| "Remaining Line Amount (LCY)" | Decimal | |
| "Qty. Posted" | Decimal | |
| "Qty. to Transfer to Journal" | Decimal | |
| "Posted Total Cost" | Decimal | |
| "Posted Total Cost (LCY)" | Decimal | |
| "Posted Line Amount" | Decimal | |
| "Posted Line Amount (LCY)" | Decimal | |
| "Qty. Transferred to Invoice" | Decimal | |
| "Qty. to Transfer to Invoice" | Decimal | |
| "Qty. Invoiced" | Decimal | |
| "Qty. to Invoice" | Decimal | |
| "Reserved Quantity" | Decimal | |
| "Reserved Qty. (Base)" | Decimal | |
| Reserve | Enum Microsoft.Inventory.Tracking."Reserve Method" | |
| Planned | Boolean | |
| "Version No." | Integer | |
| "Variant Code" | Code[10] | |
| "Bin Code" | Code[20] | |
| "Qty. per Unit of Measure" | Decimal | |
| "Quantity (Base)" | Decimal | |
| "Requested Delivery Date" | Date | |
| "Promised Delivery Date" | Date | |
| "Planned Delivery Date" | Date | |
| "Package No." | Code[50] | |
| "Price Calculation Method" | Enum Microsoft.Pricing.Calculation."Price Calculation Method" | |
| "Cost Calculation Method" | Enum Microsoft.Pricing.Calculation."Price Calculation Method" | |
| "Pick Qty." | Decimal | |
| "Qty. Picked" | Decimal | |
| "Qty. Picked (Base)" | Decimal | |
| "Completely Picked" | Boolean | |
| "Pick Qty. (Base)" | Decimal | |
| "Qty. on Journal" | Decimal | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |