Table design - decide which data dictionary item to choose for a column

[Rauf]

Being a beginner, how can I decide to choose between data dictionaty items if I am about to design a new table ?
For example, for a payment request (to finance department) based on purchase order. The table should have PRID. Which data dictionary item should I choose for PRID(it should be a number). Can I choose DOCO for this?

 

[Scott Beebe]

If the table needs PRID, why don't you use that one? Why choose a different DD item?

 

[clmates]

Hi

I usually look for item type and description in the DD browser, If I find any suitable, use it, If not, then consider to create a new custom DD item, use any system from 55 to 59 for your items and you are safe

also, when you create a transaction table that you use always insert audit fields (User, Workstation, application, date and time)

you can generate a primary index in many ways, you need to keep clear the use of your table:

- it can be used by several users at a time on the same documents?

- should you implement record locking (or reservation)?

- you need an unique transaction index?

etc

then choose best index to suit your needs


HTH

 

[Rauf]

Oh, did you mean PayrollID-PRID. I need a data item to store Payment Request ID. It should be a number.