Table 20500 "Subcontractor Price"

Subcontracting · Microsoft.Manufacturing.Subcontracting · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Subcontractor Price
DataClassification	CustomerContent
LookupPageId	Subcontractor Prices
DrillDownPageId	Subcontractor Prices

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	Vendor No.	Code[20]	Specifies the number of the vendor who offers the line subcontractor price on the item. via Page 20500 “Subcontractor Prices”	TableRelation Table 23 “Vendor”; NotBlank
2	Item No.	Code[20]	Specifies the number of the Item that the subcontractor price applies to. via Page 20500 “Subcontractor Prices”	TableRelation Table 27 “Item”; NotBlank
3	Work Center No.	Code[20]	Specifies the number of the work center that the subcontractor price applies to. via Page 20500 “Subcontractor Prices”	TableRelation Table 99000754 “Work Center” (“Work Center”.“No.” where(“Subcontractor No.” = filter(<> ‘’))); NotBlank
4	Variant Code	Code[10]	Specifies the variant of the item on the line. via Page 20500 “Subcontractor Prices”	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”)))
5	Standard Task Code	Code[10]	Specifies the code of the standard task that the subcontractor price applies to. via Page 20500 “Subcontractor Prices”	TableRelation Table 99000778 “Standard Task” (Standard Task)
6	Starting Date	Date	Specifies the date from which the subcontractor price is valid. via Page 20500 “Subcontractor Prices”
7	Unit of Measure Code	Code[10]	Specifies how each unit of the item is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item card is inserted. via Page 20500 “Subcontractor Prices”	TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”)))
8	Minimum Quantity	Decimal	Specifies the minimum quantity of the item that you must buy from the vendor in order to get the subcontractor price. via Page 20500 “Subcontractor Prices”
9	Currency Code	Code[10]	Specifies the currency code of the subcontractor price. via Page 20500 “Subcontractor Prices”	TableRelation Table 4 “Currency”
10	Direct Unit Cost	Decimal	Specifies the cost of one unit of the selected item. via Page 20500 “Subcontractor Prices”
20	Minimum Amount	Decimal	Specifies the minimum amount, in money, of the item that you must buy from the vendor in order to get the subcontractor price. via Page 20500 “Subcontractor Prices”
30	Ending Date	Date	Specifies the date to which the subcontractor price is valid. via Page 20500 “Subcontractor Prices”

Keys

PK: Vendor No., Item No., Work Center No., Variant Code, Standard Task Code, Starting Date, Unit of Measure Code, Minimum Quantity, Currency Code (clustered)
Key01: Vendor No., Item No., Starting Date, Currency Code, Unit of Measure Code, Minimum Quantity
Key02: Vendor No., Item No., Work Center No., Variant Code, Unit of Measure Code, Currency Code
Key03: Work Center No.
Key04: Item No.

Procedures

CopySubcontractorPriceToVendorsSubcontractorPrice(var SubcontractorPrice: Record "Subcontractor Price"; VendNo: Code[20]; WorkCenterNo: Code[20])
DeletePricesForVendor(VendorNo: Code[20]) (internal)
DeletePricesForWorkCenter(WorkCenterNo: Code[20]) (internal)
DeletePricesForItem(ItemNo: Code[20]) (internal)

Triggers

OnInsert, OnRename

Relations

drill-down page Page 20500 “Subcontractor Prices”
lookup page Page 20500 “Subcontractor Prices”
Vendor No.: TableRelation Table 23 “Vendor”
Item No.: TableRelation Table 27 “Item”
Currency Code: TableRelation Table 4 “Currency”
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Work Center No.: TableRelation Table 99000754 “Work Center”
Standard Task Code: TableRelation Table 99000778 “Standard Task”

Pages and codeunits on this table

Page 20500 “Subcontractor Prices” (source table)

Recent changes

2026-09-01 #10635 [Subcontracting] (Bug: 638998) Add extensibility to Subcontracting app for IT partner migration (main, BC30, feature)
2026-08-18 #9892 [main] Bug 644283: Renumber Subcontracting app object ids as it clashes with partner range (main, BC30, refactor)

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