Granite WMS/SQL/Accpac

From Wikibooks, open books for an open world
< Granite WMS‎ | SQL
Jump to navigation Jump to search

PO/Purchase = Granite Receiving[edit]

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[edit]

select * from ICREED where SEQUENCENO =''

select * from ICREEH where RECPNUMBER=''

IC/Transfers = Granite Transfer/Move[edit]

select * from ICTRED where TRANFENSEQ=''

select * from ICTREH where DOCNUM=''

IC/Items= Granite MasterItems[edit]

 SELECT  [ITEMNO], STOCKUNIT,  INACTIVE,  [DESC], [STOCKITEM],
     [FMTITEMNO],  [CATEGORY]
    FROM [ICITEM] where [STOCKITEM] = 1

OE/Orders= Granite Picking[edit]

select * from OEORDH where ORDNUMBER = 'ORD001'
select * from OEORDD where ORDUNIQ in (
select ORDUNIQ from OEORDH where ORDNUMBER = 'ORD000000001          ')


IC/History Transactions[edit]

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