Table creation

[Former Member]

Hi Friends,

I want a table field which accepts number upto '999999999999' and also accepts amount as negative or positive value, can any one please tell me what datatype or reference field I should take while creating a table.

Regards,

[Former Member]

You can create a custom domain for the amount field, specify desired value for the field length. Create data element for this domain and use the same in your custom table.

[Former Member]

Hi,

You can use this data element: WKGXXX.

Or you can find others data element with Data Type Currency field that have SIGN.

Regards,

[Former Member]

Hi,

Use data type CURR length 15 decimals 2.

You can also use the data element MAXBT.

Message was edited by:

Velangini Showry Maria Kumar Bandanadham

[Former Member]

Hi Line,

You can use the data elements BREST, KAWRT...

or else create a data element using the domain WERTV8.

<b>Reward points if this helps,</b>

Kiran

[Former Member]

Hi,

What shall I take my dataclass and size catagory as this table will hold daily transactional data.

Regards,

Line

[Former Member]

Hi

Can I take any field type (already used in other tables) for creating a ztable.

Line

[Former Member]

Hi,

For the negative value take the data type as INT4 which accepts negative and positive value.

Regards,