Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Need Link between PO, Receiving and Trade Transaction — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need Link between PO, Receiving and Trade Transaction

Question
20
Views
0
Comments
edited Apr 7, 2021 5:53PM in Reporting and Analytics for SCM

Summary

Require Table links related to Purchase Order , Receiving , ASN and Trade Operation Charges

Content

We need to develop a report to display the Purchase Order Details, Receiving and Shipment Details, Trade Operation Charges (estimates and Actuals)

We have the details in the below tables.

Purchase Orders
PO_HEADERS_ALL
PO_LINES_ALL
PO_DISTRIBUTIONS_ALL
PO_LINE_LOCATIONS_ALL

PO Receipts
RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_TRANSACTIONS

ASN Details
CMR_PURCHASE_ORDER_DTLS
CMR_RCV_TRANSACTIONS

Trade Operations and Charges
CML_TRADE_OPERATIONS
CML_TRADE_OPERATION_CHARGES
CML_CHARGES_VL
CML_TROP_CHARGE_ESTIMATES
CML_CHARGE_INVOICE_ASSOCS

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!