Can I read SQL Queries for OINV Data Linking on EtoBox?

SQL Queries for OINV Data Linking by Juan is a document available to read on EtoBox.

What is SQL Queries for OINV Data Linking about?

The document contains 3 SQL queries that are joining different tables to link purchase invoices (OINV) to other tables. The first query joins OINV to document headers (ORCT) and lines (RCT2). The second joins OINV to credit memos (ORIN) and their lines (RIN1). And the third joins OINV to reconciliation documents (OITR) and their lines (ITR1) using the reconciliation number and source object.

Author

Juan

Language

EN