Module List > Module Manufacturing tables SCSU0020
You are currently viewing the COMPANY database.
Change

COMPANY..SCSU0020 Table Definition

(COMPANY..Sales_Config_Component_Price)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PPN_I char(31)
''
Parent Par...(more) Join Now
BOMNAME_I char(15)
''
Bill of Ma...(more) Join Now
SOPNUMBE char(21)
''

SOPTYPE smallint
0

LNITMSEQ int
0
Line Item ...(more) Join Now PA11801.LNITMSEQ
CMPNTSEQ int
0

CPN_I char(31)
''
Component ...(more) Join Now
SEQ_I int
0

QUANTITY numeric(19,5)
0.00
QTY: The n...(more) Join Now
ORUNTCST numeric(19,5)
0.00
Field Type...(more) Join Now
UNITCOST numeric(19,5)
0.00
Field Type...(more) Join Now
ORUNTPRC numeric(19,5)
0.00
Field Type...(more) Join Now
UNITPRCE numeric(19,5)
0.00
Field Type...(more) Join Now
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