Table 12126 "Spesometro Appointment" (IT)

IT country layer · Microsoft.Utilities · BC29-30 · source at ea08af5e · facts from BC29

An object of the IT localization, not part of W1.

Properties

Property	Value
Caption	Spesometro Appointment
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	Appointment Code	Code[2]	—	TableRelation “Appointment Code”.Code; NotBlank
2	Vendor No.	Code[20]	—	TableRelation Vendor.“No.”; NotBlank
3	Starting Date	Date	—	NotBlank
4	Ending Date	Date	—
5	Designation	Text[60]	—

Keys

Key1: Appointment Code, Vendor No., Starting Date, Ending Date (clustered)
Key2: Starting Date, Ending Date

Procedures

FormatDate(InputDate: Date): Text
FindAppointmentByDate(FromDate: Date; ToDate: Date): Boolean
GetValueOf(FieldName: Option "First Name","Last Name",Gender,"Date of Birth",Municipality,Province,"Fiscal Code"): Text
IsIndividual(): Boolean
ValidateAppointment()

Plus 2 local procedures.

Triggers

OnInsert

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

A IT country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.