Pending Sales Order
SALES_ORDEr_PENDING
| COMPANYNAME | referencedate | reference | stockitemname | partyledgername | ORDEREDQTY | balance_qty | batchrate | batchdiscount | pending_value | orderduedate | pendency_age | total_sales_quantity | total_delivery_quantity | LEVEL_1 | LEVEL_2 | LEVEL_3 | LEVEL_4 | LEVEL_5 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Sample-2 - (from 1-Jan-2019) | 1-Aug-2019 | 3 | BAGS UNIT 2 | Sales_ledger | 6.00 | -4.00 | 567 | 0 | -2,268.00 | 2019-08-01 | 2,049.00 | -10.00 | 0.00 | Sundry Debtors | Sales_ledger | None | None | None |
| 1 | Sample-2 - (from 1-Jan-2019) | 1-Jul-2019 | 3 | BAGS UNIT 2 | Sales_ledger | 15.00 | 5.00 | 567 | 0 | 2,835.00 | 2019-07-01 | 2,080.00 | -10.00 | 0.00 | Sundry Debtors | Sales_ledger | None | None | None |
| 2 | Sample-2 - (from 1-Jan-2019) | 1-Aug-2019 | 3 | BAGS UNIT 2 | Sales_ledger | 6.00 | 3.00 | 567 | 0 | 1,701.00 | 2019-08-01 | 2,049.00 | -3.00 | 0.00 | Sundry Debtors | Sales_ledger | None | None | None |
| 3 | Sample-2 - (from 1-Jan-2019) | 1-Jul-2019 | 3 | BAGS UNIT 2 | Sales_ledger | 15.00 | 12.00 | 567 | 0 | 6,804.00 | 2019-07-01 | 2,080.00 | -3.00 | 0.00 | Sundry Debtors | Sales_ledger | None | None | None |
| 4 | Sample-2 - (from 1-Jan-2019) | 2-May-2019 | 1 | Stock Group 3 Child 1 Item Wogst | Sales_ledger | 34.00 | 34.00 | 67 | 0 | 2,278.00 | 2019-05-02 | 2,140.00 | Sundry Debtors | Sales_ledger | None | None | None | ||
| 5 | Sample-2 - (from 1-Jan-2019) | 1-Aug-2019 | 2 | CHINESE UNDER 50000 _1 | Sales_ledger | 2.00 | 2.00 | 4 | 1 | 8.00 | 2019-08-01 | 2,049.00 | Sundry Debtors | Sales_ledger | None | None | None | ||
| 6 | Sample-2 - (from 1-Jan-2019) | 1-Jul-2019 | 5 | BAGS UNIT 2 | Sales_ledger | 14.00 | 14.00 | 567 | 0 | 7,938.00 | 2019-07-01 | 2,080.00 | 0.00 | 0.00 | Sundry Debtors | Sales_ledger | None | None | None |
| 7 | Sample-2 - (from 1-Jan-2019) | 1-Jul-2019 | 9 | STOCK_ITEM_LAYER_1 | Sales_ledger | 6.00 | 6.00 | 98 | 0 | 588.00 | 2019-07-01 | 2,080.00 | 0.00 | 0.00 | Sundry Debtors | Sales_ledger | None | None | None |
| 8 | Sample-2 - (from 1-Jan-2019) | 1-Jul-2019 | 2 | CHINESE UNDER 50000 _1 | Sales_ledger | 3.00 | 3.00 | 4 | 1 | 12.00 | 2019-07-01 | 2,080.00 | Sundry Debtors | Sales_ledger | None | None | None | ||
| 9 | Sample-2 - (from 1-Jan-2019) | 1-Jul-2019 | 9 | STOCK_ITEM_LAYER_1 | Sales_ledger | 6.00 | 6.00 | 98 | 0 | 588.00 | 2019-07-01 | 2,080.00 | Sundry Debtors | Sales_ledger | None | None | None | ||
| 10 | Sample-2 - (from 1-Jan-2019) | 1-Jul-2019 | 5 | BAGS UNIT 2 | Sales_ledger | 14.00 | 14.00 | 567 | 0 | 7,938.00 | 2019-07-01 | 2,080.00 | Sundry Debtors | Sales_ledger | None | None | None | ||
| 11 | Sample-2 - (from 1-Jan-2019) | 2-May-2019 | 1 | Stock Group 3 Child 1 Item Wogst | Sales_ledger | 34.00 | 34.00 | 67 | 0 | 2,278.00 | 2019-05-02 | 2,140.00 | 0.00 | 0.00 | Sundry Debtors | Sales_ledger | None | None | None |
| 12 | Sample-2 - (from 1-Jan-2019) | 1-Aug-2019 | 2 | CHINESE UNDER 50000 _1 | Sales_ledger | 2.00 | 2.00 | 4 | 1 | 8.00 | 2019-08-01 | 2,049.00 | 0.00 | 0.00 | Sundry Debtors | Sales_ledger | None | None | None |
| 13 | Sample-2 - (from 1-Jan-2019) | 1-Jul-2019 | 2 | CHINESE UNDER 50000 _1 | Sales_ledger | 3.00 | 3.00 | 4 | 1 | 12.00 | 2019-07-01 | 2,080.00 | 0.00 | 0.00 | Sundry Debtors | Sales_ledger | None | None | None |
| 14 | Sample-2 | 1-Aug-2019 | 3 | BAGS UNIT 2 | Sales_ledger | 6.00 | -14.00 | 567 | 0 | -7,938.00 | 2019-08-01 | 2,049.00 | -20.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 15 | Sample-2 | 1-Jul-2019 | 3 | BAGS UNIT 2 | Sales_ledger | 15.00 | -5.00 | 567 | 0 | -2,835.00 | 2019-07-01 | 2,080.00 | -20.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 16 | Sample-2 | 1-Aug-2019 | 3 | BAGS UNIT 2 | Sales_ledger | 6.00 | 0.00 | 567 | 0 | 0.00 | 2019-08-01 | 2,049.00 | -6.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 17 | Sample-2 | 1-Jul-2019 | 3 | BAGS UNIT 2 | Sales_ledger | 15.00 | 9.00 | 567 | 0 | 5,103.00 | 2019-07-01 | 2,080.00 | -6.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 18 | Sample-2 | 1-Aug-2019 | 2 | CHINESE UNDER 50000 _1 | Sales_ledger | 2.00 | 0.00 | 4 | 1 | 0.00 | 2019-08-01 | 2,049.00 | -2.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 19 | Sample-2 | 1-Jul-2019 | 2 | CHINESE UNDER 50000 _1 | Sales_ledger | 3.00 | 1.00 | 4 | 1 | 4.00 | 2019-07-01 | 2,080.00 | -2.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 20 | Sample-2 | 1-Dec-2022 | 12 | Sample_item_1 | Sales_ledger | 145.00 | 145.00 | 1040 | 0 | 150,800.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 21 | Sample-2 | 1-Dec-2022 | 12 | Sample_item_1 | Sales_ledger | 145.00 | 145.00 | 1040 | 0 | 150,800.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 22 | Sample-2 | 1-Dec-2022 | 12 | Sample_item_1 | Sales_ledger | 89.00 | 89.00 | 76 | 0 | 6,764.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 23 | Sample-2 | 1-Dec-2022 | 12 | Sample_item_1 | Sales_ledger | 89.00 | 89.00 | 76 | 0 | 6,764.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 24 | Sample-2 | 1-Jul-2019 | 5 | BAGS UNIT 2 | Sales_ledger | 14.00 | 14.00 | 567 | 0 | 7,938.00 | 2019-07-01 | 2,080.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 25 | Sample-2 | 1-Jul-2019 | 9 | STOCK_ITEM_LAYER_1 | Sales_ledger | 6.00 | 6.00 | 98 | 0 | 588.00 | 2019-07-01 | 2,080.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 26 | Sample-2 | 1-Dec-2022 | 12 | Sample_item_1 | Sales_ledger | 89.00 | 89.00 | 76 | 0 | 6,764.00 | 2022-12-01 | 831.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None | ||
| 27 | Sample-2 | 2-May-2019 | 1 | Stock Group 3 Child 1 Item Wogst | Sales_ledger | 34.00 | 34.00 | 67 | 0 | 2,278.00 | 2019-05-02 | 2,140.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 28 | Sample-2 | 1-Dec-2022 | 12 | Master_item | Sales_ledger | 89.00 | 89.00 | 67 | 0 | 5,963.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 29 | Sample-2 | 1-Dec-2022 | 12 | Master_item | Sales_ledger | 89.00 | 89.00 | 67 | 0 | 5,963.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 30 | Sample-2 | 1-Dec-2022 | 12 | Master_item | Sales_ledger | 89.00 | 89.00 | 76 | 0 | 6,764.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 31 | Sample-2 | 1-Dec-2022 | 12 | Master_item | Sales_ledger | 89.00 | 89.00 | 76 | 0 | 6,764.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 32 | Sample-2 | 1-Jul-2019 | 9 | STOCK_ITEM_LAYER_1 | Sales_ledger | 6.00 | 6.00 | 98 | 0 | 588.00 | 2019-07-01 | 2,080.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None | ||
| 33 | Sample-2 | 1-Jul-2019 | 5 | BAGS UNIT 2 | Sales_ledger | 14.00 | 14.00 | 567 | 0 | 7,938.00 | 2019-07-01 | 2,080.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None | ||
| 34 | Sample-2 | 2-May-2019 | 1 | Stock Group 3 Child 1 Item Wogst | Sales_ledger | 34.00 | 34.00 | 67 | 0 | 2,278.00 | 2019-05-02 | 2,140.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None | ||
| 35 | Sample-2 | 1-Dec-2022 | 12 | Master_item | Sales_ledger | 89.00 | 89.00 | 67 | 0 | 5,963.00 | 2022-12-01 | 831.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None | ||
| 36 | Sample-2 | 1-Dec-2022 | 12 | Master_item | Sales_ledger | 89.00 | 89.00 | 76 | 0 | 6,764.00 | 2022-12-01 | 831.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None | ||
| 37 | Sample-2 | 1-Dec-2022 | 12 | Sample_item_1 | Sales_ledger | 145.00 | 145.00 | 1040 | 0 | 150,800.00 | 2022-12-01 | 831.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None | ||
| 38 | Sample-2 - (from 1-Jan-2021) | 1-Dec-2022 | 12 | Master_item | Sales_ledger | 89.00 | -89.00 | 67 | 0 | -5,963.00 | 2022-12-01 | 831.00 | -178.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 39 | Sample-2 - (from 1-Jan-2021) | 1-Dec-2022 | 12 | Sample_item_1 | Sales_ledger | 56.00 | 56.00 | 1040 | 0 | 58,240.00 | 2022-12-01 | 831.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None | ||
| 40 | Sample-2 - (from 1-Jan-2021) | 1-Dec-2022 | 12 | Master_item | Sales_ledger | 89.00 | 89.00 | 67 | 0 | 5,963.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |
| 41 | Sample-2 - (from 1-Jan-2021) | 1-Dec-2022 | 12 | Sample_item_1 | Sales_ledger | 56.00 | 56.00 | 1040 | 0 | 58,240.00 | 2022-12-01 | 831.00 | 0.00 | 0.00 | Primary | Current Assets | Sundry Debtors | Sales_ledger | None |