|
1
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371117',N'TSCD',N'ASG000000001415',N'999081',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999081',N'0',N'0',NULL,NULL,0,NULL)
|
|
2
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371118',N'TSCD',N'ASG000000001415',N'999082',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999082',N'0',N'0',NULL,NULL,0,NULL)
|
|
3
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371119',N'TSCD',N'ASG000000001415',N'999083',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999083',N'0',N'0',NULL,NULL,0,NULL)
|
|
4
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371120',N'TSCD',N'ASG000000001415',N'999084',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999084',N'0',N'0',NULL,NULL,0,NULL)
|
|
5
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371121',N'TSCD',N'ASG000000001415',N'999085',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999085',N'0',N'0',NULL,NULL,0,NULL)
|
|
6
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371122',N'TSCD',N'ASG000000001415',N'999086',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999086',N'0',N'0',NULL,NULL,0,NULL)
|
|
7
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371123',N'TSCD',N'ASG000000001415',N'999087',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999087',N'0',N'0',NULL,NULL,0,NULL)
|
|
8
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371124',N'TSCD',N'ASG000000001415',N'999088',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999088',N'0',N'0',NULL,NULL,0,NULL)
|
|
9
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371125',N'TSCD',N'ASG000000001415',N'999089',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999089',N'0',N'0',NULL,NULL,0,NULL)
|
|
10
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371126',N'TSCD',N'ASG000000001415',N'999090',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999090',N'0',N'0',NULL,NULL,0,NULL)
|
|
11
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371127',N'TSCD',N'ASG000000001415',N'999091',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999091',N'0',N'0',NULL,NULL,0,NULL)
|
|
12
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371128',N'TSCD',N'ASG000000001415',N'999092',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999092',N'0',N'0',NULL,NULL,0,NULL)
|
|
13
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371129',N'TSCD',N'ASG000000001415',N'999093',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999093',N'0',N'0',NULL,NULL,0,NULL)
|
|
14
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371130',N'TSCD',N'ASG000000001415',N'999094',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999094',N'0',N'0',NULL,NULL,0,NULL)
|
|
15
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371131',N'TSCD',N'ASG000000001415',N'999095',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999095',N'0',N'0',NULL,NULL,0,NULL)
|
|
16
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371132',N'TSCD',N'ASG000000001415',N'999096',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999096',N'0',N'0',NULL,NULL,0,NULL)
|
|
17
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371133',N'TSCD',N'ASG000000001415',N'999097',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999097',N'0',N'0',NULL,NULL,0,NULL)
|
|
18
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371134',N'TSCD',N'ASG000000001415',N'999098',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999098',N'0',N'0',NULL,NULL,0,NULL)
|
|
19
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371135',N'TSCD',N'ASG000000001415',N'999099',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999099',N'0',N'0',NULL,NULL,0,NULL)
|
|
20
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371136',N'TSCD',N'ASG000000001415',N'999100',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999100',N'0',N'0',NULL,NULL,0,NULL)
|
|
21
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371137',N'TSCD',N'ASG000000001415',N'999101',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999101',N'0',N'0',NULL,NULL,0,NULL)
|
|
22
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371138',N'TSCD',N'ASG000000001415',N'999102',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999102',N'0',N'0',NULL,NULL,0,NULL)
|
|
23
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371139',N'TSCD',N'ASG000000001415',N'999103',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999103',N'0',N'0',NULL,NULL,0,NULL)
|
|
24
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371140',N'TSCD',N'ASG000000001415',N'999104',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999104',N'0',N'0',NULL,NULL,0,NULL)
|
|
25
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371141',N'TSCD',N'ASG000000001415',N'999105',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999105',N'0',N'0',NULL,NULL,0,NULL)
|
|
26
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371142',N'TSCD',N'ASG000000001415',N'999106',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999106',N'0',N'0',NULL,NULL,0,NULL)
|
|
27
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371143',N'TSCD',N'ASG000000001415',N'999107',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999107',N'0',N'0',NULL,NULL,0,NULL)
|
|
28
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371144',N'TSCD',N'ASG000000001415',N'999108',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999108',N'0',N'0',NULL,NULL,0,NULL)
|
|
29
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371145',N'TSCD',N'ASG000000001415',N'999109',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999109',N'0',N'0',NULL,NULL,0,NULL)
|
|
30
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371146',N'TSCD',N'ASG000000001415',N'999110',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999110',N'0',N'0',NULL,NULL,0,NULL)
|
|
31
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371147',N'TSCD',N'ASG000000001415',N'999111',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999111',N'0',N'0',NULL,NULL,0,NULL)
|
|
32
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371148',N'TSCD',N'ASG000000001415',N'999112',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999112',N'0',N'0',NULL,NULL,0,NULL)
|
|
33
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371149',N'TSCD',N'ASG000000001415',N'999113',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999113',N'0',N'0',NULL,NULL,0,NULL)
|
|
34
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371150',N'TSCD',N'ASG000000001415',N'999114',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999114',N'0',N'0',NULL,NULL,0,NULL)
|
|
35
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371151',N'TSCD',N'ASG000000001415',N'999115',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999115',N'0',N'0',NULL,NULL,0,NULL)
|
|
36
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371152',N'TSCD',N'ASG000000001415',N'999116',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999116',N'0',N'0',NULL,NULL,0,NULL)
|
|
37
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371153',N'TSCD',N'ASG000000001415',N'999117',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999117',N'0',N'0',NULL,NULL,0,NULL)
|
|
38
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371154',N'TSCD',N'ASG000000001415',N'999118',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999118',N'0',N'0',NULL,NULL,0,NULL)
|
|
39
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371155',N'TSCD',N'ASG000000001415',N'999119',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999119',N'0',N'0',NULL,NULL,0,NULL)
|
|
40
|
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],[ASS_CONTRACT_CODE],[PL],[REQ_ID],[REQ_CODE],[ASS_CODE_TMP],[OS],[MO_LICENSE],[CURRENT_TRANS],[CURRENT_TRANS_TYPE],[IS_COLLECT],[REF_GROUP_ID])VALUES(N'ASS000001371156',N'TSCD',N'ASG000000001415',N'999120',N'Laptop Dell 31032023',NULL,NULL,NULL,55000000,55000000,N'1',NULL,NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'0',10.00,120.00,NULL,NULL,NULL,NULL,0.00,0,NULL,N'ASPO00001170968',NULL,NULL,NULL,NULL,NULL,0,NULL,N'VNM',N'1',N'',N'N',N'1',N'A',N'vinhnt',N'Mar 30 2023 1200AM',N'kieuttt',N'Mar 30 2023 403PM',NULL,NULL,NULL,N'Mar 30 2023 1200AM',NULL,N'BT',N'DV0001',N'321000202',10.00,5000000,N'0',NULL,NULL,NULL,NULL,NULL,N'999120',N'0',N'0',NULL,NULL,0,NULL)
|