Message Boards

What field in the data base is

thumbnail
Jeffrey Craig, modified 3 Years ago.

What field in the data base is

Post Date: 2/21/18 (Bronze, 1 Post) Recent Posts

As you are processing the data entry for the purchase order a window pops up with the VAT register and the OP code.  It defaults in and I think I understand the default.  But, after you have entered it and go back in, it doesn't allow you to change the value.  So, I assume it has to actually store the data to be retreived later.  My question is where is it stored?  I cannot find the value on the po_mstr or the qad_wkfl or even the various tx tables.  Am I missing it?

It is originally stored in local variables vat_reg and op_code.

Mark vanHornsveld, modified 8 Years ago.

Re: What field in the data base is

Post Date: 2/22/18 (Gold, 216 Posts) Recent Posts

Hello Raymond,

These fields are part of VAT Register functionality in European Accoutining.

Not sure what version you are working in but the vat_reg field could be stored in  txr_mstr.txr_register from menu 2.13.7.1 euvtrgmt.p.

and op_code would be txrd_det.txrd_code. 

Operation Codes can be defined in euoptymt.p 2.13.11 (atd_mstr).

Hope that helps.

Greetings,

Mark

 

thumbnail
Raymond Chin Kwie Joe, modified 8 Years ago.

Re: What field in the data base is

Post Date: 2/27/18 (Rhodium, 825 Posts) Recent Posts

If you are looking for a file relation, below is the best I could find. follow link to manual.

Message place holder