Table 5971 "Filed Contract Line"

Base Application · Microsoft.Service.Contract · captioned “Filed Service Contract Line” · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Filed Service Contract 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	Contract Type Δ BC25 Δ BC28	Enum “Service Contract Type”	Specifies the type of contract that was filed.	enum Enum 5965 “Service Contract Type”
2	Contract No. Δ BC25 Δ BC28	Code[20]	Specifies the number of the service contract or service contract quote that was filed.	TableRelation Table 5970 “Filed Service Contract Header” (“Filed Service Contract Header”.“Contract No.” where(“Contract Type” = field(“Contract Type”)))
3	Line No. Δ BC28	Integer	Specifies the number of the filed contract line.
4	Contract Status Δ BC25	Enum “Service Contract Status”	—	enum Enum 5967 “Service Contract Status”
5	Service Item No. Δ BC25 Δ BC28	Code[20]	Specifies the number of the service item on the filed service contract line.	TableRelation Table 5940 “Service Item” (Service Item)
6	Description Δ BC28	Text[100]	Specifies a description of the service item group associated with the filed service item line.
7	Serial No. Δ BC28	Code[50]	Specifies the serial number of the service item on the filed service item line.
8	Service Item Group Code Δ BC28	Code[10]	Specifies the code for the service item group associated with this service item.	TableRelation Table 5904 “Service Item Group” (Service Item Group)
9	Customer No.	Code[20]	—	TableRelation Table 18 “Customer”
10	Ship-to Code	Code[10]	—	TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Customer No.”)))
11	Item No. Δ BC25 Δ BC28	Code[20]	Specifies the item number linked to the service item in the filed contract.	TableRelation Table 27 “Item” (Item where(Type = const(Inventory)))
12	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 5404 “Item Unit of Measure” (if (“Item No.” = filter(<> ‘’)) “Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”)) else “Unit of Measure”)
13	Response Time (Hours) Δ BC25 Δ BC28	Decimal	Specifies the estimated time interval after work on the service order starts. via Page 6086 “Filed Service Contract Lines”
14	Last Planned Service Date Δ BC28	Date	Specifies the date of the last planned service on this item.	not editable
15	Next Planned Service Date Δ BC28	Date	Specifies the date of the next planned service on this item.
16	Last Service Date Δ BC28	Date	Specifies the date of the last actual service on this item.
17	Last Preventive Maint. Date Δ BC28	Date	Specifies the date when the last time preventative service was performed on this item.	not editable
18	Invoiced to Date Δ BC28	Date	Specifies the date when the contract was last invoiced.	not editable
19	Credit Memo Date Δ BC28	Date	Specifies the date when you can create a credit memo for the item that needs to be removed from the service contract.
20	Contract Expiration Date Δ BC28	Date	Specifies the date when the service item should be removed from the service contract.
21	Service Period Δ BC28	DateFormula	Specifies the estimated time that elapses until service starts on the service item.
22	Line Value Δ BC25 Δ BC28	Decimal	Specifies the value on the service item line in the service contract.
23	Line Discount % Δ BC25 Δ BC28	Decimal	Specifies the discount percentage that is granted for the item on the line.
24	Line Amount Δ BC25 Δ BC28	Decimal	Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
28	Variant Code	Code[10]	—	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”)))
29	Starting Date	Date	—	not editable
30	New Line Δ BC28	Boolean	Specifies that this service contract line is a new line.
31	Credited	Boolean	—
32	Line Cost Δ BC25 Δ BC28	Decimal	Specifies the calculated cost of the item line in the filed service contract or filed service contract quote.
33	Line Discount Amount Δ BC25 Δ BC28	Decimal	Specifies the amount of the discount on the contract line in the filed service contract or filed contract quote.
34	Profit Δ BC25 Δ BC28	Decimal	Specifies the profit on the contract line in the filed service contract or filed contract quote.
80	Attached to Line No. + BC25	Integer	—	TableRelation Table 5971 “Filed Contract Line” (“Filed Contract Line”.“Line No.” where(“Contract Type” = field(“Contract Type”), “Contract No.” = field(“Contract No.”), “Entry No.” = field(“Entry No.”)))
100	Entry No. Δ BC25	Integer	Specifies the unique number of filed service contract or service contract quote.

Keys

Key1: Entry No., Line No. (clustered)

Procedures

ShowComments() + BC25 (internal)

Relations

lookup page Page 6086 “Filed Service Contract Lines”
Customer No.: TableRelation Table 18 “Customer”
Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
Ship-to Code: TableRelation Table 222 “Ship-to Address”
Item No.: TableRelation Table 27 “Item”
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
Service Item Group Code: TableRelation Table 5904 “Service Item Group”
Service Item No.: TableRelation Table 5940 “Service Item”
Contract No.: TableRelation Table 5970 “Filed Service Contract Header”
Attached to Line No.: TableRelation Table 5971 “Filed Contract Line”

Referenced by

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

Table 5971 “Filed Contract Line”: Attached to Line No.

Pages and codeunits on this table

Page 6074 “Filed Service Contract Subform” (source table)
Page 6086 “Filed Service Contract Lines” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Page 6087 “Filed Serv. Contract Cm. Sheet” (1 call: ShowComments → (object))

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Filed Contract Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.