Who's On?

	Membership:
	Latest: navav4
	Past 24 Hours: 0
	Prev. 24 Hours: 2
	Overall: 5208

	People Online:
	Visitors: 445
	Members: 0
	Total: 445

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

AP45.1 Query

2 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Elmer Madarang

New Member

Posts: 4

New Poster

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

Veteran Member

Posts: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

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

Veteran Member

Posts: 1163

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