FFA Data Dictionary

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 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
AccountCreditNoteNumber__c Vendor Credit Note Number Pre-Spring 2018 Text(24)
AccountECCountryCode__c Tax Country Code Pre-Spring 2018 Formula:
TEXT(Account__r.CODAECCountryCode__c)
 Text
AccountInvoiceNumber__c Vendor Invoice Number Pre-Spring 2018 Text(80)
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, "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
CopyAccountValues__c Copy Account Values Pre-Spring 2018 Checkbox true
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
CreditNoteCurrency__c Credit Note Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
 Lookup
CreditNoteDate__c Credit Note Date Pre-Spring 2018 Date TODAY()
CreditNoteDescription__c Credit Note Description Pre-Spring 2018 TextArea
CreditNoteRate__c Credit Note Rate Pre-Spring 2018 The document to home exchange rate.

 Number(18,9)
CreditNoteReason__c Credit Note Reason Pre-Spring 2018 Picklist:
Damaged Goods
Goods Returned
Incorrect Shipment
Overcharge
Retrospective Discount
CreditNoteStatus__c Credit Note Status Pre-Spring 2018 Picklist:
Complete
Discarded
In Progress
Ready to Post
CreditNoteTotal__c Credit Note Total Pre-Spring 2018 Formula:
NetTotal__c + TaxTotal__c + WithholdingTotal__c
 Number(18,2)
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 TextArea
DualRate__c Dual Rate Pre-Spring 2018 The dual to home exchange rate.

 Number(18,9)
DueDate__c Due Date Pre-Spring 2018 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
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
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)
IncomeTaxType__c Income Tax Type Pre-Spring 2018 Income Tax Type

 Picklist:
1 - Rents
10 - Crop Insurance Proceeds
11 - Unused 11
12 - Unused 12
13 - Excess Golden Parachute Payments
14 - Gross Proceeds Paid to an Attorney
2 - Royalties
3 - Other Income
4 - Federal Income Tax Withheld
5 - Fishing Boat Proceeds
6 - Medical and Healthcare Payments
7 - Nonemployee Compensation
8 - Substitute Payments in Lieu of Dividends or Interest
9 - Payer Made Direct Sales of 5000 or More
Not Reportable
IntercompanyTransfer__c Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
 Lookup
InvoiceDate__c Invoice Date Pre-Spring 2018 Date
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
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 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( CreditNoteStatus__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
PurchaseInvoice__c Payable Invoice Pre-Spring 2018 Looks up to: codaPurchaseInvoice__c
 Lookup
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
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 credit note 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 credit note, applicable for withholding tax.

Formula:
ROUND((((WithholdingExpenseNetTotal__c + WithholdingProductNetTotal__c) * BLANKVALUE(WithholdingRate__c, 0)) / 100) * -1, BLANKVALUE(CreditNoteCurrencyDecimalPlaces__c, 2))
 Number(18,2)
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.