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
3