max value of dt_LONG_NUMBER datatype

[Former Member]

please tell me about max value of each datatype in UserDataSource Object

and example data

dt_LONG_NUMBER

dt_SHORT_NUMBER

dt_QUANTITY

dt_PRICE

dt_RATE

dt_MEASURE

dt_SUM

dt_PERCENT

dt_LONG_TEXT

dt_SHORT_TEXT

dt_DATE

thank advance

[former_member201110 · Accepted solution]

Hi,

Last time I tested, the values I had were:

dt_LONG_NUMBER = -999,999 to 999,999

dt_SHORT_NUMBER = -32,767 to 32,767

dt_QUANTITY = -9,223,372,036,854.00 to 9,223,372,036,854.00

dt_PRICE = -9,223,372,036,854.00 to 9,223,372,036,854.00

dt_RATE = 0 to 9,223,372,036,854.00

dt_MEASURE = -9,223,372,036,854.00 to 9,223,372,036,854.00

dt_SUM = -9,223,372,036,854.00 to 9,223,372,036,854.00

dt_PERCENT = -9,223,372,036,854.00 to 9,223,372,036,854.00

dt_LONG_TEXT = 64000 characters

dt_SHORT_TEXT = max size as per the size property you set in your datasource object

dt_DATE = any valid date

Please note that just because a value is accepted in the UserDataSource doesn't mean you can actually save it to the database. For example, the date 31/12/1752 is valid in the datasource but cannot be saved to the SBO company database because the underlying SQL datetime datatype does not accept this value.

Kind Regards,

Owen

[Former Member · Accepted solution]

Hi expert,

I refer to this datatype and wish to know the following:

1) If in SAP, my general settings on "Unit Price decimals = 4" and "Amount decimals = 2" , under the SDK on add-on development, if I uses the dt_Price datatype, will it follow the price decimals settings?

I am facing strange rounding figures from the add-on development team programs that will round the "Discounted Price" to 2 decimals with decimals settings on "Unit Price decimals = 4" and "Amount decimals = 2"

I have no idea why? And need some knowledge on the SDK data type. Appreciate someone can guide me.

Thank you and regards

Joan.