SfdcPartnerSbscrOffer
Represents a subscription offer made available to a partner.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier of the record. | |
| IsDeleted | Bool | Indicates whether the record has been moved to the Recycle Bin (true) or not (false). | |
| Name | String | Name of the record. | |
| CurrencyIsoCode | String | ISO code for the currency in which the record's currency fields are expressed. | |
| CreatedById | String |
User.Id | ID of the user who created the record. |
| LastModifiedDate | Datetime | Date and time when the record was last modified. | |
| LastModifiedById | String |
User.Id | ID of the user who last modified the record. |
| LastViewedDate | Datetime | Date and time when the record was last viewed by a user. | |
| LastReferencedDate | Datetime | Date and time when the record was last referenced, such as through a lookup. | |
| PartnerOrg | String | ID of the partner organization associated with this subscription offer. | |
| PartnerCompanyName | String | Name of the partner company associated with this subscription offer. | |
| CustomerName | String | Name of the customer associated with this subscription offer. | |
| OfferType | String | Type classification of the subscription offer. | |
| TermsAndConditions | String | Terms and conditions associated with the subscription offer. | |
| Status | String | Current status of the record. | |
| ContractTerm | Int | Length of the contract term for the subscription offer. | |
| ServiceStartDate | Date | Date on which the subscribed service begins. | |
| ServiceEndDate | Date | Date on which the subscribed service ends. | |
| CustBillingStreet | String | The street of the customer billing address. | |
| CustBillingCity | String | The city of the customer billing address. | |
| CustBillingState | String | The state or province of the customer billing address. | |
| CustBillingPostalCode | String | The postal or ZIP code of the customer billing address. | |
| CustBillingCountry | String | The country of the customer billing address. | |
| CustBillingLatitude | Double | The latitude coordinate of the customer billing address. | |
| CustBillingLongitude | Double | The longitude coordinate of the customer billing address. | |
| CustBillingGeocodeAccuracy | String | The geocode accuracy level of the customer billing address. | |
| CustShippingStreet | String | The street of the customer shipping address. | |
| CustShippingCity | String | The city of the customer shipping address. | |
| CustShippingState | String | The state or province of the customer shipping address. | |
| CustShippingPostalCode | String | The postal or ZIP code of the customer shipping address. | |
| CustShippingCountry | String | The country of the customer shipping address. | |
| CustShippingLatitude | Double | The latitude coordinate of the customer shipping address. | |
| CustShippingLongitude | Double | The longitude coordinate of the customer shipping address. | |
| CustShippingGeocodeAccuracy | String | The geocode accuracy level of the customer shipping address. | |
| CustomerBillingEmailAddress | String | Email address used to bill the customer for this subscription offer. | |
| SubTotal | Decimal | Subtotal amount of the subscription offer, before tax. | |
| CustomerPurchaseOrderNumber | String | Purchase order number provided by the customer for this subscription offer. | |
| CustomerEmailAddress | String | Email address of the customer associated with this subscription offer. | |
| OrderPrebillDays | Int | Number of days before the service period that the customer is billed. | |
| BillingFrequency | String | Frequency at which the customer is billed for this subscription offer. | |
| PaymentMethod | String | Payment method used by the customer for this subscription offer. | |
| ExpirationDate | Date | Date on which the subscription offer expires. | |
| CustomerPaymentTerms | String | Payment terms agreed to by the customer for this subscription offer. | |
| SyncToPboLastUpdate | Datetime | Date and time when this offer was last synchronized to the partner billing organization. | |
| SyncToPboStatus | String | Status of the synchronization of this offer to the partner billing organization. | |
| PartnerOffer | String | ID of the partner offer associated with this subscription. | |
| RespondingUserId | String |
User.Id | ID of the user who responded to this subscription offer. |
| ServiceTerm | Double | Length of the service term for the subscription offer. | |
| SyncToPboError | String | Error message recorded if synchronization to the partner billing organization failed. | |
| SystemModstamp | Datetime | Date and time when the record was last modified by a user or by an automated process. | |
| CreatedDate | Datetime | Date and time when the record was created. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| SOQL | String | Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. |