Epicor SQL Query and Export Specialist
Budget: $15 – $25 USD
I need an expert in Epicor Prophet 21 SQL, particularly the 2005 version. Your primary task will be generating a Multi-View Joined Query.
Key Tasks:
- Generate Multi-View Joined Query
- Must include detailed line items from the Tag table.
- May also need assistance with:
- Exporting and cleaning data (removing embedded line feeds)
- Query Plating Process
- Open Sales Orders
- Open Purchase Orders
- Refreshing and regenerating queries for Go Live:
- On-hand inventory
- Sales History
- Purchase History
- Open Accounts Receivable
- Open Accounts Payable
- Open Sales Orders
- Open Purchase Orders
- Item Master Refresh
- Customer and Vendor Number Refresh
Ideal Skills:
- Proficiency in SQL and Epicor Prophet 21
- Experience with data export to XLSX
- Strong data cleaning and query generation skills
- Familiarity with database management and query refresh processes
Looking for someone who can deliver accurate and clean data efficiently. Please share relevant experience and approach.
Key Tasks:
- Generate Multi-View Joined Query
- Must include detailed line items from the Tag table.
- May also need assistance with:
- Exporting and cleaning data (removing embedded line feeds)
- Query Plating Process
- Open Sales Orders
- Open Purchase Orders
- Refreshing and regenerating queries for Go Live:
- On-hand inventory
- Sales History
- Purchase History
- Open Accounts Receivable
- Open Accounts Payable
- Open Sales Orders
- Open Purchase Orders
- Item Master Refresh
- Customer and Vendor Number Refresh
Ideal Skills:
- Proficiency in SQL and Epicor Prophet 21
- Experience with data export to XLSX
- Strong data cleaning and query generation skills
- Familiarity with database management and query refresh processes
Looking for someone who can deliver accurate and clean data efficiently. Please share relevant experience and approach.