Table 5137 "Job Planning Line Archive"

Base Application · Microsoft.Projects.Project.Archive · captioned “Project Planning Line” · BC24-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Project Planning Line
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	Line No. Δ BC28	Integer	Specifies the planning line’s entry number.	not editable
2	Job No. Δ BC28	Code[20]	Specifies the number of the related project.	TableRelation Table 5135 “Job Archive” (Job Archive); NotBlank
3	Planning Date Δ BC28	Date	Specifies the date of the planning line. You can use the planning date for filtering the totals of the project, for example, if you want to see the scheduled usage for a specific month of the year.
4	Document No. Δ BC28	Code[20]	Specifies a document number for the planning line.
5	Type Δ BC28	Enum “Job Planning Line Type”	Specifies the type of account to which the planning line relates.	enum Enum 1023 “Job Planning Line Type”
7	No. Δ BC28	Code[20]	Specifies the number of the account to which the resource, item or general ledger account is posted, depending on your selection in the Type field.	TableRelation Table 15 “G/L Account”, Table 156 “Resource”, Table 27 “Item” (if (Type = const(Resource)) Resource else if (Type = const(Item)) Item where(Blocked = const(false)) else if (Type = const(“G/L Account”)) “G/L Account” else if (Type = const(Text)) “Standard Text”)
8	Description Δ BC28	Text[100]	Specifies the name of the resource, item, or G/L account to which this entry applies. You can change the description.
9	Quantity Δ BC28	Decimal	Specifies the number of units of the resource, item, or general ledger account that should be specified on the planning line. If you later change the No., the quantity you have entered remains on the line.
11	Direct Unit Cost (LCY) Δ BC28	Decimal	Specifies the cost, in the local currency, of one unit of the selected item or resource. via Page 5182 “Job Planning Archive Lines”
12	Unit Cost (LCY) Δ BC28	Decimal	Specifies the cost, in LCY, of one unit of the item or resource on the line. via Page 5182 “Job Planning Archive Lines”	not editable
13	Total Cost (LCY) Δ BC28	Decimal	Specifies the total cost for the planning line. The amount is in the local currency. via Page 5182 “Job Planning Archive Lines”	not editable
14	Unit Price (LCY) Δ BC28	Decimal	Specifies the price, in LCY, of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card. via Page 5182 “Job Planning Archive Lines”	not editable
15	Total Price (LCY) Δ BC28	Decimal	Specifies the total price on the planning line. The total price is in the local currency. via Page 5182 “Job Planning Archive Lines”	not editable
16	Resource Group No.	Code[20]	—	TableRelation Table 152 “Resource Group” (Resource Group); not editable
17	Unit of Measure Code Δ BC28	Code[10]	Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.	TableRelation Table 204 “Unit of Measure”, Table 205 “Resource Unit of Measure”, Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else if (Type = const(Resource)) “Resource Unit of Measure”.Code where(“Resource No.” = field(“No.”)) else “Unit of Measure”)
18	Qty. Rounding Precision Δ BC28	Decimal	—	not editable
19	Qty. Rounding Precision (Base) Δ BC28	Decimal	—	not editable
20	Location Code Δ BC28	Code[10]	Specifies a location code for an item.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
29	Last Date Modified	Date	—	not editable
30	User ID Δ BC28	Code[50]	Specifies the ID of the user who posted the entry, to be used, for example, in the change log.	TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation
32	Work Type Code Δ BC28	Code[10]	Specifies which work type the resource applies to. Prices are updated based on this entry.	TableRelation Table 200 “Work Type” (Work Type)
33	Customer Price Group	Code[10]	—	TableRelation Table 6 “Customer Price Group” (Customer Price Group)
79	Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region); not editable
80	Gen. Bus. Posting Group Δ BC28	Code[20]	Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group); not editable
81	Gen. Prod. Posting Group Δ BC28	Code[20]	Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group); not editable
83	Document Date	Date	—
84	Planning Due Date	Date	—
900	Qty. to Assemble Δ BC28	Decimal	—
901	Qty. to Assemble (Base) Δ BC28	Decimal	—
902	Assemble to Order	Boolean	—
903	BOM Item No.	Code[20]	—	TableRelation Table 27 “Item”
904	Attached to Line No.	Integer	—
1000	Job Task No. Δ BC28	Code[20]	Specifies the number of the related project task.	TableRelation Table 5136 “Job Task Archive” (“Job Task Archive”.“Job Task No.” where(“Job No.” = field(“Job No.”))); NotBlank
1001	Line Amount (LCY) Δ BC28	Decimal	Specifies the amount in the local currency that will be posted to the project ledger. via Page 5182 “Job Planning Archive Lines”	not editable
1002	Unit Cost Δ BC28	Decimal	Specifies the cost of one unit of the item or resource on the line.
1003	Total Cost Δ BC28	Decimal	Specifies the total cost for the planning line. The total cost is in the project currency, which comes from the Currency Code field in the Project Card.	not editable
1004	Unit Price Δ BC28	Decimal	Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card.
1005	Total Price Δ BC28	Decimal	Specifies the total price in the project currency on the planning line.	not editable
1006	Line Amount Δ BC28	Decimal	Specifies the amount that will be posted to the project ledger.
1007	Line Discount Amount Δ BC28	Decimal	Specifies the discount amount that is granted for the item on the line.
1008	Line Discount Amount (LCY) Δ BC28	Decimal	—	not editable
1015	Cost Factor Δ BC28	Decimal	—	not editable
1019	Serial No. Δ BC28	Code[50]	Specifies the serial number that is applied to the posted item if the planning line was created from the posting of a project journal line.	not editable
1020	Lot No. Δ BC28	Code[50]	Specifies the lot number that is applied to the posted item if the planning line was created from the posting of a project journal line.	not editable
1021	Line Discount % Δ BC28	Decimal	Specifies the discount percentage that is granted for the item on the line.
1022	Line Type Δ BC28	Enum “Job Planning Line Line Type”	Specifies the type of planning line.	enum Enum 1003 “Job Planning Line Line Type”
1023	Currency Code	Code[10]	—	TableRelation Table 4 “Currency”; not editable
1024	Currency Date Δ BC28	Date	Specifies the date that will be used to find the exchange rate for the currency in the Currency Date field.
1025	Currency Factor Δ BC28	Decimal	—	not editable
1026	Schedule Line	Boolean	Budget Line caption	not editable
1027	Contract Line Δ BC28	Boolean	Specifies whether this line is a billable line.	not editable
1030	Job Contract Entry No. Δ BC28	Integer	Specifies the entry number of the project planning line that the sales line is linked to.	not editable
1035	Invoiced Amount (LCY) Δ BC27 Δ BC28	Decimal	—
1036	Invoiced Cost Amount (LCY) Δ BC27 Δ BC28	Decimal	—
1037	VAT Unit Price Δ BC27	Decimal	—
1038	VAT Line Discount Amount Δ BC27	Decimal	—
1039	VAT Line Amount Δ BC27	Decimal	—
1041	VAT % Δ BC28	Decimal	—
1042	Description 2 Δ BC28	Text[50]	Specifies information in addition to the description.
1043	Job Ledger Entry No.	Integer	Project Ledger Entry No. caption	TableRelation Table 169 “Job Ledger Entry” (Job Ledger Entry); not editable
1048	Status	Enum “Job Planning Line Status”	—	enum Enum 1048 “Job Planning Line Status”; not editable
1050	Ledger Entry Type Δ BC28	Enum “Job Ledger Entry Type”	Specifies the entry type of the project ledger entry associated with the planning line.	enum Enum 1026 “Job Ledger Entry Type”
1051	Ledger Entry No. Δ BC28	Integer	Specifies the entry number of the project ledger entry associated with the project planning line.	TableRelation Table 17 “G/L Entry”, Table 203 “Res. Ledger Entry”, Table 32 “Item Ledger Entry” (if (“Ledger Entry Type” = const(Resource)) “Res. Ledger Entry” else if (“Ledger Entry Type” = const(Item)) “Item Ledger Entry” else if (“Ledger Entry Type” = const(“G/L Account”)) “G/L Entry”)
1052	System-Created Entry Δ BC28	Boolean	Specifies that an entry has been created by Business Central and is related to a project ledger entry. The check box is selected automatically.
1053	Usage Link Δ BC28	Boolean	Specifies whether the Usage Link field applies to the project planning line. When this check box is selected, usage entries are linked to the project planning line. Selecting this check box creates a link to the project planning line from places where usage has been posted, such as the project journ…
1060	Remaining Qty. Δ BC28	Decimal	Specifies the remaining quantity of the resource, item, or G/L Account that remains to complete a project. The quantity is calculated as the difference between Quantity and Qty. Posted.	not editable
1061	Remaining Qty. (Base) Δ BC28	Decimal	—	not editable
1062	Remaining Total Cost Δ BC28	Decimal	Specifies the remaining total cost for the planning line. The total cost is in the project currency, which comes from the Currency Code field in the Project Card.	not editable
1063	Remaining Total Cost (LCY) Δ BC28	Decimal	Specifies the remaining total cost (LCY) for the planning line. The amount is in the local currency. via Page 5182 “Job Planning Archive Lines”	not editable
1064	Remaining Line Amount Δ BC28	Decimal	Specifies the amount that will be posted to the project ledger.	not editable
1065	Remaining Line Amount (LCY) Δ BC28	Decimal	Specifies the amount in the local currency that will be posted to the project ledger. via Page 5182 “Job Planning Archive Lines”	not editable
1070	Qty. Posted Δ BC28	Decimal	Specifies the quantity that has been posted to the project ledger, if the Usage Link check box has been selected.	not editable
1071	Qty. to Transfer to Journal Δ BC28	Decimal	Specifies the quantity you want to transfer to the project journal. Its default value is calculated as quantity minus the quantity that has already been posted, if the Apply Usage Link check box has been selected.
1072	Posted Total Cost Δ BC28	Decimal	Specifies the total cost that has been posted to the project ledger, if the Usage Link check box has been selected.	not editable
1073	Posted Total Cost (LCY) Δ BC28	Decimal	Specifies the total cost (LCY) that has been posted to the project ledger, if the Usage Link check box has been selected. via Page 5182 “Job Planning Archive Lines”	not editable
1074	Posted Line Amount Δ BC28	Decimal	Specifies the amount that has been posted to the project ledger. This field is only filled in if the Apply Usage Link check box selected on the project card.	not editable
1075	Posted Line Amount (LCY) Δ BC28	Decimal	Specifies the amount in the local currency that has been posted to the project ledger. This field is only filled in if the Apply Usage Link check box selected on the project card. via Page 5182 “Job Planning Archive Lines”	not editable
1080	Qty. Transferred to Invoice Δ BC28	Decimal	—
1081	Qty. to Transfer to Invoice Δ BC28	Decimal	Specifies the quantity you want to transfer to the sales invoice or credit memo. The value in this field is calculated as Quantity - Qty. Transferred to Invoice.
1090	Qty. Invoiced Δ BC28	Decimal	—
1091	Qty. to Invoice Δ BC28	Decimal	Specifies the quantity that remains to be invoiced. It is calculated as Quantity - Qty. Invoiced.	not editable
1100	Reserved Quantity Δ BC28	Decimal	Specifies the quantity of the item that is reserved for the project planning line.
1101	Reserved Qty. (Base) Δ BC28	Decimal	—
1102	Reserve Δ BC28	Enum “Reserve Method”	Specifies whether or not a reservation can be made for items on the current line. The field is not applicable if the Type field is set to Resource, Cost, or G/L Account.	enum Enum 100 “Reserve Method”
1103	Planned	Boolean	—	not editable
5047	Version No.	Integer	—
5402	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”), Blocked = const(false)))
5403	Bin Code Δ BC28	Code[20]	Specifies the bin where the selected item will be put away or picked in warehouse and inventory processes. If you specify a bin code in the To-Project Bin Code field on the Location page, that bin will be suggested when you choose the location.	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
5404	Qty. per Unit of Measure Δ BC28	Decimal	—	not editable
5410	Quantity (Base) Δ BC28	Decimal	Specifies the quantity expressed in the base units of measure. via Page 5182 “Job Planning Archive Lines”
5790	Requested Delivery Date	Date	—
5791	Promised Delivery Date	Date	—
5794	Planned Delivery Date Δ BC28	Date	Specifies the date that is planned to deliver the item connected to the project planning line. For a resource, the planned delivery date is the date that the resource performs services with respect to the project.
6515	Package No.	Code[50]	—	not editable
7000	Price Calculation Method Δ BC28	Enum “Price Calculation Method”	Specifies the method that will be used for price calculation in the item journal line.	enum Enum 7000 “Price Calculation Method”
7001	Cost Calculation Method Δ BC28	Enum “Price Calculation Method”	Specifies the method that will be used for cost calculation in the item journal line.	enum Enum 7000 “Price Calculation Method”
7300	Pick Qty. Δ BC28	Decimal	—
7301	Qty. Picked Δ BC28	Decimal	Specifies the quantity of the item you have picked for the project planning line.	not editable
7302	Qty. Picked (Base) Δ BC28	Decimal	Specifies the base quantity of the item you have picked for the project planning line. via Page 5182 “Job Planning Archive Lines”	not editable
7303	Completely Picked	Boolean	—	not editable
7304	Pick Qty. (Base) Δ BC28	Decimal	—
7305	Qty. on Journal Δ BC28	Decimal	—

Keys

Key1: Job No., Job Task No., Version No., Line No. (clustered)

Relations

drill-down page Page 5182 “Job Planning Archive Lines”
lookup page Page 5182 “Job Planning Archive Lines”
Location Code: TableRelation Table 14 “Location”
No.: TableRelation Table 15 “G/L Account” (conditional)
Resource Group No.: TableRelation Table 152 “Resource Group”
No.: TableRelation Table 156 “Resource” (conditional)
Job Ledger Entry No.: TableRelation Table 169 “Job Ledger Entry”
Ledger Entry No.: TableRelation Table 17 “G/L Entry” (conditional)
Work Type Code: TableRelation Table 200 “Work Type”
Ledger Entry No.: TableRelation Table 203 “Res. Ledger Entry” (conditional)
Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
Unit of Measure Code: TableRelation Table 205 “Resource Unit of Measure” (conditional)
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
BOM Item No.: TableRelation Table 27 “Item”
No.: TableRelation Table 27 “Item” (conditional)
Ledger Entry No.: TableRelation Table 32 “Item Ledger Entry” (conditional)
Currency Code: TableRelation Table 4 “Currency”
Job No.: TableRelation Table 5135 “Job Archive”
Job Task No.: TableRelation Table 5136 “Job Task Archive”
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
Customer Price Group: TableRelation Table 6 “Customer Price Group”
No.: TableRelation Table 7 “Standard Text” (conditional)
Bin Code: TableRelation Table 7354 “Bin”
Country/Region Code: TableRelation Table 9 “Country/Region”

Referenced by

12 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 5136 “Job Task Archive”: Contract (Total Cost), Contract (Total Price), End Date, Remaining (Total Cost), Remaining (Total Price), Schedule (Total Cost), Schedule (Total Price), Start Date
Table 5135 “Job Archive”: Completely Picked, Next Invoice Date, Scheduled Res. Gr. Qty., Scheduled Res. Qty.

Pages and codeunits on this table

Page 5182 “Job Planning Archive Lines” (source table)

Extended by

Table extension 6461 “Serv. Job Planning Line Arch.”

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 Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.