PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 3/19/2020 3:57 PM by  JonA
AP45.1 Query
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Elmer Madarang
AP prgrm governance Specialist
Private
New Member
(6 points)
New Member
Posts:4


Send Message:

--
2/26/2020 12:50 AM

    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
    Private
    Private
    Veteran Member
    (1294 points)
    Veteran Member
    Posts:450


    Send Message:

    --
    2/26/2020 2:25 AM
    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
    Private
    Private
    Veteran Member
    (3449 points)
    Veteran Member
    Posts:1147


    Send Message:

    --
    3/19/2020 3:57 PM

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

    From Related Table APVENMAST: VENDOR-NAME

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