How do you maintain Reference Code Defaults on MSQ620?

[Drw]

The same old problem has surfaced again - No one at Mincom can (or appears not to want) to help me...

I have found there were a few records in msf071 with an entity_value = '1' (for the entity_type = 'WKO').

When creating a new work order via msq620 these values in msf071 would be the dafaults for the corresponding ref_no's in the reference code tab.

Does anyone know how to maintain these via the online screens?

Drew

 

[dianne001]

I hope this answers your question. You can go to the mso074 and put in the entity WKO and see the existing values. you can then go to the mso070 to add items to the WKO. if you need more definitions in the WKO entity.

Let me know if this helps.

 

[Drw]

Thanks Dianne… Yes these screens let you review or modify Reference Code Definitions however they do not let you add reference code details (values) for an entity.

Drew

 

[PhantomPhil]

From what I can determine, there are "Mincom defined" and "User defined" reference codes (ie. the entity type) - set up in 'RCEN' table (via MSO010). The associated values have a flag.

The "Mincom defined" reference code values can only be modified via modification of the corresponding entity - eg. WKO values are reference codes for work orders, so can only be modified via the work order modification programs. (I think I found that one as action code '9' on MSM62CA - there are probably other ways of maintaining this, but I'm a developer, not a user! Use of action code '9' to get to reference codes does seem like a Mincom 'standard' way to get to ref codes (ie I've seen it on other programs too))

If you can decipher cobol code, then have a look at the msg071ws.cpy component (lives in the copyfile directory of the source code structure). I found that this gives a good indication of the "Mincom defined" reference code structures for each of the entity types. There are some tricky ones (WKO and PUR are 2 that I ran into but there are others) which have multiple structures (hence some of the values for WKO start with a '1' which I think means work order, and some start with a '2' which I think means standard job).

 

[PhantomPhil]

But to answer the question! ...

I think the "defaults" for the work order reference codes are coming from the standard job reference codes.

eg. Set up standard job reference code values by going to MSO690, then use action code '9' on MSM69CB, and then finish SJ creation.

When creating a WO, eg via MSO620 (or in your case via MSQ620) and I get to action code '9' on MSM62CA, then the "defaults" I see are the values from the SJ reference codes.

Looking at the content of MSF071

For the SJ, the entries are:
ENTITY_TYPE = 'WKO'
ENTITY_VALUE = '2' + district + sj

For the WO, the entries are:
ENTITY_TYPE = 'WKO'
ENTITY_VALUE = '1' + district + wo

 

[Drw]

Yes when creating a work order from a Standard Job then the defaults will come from the reference codes stored against the Standard Job
entity_value = '2 + district code + standard Job Number'

However when executing msq620 (not mso620 – mso62c with action 9 – there are no defaults here) the defaults for reference codes come from where the entity_value = ‘1’.

Drew