Micros 3700 SQL script to change serving period 1

[gcuevas]

Greetings all,

My RVC is not changing serving period despite that is enable and the serving periods are created.
i am looking at this script and i want to understand the numbers and what they are pointing too in the POS Configurator,

update micros.rvc_def
set srv_period_seq = 34
where rvc_seq = 9
commit

34 is not in relation to the serving period number ID
9 is not in relation to RVC number ID

any suggestions how to understand this numbers and how to identify them the relation in POS Configurator

thank you

 

[Wildbar]

You would need to look at the serving period and revenue center definitions.
Select * from micros.srv_period_def and and relate srv_period_seq to prd_seq
Selct * from micros.rvc_def and relate rvc_seq to obj_num
That should be what your asking I beleive

 

[gcuevas]

thank you Wildbar
it is populating the data