Table 8073 "Subscription Line Archive"
Subscription Billing · Microsoft.SubscriptionBilling
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 13 connected objects and pages
Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Subscription Line Archive |
| DataClassification | CustomerContent |
| LookupPageId | Service Commitment Archive |
| DrillDownPageId | Service Commitment Archive |
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 | Entry No. | Integer | — | AutoIncrement |
| 2 | Subscription Header No. | Code[20] | Subscription No. caption | TableRelation Table 8057 “Subscription Header” (Subscription Header) |
| 4 | Original Entry No. | Integer | — | |
| 5 | Subscription Package Code | Code[20] | — | TableRelation Table 8055 “Subscription Package” (Subscription Package); not editable; NotBlank |
| 6 | Template | Code[20] | — | TableRelation Table 8054 “Sub. Package Line Template” (Sub. Package Line Template); not editable; NotBlank |
| 7 | Description | Text[100] | Specifies the description of the Subscription Line. via Page 8094 “Service Commitment Archive” | |
| 8 | Subscription Line Start Date | Date | Specifies the date from which the Subscription Line is valid and will be invoiced. via Page 8094 “Service Commitment Archive” | |
| 9 | Subscription Line End Date | Date | Specifies the date up to which the Subscription Line is valid. via Page 8094 “Service Commitment Archive” | |
| 10 | Next Billing Date | Date | — | not editable |
| 11 | Calculation Base Amount | Decimal | Specifies the base amount from which the price will be calculated. via Page 8094 “Service Commitment Archive” | |
| 12 | Calculation Base % | Decimal | Specifies the percent at which the price of the Subscription Line will be calculated. 100% means that the price corresponds to the Base Price. via Page 8094 “Service Commitment Archive” | |
| 13 | Price | Decimal | Specifies the price of the Subscription Line with quantity of 1 in the billing period. The price is calculated from Base Price and Base Price %. via Page 8094 “Service Commitment Archive” | not editable |
| 14 | Discount % | Decimal | Specifies the percent of the discount for the Subscription Line. via Page 8094 “Service Commitment Archive” | |
| 15 | Discount Amount | Decimal | Specifies the amount of the discount for the Subscription Line. via Page 8094 “Service Commitment Archive” | |
| 16 | Amount | Decimal | Specifies the amount for the Subscription Line including discount. via Page 8094 “Service Commitment Archive” | |
| 17 | Billing Base Period | DateFormula | Specifies for which period the Amount is valid. If you enter 1M here, a period of one month, or 12M, a period of 1 year, to which Amount refers to. via Page 8094 “Service Commitment Archive” | |
| 18 | Invoicing via | Enum “Invoicing Via” | Specifies whether the Subscription Line will be invoiced using contract or sales document. via Page 8094 “Service Commitment Archive” | enum Enum 8051 “Invoicing Via” |
| 19 | Invoicing Item No. | Code[20] | — | TableRelation Item.“No.” where(“Subscription Option” = filter(“Invoicing Item” | “Service Commitment Item”)) |
| 20 | Partner | Enum “Service Partner” | Specifies whether the Subscription Line will will be calculated as a credit (Purchase Invoice) or as debit (Sales Invoice). via Page 8094 “Service Commitment Archive” | enum Enum 8053 “Service Partner” |
| 21 | Subscription Contract No. | Code[20] | Specifies in which contract the Subscription Line will be calculated. via Page 8094 “Service Commitment Archive” | TableRelation Table 8052 “Customer Subscription Contract”, Table 8063 “Vendor Subscription Contract” (if (Partner = const(Customer)) “Customer Subscription Contract” where(“Sell-to Customer No.” = field(“Sub. Header Customer No.”)) else if (Partner = const(Vendor)) “Vendor Subscription Contract”) |
| 22 | Notice Period | DateFormula | — | |
| 23 | Initial Term | DateFormula | Specifies a date formula for calculating the minimum term of the Subscription Line. If the minimum term is filled and no extension term is entered, the end of Subscription Line is automatically set to the end of the initial term. via Page 8094 “Service Commitment Archive” | |
| 24 | Extension Term | DateFormula | Specifies a date formula for automatic renewal after initial term and the rhythm of the update of “Notice possible to” and “Term Until”. via Page 8094 “Service Commitment Archive” | |
| 25 | Billing Rhythm | DateFormula | Specifies the Date formula for Rhythm in which the Subscription Line is invoiced. Using a Dateformula rhythm can be, for example, a monthly, a quarterly or a yearly invoicing. via Page 8094 “Service Commitment Archive” | |
| 26 | Cancellation Possible Until | Date | Specifies the last date for a timely termination. The date is determined by the initial term, extension term and a notice period. An initial term of 12 months and a 3-month notice period means that the deadline for a notice of termination is after 9 months. An extension period of 12 months postpones… via Page 8094 “Service Commitment Archive” | |
| 27 | Term Until | Date | Specifies the earliest regular date for the end of the Subscription Line, taking into account the initial term, extension term and a notice period. An initial term of 24 months results in a fixed term of 2 years. An extension period of 12 months postpones this date by 12 months. via Page 8094 “Service Commitment Archive” | |
| 28 | Sub. Header Customer No. | Code[20] | Subscription Header Customer No. caption | FlowField: lookup(“Subscription Header”.“End-User Customer No.” where(“No.” = field(“Subscription Header No.”))); not editable |
| 29 | Subscription Contract Line No. | Integer | — | TableRelation Table 8062 “Cust. Sub. Contract Line”, Table 8065 “Vend. Sub. Contract Line” (if (Partner = const(Customer)) “Cust. Sub. Contract Line”.“Line No.” where(“Subscription Contract No.” = field(“Subscription Contract No.”)) else if (Partner = const(Vendor)) “Vend. Sub. Contract Line”.“Line No.” where(“Subscription Contract No.” = field(“Subscription Contract No.”))) |
| 30 | Customer Price Group | Code[10] | — | TableRelation Table 6 “Customer Price Group” (Customer Price Group); not editable |
| 31 | Shortcut Dimension 1 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 32 | Shortcut Dimension 2 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 33 | Price (LCY) | Decimal | — | not editable |
| 34 | Discount Amount (LCY) | Decimal | — | not editable |
| 35 | Amount (LCY) | Decimal | — | not editable |
| 36 | Currency Code | Code[10] | Specifies the currency of amounts in the Subscription Line. via Page 8094 “Service Commitment Archive” | TableRelation Table 4 “Currency”; not editable |
| 37 | Currency Factor | Decimal | — | not editable |
| 38 | Currency Factor Date | Date | — | not editable |
| 39 | Calculation Base Amount (LCY) | Decimal | — | not editable |
| 40 | Discount | Boolean | Specifies whether the Subscription Line is used as a basis for periodic invoicing or discounts. via Page 8094 “Service Commitment Archive” | not editable |
| 41 | Serial No. (Sub. Header) | Code[50] | Specifies the serial no. of the Subscription before the change. via Page 8094 “Service Commitment Archive” | not editable |
| 42 | Quantity (Sub. Header) | Decimal | Specifies the units of the Subscription before the change. via Page 8094 “Service Commitment Archive” | |
| 50 | Next Price Update | Date | Specifies the date of the next price update. via Page 8094 “Service Commitment Archive” | |
| 53 | Type Of Update | Enum “Type Of Price Update” | Specifies, whether the Planned Subscription Line has been created by a Price Update. via Page 8094 “Service Commitment Archive” | enum Enum 8004 “Type Of Price Update” |
| 54 | Perform Update On | Date | Specifies the date, the price update will take affect if no date is specified in the contract line. If empty the “Next Price Update” of the contract line is used. via Page 8094 “Service Commitment Archive” | |
| 96 | Variant Code (Sub. Header) | Code[10] | Specifies the variant code of the Subscription before the change. via Page 8094 “Service Commitment Archive” | |
| 100 | Unit Cost | Decimal | — | not editable |
| 101 | Unit Cost (LCY) | Decimal | Specifies the unit cost of the item. via Page 8094 “Service Commitment Archive” | |
| 107 | Closed | Boolean | — | |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 8000 | Usage Based Billing | Boolean | Specifies whether usage data is used as the basis for billing via contracts. | not editable |
| 8001 | Usage Based Pricing | Enum “Usage Based Pricing” | Specifies the method for customer based pricing. | enum Enum 8007 “Usage Based Pricing”; not editable |
| 8002 | Pricing Unit Cost Surcharge % | Decimal | Specifies the surcharge in percent for the debit-side price calculation, if a unit cost surcharge is to be used. | not editable |
Keys
- PK: Entry No.
- SK1: Subscription Header No., Original Entry No.
Events published
OnAfterCopyFromSubscriptionLine(var SubscriptionLineArchive: Record "Subscription Line Archive"; SubscriptionLine: Record "Subscription Line")(integration)
Procedures
CopyFromServiceCommitment(ServiceCommitment: Record "Subscription Line")(internal)FilterOnServiceCommitment(OriginalEntryNo: Integer)(internal)
Relations
- drill-down page Page 8094 “Service Commitment Archive”
- lookup page Page 8094 “Service Commitment Archive”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Customer Price Group: TableRelation Table 6 “Customer Price Group”
- Subscription Contract No.: TableRelation Table 8052 “Customer Subscription Contract” (conditional)
- Template: TableRelation Table 8054 “Sub. Package Line Template”
- Subscription Package Code: TableRelation Table 8055 “Subscription Package”
- Sub. Header Customer No.: CalcFormula Table 8057 “Subscription Header”
- Subscription Header No.: TableRelation Table 8057 “Subscription Header”
- Subscription Contract Line No.: TableRelation Table 8062 “Cust. Sub. Contract Line” (conditional)
- Subscription Contract No.: TableRelation Table 8063 “Vendor Subscription Contract” (conditional)
- Subscription Contract Line No.: TableRelation Table 8065 “Vend. Sub. Contract Line” (conditional)
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 8057 “Subscription Header”: Archived Sub. Lines exist
Pages and codeunits on this table
- Page 8094 “Service Commitment Archive” (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 Line Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.