Salesforce Schema

BillForward Salesforce Schema
Billforward Custom Objects Field Label API Name Data Type
BFAccount Account bfwd__Account__c Lookup(Account)
  AdditionalInformation bfwd__AdditionalInformation__c Text(255)
  bfID bfwd__bfID__c Text(36) (External ID) (Unique Case Insensitive)
  City bfwd__City__c Text(255)
  Company bfwd__Company__c Formula (Text)
  CompanyName bfwd__CompanyName__c Text(255)
  Country bfwd__Country__c Text(255)
  Date of Birth bfwd__DOB__c Date
  Deleted bfwd__Deleted__c Checkbox
  Email bfwd__Email__c Email
  Fax bfwd__Fax__c Text(100)
  First Name bfwd__FirstName__c Text(255)
  Land Line bfwd__LandLine__c Text(255)
  Last Name bfwd__LastName__c Text(255)
  LogoURL bfwd__LogoURL__c URL(255)
  Mobile bfwd__Mobile__c Text(255)
  OrganizationID bfwd__OrganisationID__c Text(36)
  PostCode bfwd__PostCode__c Text(255)
  Source bfwd__Source__c Text(255)
  State bfwd__State__c Text(255)
  Street bfwd__Street__c Text Area(255)
  Updated bfwd__Updated__c Date/Time
  VatNumber bfwd__VatNumber__c Text(100)
       
BFCreditNote BFAccount bfwd__BFAccountID__c Lookup(BFAccount)
  bfID bfwd__bfID__c Text(36) (External ID) (Unique Case Insensitive)
  BFInvoice bfwd__BFInvoiceID__c Lookup(BFInvoice)
  BFSubscription bfwd__BFSubscriptionID__c Lookup(BFSubscription)
  Currency bfwd__Currency__c Picklist
  Description bfwd__Description__c Text(255)
  Remaining Value bfwd__RemainingValue__c Number(16, 2)
  Value bfwd__Value__c Number(16, 2)
       
BFInvoice bfID bfwd__bfID__c Text(36) (External ID) (Unique Case Insensitive)
  BFSubscription bfwd__BFSubscriptionID__c Lookup(BFSubscription)
  Cost bfwd__Cost__c Number(16, 2)
  Cost (ex tax) bfwd__CostExcludingTax__c Number(16, 2)
  Currency bfwd__Currency__c Text(3)
  Discount bfwd__Discount__c Number(16, 2)
  Due Date bfwd__DueDate__c Date
  Email bfwd__Email__c Formula (Text)
  Invoice Lines bfwd__InvoiceLines__c Rich Text Area(32768)
  Is Initial Invoice bfwd__IsInitialInvoice__c Checkbox
  NextExecutionAttempt bfwd__NextExecutionAttempt__c Date/Time
  OrganisationID bfwd__OrganisationID__c Text(36)
  PaymentReceived bfwd__PaymentReceived__c Date/Time
  PaymentTerms(Days) bfwd__PaymentTerms__c Number(18, 0)
  Period End bfwd__PeriodEnd__c Date/Time
  Period Start bfwd__PeriodStart__c Date/Time
  State bfwd__State__c Picklist
  TotalBillPaid bfwd__TotalBillPaid__c Number(16, 2)
  TotalExecutionAttempts bfwd__TotalExecutionAttempts__c Number(18, 0)
  Type bfwd__Type__c Text(50)
       
BFPayment bfID bfwd__bfID__c Text(36) (External ID) (Unique Case Insensitive)
  BFInvoice bfwd__BFInvoiceID__c Lookup(BFInvoice)
  BFPaymentMethod bfwd__BFPaymentMethod__c Lookup(BFPaymentMethod)
  Currency bfwd__Currency__c Text(3)
  Gateway bfwd__Gateway__c Text(100)
  Offline Payment Transaction Number bfwd__OfflinePaymentTransactionNo__c Text(255)
  Offline Payment Type bfwd__OfflinePaymentType__c Picklist
  Other Offline Payment Type bfwd__OtherOfflinePaymentType__c Text(255)
  Received bfwd__Received__c Date/Time
  Refunded bfwd__RefundedValue__c Number(16, 2)
  Remaining bfwd__RemainingValue__c Number(16, 2)
  Type bfwd__Type__c Picklist
  Value bfwd__ActualValue__c Number(16, 2)
  Value (nominal) bfwd__NominalValue__c Number(16, 2)
       
BFPaymentMethod BFAccount bfwd__BFAccount__c Lookup(BFAccount)
  bfID bfwd__bfID__c Text(36) (External ID)
  Card Holder Name bfwd__CardHolderName__c Text(255)
  Card Type bfwd__CardType__c Text(50)
  Country bfwd__Country__c Text(100)
  DefaultPaymentMethod bfwd__DefaultPaymentMethod__c Checkbox
  Deleted bfwd__Deleted__c Checkbox
  Description bfwd__Description__c Text(255)
  Expiry Date bfwd__ExpiryDate__c Text(10)
  FirstSix bfwd__FirstSix__c Text(6)
  Gateway bfwd__Gateway__c Text(100)
  LastFour bfwd__LastFour__c Text(4)
  Province bfwd__Province__c Text(100)
  State bfwd__State__c Text(15)
       
BFPaymentMethodSubscription bfID bfwd__bfID__c Text(36) (External ID)
  BFPaymentMethod bfwd__BFPaymentMethodID__c Master-Detail(BFPaymentMethod)
  BFSubscription bfwd__BFSubscriptionID__c Master-Detail(BFSubscription)
  Deleted bfwd__Deleted__c Checkbox
  OrganizationID bfwd__OrganisationID__c Text(36)
       
BFPricingComponent bfID bfwd__bfID__c Text(36) (External ID)
  BFRatePlan bfwd__BFRatePlanID__c Lookup(BFRatePlan)
  ChargeModel bfwd__ChargeModel__c Text(50)
  ChargeType bfwd__ChargeType__c Text(50)
  Description bfwd__Description__c Text(255)
  DowngradeMode bfwd__DowngradeMode__c Text(50)
  Name bfwd__PublicName__c Text(255)
  PrivateName bfwd__privateName__c Text(255)
  UnitOfMeasure bfwd__UnitOfMeasure__c Text(255)
  UnitOfMeasureID bfwd__UnitOfMeasureID__c Text(36)
  UpgradeMode bfwd__UpgradeMode__c Text(50)
  VersionID bfwd__VersionID__c Text(36)
       
BFPricingComponentTier bfID bfwd__bfID__c Text(36) (External ID)
  BFPricingComponent bfwd__BFPricingComponentID__c Lookup(BFPricingComponent)
  LowerThreshold bfwd__LowerThreshold__c Number(18, 0)
  Price bfwd__Price__c Number(16, 2)
  PricingComponentVersionID bfwd__PricingComponentVersionID__c Formula (Text)
  PricingType bfwd__PricingType__c Picklist
  UpperThreshold bfwd__UpperThreshold__c Number(18, 0)
  Valid From bfwd__ValidFrom__c Date/Time
  Valid Till bfwd__ValidTill__c Date/Time
       
BFPricingComponentValue bfID bfwd__bfID__c Text(50) (External ID)
  BFPricingComponent bfwd__BFPricingComponentID__c Lookup(BFPricingComponent)
  BFSubscription bfwd__BFSubscription__c Lookup(BFSubscription)
  Valid From bfwd__ValidFrom__c Date/Time
  Valid Till bfwd__ValidTill__c Date/Time
  Value bfwd__value__c Number(18, 0)
       
BFProduct BF ID bfwd__bfID__c Text(36) (External ID) (Unique Case Insensitive)
  BFProductLink bfwd__ProductLink__c Formula (Text)
  Deleted bfwd__Deleted__c Checkbox
  Description bfwd__Description__c Text(255)
  Duration bfwd__Duration__c Number(18, 0)
  Name bfwd__PublicName__c Text(255)
  Organisation Id bfwd__OrganisationID__c Text(36)
  Payment Terms(Days) bfwd__PaymentTerms__c Number(18, 0)
  Period bfwd__Period__c Picklist
  PrivateName bfwd__PrivateName__c Text(255)
  StartDate bfwd__StartDate__c Date/Time
  Type bfwd__Type__c Picklist
       
BFQuote Account bfwd__Account__c Lookup(Account)
  bfID bfwd__bfID__c Text(36) (External ID)
  Contact Name bfwd__ContactName__c Formula (Text)
  Description bfwd__Description__c Text Area(255)
  Expiration Date bfwd__ExpirationDate__c Date
  Quote bfwd__Quote__c Lookup(Quote)
  Status bfwd__Status__c Picklist
  Total Price bfwd__TotalPrice__c Roll-Up Summary (SUM BFQuoteLine)
       
BFQuoteLine bfID bfwd__bfID__c Text(36) (External ID)
  BFQuote bfwd__BFQuote__c Master-Detail(BFQuote)
  BFRatePlan bfwd__BFRatePlan__c Lookup(BFRatePlan)
  Discount bfwd__Discount__c Currency(16, 2)
  PercentageDiscount bfwd__PercentageDiscount__c Percent(3, 2)
  Quantity bfwd__Quantity__c Number(18, 0)
  Subtotal bfwd__Subtotal__c Currency(16, 2)
  TotalPrice bfwd__TotalPrice__c Currency(16, 2)
  UnitPrice bfwd__UnitPrice__c Currency(16, 2)
       
BFQuoteLineValue bfID bfwd__bfID__c Text(36) (External ID)
  BFPricingComponent bfwd__BFPricingComponent__c Lookup(BFPricingComponent)
  BFQuoteLine bfwd__BFQuoteLine__c Lookup(BFQuoteLine)
  Discount bfwd__Discount__c Currency(16, 2)
  Discount (%) bfwd__PercentageDiscount__c Percent(3, 2)
  Line Item bfwd__PricingComponentName__c Text(255)
  PricingComponentID bfwd__PricingComponentID__c Text(36)
  Product bfwd__BFProductName__c Text(255)
  Quantity bfwd__Quantity__c Number(18, 0)
  QuoteLineValue Number bfwd__QuoteLineValue_Number__c Auto Number
  Rate Plan bfwd__RatePlanName__c Text(255)
  RatePlanID bfwd__RatePlanID__c Text(36)
  Subtotal bfwd__Subtotal__c Currency(16, 2)
  Total Price bfwd__Price__c Currency(16, 2)
  Unit Of Measure bfwd__UnitOfMeasure__c Text(255)
  Unit Price bfwd__UnitPrice__c Currency(16, 2)
       
BFRatePlan BF ID bfwd__bfID__c Text(36) (External ID) (Unique Case Insensitive)
  BFProduct bfwd__ProductID__c Lookup(BFProduct)
  Currency bfwd__Currency__c Text(3)
  Deleted bfwd__Deleted__c Checkbox
  Description bfwd__Description__c Text(255)
  Do not Align Periods bfwd__ProrationDisabled__c Checkbox
  Duration bfwd__Duration__c Number(18, 0)
  Failed Payment Behaviour bfwd__FailedPaymentBehaviour__c Picklist
  Is Create Zero Value Invoice bfwd__IsCreateZeroValueInvoice__c Checkbox
  Issue Invoice Type bfwd__IssueInvoiceType__c Picklist
  Issue Period Duration bfwd__IssuePeriodDuration__c Number(5, 0)
  Issue Period Type bfwd__IssuePeriodType__c Picklist
  Migration Pro rata Mode bfwd__ProRataMode__c Picklist
  Name bfwd__PublicName__c Text(255)
  OrganizationID bfwd__OrganisationID__c Text(36)
  Payment Terms(Days) bfwd__PaymentTerms__c Number(18, 0)
  Period bfwd__Period__c Picklist
  PrivateName bfwd__PrivateName__c Text(255)
  Product RatePlan MigrationBehaviour bfwd__ProductRatePlanMigrationBehaviour__c Picklist
  RecursionType bfwd__RecursionType__c Text(50)
  TaxStatus bfwd__TaxStatus__c Picklist
  Trial bfwd__Trial__c Number(18, 0)
  Trial Period bfwd__TrialPeriod__c Text(50)
       
BFReceipt bfID bfwd__bfID__c Text(36) (External ID) (Unique Case Insensitive)
  BFInvoice bfwd__BFInvoiceID__c Lookup(BFInvoice)
  BFPayment bfwd__BFPaymentID__c Lookup(BFPayment)
  Created bfwd__Created__c Date/Time
  Currency bfwd__Currency__c Text(3)
  Decision bfwd__Decision__c Picklist
  Email bfwd__Email__c Formula (Text)
  ExecutionAttempt bfwd__ExecutionAttempt__c Number(4, 0)
  Gateway Request ID bfwd__RequestID__c Text(255)
  PaymentGateway bfwd__PaymentGateway__c Text(100)
  RawData bfwd__RawData__c Long Text Area(60000)
  Raw Reason Code bfwd__RawReasonCode__c Text(255)
  ReasonCode bfwd__ReasonCode__c Number(3, 0)
  Type bfwd__Type__c Picklist
  Value bfwd__Value__c Number(16, 2)
       
BFRefund bfID bfwd__bfID__c Text(36) (External ID) (Unique Case Insensitive)
  BFInvoice bfwd__BFInvoiceID__c Lookup(BFInvoice)
  Currency bfwd__Currency__c Text(50)
  Email bfwd__Email__c Formula (Text)
  Reason bfwd__Reason__c Text Area(255)
  Refund Amount bfwd__Amount__c Number(16, 2)
  Refund State bfwd__refundState__c Text(50)
       
BFSubscription BFAccount bfwd__BFAccountID__c Lookup(BFAccount)
  bfID bfwd__bfID__c Text(36) (External ID) (Unique Case Insensitive)
  BFRatePlan bfwd__RatePlanID__c Lookup(BFRatePlan)
  Contract Start bfwd__StartDate__c Date/Time
  Description bfwd__Description__c Text(255)
  Email bfwd__Email__c Formula (Text)
  FailedPaymentBehaviour bfwd__FailedPaymentBehaviour__c Picklist
  FixTermSubscriptionEnd bfwd__FixTermSubscriptionEnd__c Date/Time
  FixTermSubscriptionStart bfwd__FixTermSubscriptionStart__c Date/Time
  InitialPeriodStart bfwd__InitialPeriodStart__c Date/Time
  Is in Dunning bfwd__IsDunning__c Checkbox
  Is In TrialPeriod bfwd__IsInTrialPeriod__c Checkbox
  Migration Invoicing Type bfwd__MigrationInvoicingType__c Picklist
  Migration Pricing Behaviour bfwd__MigrationPricingBehaviour__c Picklist
  Name bfwd__Name__c Text(255)
  OrganisationID bfwd__OrganisationID__c Text(36)
  Parent bfwd__Parent__c Lookup(BFSubscription)
  PaymentTerms(Days) bfwd__PaymentTerms__c Number(18, 0)
  PeriodEnd bfwd__PeriodEnd__c Date/Time
  PeriodStart bfwd__PeriodStart__c Date/Time
  State bfwd__State__c Picklist
  SubscriptionEnd bfwd__SubscriptionEnd__c Date/Time
  Subscription Trial Period(Days) bfwd__SubscriptionTrialPeriod__c Formula (Number)
  SuccessfulPeriods bfwd__SuccessfulPeriods__c Number(18, 0)
  Trial End bfwd__TrialEnd__c Date/Time
  Type bfwd__Type__c Text(50)