SQL code assistance for APS

carzer · #1 07-29-2010, 02:01 PM

I have an old Progress program that referenced the planned requirements and receipts in Syteline 5. In Syteline 5, that was the mrp & rcpts tables. We are now using APS and I want to recreate this report. I see the rcpts table is still available, but should I reference the apsplan or apsplandetail table or another? Thanks.

Derik · #2 07-29-2010, 02:05 PM

Hi Carzer -

Which version of SQL Syteline are you running?

APS definitely changed between Progress Syteline and Syteline7...then again with Syteline8.

Thanks,

Derik

carzer · #3 07-29-2010, 02:08 PM

Forgot to add - we're on Sl 8.01.00.

khkiley · #4 07-30-2010, 09:26 AM

Carzer,

Without knowing anything about your report, ApsPlan and ApsPlanDetail are good to start with. There are also some table functions you should look at. When I get some time this weekend I will look them up for you.

Kurt

EdKale · #5 07-30-2010, 06:43 PM

Carzar,
I would use the PlanningDetail view. It combines several APS tables and is the source for the Planning Details form in SL

Ed Kale
Senior Syteline Consultant
Eclipse Consulting, Inc.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Welcome to the SYTELINE FORUMS.
You are currently viewing this forum as a guest, giving you limited access to our community. Please take a minute to register, it's fast, easy, and free! Members of Syteline Forums enjoy a lot of great features such as; the ability to post and create threads, ask questions, get or give advice, and share experiences. We invite you to join SyteLine Forums today!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)