Project

General

Profile

DATA_TRANS_291122.txt

Luc Tran Van, 11/29/2022 11:46 AM

 
1
INSERT INTO [MW_TRANSFER] ([TRANSFER_ID],[TRN_DATE],[TRN_TIME],[QTY],[PRICE],[TOTAL_AMT],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[KT_AUTH_STATUS],[KT_MAKER_ID],[KT_CREATE_DT],[KT_CHECKER_ID],[KT_APPROVE_DT],[RECORD_STATUS],[XML_TEMP],[FR_BRN_ID],[FR_DEPT_ID],[CORE_NOTE],[BRANCH_CREATE],[WARE_HOUSE],[TRANSFER_CODE],[FR_DEPT_BRN_ID])VALUES(N'MWTF00000250243',N'Nov 24 2022 2:22PM',N'2022-11-24',4451.00,NULL,124105885.00,N'XUẤT KHO VẬT PHẨM QUÀ TẶNG THEO PHIẾU YÊU CẦU PHÒNG TT&TH NGÀY 22/08/2202',N'A',N'hoint',N'Nov 24 2022 2:22PM',N'chittn',N'Nov 28 2022 2:40PM',N'U',NULL,NULL,NULL,NULL,N'1',NULL,N'DV0001',N'DEP000000000014',N'',N'DV0001',N'HC',N'069HCDC221124005',NULL)
2

    
3
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265939',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000822',N'DEP000000000591',150.00,4328.00,27300.00,4095000.00,N'',N'866000004')
4
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265940',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000435',N'DEP000000000524',210.00,4178.00,27300.00,5733000.00,N'',N'866000004')
5
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265941',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000433',N'DEP000000000510',50.00,3968.00,27300.00,1365000.00,N'',N'866000004')
6
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265942',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000392',N'DEP000000000128',550.00,3918.00,27300.00,15015000.00,N'',N'866000004')
7
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265943',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000393',N'DEP000000000140',100.00,3368.00,27300.00,2730000.00,N'',N'866000004')
8
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265944',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000389',N'DEP000000000092',250.00,3268.00,27300.00,6825000.00,N'',N'866000004')
9
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265945',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000432',N'DEP000000000498',100.00,3018.00,27300.00,2730000.00,N'',N'866000004')
10
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265946',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000823',N'DEP000000000598',60.00,2918.00,27300.00,1638000.00,N'',N'866000004')
11
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265947',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000251879',N'DEP000000252237',125.00,2858.00,27300.00,3412500.00,N'',N'866000004')
12
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265948',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000251889',N'DEP000000252414',50.00,2733.00,27300.00,1365000.00,N'',N'866000004')
13
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265949',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000396',N'DEP000000000176',500.00,2683.00,27300.00,13650000.00,N'',N'866000004')
14
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265950',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000251853',N'DEP000000252015',150.00,2183.00,27300.00,4095000.00,N'',N'866000004')
15
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265951',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000401',N'DEP000000000236',125.00,2033.00,27300.00,3412500.00,N'',N'866000004')
16
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265952',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000817',N'DEP000000000531',300.00,1908.00,27300.00,8190000.00,N'',N'866000004')
17
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265953',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000387',N'DEP000000000068',50.00,1608.00,27300.00,1365000.00,N'',N'866000004')
18
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265954',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000251878',N'DEP000000252229',150.00,1558.00,27300.00,4095000.00,N'',N'866000004')
19
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265955',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000406',N'DEP000000000296',50.00,1408.00,27300.00,1365000.00,N'',N'866000004')
20
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265956',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000408',N'DEP000000000320',175.00,1358.00,27300.00,4777500.00,N'',N'866000004')
21
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265957',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000001840',N'DEP000000251873',150.00,1183.00,27300.00,4095000.00,N'',N'866000004')
22
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265958',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000424',N'DEP000000000442',100.00,1033.00,27300.00,2730000.00,N'',N'866000004')
23
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265959',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000398',N'DEP000000000200',200.00,933.00,27300.00,5460000.00,N'',N'866000004')
24
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265960',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000251877',N'DEP000000252228',100.00,733.00,27300.00,2730000.00,N'',N'866000004')
25
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265961',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000405',N'DEP000000000284',150.00,633.00,27300.00,4095000.00,N'',N'866000004')
26
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265962',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000825',N'DEP000000000612',50.00,483.00,27300.00,1365000.00,N'',N'866000004')
27
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265963',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000395',N'DEP000000000164',100.00,433.00,27300.00,2730000.00,N'',N'866000004')
28
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265964',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000000400',N'DEP000000000224',200.00,333.00,27300.00,5460000.00,N'',N'866000004')
29
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265965',N'MWTF00000250243',N'MWMASTBAL256800',N'DV0001',N'DEP000000000014',N'MWPRICE00251773',N'BRN000000251876',N'DEP000000252220',100.00,133.00,27300.00,2730000.00,N'',N'866000004')
30
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265966',N'MWTF00000250243',N'MWMASTBAL000317',N'DV0001',N'DEP000000000014',N'MWPRICE00000317',N'BRN000000000397',N'DEP000000000188',50.00,55.00,30454.00,1522700.00,N'',N'866000004')
31
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265967',N'MWTF00000250243',N'MWMASTBAL000289',N'DV0001',N'DEP000000000014',N'MWPRICE00000289',N'BRN000000001839',N'DEP000000251934',94.00,94.00,33757.00,3173158.00,N'',N'866000004')
32
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265968',N'MWTF00000250243',N'MWMASTBAL000317',N'DV0001',N'DEP000000000014',N'MWPRICE00000317',N'BRN000000001839',N'DEP000000251934',5.00,5.00,30454.00,152270.00,N'',N'866000004')
33
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265969',N'MWTF00000250243',N'MWMASTBAL000310',N'DV0001',N'DEP000000000014',N'MWPRICE00000310',N'BRN000000001839',N'DEP000000251934',1.00,1.00,37557.00,37557.00,N'',N'866000004')
34
INSERT INTO [MW_TRANSFER_DT] ([TRANSFER_DT_ID],[TRANSFER_ID],[MAST_BAL_ID],[FR_BRN_ID],[FR_DEPT_ID],[FR_PRICE_ID],[TO_BRN_ID],[TO_DEPT_ID],[QTY],[QTY_OLD],[PRICE],[TOTAL_AMT],[NOTES],[COST_ACC])VALUES(N'MWTDT0000265970',N'MWTF00000250243',N'MWMASTBAL256774',N'DV0001',N'DEP000000000014',N'MWPRICE00251747',N'BRN000000000820',N'DEP000000000567',6.00,580.00,74000.00,444000.00,N'',N'866000004')