Payment Transactions 4729816
| ID | RC Code/ Terminal/ Code | NUmber> | Debtor Code | Debtor Name | Status | Receipt ID | CS Date | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Details
3
|
M201 Manhac/Malbog () | C-O445-202604000003 | 4736404 | SILVER 8 LOGISTICS AND TRUCKING SERVICES CORPORATION | matangmua@iports.com | Created | 1292 | ||||||||||||||
|
|||||||||||||||||||||
|
Details
2
|
M201 Manhac/Malbog () | C-O445-202604000003 | 4736404 | SILVER 8 LOGISTICS AND TRUCKING SERVICES CORPORATION | matangmua@iports.com | Created | 1292 | ||||||||||||||
|
|||||||||||||||||||||
|
Details
1
|
M201 Manhac/Malbog () | C-O445-202604000003 | 4736404 | SILVER 8 LOGISTICS AND TRUCKING SERVICES CORPORATION | matangmua@iports.com | Created | 1292 | ||||||||||||||
|
|||||||||||||||||||||
select myeg_payments.*
, rc.code rc_code
, rc.rc_name
, t.term_name
, uc.first_name as creator_fname
, uc.last_name as creator_lname
, uc.middle_name as creator_mname
, uc.email as creator_email
from "IPORTS"."MYEG_PAYMENTS" left join "IPORTS"."TERMINALS" t on "MYEG_PAYMENTS"."TERMINAL_ID" = "T"."ID" inner join "IPORTS"."USERS" uc on "MYEG_PAYMENTS"."CREATED_BY" = "UC"."ID" inner join "IPORTS"."RCENTERS" rc on "MYEG_PAYMENTS"."RCENTER_ID" = "RC"."ID" where "MYEG_PAYMENTS"."ID" > ? order by "MYEG_PAYMENTS"."ID" desc