Should The V_total_totalname Table Be Used Instead For Sa_sys_value ( – InterviewSolution

InterviewSolution

1.

Should The V_total_totalname Table Be Used Instead For Sa_sys_value (for Calculated Totals) For Getting The Most Recent Value For A Totals On A Store/day?

Answer»

No, V_SA_TOTAL_VALUE VIEW should be used to GET the LATEST Total VALUE.

No, V_SA_TOTAL_VALUE view should be used to get the latest Total Value.

Discussion

No Comment Found

Related InterviewSolutions

Is It Possible To Restrict The Ability To View All Stores By Location Security In Rms? Is It The Same Restriction For The 'transaction Find' Window Through 'transaction Maintenance' Menu ?
There Are Five Totals Displayed On Miscellaneous Totals Window (samisctl). What Do They Signify?
Why Is The 'transaction Find' Window Through 'transaction Maintenance' Menu Not Restricted To The Users Home Store While The Store / Close Audit Screen Is?
If The 'store Close Audit' Menu Shows The Users Home Store Automatically, Then Why Is It Not Visible In The 'transaction Find' Screen?
How Is Transaction Level Discount (i.e. Slab Discount) Handled In Rtlog File In Retail Sales Audit (resa)?
In Currency Rounding Rules Detail Maintenance(sarruldt) Form, When Defining The First Range As 0 To 0.2600, Why Is It Not Possible To Use 0.2700 As The Lowest Ending Amount For The Next Range?
Is The Currency-based Rounding Rules Only Used For Resa?
Why Is A Sales Audit Table (prefixed With Sa_) Used In Standard Rms (oracle Retail Merchandising System) Functionality As Currency Rounding In Price Management?
Why Post Voided Transactions From Resa Forms Are Not Picked By Saexprms?
Can We Post Void Transactions In Resa (retail Sales Audit) By Changing The Value Of Transaction Type From 'sales' To ‘void’?