Tax Reporting Data Dictionary

VatReportedTransaction__c

Label: Tax Reported Transaction

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccountCurrency__c Account Currency Pre-Winter 2019 Looks up to: c2g__codaAccountingCurrency__c

Lookup
AccountValue__c Account Value Pre-Winter 2019 Number(18,2)
Account__c Account Pre-Winter 2019 Looks up to: Account

Lookup
DocumentDate__c Document Date Pre-Winter 2019 Formula:
TransactionLineItem__r.c2g__Transaction__r.c2g__TransactionDate__c
Date
DocumentNumber__c Document Number Pre-Winter 2019 Formula:
TransactionLineItem__r.c2g__Transaction__r.c2g__DocumentNumber__c
Text
DocumentType__c Document Type Pre-Winter 2019 Formula:
Text(TransactionLineItem__r.c2g__Transaction__r.c2g__TransactionType__c)
Text
ECCountryCode__c EC Country Code Pre-Winter 2019 Formula:
Text(Account__r.c2g__CODAECCountryCode__c)
Text
FullyVATReported__c Fully Tax Reported Pre-Winter 2019 Checkbox false
MultiGrossBox__c BAS Gross Box Summer 2023 The gross value for this tax code is reported in the boxes selected (Net + Tax).

MultiselectPicklist:
G1
G10
G11
W1
MultiNetBox__c BAS Net Box Summer 2023 The net value for this tax code is reported in the boxes selected.

MultiselectPicklist:
G1
G2
G3
MultiTaxBox__c BAS Tax Box Summer 2023 The tax value for this tax code is reported in the boxes selected.

MultiselectPicklist:
1A
1B
W2
W3
W4
NetBox__c VAT Net Box Pre-Winter 2019 Picklist:
Box 6
Box 7
Box 8
Box 9
NetReported__c Net Reported Pre-Winter 2019 Number(18,2)
OwnerCompany__c Company Pre-Winter 2019 Looks up to: c2g__codaCompany__c

Lookup
PaidAccountValue__c Paid Account Value Pre-Winter 2019 Number(18,2)
Reconciled__c Reconciled Pre-Winter 2019 Formula:
Text(VatReturn__r.Status__c)
Text
TaxBox__c VAT Tax Box Pre-Winter 2019 Picklist:
Box 1
Box 2
Box 4
TaxCodeName__c Tax Code Name Summer 2019 Formula:
TaxCode__r.Name
Text
TaxCode__c Tax Code Pre-Winter 2019 Looks up to: c2g__codaTaxCode__c

Lookup
TaxReported__c Tax Reported Pre-Winter 2019 Number(18,2)
TransactionLineItem__c Transaction Line Item Pre-Winter 2019 Looks up to: c2g__codaTransactionLineItem__c

Lookup
Transaction__c Transaction Number Pre-Winter 2019 Looks up to: c2g__codaTransaction__c

Lookup
VATRegistrationNumber__c VAT Registration Number Pre-Winter 2019 Formula:
Account__r.c2g__CODAVATRegistrationNumber__c
Text
VATReturnType__c VAT Return Type Pre-Winter 2019 Formula:
TEXT(VatReturn__r.Type__c)
Text
VATStatus__c Tax Status Pre-Winter 2019 Formula:
TEXT( Account__r.c2g__CODAVATStatus__c)
Text
VatReturn__c VAT Return Report Pre-Winter 2019 Looks up to: VatReturn__c
MasterDetail
VendorDocumentNumber__c Vendor Document Number Pre-Winter 2019 Formula:
TransactionLineItem__r.c2g__Transaction__r.c2g__VendorDocumentNumber__c
Text


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