| cts | Conditions tarifaires spéciales |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | achvte | Indicateur Achat ou Vente (A/V) | CHAR | 1 |
| 2 | typcot | Type de condition tarifaire | CHAR | 3 |
| 3 | typqui | Type de QUI | CHAR | 1 |
| 4 | clequi | Cle du QUI | CHAR | 16 |
| 5 | typqoi | Type de QUOI | CHAR | 1 |
| 6 | cleqoi | Cle du QUOI | CHAR | 16 |
| 7 | numcot | Numero de condition tarifaire | LONG | - |
| 8 | typrem | Type de remise | CHAR | 1 |
| 9 | taurem1 | 1er taux de remise | DBLE | - |
| 10 | taurem2 | 2eme taux de remise | DBLE | - |
| 11 | taurem3 | 3eme taux de remise | DBLE | - |
| 12 | prxnet | Prix net | DBLE | - |
| 13 | datapp | Date de début d'application | DATE | AAAAMMJJ |
| 14 | datval | Date de validation de l'évenement | DATE | AAAAMMJJ |
| 15 | qtemin | Quantite mini de commande | DBLE | - |
| 16 | camini | CA mini pour l appli. de la condition | DBLE | - |
| 17 | datmod | Date de la dernière mise à jour | DATE | AAAAMMJJ |
| 18 | utimod | Agent ayant effectué la dernière modif. | CHAR | 8 |
| 19 | ristou | Valeur (unitaire) d'une ristourne | DBLE | - |
| 20 | qtergt | Quantité de gratuit | DBLE | - |
| 21 | numcts | Numéro de condition | LONG | - |
| 22 | numlig | Numéro de ligne | LONG | - |
| 23 | codcre | Catégorie de remise | CHAR | 6 |
| 24 | codstat | Code statistique | CHAR | 12 |
| 25 | typseuil | Type de seuil (N/Q/V) | CHAR | 1 |
| 26 | edifac | A editer sur la facture | CHAR | 1 |
| 27 | typval | Valeur de la remise | CHAR | 1 |
| 28 | sigdep | Sigle dépôt | CHAR | 12 |
| 29 | codsoc | Code Société | LONG | - |
| 30 | tqui | Type de QUI | CHAR | 3 |
| 31 | tqoi | Type de QUOI | CHAR | 3 |
| 32 | coddev | Code devise | CHAR | 3 |
| 33 | coduni | Unité de mesure | CHAR | 3 |
| 34 | etbcod | Code établissement | CHAR | 3 |
| 35 | etsstatut | Statut établissement | CHAR | 1 |
| 36 | mtacquis | Montant acquise | DBLE | - |
| 37 | qtacquis | Quantité acquise | DBLE | - |
| 38 | indact | Indicateur Actif / Inactif | CHAR | 1 |
| 39 | datcre | Date de création | DATE | AAAAMMJJ |
| 40 | indris | Indicateur ristournable | CHAR | 1 |
| 41 | codpro_grt | Code produit | CHAR | 16 |
| 42 | numelabo | Numéro d'élaboration de tarif | LONG | - |
| 43 | val01 | Valeur 01 | DBLE | - |
| 44 | heurdeb | Heure de début | DBLE | - |
| 45 | heurfin | Heure de fin | DBLE | - |
| 46 | valzn1 | Valeur zone param. 1 | CHAR | 40 |
| 47 | valzn2 | Valeur zone param. 2 | CHAR | 40 |
| 48 | valzn3 | Valeur zone param. 3 | CHAR | 40 |
| 49 | valzn4 | Valeur zone param. 4 | CHAR | 40 |
| 50 | valzn5 | Valeur zone param. 5 | CHAR | 40 |
| 51 | valzn6 | Valeur zone param. 6 | CHAR | 40 |
| 52 | valzn7 | Valeur zone param. 7 | CHAR | 40 |
| 53 | valzn8 | Valeur zone param. 8 | CHAR | 40 |
| 54 | valzn9 | Valeur zone param. 9 | CHAR | 40 |
| 55 | valzn10 | Valeur zone param. 10 | CHAR | 40 |
| 56 | codcrit | Code critère | CHAR | 6 |
| 57 | valcrit | valeur du critère | CHAR | 6 |
| 58 | codttu | Code de la table utilisateur | LONG | - |
| 59 | modges | Mode de gestion | LONG | - |
| 60 | val02 | Valeur 02 | DBLE | - |
| 61 | val03 | Valeur 03 | DBLE | - |
| 62 | val04 | Valeur 04 | DBLE | - |
| 63 | val05 | Valeur 05 | DBLE | - |
| 64 | val06 | Valeur 06 | DBLE | - |
| 65 | val07 | Valeur 07 | DBLE | - |
| 66 | val08 | Valeur 08 | DBLE | - |
| 67 | val09 | Valeur 09 | DBLE | - |
| 68 | val10 | Valeur 10 | DBLE | - |
| 69 | numcnp | Numéro de poste de contrat | LONG | - |
| 70 | codbar | Code barème | CHAR | 3 |
| 71 | indpromo | Type promotion | LONG | - |
| 72 | filtre_pour | Filtre pour | CHAR | 500 |
| 73 | filtre_sauf | Filtre sauf | CHAR | 500 |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | cts_idx1 | Clé N° 1 | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typcot (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numcot (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | cts_idx2 | Clé N° 2 | D | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| numcts (ASC) | ||||
| numlig (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | cts_idx3 | Clé N° 3 : utilisée dans gvmc_1_specif | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typcot (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numcot (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | cts_idx4 | cle 4 cts | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typcot (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numcot (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 5 | cts_idx5 | Clé 5 RMCR_CTS | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typcot (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| sigdep (ASC) | ||||
| datapp (ASC) | ||||
| datval (ASC) | ||||
| codcre (ASC) | ||||
| typrem (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 6 | cts_idx6 | Cle 6 : pour saisie des cotations (SCOT) | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typcot (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numcot (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 7 | cts_idx7 | clé n°7 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typcot (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| sigdep (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numcot (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 8 | cts_idx8 | POUR MAJ QUI-QUOI | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tqoi (ASC) | ||||
| typcot (ASC) | ||||
| achvte (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 9 | cts_idx9 | POUR MAJ QUI-QUOI | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| tqui (ASC) | ||||
| typcot (ASC) | ||||
| achvte (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 10 | cts_idx10 | Clef N°10 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| typcot (ASC) | ||||
| codcre (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 11 | cts_idx11 | Recherche multi-critères | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typcot (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| numcot (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 12 | cts_idx12 | Clé de suppression des Qui | D | N |
| Clé de suppression des Qui | ||||
Clause Order By |
||||
| codsoc (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 13 | cts_idx13 | Clé de suppression des Qoi | D | N |
| Cle de suppression des Qoi | ||||
Clause Order By |
||||
| codsoc (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 14 | cts_idx14 | Clé physique pour LP/LS/LF par clé 4 | L | N |
| Clé physique pour LP/LS/LF par clé 4 (optimisation sur oracle) | ||||
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| typcot (ASC) | ||||
| tqui (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| cleqoi (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 15 | cts_idx15 | cleqoi/clequi/tqoi/tqui/datapp/datval/co | L | N |
| cleqoi/clequi/tqoi/tqui/datapp/datval/codsoc | ||||
Clause Order By |
||||
| cleqoi (ASC) | ||||
| clequi (ASC) | ||||
| tqoi (ASC) | ||||
| tqui (ASC) | ||||
| datapp (ASC) | ||||
| datval (ASC) | ||||
| codsoc (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 16 | cts_idx16 | codsoc/achvte/numcot | L | N |
| codsoc/achvte/numcot | ||||
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| numcot (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 17 | cts_idx17 | codsoc/achvte/tqui/datapp/datval | L | N |
| codsoc/achvte/tqui/datapp/datval | ||||
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| tqui (ASC) | ||||
| datapp (ASC) | ||||
| datval (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 18 | cts_idx18 | codsoc,achvte,numelabo,codstat | L | N |
| codsoc,achvte,numelabo,codstat | ||||
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| numelabo (ASC) | ||||
| codstat (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 19 | cts_idxvar1 | Index pour accès sur codcrit | L | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| achvte (ASC) | ||||
| codcrit (ASC) | ||||