Extraction of Processing Option Values

Ravi_Shankar41

Member
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0748D.8DF442E0
Content-Type: text/plain;
charset="iso-8859-1"

Hi JDE List,

Happy New Year to EveryOne On The List


The Research steps and results are as follows:


1. Extract the text from F98306-(PO text) PTPOTX.
Results : All the PO text are stored in this table.

2. BLOB field of F983051 (Version List) VRPODATA gives the Data elements
stored in the PO.(ie PO values).
Results : When we blow the BLOB field we could able to get the data in this
format " 2| | | |ZJDE0001 1|T04012|1|2|3|4|5 "
Explanation : Locate the PO tamplate name in this data stream in the above
result.The Right side of the Template name will give the ID numbers and the
left side will be the corresponding PO values for these IDs.eg:For the ID
number 1(first number in right side of the PO Tamplate nameie T04012) the PO
value is 2(First number in the left side of Tamplate name).simillarly for
the ID number 5 the PO value is ZJDE0001

3. ID number: This is the number that JDE uses its own logic to generate in
PO design phase.This number is used in the BLOB field of F983051.


IN F985031 VRFRMTSTR doesn't help in extacting the PO values

RE: Extraction of PO values [Post#: 3142 / re: 3137 ]

As Zoltan commonly precedes: put your system config in the signature. Also,
I'm not sure that my answer actually answers your question - English in not
my native tongue. But I'll write my experiences just the same - maybe
someone will find them useful.

I did some experimenting with PO values in B7332 a while ago.
In this version (presumably, in all from B733 to XE), there's a field in
F985031, VRFRMTSTR, which describes, what fields are meaningful in BLOB
data. It has for 1 char, for string NUMBER-1 [JDEdwards uses
zero-terminated strings], for example, for String 9-1=8; d for Date, m
for Math, there may be other values, never listed them all.
Lets take P0004A ZJDE0002 for example - it'll have value c5c3 in this field,
which means it's two strings, 4 and 2 chars long, which makes sense, 'cause
system code is 4 char long (don't flame me, I know that you only 3 are
really used now) and User Defined Code is 2 chars long. If you decode BLOB,
you'll get the following data:
" 00|LT.1|T0004A|2|3.."
(zero chars are replaced with dots to improve legibility, double quotes
enclose actual value). The same in Hex:
20 30 30 7C 4C 54 00 31 7C 54 30 30 30 34 41 7C 32 7C 33 00 00

Basically, to get PO values, you need to decode first part of the BLOB (the
one before the zero char): First PO parameter is "00", and the second
parameter is "LT". You need to drop everything, which is after zero char, or
after you decode all fields, which are described in VRFRMTSTR. By the way,
the last bit is important - I found more then several occasions, where you
have more fields in the first part of BLOB (before zero char), then are
described in VRFRMTSTR. At first I wondered, then just tried changing them
in interactive version. What a surprise: they were gone. I guess it was some
corruption during some stage at a time (and this time can be very long ago,
see P0004A ZJDE0133 for a bit of fun - this was there in B7331, and in B7332
(and in XE Standalone, as I just figured out)).
The part after zero char is the reference to PO data structure (I never used
this part, so I may be wrong, but points appear valid). 1 seems always to be
there, then there is T0004A, which is the PO data structure name, and then
the numbers. It appears, that if you take only fields from F98306 (PTPOTP =
1), and sort them first by PTITNUM and then by PTSQNUM, and assign numbers
from 1 upwards, you get the sequence numbers, which are used. But this logic
is immediately violated by the program we took as an example - here
numbering starts from 2. Still, it seems to me, that as long as you order
decoded values in the same sequence as fields in F98306, you should be on
the safe side.

Hope it helps,
Vladimir Ponomarev
Config: Well, as noted in the body - this particular part was on B7332,
Wintel, SQL

PS: if you just need PO values for all programs - why don't you output
R98306 to CSV file :).

Personal Disclaimer: All of the above is result of investigation out of
curiosity, and should be taken as such. I can't promise that it'll work for
you. My Employer does not approve these recommendations. I do not recommend
that you work with database directly instead of provided means in JDEdwards.
And so on and so forth.
Also:

E-mail disclaimer:
The information in the e-mail is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this e-mail by anyone
else is unauthorised. If you are not the intended recipient, any
disclosure,copying, distribution or any action taken or omitted to be taken
in reliance on it, is prohibited and may be unlawful.



Hi JDEList Users,

Can anyone help me to extract the data from the processing option (PO
values). My requirement is to figure out the tables that are involved in
storing the PO values. My research says that, the PO values are stored in
BLOB field of F983051,and PO text are in F98306.When we tried to blow this
field we have noticed that the field contains ID number. The data is bar
separated according to the ID.We are unable to figure out where the ID is
stored in the data base so as to correlate its PO value in the F983051.

Also, when we print the PO form in the design format, we found this ID
getting printed in the last column of PO template.(This output will show the
relationship with the ID and PO values).

We require to solve this ASAP.

Any input will be greatly appreciated.

Thanks and Regards,

Ravi Shankar R
Application Specialist
AristaSoft International PVT. LTD.
URL http://www.aristasoft.com
[email protected]



------_=_NextPart_001_01C0748D.8DF442E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Extraction of Processing Option Values</TITLE>
</HEAD>
<BODY>



<FONT SIZE=3D2 FACE=3D"Arial">Hi JDE List,</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">Happy New Year to EveryOne On The =
List</FONT>
</P>





<FONT SIZE=3D2 FACE=3D"Arial">The Research steps and results are as =
follows:</FONT>
</P>





<FONT SIZE=3D2 FACE=3D"Arial">1. Extract the text from F98306-(PO =
text) PTPOTX.</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">Results :</FONT><FONT SIZE=3D2 =
FACE=3D"Arial"> All the PO text are stored in this table.</FONT>
</P>



<FONT SIZE=3D2 FACE=3D"Arial">2. BLOB field of F983051 (Version =
List) VRPODATA gives the Data elements stored in the PO.(ie PO =
values).</FONT>

<FONT SIZE=3D2 FACE=3D"Arial">Results :</FONT><FONT SIZE=3D2 =
FACE=3D"Arial"> When we blow the BLOB field we could able to get the =
data in this format "</FONT> <FONT FACE=3D"Arial">2| | | =
|ZJDE0001 1|T04012|1|2|3|4|5</FONT>
<FONT SIZE=3D2 =
FACE=3D"Arial"> " </FONT></P>



<FONT SIZE=3D2 FACE=3D"Arial">Explanation :</FONT> <FONT =
SIZE=3D2 FACE=3D"Arial">Locate the PO tamplate name in this data stream =
in the above result.The Right side of the Template name will give the =
ID numbers and the left side will be the corresponding PO values for =
these IDs.eg:For the ID number 1(first number in right side of the PO =
Tamplate nameie T04012) the PO value is 2(First number in the left side =
of Tamplate name).simillarly for the ID number 5 the PO value is =
ZJDE0001 </FONT></P>



<FONT SIZE=3D2 FACE=3D"Arial">3.</FONT> <FONT SIZE=3D2 =
FACE=3D"Arial">ID number:</FONT>
<FONT SIZE=3D2 FACE=3D"Arial"> This =
is the number that JDE uses its own logic to generate in PO design =
phase.This number is used in the BLOB field of F983051.</FONT></P>





<FONT SIZE=3D2 FACE=3D"Arial">IN F985031 VRFRMTSTR doesn't help in =
extacting the PO values </FONT>
</P>



<FONT FACE=3D"Times New Roman">RE: Extraction of PO =
values</FONT>
<FONT FACE=3D"Times New Roman">[Post#: 3142 / re: =
3137 ]</FONT>
</P>



<FONT FACE=3D"Times New Roman">As Zoltan commonly precedes: put your =
system config in the signature. Also,

I'm not sure that my answer actually answers your question - English in =
not

my native tongue. But I'll write my experiences just the same - =
maybe

someone will find them useful.



I did some experimenting with PO values in B7332 a while ago.

In this version (presumably, in all from B733 to XE), there's a field =
in

F985031, VRFRMTSTR, which describes, what fields are meaningful in =
BLOB

data. It has for 1 char, for string NUMBER-1 [JDEdwards uses

zero-terminated strings], for example, for String 9-1=3D8; d for Date, =
m

for Math, there may be other values, never listed them all.

Lets take P0004A ZJDE0002 for example - it'll have value c5c3 in this =
field,

which means it's two strings, 4 and 2 chars long, which makes sense, =
'cause

system code is 4 char long (don't flame me, I know that you only 3 =
are

really used now) and User Defined Code is 2 chars long. If you decode =
BLOB,

you'll get the following data:

" 00|LT.1|T0004A|2|3.."

(zero chars are replaced with dots to improve legibility, double =
quotes

enclose actual value). The same in Hex:

20 30 30 7C 4C 54 00 31 7C 54 30 30 30 34 41 7C 32 7C 33 00 00



Basically, to get PO values, you need to decode first part of the BLOB =
(the

one before the zero char): First PO parameter is "00", and =
the second

parameter is "LT". You need to drop everything, which is =
after zero char, or

after you decode all fields, which are described in VRFRMTSTR. By the =
way,

the last bit is important - I found more then several occasions, where =
you

have more fields in the first part of BLOB (before zero char), then =
are

described in VRFRMTSTR. At first I wondered, then just tried changing =
them

in interactive version. What a surprise: they were gone. I guess it was =
some

corruption during some stage at a time (and this time can be very long =
ago,

see P0004A ZJDE0133 for a bit of fun - this was there in B7331, and in =
B7332

(and in XE Standalone, as I just figured out)).

The part after zero char is the reference to PO data structure (I never =
used

this part, so I may be wrong, but points appear valid). 1 seems always =
to be

there, then there is T0004A, which is the PO data structure name, and =
then

the numbers. It appears, that if you take only fields from F98306 =
(PTPOTP =3D

1), and sort them first by PTITNUM and then by PTSQNUM, and assign =
numbers

from 1 upwards, you get the sequence numbers, which are used. But this =
logic

is immediately violated by the program we took as an example - here

numbering starts from 2. Still, it seems to me, that as long as you =
order

decoded values in the same sequence as fields in F98306, you should be =
on

the safe side.



Hope it helps,

Vladimir Ponomarev

Config: Well, as noted in the body - this particular part was on =
B7332,

Wintel, SQL



PS: if you just need PO values for all programs - why don't you =
output

R98306 to CSV file :).



Personal Disclaimer: All of the above is result of investigation out =
of

curiosity, and should be taken as such. I can't promise that it'll work =
for

you. My Employer does not approve these recommendations. I do not =
recommend

that you work with database directly instead of provided means in =
JDEdwards.

And so on and so forth.

Also:

</FONT>

<FONT FACE=3D"Times New Roman">E-mail disclaimer:

The information in the e-mail is confidential and may be legally =
privileged.

It is intended solely for the addressee. Access to this e-mail by =
anyone

else is unauthorised. If you are not the intended recipient, any

disclosure,copying, distribution or any action taken or omitted to be =
taken

in reliance on it, is prohibited and may be unlawful.



</FONT>
</P>



<FONT FACE=3D"Times New Roman">Hi JDEList Users,



Can anyone help me to extract the data from the processing option =
(PO

values). My requirement is to figure out the tables that are involved =
in

storing the PO values. My research says that, the PO values are stored =
in

BLOB field of F983051,and PO text are in F98306.When we tried to blow =
this

field we have noticed that the field contains ID number. The data is =
bar

separated according to the ID.We are unable to figure out where the ID =
is

stored in the data base so as to correlate its PO value in the =
F983051.



Also, when we print the PO form in the design format, we found this =
ID

getting printed in the last column of PO template.(This output will =
show the

relationship with the ID and PO values).



We require to solve this ASAP.



Any input will be greatly appreciated.



Thanks and Regards,



Ravi Shankar R

Application Specialist

AristaSoft International PVT. LTD.

URL <A HREF=3D"http://www.aristasoft.com" =
TARGET=3D"_blank">http://www.aristasoft.com</A>

[email protected]



</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C0748D.8DF442E0--
 
Back
Top