Import/export template > Module Stock > Import/export template SCSL (Stock change by container) 

Use this template to perform stock changes for all the stock lines assigned to the license plate numbers.

You can:
  • import location and/or warehouse changes for the same site,
  • import status changes.

Once the import is complete, a stock change movement and a stock change document are generated.
Import file example

You want to change the location of the PAL00011 license plate number for the A1C15 location.

The syntax of the import file is:

"E","FR012",181121,"location change","",""

"L","PAL00011","A1C15","A“

Error messages

The only error messages are the generic ones.

Tables used

This template can only be used in import mode. The data is updated in the following tables :

Table

Table description

BPCUSTMVT [MVC]

Customer transactions

FACILITY [FCY]

Sites

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

ITMWRH [ITW]

Products-warehouses

LPN [LPN]

License plate number

OVERHEAD [OVE]

Overhead codes

SCHGD [SGD]

Stock change line

SCHGH [SGH]

Stock change header

STOCK [STO]

Stock

STOJOU [STJ]

Stock journal

STOJOUVAL [SJV]

Stock movement values

STOLOC [STC]

Locations

STOLOT [STL]

Lot numbers

STOSER [STS]

Serial numbers

TABALLRUL [TRU]

Allocation and issue rules

TABLOCTYP [TLO]

Location type table

TABSTASTO [TST]

Stock status report

TABSTORUL [SRU]

Stock management rules

TABUNIT [TUN]

Table of units of measure

WAREHOUSE [WRH]

Warehouses