Stock History

• Site (field FCY)

Enter or select a storage site at which the selected product is active.

The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table.

• Warehouse (field WRH)

• Product (field ITMREF)

Enter the reference of the product for which the stock needs to be inquired.

• Lot (field LOTSEL)

Reference of the lot number to be processed.

• Starting serial number (field SERNUMSTR)

This is the product serial number.

• Ending serial number (field SERNUMEND)

• Inquiry history (field INQLTI)

Enter the number of history days -starting from the current date- for the
selection of stock movements.

• field FIL001

• Sort order (field SRTCOD)

Sorting criteria for the list or the inquiry.

• Site (field STOFCY)

• Allocation (field IPTDAT)

• Lot (field LOT)

• Sublot (field SLO)

• Major version (field ECCVALMAJ)

• Minor version (field ECCVALMIN)

• Starting serial number (field SERNUM)

• Ending serial number (field SERFIN)

• Quantity (field QTYPCU)

• PAC (field PCU)

• STK quantity (field QTYSTU)

• STK (field STU)

• Status (field STA)

• Warehouse (field WRH)

• Location (field LOC)

• Identifier 1 (field PALNUM)

• Identifier 2 (field CTRNUM)

• Stock before (field BEFSTO)

• Stock after (field AFTSTO)

• Analysis req. (field QLYCTLDEM)

• Movement type (field TRSTYP)

• Movement description (field MVTDES)

• Project (field PJT)

• BP (field BPRNUM)

• Entry type (field VCRTYPTXT)

• Entry (field VCRNUM)

• Line no. (field VCRLIN)

• Source document type (field VCRTYPORIT)

• Original document (field VCRNUMORI)

• Source document line (field VCRLINORI)

• Supplier lot (field BPSLOT)

• Expiration (field SHLDAT)

• UBD (field DLUDAT)

The use-by date (UBD) is the target date for issuing a product.
It cannot be modified. 
UBD = Reference expiry date + UBD lead time.

• Recontrol (field NEWLTIDAT)

La date de recontrôle est associée à un lot en stock. Elle indique une date d'analyse de la marchandise, une fois le délai de péremption atteint.

 Warning The new control date cannot go beyond the limit date of lot use.

• Active quantity (field ACTQTY)

• Potency (field POT)

• Original PAC (field PCUORI)

• Original coef. (field PCUSTUORI)

• Currency (field ACCCUR)

• Order amount (field AMTORD)

• Movement value (field AMTVAL)

• Order variance (field VARORD)

• Movement variance (field VARVAL)

• Order price (field PRIORD)

• Valued price (field PRIVAL)

• Cost source (field PRINAT)

• Variance not absorbed (field AMTDEV)

• field CCE1

The setup determines whether the analytical dimensions can be modified. These are initialized in compliance with the default dimension setup.

In creation mode, if no order line has been entered and the project code is modified, analytical dimensions are reset based on the setup of the default dimensions.

In creation mode, as in modification mode, if an order line has been entered and the project code is modified, analytical dimensions are not reset.

• field CCE2

• field CCE3

• field CCE4

• field CCE5

• field CCE6

• field CCE7

• field CCE8

• field CCE9

• field CCE10

• field CCE11

• field CCE12

• field CCE13

• field CCE14

• field CCE15

• field CCE16

• field CCE17

• field CCE18

• field CCE19

• field CCE20

• Stock movement group (field TRSFAM)

• Accounting date (field ACCDAT)

• Accounting document (field NUMVCR)

• Entry type (field GTE)

• Owner (field OWNER)

• Intercompany (field BETCPY)

• Creation user (field CREUSR)

• Date created (field CREDAT)

• Time (field CRETIM)