| Table Transformer |
|---|
| dateFormat | m/d/yy |
|---|
| export-word | false |
|---|
| show-source | false |
|---|
| export-csv | false |
|---|
| id | 1554112767935_676640147 |
|---|
| worklog | 5|8|w d h m|w d h m |
|---|
| separator | . |
|---|
| export-pdf | false |
|---|
| sql | SELECT *, CASE WHEN 'Subtotal' < 1000 THEN "LOW" WHEN 'Subtotal' >= 1000 AND 'Subtotal' < 2000 THEN "MEDIUM" ELSE "HIGH" END AS 'Priority' FROM T1 |
|---|
|
|
| Column |
|---|
|
Source tables: | | Table Excerpt |
|---|
|
|
| Order date | Store | Items | Subtotal |
|---|
| 6/30/ |
| 2020 | Store #3 | Date stamp | $1040.00 |
| 6 |
Store #1 | Printing of envelope A-4 size brown | $2,604.00 | 6/2018| 2020 | Store #1 | Date stamp | $784.00 |
| 6/28/ |
Store #1 | Rubber band (medium and small size) | $280.00 | 6/28/2018| 2020 | Store #2 | Plastic folder with visiting card holding sheet | $2,619.00 |
| 6/27/ |
Store #1 | ID card holder | $420.00 | | 6/27/2018 | Store #3 | File folder A to Z and 1 to 31 | $624.00 |
| 6/27/2018 | Store #1 | File separator A-4 size | $705.00 |
| 6/27/2018 | Store #1 | Rubber band (big size) | $1,656.00 |
| 6/27/2018 | Store #1 | Acknowledgement book | $3,000.00 |
6/27/2018 | Store 6/26/2018 | Store #3 | | #3 | ID card holder | $3,128.00 |
| 6/26/ |
Store #1 | Stapler 10-D | $686.00 | | 6/26/2018 | Store #3 | Office file with clip | $688.00 |
| 6/26/2018 | Store #3 | Plastic folder with hole- A4 size | $732.00 |
| 6/26/2018 | Store #3 | Meeting writing pad | $735.00 |
| 6/26/2018 | Store #2 | Brown paper sheet | $1,024.00 |
| Letter opener | $3,792.00 |
| 6/25/ |
| 2020 | Store #2 | Notice board size 3x2fit & 5x3fit | $320 |
6/25/2018 | Store #2 | Writing pad A4 size line | $3782018| 2020 | Store #3 | Scissors (big) | $78.00 |
| 6/24/ |
Store #3 | Punching machine 520 | $484.00 | | 6/24/2018 | Store #2 | Visiting card holder | $1,168.00 |
6/24/2018 | Store #2 | | 2020 | Store #2 | File separator A-4 size | $2,254.00 |
| 6/23/ |
Store #1 | File folder A to Z and 1 to 31 | $105.00 | | 6/23/2018 | Store #3 | Desk calculator | $308.00 |
| 6/23/2018 | Store #2 | Thin A4 size paper folder | $310.00 |
| 6/23/2018 | Store #2 | Office tray ( in & out ) | $567.00 |
| 6/23/2018 | Store #2 | Eraser | $777.00 |
| 6/23/2018 | Store #3 | Writing pad - A5 size line | $1,444.00 |
6/23/2018| 2020 | Store #2 | Stapler 10-D | $1,472.00 |
| 6/22/ |
| 6/22/2018 | Store #1 | Office file with clip | $696.00 |
| 6/22/2018 | Store #2 | Punching machine 520 | $2,125.00 |
6/22/2018 | Store #2 | Calculator paper roll | $484.00 | | Acknowledgement book | $3,520.00 |
| 6/21/ |
Store #1 | Writing pad - A5 size line | $703.00 | | 6/21/2018 | Store #2 | Non dust chalk | $775.00 |
| 6/21/2018 | Store #1 | Thin A4 size paper folder | $968.00 |
| 6/21/2018 | Store #2 | ID card holder | $1,798.00 |
6/21/2018 | Store | #3 | File separator A-4 size | $3,441.00 |
| 6/20/ |
Store #3 | Office tray ( in & out ) | $510.00 | | 6/20/2018 | Store #3 | Printing of envelope A-4 size brown | $1,372.00 |
| 6/20/2018 | Store #1 | Plastic folder with visiting card holding sheet | $1,886.00 |
| 6/20/2018 | Store #1 | Gate pass book | $2,214.00 |
| 6/20/2018 | Store #2 | Stamp pad ink | $2,400.00 |
6/20/2018 | Store | #1 | A4 size plastic file | $3,762.00 |
| 6/19/ |
Store #2 | Pencil | $432.00 | | 6/19/2018 | Store #3 | Scale 30 cm & 12 cm | $1,300.00 |
| 6/19/2018 | Store #2 | Binder clips 41mm,32mm,19mm, 51mm | $2,450.00 |
| 6/19/2018 | Store #1 | Notice board size 3x2fit & 5x3fit | $2,475.00 |
6/19/2018 | Store | #2 | A4 size plastic file | $3,526.00 |
| 6/18/ |
Store #3 | Key ring | $198.00 | | 6/18/2018 | Store #1 | Visiting card holder | $448.00 |
| 6/18/2018 | Store #3 | Writing pad A4 size line | $481.00 |
| 6/18/2018 | Store #3 | Acknowledgement book | $646.00 |
| 6/18/2018 | Store #2 | Writing pad - A5 size line | $873.00 |
| 6/18/2018 | Store #2 | Bubble sheet | $884.00 |
| 6/18/2018 | Store #3 | Binder clips 41mm,32mm,19mm, 51mm | $1,128.00 |
6/18/2018 | Store #2 | | 2020 | Store #2 | Date stamp | $3,078.00 |
| 6/ |
Store #2 | Gel pen | $3,608.00 | | 6/17/2018 | Store #2 | File folder A to Z and 1 to 31 | $598.00 |
| 6/17/2018 | Store #2 | Meeting writing pad | $984.00 |
| 6/17/2018 | Store #1 | Calculator paper roll | $1,392.00 |
| 6/17/2018 | Store #2 | Paper cutter stand | $3,139.00 |
6/17/2018 | Store #1 | 2018Store #2 | Letter opener | $1,107.00 | | 6/16/2018 | Store #3 | A4 size plastic file | $1,470.00 |
| 6/15/2018 | Store #1 | Highlighter (yellow,green,orange) | $912.00 |
6/15/2018 | Store | #3 | Magnetic white board duster | $1,035.00 |
| 6/15/ |
Store #1 | Binder clips 41mm,32mm,19mm, 51mm | $1,053.00 | | 6/15/2018 | Store #1 | Scissors (big) | $1,316.00 |
| 6/15/2018 | Store #3 | Bubble sheet | $1,760.00 |
| 6/15/2018 | Store #2 | Rubber band (big size) | $2,520.00 |
6/15/2018 | Store #2 | | Desk calculator | $2,964.00 |
| 6/14/ |
Store #2 | Rubber band (medium and small size) | $495.00 | | 6/14/2018 | Store #3 | Paper cutter stand | $806.00 |
6/14/2018 | Store | #1 | Letter opener | $3,045.00 |
| 6/13/ |
Store #3 | Stapler 10-D | $1,440.00 | | 6/13/2018 | Store #3 | Notice board size 3x2fit & 5x3fit | $1,533.00 |
6/13/2018 | Store | #2 | Magnetic white board duster | $1,581.00 |
| 6/12/ |
| 2020 | Store #3 | Visiting card holder | $874 |
6/12/2018 | Store #1 | Meeting writing pad | $1,16112/2018Store #1 | Punching machine 520 | $3,150.00 | 6/2018| 2020 | Store #2 | Printing of envelope A-4 size brown | $182.00 |
| 6/11/ |
Store #1 | Desk calculator | $364.00 | | 6/11/2018 | Store #3 | Library box | $1,440.00 |
| 6/11/2018 | Store #3 | Stamp pad ink | $1,470.00 |
| 6/11/2018 | Store #3 | Highlighter (yellow,green,orange) | $1,920.00 |
| 6/11/2018 | Store #2 | Scale 30 cm & 12 cm | $2,052.00 |
| 6/11/2018 | Store #3 | Gate pass book | $3,492.00 |
6/11/2018| 2020 | Store #1 | Office tray ( in & out ) | $5,000.00 |
| 6/10/ |
Gel pen | $140.00 | | 6/10/2018 | Store #2 | Library box | $770.00 |
| 6/10/2018 | Store #3 | Calculator paper roll | $1,036.00 |
| 6/10/2018 | Store #1 | Non dust chalk | $1,892.00 |
6/10/2018 | Store #3 | | Brown paper sheet | $2,976.00 |
| 6/9/ |
Store #3 | Cello tape 1" | $160.00 | | 6/9/2018 | Store #1 | Library box | $450.00 |
| 6/9/2018 | Store #3 | Plastic folder with visiting card holding sheet | $774.00 |
| 6/9/2018 | Store #2 | Key ring | $1,080.00 |
6/9/20186/9/2018 | Store #1 | Stamp pad ink | $2,300.00 | | Bubble sheet | $3,589.00 |
| 6/8/ |
Store #3 | Thin A4 size paper folder | $352.00 | | 6/8/2018 | Store #3 | Eraser | $760.00 |
| 6/8/2018 | Store #1 | Pencil | $833.00 |
| 6/8/2018 | Store #1 | Scale 30 cm & 12 cm | $1,681.00 |
6/8/2018 | Store | #2 | Cello tape 1" | $2,160.00 |
| 6/7/ |
| 2020 | Store #3 | Non dust chalk | $3,772.00 |
| 6/6/ |
| 2020 | Store #1 | Eraser | $1,176.00 |
| 6/5/ |
| 2020 | Store #1 | Key ring | $495.00 |
| 6/5/ |
| 2020 | Store #2 | Highlighter (yellow,green,orange) | $2,726.00 |
| 6/4/ |
| 2020 | Store #1 | Brown paper sheet | $280 |
| 6/4/2018 | Store #2 | Plastic folder with hole- A4 size | $744.00 |
6/4/2018 | Store #1 | Plastic folder with hole- A4 size | $1,3202018| 2020 | Store #1 | Cello tape 1" | $980.00 |
| 6/3/ |
| 2020 | Store #2 | Scissors (big) | $2,278.00 |
| 6/2/ |
| 2020 | Store #3 | Tape dispenser | $264.00 |
| 6/2/ |
| 2020 | Store #3 | Printing of invitation cards | $561.00 |
| 6/2/ |
| 2020 | Store #1 | Post it 2 x 3 | $600.00 |
| 6/2/ |
| 2020 | Store #2 | A4 size writing pad spiral | $624.00 |
| 6/2/ |
Store #2 | Gate pass book | $630.00 | | 6/2/2018 | Store #2 | Stapler HD-45 | $726.00 |
| 6/2/2018 | Store #3 | Rubber band (big size) | $880.00 |
| 6/2/2018 | Store #1 | Correction tape | $1,400.00 |
| 6/2/2018 | Store #3 | Printing of envelope cloth lined brown | $1,428.00 |
| 6/2/2018 | Store #2 | Thick A4 size paper folder | $1,575.00 |
| 6/2/2018 | Store #1 | Printing of invitation cards | $1,675.00 |
6/2/2018 | Store #3 | | 2020 | Store #3 | Plastic folder A4 size- | $1,740.00 |
| 6/2/ |
| 2020 | Store #3 | Sticker Sign here | $4,150.00 |
| 6/1/ |
| 6/1/2018 | Store #2 | Printing of envelope A-5 size brown | $425.00 |
| 6/1/2018 | Store #3 | Rubber band (medium and small size) | $648.00 |
| 6/1/2018 | Store #2 | Office file with clip | $684.00 |
| 6/1/2018 | Store #3 | Flip chart | $851.00 |
| 6/1/2018 | Store #1 | Stapler pins 10 | $968.00 |
| 6/1/2018 | Store #3 | Separators/dividers | $1,200.00 |
| 6/1/2018 | Store #1 | Magnetic white board duster | $1,200.00 |
| 6/1/2018 | Store #2 | White board marker | $1,560.00 |
6/1/2018 | Store #1 | Writing pad A4 size line | $156.00 | | Paper cutter stand | $1,825.00 |
