how to link 2 tables

[BrotherOmar]

I want to write a report that will link data between the Smartlist Sales Transactions table and the Sales Line Items in SQL. What are the names of the tables? Is there a valid link between the two?

Thanks,

Omar

 

[winthropdc]

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

http://www.microsoft.com/BusinessSolutions

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.

 

[winthropdc]

FYI: The relationship between the Line and Header tables is based on

'SOP Type' (SOPTYPE) and 'SOP Number' (SOPNUMBE).

These are the primary key fields for the header tables.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

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.