Notes

SELECT * FROM vCustomers WHERE CustomerID LIKE '%2776022%'

SELECT * FROM BillCustomer WHERE CustomerKey = 2008011107673 ORDER BY InvDate DESC

SELECT * FROM vCustomers WHERE CustomerInfID = 220923236085100000
SELECT * FROM CustomerInfo WHERE PKey = 170605000446800000

SELECT * FROM CustomerInfo WHERE BonusCardNumber = '9230419005'

SELECT * FROM NominLoyalty.NominLoyalty.dbo.WalletTransaction WITH(NOLOCK) WHERE TranReference=240329122809989488
SELECT * FROM NominLoyalty.NominLoyalty.dbo.WalletBalance WHERE AccountId = 119221213008
UPDATE NominLoyalty.NominLoyalty.dbo.WalletTransaction SET DtAmount=0 WHERE TranReference=240307131107642607
EXEC NominLoyalty.NominLoyalty.dbo.Calc_WalletBalance 119221213008

SELECT * FROM BillCustomer WHERE PKey = 230912105607349596

SELECT * FROM BillCustomerDivision WHERE HdrKey = 230912105607349596
SELECT * FROM BillCustomerDtl WHERE HdrKey = 230912105607349596
SELECT * FROM BillCustomerSale WHERE HdrKey = 230912105607349596

EXEC Check_VoucherForDiamond @Type = 'BillCustomer', @Key = 230912105607349596

EXEC DEL_ItemPurchaseVoucher @MapKey = 230912105607349596, @InvoiceType = 'BillCustomer', @IsOnlyVOucher = 'N'

UPDATE BillCustomer SEt BillStatus = 3, ImportId = null WHERE PKey = 230504100212327879

SELECT * FROM vSystems WHERE DBName = 'ZunjinDiamond'

EXEC KSERVER.ZUNJINDIAMOND.dbo.Finance_Invoice_Del 'Billing_230106180436130071'

--vendor
EXEC MOD_BillingVoucher @XML = N'<Root><Item><PKey>220927155840520554</PKey></Item></Root>'

--agent
EXEC MOD_BillingVoucher @XML = N'<Root><Item><PKey>230504100212327879</PKey></Item></Root>', @BillingType = 'Agent'

--renter
EXEC MOD_BillingVoucher @XML = N'<Root><Item><PKey>230504100212327879</PKey></Item></Root>', @BillingType = 'Renter'

SELECT * FROM vSystems WHERE DBName = 'BUSHMDiamond'
SELECT * FROM vSystems WHERE DBName = 'BUSSMDiamond'
SELECT * FROM vSystems WHERE DBName = 'NOMINCTDIAMOND'


SELECT * FROM JSERVER.BUSSMDIAMOND.dbo.ssMappingImport A
INNER JOIN JSERVER.BUSSMDIAMOND.dbo.ssGeneralLedgerDetail B ON A.MaprecId = B.MapRecId
WHERE A.ImportId = 'Billing_230504105955005477'

SELECT * FROM DIAMOND2.NOMINCTDIAMOND.dbo.ssMappingImport A
INNER JOIN DIAMOND2.NOMINCTDIAMOND.dbo.ssGeneralLedgerDetail B ON A.MaprecId = B.MapRecId
WHERE A.ImportId = 'Billing_230504105955005477'

UPDATE BillCustomer SET IsDeleted = 1 WHERE PKey = 230912105607349596
UPDATE BillCustomerDtl SET IsDeleted = 1 WHERE HdrKey = 230912105607349596
UPDATE BillCustomerSale SET IsDeleted = 1 WHERE HdrKey = 230912105607349596
--UPDATE BillCustomerInventory SET IsDeleted = 1 WHERE HdrKey = 230106180436130071
UPDATE BillCustomerState SET IsDeleted = 1 WHERE HdrKey = 230912105607349596
UPDATE BillCustomerFile SET IsDeleted = 1 WHERE HdrKey = 230912105607349596

SELECT dbo.ConvertPassword(Password), * FROM VIEW_User WHERE LoginName = 'bm12407'

SELECT * FROM nmnDivisions WHERE Name LIKE N'%Зуунмод%'

SELECT * FROM BillCustomer A
INNER JOIN BillCustomerDivision B ON A.PKey = B.HdrKey
WHERE A.InvDate = '2023-05-11' AND B.BonusAmount = '6457.94'

SELECT dbo.ConvertPassword(Password),8 FROM VIEW_User WHERE LoginName = 'userAdmin'

SELECT * FROM IdentityManagement..RoleMenu WHERE RoleId = 'MobileAdmin'
--------------------------------Haalt ustgah p2---------------------
SELECT * FROM vCustomers WHERE CustomerID LIKE '%6709958%'

SELECT * FROM BillCustomer WHERE CustomerKey = 220111875045500000 ORDER BY InvDate DESC

SELECT * FROM vCustomers WHERE CustomerInfID = 220923236085100000
SELECT * FROM CustomerInfo WHERE PKey = 210807677282000000

SELECT * FROM CustomerInfo WHERE BonusCardNumber = '9230419005'

SELECT * FROM BillCustomer WHERE PKey = 230929094736973293

SELECT * FROM BillCustomerDivision WHERE HdrKey = 230929094736973293
SELECT * FROM BillCustomerDtl WHERE HdrKey = 230929094736973293
SELECT * FROM BillCustomerSale WHERE HdrKey = 230929094736973293

EXEC Check_VoucherForDiamond @Type = 'BillCustomer', @Key = 230929144731942980

EXEC DEL_ItemPurchaseVoucher @MapKey = 230929144731942980, @InvoiceType = 'BillCustomer', @IsOnlyVOucher = 'N'

UPDATE BillCustomer SEt BillStatus = 3, ImportId = null WHERE PKey = 230504100212327879

SELECT * FROM vSystems WHERE DBName = 'ZunjinDiamond'

EXEC KSERVER.ZUNJINDIAMOND.dbo.Finance_Invoice_Del 'Billing_230106180436130071'

--vendor
EXEC MOD_BillingVoucher @XML = N'<Root><Item><PKey>220927155840520554</PKey></Item></Root>'

--agent
EXEC MOD_BillingVoucher @XML = N'<Root><Item><PKey>230504100212327879</PKey></Item></Root>', @BillingType = 'Agent'

--renter
EXEC MOD_BillingVoucher @XML = N'<Root><Item><PKey>230504100212327879</PKey></Item></Root>', @BillingType = 'Renter'

SELECT * FROM vSystems WHERE DBName = 'BUSHMDiamond'
SELECT * FROM vSystems WHERE DBName = 'BUSSMDiamond'
SELECT * FROM vSystems WHERE DBName = 'NOMINCTDIAMOND'


SELECT * FROM JSERVER.BUSSMDIAMOND.dbo.ssMappingImport A
INNER JOIN JSERVER.BUSSMDIAMOND.dbo.ssGeneralLedgerDetail B ON A.MaprecId = B.MapRecId
WHERE A.ImportId = 'Billing_230504105955005477'

SELECT * FROM DIAMOND2.NOMINCTDIAMOND.dbo.ssMappingImport A
INNER JOIN DIAMOND2.NOMINCTDIAMOND.dbo.ssGeneralLedgerDetail B ON A.MaprecId = B.MapRecId
WHERE A.ImportId = 'Billing_230504105955005477'

UPDATE BillCustomer SET IsDeleted = 1 WHERE PKey = 230929094736973293
UPDATE BillCustomerDtl SET IsDeleted = 1 WHERE HdrKey = 230929094736973293
UPDATE BillCustomerSale SET IsDeleted = 1 WHERE HdrKey = 230929094736973293
--UPDATE BillCustomerInventory SET IsDeleted = 1 WHERE HdrKey = 230106180436130071
UPDATE BillCustomerState SET IsDeleted = 1 WHERE HdrKey = 230929094736973293
UPDATE BillCustomerFile SET IsDeleted = 1 WHERE HdrKey = 230929094736973293

SELECT dbo.ConvertPassword(Password), * FROM VIEW_User WHERE LoginName = 'useradmin'

SELECT * FROM nmnDivisions WHERE Name LIKE N'%Зуунмод%'

SELECT * FROM BillCustomer A
INNER JOIN BillCustomerDivision B ON A.PKey = B.HdrKey
WHERE A.InvDate = '2023-05-11' AND B.BonusAmount = '6457.94'

SELECT dbo.ConvertPassword(Password),8 FROM VIEW_User WHERE LoginName = 'userAdmin'
SELECT * FROM IdentityManagement..RoleMenu WHERE RoleId = 'MobileAdmin'

select top 1 * from vCustomers where CustomerID = '5167647-39-1'
select top 1 * from CustomerInfo where PKey = 221102380379900001

select * from Item where Id = '06411852430'
select * from ItemBarCode where Id = '6971536925119'
select * from nmnItems where id = 'sac0013060001'

--Update Item set Status = 9 where PKey = 230911132206011353
--update Item set Id = '03ZH-S232-9', SKU = '03ZH-S232-9' where PKey = 230810153219141964

select * from Item where VendorKey = 201607200000000010
select * from ItemState where ItemKey = 230815173603993303

--bse_tableInfo 'Item'

select top 100 * from Item with(nolock) where Status = 5
select * from nmnBrand where PKey = 210617615448600001
select * from ItemDetailInfo where PKey = 160912710844801234


select top 1 * from vCustomers where CustomerID = N'Шж53051718'