Table 8013 "Usage Data Import"
Subscription Billing · Microsoft.SubscriptionBilling
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 15 connected objects and pages
Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 8041 “Usage Data Imports” (3 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Usage Data Import |
| DataClassification | CustomerContent |
| LookupPageId | Usage Data Imports |
| DrillDownPageId | Usage Data Imports |
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 8041 “Usage Data Imports” | not editable; AutoIncrement |
| 2 | Supplier No. | Code[20] | Specifies the number of the supplier to which this usage data refers. via Page 8041 “Usage Data Imports” | TableRelation Table 8014 “Usage Data Supplier” (Usage Data Supplier) |
| 3 | Supplier Description | Text[80] | Specifies the description of the supplier to which this usage data refers. via Page 8041 “Usage Data Imports” | FlowField: lookup(“Usage Data Supplier”.Description where(“No.” = field(“Supplier No.”))); not editable |
| 4 | Description | Text[80] | Specifies the description of the import. via Page 8041 “Usage Data Imports” | |
| 5 | Processing Date | Date | Specifies the date of the last processing step. via Page 8041 “Usage Data Imports” | not editable |
| 6 | Processing Step | Enum “Processing Step” | Specifies the last processing step. via Page 8041 “Usage Data Imports” | enum Enum 8006 “Processing Step”; not editable |
| 7 | Processing Status | Enum “Processing Status” | Specifies the status of the last processing step. via Page 8041 “Usage Data Imports” | enum Enum 8012 “Processing Status”; not editable |
| 8 | Reason (Preview) | Text[80] | Specifies the preview why the last processing step failed. via Page 8041 “Usage Data Imports” | not editable |
| 9 | Reason | Blob | — | |
| 10 | No. of Usage Data Blobs | Integer | Specifies the number of files of the raw data. via Page 8041 “Usage Data Imports” | FlowField: count(“Usage Data Blob” where(“Usage Data Import Entry No.” = field(“Entry No.”))); not editable |
| 11 | No. of Imported Lines | Integer | — | obsolete Pending 29.0; #if not CLEANSCHEMA32; FlowField: count(“Usage Data Generic Import” where(“Usage Data Import Entry No.” = field(“Entry No.”))); not editable |
| 12 | No. of Imported Line Errors | Integer | — | obsolete Pending 29.0; #if not CLEANSCHEMA32; FlowField: count(“Usage Data Generic Import” where(“Usage Data Import Entry No.” = field(“Entry No.”), “Processing Status” = const(Error))); not editable |
| 13 | No. of Usage Data Billing | Integer | Specifies the number of errors during the creation and processing of Usage Data Billing. via Page 8041 “Usage Data Imports” | FlowField: count(“Usage Data Billing” where(“Usage Data Import Entry No.” = field(“Entry No.”))); not editable |
| 14 | No. of UD Billing Errors | Integer | Specifies the number of usage data billing errors. via Page 8041 “Usage Data Imports” | FlowField: count(“Usage Data Billing” where(“Usage Data Import Entry No.” = field(“Entry No.”), “Processing Status” = const(Error))); not editable |
Keys
- PK: Entry No. (clustered)
Events published
OnDeleteUsageDataBillingLines()(integration)OnBeforeProcessUsageDataImport(var UsageDataImport: Record "Usage Data Import"; ProcessingStep: Enum "Processing Step")(integration)OnAfterProcessUsageDataImport(var UsageDataImport: Record "Usage Data Import"; ProcessingStep: Enum "Processing Step")(integration)
Procedures
SetStatus(ProcessingStatus: Enum Microsoft.SubscriptionBilling."Processing Status")(internal)SetReason(ReasonText: Text)(internal)DeleteUsageDataBillingLines()(internal)SetErrorReason(ErrorText: Text)(internal)UpdateProcessingStatus()(internal)ShowReason()(internal)NewDataImport()(internal)ImportFile()(internal)ProcessUsageDataImport(var UsageDataImport: Record "Usage Data Import"; ProcessingStep: Enum "Processing Step")(internal)CloseUsageDataImports(var UsageDataImport: Record "Usage Data Import")(internal)ReopenUsageDataImports(var UsageDataImport: Record "Usage Data Import")(internal)CollectCustomerContractsAndCreateInvoices(var UsageDataImport: Record "Usage Data Import")(internal)CollectVendorContractsAndCreateInvoices(var UsageDataImport: Record "Usage Data Import")(internal)ShowRelatedDocuments(var UsageDataImport: Record "Usage Data Import"; ServicePartner: Enum "Service Partner"; DocumentType: Option Contract,"Contract Invoices","Posted Contract Invoices")(internal)
Plus 6 local procedures.
Triggers
OnDelete
Relations
- drill-down page Page 8041 “Usage Data Imports”
- lookup page Page 8041 “Usage Data Imports”
- No. of UD Billing Errors: CalcFormula Table 8006 “Usage Data Billing”
- No. of Usage Data Billing: CalcFormula Table 8006 “Usage Data Billing”
- No. of Usage Data Blobs: CalcFormula Table 8011 “Usage Data Blob”
- Supplier Description: CalcFormula Table 8014 “Usage Data Supplier”
- Supplier No.: TableRelation Table 8014 “Usage Data Supplier”
- No. of Imported Line Errors: CalcFormula Table 8018 “Usage Data Generic Import”
- No. of Imported Lines: CalcFormula Table 8018 “Usage Data Generic Import”
Referenced by
2 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 8011 “Usage Data Blob”: Usage Data Import Entry No.
- Table 8018 “Usage Data Generic Import”: Usage Data Import Entry No.
Pages and codeunits on this table
- Page 8040 “Usage Data Import API” (source table)
- Page 8041 “Usage Data Imports” (source table)
- Codeunit 8023 “Create Usage Data Billing” (codeunit runs on it)
- Codeunit 8025 “Import And Process Usage Data” (codeunit runs on it)
- Codeunit 8026 “Process Usage Data Billing” (codeunit runs on it)
- Codeunit 8027 “Process Usage Data Import” (codeunit runs on it)
Recent changes
- 2026-09-25 #9293 [Bug][SubscriptionBilling] Process Usage Data Billing uses lines marked Processing Status = Error (currency mismatch) (main, BC30, fix)
Deprecations
- field No. of Imported Line Errors: Pending 29.0 (#if not CLEANSCHEMA32), “Replaced by GetImportedLineCount in the Usage Data Processing interface.”
- field No. of Imported Lines: Pending 29.0 (#if not CLEANSCHEMA32), “Replaced by GetImportedLineCount in the Usage Data Processing interface.”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
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 Import"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.