Schema

Download schema as CSV

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)