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 |
receiptdetail |
rd |
lot |
l |
lotxlocxid |
lli |
skuxloc |
sl |
lotattribute |
la |
orders |
o |
orderdetail |
od |
pickdetail |
pd |
dropid |
d |
dropiddetail |
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 continuation.
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, Description , Last edit who should be there in the begining of the query block |
General Tips
Report ID should be added in the Report Design |
|