Table 8016 "Usage Data Supp. Subscription"
Subscription Billing · Microsoft.SubscriptionBilling
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 11 connected objects and pages
Subscription Billing · Microsoft.SubscriptionBilling · captioned “Usage Data Supplier Subscription” · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 8042 “Usage Data Subscriptions” (4 Learn pages), Page 8031 “Connect Subscription To SO” (1).
Properties
| Property | Value |
|---|---|
| Caption | Usage Data Supplier Subscription |
| DataClassification | CustomerContent |
| LookupPageId | Usage Data Subscriptions |
| DrillDownPageId | Usage Data Subscriptions |
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 | Specifies the sequential number assigned to the record when it was created. via Page 8031 “Connect Subscription To SO” | AutoIncrement |
| 2 | Supplier No. | Code[20] | Specifies the number of the supplier to which this subscription refers. via Page 8031 “Connect Subscription To SO” | TableRelation Table 8014 “Usage Data Supplier” (Usage Data Supplier) |
| 3 | Supplier Description | Text[80] | Specifies the description of the supplier to which this subscription refers. via Page 8031 “Connect Subscription To SO” | FlowField: lookup(“Usage Data Supplier”.Description where(“No.” = field(“Supplier No.”))); not editable |
| 4 | Customer No. | Code[20] | Specifies the internal number of the customer to which this subscription refers. via Page 8031 “Connect Subscription To SO” | TableRelation Table 18 “Customer” |
| 5 | Customer Name | Text[100] | Specifies the name of the customer to which this subscription refers. via Page 8031 “Connect Subscription To SO” | FlowField: lookup(Customer.Name where(“No.” = field(“Customer No.”))); not editable |
| 6 | Subscription Header No. | Code[20] | Specifies the number of the Subscription to which this subscription refers. via Page 8031 “Connect Subscription To SO” | not editable |
| 7 | Subscription Line Entry No. | Integer | Specifies the Subscription Line to which this subscription is linked. via Page 8031 “Connect Subscription To SO” | TableRelation Table 8059 “Subscription Line” (Subscription Line); not editable |
| 8 | Product Name | Text[100] | Specifies the vendor’s product name for this subscription. via Page 8031 “Connect Subscription To SO” | |
| 9 | Status | Enum “Usage Data Subscription Status” | Specifies the status of this subscription. via Page 8031 “Connect Subscription To SO” | enum Enum 8014 “Usage Data Subscription Status” |
| 10 | Billing Cycle | Enum “Billing Cycle” | Specifies the billing cycle of the subscription. via Page 8031 “Connect Subscription To SO” | enum Enum 8011 “Billing Cycle” |
| 11 | Quantity | Decimal | Specifies the quantity that refers to this subscription. via Page 8031 “Connect Subscription To SO” | |
| 12 | Start Date | Date | Specifies when the subscription was created. via Page 8031 “Connect Subscription To SO” | |
| 13 | End Date | Date | Specifies the end date of the subscription. via Page 8031 “Connect Subscription To SO” | |
| 14 | Supplier Reference Entry No. | Integer | Specifies the sequential number of the ID in the reference table for this subscription. via Page 8031 “Connect Subscription To SO” | TableRelation Table 8015 “Usage Data Supplier Reference” (Usage Data Supplier Reference) |
| 15 | Supplier Reference | Text[80] | Specifies the unique ID of the subscription at the supplier. via Page 8031 “Connect Subscription To SO” | not editable |
| 16 | Customer ID | Text[80] | Specifies the unique ID of the customer for this subscription at the supplier. via Page 8031 “Connect Subscription To SO” | |
| 17 | Customer Description | Text[100] | Specifies the name of the customer for this subscription with the supplier. via Page 8031 “Connect Subscription To SO” | |
| 18 | Product ID | Text[80] | Specifies the unique ID of the product for this subscription with the supplier. via Page 8031 “Connect Subscription To SO” | |
| 19 | Processing Status | Enum “Processing Status” | Specifies the processing status of this subscription. via Page 8031 “Connect Subscription To SO” | enum Enum 8012 “Processing Status”; not editable |
| 20 | Unit Type | Text[80] | Specifies the unit of the subscription. via Page 8031 “Connect Subscription To SO” | |
| 21 | Connect to Sub. Header No. | Code[20] | Specifies the Subscription to which the Supplier Subscription should be connected. via Page 8031 “Connect Subscription To SO” | TableRelation Table 8057 “Subscription Header” (“Subscription Header” where(“End-User Customer No.” = field(“Customer No.”), “Provision End Date” = filter(0D))) |
| 22 | Connect to Sub. Header Method | Enum “Connect To SO Method” | Specifies whether new Subscription Lines will be created or existing Subscription Lines will be updated for the Subscription. via Page 8031 “Connect Subscription To SO” | enum Enum 8009 “Connect To SO Method” |
| 23 | Connect to Sub. Header at Date | Date | Specifies the date on which the new Subscription Lines will be created. via Page 8031 “Connect Subscription To SO” | |
| 24 | Reason (Preview) | Text[80] | Specifies the preview why the last processing step failed. via Page 8031 “Connect Subscription To SO” | not editable |
| 25 | Reason | Blob | — |
Keys
- PK: Entry No. (clustered)
Procedures
SetErrorReason(ErrorText: Text)(internal)ShowReason()(internal)SetReason(ReasonText: Text)(internal)ResetProcessingStatus(var UsageDataSubscription: Record "Usage Data Supp. Subscription")(internal)ResetServiceObjectAndServiceCommitment()(internal)FindForSupplierReference(SupplierNo: Code[20]; SupplierReference: Text[80]): Boolean(internal)UpdateSubscriptionHeaderNoInImportedData()(internal)
Plus 4 local procedures.
Relations
- drill-down page Page 8042 “Usage Data Subscriptions”
- lookup page Page 8042 “Usage Data Subscriptions”
- Customer Name: CalcFormula Table 18 “Customer”
- Customer No.: TableRelation Table 18 “Customer”
- Supplier Description: CalcFormula Table 8014 “Usage Data Supplier”
- Supplier No.: TableRelation Table 8014 “Usage Data Supplier”
- Supplier Reference Entry No.: TableRelation Table 8015 “Usage Data Supplier Reference”
- Connect to Sub. Header No.: TableRelation Table 8057 “Subscription Header”
- Subscription Line Entry No.: TableRelation Table 8059 “Subscription Line”
Pages and codeunits on this table
- Page 8031 “Connect Subscription To SO” (source table)
- Page 8042 “Usage Data Subscriptions” (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: "Usage Data Supp. Subscription"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.