Hi, everybody
How can I retrieve the fields displayed on the manual supplier invoice screen from the database?
"SQL Column" field is disable and not available in “LOV Reference” field.
Retrieving Fields from Manual Supplier Invoice Screen Database
Userlevel 6
+11
Hi
The fields you refer to are Client fields that do not show SQL Column in System Info. But you can use MAN_SUPP_INVOICE and MAN_SUPP_INVOICE_ITEM views to get the corresponding columns for these fields.
Hope this will help.
Regards,
Akila
+1
I couldn't find the MAN_SUPP_INVOICE and MAN_SUPP_INVOICE_ITEM views. I believe some fields above are default, and some fields are also calculated. I'm wondering if I can retrieve these fields from anywhere else in the database.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.