Accounting Data Dictionary

c2g__codaPurchaseCreditNote__c

Label: Payable Credit Note

Holds information that applies to the whole payable credit note such as vendor account and payable credit note date.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
c2g__AccountAddress__c Account Address Pre-Spring 2018 Formula:
c2g__Account__r.BillingStreet + ' ' + c2g__Account__r.BillingCity + ' ' + c2g__Account__r.BillingState + ' ' + c2g__Account__r.BillingPostalCode + ' ' + c2g__Account__r.BillingCountry
 Text
c2g__AccountCreditNoteNumber__c Vendor Credit Note Number Pre-Spring 2018 Text(24)
c2g__AccountECCountryCode__c Tax Country Code Pre-Spring 2018 Formula:
TEXT(c2g__Account__r.c2g__CODAECCountryCode__c)
 Text
c2g__AccountInvoiceNumber__c Vendor Invoice Number Pre-Spring 2018 Text(80)
c2g__Account__c Account Pre-Spring 2018 Looks up to: Account

 Lookup
c2g__AvalaraVATReportingDocumentIndicator__c Avalara VAT Reporting Document Indicator Spring 2020 Document indicator required for the Avalara VAT Reporting integration. If blank, "5 - Canceled 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		 false
c2g__CopyAccountValues__c Derive Details from Account Pre-Spring 2018 If selected, retrieves the available details from the selected account.

 Checkbox true
c2g__CreditNoteCurrencyDecimalPlaces__c Currency Decimal Places Spring 2022 The number of decimal places used by the credit note currency. Permitted values are 0 and 2. The default is 2.

 Number(1,0) 2
c2g__CreditNoteCurrency__c Credit Note Currency Pre-Spring 2018 Looks up to: c2g__codaAccountingCurrency__c
 Lookup
c2g__CreditNoteDate__c Credit Note Date Pre-Spring 2018 Date TODAY()
c2g__CreditNoteDescription__c Credit Note Description Pre-Spring 2018 TextArea
c2g__CreditNoteRate__c Credit Note Rate Pre-Spring 2018 The document to home exchange rate.

 Number(18,9)
c2g__CreditNoteReason__c Credit Note Reason Pre-Spring 2018 Picklist:
Damaged Goods
Goods Returned
Incorrect Shipment
Overcharge
Retrospective Discount
c2g__CreditNoteStatus__c Credit Note Status Pre-Spring 2018 Picklist:
Complete
Discarded
In Progress
Ready to Post
c2g__CreditNoteTotal__c Credit Note Total Pre-Spring 2018 Formula:
c2g__NetTotal__c + c2g__TaxTotal__c + c2g__WithholdingTotal__c
 Number(18,2)
c2g__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
c2g__DeriveDueDate__c Derive Due Date Pre-Spring 2018 If selected, derives the due date of this document from the credit note date and the vendor account's credit terms.

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

 Checkbox true
c2g__Dimension1__c Dimension 1 Pre-Spring 2018 Looks up to: c2g__codaDimension1__c
 Lookup
c2g__Dimension2__c Dimension 2 Pre-Spring 2018 Looks up to: c2g__codaDimension2__c
 Lookup
c2g__Dimension3__c Dimension 3 Pre-Spring 2018 Looks up to: c2g__codaDimension3__c
 Lookup
c2g__Dimension4__c Dimension 4 Pre-Spring 2018 Looks up to: c2g__codaDimension4__c
 Lookup
c2g__DiscardReason__c Discard Reason Pre-Spring 2018 TextArea
c2g__DualRate__c Dual Rate Pre-Spring 2018 The dual to home exchange rate.

 Number(18,9)
c2g__DueDate__c Due Date Pre-Spring 2018 Date
c2g__EInvoiceExternalIdentifier__c E-Invoice External Unique Identifier Spring 2022 Used to uniquely identify the e-invoice in the Storecove system.

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

 Picklist:
Accepted
Acknowledged
Rejected
c2g__EnableReverseCharge__c Enable Reverse Charge Pre-Spring 2018 Checkbox false
c2g__ExpenseLineCount__c Expense Line Count Spring 2023 Summary
c2g__ExpensesNetTotal__c Expenses Net Total Pre-Spring 2018 Total value of expense items on the credit note, before tax. SUM: Payable Credit Note Expense Line Item: NetValue

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

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

 Summary
c2g__ExternalId__c External Id Pre-Spring 2018 Text(32)
c2g__IncomeTaxType__c Income Tax Type Pre-Spring 2018 Income Tax Type

 Picklist:
(MISC) 1 - Rents
(MISC) 10 - Gross proceeds paid to an attorney
(MISC) 11 - Fish purchased for resale
(MISC) 12 - Section 409A deferrals
(MISC) 13 - FATCA filing requirement (Checkbox)
(MISC) 14 - Excess golden parachute payments
(MISC) 15 - Nonqualified deferred compensation
(MISC) 16 - State tax withheld
(MISC) 17 - State/Payer's state no.
(MISC) 18 - State income
(MISC) 2 - Royalties
(MISC) 3 - Other income
(MISC) 4 - Federal income tax withheld
(MISC) 5 - Fishing boat proceeds
(MISC) 6 - Medical and health care payments
(MISC) 7 - Payer made direct sales of 5000 or more (Checkbox)
(MISC) 8 - Substitute payments in lieu of dividends or interest
(MISC) 9 - Crop insurance proceeds
(NEC) 1 - Nonemployee compensation
(NEC) 2 - Payer made direct sales of 5000 or more (Checkbox)
(NEC) 4 - Federal income tax withheld
(NEC) 5 - State tax withheld
(NEC) 6 - State/Payer's state no.
(NEC) 7 - State income
Not Reportable
c2g__IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: c2g__codaIntercompanyTransfer__c
 Lookup
c2g__InvoiceDate__c Invoice Date Pre-Spring 2018 Date
c2g__ItemsNetTotal__c Items Net Total Pre-Spring 2018 Total value of product items on the credit note, before tax. SUM: Payable Credit Note Line Item: NetValue

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

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

 Summary
c2g__MatchType__c Match Type Pre-Spring 2018 Formula:
TEXT(c2g__Transaction__r.c2g__MatchType__c)
 Text
c2g__NetTotal__c Net Total Pre-Spring 2018 Formula:
c2g__ItemsNetTotal__c + c2g__ExpensesNetTotal__c
 Number(18,2)
c2g__OutstandingValue__c Outstanding Value Pre-Spring 2018 Formula:
c2g__Transaction__r.c2g__DocumentOutstandingTotal__c
 Number(18,2)
c2g__OwnerCompany__c Company Pre-Spring 2018 Looks up to: c2g__codaCompany__c
 Lookup
c2g__PaymentStatus__c Payment Status Pre-Spring 2018 Formula:
if( NOT( ISPICKVAL( c2g__CreditNoteStatus__c, 'Complete' ) ), $Label.NotApplicable, if( c2g__Transaction__r.c2g__DocumentOutstandingTotal__c == 0, $Label.Paid, if( c2g__Transaction__r.c2g__DocumentTotal__c == c2g__Transaction__r.c2g__DocumentOutstandingTotal__c, $Label.codaPurchaseInvoiceFieldStatusUnpaid, $Label.codaPurchaseInvoiceFieldStatusPartPaid ) ) )
 Text
c2g__Period__c Period Pre-Spring 2018 Financial period

Looks up to: c2g__codaPeriod__c
 Lookup
c2g__ProductLineCount__c Product Line Count Spring 2023 Summary
c2g__PurchaseInvoice__c Payable Invoice Pre-Spring 2018 Looks up to: c2g__codaPurchaseInvoice__c
 Lookup
c2g__Reference1__c Reference 1 Pre-Spring 2018 Text(80)
c2g__Reference2__c Reference 2 Pre-Spring 2018 Text(80)
c2g__RegisteredDate__c Registered Date Pre-Spring 2018 Date Today()
c2g__TaxCode1__c Tax Code 1 Pre-Spring 2018 Looks up to: c2g__codaTaxCode__c
 Lookup
c2g__TaxDocumentCode__c External Tax Document Code Pre-Spring 2018 Text(80)
c2g__TaxStatus__c External Tax Status Pre-Spring 2018 Tax status of the invoice.

 Picklist:
Calculated
Finalized
Not Calculated
c2g__TaxTotal__c Tax Total Pre-Spring 2018 Formula:
c2g__ItemsTax1Total__c + c2g__ExpensesTax1Total__c + c2g__ItemsTax2Total__c + c2g__ExpensesTax2Total__c - c2g__ItemsOutputTaxTotal__c - c2g__ExpensesOutputTaxTotal__c
 Number(18,2)
c2g__Transaction__c Transaction Pre-Spring 2018 Looks up to: c2g__codaTransaction__c
 Lookup
c2g__TriggerPostingError__c Trigger Posting Error Winter 2023 TextArea false
c2g__TriggerPosting__c Trigger Posting Winter 2023 The method of trigger-posting a document after its header has been updated.

 Picklist:
Asynchronous
Synchronous
c2g__UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
c2g__VATRegistrationNumber__c Tax Registration Number Pre-Spring 2018 Formula:
c2g__Account__r.c2g__CODAVATRegistrationNumber__c
 Text
c2g__WithholdingExpenseNetTotal__c Withholding Expense Net Total Spring 2021 Summary
c2g__WithholdingProductNetTotal__c Withholding Product Net Total Spring 2021 Summary
c2g__WithholdingRate__c Withholding Rate Spring 2021 The Withholding tax rate.

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

Looks up to: c2g__codaTaxCode__c
 Lookup
c2g__WithholdingTotal__c Withholding Total Spring 2021 The total value of items and expenses on the puchase credit note, applicable for withholding tax.

Formula:
ROUND((((c2g__WithholdingExpenseNetTotal__c + c2g__WithholdingProductNetTotal__c) * BLANKVALUE(c2g__WithholdingRate__c, 0)) / 100) * -1, BLANKVALUE(c2g__CreditNoteCurrencyDecimalPlaces__c, 2))
 Number(18,2)
c2g__Year__c Year Pre-Spring 2018 Formula:
c2g__Period__r.c2g__YearName__r.Name
 Text


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