Salesforce Schema

BillForward Salesforce Schema
Billforward Custom ObjectsField LabelAPI NameData Type
BFAccountAccountbfwd__Account__cLookup(Account)
 AdditionalInformationbfwd__AdditionalInformation__cText(255)
 bfIDbfwd__bfID__cText(36) (External ID) (Unique Case Insensitive)
 Citybfwd__City__cText(255)
 Companybfwd__Company__cFormula (Text)
 CompanyNamebfwd__CompanyName__cText(255)
 Countrybfwd__Country__cText(255)
 Date of Birthbfwd__DOB__cDate
 Deletedbfwd__Deleted__cCheckbox
 Emailbfwd__Email__cEmail
 Faxbfwd__Fax__cText(100)
 First Namebfwd__FirstName__cText(255)
 Land Linebfwd__LandLine__cText(255)
 Last Namebfwd__LastName__cText(255)
 LogoURLbfwd__LogoURL__cURL(255)
 Mobilebfwd__Mobile__cText(255)
 OrganizationIDbfwd__OrganisationID__cText(36)
 PostCodebfwd__PostCode__cText(255)
 Sourcebfwd__Source__cText(255)
 Statebfwd__State__cText(255)
 Streetbfwd__Street__cText Area(255)
 Updatedbfwd__Updated__cDate/Time
 VatNumberbfwd__VatNumber__cText(100)
    
BFCreditNoteBFAccountbfwd__BFAccountID__cLookup(BFAccount)
 bfIDbfwd__bfID__cText(36) (External ID) (Unique Case Insensitive)
 BFInvoicebfwd__BFInvoiceID__cLookup(BFInvoice)
 BFSubscriptionbfwd__BFSubscriptionID__cLookup(BFSubscription)
 Currencybfwd__Currency__cPicklist
 Descriptionbfwd__Description__cText(255)
 Remaining Valuebfwd__RemainingValue__cNumber(16, 2)
 Valuebfwd__Value__cNumber(16, 2)
    
BFInvoicebfIDbfwd__bfID__cText(36) (External ID) (Unique Case Insensitive)
 BFSubscriptionbfwd__BFSubscriptionID__cLookup(BFSubscription)
 Costbfwd__Cost__cNumber(16, 2)
 Cost (ex tax)bfwd__CostExcludingTax__cNumber(16, 2)
 Currencybfwd__Currency__cText(3)
 Discountbfwd__Discount__cNumber(16, 2)
 Due Datebfwd__DueDate__cDate
 Emailbfwd__Email__cFormula (Text)
 Invoice Linesbfwd__InvoiceLines__cRich Text Area(32768)
 Is Initial Invoicebfwd__IsInitialInvoice__cCheckbox
 NextExecutionAttemptbfwd__NextExecutionAttempt__cDate/Time
 OrganisationIDbfwd__OrganisationID__cText(36)
 PaymentReceivedbfwd__PaymentReceived__cDate/Time
 PaymentTerms(Days)bfwd__PaymentTerms__cNumber(18, 0)
 Period Endbfwd__PeriodEnd__cDate/Time
 Period Startbfwd__PeriodStart__cDate/Time
 Statebfwd__State__cPicklist
 TotalBillPaidbfwd__TotalBillPaid__cNumber(16, 2)
 TotalExecutionAttemptsbfwd__TotalExecutionAttempts__cNumber(18, 0)
 Typebfwd__Type__cText(50)
    
BFPaymentbfIDbfwd__bfID__cText(36) (External ID) (Unique Case Insensitive)
 BFInvoicebfwd__BFInvoiceID__cLookup(BFInvoice)
 BFPaymentMethodbfwd__BFPaymentMethod__cLookup(BFPaymentMethod)
 Currencybfwd__Currency__cText(3)
 Gatewaybfwd__Gateway__cText(100)
 Offline Payment Transaction Numberbfwd__OfflinePaymentTransactionNo__cText(255)
 Offline Payment Typebfwd__OfflinePaymentType__cPicklist
 Other Offline Payment Typebfwd__OtherOfflinePaymentType__cText(255)
 Receivedbfwd__Received__cDate/Time
 Refundedbfwd__RefundedValue__cNumber(16, 2)
 Remainingbfwd__RemainingValue__cNumber(16, 2)
 Typebfwd__Type__cPicklist
 Valuebfwd__ActualValue__cNumber(16, 2)
 Value (nominal)bfwd__NominalValue__cNumber(16, 2)
    
BFPaymentMethodBFAccountbfwd__BFAccount__cLookup(BFAccount)
 bfIDbfwd__bfID__cText(36) (External ID)
 Card Holder Namebfwd__CardHolderName__cText(255)
 Card Typebfwd__CardType__cText(50)
 Countrybfwd__Country__cText(100)
 DefaultPaymentMethodbfwd__DefaultPaymentMethod__cCheckbox
 Deletedbfwd__Deleted__cCheckbox
 Descriptionbfwd__Description__cText(255)
 Expiry Datebfwd__ExpiryDate__cText(10)
 FirstSixbfwd__FirstSix__cText(6)
 Gatewaybfwd__Gateway__cText(100)
 LastFourbfwd__LastFour__cText(4)
 Provincebfwd__Province__cText(100)
 Statebfwd__State__cText(15)
    
BFPaymentMethodSubscriptionbfIDbfwd__bfID__cText(36) (External ID)
 BFPaymentMethodbfwd__BFPaymentMethodID__cMaster-Detail(BFPaymentMethod)
 BFSubscriptionbfwd__BFSubscriptionID__cMaster-Detail(BFSubscription)
 Deletedbfwd__Deleted__cCheckbox
 OrganizationIDbfwd__OrganisationID__cText(36)
    
BFPricingComponentbfIDbfwd__bfID__cText(36) (External ID)
 BFRatePlanbfwd__BFRatePlanID__cLookup(BFRatePlan)
 ChargeModelbfwd__ChargeModel__cText(50)
 ChargeTypebfwd__ChargeType__cText(50)
 Descriptionbfwd__Description__cText(255)
 DowngradeModebfwd__DowngradeMode__cText(50)
 Namebfwd__PublicName__cText(255)
 PrivateNamebfwd__privateName__cText(255)
 UnitOfMeasurebfwd__UnitOfMeasure__cText(255)
 UnitOfMeasureIDbfwd__UnitOfMeasureID__cText(36)
 UpgradeModebfwd__UpgradeMode__cText(50)
 VersionIDbfwd__VersionID__cText(36)
    
BFPricingComponentTierbfIDbfwd__bfID__cText(36) (External ID)
 BFPricingComponentbfwd__BFPricingComponentID__cLookup(BFPricingComponent)
 LowerThresholdbfwd__LowerThreshold__cNumber(18, 0)
 Pricebfwd__Price__cNumber(16, 2)
 PricingComponentVersionIDbfwd__PricingComponentVersionID__cFormula (Text)
 PricingTypebfwd__PricingType__cPicklist
 UpperThresholdbfwd__UpperThreshold__cNumber(18, 0)
 Valid Frombfwd__ValidFrom__cDate/Time
 Valid Tillbfwd__ValidTill__cDate/Time
    
BFPricingComponentValuebfIDbfwd__bfID__cText(50) (External ID)
 BFPricingComponentbfwd__BFPricingComponentID__cLookup(BFPricingComponent)
 BFSubscriptionbfwd__BFSubscription__cLookup(BFSubscription)
 Valid Frombfwd__ValidFrom__cDate/Time
 Valid Tillbfwd__ValidTill__cDate/Time
 Valuebfwd__value__cNumber(18, 0)
    
BFProductBF IDbfwd__bfID__cText(36) (External ID) (Unique Case Insensitive)
 BFProductLinkbfwd__ProductLink__cFormula (Text)
 Deletedbfwd__Deleted__cCheckbox
 Descriptionbfwd__Description__cText(255)
 Durationbfwd__Duration__cNumber(18, 0)
 Namebfwd__PublicName__cText(255)
 Organisation Idbfwd__OrganisationID__cText(36)
 Payment Terms(Days)bfwd__PaymentTerms__cNumber(18, 0)
 Periodbfwd__Period__cPicklist
 PrivateNamebfwd__PrivateName__cText(255)
 StartDatebfwd__StartDate__cDate/Time
 Typebfwd__Type__cPicklist
    
BFQuoteAccountbfwd__Account__cLookup(Account)
 bfIDbfwd__bfID__cText(36) (External ID)
 Contact Namebfwd__ContactName__cFormula (Text)
 Descriptionbfwd__Description__cText Area(255)
 Expiration Datebfwd__ExpirationDate__cDate
 Quotebfwd__Quote__cLookup(Quote)
 Statusbfwd__Status__cPicklist
 Total Pricebfwd__TotalPrice__cRoll-Up Summary (SUM BFQuoteLine)
    
BFQuoteLinebfIDbfwd__bfID__cText(36) (External ID)
 BFQuotebfwd__BFQuote__cMaster-Detail(BFQuote)
 BFRatePlanbfwd__BFRatePlan__cLookup(BFRatePlan)
 Discountbfwd__Discount__cCurrency(16, 2)
 PercentageDiscountbfwd__PercentageDiscount__cPercent(3, 2)
 Quantitybfwd__Quantity__cNumber(18, 0)
 Subtotalbfwd__Subtotal__cCurrency(16, 2)
 TotalPricebfwd__TotalPrice__cCurrency(16, 2)
 UnitPricebfwd__UnitPrice__cCurrency(16, 2)
    
BFQuoteLineValuebfIDbfwd__bfID__cText(36) (External ID)
 BFPricingComponentbfwd__BFPricingComponent__cLookup(BFPricingComponent)
 BFQuoteLinebfwd__BFQuoteLine__cLookup(BFQuoteLine)
 Discountbfwd__Discount__cCurrency(16, 2)
 Discount (%)bfwd__PercentageDiscount__cPercent(3, 2)
 Line Itembfwd__PricingComponentName__cText(255)
 PricingComponentIDbfwd__PricingComponentID__cText(36)
 Productbfwd__BFProductName__cText(255)
 Quantitybfwd__Quantity__cNumber(18, 0)
 QuoteLineValue Numberbfwd__QuoteLineValue_Number__cAuto Number
 Rate Planbfwd__RatePlanName__cText(255)
 RatePlanIDbfwd__RatePlanID__cText(36)
 Subtotalbfwd__Subtotal__cCurrency(16, 2)
 Total Pricebfwd__Price__cCurrency(16, 2)
 Unit Of Measurebfwd__UnitOfMeasure__cText(255)
 Unit Pricebfwd__UnitPrice__cCurrency(16, 2)
    
BFRatePlanBF IDbfwd__bfID__cText(36) (External ID) (Unique Case Insensitive)
 BFProductbfwd__ProductID__cLookup(BFProduct)
 Currencybfwd__Currency__cText(3)
 Deletedbfwd__Deleted__cCheckbox
 Descriptionbfwd__Description__cText(255)
 Do not Align Periodsbfwd__ProrationDisabled__cCheckbox
 Durationbfwd__Duration__cNumber(18, 0)
 Failed Payment Behaviourbfwd__FailedPaymentBehaviour__cPicklist
 Is Create Zero Value Invoicebfwd__IsCreateZeroValueInvoice__cCheckbox
 Issue Invoice Typebfwd__IssueInvoiceType__cPicklist
 Issue Period Durationbfwd__IssuePeriodDuration__cNumber(5, 0)
 Issue Period Typebfwd__IssuePeriodType__cPicklist
 Migration Pro rata Modebfwd__ProRataMode__cPicklist
 Namebfwd__PublicName__cText(255)
 OrganizationIDbfwd__OrganisationID__cText(36)
 Payment Terms(Days)bfwd__PaymentTerms__cNumber(18, 0)
 Periodbfwd__Period__cPicklist
 PrivateNamebfwd__PrivateName__cText(255)
 Product RatePlan MigrationBehaviourbfwd__ProductRatePlanMigrationBehaviour__cPicklist
 RecursionTypebfwd__RecursionType__cText(50)
 TaxStatusbfwd__TaxStatus__cPicklist
 Trialbfwd__Trial__cNumber(18, 0)
 Trial Periodbfwd__TrialPeriod__cText(50)
    
BFReceiptbfIDbfwd__bfID__cText(36) (External ID) (Unique Case Insensitive)
 BFInvoicebfwd__BFInvoiceID__cLookup(BFInvoice)
 BFPaymentbfwd__BFPaymentID__cLookup(BFPayment)
 Createdbfwd__Created__cDate/Time
 Currencybfwd__Currency__cText(3)
 Decisionbfwd__Decision__cPicklist
 Emailbfwd__Email__cFormula (Text)
 ExecutionAttemptbfwd__ExecutionAttempt__cNumber(4, 0)
 Gateway Request IDbfwd__RequestID__cText(255)
 PaymentGatewaybfwd__PaymentGateway__cText(100)
 RawDatabfwd__RawData__cLong Text Area(60000)
 Raw Reason Codebfwd__RawReasonCode__cText(255)
 ReasonCodebfwd__ReasonCode__cNumber(3, 0)
 Typebfwd__Type__cPicklist
 Valuebfwd__Value__cNumber(16, 2)
    
BFRefundbfIDbfwd__bfID__cText(36) (External ID) (Unique Case Insensitive)
 BFInvoicebfwd__BFInvoiceID__cLookup(BFInvoice)
 Currencybfwd__Currency__cText(50)
 Emailbfwd__Email__cFormula (Text)
 Reasonbfwd__Reason__cText Area(255)
 Refund Amountbfwd__Amount__cNumber(16, 2)
 Refund Statebfwd__refundState__cText(50)
    
BFSubscriptionBFAccountbfwd__BFAccountID__cLookup(BFAccount)
 bfIDbfwd__bfID__cText(36) (External ID) (Unique Case Insensitive)
 BFRatePlanbfwd__RatePlanID__cLookup(BFRatePlan)
 Contract Startbfwd__StartDate__cDate/Time
 Descriptionbfwd__Description__cText(255)
 Emailbfwd__Email__cFormula (Text)
 FailedPaymentBehaviourbfwd__FailedPaymentBehaviour__cPicklist
 FixTermSubscriptionEndbfwd__FixTermSubscriptionEnd__cDate/Time
 FixTermSubscriptionStartbfwd__FixTermSubscriptionStart__cDate/Time
 InitialPeriodStartbfwd__InitialPeriodStart__cDate/Time
 Is in Dunningbfwd__IsDunning__cCheckbox
 Is In TrialPeriodbfwd__IsInTrialPeriod__cCheckbox
 Migration Invoicing Typebfwd__MigrationInvoicingType__cPicklist
 Migration Pricing Behaviourbfwd__MigrationPricingBehaviour__cPicklist
 Namebfwd__Name__cText(255)
 OrganisationIDbfwd__OrganisationID__cText(36)
 Parentbfwd__Parent__cLookup(BFSubscription)
 PaymentTerms(Days)bfwd__PaymentTerms__cNumber(18, 0)
 PeriodEndbfwd__PeriodEnd__cDate/Time
 PeriodStartbfwd__PeriodStart__cDate/Time
 Statebfwd__State__cPicklist
 SubscriptionEndbfwd__SubscriptionEnd__cDate/Time
 Subscription Trial Period(Days)bfwd__SubscriptionTrialPeriod__cFormula (Number)
 SuccessfulPeriodsbfwd__SuccessfulPeriods__cNumber(18, 0)
 Trial Endbfwd__TrialEnd__cDate/Time
 Typebfwd__Type__cText(50)

 

Was this article helpful?
YesNo