GP Tables

BM00101 - Bill of Materials Header

Dynamics GP table BM00101 (Bill of Materials Header) contains 10 columns including ITEMNMBR, Bill_Status, Status_Ord....

SQL Query Builder

10 Columns

Column Description Type Length
ITEMNMBR Item Number String 32
Bill_Status Bill Status Integer 2
Status_Ord Status Ord Long Integer 4
BM_Stock_Method BM Stock Method Integer 2
Effective_Date Effective Date Date 4
Obsolete_Date Obsolete Date Date 4
UOFM U Of M String 10
NOTEINDX Note Index Currency 10
CREATDDT Created Date Date 4
MODIFDT Modified Date Date 4

Related Tables

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

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

NOTEINDX

AAG00201 AAG00300 AAG00400 AAG00401 AF40100 AF40103 AF40106 APR_BLM42100

Effective_Date

BM_Stock_Method

Bill_Status

Status_Ord

Obsolete_Date