Granite WMS/SQL/Accpac

PO/Purchase = Granite Receiving
select * from [dbo].[POPORH1] where PONumber = 'PO00000021' select [POPORL], [PONUMBER],VDCODE,VDNAME,[DESCRIPTIO],[PORTYPE] from [dbo].[POPORH1] where PONumber = 'PO00000021'

select * from [POPORL] where PORHSEQ = 18772

IC/Receipts = Granite Takeon
select * from ICREED where SEQUENCENO =''

select * from ICREEH where RECPNUMBER=''  

IC/Transfers = Granite Transfer/Move
select * from ICTRED where TRANFENSEQ=''

select * from ICTREH where DOCNUM=''  

IC/Items= Granite MasterItems
SELECT [ITEMNO], STOCKUNIT,  INACTIVE,  [DESC], [STOCKITEM], [FMTITEMNO], [CATEGORY] FROM [ICITEM] where [STOCKITEM] = 1

OE/Orders= Granite Picking
select * from OEORDH where ORDNUMBER = 'ORD001' select * from OEORDD where ORDUNIQ in ( select ORDUNIQ from OEORDH where ORDNUMBER = 'ORD000000001         ')

IC/History Transactions
SELECT       LOCATION, ITEMNO, TRANSDATE, [LINENO], CATEGORY, DOCNUM, QUANTITY, UNIT FROM           dbo.ICHIST WITH (INDEX (ICHIST_KEY_0))