[SOLVED] Do the SEQ fields have to be unique?

[malcolm]

Hi all,

I was wondering if the SEQ fields such as RATE_GEO_COST_SEQ and RATE_GEO_COST_GROUP_SEQ have to be unique.

Mal

[AlejandroBarba]

Re: Do the SEQ fields have to be unique?

Hi Malcolm,

The RATE_GEO_COST_SEQ and RATE_GEO_COST_GROUP_SEQ in the tables RATE_GEO_COST and RATE_GEO_COST_GROUP do not have to be necessarily unique.

Nevertheless you should always use different RATE_GEO_COST_SEQ numbers within the same Rate Record if you have more than one cost line (for example when you have different rates depending on the equipment types in the same Rate Record).

Hope this helps,

Alejandro B.