| 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 |
Looks up to: Account
|
Lookup |
|
| ArchiveSet__c |
Archive Set |
Spring 2021 |
Lookup to the Archive Set
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, "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 |
|
| BillingAddress__c |
Billing Address |
Pre-Spring 2018 |
Billing Address.
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 credit note relates to.
Looks up to: fferpcore__BillingDocument__c
|
Lookup |
|
| CompanyReference__c |
Company Name |
Pre-Spring 2018 |
Company Reference
Formula:
OwnerCompany__r.Name
|
Text |
|
| CopyAccountValues__c |
Copy Account Values |
Pre-Spring 2018 |
|
Checkbox |
true |
| CopyDefaultPrintedTextDefinitions__c |
Copy Default Printed Text Definitions |
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
Ready to Post & Match |
|
| CreditNoteTotal__c |
Credit Note Total |
Pre-Spring 2018 |
Formula:
NetTotal__c + TaxTotal__c + WithholdingTotal__c
|
Number(18,2) |
|
| Currency__c |
Currency |
Pre-Spring 2018 |
Credit note currency.
Formula:
CreditNoteCurrency__r.Name
|
Text |
|
| CustomerReference__c |
Customer Reference |
Pre-Spring 2018 |
|
Text(24) |
|
| 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 |
|
| DocumentOutstandingTotal__c |
Outstanding |
Pre-Spring 2018 |
Credit Note Outstanding.
Formula:
Transaction__r.DocumentOutstandingTotal__c
|
Number(18,2) |
|
| DocumentTotal__c |
Total |
Pre-Spring 2018 |
Credit Note 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 |
|
Date |
|
| EInvoiceDeliveryError__c |
E-Invoice Delivery Error |
Spring 2022 |
Indicates the reason for a delivery failure. Not used for business responses such as accepted or rejected.
|
LongTextArea(131072) |
|
| EInvoiceDeliveryStatus__c |
E-Invoice Delivery Status |
Spring 2022 |
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 |
Spring 2022 |
Used to uniquely identify the e-invoice in the Storecove system.
|
Text(36) |
|
| EInvoiceIdentifier__c |
E-Invoice Unique Identifier |
Spring 2022 |
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 credit note relates to.
Looks up to: fferpcore__ff_Engagement__c
|
Lookup |
|
| ExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(24) |
|
| IntercompanyTransfer__c |
Intercompany Transfer |
Pre-Spring 2018 |
Looks up to: codaIntercompanyTransfer__c
|
Lookup |
|
| InvoiceDate__c |
Invoice Date |
Pre-Spring 2018 |
|
Date |
|
| InvoiceReference__c |
Invoice Number |
Pre-Spring 2018 |
Invoice reference.
Formula:
Invoice__r.Name
|
Text |
|
| Invoice__c |
Invoice |
Pre-Spring 2018 |
Looks up to: codaInvoice__c
|
Lookup |
|
| 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 |
|
Summary |
|
| Opportunity__c |
Opportunity |
Pre-Spring 2018 |
The opportunity to which this Credit Note 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 |
|
| 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 |
|
| 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) |
|
| RoundedCreditNoteTotal__c |
Rounded Credit Note Total |
Spring 2022 |
If credit note currency is CHF, displays the credit note total rounded to 0.05.
Formula:
IF ( CreditNoteCurrency__r.Name = 'CHF', ( ROUND(CreditNoteTotal__c * 20,0) )/20, CreditNoteTotal__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 external tax status of the invoice.
|
Picklist:
Calculated
Finalized
Not Calculated |
|
| ShippingAddress__c |
Shipping Address |
Pre-Spring 2018 |
Shipping Address.
Formula:
Account__r.ShippingStreet + ' ' + Account__r.ShippingCity + ' ' + Account__r.ShippingState + ' ' + Account__r.ShippingPostalCode + ' ' + Account__r.ShippingCountry
|
Text |
|
| 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 |
|
| UnitOfWork__c |
Unit of Work |
Pre-Spring 2018 |
|
Number(18,0) |
|
| 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 credit note, used to withhold tax.
Formula:
ROUND(((WithholdingNetTotal__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 |
|
