Business Central tables

2,473 tables, versions 17 to 29

200 of 2,473 tables, this page

table 9012 "AAD Application"Base Application17-29
table 9016 "Permission Set In Plan Buffer"System Applicationnew in 20
table 9017 "Plan Configuration"System Applicationnew in 20
table 9018 "Custom Permission Set In Plan"System Applicationnew in 20
table 9019 "Default Permission Set In Plan"System Applicationnew in 22
table 9020 "Security Group"System Applicationnew in 22
table 9021 "Security Group Member Buffer"System Applicationnew in 22
table 9022 "Security Group Buffer"System Applicationnew in 22
table 9040 "Date Compr. Settings Buffer"Base Applicationnew in 18
table 9041 "Date Compr. Retain Fields"Base Applicationnew in 20
table 9042 "Team Member Cue"Base Application17-29
table 9043 "ABS Container Content"System Applicationnew in 19
table 9044 "ABS Container"System Applicationnew in 19
table 9045 "Acc. Payable Performance Chart"Base Applicationnew in 27
table 9046 "Account Payable Cue"Base Applicationnew in 27
table 9050 "Warehouse Basic Cue"Base Application17-29
table 9051 "Warehouse WMS Cue"Base Application17-29
table 9052 "Service Cue"Base Application17-29
table 9053 "Sales Cue"Base Application17-29
table 9054 "Finance Cue"Base Application17-29
table 9055 "Purchase Cue"Base Application17-29
table 9056 "Manufacturing Cue"Base Application17-29
table 9057 "Job Cue"Base Application17-29
table 9058 "Warehouse Worker WMS Cue"Base Application17-29
table 9059 "Administration Cue"Base Application17-29
table 9060 "SB Owner Cue"Base Application17-29
table 9061 "RapidStart Services Cue"Base Application17-29
table 9062 "User Security Status"Base Application17-29
table 9063 "Relationship Mgmt. Cue"Base Application17-29
table 9064 "SAS Parameters"System Applicationnew in 19
table 9065 "Job Queue Role Center Cue"Base Applicationnew in 25
table 9066 "Job Queue Notification Setup"Base Applicationnew in 25
table 9067 "Job Queue Notified Admin"Base Applicationnew in 25
table 9069 "O365 Sales Cue"Base Applicationgone after 25
Removed, tag 24.0
table 9070 "Accounting Services Cue"Base Application17-29
table 9080 "Error Handling Parameters"Base Application17-29
table 9088 "Top Vendors By Purchase"Base Applicationnew in 27
table 9089 "Purch. by Vend.Grp.Chart Setup"Base Applicationnew in 27
table 9090 "Autocomplete Address"Base Application17-29
table 9091 "Postcode Service Config"Base Application17-29
table 9100 "SharePoint File"System Applicationnew in 21
table 9103 "SharePoint List Item"System Applicationnew in 21
table 9104 "SharePoint List Item Atch"System Applicationnew in 21
table 9105 "SharePoint List"System Applicationnew in 21
table 9106 "SharePoint Folder"System Applicationnew in 21
table 9130 "SharePoint Graph List"System Applicationnew in 28
table 9131 "SharePoint Graph List Item"System Applicationnew in 28
table 9132 "SharePoint Graph Drive Item"System Applicationnew in 28
table 9133 "SharePoint Graph Drive"System Applicationnew in 28
table 9144 "Approvals Activities Cue"Base Application17-29
table 9150 "My Customer"Base Application17-29
table 9151 "My Vendor"Base Application17-29
table 9152 "My Item"Base Application17-29
table 9153 "My Account"Base Application17-29
table 9154 "My Job"Base Application17-29
table 9155 "My Time Sheets"Base Application17-29
table 9160 TempStackBase Application17-29
table 9165 "Support Contact Information"Base Application17-29
table 9170 "Profile Resource Import/Export"Base Applicationgone after 25
Removed, tag 18.0
table 9171 "Profile Import"Base Application17-29
table 9172 "User Settings"System Applicationnew in 19
table 9173 "Extra Settings"System Application19 to 25
Removed, tag 23.0
table 9175 "Designer Diagnostic"Base Application17-29
table 9176 "Experience Tier Setup"Base Application17-29
table 9177 "Experience Tier Buffer"Base Application17-29
table 9178 "Application Area Setup"Base Application17-29
table 9179 "Application Area Buffer"Base Application17-29
table 9180 "Generic Chart Setup"Base Application17-29
table 9181 "Generic Chart Filter"Base Application17-29
table 9182 "Generic Chart Y-Axis"Base Application17-29
table 9183 "Generic Chart Query Column"Base Application17-29
table 9185 "Generic Chart Captions Buffer"Base Application17-29
table 9186 "Generic Chart Memo Buffer"Base Application17-29
table 9190 "Terms And Conditions"Base Application17-29
table 9191 "Terms And Conditions State"Base Application17-29
table 9197 "Profile Designer Diagnostic"Base Application17-29
table 9203 "Barcode Encode Settings"System Applicationnew in 18
table 9204 "Barcode Encode Settings 2D"System Applicationnew in 19
table 9222 "Application User Settings"System Applicationnew in 20
table 9260 "Customer Experience Survey"System Applicationnew in 22
Pending, tag 27.0
table 9400 "Media Repository"Base Application17-29
table 9450 "File Account"System Applicationnew in 26
table 9451 "Ext. File Storage Connector"System Applicationnew in 26
table 9452 "File Storage Connector Logo"System Applicationnew in 26
table 9453 "File Account Scenario"System Applicationnew in 26
table 9454 "File Scenario"System Applicationnew in 26
table 9455 "File Account Content"System Applicationnew in 26
table 9500 "Email Item"Base Application17-29
table 9501 "Sequence No. Preview State"Base Application17-25, 27-29
table 9510 "Email Parameter"Base Application17-29
table 9551 "Document Service Cache"Base Applicationnew in 18
Removed, tag 26.0
table 9555 "Record Selection Buffer"System Applicationnew in 22
table 9560 "Document Sharing"System Applicationnew in 19
table 9600 "XML Schema"Base Application17-29
table 9610 "XML Schema Element"Base Application17-29
table 9611 "XML Schema Restriction"Base Application17-29
table 9612 "Referenced XML Schema"Base Application17-29
table 9640 "Table Relations Buffer"Base Application26 to 27
table 9650 "Custom Report Layout"Base Application17-29
table 9651 "Report Layout Selection"Base Application17-29
table 9656 "Report Layout Update Log"Base Application17-29
table 9657 "Custom Report Selection"Base Application17-29
table 9701 "Cue Setup"System Application17-29
table 9760 "SFTP Folder Content"System Applicationnew in 28
table 9800 "Table Permission Buffer"Base Applicationgone after 25
Removed, tag 24.0
table 9802 "Permission Set Link"Base Application17-29
table 9804 "Recorded Event Buffer"Base Application17-29
table 9805 "Table Filter"Base Application17-29
table 9852 "Permission Buffer"Base Application17-29
table 9861 "Permission Set Relation Buffer"System Applicationnew in 21
table 9862 "PermissionSet Buffer"System Applicationnew in 21
table 9865 "Permission Lookup Buffer"System Applicationnew in 21
table 9883 "Perm. Set Assignment Buffer"Base Applicationnew in 28
table 9888 "SmartList Export Results"Base Applicationgone after 25
Removed, tag 22.0
table 9889 "SmartList Import Results"Base Applicationgone after 25
Removed, tag 22.0
table 9900 "Web Service Aggregate"System Application17-29
table 9981 "Word Template Custom Field"System Applicationnew in 22
table 9987 "Word Templates Table"System Applicationnew in 18
table 9988 "Word Template"System Applicationnew in 18
table 9989 "Word Template Field"System Applicationnew in 22
table 9990 "Word Templates Related Table"System Applicationnew in 18
table 9991 "Word Templates Related Buffer"System Applicationnew in 22
table 9994 "API Data Upgrade"Base Applicationnew in 20
table 9996 "Upgrade Tag Backup"System Applicationnew in 19
table 9999 "Upgrade Tags"System Application17-29
table 10000 "PAC Web Service"Base Application17-29
US only
table 10001 "PAC Web Service Detail"Base Application17-29
US only
table 10002 "Document Header"Base Application17-29
US only
table 10003 "Document Line"Base Application17-29
US only
table 10004 "MX Electronic Invoicing Setup"Base Application17-29
US only
table 10010 "IRS 1099 Form-Box"Base Application17-29
US onlyRemoved, tag 28.0
table 10011 "Sales Tax Amount Line"Base Application17-29
US only
table 10012 "Sales Tax Amount Difference"Base Application17-29
US only
table 10013 "Vendor Location"Base Application17-29
US only
table 10015 "GIFI Code"Base Application17-29
US only
table 10016 "IRS 1099 Adjustment"Base Application17-29
US onlyRemoved, tag 28.0
table 10040 "Data Dictionary Info"Base Application17-29
US only
table 10100 "Account Identifier"Base Application17-29
US only
table 10120 "Bank Rec. Header"Base Applicationgone after 25
US onlyRemoved, tag 23.0
table 10121 "Bank Rec. Line"Base Applicationgone after 25
US onlyRemoved, tag 23.0
table 10122 "Bank Comment Line"Base Application17-29
US only
table 10123 "Posted Bank Rec. Header"Base Application17-29
US only
table 10124 "Posted Bank Rec. Line"Base Application17-29
US only
table 10126 "Bank Rec. Sub-line"Base Applicationgone after 25
US onlyRemoved, tag 23.0
table 10139 "Item Location Variant Buffer"Base Application17-29
US only
table 10140 "Deposit Header"Base Applicationgone after 25
US onlyRemoved, tag 23.0
table 10143 "Posted Deposit Header"Base Application17-29
US only
table 10144 "Posted Deposit Line"Base Application17-29
US only
table 10240 "B10 Adjustment"Base Application17-29
US only
table 10300 "ACH US Header"Base Application17-29
US only
table 10301 "ACH US Detail"Base Application17-29
US only
table 10302 "ACH US Footer"Base Application17-29
US only
table 10303 "ACH RB Header"Base Application17-29
US only
table 10304 "ACH RB Detail"Base Application17-29
US only
table 10305 "ACH RB Footer"Base Application17-29
US only
table 10306 "ACH Cecoban Header"Base Application17-29
US only
table 10307 "ACH Cecoban Detail"Base Application17-29
US only
table 10308 "ACH Cecoban Footer"Base Application17-29
US only
table 10807 "Sales Tax Setup Wizard"Base Application17-29
US only
table 10810 "EFT Export"Base Application17-29
US only
table 10811 "EFT Export Workset"Base Application17-29
US only
table 11000 "Place of Dispatcher"Base Application17-29
DE only
table 11001 "Place of Receiver"Base Application17-29
DE only
table 11002 "Data Export"Base Application17-29
DE only
table 11003 "Data Export Record Definition"Base Application17-29
DE only
table 11004 "Data Export Record Source"Base Application17-29
DE only
table 11005 "Data Export Record Field"Base Application17-29
DE only
table 11006 "Data Export Table Relation"Base Application17-29
DE only
table 11007 "Data Export Record Type"Base Application17-29
DE only
table 11008 "Data Export Buffer"Base Application17-29
DE only
table 11009 "Data Export Setup"Base Applicationnew in 20
DE only
table 11010 "Data Exp. Primary Key Buffer"Base Application17-29
DE only
table 11011 "Sales VAT Advance Notification"Base Applicationgone after 25
DE onlyRemoved, tag 24.0
table 11012 "Transmission Log Entry"Base Applicationgone after 25
DE onlyRemoved, tag 24.0
table 11013 "Electronic VAT Decl. Setup"Base Applicationgone after 25
DE onlyRemoved, tag 24.0
table 11014 CertificateBase Application17-29
DE onlyRemoved, tag 25.0
table 11015 "Key Buffer"Base Application17-29
DE only
table 11016 "Number Series Buffer"Base Application17-29
DE only
table 11028 "Electronic VAT Decl. Buffer"Base Application19 to 25
DE onlyRemoved, tag 24.0
table 12145 "No. Series Line Sales"Business Foundationnew in 24
Removed, tag 27.0
table 12146 "No. Series Line Purchase"Business Foundationnew in 24
Removed, tag 27.0
table 20400 "Qlty. Management Setup"Quality Managementnew in 28
table 20401 "Qlty. Test"Quality Managementnew in 28
table 20402 "Qlty. Inspection Template Hdr."Quality Managementnew in 28
table 20403 "Qlty. Inspection Template Line"Quality Managementnew in 28
table 20404 "Qlty. Inspection Gen. Rule"Quality Managementnew in 28
table 20405 "Qlty. Inspection Header"Quality Managementnew in 28
table 20406 "Qlty. Inspection Line"Quality Managementnew in 28
table 20407 "Qlty. Inspect. Source Config."Quality Managementnew in 28
table 20408 "Qlty. Test Lookup Value"Quality Managementnew in 28
table 20409 "Qlty. Inspect. Src. Fld. Conf."Quality Managementnew in 28
table 20411 "Qlty. Inspection Result"Quality Managementnew in 28
table 20412 "Qlty. I. Result Condit. Conf."Quality Managementnew in 28
table 20414 "Qlty. Mgmt. Role Center Cue"Quality Managementnew in 28
table 20423 "Qlty. Related Transfers Buffer"Quality Managementnew in 28
table 20424 "Qlty. Disposition Buffer"Quality Managementnew in 28
table 20435 "Qlty. Workflow Config. Value"Quality Managementnew in 28
table 20500 "Subcontractor Price"Subcontractingnew in 28
table 20560 "Subcontractor WIP Ledger Entry"Subcontractingnew in 28
table 20572 "Subc. Standard Task Comment"Subcontractingnew in 29