Table 8051 "Subscription Contract Setup"
Subscription Billing · Microsoft.SubscriptionBilling
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 5 connected objects and pages
Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 8051 “Service Contract Setup” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Subscription Contract Setup |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Primary Key | Code[10] | — | |
| 2 | Cust. Sub. Contract Nos. | Code[20] | Specifies the code for the number series that will be used to assign numbers to Customer Subscription Contracts. via Page 8051 “Service Contract Setup” | TableRelation No. Series |
| 3 | Vend. Sub. Contract Nos. | Code[20] | Specifies the code for the number series that will be used to assign numbers to Vendor Subscription Contracts. via Page 8051 “Service Contract Setup” | TableRelation No. Series |
| 4 | Subscription Header No. | Code[20] | Specifies the code for the number series that will be used to assign numbers to Subscriptions. via Page 8051 “Service Contract Setup” | TableRelation No. Series |
| 5 | Aut. Insert C. Contr. DimValue | Boolean | Specifies whether the contract number is also automatically created as a dimension value when a Customer Subscription Contract is created. via Page 8051 “Service Contract Setup” | |
| 6 | Sub. Line Start Date Inv. Pick | Enum “Serv. Start Date For Inv. Pick” | Specifies the date field, that will be used as Subscription Start Date of the Subscription Line, if the item is shipped in a inventory pick. via Page 8051 “Service Contract Setup” | enum Enum 8000 “Serv. Start Date For Inv. Pick” |
| 7 | Overdue Date Formula | DateFormula | Specifies the default date formula which will be used for filtering overdue Subscription Lines. via Page 8051 “Service Contract Setup” | |
| 10 | Contract Invoice Description | Enum “Contract Invoice Text Type” | Specifies which information is used for Sales Invoice line description. via Page 8051 “Service Contract Setup” | enum Enum 8001 “Contract Invoice Text Type” |
| 11 | Contract Invoice Add. Line 1 | Enum “Contract Invoice Text Type” | Specifies which information is used for the first additional line. via Page 8051 “Service Contract Setup” | enum Enum 8001 “Contract Invoice Text Type” |
| 12 | Contract Invoice Add. Line 2 | Enum “Contract Invoice Text Type” | Specifies which information is used for the second additional line. via Page 8051 “Service Contract Setup” | enum Enum 8001 “Contract Invoice Text Type” |
| 13 | Contract Invoice Add. Line 3 | Enum “Contract Invoice Text Type” | Specifies which information is used for the third additional line. via Page 8051 “Service Contract Setup” | enum Enum 8001 “Contract Invoice Text Type” |
| 14 | Contract Invoice Add. Line 4 | Enum “Contract Invoice Text Type” | Specifies which information is used for the fourth additional line. via Page 8051 “Service Contract Setup” | enum Enum 8001 “Contract Invoice Text Type” |
| 15 | Contract Invoice Add. Line 5 | Enum “Contract Invoice Text Type” | Specifies which information is used for the fifth additional line. via Page 8051 “Service Contract Setup” | enum Enum 8001 “Contract Invoice Text Type” |
| 20 | Origin Name collective Invoice | Enum “Contract Origin Name Type” | Specifies which customer information (name) is transferred to collective invoices. This setting is applies for collective invoices only. via Page 8051 “Service Contract Setup” | enum Enum 8002 “Contract Origin Name Type” |
| 21 | Dimension Code Cust. Contr. | Code[20] | Specifies the Dimension Code that is used for Customer Subscription Contracts. via Page 8051 “Service Contract Setup” | TableRelation Table 348 “Dimension” |
| 30 | Invoice Desc. (Surcharge) | Enum “Invoice Detail Origin” | Specifies the origin of the invoice details’ description for usage data to be charged as Unit Cost Surcharge. via Page 8051 “Service Contract Setup” | enum Enum 8021 “Invoice Detail Origin” |
| 59 | Default Period Calculation | enum “Period Calculation” | Specifies which Period Calculation will initially be set in Subscription Package line. via Page 8051 “Service Contract Setup” | enum Enum 8005 “Period Calculation” |
| 60 | Default Billing Base Period | DateFormula | Specifies the default period to which the Subscription Line amount relates. For example, enter 1M if the amount relates to one month or 12M if the amount relates to 1 year. via Page 8051 “Service Contract Setup” | |
| 61 | Default Billing Rhythm | DateFormula | Specifies the default rhythm in which the Subscription Line is calculated. Using a date formula, the rhythm can be defined as monthly, quarterly or annual calculation. via Page 8051 “Service Contract Setup” | |
| 180 | Def. Rel. Jnl. Template Name | Code[10] | Specifies the name of the journal template to use for posting of deferrals release. via Page 8051 “Service Contract Setup” | TableRelation Table 80 “Gen. Journal Template” (Gen. Journal Template) |
| 181 | Def. Rel. Jnl. Batch Name | Code[10] | Specifies the name of the journal batch to use for posting of deferrals release. via Page 8051 “Service Contract Setup” | TableRelation Table 232 “Gen. Journal Batch” (if (“Def. Rel. Jnl. Template Name” = filter(<> ‘’)) “Gen. Journal Batch”.Name where(“Journal Template Name” = field(“Def. Rel. Jnl. Template Name”))) |
| 182 | Create Contract Deferrals | Enum “Create Contract Deferrals” | Specifies whether deferrals are created for new Subscription lines by default. via Page 8051 “Service Contract Setup” | enum Enum 8020 “Create Contract Deferrals” |
Keys
- PK: Primary Key (clustered)
Procedures
ContractTextsCreateDefaults()VerifyContractTextsSetup()CheckPrerequisitesForCreatingManualContractLine()InitRecord()(internal)
Plus 1 local procedures.
Relations
- Def. Rel. Jnl. Batch Name: TableRelation Table 232 “Gen. Journal Batch”
- Dimension Code Cust. Contr.: TableRelation Table 348 “Dimension”
- Def. Rel. Jnl. Template Name: TableRelation Table 80 “Gen. Journal Template”
Pages and codeunits on this table
- Page 8051 “Service Contract Setup” (source table)
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Subscription Contract Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.