Import/export template > Module Stock > Import/export template LPNO (License plate number operation) 

Use this function import operations to internal containers.
The operations are identified by their mode of operation.

You can:
  • Fully or partly split one license plate number into one or several license plate numbers.
    The MODOPELPN - Mode of operation field of this template must be set to ‘2’.

    The rules that apply to the license plate number and location are the same as in interactive entry mode:
    • If the destination license plate numbers entered in the import file include stock lines and are linked to a location, it is not necessary to specify their location in the import file. Otherwise, their location must be specified.
      For further information, please refer to the documentation on the License plate number operations function.
  • Fully or partly deassign one or several stock lines of a license plate number. Once the import is complete, the stock lines are no longer attached to the license plate number.
    The MODOPELPN - Mode of operation field of this template must be set to ‘3’.

    The rules that apply to the license plate number and location are the same as in interactive entry mode:
    • You can change the location of license plate numbers during the operation.
      For further information, please refer to the documentation on the License plate number operations function.
  • Assigning stock lines to existing license plate numbers.
    The MODOPELPN - Mode of operation field of this template must be set to ‘4’.

    The rules that apply to the license plate number and location are the same as in interactive entry mode:
    • If the destination license plate numbers entered in the import file include stock lines and are linked to a location, it is not necessary to specify their location in the import file. Otherwise, their location must be specified.
      Please refer to the License plate number assignment documentation for more information.
Once the import is complete, a stock change movement of the License plate number change type and a stock change document are generated.
Import file examples

Importing a split

You want to split part of the PAL00173 license plate number in order to assign the products from two stock lines to the PAL00175 license plate number.

The syntax of the import file is:

"E","","FR012",190104,"","","",2

"L",1000,"CON006","UN",1,"A","STO","A1C12","PAL00173","","","","","","SERFR01200021","FR012"

"S","UN",1,1,"","PAL00175","SERFR01200021"

"L",2000,"CON006","UN",1,"A","STO","A1C12","PAL00173","","","","","","SERFR01200022","FR012"

"S","UN",1,1,"A1C12","PAL00175","SERFR01200022"

Deassigning a license plate number

You want to deassign a product from the PAL00172 license plate number and assign to the A1C12 location. The serial number of the product is: SERFR01200020.

The syntax of the import file is:

"E","","FR012",190104,"","","",3

"L",1000,"CON006","UN",1,"A","STO","A1C11","PAL00172","","","","","","SERFR01200020","FR012"

Assigning a license plate number

You want to assign a stock line,which has not yet been assigned to a license plate number, to the two following license plate numbers:

    • PAL00173, which is already linked to a location. It is not necessary to specify the location in the import file.
    • PAL00175, which is free and must be linked to the A1C12 location.

The syntax of the import file is:

"E","","FR012",190103,"","","",4

"L",1000,"BMS020","UN",1,"A","STO","A1C11","","","","","","","","FR012"

"S","UN",1,1,"","PAL00173",""

"L",2000,"BMS020","UN",1,"A","STO","A1C11","","","","","","","","FR012"

"S","UN",9,9,"A1C12","PAL00175",""

"S","UN",1,1,"A1C12","","SERFR01200020"





Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

FACILITY [FCY]

Sites

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

ITMWRH [ITW]

Products-warehouses

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