DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

 

SELECT * FROM TR_PO_MASTER WHERE PO_CODE ='PO069/20/0083'

SELECT * FROM TR_PO_PAYMENT WHERE PO_ID =(SELECT PO_ID FROM TR_PO_MASTER WHERE PO_CODE ='PO069/20/0083') 

Trạng thái: Select thành công 

PO_ID PO_CODE PO_NAME CONTRACT_ID SUP_ID SUP_NAME SUP_ADDR INPUT_DT PAYMENT_DT TOTAL_AMT REQ_DOC_ID DELIVERY_DT PAYAPP_DT NOTES RECORD_STATUS MAKER_ID CREATE_DT AUTH_STATUS CHECKER_ID APPROVE_DT PO_TYPE BRANCH_ID IS_CLOSED AMT_ADD 

TRPM00000251113 PO069/20/0083 Cải tạo trụ sở mới Chi nhánh Thanh Hóa   CMS000001126237     9/30/2020 12:23:01 PM 1/1/1900 12:00:00 AM 1057640727 TRRD00000251147       1 tanvt 9/30/2020 1:32:32 PM A vanpt2 9/30/2020 1:35:42 PM 1 DV0001     

PAY_ID PO_ID PAY_PHASE EXP_DT PERCENT AMOUNT NOTES RECORD_STATUS MAKER_ID CREATE_DT AUTH_STATUS CHECKER_ID APPROVE_DT CURRENCY RATE TOTAL_AMT 

TRPP00000251350 TRPM00000251113 1 9/30/2020 12:00:00 AM 40 423056291   U tanvt 9/30/2020 1:32:32 PM U   1/1/1900 12:00:00 AM VND 1 423056291.00 

TRPP00000251351 TRPM00000251113 1 9/30/2020 12:00:00 AM 40 423056291   U tanvt 9/30/2020 1:32:32 PM U   1/1/1900 12:00:00 AM VND 1 423056291.00 

TRPP00000251352 TRPM00000251113 3 9/30/2020 12:00:00 AM 30 317292218   U tanvt 9/30/2020 1:32:32 PM U   1/1/1900 12:00:00 AM VND 1 317292218.00 

Result ErrorDesc 

SUCCESSFULL