Table: itemreceipt_expense
Generating CSV file, please wait...
Downloads can take up to a few minutes depending on the number of rows
| AutoId |
ITEMRECEIPT_InternalId |
custcol_scm_item_parent |
amount |
acct_key |
memo |
markreceived |
custcol_shopify_order_line_item |
orderline |
custcol_shipment_record_id |
custcol_wrm_claimitem |
orderdoc |
custcol_fin_dept |
custcol_hj_po_linenum |
custcol_scm_costcat_profile |
account |
custcol_dept_ord |
| 1 |
8027299 |
|
380.00 |
833 |
DHL Cost |
T |
|
6 |
|
|
7321558 |
Administrative |
|
|
833 |
|
| 2 |
8057443 |
|
-920.00 |
214 |
Discount |
T |
|
1 |
|
|
6592634 |
Manufacturing |
|
|
214 |
|
| 3 |
8065822 |
|
57.19 |
722 |
Shipping Cost |
T |
|
1 |
|
|
7987035 |
|
|
|
722 |
|
| 4 |
8066230 |
|
700.00 |
214 |
Inland Shipping Cost |
T |
|
5 |
|
|
4544263 |
Manufacturing |
|
|
214 |
|
| 5 |
8085788 |
|
700.00 |
214 |
Inland Shipping Cost |
T |
|
5 |
|
|
4544278 |
Manufacturing |
|
|
214 |
|
| 6 |
8177927 |
|
8.00 |
214 |
Shipping Charge |
T |
|
2 |
|
|
7970914 |
Manufacturing |
|
|
214 |
|
| 7 |
8221788 |
|
12.17 |
214 |
Tax |
T |
|
15 |
|
|
7885350 |
Manufacturing |
|
|
214 |
|
| 8 |
8251345 |
|
-1000.00 |
214 |
Discount |
T |
|
7 |
|
|
5900379 |
Manufacturing |
|
|
214 |
|
| 9 |
8279705 |
|
-960.00 |
214 |
Discount |
T |
|
7 |
|
|
5901105 |
Manufacturing |
|
|
214 |
|
| 10 |
8288678 |
|
-920.00 |
214 |
Discount |
T |
|
1 |
|
|
6592529 |
Manufacturing |
|
|
214 |
|
| 11 |
8290299 |
|
6200.00 |
831 |
Air Freight |
T |
|
13 |
|
|
7108850 |
Administrative |
|
|
831 |
|
| 12 |
8290406 |
|
2300.00 |
214 |
Air Shipping Cost |
T |
|
7 |
|
|
7108864 |
Manufacturing |
|
|
214 |
|
| 13 |
8294362 |
|
7.70 |
214 |
Tax for Shipping Labels |
T |
|
5 |
|
|
8155368 |
Manufacturing |
|
|
214 |
|
| 14 |
8294362 |
|
5.22 |
214 |
Tax for Toner and Drum |
T |
|
6 |
|
|
8155368 |
Manufacturing |
|
|
214 |
|
| 15 |
8294362 |
|
2.36 |
214 |
Tax for Broom |
T |
|
7 |
|
|
8155368 |
Manufacturing |
|
|
214 |
|
| 16 |
8294362 |
|
19.16 |
214 |
Tax for Office Supplies |
T |
|
8 |
|
|
8155368 |
Manufacturing |
|
|
214 |
|
| 17 |
8316420 |
|
-1000.00 |
214 |
Discount |
T |
|
7 |
|
|
5900377 |
Manufacturing |
|
|
214 |
|
| 18 |
8317874 |
|
-800.00 |
214 |
Discount |
T |
|
1 |
|
|
6593155 |
Manufacturing |
|
|
214 |
|
| 19 |
8338640 |
|
880.00 |
831 |
Freight Cost 200 pcs sub-keypad |
T |
|
7 |
|
|
7441680 |
Administrative |
|
|
831 |
|
| 20 |
8339854 |
|
-980.00 |
214 |
Discount |
T |
|
5 |
|
|
5901110 |
Manufacturing |
|
|
214 |
|
| 21 |
8358149 |
|
424.00 |
214 |
Trucking Fee |
T |
|
6 |
|
|
4790879 |
Manufacturing |
|
|
214 |
|
| 22 |
8360188 |
|
-920.00 |
214 |
Discount |
T |
|
1 |
|
|
6592640 |
Manufacturing |
|
|
214 |
|
| 23 |
8385936 |
|
17.99 |
214 |
One day shipping for N95 masks |
T |
|
18 |
|
|
7622585 |
Manufacturing |
|
|
214 |
|
| 24 |
8430190 |
|
-920.00 |
214 |
Discount |
T |
|
1 |
|
|
6593157 |
Manufacturing |
|
|
214 |
|
| 25 |
5930301 |
|
-127.00 |
214 |
Sample Deduction for New Control GS07M-30AROP |
T |
|
16 |
|
|
5171972 |
Manufacturing |
|
|
214 |
|
| 26 |
17732167 |
|
-7.80 |
214 |
5% Discount Promo (5OFFNOW) |
T |
|
2 |
|
|
17473239 |
Manufacturing |
|
|
214 |
|
| 27 |
17732167 |
|
5.00 |
214 |
Shipping |
T |
|
3 |
|
|
17473239 |
Manufacturing |
|
|
214 |
|
| 28 |
17752676 |
|
80.00 |
530 |
Extra Carton 10 PCS |
T |
|
1 |
|
|
10888484 |
Revenue |
|
|
530 |
|
| 29 |
17759406 |
|
8.00 |
214 |
1 BOX for SD-AZ07-01BN |
T |
|
4 |
|
|
10302824 |
Manufacturing |
|
|
214 |
|
| 30 |
17759406 |
|
56.00 |
214 |
7 BOXES for SD-AZ13-02BN |
T |
|
5 |
|
|
10302824 |
Manufacturing |
|
|
214 |
|
| 31 |
17759406 |
|
16.00 |
214 |
2 BOXES for SD-AZ17-01MB |
T |
|
6 |
|
|
10302824 |
Manufacturing |
|
|
214 |
|
| 32 |
17817647 |
|
56.00 |
530 |
Extra Carton SD-AZ13-02BN-T |
T |
|
1 |
|
|
10743580 |
Revenue |
|
|
530 |
|
| 33 |
17817647 |
|
32.00 |
530 |
Extra Carton SD-AZ13-02CH |
T |
|
2 |
|
|
10743580 |
Revenue |
|
|
530 |
|
| 34 |
17827606 |
|
32.87 |
830 |
Sales Tax |
T |
|
6 |
|
|
17691908 |
Finance |
|
|
830 |
|
| 35 |
17827606 |
|
24.43 |
830 |
Sales Tax - Samsung Phone |
T |
|
7 |
|
|
17691908 |
Finance |
|
|
830 |
|
| 36 |
17837000 |
|
90.00 |
530 |
Delivery Charge (Decking & Beams) |
T |
|
8 |
|
|
16737821 |
Revenue |
|
|
530 |
|
| 37 |
17837819 |
|
24.00 |
530 |
Extra Carton |
T |
|
2 |
|
|
9895105 |
Revenue |
|
|
530 |
|
| 38 |
17837824 |
|
20.00 |
530 |
Extra Carton |
T |
|
1 |
|
|
10762186 |
Revenue |
|
|
530 |
|
| 39 |
17841718 |
|
12.00 |
214 |
Shipping |
T |
|
1 |
|
|
17441582 |
Manufacturing |
|
|
214 |
|
| 40 |
17841718 |
|
2.80 |
830 |
Sales Tax |
T |
|
3 |
|
|
17441582 |
Finance |
|
|
830 |
|
| 41 |
17843360 |
|
13.99 |
830 |
Sales Tax |
T |
|
2 |
|
|
17515958 |
Finance |
|
|
830 |
|
| 42 |
17846194 |
|
169.75 |
830 |
Sales Tax |
T |
|
3 |
|
|
17759833 |
Finance |
|
|
830 |
|
| 43 |
17851010 |
|
7.26 |
830 |
Sales Tax |
T |
|
3 |
|
|
17759414 |
Finance |
|
|
830 |
|
| 44 |
17853922 |
|
-1040.00 |
214 |
Discount |
T |
|
1 |
|
|
11008397 |
Manufacturing |
|
|
214 |
|
| 45 |
17909002 |
|
-960.00 |
530 |
Discount:USD20*48SETS |
T |
|
1 |
|
|
15315582 |
Revenue |
|
|
530 |
|
| 46 |
17909003 |
|
-920.00 |
530 |
Discount:USD20*46SETS |
T |
|
1 |
|
|
15316307 |
Revenue |
|
|
530 |
|
| 47 |
17911574 |
|
60.00 |
530 |
Delivery Charge - 12ft Orange Beams |
T |
|
11 |
|
|
16737821 |
Revenue |
|
|
530 |
|
| 48 |
17914612 |
|
24.43 |
830 |
Sales Tax - Samsung Phone (Replacement phone) |
T |
|
9 |
|
|
17691908 |
Finance |
|
|
830 |
|
| 49 |
17915625 |
|
-920.00 |
530 |
Discount:USD20*46SETS |
T |
|
1 |
|
|
15316808 |
Revenue |
|
|
530 |
|
| 50 |
17919136 |
|
8.00 |
214 |
Shipping |
T |
|
1 |
|
|
17760044 |
Manufacturing |
|
|
214 |
|