Project

General

Profile

Feature #1456

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 08.03.2023

Added by Luc Tran Van over 2 years ago. Updated over 2 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
03/07/2023
Due date:
% Done:

0%

Estimated time:
1.0 TR_REQ_PROCESS_CHILD_APP.txt (37.3 KB) 1.0 TR_REQ_PROCESS_CHILD_APP.txt Luc Tran Van, 03/07/2023 10:44 PM
PL_REQ_DOC_SendApp.txt (24.3 KB) PL_REQ_DOC_SendApp.txt Luc Tran Van, 03/07/2023 10:54 PM
1.0 HOAN TAT PYCMS PUR 2023 000263.txt (653 Bytes) 1.0 HOAN TAT PYCMS PUR 2023 000263.txt Luc Tran Van, 03/08/2023 09:38 AM
TR_CONTRACT_Upd.txt (22.6 KB) TR_CONTRACT_Upd.txt Luc Tran Van, 03/08/2023 03:10 PM
DATA_#4#5.xlsx (13.2 KB) DATA_#4#5.xlsx Luc Tran Van, 03/09/2023 10:26 AM
data hợp đồng.txt (522 Bytes) data hợp đồng.txt Luc Tran Van, 03/09/2023 11:04 AM
TR_REQUEST_CAR_Search.txt (12.2 KB) TR_REQUEST_CAR_Search.txt Luc Tran Van, 03/09/2023 11:10 AM
DATA_MONTH_LIMIT.xlsx (32.2 KB) DATA_MONTH_LIMIT.xlsx Luc Tran Van, 03/09/2023 11:24 AM
DATA_#7.xlsx (11.2 KB) DATA_#7.xlsx Luc Tran Van, 03/09/2023 11:33 AM
CM_REQUEST_TEMPLATE_Get_Report_No.txt (762 Bytes) CM_REQUEST_TEMPLATE_Get_Report_No.txt Luc Tran Van, 03/09/2023 01:55 PM
rpt_TSCD_BC06_1_Excel_BanViet.txt (30.3 KB) rpt_TSCD_BC06_1_Excel_BanViet.txt Luc Tran Van, 03/09/2023 01:57 PM
rpt_TSCD_BC08_2_Excel_BanViet.txt (24.4 KB) rpt_TSCD_BC08_2_Excel_BanViet.txt Luc Tran Van, 03/09/2023 01:58 PM
DATA_#13.xlsx (9.55 KB) DATA_#13.xlsx Luc Tran Van, 03/09/2023 02:00 PM
Lấy data hợp đồng.txt (702 Bytes) Lấy data hợp đồng.txt Luc Tran Van, 03/09/2023 02:32 PM
DATA_#18.xlsx (11.7 KB) DATA_#18.xlsx Luc Tran Van, 03/09/2023 02:38 PM

History

#4 Updated by Luc Tran Van over 2 years ago

DECLARE @ID varchar(mAX)
SELECT @ID=at.ASSET_ID FROM ASS_MASTER at WHERE at.ASSET_CODE='069TS21020012220001'
SELECT * FROM ASS_TRANSACTIONS at WHERE at.ASSET_ID= @ID
SELECT * FROM ASS_ADDNEW aa WHERE aa.ADDNEW_ID= (SELECT at.TRN_ID FROM ASS_TRANSACTIONS at WHERE at.ASSET_ID= @ID)
SELECT * FROM ASS_MASTER am WHERE am.ASSET_ID=@ID

#5 Updated by Luc Tran Van over 2 years ago

DECLARE @ID varchar(mAX)
SELECT @ID=at.ASSET_ID FROM ASS_MASTER at WHERE at.ASSET_CODE='069TS21020012220002'
SELECT * FROM ASS_TRANSACTIONS at WHERE at.ASSET_ID= @ID
SELECT * FROM ASS_ADDNEW aa WHERE aa.ADDNEW_ID= (SELECT at.TRN_ID FROM ASS_TRANSACTIONS at WHERE at.ASSET_ID= @ID)
SELECT * FROM ASS_MASTER am WHERE am.ASSET_ID=@ID

#9 Updated by Luc Tran Van over 2 years ago

select * from TR_REQUEST_DOC_DT where CONTRACT_ID = 'TRC000000000254'

#10 Updated by Luc Tran Van over 2 years ago

select * from TR_CONTRACT where CONTRACT_ID = 'TRC000000000254'

#13 Updated by Luc Tran Van over 2 years ago

select * from CM_GOODS where GD_ID = 'GOO000000255604'

Also available in: Atom PDF