Sales Tables

Here’s a practical, real‑world list of the most commonly used Sales tables in Dynamics 365 Business Central, grouped by functional area. This is the set you’ll see constantly when working with sales order processing, posting, reporting, integrations, APIs, and extensions.

They are also great when you need to import data via Configuration Packages.

1️⃣ Sales Master Data (Customers & Setup)

Table No.	Table Name	Purpose
18	Customer	Core customer master record
92	Customer Posting Group	Assign GL Accounts for Posting
222	Ship-to Address	Manage Multiple Shipping Addresses
23	Vendor	Drop Shipments + Intercompany
79	Company Information	Company details used on sales documents
311	Sales & Receivables Setup	Global sales defaults & controls
77	Report Selections – Sales	Sales document report mappings
13	Salesperson/Purchaser	Sales reps tied to customers & orders
1381	Customer Template	Default values when creating customers

2️⃣ Sales Documents (Headers & Lines)

Table No.	Table Name	Purpose
36	Sales Header	Header for open quotes, orders, invoices, etc.
37	Sales Line	Line details (items, G/L, services)
44	Sales Comment Line	Comments on sales documents
110	Sales Shipment Header	Posted shipment header
111	Sales Shipment Line	Posted shipment lines
112	Sales Invoice Header	Posted invoice header
113	Sales Invoice Line	Posted invoice lines
114	Sales Cr. Memo Header	Posted credit memo header
115	Sales Cr. Memo Line	Posted credit memo lines

3️⃣ Pricing and Discounts

Table No.	Table Name	Purpose
7000	Price List	New Price List Experience
7001	Price List Line	New Price List Experience
7002	Sales Price	Legacy sales pricing
7004	Sales Line Discount	Legacy line discounts

4️⃣ Posted Sales & Customer Ledger Impact

Table No.	Table Name	Purpose
21	Cust. Ledger Entry	AR balance & history
379	Detailed Cust. Ledg. Entry	Applied amounts & payments
271	Bank Account Ledger Entry	Payment side of sales
32	Item Ledger Entry	Inventory movement from sales
5802	Value Entry	Cost impact of sales
5811	Post Value Entry to G/L	GL impact of sales
6508	Value Entry Relation	Links item entries to documents

5️⃣ Posted Transactions and Dimensions

Table No.	Table Name	Purpose
81	Gen. Journal Line	Open Journal Entries
17	G/L Entry	Posted Journal Entries
480	Dimension Set Entry	Dimensions used on sales docs

6️⃣ Shipping, Logistics & Fulfillment

Table No.	Table Name	Purpose
5744	Transfer Shipment Header	Intercompany & logistics movements
5745	Transfer Shipment Line	Transfer item lines
7320	Warehouse Shipment Header	Warehouse-managed shipments
7321	Warehouse Shipment Line	Warehouse ship lines

7️⃣ Before the Sale (Let's Talk CRM)

Table No.	Table Name	Purpose
5050	Contact	Contact Tracking
5092	Opportunity	Pipeline tracking
5093	Opportunity Entry	Opportunity stage history
5065	Interaction Log Entry	CRM activity history

🔄 Sales vs Purchasing Cheat Sheet

Sales	Purchasing
Customer Card (18)	Vendor Card (23)
Customer Posting Group (92)	Vendor Posting Group (93)
Salesperson/Purchaser (13)	Salesperson/Purchaser (13)
Sales & Receivables Setup (311)	Purchases & Payables Setup (312)
Sales Header (36) - Open Documents	Purchase Header (38) - Open Documents
Sales Line (37) - Open Documents	Purchase Line (39) - Open Documents
Customer Ledger (21) - Posted Entries	Vendor Ledger (25) - Posted Entries
Sales Invoice (112/113) - Posted Entries	Purchase Invoice (122/123)Posted Entries

For more information on Purchasing Tables - Click Here.

For more information on General Ledger Tables - Click Here.

---

Ready to optimize your Business Central environment with guidance from a BC expert?

Contact Ben Cole at Ben@BenColeBC.com or (214) 433-0923.

Don't forget to subscribe so that you never miss a weekly tip.

---

Ben Cole is passionate about making Microsoft Dynamics 365 Business Central work smarter for real people—users and partners alike. With roots in public accounting, Ben’s seen firsthand how automation and clever solutions can transform the Business Central experience. He’s known for breaking down complex topics with a dash of wit and plenty of practical advice. If you want to get more out of Business Central (and maybe even enjoy the process), Ben’s your go-to guide.

Ben@BenColeBC.com 

(214) 433-0923