Ugh, the devs on this project are bad at databases. This is a table for warehouse inventory:
CREATE TABLE [dbo].[BDIVTRAN](
[VVTDLT] [char](1) NOT NULL DEFAULT (''),
[VVTCO#] [numeric](2, 0) NOT NULL DEFAULT ((0)),
[VVTWH#] [numeric](2, 0) NOT NULL DEFAULT ((0)),
[VVTYMD] [numeric](8, 0) NOT NULL DEFAULT ((0)),
[VVTRF1] [char](25) NOT NULL DEFAULT (''),
[VVTRF2] [char](25) NOT NULL DEFAULT (''),
[VVTTXN] [char](20) NOT NULL DEFAULT (''),
[VVTPC] [numeric](6, 0) NOT NULL DEFAULT ((0)),
[VVTQTY] [numeric](9, 0) NOT NULL DEFAULT ((0)),