Stock statuses

The major rules that define whether a particular stock unit is in stock or not.

First & Last type can:

- PC (produce creation)

- PD (produce depletion)

- DT (data transfer mode)

In the Stock Unit Header table (cspalh), you can find the current statuses of the instance.

When a Stock unit (pallet) is loaded from a cargo / vessel manifest file, the first_type / first_operation_type is set to PC / IWF

When that stock unit is unloaded and scanned in, for example, a port, that status for first_type / first_operation_type is changed, namely to PC / IWS, but can also have a different value, but different from PC / IWF

So firsts:

PC / IWF => underway on vessel

<> PC / IWF (for overseas fruit, it will probably be PC / IWF) then it is included in localized stock. 

This first status can have various combinations for the own grown fruit or packaging, but always <> PC IWF

You can read the "in-stock" status of the pallet in itself from Last_type

If Last_type = 'PC' = present in site

If Last_type <> 'PD' = not present in site. (eg unloaded, used for repacking as a donor pallet, dump, ...)

Another important one is the Block flag which can be raised in case of blocked stock. This is a super flag that doesn't really say why, but provides a general block for delivery or extradition.