Invoice information window within Sales Transaction Entry window SQL Table reference needed

(0) Share

Report

Posted on by Community Member

In the Sales Transaction Entry window, if you go to Additional and then "Invoice Information" window, the data in there, I need to know which table is that storing to. I am including the screenshot of the window in question. I would be very appreciative if someone can point me in the right direction. Thank you!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

This looks like an Extender window. Do you have Extender? If you click on Tools->Table Insert what does it list there?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

so I have looked it is indeed an extender window. but I'm still unsure to figure out where the data is being placed at?? any ideas? would it be stored in the ext tables in Sql?

Was this reply helpful? Yes No
Suggested answer

Patrick Lauzière 467 on at

Like (1)

Report
Copy link

Link copied!

Hi Adal,

It's look like an extender window.

If it's the case you will be able to see your index in the EXT00100 table. Which is the "Extender Window Key Values"

Try:

select *

from EXT00100

where PT_UD_Key like 'ET637247%'

If you see your SOP Number in the PT_UD_Key field try with one of those tables

EXT00101 Extender Window Field Strings

EXT00102 Extender Window Field Dates

EXT00103 Extender Window Field Numbers

EXT00104 Extender Window Field Times

Exemple:

select *

from EXT00101

where PT_UD_Key like 'ET637247%'

Was this reply helpful? Yes No