Computation Sheets 4729816
| ID | RC Code/ Terminal/ Code | NUmber> | Debtor Code | Debtor Name | Status | Receipt ID | CS Date | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Details
4729002
|
M206 Aroroy (O374) | O-O374-202312000126 | 1 | SAMSON RAPSING | Receipted | 1984892 | 2023-12-16 14:05:17 | ||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||
|
Details
4729001
|
M302 Fort San Pedro - RC2 (BP11) | C-BP11-202312001298 | 1031804 | JADES CARGO SERVICES INC. | Receipted | 1984895 | 2023-12-16 14:04:50 | ||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||
select cs_header.*
, 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"."CS_HEADER" inner join "IPORTS"."TERMINALS" t on "CS_HEADER"."TERMINAL_ID" = "T"."ID" inner join "IPORTS"."USERS" uc on "CS_HEADER"."CREATED_BY" = "UC"."ID" inner join "IPORTS"."RCENTERS" rc on "CS_HEADER"."RCENTER_ID" = "RC"."ID" where "CS_HEADER"."ID" > ? order by "CS_HEADER"."ID" desc