Attribute data type significance

[former_member594111]

Hi All,

Can you please tell significance of each attribute data type, when we need to use particular data type like navchar,decimal,integer,timestamp

and whats is length in attribute

Regards,

Abhijeet

[piyush_parekh · Accepted solution]

Hi Abhijeet,

Each attribute type serves different purpose in maintaining specific data record.

1. NVARCHAR - most commonly used attribute used to maintain alphanumeric records. You need to specify the length of attribute i.e. maximum number of characters allowed. Length parameter is applicable only for this attribute type.

2. Decimal - This type of attribute can contain decimal values and can be used as attribute and key figures in a planning model. The length is predefined as (18,6) i.e. 6 decimal places and 12 integer places.

3. Integer - to maintain records of integer types. e.g Lead Time or WEEKWEIGHT in time profiles

4. Timestamp - to maintain date and time type of records e.g.ACTMOVEDATE in Delivery MDT

Hope this helps!

Regards,

Piyush

[former_member594111 · Accepted solution]

Thank you so much Piyush

Yes its helps.