{"id":11486,"date":"2023-06-27T13:02:21","date_gmt":"2023-06-27T13:02:21","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=11486"},"modified":"2023-06-27T13:02:24","modified_gmt":"2023-06-27T13:02:24","slug":"specifications-and-limitations-of-objects-in-d365-bc","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/specifications-and-limitations-of-objects-in-d365-bc\/","title":{"rendered":"Specifications and Limitations of Objects in D365 BC"},"content":{"rendered":"\n

Specifications and Limitations of Objects in D365 BC:<\/h2>\n\n\n\n

In this blog, we will know about the behavior of objects in D365 BC as per Microsoft. The following specifications of objects:<\/p>\n\n\n\n

(1) Tables:<\/strong><\/em><\/p>\n\n\n\n

Feature<\/th>Characteristic<\/th><\/tr><\/thead>
Range for table object ID numbers<\/td>1 \u2013 999,999,999 1<\/sup><\/td><\/tr>
Maximum number of characters in a table name<\/td>30<\/td><\/tr>
Maximum table size<\/td>Depends on available storage<\/td><\/tr>
Maximum number of records in a table<\/td>Depends on available storage<\/td><\/tr>
Maximum record size<\/td>8060 bytes2<\/sup><\/td><\/tr>
Maximum number of fields in a record<\/td>500<\/td><\/tr>
Range for field numbers<\/td>1 \u2013 999,999,999<\/td><\/tr>
Maximum number of keys for a table<\/td>40<\/td><\/tr>
Maximum size of a Business Central key<\/td>900 bytes<\/td><\/tr>
Maximum number of distinct fields per key<\/td>16<\/td><\/tr>
Maximum size of an (non-key) index<\/td>1700 bytes<\/td><\/tr>
Maximum number of SumIndexFields per key<\/td>20<\/td><\/tr>
Maximum number of characters in a text or code field<\/td>2048<\/td><\/tr>
Maximum size of a BLOB field<\/td>2 GB<\/td><\/tr>
Maximum number of characters in a field name<\/td>30<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

(2) Pages:<\/em><\/strong><\/p>\n\n\n\n

Feature<\/th>Characteristic<\/th><\/tr><\/thead>
Range for page or report object ID numbers<\/td>1 \u2013 999,999,999 1<\/sup><\/td><\/tr>
Maximum number of characters in a caption<\/td>1024<\/td><\/tr>
Maximum bitmap size in bitmap property<\/td>32500 bytes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

(3) Reports:<\/em><\/strong><\/p>\n\n\n\n

Feature<\/th>Characteristic<\/th><\/tr><\/thead>
Range for page or report object ID numbers<\/td>1 \u2013 999,999,999 1<\/sup><\/td><\/tr>
Maximum number of characters in a caption<\/td>1024<\/td><\/tr>
Maximum bitmap size in bitmap property<\/td>32500 bytes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

(4) Codeunits:<\/em><\/strong><\/p>\n\n\n\n

Feature<\/th>Characteristic<\/th><\/tr><\/thead>
Range for table object ID numbers<\/td>1 \u2013 999,999,999 1<\/sup><\/td><\/tr>
Maximum number of characters in variable names<\/td>30<\/td><\/tr>
Maximum number of dimensions in array variables<\/td>10<\/td><\/tr>
Maximum number of elements in an array variable<\/td>1,000,000<\/td><\/tr>
Maximum physical size of a codeunit<\/td>2 GB<\/td><\/tr>
Lower bound of index in an array<\/td>1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
How to Set Default Values in Change Status on Production Order in BC D365<\/a>
Modify Shortcut Dimension Value in Pre-Entries in D365 BC<\/a>
How To Modify Triggers of Existing Report in BC D365<\/a>
Page Extension Overview in Business Central D365<\/a>
How to Switch Company and Environment in D365 BC SAAS<\/a>
Creation of\u00a0Chart of Accounts in D365 BC<\/a>
Auto creation of Item while entering Item Description in Sales Line in D365 BC<\/a>
Performance Profiler Overview<\/a>\u2013 Microsoft Docs<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Specifications and Limitations of Objects in D365 BC: In this blog, we will know about the behavior of objects in D365 BC as per Microsoft. The following specifications of objects: (1) Tables: Feature Characteristic Range for table object ID numbers 1 \u2013 999,999,999 1 Maximum number of characters in a table name 30 Maximum table size Depends on available storage Maximum number of records in a table Depends on available storage Maximum record size 8060 bytes2 Maximum number of fields in a record 500 Range for field numbers 1 \u2013 999,999,999 Maximum number of keys for a table 40 Maximum size <\/p>\n","protected":false},"author":1,"featured_media":11495,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[1187,1188],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/06\/Specifications-and-Limitations-of-Objects-in-D365-BC.jpg?fit=650%2C350&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/11486"}],"collection":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/comments?post=11486"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/11486\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/11495"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=11486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=11486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=11486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}