Show Menu
Cheatography

Report Format Tips Cheat Sheet (DRAFT) by

Tips for formatting report queries

This is a draft cheat sheet. It is a work in progress and is not finished yet.

Table and Alias

Storer
s
SKU
sku
po
po
podetail
pod
receipt
r
receip­tdetail
rd
lot
l
lotxlocxid
lli
skuxloc
sl
lotatt­ribute
la
orders
o
orderd­etail
od
pickdetail
pd
dropid
d
dropid­detail
dd
loadhdr
ld
wave
w
wavedetail
wd
loc
loc
 

Rules for UNION in queries

For the Queries with union, use separate alias names for tables in the union. In second union all the alias should end with _01 ( ex: rd_01) and third union should end with _02 ( ex: rd_01) and so on
Before using an alias always do a search for that alias in the query for the existence and for getting the sequence contin­uation.

Rules for Inner Queries

For the inner queries, use the table alias name ending with 01 ( ex: rd01)
 

General Tips

Report ID should be added in the Report Design
Report ID, Descri­ption , Last edit who should be there in the begining of the query block

General Tips

Report ID should be added in the Report Design