DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module WS tables WS20003
You are currently viewing the COMPANY database.
Change

COMPANY..WS20003 Table Definition

(COMPANY..WS_MT_POP_WORK)

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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3