Knowledge Base / ERP

Microsoft Dynamics 365 Business Central

Vendor: Microsoft · SMB

Microsoft's ERP application for small and mid-sized companies (sales, purchasing, inventory, warehouse, finance), run by Microsoft online or by the customer on premises on SQL Server. Since version 15 the business logic is the AL Base Application, whose source Microsoft publishes, so table and field names can be proven line by line. For process mining the facts that matter most: open quotes and orders are DELETED when converted or fully invoiced, so their history survives only in the posted documents and in the document archive (Sales Header Archive), which is written only when the Archive Quotes / Archive Orders settings or a user archive; the archive's own date is the user's work date. Field-level history exists only if the Change Log was switched on. Every table carries SystemCreatedAt/By and SystemModifiedAt/By (version 17 and later), but they are lost with the deleted row: an archive or posted copy carries its own insert time and user, so for finished cases the creation time and creator of a quote or order survive only in the Change Log (insertions logged). This entry is proven against version 20 (build 20.18, Danish and base source); other versions are not checked.

Order-to-Cash (O2C)

Full sales cycle from quote through payment receipt

Activities

• Create Sales Quote - Sales Header row with Document Type = Quote. While the quote is open: time = the row's SystemCreatedAt (UTC), user = SystemCreatedBy. Once it is converted or deleted both are gone (the archive does not keep them): only the Order Date / Document Date (work date, no time) survive in the archive or on the order, and the creator only in a Change Log insertion entry.
• Archive Quote Version - Sales Header Archive + Sales Line Archive version (Version No. 1, 2, ...), written by the Archive Document action, on delete, Make Order or print when Archive Quotes = Always or Question. Time: the archive row's SystemCreatedAt; Date Archived is the work date.
• Send Quote to Customer - Sales Header.Quote Sent to Customer (DateTime) is set by the quote's Email action; the email itself is in Sent Email, related through Email Related Record.
• Accept Quote - Sales Header.Quote Accepted ticked; Quote Accepted Date = work date. Optional in standard use.
• Close Opportunity as Lost - The only standard lost outcome: Opportunity Status = Lost with an Opportunity Entry (Action Taken = Lost, Close Opportunity Code). Exists only where Relationship Management opportunities are used; a quote has no lost status.
• Delete Sales Quote - The quote's Sales Header is deleted (archived first if Archive Quotes says so). Visible as an event only through Change Log Entry (Type of Change = Deletion) or as an archive with no later order.
• Make Order from Quote - Sales-Quote to Order: new Sales Header (Document Type = Order) with Quote No. = the quote, lines copied with the same Line No., quote archived per Archive Quotes, quote deleted. Time: the order's SystemCreatedAt while the order is open; after full invoicing the order is deleted, and the surviving mark is the quote's last archive version (its SystemCreatedAt and Archived By, only if Archive Quotes archived it) or a Change Log insertion on Sales Header.
• Make Invoice from Quote - Sales-Quote to Invoice (the quote's Make Invoice action): new Sales Header (Document Type = Invoice) with Quote No. = the quote, lines copied, quote archived per Archive Quotes, quote deleted. No order exists; the posted invoice carries Quote No. with a blank Order No., Pre-Assigned No. = the unposted invoice.
• Release Sales Order - Sales Header.Status = Released and a Warehouse Request. No release date or user is stored: the event needs Change Log Entry on Status, else only the last SystemModifiedAt.
• Print Order Confirmation - Report 1305: No. Printed + 1, an archive version when Archive Orders is on, and an Interaction Log Entry (Document Type Sales Ord. Cnfrmn., real date and time, User ID) if an interaction template is set.
• Email Order Confirmation - Sent Email (Date Time Sent, User Security Id) related to the order through Email Related Record (Table Id 36, System Id).
• Create Warehouse Shipment - Warehouse Shipment Header/Line with Source Type 37 and Source No./Source Line No. = the order line. Locations with Require Shipment only. Time: SystemCreatedAt while open only; the header is deleted when fully posted and the posted copy keeps just Assignment Date/Time (when a user was assigned).
• Register Pick - Registered Whse. Activity Hdr./Line (Registering Date = work date); the registering user is on Warehouse Entry.User ID. When the pick was created is not kept: the open pick is deleted at registration and the registered copy's SystemCreatedAt is the registration moment.
• Archive Sales Order Version - With Archive Orders on, Sales-Post archives the order before every run that ships and on full invoicing (Sales Header Archive, Version No. counts shipping runs).
• Post Sales Shipment - Sales Shipment Header/Line with Order No. and Order Line No., User ID and Posting Date; Item Ledger Entry; Posted Whse. Shipment Line.Posted Source No. = the shipment.
• Post Sales Invoice - Sales Invoice Header/Line with Order No./Order Line No. (or, for an invoice document, Pre-Assigned No. and Quote No.) and User ID; Cust. Ledger Entry; Value Entry links the invoice to the shipment's item ledger entry. When the order is fully invoiced, it is deleted.

Case attributes

• Sell-to Customer No. (Text) - Sales Header.Sell-to Customer No.
• Currency Code (Text) - Sales Header.Currency Code (blank = local currency).
• Order Amount (Decimal) - Sum of Sales Line.Amount for the order (Sales Header.Amount is a FlowField, not a column).
• Doc. No. Occurrence (Integer) - Separates documents that reused a number; part of the archive key.
• Order No. (Text) - Sales Header.No. of the order; Order No. on Sales Shipment Header and Sales Invoice Header.
• Quote No. (Text) - Sales Header.No. of the quote; on the order Sales Header.Quote No., on posted documents Quote No., in the archive Sales Quote No.
• Location Code (Text) - Sales Header.Location Code; decides whether warehouse shipment and pick steps exist (Location.Require Shipment / Require Pick).
• Responsibility Center (Text) - Sales Header.Responsibility Center.
• Salesperson Code (Text) - Sales Header.Salesperson Code.
• Invoice Runs (Integer) - Number of Sales Invoice Header rows with this Order No.
• Quote Outcome (Text) - Derived: Converted to Order (an order, open or posted, has Quote No. and an Order No.), Converted to Invoice (an unposted invoice has Quote No., or a posted invoice has Quote No. with a blank Order No.), Lost (opportunity closed Lost), Deleted (archive or change log only), Open.
• Quote Versions (Integer) - Number of Sales Header Archive versions of the quote.
• Shipping Runs (Integer) - Number of Sales Shipment Header rows with this Order No.

Process-mining benefits (historical)

• Quote-to-order conversion by customer and salesperson [Efficiency]: Measure how many quotes become orders, how fast, and where the rest go, per customer and salesperson.
• How many times a quote is revised before it is won [Efficiency]: Count quote versions and the time between them to see which quotes need several rounds.
• Order-to-shipment lead time against the promised date [Service]: Compare the time from order to each shipment with the Promised Delivery Date to find late deliveries.
• Split shipments and invoices per order [Cost]: Find orders shipped or invoiced in several runs and what that costs in handling.
• Shipped but not yet invoiced [Cash]: Size and age of goods shipped but not invoiced, which delays cash.
• Who created, released and posted each order [Compliance]: Separation of duties: the same user creating, releasing and posting an order.

Process-mining benefits (action)

• Flag quotes about to expire without an order [Service]: Alert the salesperson before Quote Valid Until Date passes on a quote with no order.
• Chase released orders that have not shipped [Service]: Alert when a released order passes its shipment date with nothing posted.
• Invoice shipped goods promptly [Cash]: Prompt billing when goods have shipped and no invoice followed within a set number of days.
• Turn on the evidence before the next audit [Compliance]: Where Change Log Entry or Sales Header Archive history is missing, switch on Archive Quotes / Archive Orders and the Change Log for Sales Header insertions, deletions and Status so creators, releases and deletions become visible.
• Record why quotes are lost [Efficiency]: Close lost quotes through an opportunity with a lost reason instead of deleting them, so lost reasons can be analysed.
• Catch late picks before the truck leaves [Service]: Alert when a warehouse shipment is due and its pick is not registered.

Data tables

• Change Log Entry - Change Log Entry (table 405). Change Log entries, one per changed field, if the Change Log is on for the table. The only source for releases, revisions and deletions of quotes and orders. SQL name on premises (v15+): [<Company>$Change Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/ChangeLogEntry.Table.al#L2]
• Sales Header - Sales Header (table 36). Open sales documents: quotes (Document Type 0), orders (1) and unposted invoices (2) until converted, deleted or posted. A quote is deleted by Make Order and by Make Invoice; a fully invoiced order and a posted invoice are deleted by posting. The row's SystemCreatedAt/By (true creation time and creator) are lost with it: an archive or posted copy carries its own insert time and user, not these. SQL name on premises (v15+): [<Company>$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/SalesHeader.Table.al#L1]
• Sales Header Archive - Sales Header Archive (table 5107). Archived versions of quotes and orders: the only record of a converted or deleted quote. Written only when the Archive Quotes / Archive Orders settings (or a user) archive. SQL name on premises (v15+): [<Company>$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/SalesHeaderArchive.Table.al#L1]
• Sales Invoice Header - Sales Invoice Header (table 112). Posted sales invoice. SQL name on premises (v15+): [<Company>$Sales Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/SalesInvoiceHeader.Table.al#L1]
• Sales Invoice Line - Sales Invoice Line (table 113). Posted invoice lines. SQL name on premises (v15+): [<Company>$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/SalesInvoiceLine.Table.al#L1]
• Sales Line - Sales Line (table 37). Lines of open quotes and orders. Make Order copies quote lines to the order with the same Line No. SQL name on premises (v15+): [<Company>$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/SalesLine.Table.al#L1]
• Sales Line Archive - Sales Line Archive (table 5108). Lines of each archived version. SQL name on premises (v15+): [<Company>$Sales Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/SalesLineArchive.Table.al#L1]
• Sales Shipment Header - Sales Shipment Header (table 110). Posted sales shipment, one per posting run that ships. SQL name on premises (v15+): [<Company>$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/SalesShipmentHeader.Table.al#L1]
• Sales Shipment Line - Sales Shipment Line (table 111). Posted shipment lines. SQL name on premises (v15+): [<Company>$Sales Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/SalesShipmentLine.Table.al#L1]
• Cust. Ledger Entry - Cust. Ledger Entry (table 21). Customer ledger entry written by the invoice. SQL name on premises (v15+): [<Company>$Cust. Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/CustLedgerEntry.Table.al#L1]
• Interaction Log Entry - Interaction Log Entry (table 5065). Logged document prints and sends (only if an interaction template is set up for the document type). SQL name on premises (v15+): [<Company>$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/InteractionLogEntry.Table.al#L1]
• Item Ledger Entry - Item Ledger Entry (table 32). Item ledger entries; Entry Type 1 = Sale is the physical shipment. SQL name on premises (v15+): [<Company>$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/ItemLedgerEntry.Table.al#L1]
• Posted Whse. Shipment Header - Posted Whse. Shipment Header (table 7322). Posted warehouse shipment. Its SystemCreatedAt is the posting moment, not when the warehouse shipment was created. SQL name on premises (v15+): [<Company>$Posted Whse. Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/PostedWhseShipmentHeader.Table.al#L1]
• Posted Whse. Shipment Line - Posted Whse. Shipment Line (table 7323). Posted warehouse shipment lines; Posted Source No. is the Sales Shipment No. SQL name on premises (v15+): [<Company>$Posted Whse. Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/PostedWhseShipmentLine.Table.al#L1]
• Registered Whse. Activity Hdr. - Registered Whse. Activity Hdr. (table 5772). Registered pick header. No registering user field (the user is on Warehouse Entry) and no creation date: its SystemCreatedAt is the registration moment. SQL name on premises (v15+): [<Company>$Registered Whse. Activity Hdr.$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/RegisteredWhseActivityHdr.Table.al#L1]
• Registered Whse. Activity Line - Registered Whse. Activity Line (table 5773). Registered pick lines, pointing to the sales line and the warehouse shipment. SQL name on premises (v15+): [<Company>$Registered Whse. Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/RegisteredWhseActivityLine.Table.al#L1]
• Value Entry - Value Entry (table 5802). Value entries; links an invoice (Document No.) to the shipment's item ledger entry. SQL name on premises (v15+): [<Company>$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/ValueEntry.Table.al#L1]
• Warehouse Activity Header - Warehouse Activity Header (table 5766). Open pick (Type 2) or inventory pick (Type 5); deleted when all lines are registered. A warehouse pick header names no source document and can cover several orders: the lines carry the link. SQL name on premises (v15+): [<Company>$Warehouse Activity Header$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/WarehouseActivityHeader.Table.al#L1]
• Warehouse Activity Line - Warehouse Activity Line (table 5767). Lines of open picks and inventory picks; the only link from an open pick to the sales order line. Deleted as they are registered. SQL name on premises (v15+): [<Company>$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/WarehouseActivityLine.Table.al#L1]
• Warehouse Entry - Warehouse Entry (table 7312). Warehouse entries; the only place the registering user of a pick is stored. SQL name on premises (v15+): [<Company>$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/WarehouseEntry.Table.al#L1]
• Warehouse Request - Warehouse Request (table 5765). Created or updated when a sales order is released at a location with warehouse handling. SQL name on premises (v15+): [<Company>$Warehouse Request$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/WarehouseRequest.Table.al#L1]
• Warehouse Shipment Header - Warehouse Shipment Header (table 7320). Open warehouse shipment (locations with Require Shipment); deleted when fully posted. Its creation time does not survive: the posted header is a new row that copies only the assignment stamps. SQL name on premises (v15+): [<Company>$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/WarehouseShipmentHeader.Table.al#L1]
• Warehouse Shipment Line - Warehouse Shipment Line (table 7321). Open warehouse shipment lines, pointing to the sales line. SQL name on premises (v15+): [<Company>$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/WarehouseShipmentLine.Table.al#L1]
• Change Log Setup - Change Log Setup (table 402). Change Log Setup: logging is off unless Change Log Activated is on. SQL name on premises (v15+): [<Company>$Change Log Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/ChangeLogSetup.Table.al#L1]
• Change Log Setup (Field) - Change Log Setup (Field) (table 404). Change Log Setup (Field): for a table set to Some Fields, which fields are logged on insertion, modification and deletion. SQL name on premises (v15+): [<Company>$Change Log Setup (Field)$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/ChangeLogSetupField.Table.al#L1]
• Change Log Setup (Table) - Change Log Setup (Table) (table 403). Which tables the Change Log records, and for which operations. Some Fields means the fields listed in Change Log Setup (Field). SQL name on premises (v15+): [<Company>$Change Log Setup (Table)$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/ChangeLogSetupTable.Table.al#L1]
• Item - Item (table 27). Items. No field records which quote caused an item to be created. SQL name on premises (v15+): [<Company>$Item$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/Item.Table.al#L1]
• Location - Location (table 14). Locations; the Require flags decide whether warehouse shipments and picks exist. SQL name on premises (v15+): [<Company>$Location$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/Location.Table.al#L1]
• Retention Policy Setup - Retention Policy Setup (table 3901). System Application: retention policies; v20 registers Change Log Entry and Sales Header Archive for deletion by policy. SQL name on premises (v15+): [<Company>$Retention Policy Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/system%20application/source/System%20Application/Retention%20Policy/src/Retention%20Policy%20Setup/RetentionPolicySetup.Table.al#L9]
• Sales & Receivables Setup - Sales & Receivables Setup (table 311). Sales & Receivables Setup: the switches that decide whether quotes and orders are archived. Holds today's values only. SQL name on premises (v15+): [<Company>$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/SalesReceivablesSetup.Table.al#L1]
• User - User (table 2000000120). Platform table (not in the AL source). User ID, Archived By and Assigned User ID hold its User Name; SystemCreatedBy, SystemModifiedBy and Sent Email.User Security Id hold its User Security ID. The Learn page is the current-version reference, not version-pinned. SQL name on premises (v15+): [User] (not per company; the physical name is assumed - confirm in sys.tables). [Source: https://learn.microsoft.com/en-us/dynamics365/business-central/application/system/table/system.security.accesscontrol.user]
• Close Opportunity Code - Close Opportunity Code (table 5094). Reason codes for closing an opportunity as Won or Lost. SQL name on premises (v15+): [<Company>$Close Opportunity Code$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/CloseOpportunityCode.Table.al#L1]
• Document Attachment - Document Attachment (table 1173). Files attached by users to quotes, orders and invoices. Copied quote to order (Attached Date kept) and order to posted invoice (Attached Date reset to the posting moment); the source rows are deleted with the document. SQL name on premises (v15+): [<Company>$Document Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/DocumentAttachment.Table.al#L1]
• Email Outbox - Email Outbox (table 8888). System Application: queued and failed emails. SQL name on premises (v15+): [<Company>$Email Outbox$63ca2fa4-4f03-4f2b-a480-172fef340d3f]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/system%20application/source/System%20Application/Email/src/Email/Outbox/EmailOutbox.Table.al#L7]
• Email Related Record - Email Related Record (table 8909). System Application: links a sent email to the sales document it carried (Table Id + System Id). SQL name on premises (v15+): [<Company>$Email Related Record$63ca2fa4-4f03-4f2b-a480-172fef340d3f]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/system%20application/source/System%20Application/Email/src/Email/EmailRelatedRecord.Table.al#L9]
• Opportunity - Opportunity (table 5092). Relationship Management opportunity; the only standard place a sale is marked lost. SQL name on premises (v15+): [<Company>$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/Opportunity.Table.al#L1]
• Opportunity Entry - Opportunity Entry (table 5093). Opportunity history, including the Won or Lost close with its reason code. SQL name on premises (v15+): [<Company>$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/OpportunityEntry.Table.al#L1]
• Posted Invt. Pick Header - Posted Invt. Pick Header (table 7342). Posted inventory pick (locations that require pick but not shipment). SQL name on premises (v15+): [<Company>$Posted Invt. Pick Header$437dbf0e-84ff-417a-965d-ed2bb9650972]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/BaseApp/Source/Base%20Application/PostedInvtPickHeader.Table.al#L1]
• Sent Email - Sent Email (table 8889). System Application: emails that were sent. SQL name on premises (v15+): [<Company>$Sent Email$63ca2fa4-4f03-4f2b-a480-172fef340d3f]. [Source: https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/df2789414893f4fee69cbfec3a2e939e7f4ba943/system%20application/source/System%20Application/Email/src/Email/Sent/SentEmail.Table.al#L7]

Explore this interactively in the mindzie Knowledge Base.