GP Tables

SV00166 - SV_Extended_Pricing_Matrix_LINE

SQL Query Builder

22 Columns

Column Description Type Length
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
WS_Billing_Method smallint
Billing_Amount numeric(19,5)
ITEMDESC char(101)
Pricing_Markup_Amount numeric(19,5)
Pricing_Markup_Percent int
Pricing_Amount_1 numeric(19,5)
Pricing_Amount_2 numeric(19,5)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with SV00166. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

MDFUSRID

ASIEXP09 ASIEXP19 ASIEXP22 CM20200 CM20300 CT00002 CT00102 CT40401

Modified_Time

PDK10500 JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301

WS_Other_Cost_Sub_Code

Billing_Amount