SalesParmTable, SalesParmLine is temporary store table?

(0) Share

Report

Posted on by Community Member

Hi All,

May I know whether SalesParmTable and SalesParmLine is temporary table during sales posting only or it will store data permanently to these table even after posting?

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (3)

Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi

The "PARM" tables aren't temporary, but contain all Posting data session.

Every session have a different ParmId value.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

"Parm" tables are not temporary tables. They are regular tables. However, once the posting is complete this data is not used any longer. You should develop a maintenance schedule to clean up these tables, so they don't get too large. AX provides clean up functionality to delete old parm records. Before using these clean up jobs make sure you check for relationships with or dependencies from custom tables, so that referential integrity is properly maintained.

Hope this helps. --Tom

Was this reply helpful? Yes No
Verified answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi, These are not temp tables and records do not get deleted after sales order posting. These tables create records based on user sessions which is distinguished by ParmId.

Was this reply helpful? Yes No