Hi All,
I am creating a SBO_SP_TransactionNotification message. The statement is as follows,
SELECT T0.[DocNum], T0.[CardName], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity] FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocEntry = cast(@list_of_cols_val_tab_del as int)
If i am not wrong this will return me the document no, BP Name, Posting Date, Item Code, Item Description and Item Quantity from the open document, as i am using @list_of_cols_val_tab_del on DocEntry.
But when i am debugging the same query the @list_of_cols_val_tab_del is returning the BP Name instead of DocEntry.
Can anybody clarify the same if I am right or not, as I want to have a reference to the Open Document Number in the Where Clause and Not BP Name.
Please help me resolve the issue.
Regards
Rohan S. K