CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

F98950 - BINDTA field

edited Mar 10, 2017 4:00AM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered

Hi,

Hope you can help me with this one.

We needed to copy grid formats for one application from user1 to a number of other users. In orther to do it we built  a sql code more or less like this one:

;

SELECT * FROM F98950 WHERE UOUSER='USER1' AND UOFMNM IN ('W4210A')

CREATE TABLE TEMP_F98950 AS

SELECT * FROM F98950 WHERE UOUSER='USER1' AND UOFMNM IN ('W4210A')

Update TEMP_F98950 Set Uouser='USER2';

INSERT INTO F98950 (SELECT * FROM TEMP_F98950);

;

It worked ok but i would like to know the logic for field F98950.BINDTA, I saw that it took a diferent value for each one of the new lines, do you guys know what's the purpose of this field?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center