use T22M001


DELETE FROM GREY_RETURN_ACCOUNT_TYPES
INSERT INTO GREY_RETURN_ACCOUNT_TYPES VALUES('GRTNA/C')
UPDATE GREY_PURCHASE_RETURN_GOODS_DETAIL SET PurRtnType='GRTNA/C'


DELETE FROM FINISHED_RETURN_ACCOUNT_TYPES
INSERT INTO FINISHED_RETURN_ACCOUNT_TYPES VALUES('FRTNA/C')
UPDATE FINISHED_PURCHASE_RETURN_GOODS_DETAIL SET PurRtnType='FRTNA/C'

SELECT * FROM FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL WHERE (LEN(BkSrNo) = 6) ORDER BY BkSrNo

SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo FROM MULTI_JOURNAL_ADDLESS_DETAIL INNER JOIN ACCOUNT_MASTER ON MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty = ACCOUNT_MASTER.AccCode INNER JOIN ACCOUNT_TYPES ON ACCOUNT_MASTER.AccType = ACCOUNT_TYPES.AccTypes WHERE (ACCOUNT_TYPES.FinalCrDr = 'INCOME') AND (ACCOUNT_TYPES.FinalApplicable = 'INCOME/EXPENSES')

SELECT GENERAL_PURCHASE.SrNo FROM GENERAL_PURCHASE INNER JOIN ACCOUNT_MASTER ON GENERAL_PURCHASE.PLAcc = ACCOUNT_MASTER.AccCode INNER JOIN ACCOUNT_TYPES ON ACCOUNT_MASTER.AccType = ACCOUNT_TYPES.AccTypes WHERE (ACCOUNT_TYPES.FinalType = 'BALANCE SHEET') AND (ACCOUNT_TYPES.FinalCrDr = 'ASSETS')