VAT Report Setup #743

Other table in Microsoft Dynamics 365 Business Central. 44 fields, 1 records in Cronus demo.

44
Fields
1
Records
1
Primary key
4
FlowFields
12
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Primary key.

All fields (44)

VAT Report Setup — FIELDS
NO.FIELDTYPECLASSRELATION
1 Primary key PK Code Normal
2 No. Series Code Normal → No. Series #308
3 Allow Modification Boolean Normal
4 VAT Return No. Series Code Normal → No. Series #308
20 VAT Return Period No. Series Code Normal → No. Series #308
21 Report Version Code Normal → VAT Reports Configuration #746
23 Update Period Job Frequency Option Normal
24 Manual Receive Period CU ID Integer Normal
25 Manual Receive Period CU Cap ⚡ FLOW Text FlowField
26 Auto Receive Period CU ID Integer Normal
27 Auto Receive Period CU Cap ⚡ FLOW Text FlowField
28 Receive Submitted Return CU ID Integer Normal
29 Receive Submitted Return CUCap ⚡ FLOW Text FlowField
30 Period Reminder Calculation DateFormula Normal
31 Report VAT Base Boolean Normal
32 Report VAT Note Boolean Normal
4700 VAT Group Role Option Normal
4701 Approved Members ⚡ FLOW Integer FlowField
4702 Group Member ID GUID Normal
4703 Group Representative API URL Text Normal
4705 User Name Key GUID Normal
4706 Web Service Access Key Key GUID Normal
4707 Group Representative Company Text Normal
4708 Client ID Key GUID Normal
4709 Client Secret Key GUID Normal
4710 OAuth 2.0 Authority URL Text Normal
4711 OAuth 2.0 Resource URL Text Normal
4712 OAuth 2.0 Redirect URL Text Normal
4713 Group Representative Uses Business Central Online Boolean Normal
4714 Group Settlement Account Code Normal → G/L Account #15
4715 VAT Settlement Account Code Normal → G/L Account #15
4716 VAT Due Box No. Text Normal
4717 Group Settlement General Journal Template Code Normal → Gen. Journal Template #80
4718 Group Representative Product Version Option Normal
4719 Authentication Type Option Normal
10530 MTD OAuth Setup Option Option Normal
10531 MTD Gov Test Scenario Text Normal
10539 Enabled Boolean Normal
10540 User IP Address Service Text Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (6)

Tables referenced by fields on the VAT Report Setup table through TableRelation properties.

No. Series
#308 · Other · via No. Series, VAT Return No. Series, VAT Return Period No. Series
VAT Reports Configuration
#746 · Other · via Report Version
G/L Account
#15 · General Ledger · via Group Settlement Account, VAT Settlement Account
Gen. Journal Template
#80 · Other · via Group Settlement General Journal Template