| c2g__AccountCurrency__c |
Account Currency |
Pre-Spring 2018 |
Formula:
c2g__Account__r.c2g__CODAAccountTradingCurrency__c
|
Text |
|
|
| c2g__AccountName__c |
Account Name |
Spring 2018 |
Formula:
c2g__Account__r.Name
|
Text |
|
|
| c2g__AccountOutstanding__c |
Account Outstanding |
Pre-Spring 2018 |
Formula:
c2g__Transaction__r.c2g__AccountOutstandingTotal__c
|
Number(18,2) |
|
|
| c2g__AccountTotal__c |
Account Total |
Pre-Spring 2018 |
Formula:
c2g__Transaction__r.c2g__AccountTotal__c
|
Number(18,2) |
|
|
| c2g__Account__c |
Account |
Pre-Spring 2018 |
Looks up to: Account
|
Lookup |
|
|
| c2g__ArchiveSet__c |
Archive Set |
Spring 2021 |
Lookup to the Archive Set
Looks up to: c2g__ArchiveSet__c
|
Lookup |
false |
|
| 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__BillingAddress__c |
Billing Address |
Pre-Spring 2018 |
Billing Address.
Formula:
c2g__Account__r.BillingStreet + ' ' + c2g__Account__r.BillingCity + ' ' + c2g__Account__r.BillingState + ' ' + c2g__Account__r.BillingPostalCode + ' ' + c2g__Account__r.BillingCountry
|
Text |
|
|
| c2g__BillingDocument__c |
Billing Document |
Spring 2022 |
Billing document the sales credit note relates to.
Looks up to: fferpcore__BillingDocument__c
|
Lookup |
|
|
| c2g__CompanyReference__c |
Company Name |
Pre-Spring 2018 |
Company Reference
Formula:
c2g__OwnerCompany__r.Name
|
Text |
|
|
| c2g__CopyAccountValues__c |
Copy Account Values |
Pre-Spring 2018 |
|
Checkbox |
|
true |
| c2g__CopyDefaultPrintedTextDefinitions__c |
Copy Default Printed Text Definitions |
Pre-Spring 2018 |
|
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 |
true |
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
Ready to Post & Match |
|
|
| c2g__CreditNoteTotal__c |
Credit Note Total |
Pre-Spring 2018 |
Formula:
c2g__NetTotal__c + c2g__TaxTotal__c + c2g__WithholdingTotal__c
|
Number(18,2) |
|
|
| c2g__Currency__c |
Currency |
Pre-Spring 2018 |
Credit note currency.
Formula:
c2g__CreditNoteCurrency__r.Name
|
Text |
|
|
| c2g__CustomerReference__c |
Customer Reference |
Pre-Spring 2018 |
|
Text(50) |
|
|
| c2g__DeriveCurrency__c |
Derive Currency |
Pre-Spring 2018 |
|
Checkbox |
|
true |
| c2g__DeriveDueDate__c |
Derive Due Date |
Pre-Spring 2018 |
|
Checkbox |
|
true |
| c2g__DerivePeriod__c |
Derive Period |
Pre-Spring 2018 |
|
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__DocumentOutstandingTotal__c |
Outstanding |
Pre-Spring 2018 |
Credit Note Outstanding.
Formula:
c2g__Transaction__r.c2g__DocumentOutstandingTotal__c
|
Number(18,2) |
|
|
| c2g__DocumentTotal__c |
Total |
Pre-Spring 2018 |
Credit Note Total.
Formula:
c2g__Transaction__r.c2g__DocumentTotal__c
|
Number(18,2) |
|
|
| 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 |
false |
|
| c2g__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) |
|
|
| c2g__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 |
|
|
| 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__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) |
false |
|
| c2g__Engagement__c |
Engagement |
Spring 2022 |
Lookup to the Engagement that this sales credit note relates to.
Looks up to: fferpcore__ff_Engagement__c
|
Lookup |
false |
|
| c2g__ExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(24) |
|
|
| 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__InvoiceReference__c |
Invoice Number |
Pre-Spring 2018 |
Invoice reference.
Formula:
c2g__Invoice__r.Name
|
Text |
|
|
| c2g__Invoice__c |
Invoice |
Pre-Spring 2018 |
Looks up to: c2g__codaInvoice__c
|
Lookup |
|
|
| c2g__LineCount__c |
Line Count |
Spring 2022 |
|
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 |
|
Summary |
|
|
| c2g__Opportunity__c |
Opportunity |
Pre-Spring 2018 |
The opportunity to which this Credit Note is related.
Looks up to: Opportunity
|
Lookup |
|
|
| 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__PrintStatus__c |
Print Status |
Pre-Spring 2018 |
|
Picklist:
Not Printed
Printed |
|
|
| c2g__PrintedText1AllowEdit__c |
Printed Text 1 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
|
false |
| c2g__PrintedText1Heading__c |
Printed Text 1 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText1TextDefinitionName__c |
Printed Text 1 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText1Text__c |
Printed Text 1 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
|
| c2g__PrintedText2AllowEdit__c |
Printed Text 2 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
|
false |
| c2g__PrintedText2Heading__c |
Printed Text 2 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText2TextDefinitionName__c |
Printed Text 2 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText2Text__c |
Printed Text 2 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
|
| c2g__PrintedText3AllowEdit__c |
Printed Text 3 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
|
false |
| c2g__PrintedText3Heading__c |
Printed Text 3 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText3TextDefinitionName__c |
Printed Text 3 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText3Text__c |
Printed Text 3 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
|
| c2g__PrintedText4AllowEdit__c |
Printed Text 4 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
|
false |
| c2g__PrintedText4Heading__c |
Printed Text 4 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText4TextDefinitionName__c |
Printed Text 4 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText4Text__c |
Printed Text 4 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
|
| c2g__PrintedText5AllowEdit__c |
Printed Text 5 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
|
false |
| c2g__PrintedText5Heading__c |
Printed Text 5 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText5TextDefinitionName__c |
Printed Text 5 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__PrintedText5Text__c |
Printed Text 5 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
|
| c2g__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 ( c2g__CreditNoteCurrency__r.Name = 'CHF', ( ROUND(c2g__CreditNoteTotal__c * 20,0) )/20, c2g__CreditNoteTotal__c )
|
Number(18,2) |
|
|
| c2g__SalesTaxDocumentCode__c |
External tax document code |
Pre-Spring 2018 |
|
Text(80) |
|
|
| c2g__SalesTaxStatus__c |
External Tax Status |
Pre-Spring 2018 |
The current external tax status of the invoice.
|
Picklist:
Calculated
Finalized
Not Calculated |
|
|
| c2g__ShippingAddress__c |
Shipping Address |
Pre-Spring 2018 |
Shipping Address.
Formula:
c2g__Account__r.ShippingStreet + ' ' + c2g__Account__r.ShippingCity + ' ' + c2g__Account__r.ShippingState + ' ' + c2g__Account__r.ShippingPostalCode + ' ' + c2g__Account__r.ShippingCountry
|
Text |
|
|
| c2g__Tax1Total__c |
Tax 1 Total |
Pre-Spring 2018 |
|
Summary |
|
|
| c2g__Tax2Total__c |
Tax 2 Total |
Pre-Spring 2018 |
|
Summary |
|
|
| c2g__Tax3Total__c |
Tax 3 Total |
Pre-Spring 2018 |
|
Summary |
|
|
| c2g__TaxCode1__c |
Tax Code |
Pre-Spring 2018 |
Looks up to: c2g__codaTaxCode__c
|
Lookup |
|
|
| c2g__TaxCode2__c |
Tax Code 2 |
Pre-Spring 2018 |
Looks up to: c2g__codaTaxCode__c
|
Lookup |
|
|
| c2g__TaxCode3__c |
Tax Code 3 |
Pre-Spring 2018 |
Looks up to: c2g__codaTaxCode__c
|
Lookup |
|
|
| c2g__TaxTotal__c |
Tax Total |
Pre-Spring 2018 |
Formula:
c2g__Tax1Total__c + c2g__Tax2Total__c + c2g__Tax3Total__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__WithholdingNetTotal__c |
Withholding Net Total |
Fall 2021 |
|
Summary |
|
|
| c2g__WithholdingRate__c |
Withholding Rate |
Fall 2021 |
The amount of Withholding Tax as a percentage.
|
Number(7,3) |
|
|
| c2g__WithholdingTax__c |
Withholding Tax |
Fall 2021 |
Lookup to the tax code used to withhold tax.
Looks up to: c2g__codaTaxCode__c
|
Lookup |
|
|
| c2g__WithholdingTotal__c |
Withholding Total |
Fall 2021 |
Total gross value of product lines on the sales credit note, used to withhold tax.
Formula:
ROUND(((c2g__WithholdingNetTotal__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 |
|
|
