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')
|