Small and medium business | Business Central, N...

Field Names For Tables

(1) Share

Report

Posted on by DS-15051354-0

152

I'm developing a new App. to add transactions (Sales and Journals) by API.

I need to know table field names for various tables.

Is there a way to lookup field names for tables just using BC UI.

How would I do this?

Thanks.

Keith

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,398 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

I hope this can help you and give you some hints

How to export all fields in all tables in Dynamics 365 Business Central | Dynamics 365 Lab (yzhums.com)

BR

GR

Was this reply helpful? Yes No
Valentin Castravet 31,586 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

You can use the Page Inspection Pane to view all fields for a specific page/table. To do this, go to your page and click ctrl+alt+f1 on the keyboard or select Settings ->Help & Support ->Inspect pages and data.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,057 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi, If it is standard APIs, it is recommended to view the code of standard APIs, because its caption is a bit special.

How to export all page field caption in Dynamics 365 Business Central (table 2000000202 “All Control Fields”) – Comparing Table Field Caption and Page Field Caption

https://yzhums.com/38428/

Thanks.

ZHU

Was this reply helpful? Yes No
DS-15051354-0 152 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your help in getting to Tables and then to fields, it was a big help.

So now I need to add a couple fields in Table=81 (journal) to my

Template of fields to create a journal line. via an API.

Question how to add a field from a table (81) to my batch Template?

When I had tried a few different names to see if in Template I get an error

property does not exist on type 'Microsoft.NAV.journalLine!.

So I guess I need to modify Microsoft.NAV.journalLine. How do I do that.

Documentation is a bit vague on this subject.

Thanks Keith

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,057 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, If you are using Web Services (Odata), just add the fields directly to the page.
If you are using the API, unfortunately, it is not possible to extend the standard API at this time.

More details: Dynamics 365 Business Central: Can we extend standard APIs? – Download Standard Source Code for APIs

https://yzhums.com/20960/

Thanks.

ZHU

Was this reply helpful? Yes No
DS-15051354-0 152 on at

Like (1)

Report
Copy link

Link copied!

I just want to verify what you are explaining.

Yes I am using the API.

Are you saying I can only add the following 12 fields using the following API and can't at this time add more fields?

POST https://{businesscentralPrefix}/api/v2.0/companies({id})/journals({id})/journalLines
Content-type: application/json

{
"id": "0a077d18-45e3-ea11-bb43-000d3a2feca1",
"journalId": "dd1b6a90-44e3-ea11-bb43-000d3a2feca1",
"lineNumber": 10000,
"accountType": "G/L Account",
"accountId": "00000000-0000-0000-0000-000000000000",
"accountNumber": "",
"postingDate": "2018-12-31",
"documentNumber": "",
"externalDocumentNumber": "",
"amount": 0,
"description": "",
"comment": ""
}

thanks

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,057 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Yes, if you want to add new fields, you must create a new API page.

This is clearly documented in the MS Docs.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No