Tax Reporting Data Dictionary

ffvat__VatReturn__c

Label: VAT Return Report

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
ffvat__Box1Sum__c Box1Sum Pre-Winter 2019 Summary
ffvat__Box1__c Box1 Pre-Winter 2019 Formula:
Round(ffvat__Box1Sum__c * (-1), 2)
Number(18,2) false
ffvat__Box2Sum__c Box2Sum Pre-Winter 2019 Summary
ffvat__Box2__c Box2 Pre-Winter 2019 Formula:
ROUND(ffvat__Box2Sum__c * (-1), 2)
Number(18,2) false
ffvat__Box3__c Box3 Pre-Winter 2019 Formula:
ffvat__Box1__c + ffvat__Box2__c
Number(18,2) false
ffvat__Box4__c Box4 Pre-Winter 2019 Summary
ffvat__Box5__c Box5 Pre-Winter 2019 Formula:
ABS(Round(ffvat__Box3__c, 2) - Round(ffvat__Box4__c, 2))
Number(18,2) false
ffvat__Box6Sum__c Box6Sum Pre-Winter 2019 Summary
ffvat__Box6__c Box6 Pre-Winter 2019 Formula:
Floor(ffvat__Box6Sum__c * (-1))
Number(18,2) false
ffvat__Box7RoundedDown__c Box7 Rounded Down Winter 2019 The value of Box 7 rounded down.

Formula:
Floor(ffvat__Box7__c)
Number(18,2) false
ffvat__Box7__c Box7 Pre-Winter 2019 Summary
ffvat__Box8Sum__c Box8Sum Pre-Winter 2019 Summary
ffvat__Box8__c Box8 Pre-Winter 2019 Formula:
Floor(ffvat__Box8Sum__c * (-1))
Number(18,2) false
ffvat__Box9RoundedDown__c Box9 Rounded Down Winter 2019 The value of Box 9 rounded down.

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

Looks up to: ffvat__BusinessActivityStatement__c
Lookup false
ffvat__DateFrom__c Period Start Date Pre-Winter 2019 Date true
ffvat__DateTo__c Period End Date Pre-Winter 2019 Date true
ffvat__GroupOfCompanies__c Group of companies Summer 2019 Checkbox false
ffvat__IncludeOutdated__c Include Earlier Unreported Transactions Pre-Winter 2019 Checkbox false
ffvat__IsBas__c Associated with a BAS Summer 2023 If selected, the VAT return report is associated with a business activity statement.

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

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

Text(165) false
ffvat__Status__c Status Pre-Winter 2019 Picklist:
Delete Error
Deleted
Deleting
Generated
In Progress
Reconciled
Submitted
ffvat__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) false
ffvat__TaxCodeInconsistent__c Inconsistent Tax Codes Summer 2021 Checkbox false
ffvat__Timestamp__c Timestamp Winter 2019 This timestamp records the date and time that the VAT return was submitted to HMRC.

DateTime false
ffvat__TotalVATReportedTransactions__c Total Tax Reported Transactions Pre-Winter 2019 Summary
ffvat__Type__c Type Pre-Winter 2019 Picklist:
Cash VAT Accounting
Standard VAT Accounting
ffvat__VATGroup__c Tax Group Summer 2019 Looks up to: ffvat__VATGroup__c
Lookup false


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