AP45.1 Query

Sort:
You are not authorized to post a reply.
Author
Messages


Elmer Madarang











New Member



Posts: 4




New Member



    I want to build a query to pull reportable amount in Ap45.1

    Field name is: REPINCAMT - I can't seem to find which table this belongs to? Does any one know and how can I pull that via a .dme

    thanks!

    Elmer

     

     



    Ragu Raghavan











    Veteran Member



    Posts: 468




    Veteran Member



      Depending on the conditions, looks like it could be from any number for source - see extract from code AP45 below

      005150 IF (APP-TRAN-INC-AMT NOT = ZEROS)
      005160 MOVE APP-TRAN-INC-AMT TO AP45F1-REPINCAMT (I1)
      005170 ELSE
      IF (APP-DISC-LOST-FLG = "Y")
      005180 MOVE APP-TRAN-PMT-AMT TO AP45F1-REPINCAMT (I1)
      ELSE
      COMPUTE AP45F1-REPINCAMT (I1) ROUNDED = APP-TRAN-PMT-AMT
      - APP-TRAN-DISC-AMT.
      005200 IF (APP-REC-STATUS = 9)
      005210 AND (APP-TRAN-INC-AMT = ZEROS)
      005220 MOVE ZEROS TO AP45F1-REPINCAMT (I1).


      JonA











      Veteran Member



      Posts: 1162




      Veteran Member



        From APPAYMENT: COMPANY, VENDOR, INVOICE, TRAN-INC-AMT, TRAN-DISC-AMT, REC-STATUS.

        From Related Table APVENMAST: VENDOR-NAME

        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        You are not authorized to post a reply.