Metadata Changes when Enabling the Revenue Recognition Setup for Accounting

When you enable the integration between Revenue Management and Accounting, the following fields are created:

Fields Added by the Integration with Accounting
Object	Field	Description
Sales Invoice	Include in Revenue Recognition	Indicates whether or not the sales invoice is included for revenue recognition. Defaults to false.
	Revenue Recognition End Date	End date of the period over which you want to recognize the sales invoice.
	Revenue Recognition Start Date	Start date of the period over which you want to recognize the sales invoice.
	Revenue Recognition Template	Lookup to a template for recognizing revenue on the sales invoice. This field is not used by the standard integration which recognizes revenue at sales invoice line level, not header level.
Sales Invoice Line Item	Complete	Indicates whether or not the sales invoice line item has been delivered.
	Include in Revenue Recognition	Indicates whether or not the sales invoice line item is included for revenue recognition. Selected automatically if the sales invoice's status is "Complete".
	Invoice Currency	The invoice currency, derived from the sales invoice.
	Percent Complete	The percentage of the sales invoice line item that has been delivered.
	Recognized to Date	Stores the revenue that has been recognized to date for the sales invoice line item. The value updates each time recognition transactions are committed for the line item.
	Revenue Recognition Complete	A checkbox that is automatically set by the recognition process when the sales invoice line item is fully recognized. The line item is then ignored by future recognition processes.
	Revenue Recognition End Date	End date of the period over which you want to recognize the sales invoice line item.
	Revenue Recognition Start Date	Start date of the period over which you want to recognize the sales invoice line item.
	Revenue Recognition Template	Lookup to the template used to recognize revenue for the sales invoice line item.
Sales Credit Note	Include in Revenue Recognition	Indicates whether or not the sales credit note is included for revenue recognition. Defaults to false.
	Revenue Recognition End Date	End date of the period over which you want to recognize the sales credit note.
	Revenue Recognition Start Date	Start date of the period over which you want to recognize the sales credit note.
	Revenue Recognition Template	Lookup to a template for recognizing revenue on the sales credit note. This field is not used by the standard integration which recognizes revenue at sales credit note line level, not header level.
Sales Credit Note Line Item	Complete	Indicates whether or not the sales credit note line item has been delivered.
	Credit Note Currency	The credit note currency, derived from the sales credit note.
	Include in Revenue Recognition	Indicates whether or not the sales credit note line item is included for revenue recognition. Selected automatically if the sales credit note's status is "Complete".
	Percent Complete	The percentage of the sales credit note line item that has been delivered.
	Recognized to Date	Stores the revenue that has been recognized to date for the sales credit note line item. The value updates each time recognition transactions are committed for the line item.
	Reporting Net Value	The sales invoice line item's Net Value with the sign reversed.
	Revenue Recognition Complete	A checkbox that is automatically set by the recognition process when the sales credit note line item is fully recognized. The line item is then ignored by future recognition processes.
	Revenue Recognition End Date	End date of the period over which you want to recognize the sales credit note line item.
	Revenue Recognition Start Date	Start date of the period over which you want to recognize the sales credit note line item.
	Revenue Recognition Template	Lookup to the template used to recognize revenue for the sales credit note line item.
Recognition Transaction Line	Sales Invoice	Lookup to the sales invoice associated with this transaction line.
	Sales Invoice Line Item	Lookup to the sales invoice line item associated with this transaction line.
	Sales Credit Note	Lookup to the sales credit note associated with this transaction line.
	Sales Credit Note Line Item	Lookup to the sales credit note line item associated with this transaction line.
Recognition Schedule	Sales Invoice Line Item	Lookup to the sales invoice line item associated with this recognition schedule.
Recognition Schedule	Sales Credit Note Line Item	Lookup to the sales credit note line item associated with this recognition schedule.
Recognition Schedule Line	Sales Invoice	Lookup to the sales invoice associated with this recognition schedule line.
	Sales Invoice Line Item	Lookup to the sales invoice line item associated with this recognition schedule line.
	Sales Credit Note	Lookup to the sales credit note associated with this recognition schedule line.
	Sales Credit Note Line Item	Lookup to the sales credit note line item associated with this recognition schedule line.

The fields added to Sales Invoice Line Item and Sales Credit Note Line Item are added to the Manage Lines (SUT), Manage Lines (VAT/GST), and Manage Lines (Combined Tax) field sets. This means the fields will be available in the Line Items grid on the Sales Invoice Lightning Page and Sales Credit Note Lightning Page. For information about activating these Lightning pages, see Activating and Configuring Lightning Record Pages for Documents.

Recognition Settings

This table lists the recognition settings records that are created for the source objects.

Recognition Settings Created by the Integration with Accounting
	Sales Invoice	Sales Invoice Line Item	Sales Credit Note	Sales Credit Note Line Item
Recognition Settings Name	Sales Invoices	Sales Invoice Line Items	Sales Credit Notes	Sales Credit Note Line Items
Settings Level	Primary	Level 2	Primary	Level 2
Parent Recognition Settings	blank	Sales Invoices	blank	Sales Credit Notes
Object	c2g__codaInvoice__c	c2g__codaInvoiceLineItem__c	c2g__codaCreditNote__c	c2g__codaCreditNoteLineItem__c
Parent Lookup		c2g__Invoice__c		c2g__CreditNote__c
Value Type	Revenue	Revenue	Revenue	Revenue
Settings Type	Actual	Actual	Actual	Actual
Recognition Transaction Line Lookup	ffrrSalesInvoice__c	ffrrSalesInvoiceLineItem__c	ffrrSalesCreditNote__c	ffrrSalesCreditNoteLineItem__c
Recognition Schedule Lookup		ffrrSalesInvoiceLineItem__c		ffrrSalesCreditNoteLineItem__c
Recognition Schedule Line Lookups		ffrrSalesInvoiceLineItem__c, ffrrSalesInvoice__c		ffrrSalesCreditNoteLineItem__c, ffrrSalesCreditNote__c
Parent Relationship Paths		Id, c2g__codaInvoice__c		Id, c2g__CreditNote__c
Display Information	c2g__Account__c	c2g__Product__c	c2g__Account__c	c2g__Product__c
Description	Name	Name	Name	Name
Start Date	ffrrRevenueRecognitionStartDate__c	ffrrRevenueRecognitionStartDate__c	ffrrRevenueRecognitionStartDate__c	ffrrRevenueRecognitionStartDate__c
End Date	ffrrRevenueRecognitionEndDate__c	ffrrRevenueRecognitionEndDate__c	ffrrRevenueRecognitionEndDate__c	ffrrRevenueRecognitionEndDate__c
Active Field	ffrrIncludeInRevenueRecognition__c	ffrrIncludeInRevenueRecognition__c	ffrrIncludeInRevenueRecognition__c	ffrrIncludeInRevenueRecognition__c
Active Value	TRUE	TRUE	TRUE	TRUE
Include Active Value	Include	Include	Include	Include
% Complete		ffrrPercentComplete__c		ffrrPercentComplete__c
Completed Field		ffrrComplete__c		ffrrComplete__c
Completed Value		TRUE		TRUE
Include Completed Value		Include		Include
Recognition Complete		ffrrRevenueRecognitionComplete__c		ffrrRevenueRecognitionComplete__c
Grouped By	c2g__OwnerCompany__c		c2g__OwnerCompany__c
Document Currency	c2g__InvoiceCurrency__c	ffrrInvoiceCurrency__c	c2g__CreditNoteCurrency__c	ffrrCreditNoteCurrency__c
Account		c2g__Invoice__r.c2g__Account__c		c2g__CreditNote__r.c2g__Account__c
Product		c2g__Product__c		c2g__Product__c
Company		c2g__OwnerCompany__c		c2g__OwnerCompany__c
Analysis Item 1		c2g__Dimension1__c		c2g__Dimension1__c
Analysis Item 2		c2g__Dimension2__c		c2g__Dimension2__c
Analysis Item 3		c2g__Dimension3__c		c2g__Dimension3__c
Analysis Item 4		c2g__Dimension4__c		c2g__Dimension4__c
Total Revenue	c2g__NetTotal__c	c2g__NetValue__c	c2g__NetTotal__c	ffrrReportingNetValue__c
Balance Sheet*	9999	9999	9999	9999
Income Statement*	9000	9000	9000	9000
Revenue Recognized to Date Value		ffrrRecognizedToDate__c		ffrrRecognizedToDate__c
Fixed IS GLA Code	TRUE	TRUE	TRUE	TRUE
Fixed BS GLA Code	TRUE	TRUE	TRUE	TRUE