Table 5970 "Filed Service Contract Header"

Base Application · Microsoft.Service.Contract · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Filed Service Contract Header
DataClassification	CustomerContent
Permissions	tabledata “Filed Service Contract Header” = rimd, tabledata “Filed Contract Line” = rimd, tabledata “Filed Serv. Contract Cmt. Line” = rimd, tabledata “Filed Contract Service Hour” = rimd, tabledata “Filed Contract/Serv. Discount” = rimd

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 No. Δ BC28	Code[20]	Specifies the number of the filed service contract or service contract quote.
2	Contract Type Δ BC25 Δ BC28	Enum “Service Contract Type”	Specifies the type of the filed contract or contract quote.	enum Enum 5965 “Service Contract Type”
3	Description Δ BC28	Text[100]	Specifies a description of the filed service contract or contract quote.
4	Description 2	Text[50]	—
5	Status Δ BC25 Δ BC28	Option	Specifies the status of the filed service contract or contract quote.	OptionCaption: ,Signed,Canceled
6	Change Status Δ BC25 Δ BC28	Enum “Service Contract Change Status”	Specifies if the service contract or the service contract quote was open or locked for changes at the moment of filing.	enum Enum 5968 “Service Contract Change Status”
7	Customer No. Δ BC28	Code[20]	Specifies the number of the customer who owns the items in the filed service contract or contract quote.	TableRelation Table 18 “Customer”; NotBlank
8	Name Δ BC28	Text[100]	Specifies the name of the customer in the filed service contract or contract quote.	not editable
9	Address Δ BC28	Text[100]	Specifies the address of the customer in the filed service contract or contract quote.	not editable
10	Address 2 Δ BC28	Text[50]	Specifies additional address information.	not editable
11	Post Code Δ BC28	Code[20]	Specifies the postal code.	TableRelation Table 225 “Post Code” (Post Code); not editable
12	City Δ BC28	Text[30]	Specifies the city of the address.	TableRelation Table 225 “Post Code” (“Post Code”.City); not editable
13	Contact Name Δ BC28	Text[100]	Specifies the name of the person you regularly contact when you do business with the customer in the filed service contract or contract quote.
14	Your Reference Δ BC28	Text[35]	Specifies the customer’s reference number.
15	Salesperson Code Δ BC28	Code[20]	Specifies the code of the salesperson assigned to the filed service contract or contract quote.	TableRelation Table 13 “Salesperson/Purchaser” (“Salesperson/Purchaser” where(Blocked = const(false)))
16	Bill-to Customer No. Δ BC28	Code[20]	Specifies the number of the customer that you send or sent the invoice or credit memo to.	TableRelation Table 18 “Customer”
17	Bill-to Name Δ BC28	Text[100]	Specifies the name of the customer that you send or sent the invoice or credit memo to.	not editable
18	Bill-to Address Δ BC28	Text[100]	Specifies the address of the customer to whom you will send the invoice.	not editable
19	Bill-to Address 2 Δ BC28	Text[50]	Specifies an additional line of the address.	not editable
20	Bill-to Post Code Δ BC28	Code[20]	Specifies the postal code of the customer’s billing address.	TableRelation Table 225 “Post Code” (Post Code); not editable
21	Bill-to City Δ BC28	Text[30]	Specifies the city of the address.	TableRelation Table 225 “Post Code” (“Post Code”.City); not editable
22	Ship-to Code Δ BC28	Code[10]	Specifies a code for an alternate shipment address if you want to ship to another address than the one that has been entered automatically. This field is also used in case of drop shipment.	TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Customer No.”)))
23	Ship-to Name Δ BC28	Text[100]	Specifies the name of the customer at the address that the items are shipped to.	not editable
24	Ship-to Address Δ BC28	Text[100]	Specifies the address that the items are shipped to.	not editable
25	Ship-to Address 2 Δ BC28	Text[50]	Specifies an additional part of the ship-to address, in case it is a long address.	not editable
26	Ship-to Post Code Δ BC28	Code[20]	Specifies the postal code of the address that the items are shipped to.	TableRelation Table 225 “Post Code” (Post Code); not editable
27	Ship-to City Δ BC28	Text[30]	Specifies the city of the address that the items are shipped to.	TableRelation Table 225 “Post Code” (“Post Code”.City); not editable
28	Serv. Contract Acc. Gr. Code Δ BC28	Code[10]	Specifies the code of the service contract account group that the filed service contract is associated with.	TableRelation Table 5973 “Service Contract Account Group” (“Service Contract Account Group”.Code)
32	Invoice Period Δ BC25 Δ BC28	Enum “Service Contract Header Invoice Period”	Specifies the invoice period for the filed service contract or contract quote.	enum Enum 5997 “Service Contract Header Invoice Period”
33	Last Invoice Date Δ BC28	Date	Specifies the invoice date when this filed service contract was last invoiced.	not editable
34	Next Invoice Date Δ BC28	Date	Specifies the next invoice date for this filed service contract or contract quote.
35	Starting Date Δ BC28	Date	Specifies the starting date of the filed service contract or contract quote.
36	Expiration Date Δ BC28	Date	Specifies the date when the filed service contract expires.
38	First Service Date Δ BC28	Date	Specifies the date of the first expected service for the service items in the filed service contract or contract quote.
39	Max. Labor Unit Price Δ BC25 Δ BC28	Decimal	Specifies the maximum unit price that can be set for a resource on all service order lines for to the filed service contract or contract quote.
40	Calcd. Annual Amount Δ BC25 Δ BC28	Decimal	Specifies the sum of the Line Amount field values on all contract lines associated with the filed service contract or contract quote.
42	Annual Amount Δ BC25 Δ BC28	Decimal	Specifies the amount that was invoiced annually before the service contract or contract quote was filed.
43	Amount per Period Δ BC25 Δ BC28	Decimal	Specifies the amount that will be invoiced for each invoice period for the filed service contract or contract quote.	not editable
44	Combine Invoices Δ BC28	Boolean	Specifies you want to combine invoices for this filed service contract with invoices for other service contracts with the same bill-to customer.
45	Prepaid Δ BC28	Boolean	Specifies that this filed service contract or contract quote is prepaid.
46	Next Invoice Period	Text[30]	—	not editable
47	Service Zone Code Δ BC28	Code[10]	Specifies the code of the service zone of the customer’s ship-to address.	TableRelation Table 5957 “Service Zone” (Service Zone)
48	Language Code	Code[10]	—	TableRelation Table 8 “Language”
49	Format Region + BC25	Text[80]	—	TableRelation “Language Selection”.“Language Tag”
50	Cancel Reason Code Δ BC28	Code[10]	Specifies the cancel reason code specified in a service contract or a contract quote at the moment of filing.	TableRelation Table 231 “Reason Code” (Reason Code)
51	Last Price Update Date Δ BC28	Date	Specifies the date when you last updated the service contract prices.	not editable
52	Next Price Update Date Δ BC28	Date	Specifies the next date when you want contract prices to be updated.
53	Last Price Update % Δ BC28	Decimal	Specifies the price update percentage you used when you last updated the contract prices.	not editable
55	Response Time (Hours) Δ BC25 Δ BC28	Decimal	Specifies the default response time for the service items in the filed service contract or contract quote. via Page 6072 “Filed Service Contract”
56	Contract Lines on Invoice Δ BC28	Boolean	Specifies that you want the contract lines for this service contract to appear as text on the invoice created when you invoice the contract.
59	Service Period Δ BC28	DateFormula	Specifies the default service period for the service items in the filed service contract or contract quote.
60	Payment Terms Code Δ BC28	Code[10]	Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount.	TableRelation Table 3 “Payment Terms” (Payment Terms)
62	Invoice after Service Δ BC28	Boolean	Specifies you can only invoice the contract if you have posted a service order since last time you invoiced the contract.
63	Quote Type	Option	—	OptionCaption: Quote 1.,Quote 2.,Quote 3.,Quote 4.,Quote 5.,Quote 6.,Quote 7.,Quote 8.
64	Allow Unbalanced Amounts Δ BC28	Boolean	Specifies whether the Annual Amount field on the contract or quote is modified automatically or manually.
65	Contract Group Code Δ BC28	Code[10]	Specifies the contract group code of the filed service contract or contract quote.	TableRelation Table 5966 “Contract Group” (Contract Group)
66	Service Order Type Δ BC28	Code[10]	Specifies the service order type assigned to service orders linked to this filed service contract or contract quote.	TableRelation Table 5903 “Service Order Type” (Service Order Type)
67	Shortcut Dimension 1 Code Δ BC28	Code[20]	Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
68	Shortcut Dimension 2 Code Δ BC28	Code[20]	Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
69	Accept Before	Date	—
71	Automatic Credit Memos Δ BC28	Boolean	Specifies that you want a credit memo created when you remove a contract line from the filed service contract.
74	Template No.	Code[20]	—
75	Price Update Period Δ BC28	DateFormula	Specifies the price update period for this filed service contract or contract quote.
79	Price Inv. Increase Code Δ BC28	Code[20]	Specifies the standard text code to print on service invoices for this filed service contract, informing the customer which prices have been updated.	TableRelation Table 7 “Standard Text” (Standard Text)
80	Print Increase Text Δ BC28	Boolean	Specifies that the price increase text is printed on invoices for this contract, informing the customer which prices have been updated.
81	Currency Code Δ BC28	Code[10]	Specifies the currency code of the amounts in the filed service contract or contract quote.	TableRelation Table 4 “Currency”
82	No. Series	Code[20]	—	TableRelation Table 308 “No. Series” (No. Series)
83	Probability Δ BC28	Decimal	—
84	Comment + BC25	Boolean	—	FlowField: exist(“Filed Serv. Contract Cmt. Line” where(“Entry No.” = field(“Entry No.”))); not editable
85	Responsibility Center Δ BC28	Code[10]	Specifies the code of the responsibility center, such as a distribution hub, that is associated with the involved user, company, customer, or vendor.	TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
86	Phone No. Δ BC28	Text[30]	Specifies the customer phone number.
87	Fax No.	Text[30]	—
88	E-Mail Δ BC28	Text[80]	Specifies the customer’s email address.
89	Bill-to County	Text[30]	—
90	County	Text[30]	—
91	Ship-to County	Text[30]	—
92	Country/Region Code Δ BC28	Code[10]	Specifies the country/region of the address.	TableRelation Table 9 “Country/Region” (Country/Region)
93	Bill-to Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
94	Ship-to Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
95	Name 2	Text[50]	—	not editable
96	Bill-to Name 2	Text[50]	—	not editable
97	Ship-to Name 2	Text[50]	—	not editable
98	Next Invoice Period Start	Date	—	not editable
99	Next Invoice Period End	Date	—	not editable
100	Entry No. Δ BC25	Integer	Specifies the unique number of filed service contract or service contract quote.
101	File Date Δ BC28	Date	Specifies the date when service contract or contract quote is filed.
102	File Time Δ BC28	Time	Specifies the time when the service contract or contract quote is filed.
103	Filed By Δ BC28	Code[50]	Specifies the name of the user who filed the service contract.	TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
104	Reason for Filing Δ BC28	Option	Specifies the reason for filing the service contract or contract quote.	OptionCaption: ,Contract Signed,Contract Canceled
105	Contract Type Relation	Enum “Service Contract Type”	—	enum Enum 5965 “Service Contract Type”
106	Contract No. Relation	Code[20]	—	TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = field(“Contract Type Relation”)))
109	No. of Filed Versions + BC25	Integer	—	FlowField: max(“Filed Service Contract Header”.“Entry No.” where(“Contract Type Relation” = field(“Contract Type Relation”), “Contract No. Relation” = field(“Contract No. Relation”))); not editable
110	Restorable + BC25	Boolean	—
111	Source Contract Exists + BC25	Boolean	—	FlowField: exist(“Service Contract Header” where(“Contract Type” = field(“Contract Type Relation”), “Contract No.” = field(“Contract No. Relation”))); not editable
112	Last Filed DateTime + BC25	DateTime	—	FlowField: max(“Filed Service Contract Header”.SystemCreatedAt where(“Contract Type Relation” = field(“Contract Type Relation”), “Contract No. Relation” = field(“Contract No. Relation”))); not editable
204	Payment Method Code + BC25 Δ BC28	Code[10]	Specifies how to make payment, such as with bank transfer, cash, or check.	TableRelation Table 289 “Payment Method” (Payment Method)
210	Ship-to Phone No. + BC25 Δ BC28	Text[30]	Specifies the telephone number of the company’s shipping address.
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
1200	Direct Debit Mandate ID + BC25 Δ BC28	Code[35]	Specifies the direct-debit mandate that the customer has signed to allow direct-debit collection of payments.	TableRelation Table 1230 “SEPA Direct Debit Mandate” (“SEPA Direct Debit Mandate” where(“Customer No.” = field(“Bill-to Customer No.”))); DataClassification SystemMetadata
5050	Contact No. Δ BC25 Δ BC28	Code[20]	Specifies the number of the contact who will receive the service contract delivery.	TableRelation Table 5050 “Contact”
5051	Bill-to Contact No. Δ BC25 Δ BC28	Code[20]	Specifies the number of the contact person at the customer’s billing address.	TableRelation Table 5050 “Contact”
5052	Bill-to Contact Δ BC28	Text[100]	Specifies the name of the contact person at the customer’s billing address.
5053	Last Invoice Period End + BC25	Date	—

Keys

Key1: Entry No. (clustered)
Key2: Contract Type Relation, Contract No. Relation, File Date, File Time
Key3: Contract Type, Contract No.

Events published

OnAfterFileContract(var FiledServiceContractHeader: Record "Filed Service Contract Header"; ServiceContractHeader: Record "Service Contract Header") (integration)
OnFileContractOnBeforeFiledServContractHeaderInsert(var ServiceContractHeader: Record "Service Contract Header"; var FiledServiceContractHeader: Record "Filed Service Contract Header") (integration)
OnFileContractOnBeforeFiledContractLineTransferFields(var ServiceContractLine: Record "Service Contract Line") + BC25 (integration)

Trigger event subscribers

OnBeforeInsertEvent: Codeunit 5999 “Service Experience Tier” BlockInsertFiledServiceContractHeader

Procedures

GetLastEntryNo(): Integer
FileContract(ServiceContractHeader: Record "Service Contract Header") Δ BC25
FileQuotationBeforeSigning(ServiceContractHeader: Record "Service Contract Header") Δ BC25
FileContractBeforeCancellation(ServiceContractHeader: Record "Service Contract Header") Δ BC25
NextInvoicePeriod(): Text[250]
SetSecurityFilterOnResponsibilityCenter() + BC25 (internal)

Plus 4 local procedures.

Triggers

OnDelete

Relations

drill-down page Page 6073 “Filed Service Contract List”
lookup page Page 6073 “Filed Service Contract List”
Direct Debit Mandate ID: TableRelation Table 1230 “SEPA Direct Debit Mandate”
Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
Bill-to Customer No.: TableRelation Table 18 “Customer”
Customer No.: TableRelation Table 18 “Customer”
Ship-to Code: TableRelation Table 222 “Ship-to Address”
Bill-to City: TableRelation Table 225 “Post Code”
Bill-to Post Code: TableRelation Table 225 “Post Code”
City: TableRelation Table 225 “Post Code”
Post Code: TableRelation Table 225 “Post Code”
Ship-to City: TableRelation Table 225 “Post Code”
Ship-to Post Code: TableRelation Table 225 “Post Code”
Cancel Reason Code: TableRelation Table 231 “Reason Code”
Payment Method Code: TableRelation Table 289 “Payment Method”
Payment Terms Code: TableRelation Table 3 “Payment Terms”
No. Series: TableRelation Table 308 “No. Series”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Currency Code: TableRelation Table 4 “Currency”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Bill-to Contact No.: TableRelation Table 5050 “Contact”
Contact No.: TableRelation Table 5050 “Contact”
Responsibility Center: TableRelation Table 5714 “Responsibility Center”
Service Order Type: TableRelation Table 5903 “Service Order Type”
Service Zone Code: TableRelation Table 5957 “Service Zone”
Source Contract Exists: CalcFormula Table 5965 “Service Contract Header”
Contract No. Relation: TableRelation Table 5965 “Service Contract Header”
Contract Group Code: TableRelation Table 5966 “Contract Group”
Last Filed DateTime: CalcFormula Table 5970 “Filed Service Contract Header”
No. of Filed Versions: CalcFormula Table 5970 “Filed Service Contract Header”
Serv. Contract Acc. Gr. Code: TableRelation Table 5973 “Service Contract Account Group”
Comment: CalcFormula Table 5974 “Filed Serv. Contract Cmt. Line”
Price Inv. Increase Code: TableRelation Table 7 “Standard Text”
Language Code: TableRelation Table 8 “Language”
Bill-to Country/Region Code: TableRelation Table 9 “Country/Region”
Country/Region Code: TableRelation Table 9 “Country/Region”
Ship-to Country/Region Code: TableRelation Table 9 “Country/Region”

Referenced by

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

Table 5970 “Filed Service Contract Header”: Last Filed DateTime, No. of Filed Versions
Table 5971 “Filed Contract Line”: Contract No.
Table 5974 “Filed Serv. Contract Cmt. Line”: No.
Table 5975 “Filed Contract Service Hour”: Service Contract No.
Table 5976 “Filed Contract/Serv. Discount”: Contract No.

Pages and codeunits on this table

Page 6072 “Filed Service Contract” (source table)
Page 6073 “Filed Service Contract List” (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.

Codeunit 447 “Record Link Management” (3 calls: FileContract → CopyLinks, FileServiceContractContractServDiscounts → CopyLinks, FileServiceContractServiceHours → CopyLinks)
Codeunit 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
Codeunit 5700 “User Setup Management” (1 call: SetSecurityFilterOnResponsibilityCenter → GetServiceFilter)
Codeunit 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)

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