Module List > Module WS tables WS30003
You are currently viewing the COMPANY database.
Change

COMPANY..WS30003 Table Definition

(COMPANY..WS_MT_POP_HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Service_Call_ID char(17)


Technician char(11)


PONUMBER char(17)

PO Number ...(more) Join Now POP10110.PONUMBER
ORD int

Ord Unique...(more) Join Now BM00111.ORD
WS_Transaction_Date datetime


VENDORID char(15)

Vendor ID:...(more) Join Now PM10000.VENDORID
join ... more text available
VENDNAME char(65)

Vendor Nam...(more) Join Now POP10300.VENDNAME
ITEMNMBR char(31)

span style...(more) Join Now IV00101.ITEMNMBR
join ... more text available
ITEMDESC char(101)

Item Descr...(more) Join Now BM10300.ITEMDESC
UOFM char(9)

U Of M: T...(more) Join Now IV10001.UOFM
See I... more text available
QTYORDER numeric(19,5)

QTY Ordered: The quantity ordered on the line item. POP10210.QTYORDER
UNITCOST numeric(19,5)

Unit Cost:...(more) Join Now IV10001.UNITCOST
LOCNCODE char(11)

Location C...(more) Join Now RM00102.LOCNCODE
join ... more text available
WS_Cost_Code int


Product_Indicator smallint

Product In...(more) Join Now POP10110.Product_Indicator
eConnect_Error_Code int


DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3