|
1
|
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(N'ASA000000257747',N'Dec 29 2022 12:00AM',NULL,N'ASG00000001298',NULL,N'MÁY CHẤM CÔNG BẰNG VÂN TAY BIOENTRY P2 BEP2-OD',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,1.00,1200.00,N'0',1,N'ASPO00000257747',NULL,NULL,NULL,0,NULL,N'N',NULL,N'1',N'A',N'ngadh',N'Dec 29 2022 10:35AM',N'sondt1',N'Dec 29 2022 11:10AM',NULL,N'N',N'BRN000000251877',N'U',NULL,NULL,NULL,NULL,N'I',NULL,N'321000202',0.00,0,N'DEP000000252360')
|
|
2
|
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(N'ASA000000257748',N'Dec 29 2022 12:00AM',NULL,N'ASG00000001318',NULL,N'BÀN TRÒN TIẾP KHÁCH',NULL,N'SL : 06 CÁI',NULL,NULL,NULL,NULL,NULL,0,NULL,1.00,1200.00,N'0',1,N'ASPO00000257748',NULL,NULL,NULL,0,NULL,N'N',NULL,N'1',N'A',N'ngadh',N'Dec 29 2022 10:37AM',N'sondt1',N'Dec 29 2022 11:10AM',NULL,N'N',N'BRN000000251877',N'U',NULL,NULL,NULL,NULL,N'I',NULL,N'321000202',0.00,0,N'DEP000000252360')
|
|
3
|
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(N'ASA000000257749',N'Dec 29 2022 12:00AM',NULL,N'ASG00000001306',NULL,N'CỬA GIAN ĐỆM CKD-10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,1.00,1200.00,N'0',1,N'ASPO00000257749',NULL,NULL,NULL,0,NULL,N'N',NULL,N'1',N'A',N'ngadh',N'Dec 29 2022 10:40AM',N'sondt1',N'Dec 29 2022 11:10AM',NULL,N'N',N'BRN000000251877',N'U',NULL,NULL,NULL,NULL,N'I',NULL,N'321000202',0.00,0,N'DEP000000252360')
|