Table 8018 "Usage Data Generic Import"
Subscription Billing · Microsoft.SubscriptionBilling
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 9 connected objects and pages
Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 8038 “Usage Data Generic Import” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Usage Data Generic Import |
| DataClassification | CustomerContent |
| LookupPageId | Usage Data Generic Import |
| DrillDownPageId | Usage Data Generic Import |
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 | Usage Data Import Entry No. | Integer | — | TableRelation Table 8013 “Usage Data Import” (Usage Data Import) |
| 3 | Processing Status | Enum “Processing Status” | Specifies whether the row has been processed. In case of an error during processing, it is displayed in the “Reason” field. via Page 8038 “Usage Data Generic Import” | enum Enum 8012 “Processing Status”; not editable |
| 4 | Reason Preview | Text[80] | Specifies the preview why the last processing step failed. via Page 8038 “Usage Data Generic Import” | not editable |
| 5 | Reason | Blob | — | |
| 6 | Subscription Header No. | Code[20] | Specifies to which Subscription the usage data refers. via Page 8038 “Usage Data Generic Import” | TableRelation Table 8057 “Subscription Header” (Subscription Header); not editable |
| 7 | Customer ID | Text[80] | Specifies the number of the customer at the supplier to which the usage data refers. via Page 8038 “Usage Data Generic Import” | TableRelation Table 8015 “Usage Data Supplier Reference” (“Usage Data Supplier Reference”.“Supplier Reference”) |
| 8 | Customer Name | Text[250] | Specifies the name of the customer at the supplier to which the usage data refers. via Page 8038 “Usage Data Generic Import” | |
| 9 | Invoice ID | Text[36] | Specifies the number of the invoice to which the usage data refers. via Page 8038 “Usage Data Generic Import” | |
| 10 | Supp. Subscription ID | Text[80] | Specifies the ID of the subscription at the supplier to which the usage data refers. The ID of the subscription is stored in the “Usage data item references”. via Page 8038 “Usage Data Generic Import” | |
| 11 | Supp. Subscription Name | Text[250] | Specifies the name of the subscription at the supplier to which the usage data refers. via Page 8038 “Usage Data Generic Import” | |
| 12 | Supp. Subscription Description | Text[250] | Specifies an additional description of the supplier’s subscription. via Page 8038 “Usage Data Generic Import” | |
| 13 | Supp. Subscription Start Date | Date | Specifies the start date of the subscription at the supplier. via Page 8038 “Usage Data Generic Import” | |
| 14 | Supp. Subscription End Date | Date | Specifies the end date of the subscription at the supplier. via Page 8038 “Usage Data Generic Import” | |
| 15 | Billing Period Start Date | Date | Specifies the start date of the billing period. via Page 8038 “Usage Data Generic Import” | |
| 16 | Billing Period End Date | Date | Specifies the end date of the billing period. via Page 8038 “Usage Data Generic Import” | |
| 17 | Product ID | Text[80] | Specifies the vendor’s product ID associated with the subscription. The product ID is stored in the “Usage data item references”. via Page 8038 “Usage Data Generic Import” | |
| 18 | Product Name | Text[100] | Specifies the supplier’s product name associated with the subscription. via Page 8038 “Usage Data Generic Import” | |
| 19 | Cost | Decimal | Specifies the cost price for the usage data row. via Page 8038 “Usage Data Generic Import” | |
| 20 | Price | Decimal | Specifies the sales price for the usage data line. via Page 8038 “Usage Data Generic Import” | |
| 21 | Quantity | Decimal | Specifies the quantity for the usage data row. via Page 8038 “Usage Data Generic Import” | |
| 22 | Discount | Decimal | Specifies the discount of the usage data row. via Page 8038 “Usage Data Generic Import” | |
| 23 | Tax | Decimal | Specifies the tax of the usage data row. via Page 8038 “Usage Data Generic Import” | |
| 24 | Amount | Decimal | Specifies the total amount of the usage data row. via Page 8038 “Usage Data Generic Import” | |
| 25 | Currency | Text[10] | Specifies the currency of the usage data row. via Page 8038 “Usage Data Generic Import” | |
| 26 | Unit | Text[30] | Specifies the unit of the usage data row. via Page 8038 “Usage Data Generic Import” | |
| 27 | Cost Amount | Decimal | Specifies the cost amount for the usage data row. via Page 8038 “Usage Data Generic Import” | |
| 30 | Service Object Availability | Enum “Service Object Availability” | Specifies whether a Subscription is available to be connected with the Supplier Subscription or if the connection has been established already. via Page 8038 “Usage Data Generic Import” | enum Enum 8018 “Service Object Availability”; not editable |
| 50 | Text1 | Text[80] | Specifies a text value that can be used for any purpose. via Page 8038 “Usage Data Generic Import” | |
| 51 | Text2 | Text[80] | Specifies a text value that can be used for any purpose. via Page 8038 “Usage Data Generic Import” | |
| 52 | Text3 | Text[80] | Specifies a text value that can be used for any purpose. via Page 8038 “Usage Data Generic Import” | |
| 53 | Decimal1 | Decimal | Specifies a text value that can be used for any purpose. via Page 8038 “Usage Data Generic Import” | |
| 54 | Decimal2 | Decimal | Specifies a text value that can be used for any purpose. via Page 8038 “Usage Data Generic Import” | |
| 55 | Decimal3 | Decimal | Specifies a text value that can be used for any purpose. via Page 8038 “Usage Data Generic Import” | |
| 1220 | Data Exch. Entry No. | Integer | — | TableRelation Table 1220 “Data Exch.” (Data Exch.); not editable |
Keys
- PK: Entry No. (clustered)
- Key2: Usage Data Import Entry No., Processing Status
Procedures
InitFromUsageDataImport(UsageDataImport: Record "Usage Data Import")(internal)SetReason(ReasonText: Text)(internal)ShowReason()(internal)GetCurrencyCode(): Code[10](internal)GetNextEntryNo(): Integer(internal)
Plus 1 local procedures.
Triggers
OnInsert, OnModify
Relations
- drill-down page Page 8038 “Usage Data Generic Import”
- lookup page Page 8038 “Usage Data Generic Import”
- Data Exch. Entry No.: TableRelation Table 1220 “Data Exch.”
- Usage Data Import Entry No.: TableRelation Table 8013 “Usage Data Import”
- Customer ID: TableRelation Table 8015 “Usage Data Supplier Reference”
- Subscription Header No.: TableRelation Table 8057 “Subscription Header”
Referenced by
2 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 8013 “Usage Data Import”: No. of Imported Line Errors, No. of Imported Lines
Pages and codeunits on this table
- Page 8038 “Usage Data Generic Import” (source table)
- Page 8039 “Usage Data Generic Import API” (source table)
Recent changes
- 2026-07-30 #8553 [Bug][SubscriptionBilling]: Performance: Billing document creation does not scale to large datasets (4M+ subscription lines) (main, BC30, performance)
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 Generic Import"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.