xTuple.com xTupleU Blog & News Customer Support

Where is the table in the Check Details

The following query in the Check report where is the checkDetailFormatted coming from. I checked in the database including the api schema and it is not there. I want to modify the checkdata_checknumber, to not include "Invoice#" string

 

SELECT checkdata_page,
       checkdata_checknumber,
       checkdata_checkwords,
       checkdata_checkdate,
       checkdata_checkamount,
       checkdata_checkcurrsymbol,
       checkdata_checkcurrabbr,
       checkdata_checkcurrname,
       checkdata_checkpayto,
       checkdata_checkaddress,
       checkdata_checkmemo,
       checkdata_docnumber,
       checkdata_docreference,
       checkdata_docdate,
       checkdata_docamount,
       checkdata_docdiscount,
       checkdata_docnetamount
  FROM checkDetailFormatted(<? value("checkhead_id") ?>, 12);

It is a function

It is a function, public.checkdetailformatted(). If you want to change this I suggest copying it to a new name (in its own schema, so like custom.checkdetailcustom() or something), and then modify the check report definition to use your custom function. 

Got it! I see that function. Will create a new schema and modify. Thanks for the help