SalesParmTable, SalesParmLine is temporary store table?

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (3)

Answers (3)

Verified answer

Faisal Fareed 10,794 User Group Leader on at

Like (0)

Report

RE: SalesParmTable, SalesParmLine is temporary store table?

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.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: SalesParmTable, SalesParmLine is temporary store table?

"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
Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report

RE: SalesParmTable, SalesParmLine is temporary store table?

Hi

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

Every session have a different ParmId value.