Using OEINVD and OECOINI tables for report and trying to get item/miscellaneous comments. Somehow I am not able to get comments to match. Any tips?
*note: Filter COINTYPE = 1 to include comments and not instructions
SQL:
SELECT dbo.OEINVH.INVNUMBER, dbo.OEINVD.ITEM, dbo.OEINVD.MISCCHARGE, dbo.OECOINI.COINTYPE, dbo.OECOINI.UNIQUIFIER, dbo.OECOINI.COIN
FROM dbo.OEINVH INNER JOIN
dbo.OEINVD ON dbo.OEINVH.INVUNIQ = dbo.OEINVD.INVUNIQ LEFT OUTER JOIN
dbo.OECOINI ON dbo.OEINVD.INVUNIQ = dbo.OECOINI.INVUNIQ AND dbo.OEINVD.DETAILNUM = dbo.OECOINI.DETAILNUM
WHERE (dbo.OECOINI.COINTYPE = 1)
*note: Filter COINTYPE = 1 to include comments and not instructions
SQL:
SELECT dbo.OEINVH.INVNUMBER, dbo.OEINVD.ITEM, dbo.OEINVD.MISCCHARGE, dbo.OECOINI.COINTYPE, dbo.OECOINI.UNIQUIFIER, dbo.OECOINI.COIN
FROM dbo.OEINVH INNER JOIN
dbo.OEINVD ON dbo.OEINVH.INVUNIQ = dbo.OEINVD.INVUNIQ LEFT OUTER JOIN
dbo.OECOINI ON dbo.OEINVD.INVUNIQ = dbo.OECOINI.INVUNIQ AND dbo.OEINVD.DETAILNUM = dbo.OECOINI.DETAILNUM
WHERE (dbo.OECOINI.COINTYPE = 1)
*Community Hub is the new name for Sage City