quan and numc

[Former Member]

what is the diffrent between QUAN and NUMC?

[Former Member]

NUMC is a character field which stores numbers.. You cannot specify any decimals for NUMC

QUAN is used to store quantities which has decimals..

[hymavathi_oruganti]

QUAN field is numeric type and NUMC is char+numeric type

[Former Member]

Hi

QUAN is for quantity fields of type Packed numbers with decimals.

NUMC is Numeric Characters of type Packed numbers

Regards,

Wenceslaus.

[Former Member]

Hi,

Usually A QUAN field has to refer to some Unit of measure. NUMC need not refer to any unit field.

Thanks,

Rashmi.

[Former Member]

Hai Rani

Numeric Text (N) Data Type

Data a(3) type n.

a = ‘123’.

Data b(6) type n value ‘500029’.

Data :c(3) type n value ‘123’,

d(6) type n value ‘500029’.

Data e(3) type n.

move ‘123’ to e.

Quan like Packed type DataType

Packed Number (P) Data type

Data a type p decimals 2.

a = ‘123.45’.

Data b type p decimals 2 value ‘234.56’.

Data : c type p decimals 2 value ‘123.45’,

d type p decimals 2 value ‘234.56’.

Thanks & regards

Sreenivasulu P

[abdul_hakim]

QUAN and NUMC are character type fields with the exception that you cannot have decimal points for NUMC..

Cheers,

Abdul

[Former Member]

HI

GOOD

QUAN: Quantity. Equivalent to an amount field DEC. A field of this type must always refer to a units field with UNIT format (reference field). The maximum length for this data type is 31 places

NUMC=>

QUAN: Quantity. Equivalent to an amount field DEC. A field of this type must always refer to a units field with UNIT format (reference field). The maximum length for this data type is 31 places

THANKS

MRUTYUN

[Former Member]

Hi rani,

1. There are differences at

a) usage level

b) database level

2. usage level :

quan : we can enter numbers with decimals

(we cannot enter alphabets)

numc : we can enter numbers (without decimals)

(we cannot enter alphabets)

(NUMC is treated as a string only,

(they are not meant for calculatin purpose)

3. database level :

quan : the field type is NUMBER with decimals

NUMC : the field type is CHAR

regards,

amit m.