GP Tables

ADSK0500 - BOMs exported from GP

Dynamics GP table ADSK0500 (BOMs exported from GP) contains 8 columns including ADITEMNMBR, ADREVNMBR, ADDSGNAUTH....

SQL Query Builder

8 Columns

Column Description Type Length
ADITEMNMBR AD Item Number String 52
ADREVNMBR AD Revision Number String 52
ADDSGNAUTH AD Design Authority String 102
ADOBSOLETE AD Obsolete Boolean 2
ADBUY AD Buy Boolean 2
ADUOM AD Unit of Measure String 10
ADTRNID AD Transaction ID Long Integer 4
ADITEMDESC AD Item Description Text 2

Related Tables

Tables that share columns with ADSK0500. Click "Join" to add to your query.

ADDSGNAUTH

ADITEMNMBR

ADOBSOLETE

ADTRNID