🚀 Business Central - 50 Tablas CORE

Maestras (15)
Documentos (20)
Entries (10)
Setup (5)
MAESTRAS CORE Customer (18) Vendor (23) Item (27) Location (14) G/L Account (15) Employee (5200) Contact (5050) Currency (4) Country/ Region (9) Item Category (5722) DOCUMENTOS CORE Sales Header (36) Sales Line (37) Purchase Header (38) Purchase Line (39) Item Journal Line (83) Gen. Journal Line (81) Job (167) Production Order (5405) ENTRIES Item Ledger Entry (32) Cust. Ledger Entry (21) Vendor Ledger Entry (25) G/L Entry (17) Value Entry (5802) Job Ledger Entry (169) SETUP General Ledger Setup (98) Sales & Receiv. Setup (311) Inventory Setup (313)

💰 SALES & CRM (12 tablas)

Customer (18)
PK: No.
Used in: Sales Header, Cust. Ledger Entry
Type: Master Table
Sales Header (36)
PK: Document Type + No.
FK: Sell-to Customer No. → Customer
Type: Document
Sales Line (37)
PK: Document Type + Document No. + Line No.
FK: No. → Item (when Type=Item)
Type: Document Line
Posted Sales Invoice Header (112)
PK: No.
FK: Sell-to Customer No. → Customer
Type: Posted Document
Posted Sales Invoice Line (113)
PK: Document No. + Line No.
FK: No. → Item
Type: Posted Document Line
Contact (5050)
PK: No.
Related: Customer, Vendor
Type: Master Table (CRM)
Customer Posting Group (92)
PK: Code
Used in: Customer
Type: Setup/Master
Cust. Ledger Entry (21)
PK: Entry No.
FK: Customer No. → Customer
Type: Ledger Entry
Detailed Cust. Ledg. Entry (379)
PK: Entry No.
FK: Cust. Ledger Entry No.
Type: Detailed Entry
Sales Shipment Header (110)
PK: No.
FK: Sell-to Customer No.
Type: Posted Document
Sales Shipment Line (111)
PK: Document No. + Line No.
FK: No. → Item
Type: Posted Document Line
Salesperson/Purchaser (13)
PK: Code
Used in: Customer, Sales Header
Type: Master Table

🛒 PURCHASE (10 tablas)

Vendor (23)
PK: No.
Used in: Purchase Header, Vendor Ledger Entry
Type: Master Table
Purchase Header (38)
PK: Document Type + No.
FK: Buy-from Vendor No. → Vendor
Type: Document
Purchase Line (39)
PK: Document Type + Document No. + Line No.
FK: No. → Item (when Type=Item)
Type: Document Line
Posted Purch. Invoice Header (122)
PK: No.
FK: Buy-from Vendor No. → Vendor
Type: Posted Document
Posted Purch. Invoice Line (123)
PK: Document No. + Line No.
FK: No. → Item
Type: Posted Document Line
Vendor Posting Group (93)
PK: Code
Used in: Vendor
Type: Setup/Master
Vendor Ledger Entry (25)
PK: Entry No.
FK: Vendor No. → Vendor
Type: Ledger Entry
Detailed Vendor Ledg. Entry (380)
PK: Entry No.
FK: Vendor Ledger Entry No.
Type: Detailed Entry
Purch. Receipt Header (120)
PK: No.
FK: Buy-from Vendor No.
Type: Posted Document
Purch. Receipt Line (121)
PK: Document No. + Line No.
FK: No. → Item
Type: Posted Document Line

📦 INVENTORY (12 tablas)

Item (27)
PK: No.
Used in: Sales/Purchase Lines, Item Ledger Entry
Type: Master Table
Location (14)
PK: Code
Used in: Items, Documents, Entries
Type: Master Table
Item Category (5722)
PK: Code
Used in: Item
Type: Master Table
Item Posting Group (94)
PK: Code
Used in: Item
Type: Setup/Master
Item Journal Line (83)
PK: Journal Template + Journal Batch + Line No.
FK: Item No. → Item
Type: Journal Document
Item Ledger Entry (32)
PK: Entry No.
FK: Item No. → Item, Location Code → Location
Type: Ledger Entry
Value Entry (5802)
PK: Entry No.
FK: Item Ledger Entry No.
Type: Detailed Entry
Item Application Entry (339)
PK: Entry No.
FK: Inbound/Outbound Item Entry No.
Type: Application Entry
Transfer Header (5740)
PK: No.
FK: Transfer-from/to Code → Location
Type: Document
Transfer Line (5741)
PK: Document No. + Line No.
FK: Item No. → Item
Type: Document Line
Warehouse Entry (7312)
PK: Entry No.
FK: Item No. → Item, Location Code → Location
Type: Warehouse Entry
Bin (7354)
PK: Location Code + Code
FK: Location Code → Location
Type: Master Table

💳 FINANCE (11 tablas)

G/L Account (15)
PK: No.
Used in: G/L Entry, Journal Lines
Type: Master Table (Chart of Accounts)
Gen. Journal Line (81)
PK: Journal Template + Journal Batch + Line No.
FK: Account No. → G/L Account
Type: Journal Document
G/L Entry (17)
PK: Entry No.
FK: G/L Account No. → G/L Account
Type: Ledger Entry
Dimension (348)
PK: Code
Used in: Dimension Value, Dimension Set Entry
Type: Master Table
Dimension Value (349)
PK: Dimension Code + Code
FK: Dimension Code → Dimension
Type: Master Table
Currency (4)
PK: Code
Used in: Customer, Vendor, Documents
Type: Master Table
Bank Account (270)
PK: No.
Related: Bank Account Ledger Entry
Type: Master Table
Bank Account Ledger Entry (271)
PK: Entry No.
FK: Bank Account No. → Bank Account
Type: Ledger Entry
VAT Entry (254)
PK: Entry No.
Related: G/L Entry, Documents
Type: Tax Entry
VAT Posting Setup (325)
PK: VAT Bus. Posting Group + VAT Prod. Posting Group
Used in: Documents, Items, Customers
Type: Setup Table
Payment Terms (3)
PK: Code
Used in: Customer, Vendor, Documents
Type: Master Table

⚙️ SETUP & ADMINISTRATION (5 tablas)

General Ledger Setup (98)
PK: Primary Key (singleton)
Type: Setup Table
Purpose: Global accounting setup
Sales & Receivables Setup (311)
PK: Primary Key (singleton)
Type: Setup Table
Purpose: Sales module configuration
Purchases & Payables Setup (312)
PK: Primary Key (singleton)
Type: Setup Table
Purpose: Purchase module configuration
Inventory Setup (313)
PK: Primary Key (singleton)
Type: Setup Table
Purpose: Inventory module configuration
User Setup (91)
PK: User ID
Type: Setup Table
Purpose: User permissions and limits