Scribd
Upload
18 views2 pages

Price Structure Query for SKUs

The document contains a SQL query that retrieves pricing and distributor information from a database. It selects various fields related to price structures, including secondary and primary prices, effective dates, and unit measures for specific SKUs. The query filters results based on a specific effective date and a list of SKUs.

Uploaded by

aleek6404
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
18 views2 pages

Price Structure Query for SKUs

The document contains a SQL query that retrieves pricing and distributor information from a database. It selects various fields related to price structures, including secondary and primary prices, effective dates, and unit measures for specific SKUs. The query filters results based on a specific effective date and a list of SKUs.

Uploaded by

aleek6404
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

SELECT [Link],[Link],convert(varchar, dt.

WORKING_DATE, 105) WORKING_DATE,


[Link], ps.PRICE_STRUC,
PRICE_UNIT1 AS 'SECONDARY PRICE CS', PRICE_UNIT2 AS 'SECONDARY PRICE DZ',
PRICE_UNIT3 AS 'SECONDARY PRICE PC',
PRICE_PURCHASE1 AS 'PRIMARY PRICE CS',PRICE_PURCHASE2 AS 'PRIMARY PRICE
DZ',PRICE_PURCHASE3 AS 'PRIMARY PRICE PC',
bc.SELL_FACTOR1 as [Seconday UOM CS], bc.SELL_FACTOR2 as [Secondary UOM DZ],
bc.SELL_FACTOR3 as [Secondary UOM PC],
bc.PURCHASE_FACTOR1 as [Primary UOM CS], bc.PURCHASE_FACTOR2 as [Primary UOM DZ],
bc.PURCHASE_FACTOR3 as [Primary UOM PC],
convert(varchar, EFFECTIVE_DATE, 105) EFFECTIVE_DATE,convert(varchar,
EFFECTIVE_TODATE, 105) EFFECTIVE_TODATE, ps.GST_REGISTERED, ps.GST_NREGISTERED
FROM PRICE_STRUCTURE ps
join batch bc on [Link] = [Link] and [Link] = [Link]
left join DISTRIBUTOR dt on [Link] = [Link]
where
EFFECTIVE_DATE IN '20250908'
AND [Link] IN
('21133329',
'64767114',
'64767116',
'64785330',
'64840278',
'64875203',
'64892650',
'64892653',
'64892656',
'64947100',
'64947106',
'64947112',
'64947118',
'64947124',
'64947131',
'64947137',
'64947143',
'64947300',
'64947307',
'64947313',
'64947319',
'64947325',
'64947332',
'64947338',
'64947344',
'64948009',
'64948016',
'64948022',
'64948029',
'64953995',
'64954001',
'64954018',
'64954020',
'64960765',
'64960771',
'64960777',
'64960783',
'64960789',
'64960795',
'64987261',
'64987268',
'65067513',
'65067525',
'65067531',
'65067537',
'65067543',
'65086637',
'65086641',
'65218554',
'65218557',
'65218560',
'65218563',
'65218566',
'65218569',
'65218572',
'65218575',
'65221149',
'65234364',
'65234368',
'65234372',
'65234464',
'65243406',
'65243413',
'65243420',
'65243990',
'65243993',
'65248686',
'65248690',
'65248694',
'65254314',
'65426411',
'65428006',
'68542102',
'68718670',
'69583229',
'69583247',
'69743970',
'69743987')

You might also like