FFA Data Dictionary

codaTransaction__c

Label: Transaction

Holds header information about a transaction.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccountOutstandingTotal__c Account Outstanding Total Pre-Spring 2018 Summary
AccountTotal__c Account Total Pre-Spring 2018 Summary
Account__c Account Pre-Spring 2018 Looks up to: Account

Lookup
AccountingBook__c Accounting Book Spring 2020 A lookup to the Accounting Book.

Looks up to: AccountingBook__c
Lookup
Allocation__c Allocation Pre-Spring 2018 Looks up to: Allocation__c
Lookup
ApexJobId__c Apex Job ID Pre-Spring 2018 Text(18)
ArchiveSet__c Archive Set Spring 2018 Looks up to: ArchiveSet__c
Lookup
AvalaraVATReportingStatus__c Avalara VAT Reporting Status Spring 2020 Status of sending the transaction to Avalara VAT Reporting.

Picklist:
Not Ready for Sending
Ready for Sending
Sending Failed
Sent to Avalara VAT Reporting
Validation Error
BatchProcess__c Batch Process Pre-Spring 2018 Looks up to: fflib_BatchProcess__c
Lookup
BillingDocument__c Billing Document Pre-Spring 2018 Lookup to the billing document to which this transaction relates

Looks up to: fferpcore__BillingDocument__C

Lookup
CashEntry__c Cash Entry Pre-Spring 2018 Looks up to: codaCashEntry__c
Lookup
Credits__c Home Credits Pre-Spring 2018 Summary
CurrencyRevaluation__c Currency Revaluation Pre-Spring 2018 Looks up to: codaCurrencyRevaluation__c
Lookup
Debits__c Home Debits Pre-Spring 2018 Summary
DocumentDescription__c Document Description Pre-Spring 2018 Text(255)
DocumentNumber__c Document Number Pre-Spring 2018 Text(80)
DocumentOutstandingTotal__c Document Outstanding Total Pre-Spring 2018 Summary
DocumentReference2__c Document Reference 2 Pre-Spring 2018 Text(80)
DocumentReference__c Document Reference Pre-Spring 2018 Text(80)
DocumentTotal__c Document Total Pre-Spring 2018 Summary
DocumentValueTotal__c Document Value Total Spring 2022 Summary
DualCredits__c Dual Credits Pre-Spring 2018 Summary
DualDebits__c Dual Debits Pre-Spring 2018 Summary
DualValueTotal__c Dual Value Total Pre-Spring 2018 Summary
ExternalId__c External Id Pre-Spring 2018 Text(32)
HierarchyReference__c Hierarchy Reference Spring 2022 Lookup to Consolidation Hierarchy from the Transaction object.

Looks up to: ConsolidationHierarchy__c
Lookup
HomeCredits__c Home Credits Fall 2018 Formula:
IF(Credits__c < 0, Credits__c * -1, Credits__c)
Number(18,2)
HomeValueTotal__c Home Value Total Pre-Spring 2018 Summary
IncomeScheduleGroup__c Income Schedule Group Pre-Spring 2018 Looks up to: codaGroupingReference__c
Lookup
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
Lookup
InvoiceGroup__c Invoice Group Pre-Spring 2018 Looks up to: codaGroupingReference__c
Lookup
Journal__c Journal Pre-Spring 2018 Looks up to: codaJournal__c
Lookup
LineCount__c Line Count Spring 2022 Summary
MatchType__c MatchType Pre-Spring 2018 Picklist:
Credited
OriginalTransaction__c Original Transaction Number Pre-Spring 2018 Looks up to: codaTransaction__c
Lookup
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
PayableCreditNote__c Payable Credit Note Pre-Spring 2018 Looks up to: codaPurchaseCreditNote__c
Lookup
PayableInvoice__c Payable Invoice Pre-Spring 2018 Looks up to: codaPurchaseInvoice__c
Lookup
Period__c Period Pre-Spring 2018 Financial period

Looks up to: codaPeriod__c
Lookup
ReportingPeriod__c Reporting Period Fall 2021 Lookup to the financial period of the reporting company.

Looks up to: codaPeriod__c
Lookup
ReportingValueTotal__c Reporting Value Total Spring 2022 Summary
ReverseReason__c Reverse Reason Pre-Spring 2018 TextArea
ReverseTransaction__c Reverse Transaction Number Pre-Spring 2018 Looks up to: codaTransaction__c
Lookup
SalesCreditNote__c Sales Credit Note Pre-Spring 2018 Looks up to: codaCreditNote__c
Lookup
SalesInvoice__c Sales Invoice Pre-Spring 2018 Looks up to: codaInvoice__c
Lookup
SequentialTransactionNumber__c Sequential Transaction Number Fall 2021 Stores a generated sequence number for the transaction, allowing you to order transactions by company.

Text(25)
TaxLineActiveCount__c Number of Tax Lines Spring 2022 The number of Tax lines of interest to Avalara.

Summary
TaxLineCount__c Number of Tax Lines Fall 2020 The number of document lines with a Type of Tax.

Summary
TransactionDate__c Transaction Date Pre-Spring 2018 Date Today()
TransactionType__c Transaction Type Pre-Spring 2018 Picklist:
Allocation
Cash
Cash Matching Journal
Credit Note
Currency Revaluation
Elimination
Invoice
Journal
Purchase Credit Note
Purchase Invoice
Summarization
Year End Journal
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
VendorDocumentNumber__c Vendor Document Number Pre-Spring 2018 Text(25)
Year__c Year Pre-Spring 2018 Formula:
Period__r.YearName__r.Name
Text


© Copyright 2009–2022 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.