Stake Prod Loc

Contains the number which uniquely identifies the cycle (stock) count.

Contains the department number where the stock take will occur.

Contains the class number where the stock take will occur.

Contains the subclass number where the stock take will occur.

Contains location type. Valid values are : S = Store , W = Warehouse or Internal Finisher , E = External Finisher

Contains the location where the cycle (stock) count will occur. If LOC_TYPE is S, then the location is the Store. If LOC_TYPE is W, then the location is the Warehouse or Internal Finisher. If LOC_TYPE is E, then the location is the External Finisher.

Indicates whether or not the record has been processed. The value will be N for not processed when the record is first created. Once the user approves the record to affect the stock ledger the value will be updated to a P. This will then change to S to once the record is processed by the stock ledger programs.

Contains the total cost of the inventory for the department. This field is stored in the local currency.

Contains the total retail value of the inventory for the department. This field is stored in the local currency.

This field represents the adjustment to the total_cost. This provides an audit trail when the total_cost is modified. This field is stored in the local currency.

This field represents the adjustment to the total_retail. This provides an audit trail when the total_retail is modified. This field is stored in the local currency.

This field will hold the user ID that created the record.

This field will hold the date and time of when the record was created.

This field will hold the user ID that last updated the record.

This field will hold the date and time of when the record was last updated.