This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
You probably need to create a new ObjectStructure and so a new table for Workorders.
Sent from Samsung Mobile
-------- Original message --------
Subject: [MAXIMO List] Need Help on Maximo 6.2 interface tables
From: raj_631 <raj_631@yahoo.com>
To: MAXIMO@yahoogroups.com
CC:
Hi All,
I need help on my user requirement for interface tables.
Did below successfully (done).
- Insert the data into Maximo.MXIN_INTER_TRANS & Maximo.MISR_IFACE tables
- Maximo will run cron job and create SRs in the system, at the same time data will be deleted from Maximo.MXIN_INTER_TRANS table
- Once SRs created, a reference data row (new row) will be added to Maximo.MXOUT_INTER_TRANS table with unique transid and the same time a new row will be added to Maximo.MISR_IFACE table with SR Status and Status Date.
- For Each status change on SR, a new row will be added to iface and out bound the tables.
Now Users will create workorder manually for respective SR.
Requirement is : update workorder number, wo# status and wo# status date to SR in the interface table or outbound table.
this one we need to update in MISR_Iface table or MXOUT_Inter_trans table?
in both the tables no fields are available.
We need to create new fields for wo#, wo# status?
is there any way to update without any custom class file or what is the best way to update?
Basically I never worked on integration interface table.
we working on Maximo 6.2
Thanks in advance for your kind info
Regards