Tax Reporting Data Dictionary

VatReturn__c

Label: VAT Return Report

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Box1Sum__c Box1Sum Pre-Winter 2019 Summary
Box1__c Box1 Pre-Winter 2019 Formula:
Round(Box1Sum__c * (-1), 2)
Number(18,2)
Box2Sum__c Box2Sum Pre-Winter 2019 Summary
Box2__c Box2 Pre-Winter 2019 Formula:
ROUND(Box2Sum__c * (-1), 2)
Number(18,2)
Box3__c Box3 Pre-Winter 2019 Formula:
Box1__c + Box2__c
Number(18,2)
Box4__c Box4 Pre-Winter 2019 Summary
Box5__c Box5 Pre-Winter 2019 Formula:
ABS(Round(Box3__c, 2) - Round(Box4__c, 2))
Number(18,2)
Box6Sum__c Box6Sum Pre-Winter 2019 Summary
Box6__c Box6 Pre-Winter 2019 Formula:
Floor(Box6Sum__c * (-1))
Number(18,2)
Box7RoundedDown__c Box7 Rounded Down Winter 2019 The value of Box 7 rounded down.

Formula:
Floor(Box7__c)
Number(18,2)
Box7__c Box7 Pre-Winter 2019 Summary
Box8Sum__c Box8Sum Pre-Winter 2019 Summary
Box8__c Box8 Pre-Winter 2019 Formula:
Floor(Box8Sum__c * (-1))
Number(18,2)
Box9RoundedDown__c Box9 Rounded Down Winter 2019 The value of Box 9 rounded down.

Formula:
Floor(Box9__c)
Number(18,2)
Box9__c Box9 Pre-Winter 2019 Summary
BusinessActivityStatement__c Business Activity Statement Summer 2023 Business activity statement that relates to the VAT return report.

Looks up to: BusinessActivityStatement__c
Lookup
DateFrom__c Period Start Date Pre-Winter 2019 Date
DateTo__c Period End Date Pre-Winter 2019 Date
GroupOfCompanies__c Group of companies Summer 2019 Checkbox false
IncludeOutdated__c Include Earlier Unreported Transactions Pre-Winter 2019 Checkbox false
IsBas__c Associated with a BAS Summer 2023 If selected, the VAT return report is associated with a business activity statement.

Checkbox false
OwnerCompany__c Company Pre-Winter 2019 Looks up to: c2g__codaCompany__c

Lookup
PeriodAndCompany__c Period and Company Summer 2023 The shortened value of the period and company name, for validation results. Must be unique.

Text(165)
Status__c Status Pre-Winter 2019 Picklist:
Delete Error
Deleted
Deleting
Generated
In Progress
Reconciled
Submitted
SubmissionReceiptReferenceNumber__c Submission Receipt Reference Number Winter 2019 This is the Submission Receipt Reference Number received from HMRC when the VAT return is submitted.

Text(255)
TaxCodeInconsistent__c Inconsistent Tax Codes Summer 2021 Checkbox false
Timestamp__c Timestamp Winter 2019 This timestamp records the date and time that the VAT return was submitted to HMRC.

DateTime
TotalVATReportedTransactions__c Total Tax Reported Transactions Pre-Winter 2019 Summary
Type__c Type Pre-Winter 2019 Picklist:
Cash VAT Accounting
Standard VAT Accounting
VATGroup__c Tax Group Summer 2019 Looks up to: VATGroup__c
Lookup


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.