Posts in: SQL

Supplier_INFORMATION

Retrieves Trading Community Architecture (TCA) party and contact details for Supplier_INFORMATION.

Read More →

PJC Expenditure Item PJC_EXP_ITEMS_ALL To Its Source

SQL query script extracted for PJC Expenditure Item PJC_EXP_ITEMS_ALL To Its Source.

Read More →

Sets - including Common Set

SQL query script extracted for Sets - including Common Set.

Read More →

Profiles and Profile Values - Query all profile options based on criteria

SQL query script extracted for Profiles and Profile Values - Query all profile options based on criteria.

Read More →

Query the values set for a profiles – in this instance DOO

SQL query script extracted for Query the values set for a profiles – in this instance DOO.

Read More →