I am trying to read sales discount information in my script but am having trouble with some fields. For example field tdsls041.dlev has three pieces of infomation within one field.

Is this an array within a table? How do I process this information?

All replies appreciated.

Thanks Mike

To take the three values you have to write something like this in your script:

value1=tdsls041.dlev(1)
value2=tdsls041.dlev(2)
value3=tdsls041.dlev(3)

Hope this helps.

There are several fields on the sales order line table dealing with pricing and discounting that are essentially arrays of size 3. You would access each one as tdsls041.dlev(1) [or (2) or [3]). Whether all three are in play depends on the value of the "Number of Discount Levels" field on the Sales Order Parameters table (tdsls000.mldi.4 -- session tdsls4100m000).

What other information do you need?

Thanks for your quick responses. That should be the information I need. Mike