Foundations Data Dictionary

fferpcore__BillingDocument__c

Label: Billing Document

Contains sales invoice and sales credit note billing documents that enable you to bill and credit customers.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
fferpcore__Account__c Account Pre-Spring 2018 Lookup to the Salesforce Account to which this document relates.

Looks up to: Account

Lookup false
fferpcore__AllowRebilling__c Allow Rebilling Spring 2021 Indicates that the credit note allows rebilling.

Checkbox false
fferpcore__AnalysisItem1__c Analysis Item 1 Pre-Spring 2018 Used to sub-analyze billing documents and can be used to represent a number of different business concepts.

Looks up to: fferpcore__AnalysisItem__c
Lookup false
fferpcore__AnalysisItem2__c Analysis Item 2 Pre-Spring 2018 Used to sub-analyze billing documents and can be used to represent a number of different business concepts.

Looks up to: fferpcore__AnalysisItem__c
Lookup false
fferpcore__AnalysisItem3__c Analysis Item 3 Pre-Spring 2018 Used to sub-analyze billing documents and can be used to represent a number of different business concepts.

Looks up to: fferpcore__AnalysisItem__c
Lookup false
fferpcore__AnalysisItem4__c Analysis Item 4 Pre-Spring 2018 Used to sub-analyze billing documents and can be used to represent a number of different business concepts.

Looks up to: fferpcore__AnalysisItem__c
Lookup false
fferpcore__BillingAccountName__c Billing Account Pre-Spring 2018 Name of the account to appear on the billing document as the account being billed.

Text(255) false
fferpcore__BillingCity__c Billing City Pre-Spring 2018 Text(40) false
fferpcore__BillingCountry__c Billing Country Pre-Spring 2018 Text(40) false
fferpcore__BillingPostalCode__c Billing Zip/Postal Code Pre-Spring 2018 Text(20) false
fferpcore__BillingState__c Billing State/Province Pre-Spring 2018 Text(80) false
fferpcore__BillingStreet__c Billing Street Pre-Spring 2018 TextArea false
fferpcore__Company__c Company Pre-Spring 2018 Lookup to the associated company.

Looks up to: fferpcore__Company__c
Lookup false
fferpcore__CompletionProcessTracking__c Completion Process Pre-Spring 2018 Lookup to the process tracking record to which this billing document currently relates.

Looks up to: fferpcore__ProcessTracking__c
Lookup false
fferpcore__CreditNoteReason__c Credit Note Reason Spring 2020 Reason for the credit note. Can also be set on negative invoices.

Picklist:
Damaged Goods
Goods Returned
Incorrect Shipment
Overcharge
Retrospective Discount
fferpcore__CustomerReference__c Customer Reference Pre-Spring 2018 External customer reference.

TextArea false
fferpcore__DateIssued__c Date Issued Pre-Spring 2018 Date on which the billing document was sent.

Date false
fferpcore__Description__c Description Pre-Spring 2018 Description of the sales invoice or credit note.

TextArea false
fferpcore__DiscountTotal__c Discount Total Pre-Spring 2018 The total discount of all billing document line items associated with this billing document.

Summary
fferpcore__DocumentDate__c Document Date Pre-Spring 2018 Date on which the document was created.

Date true TODAY()
fferpcore__DocumentDueDate__c Document Due Date Pre-Spring 2018 Date on which payment is expected.

Date false
fferpcore__DocumentSource__c Document Source Spring 2021 Indicates where this billing document originates from.

Picklist:
Order Management
Services
Subscriptions
fferpcore__DocumentStatus__c Document Status Pre-Spring 2018 Status of the billing document. The status can be Draft or Complete. When the status is complete, you can only edit the Document Due Date, Customer Reference and Description.

Picklist:
Complete
Discarded
Draft
Ready for Review
Superseded
fferpcore__DocumentTotal__c Document Total Pre-Spring 2018 Total value of all the billing document line items on this billing document.

Summary
fferpcore__DocumentTypePrefix__c Document Type Prefix Pre-Spring 2018 Formula:
IF(ISPICKVAL(fferpcore__DocumentType__c, "Credit Note"), "CRN", "INV")
Text false
fferpcore__DocumentType__c Document Type Pre-Spring 2018 Indicates whether the document is a sales invoice or a sales credit note.

Picklist:
Credit Note
Invoice
fferpcore__Engagement__c Engagement Spring 2021 Engagement this billing document relates to.

Looks up to: fferpcore__ff_Engagement__c
Lookup false
fferpcore__ExternalDocumentNumber__c External Document Number Pre-Spring 2018 Text(255) false
fferpcore__ExternalTaxStatus__c External Tax Status Summer 2020 Status of the external tax calculation if using an external system to calculate tax on the billing document.

Picklist:
Calculated
Finalized
Not Calculated
Voided
fferpcore__FooterText__c Footer Text Pre-Spring 2018 Text to be shown at the end of printed billing documents.

Html(131072) false
fferpcore__HeaderText__c Header Text Pre-Spring 2018 Text to be shown at the start of printed billing documents.

Html(131072) false
fferpcore__IsBillingAddressValidated__c Billing Address Validated Pre-Spring 2018 Indicates whether the billing address has been validated against the addresses in the external tax calculation service.

Formula:
NOT ( ISBLANK(fferpcore__BillingStreet__c) && ISBLANK(fferpcore__BillingCity__c) && ISBLANK(fferpcore__BillingState__c) && ISBLANK(fferpcore__BillingPostalCode__c) && ISBLANK(fferpcore__BillingCountry__c) ) && ( fferpcore__BillingStreet__c = fferpcore__ValidatedBillingStreet__c ) && ( fferpcore__BillingCity__c = fferpcore__ValidatedBillingCity__c ) && ( fferpcore__BillingState__c = fferpcore__ValidatedBillingState__c ) && ( fferpcore__BillingPostalCode__c = fferpcore__ValidatedBillingPostalCode__c ) && ( fferpcore__BillingCountry__c = fferpcore__ValidatedBillingCountry__c )
Checkbox
fferpcore__IsComplete__c Is Complete Pre-Spring 2018 Formula:
ISPICKVAL(fferpcore__DocumentStatus__c, "Complete")
Checkbox
fferpcore__IsShippingAddressValidated__c Shipping Address Validated Pre-Spring 2018 Indicates whether the shipping address has been validated against the addresses in the external tax calculation service.

Formula:
NOT ( ISBLANK(fferpcore__ShippingStreet__c) && ISBLANK(fferpcore__ShippingCity__c) && ISBLANK(fferpcore__ShippingState__c) && ISBLANK(fferpcore__ShippingPostalCode__c) && ISBLANK(fferpcore__ShippingCountry__c) ) && ( fferpcore__ShippingStreet__c = fferpcore__ValidatedShippingStreet__c ) && ( fferpcore__ShippingCity__c = fferpcore__ValidatedShippingCity__c ) && ( fferpcore__ShippingState__c = fferpcore__ValidatedShippingState__c ) && ( fferpcore__ShippingPostalCode__c = fferpcore__ValidatedShippingPostalCode__c ) && ( fferpcore__ShippingCountry__c = fferpcore__ValidatedShippingCountry__c )
Checkbox
fferpcore__IsTaxCalculated__c Tax Calculated Spring 2020 Indicates if the tax has been calculated for the billing document.

Checkbox false
fferpcore__NetTotal__c Net Total Pre-Spring 2018 The total net value of all billing document line items associated with this billing document.

Summary
fferpcore__NumberOfBillingDocumentLineItems__c Number Of Billing Document Line Items Pre-Spring 2018 Number of billing document line items currently associated with this billing document.

Summary
fferpcore__ProcessingTaxDetails__c Creating Tax Breakdown Records Fall 2020 Indicates that tax breakdown records relating to the billing document are currently being created by a Certinia process.

Checkbox false
fferpcore__RelatedDocument__c Related Document Pre-Spring 2018 Lookup to the related invoice or credit note.

Looks up to: fferpcore__BillingDocument__c
Lookup false
fferpcore__ReportingDocumentTotal__c Reporting Document Total Pre-Spring 2018 Total value of all the billing document line items on this billing document based on the Document Type. If the document is an invoice, the value is the same as the Document Total. If the document is a credit note, the value is calculated using the formula: Document Total * -1.

Formula:
IF (ISPICKVAL(fferpcore__DocumentType__c, "Credit Note"), fferpcore__DocumentTotal__c * -1, fferpcore__DocumentTotal__c)
Currency(18,2) false
fferpcore__ShippingAccountName__c Shipping Account Pre-Spring 2018 Name of the account to appear on the billing document as the Shipping Account.

Text(255) false
fferpcore__ShippingCity__c Shipping City Pre-Spring 2018 Text(40) false
fferpcore__ShippingCountry__c Shipping Country Pre-Spring 2018 Text(40) false
fferpcore__ShippingPostalCode__c Shipping Zip/Postal Code Pre-Spring 2018 Text(20) false
fferpcore__ShippingState__c Shipping State/Province Pre-Spring 2018 Text(80) false
fferpcore__ShippingStreet__c Shipping Street Pre-Spring 2018 TextArea false
fferpcore__TaxPointDate__c Tax Point Date Spring 2021 The date to use for tax calculation purposes if different from Document Date.

Date false
fferpcore__TaxValueTotal__c Tax Value Total Pre-Spring 2018 The total tax value of all billing document line items associated with this billing document.

Summary
fferpcore__ValidatedBillingCity__c Validated Billing City Pre-Spring 2018 Billing address city validated by the external tax calculation service.

Text(40) false
fferpcore__ValidatedBillingCountry__c Validated Billing Country Pre-Spring 2018 Billing address country validated by the external tax calculation service.

Text(40) false
fferpcore__ValidatedBillingPostalCode__c Validated Billing Zip/Postal Code Pre-Spring 2018 Billing address postal code validated by the external tax calculation service.

Text(20) false
fferpcore__ValidatedBillingState__c Validated Billing State/Province Pre-Spring 2018 Billing address state or province validated by the external tax calculation service.

Text(20) false
fferpcore__ValidatedBillingStreet__c Validated Billing Street Pre-Spring 2018 Billing address street validated by the external tax calculation service.

TextArea false
fferpcore__ValidatedShippingCity__c Validated Shipping City Pre-Spring 2018 Shipping address city validated by the external tax calculation service.

Text(40) false
fferpcore__ValidatedShippingCountry__c Validated Shipping Country Pre-Spring 2018 Shipping address country validated by the external tax calculation service.

Text(40) false
fferpcore__ValidatedShippingPostalCode__c Validated Shipping Zip/Postal Code Pre-Spring 2018 Shipping address postal code validated by the external tax calculation service.

Text(20) false
fferpcore__ValidatedShippingState__c Validated Shipping State/Province Pre-Spring 2018 Shipping address state or province validated by the external tax calculation service.

Text(20) false
fferpcore__ValidatedShippingStreet__c Validated Shipping Street Pre-Spring 2018 Shipping address street validated by the external tax calculation service.

TextArea false


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