Table 4702 "VAT Group Submission Header"

VATGroupManagement · Microsoft.Finance.VAT.Group · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 4701 “VAT Group Submissions” (1 Learn page), Page 4707 “VAT Group Submission” (1), Page 4708 “VAT Group Submission List” (1).

Properties

Property	Value
Caption	VAT Group Submission Header
LookupPageId	VAT Group Submission

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	ID	Guid	Specifies the record identifier. via Page 4701 “VAT Group Submissions”	DataClassification SystemMetadata
5	No.	Code[20]	Specifies the identifier for the VAT return from the group member that submitted it. via Page 4707 “VAT Group Submission”	DataClassification CustomerContent
6	VAT Group Return No.	Code[20]	—	TableRelation Table 740 “VAT Report Header” (“VAT Report Header”.“No.”); DataClassification CustomerContent
10	Group Member ID	Guid	Specifies the ID of the group member that submitted the VAT report. via Page 4708 “VAT Group Submission List”	TableRelation Table 4700 “VAT Group Approved Member” (VAT Group Approved Member); DataClassification EndUserIdentifiableInformation
15	Group Member Name	Text[250]	Specifies the name of the group member that submitted the VAT report. via Page 4707 “VAT Group Submission”	FlowField: lookup(“VAT Group Approved Member”.“Group Member Name” where(ID = field(“Group Member ID”)))
20	Start Date	Date	Specifies the start date of the report period for the VAT report submission. via Page 4707 “VAT Group Submission”	DataClassification CustomerContent
25	End Date	Date	Specifies the end date of the report period for the VAT report submission. via Page 4707 “VAT Group Submission”	DataClassification CustomerContent
30	Submitted On	DateTime	Specifies the timestamp during which the VAT report was submitted. via Page 4707 “VAT Group Submission”	DataClassification CustomerContent
35	Company	Text[30]	Specifies the company from which the VAT report was submitted. via Page 4707 “VAT Group Submission”	DataClassification OrganizationIdentifiableInformation

Keys

PK: ID (clustered)
Submitted On: Submitted On
No.: No.
VAT Group Return No.: VAT Group Return No.
Dates: Start Date, End Date

Procedures

SetFiltersForLastSubmissionInAPeriod(StartDate: Date; EndDate: Date; SetVATGroupReturnNoFilter: Boolean; VATGroupReturnNo: code[20]) (internal)

Triggers

OnInsert, OnDelete

Relations

lookup page Page 4707 “VAT Group Submission”
Group Member Name: CalcFormula Table 4700 “VAT Group Approved Member”
Group Member ID: TableRelation Table 4700 “VAT Group Approved Member”
VAT Group Return No.: TableRelation Table 740 “VAT Report Header”

Referenced by

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

Table 4701 “VAT Group Calculation”: VAT Group Submission ID, VAT Group Submission No.
Table 4703 “VAT Group Submission Line”: VAT Group Submission ID, VAT Group Submission No.

Pages and codeunits on this table

Page 4701 “VAT Group Submissions” (source table)
Page 4707 “VAT Group Submission” (source table)
Page 4708 “VAT Group Submission List” (source table)

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: "VAT Group Submission Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.