Need Link between PO, Receiving and Trade Transaction
Summary
Require Table links related to Purchase Order , Receiving , ASN and Trade Operation ChargesContent
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:
2