Hi Omar
Sales transactions (SOP) are stored in 4 main tables. They are:
SOP_HDR_WORK (SOP10100) Sales Transaction Work
SOP_HDR_HIST (SOP30200) Sales Transaction History
SOP_LINE_WORK (SOP10200) Sales Transaction Amounts Work
SOP_LINE_HIST (SOP30300) Sales Transaction Amounts History
This table information is available from Tools >> Resources >> Table descriptions.
Hope this helps.
David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.