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 | |
| bfwd__Email__c | |||
| 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 | |
| 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 | |
| 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) | |
| 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) | |
| 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) |