411 REFERENCE · Wikibooks
Granite WMS/SQL/Accpac
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
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))