EXEC TR_REQ_PAY_DETAIL 'TRPY00000200455'
TRPY00000200455

SELECT * FROM TR_REQ_PAY_ATTACH WHERE REQ_PAY_ID = 'TRPY00000200455'
SELECT * FROM CM_SUPPLIER WHERE SUP_CODE = 'NCC000001126250'


EXEC dbo.sp_generate_inserts @table_name = 'TR_REQ_PAY_ATTACH', @from = 'TR_REQ_PAY_ATTACH'

	
SELECT * FROM CM_SUPPLIER WHERE SUP_CODE = 'NCC000001126250'

Update cot Ten tai khoan trong PDN Tam ung:
UPDATE TR_REQ_PAY_METHOD SET ACC_NAME = '' WHERE METHOD_ID = ''
SELECT * FROM TR_REQ_PAY_METHOD WHERE REQ_PAY_ID = (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE = 'NCC.2020.000092'



SELECT * FROM TR_REQ_PAY_PERIOD WHERE CONTRACT_ID = 'TRC000001125921'

UPDATE TR_REQ_PAY_PERIOD SET AMT_PAY =28778461.00 WHERE PERIOD_ID='PYOD00000200469'
UPDATE TR_REQ_PAY_PERIOD SET AMT_PAY =28778461.00 WHERE PERIOD_ID='PYOD00000200469'
00003014
Check thông tin khách hàng:
SELECT * FROM LS_CUSTOMER WHERE CUSTOMER_CODE = 00003014
UPDATE LS_CUSTOMER SET AUTH_STATUS = 'A' WHERE CUSTOMER_CODE = 00003014
Check PYCMS:
SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2020/000056'

Cap nhat PDN Thanh toan:
UPDATE TR_REQ_PAYMENT SET REQ_PAY_CODE ='SỐ PHIẾU CŨ', REQ_DT ='Nắm - Tháng - Ngày', CREATE_DT ='Năm - Tháng - Ngày',
APPROVE_DT ='Năm - Tháng - Ngày', APPROVE_DT_KT ='Năm - Tháng -Ngày', AUTH_STATUS='A', AUTH_STATUS_KT='A'
WHERE REQ_PAY_CODE='SỐ PHIẾU MỚI'


Cap nhat PDN Tam Ung: luy ke PAY_AMT
UPDATE TR_REQ_ADVANCE_PAYMENT SET REQ_PAY_CODE ='062020/089422', REQ_DT ='2020-06-26', CREATE_DT =REQ_DT,
APPROVE_DT =REQ_DT, APPROVE_DT_KT =REQ_DT, AUTH_STATUS='A', AUTH_STATUS_KT='A'
WHERE REQ_PAY_CODE='NCC.2020.000121'

BANG HOA DON: TR_REQ_PAY_INVOICE

CHECK TT TRA VE:
SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-0010007'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-0010007')
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-0010007')

UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID =''
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB ='C' WHERE ID =''
https://gsoft.com.vn/wp-content/uploads/2020/09/10.-PHAT-SINH-PYCMS-TU-TTCT.txt - EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC ''  -- TRUYEN ID CUA TO TRINH CHU TRUONG VAO

Tim hoa don :SELECT * FROM TR_REQ_PAY_INVOICE WHERE INVOICE_NO = '0011727'
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE = '092020/000858'

Xoa hđ:
DELETE FROM TR_CONTRACT WHERE CONTRACT_ID ='TRC000000251746'
DELETE FROM TR_CONTRACT_DT WHERE CONTRACT_ID ='TRC000000251746'
DELETE FROM TR_CONTRACT_PAYMENT WHERE CONTRACT_ID ='TRC000000251746'