SalesOrdersForOrderHublinesbillingPlans
SalesOrdersForOrderHublinesbillingPlans
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinesbillingPlans |
| LinesFulfillLineId [KEY] | Long | LinesFulfillLineId of SalesOrdersForOrderHublinesbillingPlans |
| BillingNumberOfPeriods | Int | Number of timeframes in a recurring invoice. |
| BillingPeriodEndDate | Date | End date of the billing timeframe. The application sets this date to the contract end date of the first billing timeframe. If the invoice does not cover the full billing timeframe, then the application sets the end date to the billing end date of the subsequent billing timeframe. |
| BillingPeriodNumber | Int | Timeframe number for the billing start date, end date, or transaction date. |
| BillingPeriodStartDate | Date | Start date of the billing timeframe. The application sets this date to the contract start date of the first billing timeframe. If the invoice does not cover the full billing timeframe, then the application sets the start date to the billing start date of the subsequent billing timeframe. |
| BillingPlanId [KEY] | Long | Value that uniquely identifies the billing plan. |
| BillingPlanTypeCode | String | Abbreviation that identifies the type of billing plan, such as periodic or milestone. |
| BillingPlanType | String | Name of the billing plan type. |
| BillingTransactionDate | Date | Date when the first invoice occurs when the sales order uses a recurring invoice. If the invoice covers only part of an invoice timeframe, then this attribute stores the date of the subsequent invoice. |
| CancellationEffectiveDate | Date | Date when recurring billing stops and no future billing occurs. |
| NetBillingAmountForEachPeriod | Double | Net amount that the application bills for each billing timeframe. |
| OverridePeriod | Int | Timeframe that includes an override amount. For example, the first invoice is for timeframe 1, the second invoice is for timeframe 2, and so on. |
| OverridePeriodAmount | Double | Override amount to apply on the timeframe. |
| OverridePeriodQuantity | Double | Quantity to use when calculating recurring billing or credit for the override timeframe. |
| PeriodicityCode | String | Timeframe of the recurring invoice. Values include Day, Week, Month, Quarter, or Year. |
| Periodicity | String | Name of the timeframe of the recurring invoice. |
| SourceBillingPlanId | String | Value that identifies the billing plan. The source application assigns this value. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| FromDate | Date | FromDate |
| HeaderId | String | HeaderId |
| OrderKey | String | OrderKey |
| OrderNumber | String | OrderNumber |
| SourceTransactionNumber | String | SourceTransactionNumber |
| SourceTransactionSystem | String | SourceTransactionSystem |
| ToDate | Date | ToDate |
| Finder | String | finder |