Module List > Module SV tables SV00166
You are currently viewing the COMPANY database.
Change

COMPANY..SV00166 Table Definition

(COMPANY..SV_Extended_Pricing_Matrix_LINE)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Pricing_Matrix_Name char(15)


WS_Cost_Code int


WS_Other_Cost_Sub_Code int


Price_Matrix_Entry_1 char(31)


Price_Matrix_Entry_2 char(31)


Price_Matrix_Entry_3 char(31)


Price_Matrix_Entry_4 char(31)


Price_Matrix_Entry_5 char(31)


Price_Matrix_Entry_6 char(31)


Price_Matrix_Entry_7 char(31)


SEQNUMBR int

Field Type...(more) Join Now
WS_Billing_Method smallint


Billing_Amount numeric(19,5)


ITEMDESC char(101)

Field Type...(more) Join Now
Pricing_Markup_Amount numeric(19,5)


Pricing_Markup_Percent int


Pricing_Amount_1 numeric(19,5)


Pricing_Amount_2 numeric(19,5)


MODIFDT datetime

Date the r...(more) Join Now
Modified_Time datetime


MDFUSRID char(15)

User that ...(more) Join Now
join ... more text available
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