--IV00101 – Item Master
--IV00102 – Item Quantity Master
--IV00103 – Item Vendor Master
--IV00107 – Item Price List Options
--IV00108 – Item Price List
--IV00118 – Item Cost Change History
--IV10000 – Unposted/Work Transactions (header)
--IV10001 – Unposted/Work Transactions (line detail)
--IV30200 – Transaction History (header)
--IV30300 – Transaction Amounts History (line detail)
--IV30301 – Transaction Amounts Detail History
delete from IV00101
Go
truncate table IV00101
Go
delete from IV00102
Go
truncate table IV00102
Go
delete from IV00103
Go
truncate table IV00103
Go
delete from IV00107
Go
truncate table IV00107
Go
delete from IV00108
Go
truncate table IV00108
Go
delete from IV00118
Go
truncate table IV00118
Go
delete from IV10000
Go
truncate table IV10000
Go
delete from IV10001
Go
truncate table IV10001
Go
delete from IV30200
Go
truncate table IV30200
Go
delete from IV30300
Go
truncate table IV30300
Go
delete from IV30301
Go
truncate table IV30301
Go
 





Leave a Reply.