Can someone please let me know where I can find the Data Model for the Oracle Retail Sales Audit?
Also there are some SA Tables in the Retail Merchandising System Data Model. Please let me know if this is a super set of the Oracle Retail Sales Audit Data Model?
You can refer to the below in meta link: Doc ID 1331603.1 Retail Suite Information Center Index, Documentation, and Customer Resources
I am not sure I understand your question, could you be more specific. Can you list out the exact tables that you are referring to for which you need to know how the data is populated. Thanks.
After going through the documentation, I could figure out that SA_TRAN_HEAD,SA_CUSTOMER,SA_CUST_ATTRIB,SA_TRAN_ITEM,SA_TRAN_DISC,SA_TRAN_IGTAX,SA_TRAN_PAYMENT,SA_TRAN_TENDER are populated from the RTLog where in there is a record for each transaction and the columns in these tables are getting populated.
I had a query on the database the ReSa uses, but thanks to you I was able to get an understanding of that.
Now as for the tables like SA_STORE_DATA,SA_STORE_DAY,SA_STORE_POS,SA_STORE_VALUE,SA_TRAN_PAYMENT_REV,SA_VOUCHER_OPTIONS , how are these getting populated?
Pardon my ignorance,but I am a newbie to this and I am just getting to know about all this.
Let me start with the ones that I am completely aware about:
SA_STORE_DAY - This basically allows you to create a Business Day for which to process the transactions. The batch sastdycr.pc will create this record, you can get information about this batch from the Operations Guide.
SA_STORE_DATA : On the store form (Org Hierarchy -> Edit a Store) goto Options and select Store Data and enter the required details, this will create a record there.
SA_TRAN_PAYMENT_REV : saimptlogfin.pc will insert into this if there are any changes to the existing transactions when they are being processed by this batch.
For the other tables, I am sure that there will be some way to populate them either online or they may be populated via some install scripts. But I cannot give specific information. Also please refer the following Note, it is many references as well in it with several FAQ's. This may help you. Happy Learning!
FAQ: Oracle Retail Sales Audit Fundamentals Part 1 (Doc ID 876434.1)
Thanks a lot Preeti for this valuable bit of information.
I did not quite get you on how to access FAQ: Oracle Retail Sales Audit Fundamentals Part 1 (Doc ID 876434.1)+.
Can you please let me know where I can this be getting from.
Thanks in Advance for your help.