| fsk | Stocks par valorisation FIFO |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | codsoc | Code Société | LONG | - |
| 2 | sigdep | Sigle dépôt | CHAR | 12 |
| 3 | codpro | Code produit | CHAR | 16 |
| 4 | numlot | Numéro de lot | CHAR | 7 |
| 5 | nummsk | Numéro d'un mouvement de stocks | LONG | - |
| 6 | numfsk | Numéro stock FIFO | LONG | - |
| 7 | datmvt | Date du mouvement de stock | DATE | AAAAMMJJ |
| 8 | heumvt | Heure du mouvement | DBLE | - |
| 9 | codosk | Code opération stocks | CHAR | 6 |
| 10 | typosk | Type d'opération sur les stocks | CHAR | 3 |
| 11 | codemp | Code emplacement | CHAR | 10 |
| 12 | qtefsk | Qte stock FIFO | DBLE | - |
| 13 | qtemvt | Qte mouvementee (Formule regle) | DBLE | - |
| 14 | qtejus | Qte justifiée | DBLE | - |
| 15 | achvte | Indicateur Achat ou Vente (A/V) | CHAR | 1 |
| 16 | typeve | Type d'événement | CHAR | 3 |
| 17 | numeve | Numéro d'événement | LONG | - |
| 18 | numpos | Numéro de poste | LONG | - |
| 19 | numlig | Numéro de ligne | LONG | - |
| 20 | prxfsk | Prix valorisation FIFO | DBLE | - |
| 21 | prxvte | Prix unitaire de vente | DBLE | - |
| 22 | codana1 | Code imputation analytique | CHAR | 6 |
| 23 | codana2 | Code imputation analytique | CHAR | 6 |
| 24 | codana3 | Code imputation analytique | CHAR | 6 |
| 25 | indjus | Indicateur FSK | CHAR | 1 |
| 26 | gefifo | Indicateur géré FIFO | CHAR | 1 |
| 27 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 28 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
| 29 | typeaf | Type d'affaire | CHAR | 1 |
| 30 | typmvt | Type de mouvement de stock (E/S) | CHAR | 1 |
| 31 | typfsk | Type de valorisation de stock FIFO/LIFO | CHAR | 1 |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | fsk_idx1 | Clé N°1 | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typfsk (ASC) | ||||
| sigdep (ASC) | ||||
| codpro (ASC) | ||||
| numlot (ASC) | ||||
| nummsk (ASC) | ||||
| numfsk (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | fsk_idx2 | Clé 2 | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typfsk (ASC) | ||||
| sigdep (ASC) | ||||
| codpro (ASC) | ||||
| numlot (ASC) | ||||
| typosk (ASC) | ||||
| indjus (ASC) | ||||
| gefifo (ASC) | ||||
| datmvt (ASC) | ||||
| heumvt (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | fsk_idx3 | Clé 3 : LIFO | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typfsk (ASC) | ||||
| sigdep (ASC) | ||||
| codpro (ASC) | ||||
| numlot (ASC) | ||||
| typosk (ASC) | ||||
| indjus (ASC) | ||||
| gefifo (ASC) | ||||
| datmvt (DESC) | ||||
| heumvt (DESC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | fsk_idx4 | Clé pour Reprise | P | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| codpro (ASC) | ||||
| typfsk (ASC) | ||||
| sigdep (ASC) | ||||
| numlot (ASC) | ||||
| nummsk (ASC) | ||||
| numfsk (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 5 | fsk_idx5 | Lecture Mouvts suivant typmvt/FIFO | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typfsk (ASC) | ||||
| sigdep (ASC) | ||||
| codpro (ASC) | ||||
| numlot (ASC) | ||||
| typmvt (ASC) | ||||
| indjus (ASC) | ||||
| gefifo (ASC) | ||||
| datmvt (ASC) | ||||
| heumvt (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 6 | fsk_idx6 | Lecture Mouvts suivant typmvt/LIFO | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typfsk (ASC) | ||||
| sigdep (ASC) | ||||
| codpro (ASC) | ||||
| numlot (ASC) | ||||
| typmvt (ASC) | ||||
| indjus (ASC) | ||||
| gefifo (ASC) | ||||
| datmvt (DESC) | ||||
| heumvt (DESC) | ||||