Scheduled Resource Table

Hey Drew..



The actual table that Epicor stores what specific resources are
scheduled for a particular operation is ResourceTimeUsed. On a side
note, give me a call, there are some things I'd like to discuss
regarding that and the email you sent the other day...



Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of drew.pete
Sent: Friday, April 08, 2011 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Scheduled Resource Table





Hello all,

On 905.602A - I'm looking to put together a BAQ report for projected
load on resources. So far, all I can find for resources on Jobs is in
the JobOpDtl table. I'd like to be using the table that houses the
"Scheduled Resources" found on the Scheduled Resources tab in Job Entry.
Does anyone know what table that information resides in?

Thanks!
Drew





[Non-text portions of this message have been removed]
Hello all,

On 905.602A - I'm looking to put together a BAQ report for projected load on resources. So far, all I can find for resources on Jobs is in the JobOpDtl table. I'd like to be using the table that houses the "Scheduled Resources" found on the Scheduled Resources tab in Job Entry. Does anyone know what table that information resides in?

Thanks!
Drew
Well, did some digging using the BL Tester and found the datasource. Says it's external which makes sense why I can't find a table named "JobResources".

Table: JobResources
JobResources.Company {EXTERNAL} String
JobResources.JobNum {EXTERNAL} String
JobResources.AssemblySeq {EXTERNAL} Int32
JobResources.OprSeq {EXTERNAL} Int32
JobResources.OpDtlSeq {EXTERNAL} Int32
JobResources.WhatIf {EXTERNAL} Boolean
JobResources.AllocNum {EXTERNAL} Int32
JobResources.ResourceGrpID {EXTERNAL} String
JobResources.ResourceID {EXTERNAL} String
JobResources.ResourceDesc {EXTERNAL} String
JobResources.CalendarName {EXTERNAL} String
JobResources.RowIdent {EXTERNAL} String
JobResources.RowMod {EXTERNAL} String
JobResources.DBRowIdent {EXTERNAL} Byte[]

Now just to figure out how in the world this information is calculated/determined?

--- In vantage@yahoogroups.com, "drew.pete" <drew.pete@...> wrote:
>
> Hello all,
>
> On 905.602A - I'm looking to put together a BAQ report for projected load on resources. So far, all I can find for resources on Jobs is in the JobOpDtl table. I'd like to be using the table that houses the "Scheduled Resources" found on the Scheduled Resources tab in Job Entry. Does anyone know what table that information resides in?
>
> Thanks!
> Drew
>
Not sure if you've tried this already... In Job Entry, open Field Help
then choose "Technical Details". It will display the data binding for
each field, with table and column name.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of drew.pete
Sent: Friday, April 08, 2011 12:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Scheduled Resource Table





Well, did some digging using the BL Tester and found the datasource.
Says it's external which makes sense why I can't find a table named
"JobResources".

Table: JobResources
JobResources.Company {EXTERNAL} String
JobResources.JobNum {EXTERNAL} String
JobResources.AssemblySeq {EXTERNAL} Int32
JobResources.OprSeq {EXTERNAL} Int32
JobResources.OpDtlSeq {EXTERNAL} Int32
JobResources.WhatIf {EXTERNAL} Boolean
JobResources.AllocNum {EXTERNAL} Int32
JobResources.ResourceGrpID {EXTERNAL} String
JobResources.ResourceID {EXTERNAL} String
JobResources.ResourceDesc {EXTERNAL} String
JobResources.CalendarName {EXTERNAL} String
JobResources.RowIdent {EXTERNAL} String
JobResources.RowMod {EXTERNAL} String
JobResources.DBRowIdent {EXTERNAL} Byte[]

Now just to figure out how in the world this information is
calculated/determined?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"drew.pete" <drew.pete@...> wrote:
>
> Hello all,
>
> On 905.602A - I'm looking to put together a BAQ report for projected
load on resources. So far, all I can find for resources on Jobs is in
the JobOpDtl table. I'd like to be using the table that houses the
"Scheduled Resources" found on the Scheduled Resources tab in Job Entry.
Does anyone know what table that information resides in?
>
> Thanks!
> Drew
>





[Non-text portions of this message have been removed]