Database diagram

1.

G.O.L.D. STOCK
Database diagram
Version 5.10
Update of 29/08/2014

2. I. Table catalogue

3. Tables TB_xxx (1/5)

TB_A..
TB_ANOOL
TB_B..
TB_C..
TB_D..
TB_ACC
TB_ART
TB_BANAL
TB_CALOZP
TB_DAE*
TB_ACTI
TB_ARTDEP
TB_BERDV
TB_CHARI
TB_DBG
TB_ADRESS
TB_ARTDT
TB_BFRDV
TB_CHLOG
TB_DECINV
TB_ALAOL
TB_ARTFAC
TB_BLQRDV
TB_CHPM
TB_DEPOT
TB_ALCH
TB_ARTOV
TB_BLQTOUR
TB_CHREV
TB_DETCHARGE
TB_ALS
TB_ARTPRQPPD
TB_BLSLREC
TB_CHZI
TB_DISTALS
TB_AMISS
TB_ARTR
TB_BORDALO
TB_CLAS
TB_DISTTRV
TB_ANOADRTIE
TB_ATAR
TB_BORDREP
TB_CLASTA
TB_DLCEXP
TB_ANOART
TB_ATOUR
TB_BQTOUR
TB_CLTOUR
TB_DOSUMS
TB_ANOCOME
TB_ATTR
TB_BSTKB
TB_CMDCOM
TB_DSLREC
TB_ANOCOML
TB_AUDUMS
TB_BTOUR
TB_COMP
TB_DTOUR
TB_ANODETOR
TB_AXIMVT
TB_CORIND
TB_ANOENTOR
TB_CPTBL
TB_ANOINT
TB_CTAB
TB_ANOMA
TB_CTAGR
TB_ANONOMD
TB_CTOUR
TB_ANONOME
TB_CUMS
TB_ANOTIERS
TB_CZNS
TB_ANOOF
TB_CZOP
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 3

4. Tables TB_xxx (2/5)

TB_E..
TB_EREPAN
TB_EUMS
TB_G..
TB_H..
TB_EAN
TB_ESLREC
TB_EVAG
TB_GARE
TB_HAPP
TB_EAUDRE
TB_ESTAIN
TB_EXP13
TB_GESCONF
TB_HCUMS
TB_EAVIEX
TB_ESTLOT
TB_GPIC
TB_HDETCHARGE
TB_ECALLO
TB_ESTLPR
TB_GPPDEF
TB_HDOSUMS
TB_ECDE
TB_ETAB
TB_GPPPAR
TB_HEADMVT
TB_EINV
TB_ETICAL
TB_GRPAFPICK
TB_HEAVIEX
TB_EMB
TB_ETICON
TB_GRPART
TB_HECALLO
TB_EMBIO
TB_ETIDAT
TB_GRPASSO
TB_HECDE
TB_EMBSLREC
TB_ETIETI
TB_GRPTIER
TB_HEMBUMS
TB_EMBUMS
TB_ETIFAM
TB_F..
TB_HENTCHARGE
TB_ENTCHARGE
TB_ETIINT
TB_FAM
TB_HERDV
TB_ENTR
TB_ETILCA
TB_FAMFAC
TB_HEREC
TB_EPA
TB_ETILCO
TB_FAMREG
TB_HEUMS
TB_EPAL
TB_ETILIG
TB_FAMREP
TB_HEXP
TB_EPICK
TB_ETILLC
TB_FED
TB_HFRDV
TB_EPLAUD
TB_ETISQL
TB_FEDLIB
TB_HINTER
TB_ERDV
TB_ETIVAR
TB_FERMP
TB_HLAVIEX
TB_EREC
TB_ETLO
TB_FOUMG
TB_HLCDE
TB_EREP
TB_ETOUR
TB_FRDV
TB_HLCUMS
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 4

5. Tables TB_xxx (3/5)

TB_HLOGAR
TB_HPLOMB
TB_I..
TB_L..
TB_LQTOUR
TB_HLOTET
TB_HPLOREC
TB_IAXI
TB_LAUDRE
TB_LRDV
TB_HLOTPR
TB_HPRE
TB_IAXI2
TB_LAVIEX
TB_LREC
TB_HLPREP
TB_HREC
TB_IMGSTK
TB_LCDE
TB_LREPAN
TB_HLQRDV
TB_HRREC
TB_IMODTNO
TB_LCTAB
TB_LSLPAQ
TB_HLRDV
TB_HSATAS
TB_IMPR
TB_LCUMS
TB_LSLREC
TB_HLREC
TB_HSTAUMS
TB_INTER
TB_LETAB
TB_LSTAIN
TB_HMISS
TB_HTAVIEX
TB_INTPICK
TB_LGNMVT
TB_LTAB
TB_HMVTAL
TB_HTMSCHARGE
TB_INTTR
TB_LIBONU
TB_LTOUR
TB_HMVTCDE
TB_HTMVTR
TB_ITDPER
TB_LIEFONC
TB_HMVTCHA
TB_HTPREP
TB_ITHEVT
TB_LINAR
TB_HMVTDG
TB_HTRAUMS
TB_ITHINV
TB_LINV
TB_HMVTEX
TB_HVOC
TB_ITPROP
TB_LLTAB
TB_HMVTIN
TB_HVOCALLMG
TB_ITSITU
TB_LOGAR
TB_HMVTPR
TB_HVOCECL
TB_LOTET
TB_HMVTRA
TB_HVOCRAM
TB_LOTOP
TB_HMVTRE
TB_LOTPR
TB_HMVTSD
TB_LPLAUD
TB_HORODAT
TB_LPREP
TB_HPLBUMS
TB_LQRDV
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 5

6. Tables TB_xxx (4/5)

TB_M..
TB_MVTSOLDOR
TB_P..
TB_R..
TB_MANVOC
TB_PAQPARAM
TB_RACK
TB_MAS
TB_PAR
TB_REGCP
TB_MATMES
TB_PARCHA
TB_REGFIE
TB_MATSAT
TB_PARCODNC
TB_REGFIL
TB_MCAR
TB_PARL
TB_REGIE
TB_MESSD
TB_PICCH
TB_REINTEG
TB_MISS
TB_N..
TB_PICK
TB_REPI
TB_MODPRE
TB_NOMDET
TB_PIVDEB
TB_RES
TB_MVTAL
TB_NOMENT
TB_PIVOT
TB_RETFAM
TB_MVTCDE
TB_PLBUMS
TB_RFIFO
TB_MVTCHA
TB_PLOMB
TB_RLANCE
TB_MVTDG
TB_PLOREC
TB_RPASSAGE
TB_MVTEX
TB_RQCP
TB_MVTIN
TB_O..
TB_MVTPR
TB_ONU
TB_RREC
TB_Q..
TB_RSCAL
TB_MVTRA
TB_QTOUR
TB_RUMS
TB_MVTRE
TB_QUAI
TB_RUPREM
TB_MVTSD
TB_RUPTP
TB_MVTSER
TB_RURG
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 6

7. Tables TB_xxx (5/5)

TB_S..
TB_STOCK
TB_T..
TB_TRKPARGAM
TB_W..
TB_SATAS
TB_SUPTIER
TB_TADER
TB_TRKPOSENT
TB_WANPR
TB_SEINV
TB_SYCAR
TB_TAVIEX
TB_TRKPOSLIB
TB_WINV
TB_SELMVS
TB_SYNPR
TB_TLOCOM
TB_TRKTABENT
TB_SESSION
TB_TMSCHARGE
TB_TRKTABLIB
TB_SFAFAC
TB_TMVTR
TB_TRKVALPAR
TB_SFAM
TB_TPREP
TB_TRPIC
TB_SLPAQ
TB_TPSIN
TB_TRV
TB_SSLREC
TB_TPSPR
TB_TSLREC
TB_STACD
TB_TRACOLS
TB_TTY
TB_STACLIENT
TB_TRAUMS
TB_Z..
TB_STAEMP
TB_TRINV
TB_ZDCLI
TB_STAEX
TB_TRKCTLENT [TRA]
TB_ZNCLI
TB_STAFOURN
TB_TRKCTLLIG [TRA]
TB_ZNS
TB_STAPE
TB_TRKGAMIND
TB_V..
TB_ZNSCH
TB_STAPIC
TB_TRKGAMME [TRA]
TB_VERSION
TB_ZOP
TB_STARE
TB_TRKGROART [TRA]
TB_VLAVIEX
TB_ZOPETIMP
TB_STATUT
TB_TRKINDENT
TB_VPREP
TB_ZPNSR
TB_STAUMS
TB_TRKINDLIB
TB_VTAB
TB_ZPNSRGAB
TB_STKFAC
TB_TRKNATIND [TRA]
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 7

8. Other tables (1/2)

ADM_
AS_REF_CODES
G_
INT
IST
GOLDRPT
INTBATCH
ISTCTLENT
ADM_DICTIONARY
INTDEPEND
ISTCTLLIG
ADM_DO
INTHBATCH
ISTGAMIND
ADM_MENUS [TRA]
INTLINK
ISTGAMME
ADM_DEPOTS
ADM_PROFILES
I
INTOTRT
ISTGROART
ADM_SITES
ICORRES
INTPDYN
ISTINDIC
ADM_USERPREF
INTPLAN
ISTNATIND
ADM_USERS
INTPRDYN
ISTPARGAM
INTPRINC
ISTPOSTES
INTTASK
GEPPRCOM
ISTTABLES
INTWBATCH
ISTVALPAR
ALARMS
AS_
BLG_
AS_MODULES
BLG_MVTEX
IEM
IEMCAPIND
[TRA_...]
BLG_MVTIN
AS_MODULES_RIGHTS
BLG_MVTRA
AS_MODULES_STRUCT
BLG_MVTRE
IEMENTETE
IEMRESFIL
IEMRESSOU
IT_
[TRA_...]
IEMSUPPUL
AS_PARDARG
IEMUNLOGI
IT_ECDE
IT_LCDE
AS_PARLARG
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 8

9. Other tables (2/2)

L
N3_
TRA
LANGUES
N3_ANUAR
TRA_COMCOLS
N3_DATREL
TRA_COMTABS
N3_EAVIEX
TRA_GEN
N3_HEAVIEX
N3_HLAVIEX
N3_HTAVIEX
N3_IMSTK
N3_LAVIEX
N3_MVTEX
N3_MVTIN
N3_MVTRE
N3_MVTSOLDOR
N3_TAVIEX
► NOTE: The tables GEPxxx and VOxxx are not described in this document
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 9

10. II. Detailed schemas

11. Administration – General schema

1,n
Applications
1,1
ADM_DICTIONARY
Descriptions
of the applications
1,n
1,n
LANGUES
Languages
1.1
ADIKEY
ADIAPPLI
LANGUE
1,1
1.1
1,n
1,n
1,n
1
1,n
2
1,1
1,n
APRPROF
APRIDENT
APRAPPLI
3
1,1
ADM_MENUS
Menus
of the applications
1,n
ADM_PROFILES
User profiles
1,n
1,1
TRA_ADM_MENUS
Application menu
descriptions
TAMEIDENT
TAMEAPPLI
LANGUAGE
AMEIDENT
AMEAPPLI
1,1
1,1
1,n
1,n
1,1
LANGUES
Languages
TB_RLANCE
TELNET radio menus
ADM_USERPREF
User
preferences
RL_PROGRAM
RL_LANG
AUPUSER
AUPAPPLI
0,n
1.1
ADM_USERS
Users
applications
ADM_SITES
Associations
Users - Sites
Note Ignored by STOCK
1
ESTOCK
2
ESTOCKPDA
3
VDW
ASIUSER
ASISITE
ASIAPPLI
1,n
1,1
ADM_DO
Associations
Users – O.O.
0,n
0,n
PRO
Order originators
DEP
Depots
ADOUSER
ADODO
ADOAPPLI
1,n
1,1
AUSUSER
AUSAPPLI
ADM_DEPOTS
Associations
Users - Depots
0,n
0,n
ADEUSER
ADEDEPOT
ADEAPPLI
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 11

12. Administration – Detail

0,1
0,n
TB_ETOUR
Prep. routes - Headers
0,n
TB_ZOP
Preparation areas
0,n
TB_LPREP
Preparation lines
0,n
TB_ERDV
Prep. Cons. Headers
0,1
0,1
ADM_USERS
Users
applications
0,1
1,1
0,n
CAT
Staff categories
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 12

13. General parameters

TB_EPA
General parameters
Headers
1,n
1,1
EP_TABLEX
0,n
TB_EPAL
General parameters
Header descriptions
1,1
1,n
LANGUES
Languages
1,n
LANGUES
Languages
EL_TABLEX
EL_LANG
1,1
TB_PAR
General parameters
Entries
PR_TABLEX
PR_POSTEX
1,n
1,1
TB_PARL
General parameters
Entry descriptions
1,1
PI_TABLEX
PI_POSTEX
PI_LANG
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 13

14.  General parameters

General parameters
► The "general parameter" tables group the most of the G.O.L.D. STOCK parameters. STOCK. The data are
presented in a simple form as "Header - Lines" types, the header being the Parameter table, and the line
being the Table entry.
► A general parameters table usually contains one or more entries, but it can also not contain any (if it is for
example to define exceptional cases).
► According to the cases, the number of entries in the table can be fixed or variable. Some examples:
- the week day table (JSM) must contains 7 entries (one per day)
- the storage algorithm parameterisation table (ALG)contains so far 8 entries, which corresponds to 8
parameters used by algorithm. Only one modification of the programme will influence to modify this
number.
- the lift table (LIF) contains as many entries as the lifts existing in the warehouse ( so it is empty
usually)
- The (FPA) table of article preparation families must at least contain one entry which is used as
default value. The person in-charge of the parameterisation can then add as many entries as desired.
► The authorisation to modify a table and/or an entry by an user can be parameterised using the Safety
level:
- If the user ( ADM_USERS) is of "Normal" type, only the tables or entries with lower safety level to
that of the user can be modified.
- otherwise (the user "GLOBAL ADMIN" or "LOCAL ADMIN type) , this parameterisation is without
impacts
► The general parameters table support the multilingualism the description fields of the table and
entries can be used in different application languages.
► To each entry can be associated with one or more parameters:
- the description areas ( 5, 10, 20, 30 and 300 characters)
- 4 alphanumeric parameters (8, 8, 1 and 30 characters)
- 6 decimal numeric parameters of different sizes
► The use of the numeric and alphanumeric parameters in the entries is parameterised at the table level
(On this occasion a description is entered for the parameter). However, the description areas, do not have
this constraint.
► The feeding of the general parameter table is carried out exclusively using the following screens:
PMSParParamGeneManager: General parameter table management
PMSParParamGeneUpdate: Creation/Modification/Display of a general parameter table
PMSParParamGenePosteManager: Entry management of a general parameter table
PMSParParamGenePosteCreateUpdate: C/M/D of an entry of a general parameter table
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 14

15. Operating parameters

LANGUES
Languages
1,n
1,1
EB_TABLEX
TB_ETAB
Oper. parameters
Headers
1,n
AB_TABLEX
AB_POSTE1
AB_POSTE2
AB_POSTE3
1, n
1,n
1,1
1,n
LL_TABLEX
LL_LANG
1,1
1,1
TB_LTAB
Oper. parameters
Lines (Entries)
LANGUES
Languages
1,n
1,n
1,n
LANGUES
Languages
1,n
1,1
TB_LLTAB
Oper. parameters
Line descriptions
TA_TABLEX
TA_POSTE1
TA_POSTE2
TA_POSTE3
TA_LANG
CB_TABLEX
CB_PARAM
TB_CTAB
Oper. parameters
Columns (Parameters)
1,1
1,1
TB_LETAB
Oper. parameters
Header descriptions
1,n
1,1
TB_LCTAB
Oper. parameters
Column descriptions
1,1
1,1
TB_VTAB
Oper. parameters
Parameter values
LB_TABLEX
LB_PARAM
LB_LANG
VT_TABLEX
VT_POSTE1
VT_POSTE2
VT_POSTE3
VT_PARAM
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 15

16.  Operating parameters

Operating parameters
► The "operating parameter" tables complete the general parameter tables by adding an additional
dimension: in a given table, a list of parameters can be defined for an nth group of entries (n = 1, 2 or 3).
The term "lines" is used for the entries and the "columns" for the parameters.
► The below diagram represents the table ALT, for which 2 entries and 4 parameters have been defined:
Table ALT:
Entry 1
0
1
50
90
100
P1
Indicator
Entry 2
0
AFF
0
DESAFF
1
REAFF
1
REAET
0
P2
P3
P4
Values
► The information distributed in various tables is done in the following manner:
- TB_ETAB contains the table entry and its security level
- TB_LETAB contains the table description, in various managed languages
- TB_LTAB contains the entry value combinations: (0,0), (0,1), (50,0), (50, 1) etc. as well as their
security level
- TB_LLTAB contains the entry value description combinations: (INITIAL, APPROCHE), (INITIAL,
PREPARE), (A LANCER, APPROCHE) etc.
- TB_CTAB contains the parameter codes: AFF, DESAFF etc.
- TB_LCTAB contains the parameter descriptions: "ALLOCATION", "DEALLOCATION" etc.
- TB_VTAB contains the values defined for each entry-parameter combination. For example: (50, 1) +
"DEALLO" P1 = 1
► It is possible to define for each entry-parameter combination etc.
- an alphanumerical value (represented here by P1) and/or
- a whole numeric value (P2) and/or
- a decimal numeric value (P3) and/or
- a date (P4)
► The feeding of the operating parameter table is carried out exclusively using the following screens:
PMSParParamFoncManager: Operating parameter table management
PMSParParamFoncUpdate: Creation/ Update of an operating parameter table
PMSParParamFoncContenuManager: Content management of an operating parameter table
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 16

17. Other parameters (1/2)

Report management
Printing
modes
MED
Types
Print.
LIE
1,n
1,1
1,1
1,n
1.1
TB_IMPR
Printers
TB_FED
Files to be printed
1,n
1,1
TB_FEDLIB
Files to be printed
Multilingual descriptions
1,1
1,n
FL_NOMOBJ
FL_LANG
1,1
1,n
1,n
FE_NOMOBJ
1,n
DEP
Depots
LIE
Types
Print.
IM_IMPR
1,n
1,1
1,1
TB_TTY
Report allocation
TY_NOMOBJ
TY_IMPR
LANGUES
Languages
Counters
TB_COMP
Counters
CO_LIBCTR
TB_CPTBL
Counter of DN no.
by customer
CP_LIVREA
CP_NSEQBL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 17

18. Other parameters (2/2)

Classes & attributes
TB_CLAS
Attribute classes
TB_ART
Articles
CL_CLASSE
1,n
0,n
1,1
1,1
0,n
TB_ATTR
Class attributes
1,1
TB_ATAR
Article-attribute links
AT_CLASSE
AT_ATTRIB
Time stamping
TB_HORODAT
Time stamping
HD_DEPOT
HD_PROC
HD_DATACT
1,1
1,n
PHD
Time stamping process
MHR
Time stamping modes
HOR
Time stamping parameters
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 18

19.  Other parameters (a)

Other parameters (a)
Report management
► The 3 tables TB_FED, TB_IMPR and TB_TTY allow you to define...
- the list of G.O.L.D. STOCK application statuses
- the list of printers that can be used for each depot
- links between the statuses and printers, which can be narrowed by user and by screen
► TB_FED
Each status has a unique code, imposed by SYMPHONY EYC.
It is indicated for each status...
- if it is an ordinary status ("list") or a label
- the printout orientation: portrait or landscape
The status description supports the multiple languages.
► TB_IMPR
Each printer has a unique code on all the depots. Their naming comes under the responsibility of the
users. It is indicated for each of them...
- the code of the depot where it is located
- its type: List (laser printer etc) or Label
- the instruction before being used for the printout launch
- the number of maximum lines in the two orientations (portrait and landscape)
Note that the printer can be fictive. In this case, the status remains stored as the file which can be
consulted by the user.
► TB_TTY
For a given depot, each status must be associated with a printer adapted to its form (list or label). It
is, moreover, possible to narrow this association by user and/or by screen.
► The feeding of these tables is carried out exclusively using the following screens:
PMSParEditionManager: Report management
PMSParImprimanteManager: Printer management
PMSParEditionImprimanteManager: Printout - printer association management
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 19

20.  Other parameters (b)

Other parameters (b)
Counter management
► The counters are used to allocate an internal number to different objects of the application: delivery
orders, preparation lot, SSCC no. etc. Each counter is characterised by...
- its code
- its limits (mini and maxi values)
- its increment step (generally = 1)
- the last allocated value
► TB_COMP
The counters used by the G.O.L.D. Stock application are in reality managed by using ORACAL
sequencer since many years. The table TB_COMP, used in the beginning, has been kept only in the
aim of storing the counter labels. The table key takes the ORACAL sequencer name.
Example of ORACLE sequencer (display by PL/SQL developer):
► TB_CPTBL
This table allows the user to manage the counters of DN numbers by delivered customer.
► The screen used for the counter management is limited to...
PMSParCompteurShow: Counter management, which allows you to display the "standard" counters
based on the table TB_COMP and the ORACLE sequencers.
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 20

21.  Other parameters (c)

Other parameters (c)
Classes and attributes
► The article attributes allow you to define additional characteristics at the article level. They are
organised in a hierarchical way in Classes and Attributes.
A G.O.L.D. CENTRAL interface G.O.L.D. STOCK of the classes and attributes existed in the beginning. Its
deletion made independent the management of these data on the two applications
► TB_ CLAS
This table contains the attribute classes. For each one, the following data are defined...
- Code and description
- an indicator (Y/N) indicating if an article can have several attributes of this class.
Examples:
- colour: a single value possible (blue, white...)
- material (for a tissue): several values possible ( wool AND acrylic etc.)
► TB_ATTR
This table contains the attributes of each class. For each one, the following are defined...
- code and description
- three pieces of information (an alphanumeric field and two dates), which can be used or not
according to the need. For example, the dates can be used to define a validity period, and the
numeric value of a percentage...
- an indicator (Y/N) indicating if the above mentioned three information must be or must not be used
to pre-initialise the article-attribute link during its definition.
Example:
- The "Material" class contains two attributes: "Wool" and "Acrylic", for which the alphanumeric fields
have been entered with 30 and 70 (these values represents %)
- If these two attributes are later associated to an article, the association screen will enter by
default the values 30 and 70. The clerk can then modify them or not according to his needs.
► The classes and attributes parameterisation screens are...
PMSParClasseAttributManager: Class and attribute management
PMSParClasseAttributUpdate: Management of a class and its attributes
► The screen using this parameterisation for the feeding of the article ID is ...
PMSGdbArticleAttributManager: Article attribute management
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 21

22.  Other parameters (d)

Other parameters (d)
Time stamping
► This table contains a calendar allowing you to describe the working days of each depot (Work day, activity
start date...). Ref. NDI_064 (V. 5.04)
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 22

23. Report Parameterisation

TRA_AS_MODULES_STRUCT
Tree structure Description
1,n
1,1
0,n
AS_MODULES_STRUCT
Menu
0,1
tree structure
1,n
1
CODE
PARENT
1,1
1,n
LANGUES
Languages
ADM_USERS
Users
MODPARENT
0,n
1,1
TRA_AS_MODULES
Module Descriptions
1,n
1,1
AS_MODULES
Modules
(Printing programmes)
1,n
1,1
1,n
1,1
AS_MODULES_RIGHTS
Modules:
User rights
1,n
1,1
MODUL
ASMODUL
ASUSER
TMOSCODE
LANGUE
LANGUES
Languages
1,1
AS_PARDARG
Calling arguments
0,n
AS_REF_CODES
Arguments
queries
1,n
1,1
DARMODUL
DARSEQ
RV_TYPE
RV_DOMAIN
1.1
LANGUES
Languages
1, n
1.1
AS_PARLARG
Arguments descriptions
LARMODUL
LARLANG
LARSEQ
1
Menu tree structure
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 23

24.  Report parameterisation (a)

Report parameterisation (a)
► G.O.L.D. STOCK has a screen which can be parameterised and which allows you to launch most of the
application reports (statements, statistics etc.). The aim of the tables AS_xxx is to parameterise this screen.
► The parameterisation requires...
- the implementation of a tree structure with N level allowing you to class the report programmes.
Thus a menu is established which is represented by a tree in the report launch.
- the definition of all the report programmes that can be used by the screen, for each programme...
- its linking in the tree structure
- the list of calling parameters, for each parameter...
- its characteristics (type, size...)
- a request which allows the user to propose a list of values (optional)
- the list of users authorised to launch the report
► The content of these tables is normally managed by SYMPHONY EYC, except the user authorisation.
► AS_MODULES_STRUCT
This table contains the menu options as the tree structure (element parent element). The root
element is represented by the "ROOT" code. A description must be entered for each option (multiple
languages managed)
► AS_MODULES
This table defines the report "modules", the module name is the proC programme name. A
description must be entered for each module (multiple languages managed).
The table indicates also if the report must be done in HTML mode.
► AS_MODULES_RIGHT
This table defines the authorisations: module links - users
► AS_PARDARG
This table contains, for each module, the classified list of the calling arguments of the report
programme, as well as the characteristics of each argument (type, size...)
► AS_ PARLARG
This table contains the argument description (multiple languages managed).
► AS_ REF_CODES
This table contains the SQL queries associated to the list of values used by report module
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 24

25.  Report parameterisation (b)

Report parameterisation (b)
► The screens used for the parameterisation definition are etc.
PMSEdtSaisieStructureEdition: Report structure input (Tree structure)
PMSEdtSaisieModule: Report module management (report programs)
PMSEdtSaisieModuleDetail: Report module management
PMSEdtSaisieModuleTrad: Translation of module descriptions
PMSEdtSaisieSecuriteEdition: Input of the authorisation of the modules by user
PMSEdtSaisieParametre: Module parameter management
PMSEdtSaisieParametreDetail: Module parameter management
PMSEdtSaisieParametreRequete: Parameter query management
PMSEdtSaisieParametreTrad: Translation of parameter descriptions
► The report launching screens, based on this parameterisation, are...
PMSEdtStart: Report launch – Main screen
PMSEdt: Print launch
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 25

26. Warehouse map - General schema

TB_ENTR
Warehouse
TA_NOMTAB
TA_NBDOUZ
TA_SCHALV
TA_CODPIL
TE_CODE
1,n
1.1
1.1
TB_DEPOT
Depots
TB_TADER
Decision tables
1,n
Depots
1
Overflow area
2
Standby area
1,1
1,n
TDC
DEP
DP_DEPOT
1,n
1,1
1.1
0,1
1
0,1
TB_ZNSCH
Homogeneity
restrictions
1,1
0,1
2
0,n
ZH_DEPOT
ZH_ZONE
ZH_CODCHO
ZN_TYP
1,n
0,n
TB_ZNS
Shop areas
1,n
0,n
ZN_DEPOT
ZN_ZONE
1,n
0,n
1,1
1,1
1,1
1,1
TB_ALS
Rack aisles
TB_ACC
Accumulator
addresses
TB_MAS
Mass
addresses
TB_BANAL
Common
addresses
1,n
1.1
AL_DEPOT
AL_ZONE
AL_ALLEE
1,1
AD_ADRCLI
1,1
x
MA_ADRCLI
x
1,1
BA_ADRCLI
x
TB_TRV
Rack bays
x
1,n
1,1
TR_DEPOT
TR_ZONE
TR_ALLEE
TR_TRAVEE
TB_RACK
Rack cells
RK_ADRCLI
0,n
0,1
1,n
0,1
0,1
0,1
TB_ADRESS
Warehouse address
1,n
TB_STAEMP
Stock statuses
Location
AD_ADRCLI
x
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 26

27. Warehouse map - detail (1/2)

1,1
TB_ENTR
Warehouse
1,n
TB_INTER
Third parties
1,n
LANGUES
Languages
1,1
1,1
1,n
VAT
VAT codes
TB_DEPOT
Depots
0,1
1,n
1,1
1,n
0.1
1,n
0,1
1,n
0,1
1,n
0,1
1,n
TB_ZNS
Warehouse areas
0,1
1,n
1,1
1.1
1
2
1,n
1,1
RAD
1,n
Radio oper. modes
TB_ZOP
Preparation areas
TZO
Warehouse area types
TMA
Rack types
RPA
Pallet storage modes
RRP
Depth storage rules
TDC
Decision tables
DIT
Directions
GAB
Dimensions
MRE
Storage modes
RAD
Radio oper. modes
PZN
Transition rules
1,n
1,1
1,n
1,1
1,n
1,1
1,n
1,1
1,n
CST
1
Exclusive dimensions
2
Substitution dimension
Calculated statuses
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 27

28. Warehouse map - detail (2/2)

0,1
TB_GARE
Stations
1,n
TB_RACK
Rack cells
1,1
1,n
1,1
1,n
1,1
1,n
0.1
TB_MAS
Mass address
1,1
1
1
1,n
1,n
TB_ACC
Accu. addresses
1,1
1
1
Depth dimensions
ROT
Turnover classes
RPK
Reserve/Picking
TB_ART
Articles
0,n
1,1
0,1
PRF
GAB
Dimensions
RPK
Reserve/Picking
1,1
1,n
GAB
Dimensions
RPK
Reserve/Picking
0,1
TB_QUAI
Docks
0,n
1,1
TB_BANAL
Common addresses
1,n
1,1
1,n
1,1
1,n
If article is stored
TB_ART
Articles
0,n
1,n
1
TBA
Common area types
ATT
Attributes (Bulk/Stock)
RAD
Radio oper. modes
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 28

29. Warehouse map - Miscellaneous

TB_BANAL
Common addresses
1,1
0,1
0,n
1,n
TB_QUAI
Docks
1,1
0,n
1,1
0,n
DEP
Depots
TB_ZNS
Warehouse areas
TQU
Dock types
DEP
Depots
QU_CINQUA
TB_ADRESS
Warehouse addresses
0,1
1,n
TB_GARE
Stations
1,1
0,n
GE_DEPOT
GE_CODGAR
ICORRES
Correspondence address
for migration
1,1
0,1
TB_ADRESS
Warehouse address
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 29

30.  Warehouse map (a)

Warehouse map (a)
► The Warehouse map defines the warehouse architecture, i.e. the entire storage location with their
characteristics. This architecture adopts an hierarchical structure, globally taken in the database schema:
Structure level
Tables ORACLE
Warehouse................ TB_ENTR
Depot...................
Warehouse area..........
Storage address..
TB_DEPOT (+ Table DEP)
TB_ZNS + TB_ZNSCH
Depends on the type of warehouse area:
► TB_ALS + TB_TRV + TB_RACK (Racks)
► TB_MAS (Masses)
► TB_ACC (Accumulators)
► TB_BANAL (Common)
► For processing performance reasons, a great part of information which appears in this structure has been
duplicated in a single table: TB_ADRESS. This table, which contains a record by warehouse address, is
maintained using different triggers and - if needed - upgradation by a night batch programme.
Warehouses and depots
► The hierarchical root of the warehouse map is the warehouse. A warehouse consists of one or more
depots. From an organic point of view, the warehouse corresponds to an ORACLE database schema. Since the
version 5.05, it is possible to manage several warehouses in an ORACLE instance, because of a warehouse by
schema.
► TB_ENTR
This table has the distinctive feature of having a single record which describes some characteristics
of the warehouse (EAN code, addresses, etc.). It is kept for the log because, logically, its data could
be a part of a general parameter table, almost all the management rules applicable to the
warehouse which appear in the above-mentioned tables.
► TB_DEPOT
This table, which contains a record by depot, manages essentially data related to the G.O.L.D. Radio
parameterisation. The major part of the management rules of the depots is in fact managed in the
operation table DEP, for the practical reasons.
► Three screens allow the update of these two tables:
PMSSynEntrepotDepotManager: Warehouse and depot management (General information)
PMSRcmParamRadioDepotManager: Radio parameter management of the depots
PMSRcmParamRadioDepotUpdate: Radio parameter management of a depot
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 30

31.  Warehouse map (b)

Warehouse map (b)
Shop areas
► Each depot has several warehouse areas (the minimum is around ten, because it is necessary to define at
least a dock, workshops, storage areas, a "full warehouse" area etc.).
The warehouse area can be defined as a storage location group having certain characteristics in common:
storage type (rack, mass...), geographical situation, naming rules of the addresses etc. These common data is
found in the tables TB_ZNS (and possibly TB_ZNSCH); the specific data at each location which is stored in
various other tables according to the type of storage of the area.
Example: in a rack area, the width of a cell is defined at the warehouse area level and is found in
TB_ZNS. However, its height and its width can be adjusted and are found as a result in TB_RACK
► TB_ZNS
This table contains thus the major part of the characteristics common to the locations situated in a
same warehouse area:
- the area type (Rack, mass, accumulation, common)
- some parameters used by the storage algorithm
- a large number of data used by G.O.L.D. Radio
- etc.
► TB_ZNSCH
This table complements TB_ZNS if the homogeneity rules must be defined when several SHUs can be
stored to a same address.
The example -type is the one with a mass area whose content of each address must be homogeneous
in terms of product AND of logistic variants. This rule induces the creation of 2 records in TB_ZNSCH:
(Area, Type=Product) and (Area, Type=LV).
► TB_TADER
This table contains the storage rules of an SHU in a rack cell (system called " twelfths). Any area of
"rack" type must mention a decision table code (Table TDC), whose storage rule detail is found in
TB_TADER
► The "warehouse area" information is mainly managed using the following screens:
PMSMagZoneManager (& Update): Management (& update) of warehouse areas
PMSRcmParamRadioZoneManager (& Update): Radio parameter management (& update) of the areas
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 31

32.  Warehouse map (c)

Warehouse map (c)
Storage locations (Warehouse addresses)
► The data related to the storage locations of a warehouse area are distributed in the various tables
depending on the type of the area.
► In the case of the "Rack" type, the data is distributed in three tables:
- TB_ALS for the information related to the aisles
- TB_TRV for the information related to the bays
- B_RACK for the information related to the cells (cell: location of a rack area which can contain one
or more warehouse addresses)
► Otherwise, each of other types has its own table:
- TB_MAS for the masses
- TB_ACC for the accumulators
- TB_BANAL for the "common" areas
► Generally, each table (except TB_ALS) contains two types of information:
- the static data, which describes the physical configuration of the location and its management
rules. For example: such rack cell is of "Reserve" type, has a height of two meters, and supports a
weight of 3 tons. This kind of information is generally defined once for all during the creation of the
warehouse map.
- dynamic data, which evolves depending on the merchandise flow. For example: the rack cell
mentioned previously contains two pallets, which is translated by an occupation schema of
'111100001111' (binary translation) and a weight stored of 1534 kg.
► TB_ALS
This table contains a record by aisle of rack area. It is very important for the location search
algorithm because it allows the user to eliminate some searches which are not useful for the aisles
which do not exist.
► TB_TRV
This table contains a record by bay of rack area. Its main objective is to manage weight restriction by
bay. It allows also to accelerate the location search (address search economy of the in-existing bays).
► TB_RACK
This table contains a record by rack area cell. It is important to note that a cell contains generally
several addresses: from 1 to 12 if it is of "reserve" type and from 1 to 26 if it is of picking type. (this
to explain the link, 1, n-1,1 between TB_RACK and TB_ADRESS)
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 32

33.  Warehouse map (d)

Warehouse map (d)
► TB_ACC et TB_MAS
These tables, which have almost the same structure, contain a record by warehouse address. Note
that, for this area type, the level is not managed.
► TB_BANAL
This table contains only a record by warehouse address. Note that, for this type of area, the
structure of the address can take different forms (from Depot-area till Depot- Area - Aisle- Bay Level)
► TB_ADRESS
This table, which is redundant with all the other tables of the warehouse map, has been created to
increase the performance in the batch processes. It contains in fact, the essential information
present in TB_ZNS, TB_ALS, TB_TRV... , and have a record by warehouse address. For example: A
rack cell which has 4 stacks will be described by a record of TB_RACK and 4 records of TB_ADRESS.
Important note: to meet the needs during the application enhancement, new information might be
directly added into the table TB_ADRESS without impacting the other tables. This way of doing is
to be banned!!!
The update of TB_ADRESS is ensured by the triggers, and is verified by a programme launched
regularly (ba_mag11).
► TB_STAEMP
This table contains the pairs (class, stock status) linked to reserve locations:
cell in the case of the rack
address for the areas of mass, accu or common type
Do not confuse with the table TB_STAPIC, which contains the status linked to the picking address.
This table is used essentially by the storage algorithm, which compares the location status
(TB_STAEMP) with the status of the SHU to be arranged (TB_STAUMS).
ref. NDI_049 (V. 5.03)
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 33

34.  Warehouse map (e)

Warehouse map (e)
► The record generation in the tables which describe the storage locations is only possible during the
creation or the extension of a warehouse area:
PMSMagZoneManager (& Update): Management (& update) of warehouse areas
PMSMagExtensionZoneRun: Warehouse area extension
► The static data updates can be carried out in a massive way (several locations) or unit ( for a cell or an
address):
> Main screens:
PMSMagGroupeAdresseUpdate: Address group modification
PMSMagAlleeRackManager (& Update): Management (& update) of rack aisles
PMSMagTraveeRackManager (& Update): Management (& update) of rack bays
PMSMagAdresseRackManager (& Update): Management (& update) of rack cells
PMSMagAdresseBanalManager (& Update): Management (& update) of common addresses
PMSMagAdresseAccuUpdate: Accu address update
PMSMagAdresseMasseUpdate: Mass address update
> Secondary screens:
PMSMagHauteurPilesManager: Update of stack heights of rack address
PMSMagEmbasesTridiManager: Tridirectional rack area entry point management
PMSMag(Allee)CorrUpdate (Bay) (Level): Modification of aisles (bays) (levels) of correspondence
PMSMagDeblocAdrManager: Address release management
► The dynamic data (occupation, weight...) is mainly updated during the stock movement at the address.
The programmes concerned are:
pk_algor3
... for the address reservation
pk_libad2
... for the address release
Also note that:
pk_picking ... which updates the weight stored at each movement, but only when the address is not
located on the floor.
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 34

35.  Warehouse map (f)

Warehouse map (f)
Other tables linked to the warehouse map
► TB_QUAI
This table has been created during the dock lining implementation [GUA_STOCK_02 (V5.09)]. It
contains the reception and shipping dock description (a record by dock).
Each dock contains one or more addresses, called also dock lines. A dock line is linked to a single
dock.
► TB_GARE
This table has been created during the development of the pre-packing algorithm (CHU Strasbourg).
It is the conveyor stations areas in which cartons to be filled are derived. Each station is
associated to a certain number of picking addresses.
► ICORRES
This table is used by the data migration batch, executed when a new warehouse is started. It
establishes the correspondences between the address of the old system and G.O.L.D. STOCK
addresses.
► The screens used for the update of TB_QUAI and TB_GARE:
PMSMagQuaiManager: Dock management
PMSMagGareManager: Station management
... the table ICORRESS must be entered "manually"
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 35

36. Areas, work site and preparation paths – General schema

Preparation super-areas
1,n
0,n
0,1
0,n
Distribution,
0,n
allotment and
manufacturing work sites
1,n
TB_ZDCLI
Package scan rules
by PA and consignee
1
2
1,n
1,1
TB_ZPNSRGAB
Nb supports by
PA and dimension
0,n
CLP
0,n
ZS_ZPREPI
ZS_TYPSUP
TLO
1
0,n
TB_ZOP
Preparation areas
0,n
1,1
1,n
ZP_ZPREPI
ZP_DEPOT
1,n
GAB
0,n
ZG_ZPREPI
ZG_GABARIT
1,n
Dimensions
SZP
TB_ZPNSR
Nb supports by
PA and lot type
Lot types
Areas, work site and preparation paths – General schema
0,n
TB_INTER
Third parties
0,n
TB_IMPR
Printers
ZD_ZPREPI
ZD_LIVREA
3
1,1
1
1,n
TB_PICCH
Preparation paths
PC_ADRPIC
PC_CLPREP
1,1
TB_ZOPETIIMP
Label printer of
a work site
1,n
ZI_ZPREPI
ZI_DEPOT
ZI_IMPR
2
1,1
TB_RQCP
Path generation
query
TB_CALOZP
1,n
Associations
0,n
1,1 Lot type - preparation area
0,n
TB_ADRESS
Warehouse addresses
0,n
1
concerns the preparation areas
2
concerns the work-sites for distribution and allotment
3
does not concern the manufacturing work-sites
TB_FOUMG
Supplier - Work sites
GM allotted associations
FG_FOURN
FG_DEPOT
Lot types
ZC_DEPOT
ZC_ZPREPI
ZC_CODTLO
RQ_RIDTYPE
RQ_RIDTRI
1,1
1,n
TB_ZNCLI
Customer allocation
in a work site
TLO
1,n
0,n
TB_INTER
Third parties
ZC_ZONREP
ZC_CODCLI
ZC_ADRREP
TB_CZOP
Associations
Printers - Areas
1,1
0,n
1,1
0,n
TB_ZOP
TB_IMPR
CZ_ZPREPD
CZ_IMPR
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 36

37. Areas, work sites and preparation paths – Detail

0,1
0,1
0,1
1
2
3
0,n
0,n
0,n
1,1
0,n
0,1
0,n
0,1
TB_ZOP
0,n
0,1
Preparation areas
Distribution,
0,n
0,1
allotment and
manufacturing work sites
TB_IMPR
Printers
0,n
0,1
0,n
0,1
0,n
0,1
0,n
0,1
0,n
1,1
0,n
0,1
0,n
0,1
0,n
TB_ZNS
Shop areas
TMZ
Types of material used
MPR
Preparation modes
TPR
Preparation doc. types
SAA
Art. adr. in radio prep. input modes
SAQ
Qty. in radio prep. input modes
TLO
Types of lot preparation
STC
Distribution work-site statuses
NEC
Nb. empty support labels
DDE
Mistake-proof types
MGA
Fault management modes
CPA
CPV
Picking counting modes
VOC
Vocal infos
1
for preparation doc.
2
for labels
3
Standby area
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 37

38.  Areas, work sites and preparation paths (a)

Areas, work sites and preparation paths (a)
Overview
► In the beginning, the preparation area was a set of picking addresses homogeneous in terms of
preparation rules, and organised according to the preparation clerk's route (preparation path).
► With the development of new preparation process, the preparation area has become a set of addresses in
which a certain type of preparation is carried out, these addresses being organised or not following a
preparation path.
► If the concept remains the same, the vocabulary is enriched: thus we will speak of...
- the preparation area when referring to picking or floating picking (in the reserve)
- distribution, allotment or manufacturing work sites when referring to the places where these
homonym processes are carried out
- P.T.P. workshop for the location where the preparation in PTP mode is carried out
► Note that only the manufacturing work site does not need a preparation path.
Areas & Work sites
► The data related to the areas and / or preparation work-sites are stored in the following tables:
► TB_ZOP
It is the main table of the data structure. It is entered irrespective of the area type or work-site
type, and it is because of a record by area or work-site.
It contains a large number of parameters classified in different columns (General information /
Radio/ Vocal / Distribution / Allotment / Manufacturing / PTP) which will be or will not be fed, and
it depends on...
- the preparation mode: Picking, Distribution, Allotment, Manufacturing or PTP
- the material type used in the area: Paper, Radio, or Vocal
Note that the depot code does not appear in the table (i.e. in a multi-depot environment, it is not
possible to give the same code at 2 preparation areas located in the different depots)
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 38

39.  Areas, work sites and preparation paths (b)

Areas, work sites and preparation paths (b)
Additional tables of TB_ZOP, used for the preparation area (mode = picking)
► TB_ZPNSR
This table contains data used by the preparation in G.P.I.D. mode : list of supports that can be used,
and number of supports that can be simultaneously prepared.
► TB_ZDCLI
This table allows you to define by consignee (i.e delivered customer) the quantity input rule to be
used during the picking: The input must be carried out by scanning each package if the number of PU
to be picked is lower than a threshold; otherwise, the clerk can enter the quantity.
► TB_CALOZP
This table allows you to define a parameterisation of lot types by preparation area, according to the
rules similar to the ones which governs the general parameter table TLO.
Additional tables of TB_ZOP, used for the distribution and allotment work sites
► TB_ZNCLI
This table describes the customer allocation in the work sites.
- In a given work site, a customer can occupy one or more addresses
- a same warehouse area which can be used as support for several work-sites, a same warehouse
address can be found linked to several customers.
► TB_ZOPETIMP
This table allows you to link the label printers to the distribution or allotment work sites (shipping
label production)
► These tables are fed by the following screens:
PMSGdbZonePrepaManager / Update: Preparation area & work site management
TB_ZOP, TB_ZPNSR, TB_CALOZP, TB_ZOPETIMP
PMSParMagasinPreparation: Preparation area - Shop parameters TB_ZDCLI
PMSGdbZoneRepImpCliManager: Customer allocation management TB_ZNCLI
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 39

40.  Areas, work sites and preparation paths (c)

Areas, work sites and preparation paths (c)
Preparation path definition
► TB_PICCH
This table contains the preparation path description. Each shop address can thus be linked to one or
more paths for a preparation class (Presence of unique key on Address + Class)
► TB_RQCP
This table contains the SQL queries used by the preparation paths generation tools. Its (manual)
management is reserved for the development teams.
► The preparation path management uses the 3 following screens:
PMSGdbCheminPrepManager: Preparation path generation
PMSGdbCheminPrepUpdate: Modification of a preparation path
PMSCheminPrepaOrdreUpdate: Preparation order number generation
Other tables
► TB_FOUMG
Table used by the "GM alloted" process not finalised
► TB_CZOP
Table not used in standard (Developed on a CASINO specific request?)
► Screen management of other tables:
PMSGdbFournAlloMGManager: GM allotted supplier - Work site associations TB_FOUMG
PMSGdbZonePrepaImprManager: Printers - prepa area associations TB_CZOP
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 40

41. Articles – General schema

1,n
1,1
1,n
FA_CFAM
1,1
TB_SFAM
Sub-families
and segments
0,n
TB_FAM
Article families
0,1
0,n
1,1
0,n
1,1
SF_CFAM
SF_CSFAM
SF_SEGMEN
SF_CNR
TB_ARTDT
Last
updates
DA_DONORD
DA_CPROIN
DA_ARPROM
DA_ILOGIS
DA_DEPOT
1,1
DEP
1,1
PV_DONORD
PV_CPROIN
PV_ARPROM
PV_ILOGIS
PV_DEPOT
TB_PIVOT
Pivot addresses
0,n
1,1
0,1
TB_ART
1,1
Articles
TB_ATAR
Article-attribute links
TB_ATTR
Class attributes
0,1
RF_CFAIN
RF_CSFAIN
RF_SGIFLS
TB_EAN
EAN codes
of the articles
EA_EAN13
DEP
0,n
1,n
TB_RETFAM
Associations
Family - Returns
DEP
TB_PIVDEB
Overflow
pivot addresses
AA_DONORD
AA_CPROIN
AA_ARPROM
AA_ILOGIS
AA_CLASSE
AA_ATTRIB
1,1
0,n
DEP
TB_NOMENT
Nomenclatures
Composed
1,n
1,1
0,n
1,1
TB_ARTR
Substitution &
replacement articles
ARR_DONORD
ARR_CPROIN
ARR_ARPROM
ARR_ILOGIS
ARR_DATDEB
ARR_DATFIN
0,1
1,1
AR_DONORD
AR_CPROIN
AR_ARPROM
AR_ILOGIS
TB_ARTOV
Wine operations
AV_DONORD
AV_CPROIN
AV_ARPROM
AV_ILOGIS
1,1
EOV
PD_DONORD
PD_CPROIN
PD_ARPROM
PD_ILOGIS
PD_DEPOT
PD_RANG
PD_ADRPIV
TB_NOMDET
Nomenclatures
Components
NE_DONORD
NE_CPROIN
NE_ARPROM
NE_ILOGIS
NE_DEPOT
NE_SEQ
ND_DONORD
ND_CPROIN
ND_ARPROM
ND_ILOGIS
ND_SEQ
ND_DEPOT
ND_CPROCO
ND_ARPRCO
ND_ILOGCO
Wine op.
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 41

42. Articles - Detail

1.1
1
0,n
TB_INTER
Third parties
0,n
TB_EMB
Packings
0,n
TB_TRKGROART
Traceability groups
1.5
0,1
1,1
0,n
1,1
0,n
1,1
1,1
1,1
0,n
Article statuses
FPA
Preparation families
3
TB_ART
UP
Supplier
2
Preparation unit
3
Management unit
4
MMU unit
5
CMU unit
Preparation units
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,5
1,1
STT
0,n
0,n
1,1
Order originators
2
0,1
Articles
PRO
1
0,n
ISO
Iso-expiry classes
AGP
Weight management modes
ROT
Turnover classes
STK
Storage rules
MOP
Packing modes
MPR
Prep./Distr. modes
APF
Floating picking service modes
CFK
Expansion coefficients
FRA
Fragility codes
UCT
Packaging desc.
4
0,n
5
0,n
1,1
0,n
TGA
UNL
UNP
UNS
UNV
Units
(Length, Weight,
Surface, Volume)
Management types
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 42

43.  Articles (a)

Articles (a)
Overview
► In the schema, usually, the article repository is controlled by the level 3 (e.g.: G.O.L.D. Purchasing Office)
This one creates the articles, then sends them - accompanied by a data selection - to G.O.L.D. Stock.
► The data of a newly created article must be completed by specific information on the warehouse
management: Pivot address, storage rules, preparation rules...: An article can only be used by G.O.L.D.
Stock if the logistic data have been correctly entered.
► An "article" of G.O.L.D. STOCK is defined in a unique way by group:
[Order originator] [Radical] [Purchase variant] [Logistic variant]
Families (Merchandise structure)
► The merchandise structure of G.O.L.D. CENTRAL is sent as a very simplified form to G.O.L.D. STOCK. Only
the 3 higher levels are kept, and takes the denomination as "Family', " Sub-family" and "Segment".
► TB_FAM
This table contains the "Article families". It takes some information of the article ID (UBD
management, Weight variance, etc.) in the aim of reducing the task of data input.
► TB_SFAM
This table contains the two levels "Sub-family" and "Segment".
► TB_RETFAM
Table used for the parameterisation of customer returns in the context of "Return campaigns".
► The following are the related management screens:
PMSGdbFamilleLogManager / Update: Logistic family management
PMSGdbSousFamilleLogManager: Sub-family and segment management
PMSGdbRetFamManager: Return management by family
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 43

44.  Articles (b)

Articles (b)
Article: main data
► TB_ART, TB_ARTDT
The main table TB_ART contains the "static" data of each article: coding, packaging, typology etc. It
has a record by article (OO+ Root +PV+LV)
The purpose of the table TB_ARTDT is to keep by depot, the last update dates linked to a reception,
a shipment or an inventory of the article.
► TB_EAN
This table contains the EAN codes linked to the articles. Each article has normally at least an EAN
code, but can have many different types (EAN13, EAN18, etc.)
► TB_PIVOT
This table contains, by depot, the pivot address of the article used by the storage algorithm. It
contains only the pivot address used by the picking floating with movement.
► TB_PIVDEB
This table allows you to enter, always by depot, complementary pivot address (storage of a
maximum number of pallets at each pivot address)
► The following are the related management screens:
PMSGdbArticleManager / Update: Article ID management (includes the pivot address update)
PMSGdbArticleEANManager: EAN code management
PMSGdbArticleAdrDebordManager: Overflow pivot management
PTOL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 44

45.  Articles (c)

Articles (c)
Other information
► TB_NOMENT, TB_NOMDET
These tables contain the definition of the article naming convention (Compound - components links).
The naming conventions are used by depot and sequence number.
► TB_ATAR
This table contains the attribute values linked to the articles. The parameterisation of classes and
article attributes is done using the tables TB_CLAS and TB_ATTP.
► TB_ATTR
This table allows you to define the substitution articles in order preparation.
► The following are the related management screens:
PMSGdbNomEntManager / Update: Nomenclature header management (compound)
PMSGdbNomDetUpdate: Nomenclature detail management (components)
PMSGdbArticleAttributManager: Article attribute management
PMSGdbArticleSubstitutionManager: Substitute article management
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 45

46. Packings

0,n
TB_ART
Articles
1,6
1
2
0,1
1,1
0,n
[Rental companies]
1,n
0,1
0,n
0,1
LOT
Lot types
0,n
0,n
TB_EMB
Packings
0,n
1,n
TB_ETLO
Packing by
lot type
0, n
ET_TYPLOT
ET_CODEMB
GAB
Dimensions
1,1
0, n
0,1
1,n
LCE
Statuses
0,n
1,n
Types of
accounts
STT
EM_CODEMB
--------------EM_DONORD
EM_CPROIN
EM_ARPROM
EM_ILOGIS
1,n
TB_INTER
Third parties
TB_INTER
Third parties
0,n
TB_CTAGR
Packing accounts
1,n
CA_TYPCPT
CA_TIERS
CA_AGRES
CA_TYPTRS
1
Relation: "The packing is an article"
2
Relation: "An article contains packings"
0,n
TB_EMBIO
Packing movements
(temporary table)
0,1
0,
n
1,1
0,n
TB_ERDV
Header Prep. Con.
TB_ETOUR
Header Prep. Rts.
TB_CUMS
S.H.U. - Package
IO_NUMARR
IO_CTOURN
IO_USSCC
IO_CSSCC
IO_CODTIN
IO_CODINT
IO_CODEMB
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 46

47.  Packings

Packings
Overview / Database
► The packing identity cards managed by the warehouse are referenced in a dedicated table (TB_EMB). This
table is normally filled by G.O.L.D. Central, via the "Article" interface.
► Theoretically, every packing has an associated article code, although it is possible to create locally
packing IDs on G.O.L.D. STOCK.
► The packing internal code is used etc
- In the Article ID management screen
- In the packing management screens: screenshot, account display etc.
► The packing article code is used etc
- In the stock display screens
- In the movements uploaded to G.O.L.D. CENTRAL
► TB_EMB
This table contains the characteristics belonging to a packing: coding, physical characteristics,
reference of the rental company if the packing is rented etc.
► TB_ETLO
This table allows you to define extra packing to be used during the lot preparation (i.e. moreover
support packing parameterised from elsewhere)
► The following are the related management screens:
PMSAgrEmballageManager / Update: Packing management
PMSEmbParTypLotManager: Packing management by lot type
Other tables linked to the packings
► TB_CTAGR
Table allowing the listing of the "packing account" (entry/exit movements) by third party.
► TB_EMBIO
Table allowing you to store in a temporarily manner movements concerning packings, before
recopying them in the common reception or shipping movement tables.
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 47

48. Dangerous goods (D.G.)

0, n
1.1
1,1
0,n
1,n
ONU
1,1
UN codes
TB_LIBONU
Long descriptions
of U.N. codes
0,1
0,n
1,n
0,n
1,1
PLE
TB_ONU
Danger
groups
LANGUES
Languages
0,n
0,n
0,1
PLT
1,n
1,1
CLD
0,n
0,1
0,n
Categories
of transport
and limited weight
Danger classes
0,n
1,1
Packing
groups
TB_ART
Articles
0,n
0,1
0,n
0,3
0,n
0,1
0,n
0,1
0,n
0,n
1,1
1,n
RG_GRPCP1
RG_GRPCP2
Storage
sections
DRB
1,1
TB_REGCP
Compatibility rules
of D.G.
ON_DNGTRA
0,1
Compatibility
groups
GCP
1,n
GEM
LB_ONU
LB_LIBELLE
LB_LANGUE
0,n
QRB
1,n
1,n
0,n
DEP
Limited quantity
by depot and storage cat.
CLS
Storage
classes
MAV
Active materials
QTL
Limited quantities
PRS
Presentation
PLM
Maximum weight for
orange panels
RTU
Tunnel restrictions
TB_ARTPRQPPD
Risk and prudence
phrases
1,1
0,n
PPD
Caution phrases
PRQ
Risk phrases
PR_DONORD
PR_CPROIN
PR_ARPROM
PR_ILOGIS
PR_TYPE
PR_CODE
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 48

49.  Dangerous goods

Dangerous goods
Overview
► The management of dangerous products in G.O.L.D Stock is based on an international nomenclature,
called UN norm. The data is described in a table, (Table A) which defines the management rules applicable
to the different products in terms of transport, packing etc.
► This table is reproduced in the table TB_ONU: each record in this table corresponds to a "danger group"
code and to a line of the table A.
► All dangerous goods must refer to a danger group code. The information related to the dangerous goods
will be stored etc
- partly in the article ID (TB_ART): storage class, restriction tunnels etc.
- partly in the danger group (TB_ONU) referenced by the article ID
► TB_ONU
As it is not indicated by its name, this table stores the "danger groups" (A record by line of the table
A). It is the general parameter table ONU which stores the UN codes.
► TB_LIBONU
This table must have been added to store the descriptions related to the UN codes, too long for the
parameter description format
► TB_REGCP
This table defines the dangerous goods compatibility matrix, in terms of transport.
► TB_ARTPRQPPD
This table contains the list of "risk phrases" and the list of "caution phrases" (instructions appearing
on the D.G. documents)
► Besides the article ID management screen, the D.G data is managed using the following screens:
PMSGdbMatiereDangerManager / CreateUpdate: Danger group management TB_ONU
PMSGdbGstLibONUManager: UN code description management TB_LIBONU
PMSGdbSaisieRegleCPManager: Compatibility rules of D.G. TB_REGCP
PMSGdbAffectPRisqPrudManager: Allocation of the C.P. and P.P. to an article TB_ARTPRQPPD
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 49

50. Picking

TB_ART
Articles
TB_ADRESS
Warehouse address
0,n
0,1
1,1
1,1
TB_STAPIC
Stock statuses
Picking
0, n
1,1
1,n
1,1
TB_PICK
Picking allocations
TB_STATUT
Stock statuses
0,n
0,n
1, n
SP_ADRCLI
SP_CLASTA
SP_CODSTA
1
2
TB_REPI
Reallocation
Picking
1,1
1,1
RI_NSQRPI
RP_ADRPIC
0,1
TB_EUMS
S.H.U.
Headers
1,1
0,n
TB_GRPAFPICK
Automatic allocation
groups
at the picking
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1
Old address
2
New address
TB_ZOP
Preparation areas
DEP
Depots
CAD
Address classes
CLP
Preparation classes
UP
PU code
AP_DEPOT
AP_GRPAFF
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 50

51.  Picking

Picking
General
► Among the different preparation methods, the most common is the one which uses the permanent picking
addresses. G.O.L.D. STOCK offers different tools to notify picking assignments, i.e. to establish links between
articles and addresses of shops dedicated to this use.
► The system allows you to define an address by product-LV and - if needed - by Stock status.
► The allocation operation is accompanied by the notification of two thresholds (minimum and maximum)
which depends on the replenishment process.
► TB_PICK
This table contains the definitions of picking allocations : Article-address link, thresholds, picking
address class. Caution, it is only static data: the picking stock, as well as its different counters
(Ongoing, Reserved, etc.) are managed in "SHU" type structures (see later)
► TB_STAPICK
This table contains the possible stock statutes associated with a picking allocation
► TB_REPI
Table used by the picking reallocation process (it contains the definition of reallocation to be carried
out)
► TB_GRPAFPICK
Automatic allocation process parameterisation table
► Several screens allow you to manage the allocation / reallocation operations:
PMSGdbArticlePickingManager / Update: Picking allocation management
PMSGdbReimplantationManager /AideImplantationManager /DesaffectationPickingManager: Picking
address reallocation tools
PMSGdbAideImplantationManager: Allocation group parameterisation
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 51

52. Third parties

1,1
0,n
1,1
0,n
1,1
0,n
TB_INTER
Third parties
1,1
0,n
1,1
0,n
TIN
Third party types
CLA
Third party classes
CLE
Shipment classes
CLP
Preparation classes
STT
Third party statuses
etc
IR_TYPINT
IR_CODINT
0,n
1,1
TB_LIEFONC
Global locations
LF_TYPINT
LF_CODINT
LF_NUMADR
TB_HINTER
Third parties
(H)
HI_TYPINT
HI_CODINT
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 52

53.  Third parties

Third parties
General
► The different third parties of the warehouse are references in the STOCK database:
- "Origin" third party: Suppliers, workshops, other warehouses, etc.
- "Consignee" third party: Customers, workshops, other warehouses
- Carriers
- Customs authorities
► The identity cards of the third parties are usually transmitted by the Level 3 application, but STOCK also
allows to manage them locally.
► The definition of Origin/Consignee third parties can use a hierarchy at two levels: Third parties and
Global locations. When this is the case, the third party can represent a company, and the Global locations its
different sites (factories, warehouses, etc.)
► TB_INTER
This table contains the 4 third party types: Origin, Consignee, Carrier and Customs Authority
► TB_LIEFONC
This table contains the possible variations of Origin & Consignee third party in Global locations
► The associated management screens are the following:
PMSGdbInterlocuteurManager / Update: Third party management
PMSGdbLieFoncManager / CreateUpdate: Global location management
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 53

54. Alcohol parameterisation

1,1
0,1
TB_FAMREG
Excise families
1,n
0,n
1,1
0,n
1,n
ACC
Excise duty type
MCA
Excise calculation mode
FR_CODFAM
1,1
0,1
TB_ART
Articles
TB_REGIE
Excise codes
0,n
RG_CREGIE
0,1
0,n
0,1
0,n
0,1
0,n
TB_INTER
Third party
CLE
0,1
End-of-year closing types
0,n
VIN
Alcohol tax systems
CLR
Wine colours
PAY
Country of origin
ALC
Alcohol approval
SEM
Alcohol stamp statuses
MAE
Stamp cancellation reasons
TAL
Alcohol movement types
MAT
Stamping machine
TMV
Alcohol movement documents
PEA
Alcohol report parameters
TB_PARCODNC
Alcohol nomenclature
TB_DAExxx
< 15 Tables EMCS >
Ongoing Development
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 54

55.  Alcohol parameterisation

Alcohol parameterisation
Excise Families and Codes
► The excise families and codes allow you to define the taxation types on alcohol. These two informations
are referenced at the level of the article ID
► TB_FAMREG and TB_REGIE
These two tables contain the "Excise" data in the form of a "Header - Lines" type structure
► Update Screens
PMSAlcRegieAlcoolManager: Alcohol family management
PMSAlcRegieUpdate: Alcohol family creation / modification
Other parameters
► Many tables of general parameters are used to describe the alcohol parameterisation.
Caution: do not take into account the related tables to the EMCS (tables TB_DAExxx).
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 55

56. Preparation parameterisation: PPG

1,1
0,n
1,1
0,n
1,1
0,n
TB_GPPPAR
Parameterisation
of PPG
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,n
PRO
Order originators
MAC
Routing mode
CLP
Preparation classes
FPA
Preparation families
PU
Preparation unit
URG
Urgency
TB_ZOP
Preparation areas
GG_DONORD
GG_CODMAC
GG_ZPREPI
GG_CLPREP
GG_CODFPA
GG_CODEUP
1,1
1,1
MRG
Grouping modes
TLO
Preparation lot types
PMO
Packing modes
PRT
Preparation document types
0,n
1,1
TB_GPPDEF
Definition
of PPG
0,n
1,1
0,n
1,1
0,n
GD_CODGPP
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 56

57.  Preparation parameterisation: PPG

Preparation parameterisation: PPG
General
► The Preparation parameter groups (PPG) allow you to define the main rules of the detail preparation
(Picking) according to the range of criteria dependent on the articles, third parties, configuration of the
deposit etc.
► TB_GPPDEF
This table contains the PPG groups and the preparation rules that are associated to them
► TB_GPPPAR
This table contains the parameterisation definitions:
(OO + PU + Urgency + etc.) PPG
► Two screens dedicated to the PPG management :
PMSGdbGPPManager / Update: PPG management
PMSGdbParamGPPManager: PPG parameterisation management
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 57

58. Preparation parameterisation: Other parameters

FIFO rules
TB_REGFIE
FIFO rules
Headers
0,3
TB_ART
Articles
1,n
FF_REGFIF
1,n
1,1
1,1
0,n
TB_REGFIL
FIFO rules
Lines
0,1
TFI
Indicators types
0,n
TB_CORIND
Traceability indicators
0,n
TB_CLASTA
Stock status classes
0,1
FG_REGFIF
FG_NUMORD
Preparation ranges
GAM
Types of combined lots
Preparation ranges
TB_TLOCOM
TLO combined
1,n
1,1
0,n
1,1
0,n
1,1
OPG
TLO
Lot types
Range operations
1,n
Messages on DN
1,n
OPE
Operations
TB_MESSD
Messages in the
shipment documents
MD_LANG
MD_CODMESS
MD_NUMLIG
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 58

59.  Preparation parameterisation: Other parameters

Preparation parameterisation: Other parameters
FIFO rules
► The "FIFO rules" allow you to define the organised sequence of FIFO criteria used in the processes of
readied-pallet, replenishment and floating picking
► These criteria can be: Creation date / Quantity / Traceability indicator(s) / Stock status(es)
► The rules are referenced by the article ID
► TB_REGFIE and TB_REGFIL
The criteria are defined in a "Header – Lines" type structure.
► Rule management screens:
PMSGdbRegleFIFOEnteteManager / CreateUpdate: FIFO rule management
PMSGdbRegleFIFOLigneManager: FIFO rule line management
Preparation ranges (and operations)
► This parameterisation concerns the manufacturing operations carried out at the end of preparation (not to
be confused with the traceability ranges). He uses only parameter tables (general parameters and operating
parameters)
TLO combined
► This parameterisation allows you to define the associations of "Lot types" (i.e.: pallet bases) used in the
detail preparation
► Rule management screens:
PMSGdbGestTLOCombiManager / CreateUpdate: Combined TLO management
Messages on DN
► This table contains descriptions which can be modified on various shipping documents. Manual
management.
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 59

60. Distribution parameterisation (1/2)

0,n
0,n
0,n
0,n
0,n
TB_MODPRE
Preparation mode
determination
TST
Order types
0,n
0,n
TB_ART
Articles
0,n
0,n
0,n
0,n
MP_DEPOT
MP_TYPCDE
MP_CFAMIN
MP_DONORD
MP_CPROIN
MP_ARPROM
MP_ILOGIS
MP_CLTIER
MP_TYPINT
MP_CODINT
CLA
Third party classes
TB_INTER
Third parties
DEP
Depots
0,n
MPR
Depots
TB_FAM
Article families
0,n
1,n
DEP
Preparation modes
0,n
0,n
TB_FAM
Article families
0,n
TB_ART
Articles
0,n
0,n
TB_FAMREP
Families – distribution
work sites
associations
0,n
1,n
0,n
TB_SUPTIER
Lot type by
third parties
and work site
1,n
0,n
0,n
CLA
Third party classes
0,n
TB_INTER
Third parties
0,n
TB_ZOP
Prep. areas, Work sites
0,n
FR_DEPOT
FR_DONORD
FR_CPROIN
FR_ARPROM
FR_ILOGIS
FR_CFAMIN
1,n
TB_ZOP
Prep. areas, Work sites
ST_CLTIER
ST_TYPINT
ST_CODINT
ST_ZONREP
ST_TYPSUP
0,n
TLO
Lot types
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 60

61. Distribution parameterisation (2/2)

0,n
1,n
TB_GRPTIER
Third party groups
for distribution
0,n
0,n
CLA
Third party classes
0,n
TB_INTER
Third parties
0,n
TB_FAM
Article families
0,n
TB_ART
Articles
GT_GROUPE
GT_CLTIER
GT_TYPINT
GT_CODINT
GT_TYPENR
0,n
1,n
TB_GRPART
Article groups
for distribution
0,n
GA_GROUPE
GA_CFAMIN
GA_DONORD
GA_CPROIN
GA_ARPROM
GA_ILOGIS
GA_TYPENR
1,1
1,1
TB_GRPASSO
Third party groups Article groups
associations
GS_GRPTIER
GS_GRPART
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 61

62. Stock classes and statuses

TB_CLASTA
Stock
stock statuses
CS_CLASTA
1,n
1,1
1,1
TB_STAEMP
Stock statuses
Location
1,1
TB_STAPIC
Stock statuses
Picking
1,1
TB_STAUMS
Stock statuses
SHU
0,n
TB_STATUT
Stock statuses
0,n
0,n
ST_CLASTA
ST_CODSTA
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 62

63. Article / Third party basic data

TB_ART
Articles
0,n
1,n
TB_DLCEXP
Last
UBD shipped
1,n
0,n
TB_INTER
Third parties
0,n
TB_INTER
Third parties
DX_TYPINT
DX_CODINT
DX_DONORD
DX_CPROIN
DX_ARPROM
DX_ILOGIS
TB_ART
Articles
0,n
1,n
TB_RFIFO
FIFO check by
article and supplier
1,n
FI_FOURN
FI_DONORD
FI_CPROIN
FI_ARPROM
FI_ILOGIS
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 63

64. Label module

Parameterisation
0,n
LAB
Label codes
TB_ETIFAM
Label module
Families
1,n
1,n
1,1
1,1
CODFAM
1,1
TB_ETISQL
Label module
SQL Queries
TB_ETIETI
Label module
Labels - Headers
1,n
SQ_CODFAM
SQ_CODSEL
SQ_NUMLIG
0,1
CODFAM
CODETI
1,1
1,n
TB_ETILIG
Label module
Labels - Lines
0,1
0,1
1,n
1,n
CODFAM
CODETI
NUMLIG
Data (Labels to print)
TB_ETICON
Label module
Conditions - Headers
CODFAM
NUCOND
1,1
TB_ETILLC
Label module
Conditions - Lines
1,n
TB_ETIINT
Label module
Interfaces
1,1
CODFAM
NUCOND
NULCON
TB_ETILCO
Label module
Conditions - Lines
NUMGRP
NUMBER
CODFAM
NULCON
1,n
TB_ETIDAT
Label module
Data Dictionary
1,n
TB_ETIVAR
Label module
Interface variables
CODFAM
CODVAR
CODFAM
CODATA
TB_ETICAL
Label module
Calculation formulae
1,n
1,n
0,1
TB_ETILCA
Label module
Calculation lines
1,n
CODFAM
CODCAL
1,1
CODFAM
CODCAL
LIGLCA
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 64

65. Traceability - Parameters

TB_TRKTABENT
Traceability parameters
Tables
1,n
1,1
1,1
1,n
LANGUES
Languages
1,n
LANGUES
Languages
TL_CODTAB
TL_LANGUE
TE_CODTAB
0,n
TB_TRKTABLIB
Traceability parameters
Table descriptions
1,1
TB_TRKPOSENT
Traceability parameters
Table entries
PE_CODTAB
PE_CODPOS
1,n
1,1
TB_TRKPOSLIB
Traceability parameters
Table entry descriptions
1,1
PL_CODTAB
PL_CODPOS
PL_LANGUE
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 65

66. Traceability - Indicators

0,n
TB_TRKGAMIND
Range
0,n
Indicators
1,1
1,n
1,n
TB_TRKNATIND
1,1
Indicator types
1,n
0,1
TB_TRKINDENT
"TRACK" indicators
0,1
1,n
TB_CORIND
1,n
"STOCK" indicators
IE_CODITR
CR_TYPIND
CR_CODITR
NA_CODNIN
1,1
TB_TRKINDLIB
TB_TRKNATIND_TRA
Types Descriptions
1,1
1,n
1,1
LANGUES
Languages
TRACK indicators
Descriptions
1,n
TNINCODNIN
LANGUAGE
IL_CODITR
IL_LANGUE
TB_TRKCTLENT
TB_TRKCTLENT_TRA
Ctl / Headers descriptions 1,1
1,n
Indicator checks
Headers
0,n
1,n
1,1
0,1
CE_CONTIT
TCTECONTIT
LANGUAGE
LANGUES
Languages
1,1
TB_TRKCTLLIG
TB_TRKCTLLIG_TRA
Ctl / Line descriptions
1,n
1,1
LANGUES
Languages
TCTLCONTIT
TCTLPARAPP
LANGUAGE
1,n
Indicator checks
Lines
1,1
0,n
CL_CONTIT
CL_PARAPP
1,1
TB_TRKVALPAR
Parameters
of indicators
1,1
VA_CODGAM
VA_CODITR
VA_CONTIT
VA_PARAPP
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 66

67. Traceability - Ranges

PRC
Process
O.O.s
PRO
0,n
0,n
0,n
TTI
Third party types
0,n
TB_INTER
1,n
0,n
0,n
TB_TRKGROART
Article groups
1
Third parties
2
GR_CODGRO
1,1
TB_TRKGROART_TRA
Group descriptions
1,n
TGROCODGRO
LANGUAGE
1,1
0,n
Sites
LANGUES
Languages
0,n
0,n
TB_ART
1
2
Articles
0,1
1,1
1,1
1,1
0,1
1,1
0,1
1,1
0,1
TB_TRKPARGAM
Parameterisation
Indicators
1,1
1
Capture site & third party
2
Origin or consignee site & third party
TB_TRKGAMME_TRA
Range descriptions
1,n
1,1
PA_CODPRC
PA_CODSIC
PA_CODGRO
PA_CODDOR
PA_CODART
PA_CODTTI
PA_CODTIE
PA_CODSIA
1,n
TB_TRKGAMME
1,n
Traceability ranges
1,1
1,1
TGAMCODGAM
LANGUAGE
GA_CODGAM
1,n
TB_TRKGAMIND
LANGUES
Languages
Range
0,n
0,n
Indicators
1,1
1,1
TB_TRKVALPAR
Parameters
of indicators
GI_CODGAM
GI_CODITR
1,n
TB_TRKINDENT
TRACK indicators
0,1
TB_TRKCTLENT
Indicator checks
Headers
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 67

68. Basic consignments

TB_ERDV
Prepared consignments
Headers
1,1
0,1
0,n
0,n
TB_BERDV
Basic consignments
Headers
1,1
1
DEP
Depots
0,n
TB_INTER
Third parties
0,n
TB_QUAI
Docks
0,1
BR_NUMARR
1,n
0,n
0,n
1,1
TB_LQRDV
Prepared consignments
Dock lines
0,1
0,n
TB_BLQRDV
Basic consignments
Dock lines
1,1
BL_NUMARR
BL_ADRLQU
1,1
TB_FRDV
Prepared consignments
Suppliers
1,1
0,1
0,n
TB_BFRDV
Basic consignments
Suppliers
2
TB_INTER
Third parties
0,n
1,1
0,n
DST
Consignee types
BF_NUMARR
BF_TYPINT
BF_CODINT
1
Carrier
2
supplier
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 68

69. Prepared consignments

Status
SAR
Delay charging
IRA
0,n
1,1
1,1
0,n
0,n
1,1
TB_ERDV
Prepared consignments
Headers
0,1
1,1
1
DEP
Depots
TB_INTER
Third parties
0,n
TB_QUAI
Docks
0,n
0,n
0,n
1,n
0,n
MA_NUMARR
--------------MA_NUMARH
0,n
1,1
TB_LQRDV
Prepared consignments
Dock lines
1,1
TB_PLOREC
Entered seals
in reception
LA_NUMARR
LA_ADRLQU
1,1
PO_NUMARR
PO_NUMPLO
1,1
TB_FRDV
Prepared consignments
Suppliers
2
1,1
DST
Consignee types
MF_NUMARR
MF_TYPINT
MF_CODINT
1,1
1,1
0,n
TB_EREC
AGRN - Headers
0,1
TB_EAVIEX
SN - Headers
0,n
TB_STATUT
Stock statuses
0,1
0,1
ML_NUMARR
ML_NUMORC
TB_INTER
Third parties
0,n
0,n
TB_LRDV
Prepared consignments
Lines
1,1
1
Carrier
2
Supplier
(H)
TB_HPLOREC
Prepared cons.: Seals
HO_NUMARR
HO_NUMPLO
(H)
TB_HERDV
Prepared cons.: Headers
HA_NUMARH
(H)
TB_HFRDV
Prepared cons.: Suppliers
HF_NUMARH
HF_CODINT
HF_TYPINT
(H)
TB_HLRDV
Prepared cons.: Lines
HL_NUMARH
HL_NUMORC
(H)
TB_HLQRDV
Prepared cons.: Dock lines
HQ_NUMARR
HQ_ADRLQU
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 69

70. Advanced Goods Receiving Notes – General diagram

TB_EREC
AGRN Headers
1,n
OE_NUMORC
1,1
TB_LREC
AGRN Lines
0,n
OL_NUMORC
OL_NLIORC
1,1
TB_RREC
AGRN Refusals
OR_NUMORC
OR_NLIORC
TB_HEREC
AGRN Headers
(H)
HO_NUMORC
TB_HLREC
AGRN Lines
(H)
HL_NUMORC
HL_NLIORC
TB_HRREC
AGRN Refusals
(H)
HW_NUMORC
HW_NLIORC
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 70

71. Advanced goods receiving notes - Detail

1,1
1,1
1
2
1,1
0,n
0,n
0,1
0,1
0,1
TB_EREC
AGRN Headers
0,n
0,n
1,1
1,1
TB_INTER
Third parties
1,1
1,1
TB_LIEFONC
Global locations
TB_LREC
AGRN Lines
3
4
5
6
0,n
0,n
1,1
0,1
DEP
7
8
9
10
Depots
0,n
Depots
TB_ART
Articles
0,n
0,n
TB_INTER
Third parties
0,n
0,1
0,n
DEP
0,n
TB_STATUT
Stock statuses
0,n
0,1
0,n
0,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
TB_ZNS
Warehouse area
TB_STATUT
Stock statuses
PRO
PRO
TOR
TST
SER
O.O. codes
Owners
AGRN types
Stock types
Header statuses
1
Supplier
2
Carrier
3
Depot
4
Origin depot
5
End depot
6
Reception depot
7
Expected article
8
Delivered article
9
Supplier
10 Customer, if customer return
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 71

72. Shipping note – General diagram

TB_EAVIEX
Shipping note
Headers
1,n
0,n
EV_NUMAE
1,1
1,1
TB_LAVIEX
Shipping note
Lines
TB_VLAVIEX
SN distribution
for allotment
LV_NUMAE
LV_NLIGAE
0,n
(see Allotment)
1,1
TB_TAVIEX
Shipping note
Traceability
1,n
1,n
TB_CORIND
Traceability indicator
STOCK
TV_NUMAE
TV_NLIGAE
TB_HEAVIEX
Shipping note
Headers
(H)
HE_BDLFOU
HE_FOURN
TB_HLAVIEX
Shipping note
Lines
(H)
HV_NUMAE
HV_NLIGAE
TB_HTAVIEX
Shipping note
Traceability
(H)
H2_NUMAE
H2_NLIGAE
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 72

73. Shipping note - Detail

1,1
0,n
1,1
TB_EAVIEX
Shipping note
Headers
1
DEP
TB_INTER
Third parties
1,n
1,1
1,n
Depots
REP
Status
0,1
TB_LRDV
Prepared consignments
Lines
1,n
Supplier Code
Supplier order no.
DN no.
0,1
1,1
1,n
TB_EREC
AGRN Headers
1,1
1,n
1,n
1,1
1,1
1,1
1,n
1,1
0,n
0,1
1,1
TB_LAVIEX
Shipping note
Lines
0,1
2
3
4
0,n
0,n
5
DEP
1,n
TB_LREC
AGRN Lines
1,1
Depots
TB_INTER
Third parties
TB_ART
Articles
0,n
0,1
0,1
Supplier Code
Supplier order no.
DN no.
Article code
1,n
TB_STATUT
Stock statuses
1,n
TB_EMB
Packing
0,1
TB_EUMS
SHU - Headers
0,1
TB_CUMS
SHU - Package
0,1
0,1
1
Supplier
2
Consignee
3
Ordered article
4
Delivered article
5
Base code
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 73

74. Reception (Palletisation) – General diagram

TB_ERDV
Prepared consignments
Headers
0,n
1,n
1,1
1,1
TB_LRDV
Prepared consignments
Lines
0,n
0,1
ES_NUMARR
1,n
1,1
1,1
TB_ESLREC
Palletisation
Headers
1,1
TB_BLSLREC
Palletisation
DN number
BS_NUMARR
BS_NUMORC
0,n
1,1
1,1
0,n
TB_LSLREC
Palletisation
Lines
1,n
LS_NUMARR
LS_IDLARR
TB_EREC
AGRN Headers
0,n
1,1
TB_EMBSLREC
Palletisation
Additional packing
1,n
1,1
1,1
1,1
0,n
0,n
TB_DSLREC
Palletisation
Line detail
PS_NUMARR
PS_IDLARR
PS_CODNCE
1,1
TB_SSLREC
Palletisation
Stock statuses
SS_NUMARR
SS_IDLARR
SS_CLASTA
SS_CODSTA
DS_NUMARR
DS_IDLARR
DS_NLIDET
0,n
TB_LREC
AGRN Lines
1,1
TB_TSLREC
Palletisation
Traceability
TS_NUMARR
TS_IDLARR
TS_NLIDET
TS_TYPIND
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 74

75. Reception (Palletisation) – Detail

0,1
0,n
TB_ESLREC
Palletisation
Headers
1,1
0,n
1,1
0,n
1,1
0,n
1,1
1,1
1,1
1,1
1,1
1,1
TB_LSLREC
Palletisation
Lines
1
2
3
4
5
6
0,n
0,n
Sta: Pal. P.
TRA
Trsp modes
TB_DSLREC
Palletisation
Line detail
1,1
0,n
TB_ART
Articles
0,n
TB_STATUT
Stock statuses
TB_ADRESS
Store Addresses
TB_SSLREC
Palletisation
Stock statuses
0,n
TB_DOSUMS
Files
0,n
TB_CORIND
Traceability ind.
0,1
0,n
0,n
0,n
0,1
0,n
0,1
0,n
0,1
0,n
8
SEP
1,1
0,1
1,1
Depots
0,n
0,n
7
DEP
0,n
1,1
1,1
TB_EUMS
SHU - Headers
TB_STATUT
Stock statuses
SLP
Sta: Pal. L.
TEA
EAN types
STK
Storage rules
MRR
Refusal reasons
CEI
Mvt. codes
0,n
TB_INTER
Third parties
0,n
TB_MISS
Tasks
TB_TSLREC
Palletisation
Traceability
1,n
1
SHU checked-in
2
Original SHU X-Ref.
3
Pivot address
4
Mini address to search
5
Max. address to search
6
Storage area
7
Consignee
8
Link by plan no.
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 75

76. Reception - Various

Administrative Reception
0,n
TB_ERDV
Prepared consignments
Headers
0,n
TB_EREC
AGRN Headers
0,1
TB_EUMS
SHU
Headers
1,1
TB_RUMS
SHU checked-in
Administratively
1,1
1,1
1,1
1,n
EDI
Progress statuses
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 76

77. Stock structure – General diagram

1
TB_EUMS
SHU
Headers
2
0,n
UE_USSCC
1,n
1,1
TB_PLBUMS
SHU
Seals
1,1
TB_CUMS
SHU
Package
1,n
1,1
TB_EMBUMS
SHU
Packing
5
PL_USSCC
PL_CSSCC
PL_NPLOMB
UC_USSCC
UC_CSSCC
1,n
1,1
UL_USSCC
UL_CSSCC
UL_NUMLIG
UM_USSCC
UM_CSSCC
UM_CODEMB
UM_CODSQE
UM_CODNCE
UM_CODNCEF
TB_LCUMS
SHU
Lines
3
4
0,n
0,n
1,1
0,1
1,n
TB_STAUMS
SHU
Stock statuses
1,1
TB_TRAUMS
SHU
Traceability
1
Group SHU
2
Replenishment
3
Picking source
4
Merge source
5
Merge source
0,n
0,1
Article no.
(If series no.)
UT_NUMERO
UT_USSCC
UT_CSSCC
UT_NUMLIG
UT_TYPIND : "STOCK" indicator
UT_CODITR : "TRACK" indicator
SU_USSCC
SU_CSSCC
SU_NUMLIG
SU_CLASTA
SU_CODSTA
TB_DOSUMS
SHU
Files
4
DU_NUMDOS
TB_HEUMS
SHU : Headers
TB_HPLBUMS
SHU : Seals
(H)
(H)
TB_HCUMS
SHU : Package
TB_HTRAUMS
SHU : Traceability
(H)
(H)
TB_HLCUMS
SHU : Lines
(H)
(H)
TB_HSTAUMS
SHU : Stock statuses
TB_HEMBUMS
SHU : Packing
TB_HDOSUMS
SHU : Files
(H)
(H)
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 77

78. Stock structure – Detail (1/3)

1,1
1,1
0,1
0,1
0,1
0,1
TB_EUMS
SHU
Headers
0,1
1
2
3
3
3
4
5
0,n
0,n
0,n
0,n
0,n
0,n
TB_EMB
Packing
0,n
0,1
0,n
1,1
0,n
0,1
0,n
1,1
0,n
1,1
0,n
0,n
Current address
2
Destination address
3
If reserved to customer
4
If readied/prepared SHU
5
Support packing
Third party types
TB_LOTPR
Preparation lots
1,1
5
TIN
0,n
0,n
0,1
TB_INTER
Third parties
TB_LTOUR
Prep. routes - Lines
1,1
TB_CUMS
SHU
Package
TB_ADRESS
Store Addresses
1
DEP
Depots
STP
SHU statuses
SMP
Task / SHU statuses
SPU
Preparation statuses
TEA
EAN code types
TSU
SHU stock types
PRO
Owners
TB_EMB
Packing
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 78

79. Stock structure – Detail (2/3)

1,1
0,n
TB_ART
Articles
0,n
TB_LREC
AGRN - Lines
0,n
TB_ERDV
Prep. cons. Lines
0,n
TB_LCDE
D.O.s - Lines
0,n
TB_LPREP
Preparation lines
0,1
0,1
TB_LCUMS
SHU
Lines
0,1
0,1
1,1
0,n
1,1
0,n
0,1
0,n
DEP
Depots
SYM
XRef symbol codes
TST
Stock types
1,1
0,n
TB_EMB
Packing
0,n
TB_INTER
Third parties
0,1
TB_EMBUMS
SHU
Packing
0,1
0,n
0,1
0,n
1,1
0,n
TB_TRAUMS
SHU
Traceability
1,1
TB_STAUMS
SHU
Stock statuses
1,1
TIN
SQE
NCE
Third party types
Quality statuses
Packing levels
0,n
TB_CORIND
Traceability indic.
0,n
TB_STATUT
Stock statuses
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 79

80. Stock structure – Detail (3/3)

Used by the tools
of Inconsistency detection
TB_EPICK
Stock variances
Reserved & Ongoing
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 80

81. Bulk stock

TB_EUMS
SHU
Headers
1,2
1,n
1,1
TB_CUMS
SHU
Package
1,n
1,1
1,1
TB_LCUMS
SHU
Lines
0,n
TB_ART
Articles
0,n
0,n
1,1
TB_BSTKB
Common stock
1,1
0,n
TB_ADRESS
Store Addresses
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 81

82. Inventories – General diagram

TB_EINV
Inventory plans
Headers
1,1
1,n
1,1
EI_NOINVS
TB_ESTAIN
Inventory statistics
Headers
1,n
0,n
1,n
1,1
TB_SEINV
Inventory plans
Selections
ES_NOINVS
SI_NOINVS
etc.
1,1
1,1
TB_LSTAIN
Inventory statistics
Lines
TB_ARTDEP
Inventoried articles
per depot
LS_NOINVS
etc.
AP_DEPOT
AP_DONORD
AP_CPROIN
AP_ARPROM
AP_ILOGIS
--------------AP_NOINVS
1,1
TB_LINV
Inventory plans
Lines
1,n
TB_DECINV
Inventories
Variances
EC_NOINVS
EC_DEPOT
EC_DONORD
EC_CPROIN
EC_ARPROM
EC_ILOGIS
EC_SSCC
LI_NOINVS
LI_NLIGIN
LI_SUBLIN
1,1
TB_LINAR
Inventory plans
Lines- Articles
1,n
LA_NOINVS
LA_NLIGIN
LA_SUBLIN
LA_NLINAR
1,1
TB_WINV
Bulk picking inventory
(work table)
TB_TRINV
Inventory plans
Traceability
TN_NOINVS
TN_NLIGIN
TN_NLINAR
TN_SUBLIN
TN_TYPIND
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 82

83. Inventories – Detail (1/2)

1,1
0,n
TB_EINV
Inventory plans
Headers
1,1
0,n
1,1
0,n
1,1
0,n
0,1
DEP
Depots
IPR
Inventory types
SORT
Sort types
0,n
TB_FAM
Article families
0,n
TB_SFAM
Sub-families & Segments
0,n
TB_ART
Articles
0,1
TB_SEINV
Inventory plans
Selections
TB_ZNS
Warehouse area
0,1
0,1
0,n
1,1
0,1
1
2
0,n
TZO
TB_ADRESS
Store Addresses
0,n
0,1
TB_EUMS
SHU - Headers
0,n
1,1
0,n
0,1
TB_LINV
Inventory plans
Lines
0,n
0,1
0,1
0,1
0,1
0,1
0,1
3
4
3
4
3
4
Warehouse area types
STP
SHU statuses
SMP
Task / SHU statuses
ADM_USERS
users
0,n
0,n
TB_EMB
Packing
0,n
0,n
0,n
SLI
1
Inventoried address
2
SHU origin address
3
Counting 1
4
Counting 2
Invt. line statuses
0,n
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 83

84. Inventories – Detail (2/2)

0,1
0,n
TB_LCUMS
SHU - Lines
0,n
TB_ART
Articles
1,1
TB_LINAR
Inventory plans
Lines- Articles
0,1
0,1
0,1
0,1
TB_TRINV
Inventory plans
Traceability
1
2
1
2
0,n
0,n
1,1
Invt. line statuses
0,n
TB_CORIND
Traceability indic.
0,n
TB_ADRESS
Store Addresses
0,n
TB_ART
Articles
0,n
0,n
TB_EINV
Inventory plans
Headers
0,n
0,n
TB_ART
Articles
1,1
1,1
TB_ARTDEP
Inventoried articles
per depot
SLI
0,n
1,1
TB_LSTAIN
Inventory statistics
Lines
ADM_USERS
users
0,n
1,1
1,1
0,n
DEP Depots
TB_EUMS
SHU - Headers
1
Counting 1
2
Counting 2
1,1
1,1
0,n
TB_DECINV
Inventories
Variances
1,1
0,n
0,1
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 84

85. Rotating inventories

TB_ITDPER
Parameterisation of
Inventory periods
ID_DEPOT
TB_ITSITU
Inventory status
per Article-Depot
TB_ITHEVT
History of
events
IP_DEPOT
IP_DONORD
IP_CPROIN
IP_ARPROM
IP_ILOGIS
IE_DEPOT
IE_DONORD
IE_CPROIN
IE_ARPROM
IE_ILOGIS
TB_ITPROP
Proposals
of rotating inventories
IP_DEPOT
IP_DONORD
IP_CPROIN
IP_ARPROM
IP_ILOGIS
TB_ITHINV
History of
Rotating inventories
IH_DEPOT
IH_DONORD
IH_CPROIN
IH_ARPROM
IH_ILOGIS
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 85

86. Replenishment

1,1
1
0,1
TB_MISS
Tasks
0,1
TB_EUMS
SHU - Headers
1,1
TB_RURG
Urgent replenishment
1,1
1,1
2
3
0,1
TB_ADRESS
Store Addresses
0,1
1,1
0,1
TB_ART
Articles
0,1
TB_MISS
Tasks
0,1
TB_ART
Articles
RU_NPLAN
1,1
TB_RUPTP
Replenishment outages
1
1,1
RT_NSEQRP
RT_DONORD
RT_CPROIN
RT_ARPROM
RT_ILOGIS
1,1
0,n
TB_RUPREM
Replenishment outages
1,1
Link by plan no.
2
Picking address
3
Deposit address
Depots
0,1
TB_ART
Articles
0,1
TB_ADRESS
Store Addresses
1,1
1
DEP
RR_DEPOT
RR_ADRPIC
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 86

87. Basic routes (1/2)

1
1,1
Carrier
1
TB_INTER
Third parties
1,n
1,1
TB_BTOUR
Basic routes
Headers
0,n
1,1
1,n
0,n
1,1
0,n
1,n
TCD
Served customer types
TTO
Authorised ord. types
TTR
Carrier types
DST
Consignee types
TB_CTOURN
1,1
1,1
TB_CTOUR
Basic routes
Lines
0,n
1,1
TB_INTER
Third parties
0,n
CT_CTOURN
CT_RGTOUR
CT_TYPDST
CT_ZGEOG
GEO
0,n
Geographic zone
1,1
1,1
0,n
1,1
0,n
DEP
Depots
JSM
Days of the week
0,1
TB_QUAI
Docks
0,n
TB_BQTOUR
Basic routes
Docks
0,n
1,1
1,1
0,n
1,1
TB_BLQTOUR
Basic routes
Dock lines
0,n
1,1
0,n
QB_CTOURN
QB_DEPOT
DEP
Depots
TB_ADRESS
Addresses
BQ_DEPOT
BQ_CTOURN
BQ_ADRLQU
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 87

88. Basic routes (2/2)

TB_BLQTOUR
Basic routes
Dock lines
0,n
1,1
TB_DTOUR
Basic routes
Links
Customers - Dock lines
1,n
0,n
TB_ADRESS
Addresses
QD_DEPOT
QD_CTOURN
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 88

89. Prepared routes (1/2)

1
1,1
Carrier
1
TB_INTER
Third parties
1,n
1,1
TB_ETOUR
Prepared routes
Headers
0,n
1,1
0,n
1,1
0,n
1,n
1,1
0,n
1,n
TCD
Served customer types
TTO
Authorised ord. types
TTR
Carrier types
TRA
Transport modes
ET_CTOURN
1,1
1,1
TB_LTOUR
Prepared routes
Lines
LT_CTOURN
LT_RGTOUR
LT_TYPDST
LT_LIVREA
DST
0,n
1,1
Consignee types
TB_INTER
Third parties
0,n
0,1
GEO
Geographic zone
0,n
1,1
0,n
1,1
0,n
DEP
Depots
MST
Route statuses
0,1
TB_QTOUR
Prepared routes
Docks
TB_CLTOUR
Alcohol certificate
1,1
1,1
LT_CTOURN
LT_RGTOUR
TB_QUAI
Docks
0,n
0,n
1,1
1,1
0,n
1,1
TB_LQTOUR
Prepared routes
Dock lines
0,n
1,1
0,n
QT_CTOURN
QT_DEPOT
DEP
Depots
TB_ADRESS
Addresses
QL_DEPOT
QL_CTOURN
QL_ADRLQU
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 89

90. Prepared routes (2/2)

TB_LQTOUR
Prepared routes
Dock lines
0,n
1,1
TB_ATOUR
Prepared routes
Links
Customers - Dock lines
1,n
0,n
TB_ADRESS
Addresses
QA_DEPOT
QA_CTOURN
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 90

91. Delivery orders – General diagram

0,n
TB_ECDE
Delivery orders
Headers
TB_ETOUR
Prepared routes
Headers
0,1
CD_NUMORL
1,n
0,n
1,1
1,1
TB_ALAOL
Blockage of
DO updates
1,1
TB_CMDCOM
Comments
DO - Route
AL_SEQ
CC_NUMORL
CC_CTOURN
(AL_NUMORL)
1,1
TB_LCDE
Delivery orders
Lines
TB_ART
Articles
0,n
0,n
LD_NUMORL
LD_LIGORL
1,1
1,1
TB_RES
Stock
of stock
RE_DONORD
RE_NUMORL
RE_LIGORL
RE_ILOGIS
--------------RE_NUMORL
RE_LIGORL
(H)
TB_HECDE
Delivery orders
Headers
(H)
TB_HLCDE
Delivery orders
Lines
HD_NUMORL
DH_NUMORL
DH_LIGORL
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 91

92. Delivery orders - Detail

0,1
0,n
1,1
1
0,n
0,n
1,1
1
0,n
0,1
TB_ECDE
D.O.s
Headers
3
0,n
1,1
TB_INTER
Third parties
GEO
5
0,n
0,1
6
TB_TRKGAMME
Traceability ranges
TB_ZOP
Prep./Work
site areas
0,n
0,5
TB_LCDE
D.O.s
Lines
TB_ART
Articles
0,n
0,n
TB_LIEFONC
Global locations
TB_INTER
Third parties
4
0,1
Geo. areas
1,1
2
1,1
TB_LTOUR
Prepared routes
Lines
0,n
TB_STATUT
Stock statuses
0,n
TB_CORIND
Traceability ind.
0,5
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
DEP
Depots
SCD
DO statuses
1,1
0,n
1,1
0,n
TST
0,1
Stock types
0,n
TST
1,1
D.O. types
0,n
TBL
1,1
DN types
0,n
PRO
Owners
PRO
Order originators
MAC
Routing modes
CEI
Movement codes
DEP
Depots
SCL
Line statuses
RSA
Service rules
TAR
Normal/Free
FPA
Prep. family
1
Delivered customer
4
Article to be served
2
Invoiced customer
5
Initially ordered, or composed article
3
Final customer (consumer)
6
Distribution work site
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 92

93. Preparation of orders – Estimated lots

1,1
DEP
Depots
0,n
1,1
0,1
1
0,n
TB_ZOP
Prep areas - Work sites
0,n
TB_ADRESS
Store Addresses
0,n
TB_LTOUR
Prep. routes - Lines
0,n
TB_EVAG
Preparation waves
1,1
TB_ESTLOT
Preparation lots
estimated
0,1
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
TAP
Readied/Prepared
PRE
Preparation types
TLO
Lot types
TCP
Load types
1,n
EO_NLOTPR
1,1
TB_ESTLPR
Preparation lines
estimated
1,1
0,n
TB_LCDE
Delivery orders
Lines
EL_NLOTPR
EL_NLIGPR
1
Shipping dock address
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 93

94. Preparation of orders – Actual lots – General diagram

TB_EVAG
Preparation waves
Headers
EV_NUMVAG
1,n
1,1
TB_LOTOP
Preparation lot
of a preparation lot
1,1
0,n
0,n
TB_LOTET
Lot label
1,1
OL_NUMORL
OL_NLOTPR
OL_CODOPE
1,1
LE_NLOTPR
LE_USSCC
TB_LOTPR
Preparation lots
0,1
TB_LOGAR
Lots-Stations links
TB_EUMS
SHU
Headers
1,1
LG_NLOTPR
LG_CODGAR
0,n
LO_NLOTPR
1,n
1,1
TB_LPREP
Preparation lines
LP_NLOTPR
LP_NLIGPR
LP_NCOLIS
0,n
1,1
TB_WANPR
Preparation cancellation
(work table)
TB_TPREP
Preparation lines
Traceability
TC_NLOTPR
TC_NLIGPR
TC_NCOLIS
TC_TYPIND
WA_NSEQPAN
WA_NLOTPR
WA_USSCC
TB_HLOTPR
Preparation lots
(H)
HO_NLOTPR
TB_HLOGAR
Lots-Stations links
TB_HLPREP
Preparation lines
(H)
HP_NLOTPR
HP_NLIGPR
HP_NCOLIS
(H)
HG_NLOTPR
HG_CODGAR
TB_HLOTET
Lot label
(H)
HL_NLOTPR
HL_USSCC
(H)
TB_HTPREP
Preparation lines
Traceability
HC_NLOTPR
HC_NLIGPR
HC_NCOLIS
HC_TYPIND
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 94

95. Distribution

Note: We only present here the specific tables in this process of preparation
TB_EREP
Distribution plans
ER_NUMPLAN
1,n
1,1
TB_BORDREP
Statements
of distribution
0,n
BD_NUMBOR
1,n
1,1
TB_EREPAN
Distribution faults
Headers
1,n
0,1
EA_NUMBOR
EA_USSCC
EA_CSSCC
EA_NUMLIG
TB_LPREP
Preparation lines
1,1
TB_LREPAN
Distribution faults
Lines
1,1
0,n
CEI
Mvt. codes
LA_NUMBOR
LA_USSCC
LA_CSSCC
LA_NUMLIG
LA_CODECA
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 95

96. Allotment (1/2)

Note: We only present here the tables specific to this process of preparation
TB_LAVIEX
Shipping note
Lines
(*) Indirect link
0,n
(*)
1,1
TB_VLAVIEX
SN distribution
for allotment
TB_LCDE
Delivery orders
Lines
0,n
1,1
VL_NUMORL
VL_LIGORL
VL_NCDEFO
VL_BDLFOU
1,1
DEP
0,n
1,1
1,1
TB_ECALLO
Allotment variances
Depots
1
0,n
TB_LCDE
Delivery orders
Lines
1
0,n
TB_INTER
Third parties
0,n
TB_BLSLREC
Palletisation
Supplier DN No.
0,n
TB_ART
Articles
1,1
1,1
1,1
MAC
0,n
Variance codes
AA_NUMORL
AA_LIGORL
(H)
TB_HECALLO
Allotment variances
HA_NUMORL
HA_LIGORL
1
Consignee code
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 96

97. Allotment (2/2)

Allotment audit
TB_EAUDRE
Allotment audit
Headers
1,n
0,n
Supplier
+
Supplier Order No.
0,n
TB_LCUMS
SHU - Lines
1,n
AE_NUMCTR
1,1
TB_LAUDRE
Allotment audit
Lines
1,1
AL_NUMCTR
AL_SSCC
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 97

98. Package allot.

Note: We only present here the tables specific to this process of preparation
1,1
1,1
TB_BORDALO
Statements
Package allot.
1
0,n
TB_ZOP
Prep areas - Work sites
0,n
TB_INTER
Third parties
1,1
SAL
Statement status
0,n
1,n
BE_NUMBOR
BE_NCDEFO
0,1
TB_LPREP
Preparation lines
1
Supplier Code
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 98

99. Transit cross-docking

Note: We only present here the tables specific to this process of preparation
Parameterisation of the transit cross-docking screen
TB_PAQPARAM
Parameterisation
CDK screen
PQ_DEPOT
PQ_FOURN
...
CDK palletisation
TB_SLPAQ
CDK palletisation
Headers
1,n
1,1
TB_EUMS
SHU - Headers
0,1
PQ_DEPOT
PQ_NUMORC
PQ_LIVREA
PQ_NCDEFO
...
1,n
0,1
0,1
TB_LSLPAQ
CDK palletisation
Lines
1,1
0,1
TB_LCUMS
SHU - Lines
LQ_BDLFOU
LQ_LIVREA
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 99

100. Manufacture

Note: We only present here the tables specific to this process of preparation
1,1
1
0,n
TB_ZOP
Prep areas & Work sites
0,n
TB_EUMS
SHU - Headers
0,n
TB_ART
Articles
0,n
TB_ADRESS
Store Addresses
1,1
TB_REINTEG
Reintegration notes
1,1
1,1
2
EG_NUMBR
1
Manufacturing site
2
Destination address
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 100

101. Shipping

1,1
0,n
TB_EPLAUD
Audit Plans: Headers
TB_EUMS
SHU - Headers
1,1
TB_INTER
Third parties
0,n
TB_LPLAUD
Audit Plans: Headers
TB_AUDUMS
SHU audits on dock
0,n
GEO
1,1
TB_ART
Articles
0,n
1,1
1,1
1
2
ADM_USERS
Users
0,n
0,n
AU_NUMCTR
AU_LIGCTR
AU_USSCC
1,1
TB_FERMP
Messages entered
at Doors closing
Geographic zone
1
Prep. clerk
2
Controller
0,n
TB_ETOUR
Prep. routes - Headers
0,n
TB_INTER
Third parties
1,1
0,n
GEO
Geographic zone
DEP
Depots
FR_CTOURN
1,1
0,n
1,1
TB_PLOMB
Seal no. entered
at Doors closing
TB_HPLOMB (H)
Seal no. entered
at Doors closing
0,n
TB_ETOUR
Prep. routes - Headers
0,n
TB_INTER
Third parties
1,1
0,n
GEO
Geographic zone
PB_CTOURN
PB_NPLOMB
HB_CTOURN
HB_NPLOMB
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 101

102. Alcohol

1,1
TB_IMGSTK
Stock image
(Alcohol)
TB_ART
Articles
0,n
1,1
0,n
CLE
Closure types
of exercise
IS_DATSTK
IS_DONORD
IS_CPROIN
IS_ARPROM
IS_ILOGIS
IS_TCLOEX
MAT
Stamping machine
1,n
1,1
TB_MATSAT
Tax stamp by machine
MS_CODMAT
MS_NSATAS
1,n
1,1
1,1
TB_INTER
Third parties
0,n
1,1
0,n
TB_SATAS
Alcohol tax stamps
1,1
0,n
1,1
0,n
0,1
0,n
TB_HSATAS
Alcohol tax stamps
(H)
SEM
Tax stamp statuses
TAL
Alcohol mvt. types
TMV
Document types
of movement
MAE
Cancellation reason
SA_CODMAT
SA_NSATAS
HS_CODMAT
HS_NSATAS
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 102

103. Radio - Fork-lift trucks

0,1
ADM_USERS
Users
0,1
1,1
1,1
1
2
0,n
0,n
1,1
0,n
1,1
0,n
1,1
0,n
1,1
0,n
0,n
TB_CHARI
Fork-lift trucks
TB_ADRESS
Store Addresses
DEP
Depots
SCH
Fork-lift truck statuses
TZD
Types of areas served
MFC
Operating modes
1,1
1,1
TB_CHZI
Fork-lift trucks
Forbidden areas
1,1
TB_ALCH
Fork-lift trucks
Aisles allowed
1,1
TB_CHLOG
Fork-lift trucks
Connections
1,1
TB_CHREV
Fork-lift trucks
Revisions
R_CR_CODCHA
R_CR_DERREV
1,1
TB_MCAR
Fork-lift trucks
Messages to FLT drivers
R_MC_NMESS
R_MC_CODCHA
0,n
0,n
0,n
0,n
Garage address
2
Last position of the fork lift truc
1,1
TB_CHPM
Fork-lift trucks
Authorised dimensions
0,n
1
R_PM_CODCHA
R_PM_GABARI
0,n
0,n
R_ZI_CODCHA
R_ZI_CODDEP
R_ZI_CODZNS
TB_ZNS
Warehouse area
0,n
ADM_USERS
Users
0,n
TB_ZNS
Warehouse area
1,1
R_CL_CODCHA
R_CL_CODCAR
R_CL_DATLOG
Dimensions
0,n
0,n
AU_DEPOT
AU_ZONE
AU_ALLCOR
AU_CODCHA
GAB
R_CH_CODCHA
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 103

104. Radio - Warehouse map (1/2)

1,1
1,1
TB_CZNS
Inter-area costs
1,1
1,1
1
2
1
2
0,n
Depots
0,n
TB_ZNS
Warehouse area
0,n
0,n
1,1
0,n
R_CZ_DEPORI
R_CZ_ZNSORI
R_CZ_DEPDES
R_CZ_ZNSDES
DEP
CIZ
Movement rules
1
Origin
2
Destination
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 104

105. Radio - Warehouse map (2/2)

TB_RSCAL
Aisle specific
cost rules
1,1
1,1
1
2
Warehouse aisles
0,n
1,n
0,1
0,n
R_CA_DEPOT
R_CA_ZONE
R_CA_ALL1
R_CA_ALL2
1,1
CST
0,n
TB_RPASSAGE
Transition rules
1,1
1,1
0,n
1
2
Statutes calculated
0,n
0,n
RE_IDPASS
1,1
TB_DISTALS
Distances
Inter-aisles
1,1
1,1
1
2
TB_ADRESS
Store Addresses
0,n
0,n
DA_ODEPOT
DA_OZONE
DA_OALLEE
DA_DDEPOT
DA_DZONE
DA_DALLEE
DA_OTRAVEEMOD2
DA_DTRAVEEMOD2
TB_INTTR
Transit bays
Warehouse bays
1,n
0,1
1,1
0,n
R_IT_DEPOT
R_IT_ZONE
R_IT_TRAVEE
TB_DISTTRV
Distances
Inter-bays
DT_DEPOT
DT_ZONE
DT_ALLEE
DT_TRAVEE
1,1
0,n
1
Origin
2
Destination
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 105

106. Radio - Tasks

Task statuses
Report statuses
0,n
SMR
1,1
SEM
CRM
0,n
0,n
0,n
TMR
0,n
1
SM_NUMPLAN
SM_NUMSSCC
0,1
2
0,1
0,1
1,1
3
5
6
R_MA_NUMMISS
1,1
1,1
1,1
1,1
b
c
1,1
1,1
0,n
Warehouse area types
d
0,n
GAB
TZO
0,n
TB_MISS
Tasks
1,1
e
0,1
7
f
0,1
8
0,1
0,1
g
0,1
0,n
0,1
g
0,n
0,n
TB_EUMS
SHU - Headers
0,n
0,n
TB_CUMS
SHU – Package
0,n
TB_CUMS
SHU – Package
0,n
TB_INTER
Third parties
0,n
TB_ECDE
D.O.s – Headers
0,n
TB_ZOP
Prep. areas
0,1
0,n
TB_ADRESS
Store Addresses
0,n
0,1
10
TB_CHARI
Fork-lift trucks
0,n
0,1
9
ADM_USERS
Users
TB_AMISS
Tasks to be carried out
1,1
4
1,1
Dimensions
0,n
TB_SELMVS
Movements
to be carried out
1,1
0,n
Task types
a
0,n
0,n
Reports
0,1
0,1
1
Takeaway
6
Group. code
2
Takeaway and deposit 7
Takeaway
3
Task type
8
Deposit
4
Priority code
9
Dependent task
5
Htot
10 Task to release
R_MS_NUMMIS
TB_HMISS
Tasks
(H)
a
Plan no.
e
Takeaway SHU
b
Picking address
f
Occupying SHU
c
Deposit address
g
If readied
d
Planned SHU
R_HS_NUMMIS
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 106

107. Movements (1/3)

TB_MVTIN
Movements
of inventory
MI_NSEQIN
TB_MVTRE
Movements
of reception
MR_NLIGMV
1,n
1,1
TB_TMVTR
Reception mvt.
traceability
TR_NLIGMV
TR_CORIND
TB_MVTEX
Movements
of shipment
TB_HMVTIN
Movements
of inventory
(H)
TB_HMVTRE
Movements
of reception
(H)
TB_HTMVTR (H)
Reception mvt.
traceability
TB_HMVTEX
Movements
of shipment
(H)
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 107

108. Movements (2/3)

TB_MVTAL
Movements
(Alcohol)
MN_NSEQIN
TB_MVTDG
Movements
M.D.
DG_CTOURN
DG_RGTOUR
DG_LIVREA
DG_DONORD
DG_CPROIN
DG_ARPROM
DG_ILOGIS
TB_MVTCHA
Movements
of loading
MC_NUMMVT
TB_MVTRA
Movements
of transport
MT_NOORDRE
MT_DATDEP
TB_HMVTAL
Movements
(Alcohol)
(H)
TB_HMVTDG
Movements
M.D.
(H)
TB_HMVTCHA
Movements
of loading
(H)
TB_HMVTTRA
Movements
of transport
(H)
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 108

109. Movements (3/3)

TB_MVTSER
Movements
of serial no.
NS_DEPOT
NS_DONORD
NS_CPROIN
NS_ARPROM
NS_ILOGIS
NS_CODITR
TB_MVTSOLDOR
Movements
of clearance
MS_NUMORC
MS_NCDEFO
MS_DATSOLD
TB_TRPIC
Picking traces
TP_NSEQTP
TB_EMBIO
Packing movements
(temporary table)
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 109

110. Histories (1/3)

TB_HAPP
History
of readied-pallets
1,1
0,n
TB_ZNS
Warehouse area
HA_DATMVT
HA_ZONE
HA_DEPOT
1,1
TB_HEXP
History
of shipments
0,n
1,1
0,n
DEP
Depots
TB_ETOUR
Prepared routes
Headers
HX_DATMVT
HX_CTOURN
HX_DEPOT
TB_HPRE
History
of preparations
1,1
0,n
TB_ZOP
Preparation areas
and work sites
HP_DATMVT
HP_ZONE
HP_DEPOT
TB_HREC
History
of receptions
1,1
0,n
TB_ZNS
Warehouse area
HP_DATMVT
HP_ZONE
HP_DEPOT
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 110

111. Histories (2/3)

1,1
0,n
ADM_USERS
Users
0,n
TB_ZOP
Prep. and work site areas
1,1
TB_ACTI
Activity
of preparation clerks
AT_DATEPRE
AT_CODPREP
AT_DEPOPRE
AT_ZONEPRE
AT_TYPPERS
AT_TYPACTI
1,1
0,n
1,1
0,n
1,1
DEP
Depots
ACT
Activity types
TAC
Personnel type
0,n
TB_STACD
Statistics
orders
TB_STACLIENT
Statistics
customer
SC_DATMVT
1,1
1
0,n
TB_INTER
Third parties
SL_DATMVT
SL_CLIENT
TB_STAFOURN
Statistics
supplier
TB_STAEX
Statistics
shipping
1,1
3
0,n
TB_STARE
Statistics
reception
TB_STAPE
Statistics
preparation clerks
1,1
0,n
TOR
2
0,n
TB_INTER
Third parties
0,n
ADM_USERS
Users
SX_DATMVT
SX_CTRANS
TB_INTER
Third parties
SF_DATMVT
SF_FOURN
1,1
A.G.R.N. types
SP_DATMVT
SP_CODEMP
SP_STATUT
1,1
1
Customer
2
Carrier
3
Supplier
SR_DATMVT
SR_TYPEOR
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 111

112. Histories (3/3)

1,1
TB_SYCAR
Fork-lift truck driver
FLT activity summary
0,n
ADM_USERS
Users
0,n
TB_CHARI
Fork-lift trucks
0,n
TB_ZNS
Warehouse area
1,1
1,1
R_SA_CODCAR
R_SA_CODCHA
R_SA_DATACT
R_SA_CODDEP
R_SA_CODZON
1,1
TB_SYNPR
Summary
Preparation speed
0,n
ADM_USERS
Users
0,n
TB_ZOP
Prep. and work site areas
0,n
ADM_USERS
Users
0,n
TB_ZOP
Prep. and work site areas
1,1
SP_DATPRE
SP_CODPRE
SP_ZPREPI
1,1
TB_TPSIN
Inventory time
0,n
ADM_USERS
Users
0,n
TB_EINV
Inv. plans – Headers
1,1
TI_DATINV
TI_NOINVS
TI_NLOTVOC
TI_CODINV
1,1
TB_TPSPR
Preparation time
1,1
TP_CODPRE
TP_NLOTPR
1,1
TB_VPREP
Preparation clerk
preparation clerks
0,n
ADM_USERS
Users
0,n
TB_ZOP
Prep. and work site areas
1,1
SP_CODPRE
SP_ZPREPI
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 112

113. STOCK Vocal – Tables

Vocal report history
TB_HVOC
Vocal preparation
report history
NLOTPR
NLIGPR
TB_MANVOC
Missing lots in vocal
DATDEB
HHDEBP
MMDEBP
SSDEBP
CCDEBP
NLOTPR
TYPENR
NLIGPR
TB_HVOCECL
Vocal splitting
report history
TB_HVOCRAM
Collection
report history
DATDEB
HHDEBP +[MM,SS,CC]
HHFINP +[MM,SS,CC]
NLOTPR
ORDECR
TYPENR
NLIGPR
DATDEB
HHDEBP +[MM,SS,CC]
HHFINP +[MM,SS,CC]
NLOTPR
ORDECR
TYPENR
NLIGPR
DEPOT
TB_HVOCALLMG
GM Allotment
report history
NLOTAL
DATEMVT
HHMVT
MMMVT
SSMVT
ORDLIGNE
GM allotted parameterisation
TB_FOUMG
GM allotted associations
Suppliers- Work sites
FG_FOURN
FG_DEPOT
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 113

114. Interfaces L3  L2: Articles and nomenclatures

Interfaces L3 L2: Articles and nomenclatures
Interface tables
ICSARTICLE
Articles
Faults
STOCK Tables
TB_ANOART
Article interface
Faults
TB_ART
Articles
TB_ARTDT
Last updates
IARFLGREL
IARNSEQIART
TB_FAM
Article families
TB_SFAM
Sub-families, segments
TB_EMB
Packing
TB_EAN
Article EAN codes
ICSENTNOM
Nomenclatures
composed
1,n
1,1
ICSDETNOM
Nomenclatures
Components
TB_ANONOME
Nomenclature interface
Faults
ICNSEQ
ICNCEXR
ICNCEXVL
ICNSITE
ICNDEPO
ICNENT
TB_ANONOMD
Nomenclature interface
Faults
TB_NOMENT
Nomenclatures
composed
1,n
1,1
TB_NOMDET
Nomenclatures
Components
ICUSEQ
ICUCEXR
ICUCEXRCO
ICUCEXVLCO
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 114

115. Interfaces L3  L2: Third party

Interfaces L3 L2: Third party
Interface tables
ICSTIERS
Third party
Faults
STOCK Tables
TB_ANOTIERS
Third party
Faults
0,n
TB_INTER
Third parties
0,n
1,1
TB_LIEFONC
Global locations
1,1
ICSADRTIE
Global locations
TB_ANOADRTIE
Third party addresses
Faults
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 115

116. Interfaces L3  L2: Advanced goods receiving notes

Interfaces L3 L2: Advanced goods receiving notes
Interface tables
ICSENTOR
AGRN Headers
Faults
STOCK Tables
TB_ANOENTOR
AGRN headers
Faults
TB_EREC
AGRN Headers
0,n
0,n
1,1
ICSDETOR
AGRN Lines
1,1
TB_ANODETOR
AGRN lines
Faults
TB_LREC
AGRN Lines
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 116

117. Interfaces L3  L2: Delivery and manufacturing orders

Interfaces L3 L2: Delivery and manufacturing orders
Interface tables
ICSDEOL
Delivery orders
Faults
STOCK Tables
TB_ANOOL
DO interface
Faults
IOLFLGREL
IOLNSEQIOL
IT_ECDE
DO Web
Headers
0,n
IE_CEXCDE
TB_ANOCOME
Web DO interface
Header faults
IE_CEXCDE
1,1
TB_ECDE
Delivery orders
Headers
0,n
1,1
IT_LCDE
DO Web
Lines
ID_CINCDE
ICSORDFAB
Manufacturing orders
TB_ANOCOML
Web DO interface
Line faults
TB_LCDE
Delivery orders
Lines
ID_CINCDE
TB_ANOOF
MO interface
Faults
IOFLIGFAB
IOFCINFAB
TB_IMODTNO
Order modification
ticket no.
TM_ORDTYP
TM_ORDNUM
TM_MODTNO
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 117

118. Interfaces L2  L3: Movements (1/2)

Interfaces L2 L3: Movements (1/2)
STOCK Tables
Interface tables
TB_MVTIN
Movements
of inventory
N3_MVTIN
Interface
Inventory movements
MI3DONORD
MI3CPROIN
MI3ILOGIS
TB_MVTRE
Movements
of reception
N3_MVTRE
Interface
Reception movements
MR3DONORD
MR3CPROIN
MR3ARPROM
MR3ILOGIS
N3_MVTEX
Interface
Shipment movements
TB_MVTEX
Movements
of shipment
ME3DONORD
ME3CPROIN
ME3ILOGIS
TB_MVTSD
Portal Interface
Shipment movements
MDTYPMVT
MDDONORD
MDCPROIN
MDILOGIS
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 118

119. Interfaces L2  L3: Movements (2/2)

Interfaces L2 L3: Movements (2/2)
STOCK Tables
Interface tables
TB_ECDE
Delivery orders
Headers
TB_MVTCDE
Interface
Preparation start mvts
CE_NUMCDE
TB_LCDE
Delivery orders
Lines
TB_MVTPR
Interface
Preparation end mvts
MP_NUMCDE
MP_NUMLIG
TB_HMVTCDE (H)
Interface
Preparation start mvts
TB_HMVTPR (H)
Interface
Preparation end mvts
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 119

120. Interfaces L2  L3: Stock image

Interfaces L2 L3: Stock image
TB_STOCK
Interface L2 L3
Stock image
ST_DONORD
ST_CPROIN
ST_ARPROM
ST_ILOGIS
ST_DEPOT
ST_STPALE
ST_DATSTK
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 120

121. Interfaces L2  L3: Shipping note

Interfaces L2 L3: Shipping note
N3_EAVIEX
S.N. interface
Headers
1,n
1,1
N3_LAVIEX
S.N. interface
Lines
0,n
1,1
N3_TAVIEX
S.N. interface
Traceability
N3_HEAVIEX
S.N. interface
Headers
(H)
N3_HLAVIEX
S.N. interface
Lines
(H)
N3_HTAVIEX
S.N. interface
Traceability
(H)
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 121

122. Interfaces L2  L3 : Miscellaneous

Interfaces L2 L3 : Miscellaneous
Other interfaces
N3_ANUAR
Interface
Cancelling articles
N3_DATREL
Interface
Date-back order
AA3CODSIT
AA3DEPOT
AA3DONORD
AA3CPROIN
AA3ILOGIS
N3_MVTSOLDOR
Interface
AGRN balance mvts
DR3CODSIT
DR3DEPOT
DR3DONORD
DR3FOURN
DR3NCDEFO
MS3CODSIT
MS3NCDEFO
MS3NUMORC
Parameterisation and Miscellaneous
TB_PARCHA
Interfaces L3 L2
Field parameterisation
PA_CODTPC
PA_NOMTAB
PA_NOMCHA
TB_ANOINT
Interfaces L3 L2
Faults
AI_NUMANO
AI_NOMINT
TB_TRACOM
Links
Columns-Dictionaries
TL_COLUMN
TL_TABLE
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 122

123. Interfaces TRACK  STOCK: Parameters

Interfaces TRACK STOCK: Parameters
TRACK Tables
Interface tables
STOCK Tables
TRKTABLES
TB_TRKTABENT
Traceability parameters
Tables
TRACK parameters
Tables
TRA_TRKTABLES
TRACK parameters
ISTTABLES
Param. tables TRACK
Tables
1,n
1,1
1,n
LANGUES
Languages
TB_TRKTABLIB
Traceability parameters
Table descriptions
ISTCODTAB
Table descriptions
TRKPOSTES
TRACK parameters
Table entries
TRA_TRKPOSTES
TRACK parameters
Entry descriptions
1,1
ISTPOSTES
Param. tables TRACK
Table entries
ISOCODTAB
ISOCODPOS
1,1
1,n
TRA_LANG
Languages
TB_TRKPOSENT
Traceability parameters
Table entries
TB_TRKPOSLIB
Traceability parameters
Table entry descriptions
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 123

124. Interfaces TRACK  STOCK: Range

Interfaces TRACK STOCK: Range
TRACK Tables
Interface tables
STOCK Tables
TRKCTLENT
ISTCTLENT
TB_TRKCTLENT
Indicator checks
Ind. chk. interface
Indicator checks
Headers
Headers
Headers
1,n
ISECONTIT
1,1
TRKCTLLIG
ISTCTLLIG
TB_TRKCTLLIG
Indicator checks
Ind. chk. interface
Indicator checks
Lines
Lines
Lines
ISPCONTIT
ISPPARAPP
TRKINDIC
TB_TRKINDENT
TRACK indicators
TRACK indicators
TRA_TRKINDIC
TRACK indicators
ISTINDIC
Interface
TRACK indicators
1,1
1,n
TRA_LANG
Languages
TB_TRKINDLIB
ISICODITR
TRACK indicators
Descriptions
Descriptions
TRKNATIND
Indicator types
TRA_TRKNATIND
Indicator types
ISTNATIND
Interface
Indicator types
1,1
1,n
LANGUES
Languages
TB_TRKNATIND
Indicator types
ISNCODNIN
Descriptions
TRKVALPAR
Parameters
of indicators
ISTVALPAR
Interface
Param. of indicators
TB_TRKVALPAR
Parameters
of indicators
ISVCODGAM
ISVCODITR
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 124

125. Interfaces TRACK  STOCK: Ranges

Interfaces TRACK STOCK: Ranges
TRACK Tables
Interface tables
ISTGAMME
TRKGAMME
Interface
Traceability ranges
TRA_TRKGAMME
Traceability ranges
1,n
STOCK Tables
1,1
1,n
LANGUES
Languages
TB_TRKGAMME
Traceability ranges
ISGCODGAM
Traceability ranges
Descriptions
1,1
TRKGAMIND
ISTGAMIND
TB_TRKGAMIND
Range
Range indicator
Range
Indicators
Indicators
Indicators
ISLCODGAM
ISLCODITR
TRKPARGAM
ISTPARGAM
TB_TRKPARGAM
Parameterisation
Interface
Parameterisation
Indicators
Range parameterisation
Indicators
ISCCODGAM
TRKGROART
Article groups
ISTGROART
Interface
Article groups
TB_TRKGROART
Article groups
ISACODGRO
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 125

126. Interfaces STOCK  TRACK

Interfaces STOCK TRACK
Interface tables
TRACK Tables
IEMENTETE
Interface
Headers
IMENUMMVT
IEMUNLOGI
Interface
Logistic units
TRKUNLOGI:
Logistic units
IMUNUMMVT
IEMRESSOU
Interface
Resources
TRKRESSOU
Resources
IEMRESFIL
TRKRESMER
Interface
Resources:
Relationships
Parent relationships
Captured indicators
TRKRESFIL
Resources:
Child relationships
IMFNUMMVT
Interface
External articles
of resources
IMRNUMMVT
IEMCAPIND
TRKRESART
TRKRESTRA:
Resource traceability
IMINUMMVT
IEMSUPPUL
Interface
LU Deleted
IMSNUMMVT
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 126

127. PICK interfaces

1,1
DEP
0,n
1,1
TB_GPICK
STOCK PICK
Picking addresses
0,n
TB_ZOP
Prep./Work site areas
0,n
TB_ART
Articles
1,1
1,1
1,1
1,1
1
2
3
0,n
TB_ADRESS
Store Addresses
0,n
0,n
GP_DEPOT
GP_ZPREPI
GP_ADRPIC
1
Picking address
2
Start address
3
End address
1,1
DEP
0,n
1,1
1,1
TB_INTPICK
PICK STOCK
Reallocation
4
5
Depots
Depots
TB_ADRESS
Store Addresses
0,n
0,n
1,1
0,n
TB_ART
Articles
0,n
TB_ZOP
Prep./Work site areas
1,1
1,1
CLP
0,n
Preparation classes
IN_ADRPIC
IN_PILE
==========
IN_OLDADR
4
New address
5
Old address
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 127

128. Transport Interfaces (STOCK  TMS)

Transport Interfaces (STOCK TMS)
1,1
0,n
TB_ETOUR
Routes - Headers
0,n
TB_INTER
Third parties
1,1
TB_ENTCHARGE
Loads prepared
Transport
Headers
0,n
1,1
1,1
Geo. areas
DEP
Depots
PRO
Order originators
0,n
0,n
1,n
GEO
EC_NUMSEQ
EC_FLUX
1,1
1,1
0,n
TB_ZOP
Prep./Work site areas
0,n
TB_EUMS
SHU - Headers
1,1
TB_DETCHARGE
Prepared charges
Transport
Lines
1,1
0,n
1,1
0,n
1,1
0,n
PRE
Preparation types
SCG
Processing statuses
TAP
Preparation modes
DC_NUMSEQ
DC_FLUX
TB_HENTCHARGE (H)
Transport charges
Headers
TB_HDETCHARGE (H)
Transport charges
Lines
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 128

129. Transport Interfaces (TMS  STOCK)

Transport Interfaces (TMS STOCK)
1,1
1,1
1,1
1,1
1
2
1
2
0,n
DEP
0,n
0,n
PRO
Order originators
0,n
1,1
0,n
TB_ETOUR
Routes - Headers
0,n
TB_INTER
Third parties
1,1
TB_TMSCHARGE
Interface
TMS STOCK
Depots
0,n
1,1
GEO
Geo. areas
0,n
TB_ZOP
Prep./Work site areas
0,n
TB_EUMS
SHU - Headers
1,1
1,1
0,n
1,1
0,n
1,1
0,n
PRE
Preparation types
STR
Processing statuses
TAP
Preparation modes
TM_FICHIER
TM_FLUX
...
TB_HTMSCHARGE (H)
Interface
TMS STOCK
1
Forec.
2
Receipt
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 129

130. Transport Interfaces (Special AXIODIS)

1,1
0,n
TB_ECDE
D.O.s – Headers
0,n
TB_ETOUR
Routes - Headers
0,n
TB_INTER
Third parties
1,1
1,1
TB_AXIMVT
AXIODIS interface
Km calculated
1
0,n
1,1
1,1
GEO
Geo. areas
DEP
Depots
PRO
Order originators
0,n
0,n
AX_NUMORL
AX_CTOURN
1,1
0,n
TB_ETOUR
Routes - Headers
0,n
TB_LTOUR
Routes - Lines
0,n
TB_ETOUR
Routes - Headers
0,n
TB_INTER
Third parties
1,1
TB_IAXI
AXIODIS interface
1,1
1,1
1
0,n
GEO
Geo. areas
NUMCOM
TYP
1,1
TB_IAXI2
AXIODIS interface
0,n
TB_ETOUR
Routes - Headers
0,n
TB_LTOUR
Routes - Lines
1,1
1,1
DEPOT
OPERAT
DECOUPE
DEP
0,n
Depots
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 130

131. Interfaces STOCK  BILLING: Technical data

Interfaces STOCK BILLING: Technical data
1,1
TB_FAMFAC
STOCK BILLING
Article families
TB_FAM
Article families
0,n
1,1
PRO
0,n
1,n
Order originators
0,n
1,1
1,1
TB_SFAFAC
STOCK BILLING
Ss-article families
0,n
1,1
0,n
1,n
TB_SFAM
Sub-families
and segments
PRO
Order originators
SFA_CODENT
SFA_CSFAM
SFA_CFAM
SFA_CODDOR
SFA_TYPENR
0,1
1,1
1,n
TB_ARTFAC
STOCK BILLING
Articles
1
TB_ART
Articles
0,n
1,1
DEP
Depots
0,n
ART_CODENT
ART_CPROIN
ART_CODDOR
ART_TYPENR
1
Article without PV-LV
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 131

132. Interfaces STOCK  BILLING: Stock and movements (1/2)

Interfaces STOCK BILLING: Stock and movements (1/2)
1,1
TB_STKFAC
STOCK BILLING
Stock
1,n
1
0,n
TB_ENTR
warehouse
0,n
TB_ART
Articles
0,n
TB_ENTR
warehouse
0,n
TB_ART
Articles
0,n
TB_LCDE
D.O.s - Lines
STK_CODENT
STK_CODDOR
STK_CPROIN
STK_TYPENR
STK_DATSTK
1,1
1,n
TB_HEADMVT
STOCK BILLING
Movements: Headers
1
0,1
1,1
0,n
1,n
PRO
Order originators
MVE_CODEN
MVE_NUMMVT
1,1
TB_LGNMVT
STOCK BILLING
Movements: Lines
1,1
TB_ENTR
warehouse
0,n
MVL_CODENT
MVL_NUMMVT
MVL_CODUTE
1
Article without PV-LV
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 132

133. Interfaces STOCK  BILLING: Stock and movements (2/2)

Interfaces STOCK BILLING: Stock and movements (2/2)
BLG_MVTRE
STOCK BILLING
Reception movements
MR_DATMVT
BLG_MVTIN
STOCK BILLING
Inventory movements
MI_DATINV
MI_USSCC
BLG_MVTEX
STOCK BILLING
Shipment movements
ME_NUMORL
ME_CTOURN
ME_NSEQBL
BLG_MVTRA
STOCK BILLING
Transport mvts
MT_CTOURN
MT_NOORDRE
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 133

134. Miscellaneous System

TB_ANOMA
Faults
TB_SESSION
Connection time
AN_MODULE
AN_CODEMP
AN_BATCH
SE_NUMSES
TB_VERSION
Version follow-up
of patches
TB_DBG
Debug traces
VE_ID
DBGDAT
DBGNUM
...
TB_EXP13
Working table for
data history
E13ROWID
TRA_COMTABS
Comments of
GOLD Tables
TCTTABLE
LANGUAGE
1,n
LANGUES
Application languages
LANCODE
GOLDRPT
Process launched
RPTSTASE
RPTDATE
ALARMS
Interface messages L3
ALADATE
1,1
TB_GESCONF
GESCONF paths
GC_USER
GC_PATH
GC_XML
TRA_COMCOLS
Comments of
GOLD Tables
TCCTABLE
TCCCOLUMN
LANGUAGE
TRA_GEN
Printing models
GENETA
TG_ETAT
TG_LANG
TG_NUMLIG
© Copyright Symphony EYC. The contents of this document are confidential and not for reproduction without permission - Page 134