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 WSS30300
You are currently viewing the COMPANY database.
Change

COMPANY..WSS30300 Table Definition

(COMPANY..WS_SOP_LINE_HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
SOPTYPE smallint

 Field Type...(more) Join Now SVC00605.SOPTYPE
SOPNUMBE char(21)

 Field Type...(more) Join Now SVC00605.SOPNUMBE
LNITMSEQ int

 Field Type...(more) Join Now SVC00604.LNITMSEQ
CMPNTSEQ int

 Component ...(more) Join Now SVC30231.CMPNTSEQ
Product_Indicator smallint

 Product In...(more) Join Now POP10110.Product_Indicator
DOCDATE datetime

 Document D...(more) Join Now PM10000.DOCDATE
WS_Job_Number char(17)
WS_Cost_Code int
WS_Other_Cost_Sub_Code int
Cost_Code_Number_1 char(7)
Cost_Code_Number_2 char(7)
Cost_Code_Number_3 char(7)
Cost_Code_Number_4 char(7)
Cost_Element smallint
Cost_Code_Description char(31)
ITEMDESC char(101)

 Item Descr...(more) Join Now BM10300.ITEMDESC
LOCNCODE char(11)

 Location C...(more) Join Now RM00102.LOCNCODE
join ... more text available
ITEMNMBR char(31)

 span style...(more) Join Now IV00101.ITEMNMBR
join ... more text available
UOFM char(9)

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

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

 Unit Cost:...(more) Join Now IV10001.UNITCOST
EXTDCOST numeric(19,5)

 Extended C...(more) Join Now IV10001.EXTDCOST
XTNDPRCE numeric(19,5)

 Field Type...(more) Join Now SVC00203.XTNDPRCE
NONINVEN smallint

 Non IV Use...(more) Join Now POP10110.NONINVEN
Equipment_ID char(31)
Equipment_Type char(31)
TAXAMNT numeric(19,5)

 Tax Amount...(more) Join Now RM20101.TAXAMNT
VOIDED tinyint

 Voided Tru...(more) Join Now CM20200.VOIDED
Divisions char(15)
Contract_Valid smallint
COMPTRNM int
TRXDSCRN char(31)

 Transactio...(more) Join Now PM10000.TRXDSCRN
MRKDNAMT numeric(19,5)

 Markdown A...(more) Join Now SOP30300.MRKDNAMT
Account_Index_Array_2_1 int
Account_Index_Array_2_2 int
Account_Index_Array_2_3 int
Account_Index_Array_2_4 int
Account_Index_Array_2_5 int
Profit_Type_Number smallint

 1 =  ...(more) Join Now JC00701.Profit_Type_Number
Profit_Amount numeric(19,5)
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
Record_Notes text
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