Accounting Data Dictionary

codaPurchaseInvoice__c

Label: Payable Invoice

Holds information that applies to the whole payable invoice such as vendor information and due date.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccountAddress__c Account Address Pre-Spring 2018 Formula:
Account__r.BillingStreet + ' ' + Account__r.BillingCity + ' ' + Account__r.BillingState + ' ' + Account__r.BillingPostalCode + ' ' + Account__r.BillingCountry
Text
AccountECCountryCode__c Tax Country Code Pre-Spring 2018 Formula:
TEXT(Account__r.CODAECCountryCode__c)
Text
AccountInvoiceNumber__c Vendor Invoice Number Pre-Spring 2018 The vendor reference.

Text(25)
Account__c Account Pre-Spring 2018 Looks up to: Account

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
CopyAccountValues__c Derive Details from Account Pre-Spring 2018 If selected, retrieves the available details from the selected account.

Checkbox true
DeriveCurrency__c Derive Currency Pre-Spring 2018 If selected, sets the document's currency to home currency in a single-currency org or to the currency of the selected account in a multi-currency org.

Checkbox true
DeriveDueDate__c Derive Due Date Pre-Spring 2018 If selected, derives the due date of this document from the invoice date and the vendor account's credit terms.

Checkbox true
DerivePeriod__c Derive Period Pre-Spring 2018 If selected, derives the period of this document based on the document's date.

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 Payable Invoice was discarded.

TextArea
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 payable invoice is due for payment.

Date
EInvoiceExternalIdentifier__c E-Invoice External Unique Identifier Spring 2022 Used to uniquely identify the e-invoice in the Storecove system.

Text(36)
EInvoiceProcessingStatus__c E-Invoice Processing Status Spring 2022 Picklist to specify the received e-invoice stages from acknowledged to accepted.

Picklist:
Accepted
Acknowledged
Rejected
EnableReverseCharge__c Enable Reverse Charge Pre-Spring 2018 Checkbox false
ExpenseLineCount__c Expense Line Count Winter 2023 Summary
ExpensesNetTotal__c Expenses Net Total Pre-Spring 2018 Total value of expense items on the invoice, before tax. SUM: Payable Invoice Expense Line Item: NetValue

Summary
ExpensesOutputTaxTotal__c Expenses Output Tax Total Pre-Spring 2018 Summary
ExpensesTax1Total__c Expenses Tax 1 Total Pre-Spring 2018 Sum of tax 1 posted to Expense Line Items.

Summary
ExpensesTax2Total__c Expenses Tax 2 Total Pre-Spring 2018 Sum of tax 2 posted to Expense Line Items.

Summary
ExternalId__c External Id Pre-Spring 2018 Text(32)
HoldStatus__c Hold Status Pre-Spring 2018 Text(15)
IncomeTaxType__c Income Tax Type Pre-Spring 2018 Income Tax Type

Picklist:
1 - Rents
10 - Gross Proceeds Paid to an Attorney
11 - Fish Purchased for Resale
12 - Section 409A Deferrals
13 - FATCA Filing Requirement (Checkbox)
14 - Excess Golden Parachute Payments
15 - Nonqualified Deferred Compensation
16 - State Tax Withheld
17 - State/Payer's State No.
18 - State Income
2 - Royalties
3 - Other Income
4 - Federal Income Tax Withheld
5 - Fishing Boat Proceeds
6 - Medical and Healthcare Payments
7 - Payer Made Direct Sales of 5000 or More (Checkbox)
8 - Substitute Payments in Lieu of Dividends or Interest
9 - Crop Insurance Proceeds
Not Reportable
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
Lookup
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 payable invoice was created.

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

TextArea
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 payable invoice.

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

Formula:
NetTotal__c + TaxTotal__c + WithholdingTotal__c
Number(18,2)
ItemsNetTotal__c Items Net Total Pre-Spring 2018 Total value of product items on the invoice, before tax. SUM: Payable Invoice Line Item: NetValue

Summary
ItemsOutputTaxTotal__c Items Output Tax Total Pre-Spring 2018 Summary
ItemsTax1Total__c Items Tax 1 Total Pre-Spring 2018 Sum of tax 1 posted to Product Line Items.

Summary
ItemsTax2Total__c Items Tax 2 Total Pre-Spring 2018 Sum of tax 2 posted to Product Line Items.

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 and expenses on the puchase invoice, before tax.

Formula:
ItemsNetTotal__c + ExpensesNetTotal__c
Number(18,2)
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
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
Period__c Period Pre-Spring 2018 Financial period

Looks up to: codaPeriod__c
Lookup
ProductLineCount__c Product Line Count Winter 2023 Summary
Reference1__c Reference 1 Pre-Spring 2018 Text(80)
Reference2__c Reference 2 Pre-Spring 2018 Text(80)
RegisteredDate__c Registered Date Pre-Spring 2018 Date TODAY()
TaxCode1__c Tax Code 1 Pre-Spring 2018 Looks up to: codaTaxCode__c
Lookup
TaxDocumentCode__c External Tax Document Code Pre-Spring 2018 Text(80)
TaxStatus__c External Tax Status Pre-Spring 2018 Tax status of the invoice.

Picklist:
Calculated
Finalized
Not Calculated
TaxTotal__c Tax Total Pre-Spring 2018 Formula:
ItemsTax1Total__c + ExpensesTax1Total__c + ItemsTax2Total__c + ExpensesTax2Total__c - ItemsOutputTaxTotal__c - ExpensesOutputTaxTotal__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)
VATRegistrationNumber__c Tax Registration Number Pre-Spring 2018 Formula:
Account__r.CODAVATRegistrationNumber__c
Text
WithholdingExpenseNetTotal__c Withholding Expense Net Total Spring 2021 Summary
WithholdingProductNetTotal__c Withholding Product Net Total Spring 2021 Summary
WithholdingRate__c Withholding Rate Spring 2021 The Withholding tax rate.

Number(7,3)
WithholdingTax__c Withholding Tax Spring 2021 Lookup in the tax codes from purchase invoice for withholding tax details.

Looks up to: codaTaxCode__c
Lookup
WithholdingTotal__c Withholding Total Spring 2021 The total value of items and expenses on the puchase invoice, applicable for withholding tax.

Formula:
ROUND((((WithholdingExpenseNetTotal__c + WithholdingProductNetTotal__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–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.