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

COMPANY..WS20002 Table Definition

(COMPANY..WS_MT_INV_WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Service_Call_ID char(17)


WS_Transaction_Date datetime


Equipment_ID char(31)


WS_Cost_Code int


WS_Other_Cost_Sub_Code int


ITEMNMBR char(31)

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

Item Descr...(more) Join Now BM10300.ITEMDESC
TRXQTY numeric(19,5)

TRX QTY: T...(more) Join Now IV10001.TRXQTY
Cost_Per_Unit numeric(19,5)


UOFM char(9)

U Of M: T...(more) Join Now IV10001.UOFM
See I... more text available
LOCNCODE char(11)

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


SERLNMBR char(21)

Field Type...(more) Join Now SVC30620.SERLNMBR
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