Accounting Data Dictionary

codaInvoice__c

Label: Sales Invoice

Holds information that applies to the whole invoice such as customer account and due date.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccountCurrency__c Account Currency Pre-Spring 2018 Formula:
Account__r.CODAAccountTradingCurrency__c
Text
AccountName__c Account Name Spring 2018 Formula:
Account__r.Name
Text
AccountOutstanding__c Account Outstanding Pre-Spring 2018 Formula:
Transaction__r.AccountOutstandingTotal__c
Number(18,2)
AccountTotal__c Account Total Pre-Spring 2018 Formula:
Transaction__r.AccountTotal__c
Number(18,2)
Account__c Account Pre-Spring 2018 The customer account.

Looks up to: Account

Lookup
ArchiveSet__c Archive Set Spring 2018 Looks up to: ArchiveSet__c
Lookup
AvalaraVATReportingDocumentIndicator__c Avalara VAT Reporting Document Indicator Spring 2020 Document indicator required for the Avalara VAT Reporting integration. If blank, "1 - Invoice" is used.

Picklist:
1 - Invoice
10 - Customs - Customs additional Assessment - Spain
2 - Simplified Invoice
3 - Ticket
4 - Advance Payment
5 - Canceled Invoice
6 - Receipts - Italy
7 - Summary Invoice
8 - Simplified Invoice with Partner Details - Spain
9 - Regular Invoice without Partner Information - Spain
BillingAddress__c Billing Address Pre-Spring 2018 Formula:
Account__r.BillingStreet + ' ' + Account__r.BillingCity + ' ' + Account__r.BillingState + ' ' + Account__r.BillingPostalCode + ' ' + Account__r.BillingCountry
Text
BillingDocument__c Billing Document Spring 2022 Billing document the sales invoice relates to.

Looks up to: fferpcore__BillingDocument__c

Lookup
CompanyReference__c Company Name Pre-Spring 2018 Company Reference

Formula:
OwnerCompany__r.Name
Text
CompositeGroupKey__c Consolidation Composite Group Key Spring 2022 Combination of field values used to group the invoices for consolidation. Internal use only.

Text(255)
ConsolidatedInvoice__c Consolidated Invoice Spring 2022 Looks up to: codaInvoice__C

Lookup
CopyAccountValues__c Copy Account Values Pre-Spring 2018 Checkbox true
CopyDefaultPrintedTextDefinitions__c Copy Default Printed Text Definitions Pre-Spring 2018 Checkbox true
CreatingRecurringInvoice__c Creating Recurring Invoice Pre-Spring 2018 Checkbox false
Currency__c Currency Pre-Spring 2018 Invoice currency.

Formula:
InvoiceCurrency__r.Name
Text
CustomerReference__c Customer Reference Pre-Spring 2018 The customer reference.

Text(50)
DeriveCurrency__c Derive Currency Pre-Spring 2018 Checkbox true
DeriveDueDate__c Derive Due Date Pre-Spring 2018 Checkbox true
DerivePeriod__c Derive Period Pre-Spring 2018 Checkbox true
Dimension1__c Dimension 1 Pre-Spring 2018 Looks up to: codaDimension1__c
Lookup
Dimension2__c Dimension 2 Pre-Spring 2018 Looks up to: codaDimension2__c
Lookup
Dimension3__c Dimension 3 Pre-Spring 2018 Looks up to: codaDimension3__c
Lookup
Dimension4__c Dimension 4 Pre-Spring 2018 Looks up to: codaDimension4__c
Lookup
DiscardReason__c Discard Reason Pre-Spring 2018 The reason this Invoice was discarded.

TextArea
DocumentOutstandingTotal__c Outstanding Pre-Spring 2018 Invoice Outstanding.

Formula:
Transaction__r.DocumentOutstandingTotal__c
Number(18,2)
DocumentTotal__c Total Pre-Spring 2018 Invoice Total.

Formula:
Transaction__r.DocumentTotal__c
Number(18,2)
DualRate__c Dual Rate Pre-Spring 2018 The dual to home exchange rate.

Number(18,9)
DueDate__c Due Date Pre-Spring 2018 The date the invoice is due for payment.

Date
EInvoiceDeliveryError__c E-Invoice Delivery Error Fall 2021 Used to convey the reasons for a delivery failure. Will remain blank unless the status is Failed. Not used for business responses such as accepted or rejected.

LongTextArea(131072)
EInvoiceDeliveryStatus__c E-Invoice Delivery Status Fall 2021 Indicates the lifecycle of the sending journey of the e-invoice, from being queued to send, to being updated by the integration connector as it is delivered and subsequently processed by the recipient.

Picklist:
Delivered
Failed
Queued
Sending
EInvoiceExternalIdentifier__c E-Invoice External Unique Identifier Fall 2021 Used to uniquely identify the e-invoice in the Storecove system.

Text(36)
EInvoiceIdentifier__c E-Invoice Unique Identifier Fall 2021 Used to uniquely identify the e-invoice to the integration, as a reliable means of distinguishing between retries and duplicated invoices.

Text(36)
Engagement__c Engagement Spring 2022 Lookup to the Engagement that this sales invoice relates to.

Looks up to: fferpcore__ff_Engagement__c

Lookup
ExternalId__c External Id Pre-Spring 2018 Text(32)
FirstDueDate__c First Due Date Pre-Spring 2018 The date the invoice is due for the first payment.

Date TODAY()
GeneralLedgerAccount__c General Ledger Account Pre-Spring 2018 GLA used for Income Schedule

Looks up to: codaGeneralLedgerAccount__c
Lookup
GenerateAdjustmentJournal__c Generate Adjustment Journal Pre-Spring 2018 If checked a currency adjustment journal will be automatically generated when you post this invoice in a multi-currency environment.

Checkbox true
HoldStatus__c Hold Status Fall 2018 Text(15)
IncomeScheduleGroup__c Group Pre-Spring 2018 Looks up to: codaGroupingReference__c
Lookup
IncomeSchedule__c Income Schedule Pre-Spring 2018 Looks up to: codaIncomeScheduleDefinition__c
Lookup
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
Lookup
Interval__c Interval Pre-Spring 2018 Payment schedule interval

Picklist:
Daily
Monthly
Quarterly
Weekly
Yearly
InvoiceCurrencyDecimalPlaces__c Currency Decimal Places Spring 2022 The number of decimal places used by the invoice currency. Permitted values are 0 and 2. The default is 2.

Number(1,0) 2
InvoiceCurrency__c Invoice Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
InvoiceDate__c Invoice Date Pre-Spring 2018 The date the sales invoice was created.

Date Today()
InvoiceDescription__c Invoice Description Pre-Spring 2018 A description of the invoice.

TextArea
InvoiceGroup__c Invoice Group Pre-Spring 2018 Looks up to: codaGroupingReference__c
Lookup
InvoiceRate__c Invoice Rate Pre-Spring 2018 The document to home exchange rate.

Number(18,9)
InvoiceStatus__c Invoice Status Pre-Spring 2018 The current status of the invoice.

Picklist:
Complete
Discarded
In Progress
Ready to Post
Superseded
InvoiceTotal__c Invoice Total Pre-Spring 2018 The total value of all the items on the invoice, including the tax.

Formula:
NetTotal__c + TaxTotal__c + WithholdingTotal__c
Number(18,2)
InvoiceType__c Invoice Type Spring 2022 Stores the current invoice type.

Picklist:
Consolidated
Standard
LineCount__c Line Count Spring 2022 Summary
MatchType__c Match Type Pre-Spring 2018 Formula:
TEXT(Transaction__r.MatchType__c)
Text
NetTotal__c Net Total Pre-Spring 2018 The total value of items on the invoice, before tax.

Summary
NumberOfPayments__c Number of Payments Pre-Spring 2018 Payment schedule number of payments

Number(2,0)
NumberofJournals__c Number of Journals Pre-Spring 2018 Number(12,0)
Opportunity__c Opportunity Pre-Spring 2018 The opportunity to which this invoice is related.

Looks up to: Opportunity

Lookup
OutstandingValue__c Outstanding Value Pre-Spring 2018 Formula:
Transaction__r.DocumentOutstandingTotal__c
Number(18,2)
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
PaymentScheduleTotal__c PaymentScheduleTotal Pre-Spring 2018 Summary
PaymentSchedule__c Payment Schedule Pre-Spring 2018 Picklist:
Payment Schedule
PaymentStatus__c Payment Status Pre-Spring 2018 Formula:
if( NOT( ISPICKVAL( InvoiceStatus__c, 'Complete' ) ), $Label.NotApplicable, if( Transaction__r.DocumentOutstandingTotal__c == 0, $Label.Paid, if( Transaction__r.DocumentTotal__c == Transaction__r.DocumentOutstandingTotal__c, $Label.codaPurchaseInvoiceFieldStatusUnpaid, $Label.codaPurchaseInvoiceFieldStatusPartPaid ) ) )
Text
PeriodInterval__c Period Interval Pre-Spring 2018 Number(12,0)
Period__c Period Pre-Spring 2018 Financial period

Looks up to: codaPeriod__c
Lookup
PrintStatus__c Print Status Pre-Spring 2018 Picklist:
Not Printed
Printed
PrintedText1AllowEdit__c Printed Text 1 Allow Edit Pre-Spring 2018 Checkbox false
PrintedText1Heading__c Printed Text 1 Heading Pre-Spring 2018 Text(80)
PrintedText1TextDefinitionName__c Printed Text 1 Text Definition Name Pre-Spring 2018 Text(80)
PrintedText1Text__c Printed Text 1 Text Pre-Spring 2018 LongTextArea(32000)
PrintedText2AllowEdit__c Printed Text 2 Allow Edit Pre-Spring 2018 Checkbox false
PrintedText2Heading__c Printed Text 2 Heading Pre-Spring 2018 Text(80)
PrintedText2TextDefinitionName__c Printed Text 2 Text Definition Name Pre-Spring 2018 Text(80)
PrintedText2Text__c Printed Text 2 Text Pre-Spring 2018 LongTextArea(32000)
PrintedText3AllowEdit__c Printed Text 3 Allow Edit Pre-Spring 2018 Checkbox false
PrintedText3Heading__c Printed Text 3 Heading Pre-Spring 2018 Text(80)
PrintedText3TextDefinitionName__c Printed Text 3 Text Definition Name Pre-Spring 2018 Text(80)
PrintedText3Text__c Printed Text 3 Text Pre-Spring 2018 LongTextArea(32000)
PrintedText4AllowEdit__c Printed Text 4 Allow Edit Pre-Spring 2018 Checkbox false
PrintedText4Heading__c Printed Text 4 Heading Pre-Spring 2018 Text(80)
PrintedText4TextDefinitionName__c Printed Text 4 Text Definition Name Pre-Spring 2018 Text(80)
PrintedText4Text__c Printed Text 4 Text Pre-Spring 2018 LongTextArea(32000)
PrintedText5AllowEdit__c Printed Text 5 Allow Edit Pre-Spring 2018 Checkbox false
PrintedText5Heading__c Printed Text 5 Heading Pre-Spring 2018 Text(80)
PrintedText5TextDefinitionName__c Printed Text 5 Text Definition Name Pre-Spring 2018 Text(80)
PrintedText5Text__c Printed Text 5 Text Pre-Spring 2018 LongTextArea(32000)
RoundedInvoiceTotal__c Rounded Invoice Total Spring 2022 If invoice currency is CHF, displays the invoice total rounded to 0.05.

Formula:
IF ( InvoiceCurrency__r.Name = 'CHF', ( ROUND(InvoiceTotal__c * 20,0) )/20, InvoiceTotal__c )
Number(18,2)
SalesTaxDocumentCode__c External tax document code Pre-Spring 2018 Text(80)
SalesTaxStatus__c External Tax Status Pre-Spring 2018 The current tax status of the invoice.

Picklist:
Calculated
Finalized
Not Calculated
ShippingAddress__c Shipping Address Pre-Spring 2018 Formula:
Account__r.ShippingStreet + ' ' + Account__r.ShippingCity + ' ' + Account__r.ShippingState + ' ' + Account__r.ShippingPostalCode + ' ' + Account__r.ShippingCountry
Text
ShippingMethod__c Shipping Method Pre-Spring 2018 The method of delivery.

Picklist:
FedEx
Mail
Van
StartDate__c Start Date Pre-Spring 2018 Date
Swiss_QRReference__c Swiss QR Reference Winter 2024 The Swiss QR reference code.

Text(255)
Swiss_StructuredReferenceType__c Swiss Structured Reference Type Winter 2024 The reference type for QR code. This field displays the picklist with values NON, QRR, and SCOR. NON is the default value. If QRR is selected, the Swiss QR Reference field is mandatory.

Picklist:
NON
QRR
SCOR
Tax1Total__c Tax 1 Total Pre-Spring 2018 Summary
Tax2Total__c Tax 2 Total Pre-Spring 2018 Summary
Tax3Total__c Tax 3 Total Pre-Spring 2018 Summary
TaxCode1__c Tax Code Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxCode2__c Tax Code 2 Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxCode3__c Tax Code 3 Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxTotal__c Tax Total Pre-Spring 2018 Formula:
Tax1Total__c + Tax2Total__c + Tax3Total__c
Number(18,2)
Transaction__c Transaction Pre-Spring 2018 Looks up to: codaTransaction__c
Lookup
TriggerPostingError__c Trigger Posting Error Winter 2023 TextArea
TriggerPosting__c Trigger Posting Winter 2023 The method of trigger-posting a document after its header has been updated.

Picklist:
Asynchronous
Synchronous
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
Usepartperiods__c Use Part Periods Pre-Spring 2018 Checkbox true
WithholdingNetTotal__c Withholding Net Total Fall 2021 Summary
WithholdingRate__c Withholding Rate Fall 2021 The amount of Withholding Tax as a percentage.

Number(7,3)
WithholdingTax__c Withholding Tax Fall 2021 Lookup to the tax code used to withhold tax.

Looks up to: codaTaxCode__c
Lookup
WithholdingTotal__c Withholding Total Fall 2021 Total gross value of product lines on the sales invoice, used to withhold tax.

Formula:
ROUND(((WithholdingNetTotal__c * BLANKVALUE(WithholdingRate__c, 0)) / 100) * -1, BLANKVALUE(InvoiceCurrencyDecimalPlaces__c, 2))
Number(18,2)
Year__c Year Pre-Spring 2018 Formula:
Period__r.YearName__r.Name
Text


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