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

malcolm · #1 (**permalink**) June 26th, 2007, 14:28

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 · #2 (**permalink**) June 26th, 2007, 20:12

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.