Project

General

Profile

Feature #1433

VẬN HÀNH SAU GOLIVE NGÀY 03-01-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:
01/03/2023
Due date:
% Done:

0%

Estimated time:
2.0 HOAN TAT TTCT HDQT.txt (531 Bytes) 2.0 HOAN TAT TTCT HDQT.txt Luc Tran Van, 01/03/2023 09:17 AM
rpt_TR_REQUEST_CAR.txt (4.38 KB) rpt_TR_REQUEST_CAR.txt Luc Tran Van, 01/03/2023 09:53 AM
rpt_TR_REQUEST_CAR.txt (4.56 KB) rpt_TR_REQUEST_CAR.txt Luc Tran Van, 01/03/2023 10:21 AM
NCC.xlsx (133 KB) NCC.xlsx Luc Tran Van, 01/03/2023 01:58 PM
pay_upd_030122.txt (106 KB) pay_upd_030122.txt Luc Tran Van, 01/03/2023 02:50 PM
pay_upd_030122.txt (183 KB) pay_upd_030122.txt Luc Tran Van, 01/03/2023 02:55 PM
check_limit_year.txt (11.9 KB) check_limit_year.txt Luc Tran Van, 01/03/2023 03:07 PM
TR_REQUEST_DOC_SendApp.txt (18.9 KB) TR_REQUEST_DOC_SendApp.txt Luc Tran Van, 01/03/2023 03:27 PM
tr_upd.txt (106 KB) tr_upd.txt Luc Tran Van, 01/03/2023 03:36 PM
tr_upd_030122.txt (107 KB) tr_upd_030122.txt Luc Tran Van, 01/03/2023 04:30 PM
ASS_USE_MULTI_BVB_KT_Upd.txt (5.93 KB) ASS_USE_MULTI_BVB_KT_Upd.txt Luc Tran Van, 01/03/2023 04:35 PM
TR_REQ_BUDGET_Byid.txt (1.19 KB) TR_REQ_BUDGET_Byid.txt Luc Tran Van, 01/03/2023 04:44 PM
PL_REQUEST_DOC_DT_ById.txt (18.4 KB) PL_REQUEST_DOC_DT_ById.txt Luc Tran Van, 01/03/2023 04:57 PM
tr_upd_030122.txt (107 KB) tr_upd_030122.txt Luc Tran Van, 01/03/2023 05:10 PM
check_limit_year_detail.txt (12 KB) check_limit_year_detail.txt Luc Tran Van, 01/04/2023 09:01 AM
insert_PDNTT_040123.txt (27.8 KB) insert_PDNTT_040123.txt Luc Tran Van, 01/04/2023 09:23 AM
TR_REQ_KT_UPD.txt (73.2 KB) TR_REQ_KT_UPD.txt Luc Tran Van, 01/04/2023 10:06 AM
REQ_PHIEUDENGHI_THANHTOAN.docx (52.2 KB) REQ_PHIEUDENGHI_THANHTOAN.docx Luc Tran Van, 01/04/2023 11:19 AM
TR_CHECK_LIMIT_YAEr_040123.txt (12.3 KB) TR_CHECK_LIMIT_YAEr_040123.txt Luc Tran Van, 01/04/2023 11:28 AM
REQ_PHIEUDENGHI_THANHTOAN.docx (52.4 KB) REQ_PHIEUDENGHI_THANHTOAN.docx Luc Tran Van, 01/04/2023 11:34 AM
upd_040123.txt (29.3 KB) upd_040123.txt Luc Tran Van, 01/04/2023 01:40 PM
REQ_PHIEUDENGHI_THANHTOAN.docx (52.2 KB) REQ_PHIEUDENGHI_THANHTOAN.docx Luc Tran Van, 01/04/2023 01:40 PM
CM_BRANCH.txt (3.04 KB) CM_BRANCH.txt Luc Tran Van, 01/04/2023 02:28 PM
CM_EMPLOYEE.txt (5.7 KB) CM_EMPLOYEE.txt Luc Tran Van, 01/04/2023 02:37 PM
rpt_TSCD_BC08_2_Excel_BanViet.txt (24.4 KB) rpt_TSCD_BC08_2_Excel_BanViet.txt Luc Tran Van, 01/04/2023 03:10 PM
tr_req_ins.txt (77.3 KB) tr_req_ins.txt Luc Tran Van, 01/04/2023 04:05 PM
ACC_PAYByid.txt (830 Bytes) ACC_PAYByid.txt Luc Tran Van, 01/04/2023 04:50 PM

History

#3 Updated by Luc Tran Van over 2 years ago

SELECT cs.SUP_CODE,cs.SUP_NAME,tu.BRANCH_NAME FROM CM_SUPPLIER cs LEFT JOIN TL_USER tu ON cs.MAKER_ID= tu.TLNANME

#4 Updated by Luc Tran Van over 2 years ago

#5 Updated by Luc Tran Van over 2 years ago

INSERT INTO [ASS_ADDNEW] ([ADDNEW_ID],[BUY_DATE],[TYPE_ID],[GROUP_ID],[GOODS_ID],[ASSET_NAME],[ASSET_SERIAL_NO],[ASSET_DESC],[BRANCH_ID],[DEPT_ID],[EMP_ID],[DIVISION_ID],[AMORT_START_DATE],[BUY_PRICE],[AMORT_AMT],[AMORT_MONTH],[AMORT_RATE],[IS_MULTIPLE],[QTY],[PO_ID],[PD_ID],[REF_ASSET_ID],[REF_AMORTIZED_AMT],[WARRANTY_MONTHS],[NOTES],[ENTRY_BOOKED],[CORE_NOTE],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[CONSTRUCT_ID],[POSTED_STATUS],[BRANCH_CREATE],[AUTH_STATUS_KT],[CREATE_DT_KT],[APPROVE_DT_KT],[MAKER_ID_KT],[CHECKER_ID_KT],[REPORT_STATUS],[AMORT_END_DATE],[ACCOUNT_GL],[VAT],[PRICE_VAT],[DEPT_CREATE])VALUES

#6 Updated by Luc Tran Van over 2 years ago

INSERT INTO [ASS_MASTER] ([ASSET_ID],[TYPE_ID],[GROUP_ID],[ASSET_CODE],[ASSET_NAME],[ASSET_SERIAL_NO],[ASSET_DESC],[SUP_ID],[BUY_PRICE],[AMORT_AMT],[ASS_TYPE],[BRANCH_ID],[DEPT_ID],[EMP_ID],[DIVISION_ID],[BUY_DATE],[USE_DATE],[SPECIAL_ASS],[AMORT_MONTH],[AMORT_RATE],[AMORT_START_DATE],[AMORT_END_DATE],[FIRST_AMORT_AMT],[MONTHLY_AMORT_AMT],[AMORTIZED_MONTH],[AMORTIZED_AMT],[LIQUIDATION_DT],[PO_ID],[PD_ID],[WAREHOUSE_ID],[LOCATION],[REF_ASSET_ID],[REF_AMORTIZED_AMT],[WARRANTY_MONTHS],[NOTES],[AMORT_STATUS],[ASS_STATUS],[ASS_STATUS_DESC],[ENTRY_BOOKED],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[CONSTRUCT_ID],[AMORT_START_DATE_OLD],[AMORT_END_DATE_OLD],[BUY_DATE_KT],[USE_DATE_KT],[USE_STATUS],[BRANCH_CREATE],[ACCOUNT_GL],[VAT],[PRICE_VAT],[LIQ_W_STATUS],[TINHTRANGTS])VALUES

#11 Updated by Luc Tran Van over 2 years ago

#24 Updated by Luc Tran Van over 2 years ago

INSERT INTO [SYS_ERROR] ([ErrorCode],[ErrorDesc],[Form])VALUES

Also available in: Atom PDF