Extract from AR_CASH_RECEIPTS_V
Hi all,
I am trying to write an extract using TOAD, of the data captured in the Receipts Summary form. Two of the fields that I wanted to capture are Statement Number and (Statement) Line Number.
I can see these columns on the form and diagnostics tells me the data I'm looking at on screen is in AR_CASH_RECEIPTS_V. However, in TOAD, when I look at the AR_CASH_RECEIPTS_V columns neither of those two fields are part of the view.
Does anyone know where the Cash Receipt Bank Statement is held and how I can capture that information in my extract?
I am trying to write an extract using TOAD, of the data captured in the Receipts Summary form. Two of the fields that I wanted to capture are Statement Number and (Statement) Line Number.
I can see these columns on the form and diagnostics tells me the data I'm looking at on screen is in AR_CASH_RECEIPTS_V. However, in TOAD, when I look at the AR_CASH_RECEIPTS_V columns neither of those two fields are part of the view.
Does anyone know where the Cash Receipt Bank Statement is held and how I can capture that information in my extract?
0