Support for multiple checks on single field

[vishakhabhasin]

I have a scenario where I am required to perform more than one check on single field.
For example:
For a column - Type should be Decimal, Pattern should be 9,999,999.00 and the value should be less than a million. For this I am required to include two rules which are
F Type: Pattern and Rule: ?,???,???.??
F Type: Decimal and Length ...999999

How can I handle such scenario in CID file? Thanks.