stockbase.counting

Add record
Orders to count a package. The from_package is the package to be counted, the to_package is the package to overload into. Equal when it is the same. record_created_by_user_uuid is the one ordering the count. The to_package stores who was the counter and at what moment the counting took place. supply holds the results. The start_ts and end_ts indicate whether the count is ready to be executed.

118f8bdc-7a26-4c08-8d16-d85a7aaacee1

ce687d7f-65f2-442d-bf31-44be6a26f6f2 ce687d7f-65f2-442d-bf31-44be6a26f6f2

 2015-05-06T09:09:43+00:00 2015-05-06T09:20:19+00:00 2015-05-06T09:09:43+00:00 3C06A9F4-20CF-482D-B0A4-9D63E37FF9F5 1 From-package: '793355' ('ce687d7f-65f2-442d-bf31-44be6a26f6f2'), estimated_item_count: '24' packed_part: '12305' ('08cbfa61-413c-4c06-8bb5-870cc7d36da2'). No To-package, counting will be ended and from-package will be empty. Transferring '24' supply from '793355' ('ce687d7f-65f2-442d-bf31-44be6a26f6f2') to NULL (NULL). Transferring '0' supply from undefined package to NULL (NULL). Excess '24' supply in to be empty or recounted package '793355' ('ce687d7f-65f2-442d-bf31-44be6a26f6f2'). Unlinked '0' counted supply from now empty or recounted package '793355' ('ce687d7f-65f2-442d-bf31-44be6a26f6f2'). Excess '24' in from-package '793355' ('ce687d7f-65f2-442d-bf31-44be6a26f6f2'), this notice should be an exception.

c89562bb-2109-4b8c-bab9-6decdad55420

22b6dbe4-2879-4cad-b003-6f21c9383a4d 22b6dbe4-2879-4cad-b003-6f21c9383a4d

 22B6DBE4-2879-4CAD-B003-6F21C9383A4D 2015-05-06T10:37:49+00:00 2015-05-06T14:20:53+00:00 2015-05-06T10:37:49+00:00 3C06A9F4-20CF-482D-B0A4-9D63E37FF9F5 1 From-package: '14458531' ('22b6dbe4-2879-4cad-b003-6f21c9383a4d'), estimated_item_count: '118' packed_part: '21470' ('45c6052c-3652-46ea-bcba-a3ff17f74daf'). To-package: '14458531' ('22b6dbe4-2879-4cad-b003-6f21c9383a4d'), estimated_item_count: '118' packed_part_uuid: '45c6052c-3652-46ea-bcba-a3ff17f74daf'. From- and to-package are the same '14458531' ('22b6dbe4-2879-4cad-b003-6f21c9383a4d'). Update number of items from '118' to '121'. From-package lacks enough exactly counted supply ('118' < '121'). From-package lacks enough supply ('118' < '121'). From-package lacks enough supply ('118' < '121') and is counted, either originally counted wrong or transfer is too big. Going to create new items. Not enough ('3' lacking) supply in '14458531' ('22b6dbe4-2879-4cad-b003-6f21c9383a4d'), going to try unpackaged supply. Not enough ('3' lacking) supply without packages, going to try uncounted packages. Transferring '118' supply from '14458531' ('22b6dbe4-2879-4cad-b003-6f21c9383a4d') to '14458531' ('22b6dbe4-2879-4cad-b003-6f21c9383a4d'). Transferring '0' supply from undefined package to '14458531' ('22b6dbe4-2879-4cad-b003-6f21c9383a4d'). Borrowing '121' - '118' = '3', because count of to-package '14458531' ('22b6dbe4-2879-4cad-b003-6f21c9383a4d') is exact and from-package '14458531' ('22b6dbe4-2879-4cad-b003-6f21c9383a4d') does not have enough supply and not enough can be found in the rest of the dbase.

4e0288d8-b10d-40cc-a79f-2e0f294e8e81

42044f76-833e-4a4f-ab80-5294e6103ba7 42044f76-833e-4a4f-ab80-5294e6103ba7

 42044F76-833E-4A4F-AB80-5294E6103BA7 2015-05-07T08:07:31+00:00 2015-05-07T10:50:24+00:00 2015-05-07T08:07:31+00:00 3C06A9F4-20CF-482D-B0A4-9D63E37FF9F5 1 From-package: '77172073' ('42044f76-833e-4a4f-ab80-5294e6103ba7'), estimated_item_count: '0' packed_part: '22973' ('f2ba91ba-7ff1-49c1-8e8a-bed9fc6bf5f3'). To-package: '77172073' ('42044f76-833e-4a4f-ab80-5294e6103ba7'), estimated_item_count: '0' packed_part_uuid: 'f2ba91ba-7ff1-49c1-8e8a-bed9fc6bf5f3'. From- and to-package are the same '77172073' ('42044f76-833e-4a4f-ab80-5294e6103ba7'). Update number of items from '0' to '2'. Not enough ('2' lacking) supply in '77172073' ('42044f76-833e-4a4f-ab80-5294e6103ba7'), going to try unpackaged supply. Not enough ('2' lacking) supply without packages, going to try uncounted packages. Transferring '0' supply from '77172073' ('42044f76-833e-4a4f-ab80-5294e6103ba7') to '77172073' ('42044f76-833e-4a4f-ab80-5294e6103ba7'). Transferring '0' supply from undefined package to '77172073' ('42044f76-833e-4a4f-ab80-5294e6103ba7'). Borrowing '2' - '0' = '2', because count of to-package '77172073' ('42044f76-833e-4a4f-ab80-5294e6103ba7') is exact and from-package '77172073' ('42044f76-833e-4a4f-ab80-5294e6103ba7') does not have enough supply and not enough can be found in the rest of the dbase.

754b65cc-b6c2-48b7-b96f-0d2d6ca6540c

ab3cd660-8f04-49f8-a530-25e554e19ca7 ab3cd660-8f04-49f8-a530-25e554e19ca7

 AB3CD660-8F04-49F8-A530-25E554E19CA7 2015-05-07T13:42:13+00:00 2015-05-07T13:42:52+00:00 2015-05-07T13:42:13+00:00 3C06A9F4-20CF-482D-B0A4-9D63E37FF9F5 1 From-package: '35092448' ('ab3cd660-8f04-49f8-a530-25e554e19ca7'), estimated_item_count: '50' packed_part: '24726' ('d963e432-9e64-4170-95b0-22edd892cb8b'). To-package: '35092448' ('ab3cd660-8f04-49f8-a530-25e554e19ca7'), estimated_item_count: '50' packed_part_uuid: 'd963e432-9e64-4170-95b0-22edd892cb8b'. From- and to-package are the same '35092448' ('ab3cd660-8f04-49f8-a530-25e554e19ca7'). Update number of items from '50' to '6'. From-package lacks enough exactly counted supply ('1' < '6'). Transferring '6' supply from '35092448' ('ab3cd660-8f04-49f8-a530-25e554e19ca7') to '35092448' ('ab3cd660-8f04-49f8-a530-25e554e19ca7'). Transferring '0' supply from undefined package to '35092448' ('ab3cd660-8f04-49f8-a530-25e554e19ca7'). Excess '44' supply in to be empty or recounted package '35092448' ('ab3cd660-8f04-49f8-a530-25e554e19ca7'). Deleted '44' uncounted supply from to be empty or recounted package '35092448' ('ab3cd660-8f04-49f8-a530-25e554e19ca7'). Unlinked '0' counted supply from now empty or recounted package '35092448' ('ab3cd660-8f04-49f8-a530-25e554e19ca7').

63d6a0f0-02e2-4e75-9ff8-6ed702493c13

2b50235d-bf6f-450b-86dc-801922a887e3 2b50235d-bf6f-450b-86dc-801922a887e3

 2015-05-08T10:25:20+00:00 9999-12-31T23:59:59+00:00 2015-05-08T10:25:20+00:00 1

6e1eb7b4-f66b-4b13-8866-6fa111077f63

1ed81ae0-e5c4-465e-87e7-c1cd30f9397b 1ed81ae0-e5c4-465e-87e7-c1cd30f9397b

 2015-05-08T13:49:04+00:00 2015-05-08T15:29:11+00:00 2015-05-08T13:49:04+00:00 1

f1ba9454-1269-4c88-beea-4a4ddcb69985

f981d753-fcb8-4d60-9097-2031b891ece4 f981d753-fcb8-4d60-9097-2031b891ece4

 2015-05-27T11:24:14+00:00 9999-12-31T23:59:59+00:00 7C29C468-FD59-4E7E-A0C7-28D4A363A532 2015-05-27T11:24:14+00:00 1

294f6e2d-0c91-4d32-bb7e-5a37b6c9ca20

ac991575-228a-4d03-a46e-fbfb3cfea9bc ac991575-228a-4d03-a46e-fbfb3cfea9bc

 2015-05-20T09:11:01+00:00 9999-12-31T23:59:59+00:00 7C29C468-FD59-4E7E-A0C7-28D4A363A532 2015-05-20T09:11:01+00:00 1

67bfc95e-c050-4769-90b9-adde168cd76c

9a6d031f-1b47-4bce-a67c-93604e26c7bb 9a6d031f-1b47-4bce-a67c-93604e26c7bb

 2015-05-12T14:17:03+00:00 4987E705-FE0F-4CEB-8945-E301B128B702 2015-05-12T14:17:03+00:00 1

2f779917-a412-4cad-a5b0-e066ca5599e4

048e2926-c37e-4146-8dad-9002f802e384 048e2926-c37e-4146-8dad-9002f802e384

 2015-05-15T09:22:04+00:00 9999-12-31T23:59:59+00:00 7C29C468-FD59-4E7E-A0C7-28D4A363A532 2015-05-15T09:22:04+00:00 1