Is there any documentation that explains the different datatypes like what P15.2NS is, etc?

In my master files on the as400 I have a redefinition in MASTER.F554852 and MASTER_53.F554852

DEFINE TLTRQT/P16.2NS=TLTRQT/100;,$

which is refedining this field to divide by 100 since its a JDE database:

FIELD=TLTRQT,
ALIAS=TLTRQT, USAGE=P15 , ACTUAL=P15,
DESCRIPTION='Transaction Quantity',
TITLE='Transaction Quantity',$

In EDAMAS7.F554852 I have:

FIELD=TLTRQT, TLTRQT, P16, P16,$

Finally in F554852.MAS on the Windows side, I have:

FIELD=TLTRQT,
ALIAS=TLTRQT, USAGE=P15.2NS , ACTUAL=P15,
DESCRIPTION='Transaction Quantity',
TITLE='Transaction Quantity',$

This transaction qty is supposed to be like pieces, but in the report its printed a $ in front likes its currency.

Is it because P15.2NS is for currency, or what? I just took the set of masterfiles from an old table and kind of pieced together how to create a new one, so I don't really understand why they're making a P8 into P15, then P15 into P16.2NS, and finally P15.2NS

Is there any documentation on these datatype trasformations?

I figured out I can just take the N out on the Windows side:

P15.2NS => P15.2S

And its no longer printing as currency.

Look for "Describing Data With WebFOCUS Language" in the Technical Documentation Library for WF 7.6

You could also check out the WebFOCUS Keysheet Release 8 Chapter 8 - Master File. Gives you the all the different fieldtypes, segments, database types, etc.

All the essentials of master file definitions.

Vivian