Adjustment types

For users or potential users.
Post Reply
Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Adjustment types

Post by Tom Zaccaria » Thu Feb 06, 2020 7:59 am

Is there a way to see the AdjTypes in the Adjustment table without having to switch between raw and human readable windows?
Basically, I want to know what each generated AdjNum refers to in plain English as in #10 = 10% cash discount when I query this table.

Thanks,
drtmz

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Adjustment types

Post by cmcgehee » Thu Feb 06, 2020 8:06 am

Yes, you can join on the definition table. Here's a little example:

Code: Select all

SELECT d.ItemName AS AdjTypeName,a.*
FROM adjustment a
LEFT JOIN definition d ON d.DefNum=a.AdjNum
Chris McGehee
Open Dental Software
http://www.opendental.com

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: Adjustment types

Post by Tom Zaccaria » Thu Feb 06, 2020 11:49 am

Thank you

drtmz

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: Adjustment types

Post by Tom Zaccaria » Mon Feb 10, 2020 7:00 am

Actually the following query works better.

SELECT * FROM definition

Switch to Raw View and look at DefNum and ItemName columns.

drtmz

Post Reply