AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Everything Else
Acumatica Schema Br...
 
Notifications
Clear all

Acumatica Schema Browser from Juriy  

    Last Post
RSS

Tim Rodman
Posts: 2468
 Tim Rodman     ★★ All-Star ★★
February 17, 2020 1:20 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

I just tried the Acumatica Schema Browser utility from Juriy and I like it a lot. It's nice and simple, but gets me the information that I need.

If you don't know Juriy, he runs an Acumatica Developer Blog over at https://blog.zaletskyy.com

 

To download and install Juriy's schema browser, do this:

1. Go here and download the .zip file to your computer:
https://github.com/YuriyZaletskyy/DacSchemaBrowser/raw/master/DACSchemaBrowserAllInPackage.zip

2. Go to the Customization Projects (SM204505) screen in your Acumatica environment, import the .zip file, and publish it.

 

It installs a custom screen called Acumatica tables (AT102000):

image

Use the Choose table field to select an Acumatica table.

The Is Key column tells you if the column is part of the primary key on the table. Sort Descending on this column to have the primary keys float to the top.

The Field Name field is the name of the field in the Acumatica database.

The Display Name field is how the field gets displayed inside Acumatica.

The Data Length and Data Type columns tell you how many characters can fit into the field and what kind of field it is.

 

If you highlight a row in the grid and click the GET TABLES button, it will show you other tables that have a column with the same name:

image
6 Replies
Juriy Zaletsky
Posts: 15
 Juriy Zaletsky
February 17, 2020 5:39 pm
(@docotor)
6-20 Posts
Joined: 10 months ago

Nice description!

Just want to add if anyone finds some bug, you can contact me here or over github or blog for reporting it.

Reply
ToonSix liked
ToonSix
 ToonSix
(@toonsix)
Joined: 9 months ago

21-50 Posts
Posts: 29
December 22, 2020 6:22 pm
Reply toJuriy ZaletskyJuriy Zaletsky

@docotor Jurij, this is amazing usef

ul. I have not seen this capability with any other cloud erp. I will use this as a differentiator. 

Thanks a lot. 

Happy holidays

ToonSix@intercs.com

 

 

Reply
Tim Rodman
Posts: 2468
 Tim Rodman     ★★ All-Star ★★
February 18, 2020 7:29 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

Thanks Juriy!

Reply
ToonSix
Posts: 29
 ToonSix
December 22, 2020 6:26 pm
(@toonsix)
21-50 Posts
Joined: 9 months ago

Tim, thanks for posting the above. You are an Acumatica champion. I will nominate you again for 2021 MVP. Your https://augforums/episode podcasts are amazing. 

Reply
ToonSix
 ToonSix
(@toonsix)
Joined: 9 months ago

21-50 Posts
Posts: 29
December 23, 2020 12:18 pm
Reply toToonSixToonSix

Sorry podcasts can be seen at: https://www.augforums.com/podcast/

Reply
Tim Rodman
 Tim Rodman
    ★★ All-Star ★★
(@timrodman)
Joined: 5 years ago

Over 200 Posts
Posts: 2468
January 3, 2021 12:11 am
Reply toToonSixToonSix
ToonSix

Thank you @toonsix

Reply
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,644 Topics
7,640 Posts
4 Online
1,099 Members

Latest Post: Adding bill description on check stub Our newest member: mlaraiv Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×