Project

General

Profile

Download (5.24 KB)

111.txt

Luc Tran Van, 09/18/2020 08:25 AM

 
1 
??EXEC TR_REQ_PAY_DETAIL 'TRPY00000200455'
2 
TRPY00000200455
3
4 
SELECT * FROM TR_REQ_PAY_ATTACH WHERE REQ_PAY_ID = 'TRPY00000200455'
5 
SELECT * FROM CM_SUPPLIER WHERE SUP_CODE = 'NCC000001126250'
6
7
8 
EXEC dbo.sp_generate_inserts @table_name = 'TR_REQ_PAY_ATTACH', @from = 'TR_REQ_PAY_ATTACH'
9
10
11 
SELECT * FROM CM_SUPPLIER WHERE SUP_CODE = 'NCC000001126250'
12
13 
Update cot Ten tai khoan trong PDN Tam ung:
14 
UPDATE TR_REQ_PAY_METHOD SET ACC_NAME = '' WHERE METHOD_ID = ''
15 
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'
16
17
18
19 
SELECT * FROM TR_REQ_PAY_PERIOD WHERE CONTRACT_ID = 'TRC000001125921'
20
21 
UPDATE TR_REQ_PAY_PERIOD SET AMT_PAY =28778461.00 WHERE PERIOD_ID='PYOD00000200469'
22 
UPDATE TR_REQ_PAY_PERIOD SET AMT_PAY =28778461.00 WHERE PERIOD_ID='PYOD00000200469'
23 
00003014
24 
Check th?ng tin kh?ch h?ng:
25 
SELECT * FROM LS_CUSTOMER WHERE CUSTOMER_CODE = 00003014
26 
UPDATE LS_CUSTOMER SET AUTH_STATUS = 'A' WHERE CUSTOMER_CODE = 00003014
27 
Check PYCMS:
28 
SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2020/000056'
29
30 
Cap nhat PDN Thanh toan:
31 
UPDATE TR_REQ_PAYMENT SET REQ_PAY_CODE ='S? PHI?U Ch', REQ_DT ='N?m - Th?ng - Ng?y', CREATE_DT ='Nm - Th?ng - Ng?y',
32 
APPROVE_DT ='Nm - Th?ng - Ng?y', APPROVE_DT_KT ='Nm - Th?ng -Ng?y', AUTH_STATUS='A', AUTH_STATUS_KT='A'
33 
WHERE REQ_PAY_CODE='S? PHI?U M?I'
34
35
36 
Cap nhat PDN Tam Ung: luy ke PAY_AMT
37 
UPDATE TR_REQ_ADVANCE_PAYMENT SET REQ_PAY_CODE ='062020/089422', REQ_DT ='2020-06-26', CREATE_DT =REQ_DT,
38 
APPROVE_DT =REQ_DT, APPROVE_DT_KT =REQ_DT, AUTH_STATUS='A', AUTH_STATUS_KT='A'
39 
WHERE REQ_PAY_CODE='NCC.2020.000121'
40
41 
BANG HOA DON: TR_REQ_PAY_INVOICE
42
43 
CHECK TT TRA VE:
44 
SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-0010007'
45
46 
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-0010007')
47 
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2020/TTr-0010007')
48
49 
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID =''
50 
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB ='C' WHERE ID =''
51 
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
52
53 
Tim hoa don :SELECT * FROM TR_REQ_PAY_INVOICE WHERE INVOICE_NO = '0011727'
54 
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE = '092020/000858'
55
56 
Xoa h:
57 
DELETE FROM TR_CONTRACT WHERE CONTRACT_ID ='TRC000000251746'
58 
DELETE FROM TR_CONTRACT_DT WHERE CONTRACT_ID ='TRC000000251746'
59 
DELETE FROM TR_CONTRACT_PAYMENT WHERE CONTRACT_ID ='TRC000000251746'
60