Accounting Data Dictionary

fferpcore__BillingDocument__c

Label: fferpcore__BillingDocument__c

Adding fields to an object in a different managed package

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
ArchiveSet__c Archive Set Spring 2023 Lookup to the Archive Set

Looks up to: ArchiveSet__c
Lookup false
AutoCreateSalesInvoiceCheckbox__c Auto Create Sales Invoice or Credit Note Winter 2024 Indicates whether a sales invoice or credit note is automatically created from the billing document. This is selected by default. Once the sales invoice or credit note is created, this is automatically deselected.

Checkbox true
AutoCreateSalesInvoiceOrCreditNote__c DEPRECATED: Auto Create Sales Invoice Spring 2023 This field is obsolete. It has been replaced by c2g__Auto_Create_Sales_Invoice_Checkbox__c.

Formula:
ISPICKVAL(fferpcore__DocumentStatus__c, 'Complete')
Checkbox
AvalaraVATReportingDocumentIndicator__c Avalara VAT Reporting Document Indicator Spring 2021 Document indicator required for the Avalara VAT Reporting integration. If blank and the Document Type is "Invoice", "1 - Invoice" is used. If blank and the Document Type is "Credit Note", "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
DocumentRate__c Document Rate Fall 2019 The exchange rate that converts from document currency to home currency.

Number(18,9)
DualRate__c Dual Rate Fall 2019 The exchange rate that converts from home currency to dual currency.

Number(18,9)
IsAccountingDataArchived__c Accounting Data Archived Spring 2023 Indicates whether the Billing Document's Accounting data has been archived.

Checkbox false
MatchType__c Match Type Pre-Spring 2018 Match Type of the Accounting transaction to which this billing document relates.

Formula:
TEXT(Transaction__r.MatchType__c)
Text false
OnHold__c On Hold Spring 2023 Indicates that the Billing Document is on hold for collections.

Checkbox false
OutstandingValue__c Outstanding Value Pre-Spring 2018 Outstanding Value of the Accounting transaction to which this billing document relates.

Formula:
Transaction__r.DocumentOutstandingTotal__c
Number(18,2) false
PaymentStatus__c Payment Status Pre-Spring 2018 Transaction Payment Status of the Accounting transaction to which this billing document relates.

Formula:
if(OR(NOT(ISPICKVAL(fferpcore__DocumentStatus__c, 'Complete')), NOT(ISPICKVAL(PostingStatus__c, 'Posted'))), $Label.NotApplicable, if( Transaction__r.DocumentOutstandingTotal__c == 0, $Label.Paid, if( Transaction__r.DocumentTotal__c == Transaction__r.DocumentOutstandingTotal__c, $Label.codaPurchaseInvoiceFieldStatusUnpaid, $Label.codaPurchaseInvoiceFieldStatusPartPaid ) ) )
Text false
PeriodOverride__c Period Override Fall 2019 Name of the Accounting period to use when posting the billing document.

Text(80)
PostingError__c Posting Error Pre-Spring 2018 Error that occurred while posting this billing document.

LongTextArea(131072)
PostingStatus__c Posting Status Pre-Spring 2018 Posting status for this billing document.

Picklist:
Error
Posted
Posting
RelatedDocumentReference__c Related Document Fall 2019 Formula:
fferpcore__RelatedDocument__r.Name
Text
SalesInvoiceOrCreditNoteCreated__c Sales Invoice or Credit Note Created Spring 2023 Indicates whether a matching sales invoice or credit note was created from the billing document.

Checkbox false
Transaction__c Accounting Transaction Pre-Spring 2018 Lookup to the Accounting transaction to which this billing document relates.

Looks up to: codaTransaction__c
Lookup
Year__c Year Pre-Spring 2018 Accounting year to which this billing document relates.

Formula:
Transaction__r.Period__r.YearName__r.Name
Text false


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